delete from cq_itemtype where
id = 199020 or
id = 199000;
delete from cq_goods where
itemtype = 199020 or
itemtype = 199000;
insert into cq_goods
(ownerid,itemtype)
values
(1207,199020),
(1207, 199000);
INSERT INTO `cq_itemtype` (`id`,`name`,`req_profession`,`level`,`req_level`,`req_sex`,`req_force`,`req_dex`,`req_health`,`req_soul`,`monopoly`,`weight`,`price`,`id_action`,`attack_max`,`attack_min`,`defense`,`magic_atk_min`,`dodge`,`life`,`mana`,`amount`,`amount_limit`,`ident`,`gem1`,`gem2`,`magic1`,`magic2`,`magic3`,`magic_atk_max`,`magic_def`,`atk_range`,`atk_speed`,`hitrate`,`monster_type`,`target`,`able_mask`,`exp_type`,`emoney`,`official1`,`official2`,`official3`,`official4`,`official5`,`official6`,`official7`,`official8`,`official9`,`official10`,`official11`,`soul_value`,`chance`) VALUES ('199020','GoldenWingRobe','0','0','0','0','0','0','0','0','28','0','1588000000','0','0','0','0','0','0','0','0','1','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1688','0','0','0','0','0','0','0','0','0','0','0','0','0','0')
INSERT INTO `cq_itemtype` (`id`,`name`,`req_profession`,`level`,`req_level`,`req_sex`,`req_force`,`req_dex`,`req_health`,`req_soul`,`monopoly`,`weight`,`price`,`id_action`,`attack_max`,`attack_min`,`defense`,`magic_atk_min`,`dodge`,`life`,`mana`,`amount`,`amount_limit`,`ident`,`gem1`,`gem2`,`magic1`,`magic2`,`magic3`,`magic_atk_max`,`magic_def`,`atk_range`,`atk_speed`,`hitrate`,`monster_type`,`target`,`able_mask`,`exp_type`,`emoney`,`official1`,`official2`,`official3`,`official4`,`official5`,`official6`,`official7`,`official8`,`official9`,`official10`,`official11`,`soul_value`,`chance`) VALUES ('199000','GoldenWingCoat','0','0','0','0','0','0','0','0','28','0','1588000000','0','0','0','0','0','0','0','0','1','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1688','0','0','0','0','0','0','0','0','0','0','0','0','0','0')
your delete script for itemtype was pointless in most ways.
your delete script for cq_goods would only work for your server in general since you deleted from ID which has nothing to do with the actual Item
here is replacements for them
Code:
delete from cq_itemtype where
id = 190720 or
id = 190740;
delete from cq_goods where
itemtype = 190720 or
itemtype = 190740;
insert into cq_goods
(ownerid,itemtype)
values
(1207,190720),
(1207,190740);
mage warrior , u r posting things in the wrong forum , this is the 4th time u do same
actually he is in the correct forum since this is related to EO Pserver devlopement. He is releasing new files to the community. This is not an edit so it would not go into the other forum.
actually he is in the correct forum since this is related to EO Pserver devlopement. He is releasing new files to the community. This is not an edit so it would not go into the other forum.
sry , my bad , i didnt even look a the tunic he released
Good job mage warrior , keep it up dude
and deadpool , move the other ones to their correct forum
u know what im talkin about ,
the edits