• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[Request] Gesior Shop Transactions History

lucas123

New Member
Joined
Jun 6, 2010
Messages
85
Reaction score
4
i'm need help =s
in the field "Offer Name" I need to appear the name of the item you are buying the player.

Here appears only 0.
Thanks

Sorry for my bad english.


PT:
Eu preciso de ajuda,
no campo "Offer Name" eu quero que apareça o nome do item que o jogador está comprando, pois aqui só aparece 0.. alguem pode ajudar?
obrigado =D
 
SQL:
ALTER TABLE `z_shop_history_item` CHANGE `offer_id` `offer_id` VARCHAR( 255 ) NOT NULL;
UPDATE `z_shop_history_item`, `z_shop_offer` SET `z_shop_history_item`.`offer_id` = `z_shop_offer`.`offer_name` WHERE `z_shop_history_item`.`offer_id` = `z_shop_offer`.`id`;
 
Back
Top