[Release] Weekend Event/Levelup Potion

Quote:

Originally Posted by Eurion This should work, make sure you back up the files though, Just in case.  Spoiler Code: DELETE FROM cq_itemtype WHERE id >= 742000 AND id <= 742001; DELETE FROM cq_itemtype WHERE id ='1037200'; DELETE FROM cq_itemtype WHERE id ='1037210'; DELETE FROM cq_itemtype WHERE id ='1037220'; DELETE FROM cq_action WHERE id >= 15000000 AND id <= 150000009; DELETE FROM cq_action WHERE id >= 650000008 AND id <= 650000032; DELETE FROM cq_action WHERE id >= 660000000 AND id <= 660000003; DELETE FROM cq_action WHERE id >= 670000000 AND id <= 670000003; DELETE FROM cq_action WHERE id >= 680000000 AND id <= 680000027; DELETE FROM cq_map WHERE id='5388'; DELETE FROM cq_monstertype WHERE id='7025'; DELETE FROM cq_dropitemrule WHERE id='395'; DELETE FROM cq_generator WHERE id >= 68000000 AND id <= 68000024; DELETE FROM cq_npc WHERE id >= 123400 AND id <= 123402; DELETE FROM cq_task WHERE id >= 660000000 AND id <= 660000003; DELETE FROM cq_task WHERE id >= 680000000 AND id <= 670000025; DELETE FROM cq_task WHERE id >= 680000000 AND id <= 680000025; It will only delete database sided.

Quote:

Originally Posted by CroW_ZeRo i have a question too..i already make a checking item action..this my query.. Code: (680000009, 680000010, 680000038, 0507, 000000, '1027200 1027200 100'), (680000010, 680000011, 680000038, 0507, 000000, '1027201 1027201 100'), (680000011, 680000012, 680000038, 0507, 000000, '1027202 1027202 100'), (680000012, 680000013, 000000000, 0506, 000000, '1027200 1027200 100'), (680000013, 680000014, 000000000, 0506, 000000, '1027201 1027201 100'), (680000014, 680000015, 000000000, 0506, 000000, '1027202 1027202 100'),

Quote:

Originally Posted by CroW_ZeRo lol so the stackable item cannot be check ? is it a way to check an exist stakable item? *.*

Quote:

Originally Posted by zspider is it work for u guys ?? coz it'snot my problem that it'snot take 100 from 1 it's take 100 from every item and don't give u anything it's just take them and tell u u havn't the items i think the problem here the problem in id_next and id_nextfail but what how to fix it?? Code: 680000000', '680000001', '0000', '0101', '0', 'Hi~%user_name,~Im~your~event~items~exchanger.~You~can~choose~your~reward~below.'); INSERT INTO `cq_action` VALUES ('680000001', '680000002', '0000', '0101', '0', 'You~need~100~event~items~each~to~claim~your~reward.'); INSERT INTO `cq_action` VALUES ('680000002', '680000003', '0000', '0102', '0', 'Exchange~to~200~UniXO. 680000009'); INSERT INTO `cq_action` VALUES ('680000003', '680000004', '0000', '0102', '0', 'Exchange~to~500~Special~expball. 680000017'); INSERT INTO `cq_action` VALUES ('680000004', '680000008', '0000', '0102', '0', 'Exchange~to~3,000,000~Eps. 680000023'); INSERT INTO `cq_action` VALUES ('680000008', '4000026', '0000', '0102', '0', 'No~Thanks!. 0'); INSERT INTO `cq_action` VALUES ('680000009', '680000010', '680000016', '0502', '1021204', '100'); INSERT INTO `cq_action` VALUES ('680000010', '680000011', '680000016', '0502', '1021203', '100'); INSERT INTO `cq_action` VALUES ('680000011', '680000012', '680000016', '0502', '1021205', '100'); INSERT INTO `cq_action` VALUES ('680000012', '680000014', '680000013', '0508', '0', '1 0 50'); INSERT INTO `cq_action` VALUES ('680000013', '0000', '0000', '0126', '0', 'You~dont~have~enough~room~with~you!'); INSERT INTO `cq_action` VALUES ('680000014', '680000015', '0000', '0501', '813002', '200 200'); INSERT INTO `cq_action` VALUES ('680000015', '0000', '0000', '0126', '0', 'Congratulations!~You~received~200~stackable~UniXO'); INSERT INTO `cq_action` VALUES ('680000016', '0000', '0000', '0126', '0', 'Im~Sorry,~u~dont~have~enough~event~items');