[HELP] Right click item

haizamlee · 05/22/2010, 06:32

last night i took out several items from my shopping mall using shopeditor. then i changed the price of the items using this code..

Code:

delete from cq_itemtype where id >= 724043 and id <= 724043;

insert into cq_itemtype (id,name,emoney) 
values
('724043', '10SpecialExpBall', '100000')

then something wrong happened.. i cannot right-click on that item after i created it..

please..

KikkenF · 05/22/2010, 12:14

If the item already existed, and you wanted to change price only,

Code:

 UPDATE cq_itemtype SET emoney=PRICE WHERE name=ITEMNAME;

or by ID

Code:

 UPDATE cq_itemtype SET emoney=PRICE WHERE id=ITEMID;

Itemtype.dat must be changed too.