[155fullsetgears] in candy db have problem with paladin please help me

[lord.ahmed]

i want anyone help me in this problem i remmper its have a query fix but i cant get it thanks for you i you will help me

[alxandr2]

+60 [You Must Update you item id action in cq_itemtype]
Code:

delete from cq_action where id >= 19000500 and id <= 19000516;
delete from cq_action where id >= 19000520 and id <= 19000536;

INSERT INTO `cq_action` VALUES ('19000500', '19000501', '19000504', '0508', '0', '7 0 50');
INSERT INTO `cq_action` VALUES ('19000501', '19000510', '19000502', '1001', '0', 'profession == 10');
INSERT INTO `cq_action` VALUES ('19000502', '19000520', '19000503', '1001', '0', 'profession == 20');
INSERT INTO `cq_action` VALUES ('19000503', '19000530', '0000', '1001', '0', 'profession == 30');
INSERT INTO `cq_action` VALUES ('19000504', '0000', '0000', '0126', '0', 'Please check the backpack there is enough room for 7');
INSERT INTO `cq_action` VALUES ('19000505', '0000', '0000', '0126', '0', '¹Conguratulation~You~have~+60~Item');
INSERT INTO `cq_action` VALUES ('19000506', '0000', '0000', '0126', '0', '¹Conguratulation~You~have~+60~Item');
INSERT INTO `cq_action` VALUES ('19000507', '0000', '0000', '0126', '0', '¹Conguratulation~You~have~+60~Item');
INSERT INTO `cq_action` VALUES ('19000510', '19000511', '0000', '0502', '9999991', '');
INSERT INTO `cq_action` VALUES ('19000511', '19000512', '0000', '0501', '440243', '0 0 4 18 18 0 0 60 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19000512', '19000513', '0000', '0501', '135113', '0 0 4 18 18 0 0 60 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19000513', '19000514', '0000', '0501', '115113', '0 0 4 18 18 0 0 60 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19000514', '19000515', '0000', '0501', '125113', '0 0 4 18 18 0 0 60 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19000515', '19000516', '0000', '0501', '145113', '0 0 4 18 18 0 0 60 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19000516', '19000505', '0000', '0501', '165093', '0 0 4 18 18 0 0 60 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19000520', '19000521', '0000', '0502', '9999991', '');
INSERT INTO `cq_action` VALUES ('19000521', '19000522', '0000', '0501', '420243', '0 0 4 18 18 0 0 60 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19000522', '19000523', '0000', '0501', '131113', '0 0 4 18 18 0 0 60 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19000523', '19000524', '0000', '0501', '111113', '0 0 4 18 18 0 0 60 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19000524', '19000525', '0000', '0501', '121113', '0 0 4 18 18 0 0 60 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19000525', '19000526', '0000', '0501', '141113', '0 0 4 18 18 0 0 60 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19000526', '19000527', '0000', '0501', '161093', '0 0 4 18 18 0 0 60 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19000527', '19000506', '0000', '0501', '410243', '0 0 4 18 18 0 0 60 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19000530', '19000531', '0000', '0502', '9999991', '');
INSERT INTO `cq_action` VALUES ('19000531', '19000532', '0000', '0501', '163093', '0 0 4 18 18 0 0 60 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19000532', '19000533', '0000', '0501', '143113', '0 0 4 18 18 0 0 60 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19000533', '19000534', '0000', '0501', '133113', '0 0 4 18 18 0 0 60 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19000534', '19000535', '0000', '0501', '123113', '0 0 4 18 18 0 0 60 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19000535', '19000536', '0000', '0501', '113113', '0 0 4 18 18 0 0 60 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19000536', '19000507', '0000', '0501', '490243', '0 0 4 18 18 0 0 60 0 1024 0 0');

+155 [You Must Update you item id action in cq_itemtype]
Code:

delete from cq_action where id >= 19001000 and id <= 19001016;
delete from cq_action where id >= 19001020 and id <= 19001036;

INSERT INTO `cq_action` VALUES ('19001000', '19001001', '19001004', '0508', '0', '7 0 50');
INSERT INTO `cq_action` VALUES ('19001001', '19001010', '19001002', '1001', '0', 'profession == 10');
INSERT INTO `cq_action` VALUES ('19001002', '19001020', '19001003', '1001', '0', 'profession == 20');
INSERT INTO `cq_action` VALUES ('19001003', '19001030', '0000', '1001', '0', 'profession == 30');
INSERT INTO `cq_action` VALUES ('19001004', '0000', '0000', '0126', '0', 'Please check the backpack there is enough room for 7');
INSERT INTO `cq_action` VALUES ('19001005', '0000', '0000', '0126', '0', '¹Conguratulation~You~have~+155~Item');
INSERT INTO `cq_action` VALUES ('19001006', '0000', '0000', '0126', '0', '¹Conguratulation~You~have~+155~Item');
INSERT INTO `cq_action` VALUES ('19001007', '0000', '0000', '0126', '0', '¹Conguratulation~You~have~+155~Item');
INSERT INTO `cq_action` VALUES ('19001010', '19001011', '0000', '0502', '9999992', '');
INSERT INTO `cq_action` VALUES ('19001011', '19001012', '0000', '0501', '440243', '0 0 4 18 18 0 0 155 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19001012', '19001013', '0000', '0501', '135113', '0 0 4 18 18 0 0 155 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19001013', '19001014', '0000', '0501', '115113', '0 0 4 18 18 0 0 155 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19001014', '19001015', '0000', '0501', '125113', '0 0 4 18 18 0 0 155 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19001015', '19001016', '0000', '0501', '145113', '0 0 4 18 18 0 0 155 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19001016', '19001005', '0000', '0501', '165093', '0 0 4 18 18 0 0 155 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19001020', '19001021', '0000', '0502', '9999992', '');
INSERT INTO `cq_action` VALUES ('19001021', '19001022', '0000', '0501', '420243', '0 0 4 18 18 0 0 155 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19001022', '19001023', '0000', '0501', '131113', '0 0 4 18 18 0 0 155 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19001023', '19001024', '0000', '0501', '111113', '0 0 4 18 18 0 0 155 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19001024', '19001025', '0000', '0501', '121113', '0 0 4 18 18 0 0 155 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19001025', '19001026', '0000', '0501', '141113', '0 0 4 18 18 0 0 155 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19001026', '19001027', '0000', '0501', '161093', '0 0 4 18 18 0 0 155 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19001027', '19001006', '0000', '0501', '410243', '0 0 4 18 18 0 0 155 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19001030', '19001031', '0000', '0502', '9999992', '');
INSERT INTO `cq_action` VALUES ('19001031', '19001032', '0000', '0501', '163093', '0 0 4 18 18 0 0 155 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19001032', '19001033', '0000', '0501', '143113', '0 0 4 18 18 0 0 155 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19001033', '19001034', '0000', '0501', '133113', '0 0 4 18 18 0 0 155 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19001034', '19001035', '0000', '0501', '123113', '0 0 4 18 18 0 0 155 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19001035', '19001036', '0000', '0501', '113113', '0 0 4 18 18 0 0 155 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('19001036', '19001007', '0000', '0501', '490243', '0 0 4 18 18 0 0 155 0 1024 0 0');

Update in cq_itemtype

Code:

UPDATE cq_itemtype SET id_action = 19000500 where id >= 9999991;
UPDATE cq_itemtype SET id_action = 19001000 where id >= 9999992;

good luck