Offline Shop (Premium Private Shop)

[[007]DawisHU 352]

Hi guyz and @ Rakancito !

I have some system from you, Rakancito.

But first system is total bugged from you, i start developing and rewritting the whole bugged code.

Shop is can't reupdate itself when server closed/restarted, problem start in char.cpp -> 
void CHARACTER::LoadPremiumPrivateShop(int iItemCount, TPlayerItem* pItems) function.

And in db side, the example ( your files ) totally useless for me.
Example:
your code :
 

Spoiler

#ifdef ENABLE_PREMIUM_PRIVATE_SHOP

if(pi->bIsPrivateShop)

{

snprintf(szQuery, sizeof(szQuery),

"INSERT INTO item%s (id, owner_id, window, pos, vnum, count, socket0, socket1, socket2) "

"VALUES(%u, %u, '%s', %d, %u, %u, %u, %u, %u)",

GetTablePostfix(),

GainItemID(),

pi->player_id,

pi->ip[0] == 0 ? "PRIVATE_SHOP" : "PRIVATE_SHOP",

iPos,

pItemAward->dwVnum, pItemAward->dwCount, pItemAward->dwSocket0, pItemAward->dwSocket1, dwSocket2);

}
........

My code : 

 

Spoiler

snprintf(szQuery, sizeof(szQuery), 
                                "INSERT INTO item%s (id, owner_id, window, pos, vnum, count, socket0, socket1, socket2) "
                                "VALUES(%u, %u, '%s', %d, %u, %u, %u, %u, %u)",
                                GetTablePostfix(),
                                GainItemID(),
#ifdef ENABLE_PREMIUM_PRIVATE_SHOP
                            pi->ip[0] == 2 ? pi->player_id : 
#endif
                            pi->account_id,
#ifdef ENABLE_PREMIUM_PRIVATE_SHOP
                                //pi->bIsPrivateShop == true ? "PRIVATE_SHOP" : pi->ip[0] == 0 ? "SAFEBOX" : "MALL",
                                pi->ip[0] == 2 ? "PRIVATE_SHOP" : pi->ip[0] == 0 ? "SAFEBOX" : "MALL",
#else
                                pi->ip[0] == 0 ? "SAFEBOX" : "MALL",
#endif
                                iPos,
                                pItemAward->dwVnum, pItemAward->dwCount, pItemAward->dwSocket0, pItemAward->dwSocket1, dwSocket2);
                    }

No need useless + lines just work smart

if i fixed the items load, and other things in shop, and need this, i will paste it to here.
Excuse me for bad eng. 
Best regard !
 

 

#Update

Finally fixed  

Edited January 19, 2023 by Metin2 Dev
Core X - External 2 Internal

[liukefu 1]

Where to get image files？

[X E N O N 13]

Working and tested?

[master1988 7]

On 2/24/2021 at 10:49 PM, Sebypunct said:

https://metin2.download/picture/5y5Wpxv5LQhHpQ1LjuEd783H99SH446R/.png

 

Thanks works good

hello , please you version

[master1988 7]

On 2/24/2021 at 10:49 PM, Sebypunct said:

https://metin2.download/picture/5y5Wpxv5LQhHpQ1LjuEd783H99SH446R/.png

 

Thanks works good

client files modif pleas upload

[stancusorin97 0]

work?

[Aioria 11]

On 12/19/2022 at 11:13 AM, [007]DawisHU said:

Hi guyz and @ Rakancito !

I have some system from you, Rakancito.

But first system is total bugged from you, i start developing and rewritting the whole bugged code.

Shop is can't reupdate itself when server closed/restarted, problem start in char.cpp -> 
void CHARACTER::LoadPremiumPrivateShop(int iItemCount, TPlayerItem* pItems) function.

And in db side, the example ( your files ) totally useless for me.
Example:
your code :
 

  Reveal hidden contents

#ifdef ENABLE_PREMIUM_PRIVATE_SHOP

if(pi->bIsPrivateShop)

{

snprintf(szQuery, sizeof(szQuery),

"INSERT INTO item%s (id, owner_id, window, pos, vnum, count, socket0, socket1, socket2) "

"VALUES(%u, %u, '%s', %d, %u, %u, %u, %u, %u)",

GetTablePostfix(),

GainItemID(),

pi->player_id,

pi->ip[0] == 0 ? "PRIVATE_SHOP" : "PRIVATE_SHOP",

iPos,

pItemAward->dwVnum, pItemAward->dwCount, pItemAward->dwSocket0, pItemAward->dwSocket1, dwSocket2);

}
........

My code : 

 

  Hide contents

snprintf(szQuery, sizeof(szQuery), 
                                "INSERT INTO item%s (id, owner_id, window, pos, vnum, count, socket0, socket1, socket2) "
                                "VALUES(%u, %u, '%s', %d, %u, %u, %u, %u, %u)",
                                GetTablePostfix(),
                                GainItemID(),
#ifdef ENABLE_PREMIUM_PRIVATE_SHOP
                            pi->ip[0] == 2 ? pi->player_id : 
#endif
                            pi->account_id,
#ifdef ENABLE_PREMIUM_PRIVATE_SHOP
                                //pi->bIsPrivateShop == true ? "PRIVATE_SHOP" : pi->ip[0] == 0 ? "SAFEBOX" : "MALL",
                                pi->ip[0] == 2 ? "PRIVATE_SHOP" : pi->ip[0] == 0 ? "SAFEBOX" : "MALL",
#else
                                pi->ip[0] == 0 ? "SAFEBOX" : "MALL",
#endif
                                iPos,
                                pItemAward->dwVnum, pItemAward->dwCount, pItemAward->dwSocket0, pItemAward->dwSocket1, dwSocket2);
                    }

No need useless + lines just work smart

if i fixed the items load, and other things in shop, and need this, i will paste it to here.
Excuse me for bad eng. 
Best regard !
 

 

#Update

Finally fixed  

Hi! Any chance of upload your fix please?

[KolenMG 1125]

Unfortunately, After implementing it on tmp4, my client crashes after char select. Havent found a solution yet.  

 

[БlyatMAN 20]

On 12/1/2024 at 1:37 AM, KolenMG said:

Unfortunately, After implementing it on tmp4, my client crashes after char select. Havent found a solution yet.  

 

Suppose to work @ Ulthardid it on the @ TMP4files,but im not sure is the same version or other dev sistem

[ARiver 79]

On 12/11/2024 at 6:14 PM, БlyatMAN said:

Suppose to work @ Ulthardid it on the @ TMP4files,but im not sure is the same version or other dev sistem

I believe Ulthar used Great offline shop 

[БlyatMAN 20]

4 hours ago, ariver1514 said:

I believe Ulthar used Great offline shop 

Probably im not sure

[ricardo1813 5]

On 12/16/2024 at 4:18 PM, ariver1514 said:

I believe Ulthar used Great offline shop 

Ulthar version is Great Shop.

[kaminax102 0]

WOW