delete from cq_action where id >= 4007360 and id <= 4007367;
delete from cq_action where id >= 4007500 and id <= 4007597;
update cq_action set id_nextfail = 4007511 where id = 9508430;
INSERT INTO cq_action
(id, id_next, id_nextfail, type, data, param)
VALUES
(4007360, 0, 0, 122, 0, '4007520 4007530 4007540 4007550 4007560 4007570 4007580 4007590'),
(4007361, 4007362, 0, 101, 0, 'What do you want to do? Compose two pets into one?'),
(4007362, 4007363, 0, 101, 0, 'In case you do not know, the secondary one gets sacrificed.'),
(4007363, 4007364, 0, 101, 0, 'To put this simply, the primary pets gets stonger each time you compose it.'),
(4007364, 4007367, 0, 102, 0, 'I~want~to~Compose~my~Pet. 4007370'),
(4007365, 4007366, 0, 101, 0, ''),
(4007366, 4007367, 0, 102, 0, 'I~want~to~Compose~my~Pet. 4007370'),
(4007367, 4000001, 0, 102, 0, 'No~thanks. 0'),
(4007500, 4007501, 4007508, 1080, 20081, 'isexit'),
(4007501, 4007505, 4007502, 1081, 20081, 'phase >= 2'),
(4007502, 4007503, 4007503, 1081, 20081, 'phase == 1'),
(4007503, 4007504, 0, 1081, 20081, 'phase = 2'),
(4007504, 0, 0, 126, 0, 'You entered the code wrong 2 consecutive times. If you answer wrong 1 more time, YOU CANNOT COMPOSE for 15 minutes.'),
(4007505, 4007506, 0, 1080, 20081, 'delete'),
(4007506, 1000028, 4007507, 1080, 20080, 'isexit'),
(4007507, 1000028, 0, 1080, 20080, 'new'),
(4007508, 4007509, 0, 1080, 20081, 'new'),
(4007509, 4007510, 0, 1081, 20081, 'phase = 1'),
(4007510, 0, 0, 126, 0, 'You entered the code wrong. If you answer wrong 2 more times, YOU CANNOT COMPOSE for 15 minutes.'),
(4007511, 4007512, 4007360, 1080, 20080, 'isexit'),
(4007512, 4007513, 4007514, 1082, 20080, '900'),
(4007513, 4007360, 0, 1080, 20080, 'delete'),
(4007514, 4007515, 0, 130, 0, 'Wait the full 15 minutes to try again'),
(4007515, 4007516, 0, 130, 0, ''),
(4007516, 4007517, 0, 130, 0, 'Attention: You entered the Anti-Macro code wrong 3 times. You were punished. Now you must wait 15 minutes to compose again.'),
(4007517, 4007518, 0, 130, 0, ''),
(4007518, 4007519, 0, 130, 0, 'Anti-Macro System for Eudemons-online'),
(4007519, 0, 0, 131, 0, ''),
(4007520, 4007521, 0, 101, 0, 'Anti-Macro System!'),
(4007521, 4007522, 0, 101, 0, 'This was created to fight MACRO use.'),
(4007522, 4007523, 0, 101, 0, 'If you answer wrong 3 consecutive times YOU CANNOT COMPOSE for 15 minutes.'),
(4007523, 4000001, 0, 105, 0, '2 4007525 Type~the~Digit:~11'),
(4007524, 0, 0, 0, 0, ''),
(4007525, 4007526, 4007500, 2003, 0, '%accept0 == 11'),
(4007526, 4007527, 4007361, 1080, 20081, 'isexit'),
(4007527, 4007361, 0, 1080, 20081, 'delete'),
(4007528, 0, 0, 0, 0, ''),
(4007529, 0, 0, 0, 0, ''),
(4007530, 4007531, 0, 101, 0, 'Anti-Macro System!'),
(4007531, 4007532, 0, 101, 0, 'This was created to fight MACRO use.'),
(4007532, 4007533, 0, 101, 0, 'If you answer wrong 3 consecutive times YOU CANNOT COMPOSE for 15 minutes.'),
(4007533, 4000001, 0, 105, 0, '2 4007535 Type~the~Digit:~22'),
(4007534, 0, 0, 0, 0, ''),
(4007535, 4007526, 4007500, 2003, 0, '%accept0 == 22'),
(4007536, 0, 0, 0, 0, ''),
(4007540, 4007541, 0, 101, 0, 'Anti-Macro System!'),
(4007541, 4007542, 0, 101, 0, 'This was created to fight MACRO use.'),
(4007542, 4007543, 0, 101, 0, 'If you answer wrong 3 consecutive times YOU CANNOT COMPOSE for 15 minutes.'),
(4007543, 4000001, 0, 105, 0, '2 4007545 Type~the~Digit:~33'),
(4007544, 0, 0, 0, 0, ''),
(4007545, 4007526, 4007500, 2003, 0, '%accept0 == 33'),
(4007546, 0, 0, 0, 0, ''),
(4007550, 4007551, 0, 101, 0, 'Anti-Macro System!'),
(4007551, 4007552, 0, 101, 0, 'This was created to fight MACRO use.'),
(4007552, 4007553, 0, 101, 0, 'If you answer wrong 3 consecutive times YOU CANNOT COMPOSE for 15 minutes.'),
(4007553, 4000001, 0, 105, 0, '2 4007555 Type~the~Digit:~44'),
(4007554, 0, 0, 0, 0, ''),
(4007555, 4007526, 4007500, 2003, 0, '%accept0 == 44'),
(4007556, 0, 0, 0, 0, ''),
(4007560, 4007561, 0, 101, 0, 'Anti-Macro System!'),
(4007561, 4007562, 0, 101, 0, 'This was created to fight MACRO use.'),
(4007562, 4007563, 0, 101, 0, 'If you answer wrong 3 consecutive times YOU CANNOT COMPOSE for 15 minutes.'),
(4007563, 4000001, 0, 105, 0, '2 4007565 Type~the~Digit:~55'),
(4007564, 0, 0, 0, 0, ''),
(4007565, 4007526, 4007500, 2003, 0, '%accept0 == 55'),
(4007566, 0, 0, 0, 0, ''),
(4007570, 4007571, 0, 101, 0, 'Anti-Macro System!'),
(4007571, 4007572, 0, 101, 0, 'This was created to fight MACRO use.'),
(4007572, 4007573, 0, 101, 0, 'If you answer wrong 3 consecutive times YOU CANNOT COMPOSE for 15 minutes.'),
(4007573, 4000001, 0, 105, 0, '2 4007575 Type~the~Digit:~66'),
(4007574, 0, 0, 0, 0, ''),
(4007575, 4007526, 4007500, 2003, 0, '%accept0 == 66'),
(4007576, 0, 0, 0, 0, ''),
(4007580, 4007581, 0, 101, 0, 'Anti-Macro System!'),
(4007581, 4007582, 0, 101, 0, 'This was created to fight MACRO use.'),
(4007582, 4007583, 0, 101, 0, 'If you answer wrong 3 consecutive times YOU CANNOT COMPOSE for 15 minutes.'),
(4007583, 4000001, 0, 105, 0, '2 4007585 Type~the~Digit:~77'),
(4007584, 0, 0, 0, 0, ''),
(4007585, 4007526, 4007500, 2003, 0, '%accept0 == 77'),
(4007586, 0, 0, 0, 0, ''),
(4007590, 4007591, 0, 101, 0, 'Anti-Macro System!'),
(4007591, 4007592, 0, 101, 0, 'This was created to fight MACRO use.'),
(4007592, 4007593, 0, 101, 0, 'If you answer wrong 3 consecutive times YOU CANNOT COMPOSE for 15 minutes.'),
(4007593, 4000001, 0, 105, 0, '2 4007595 Type~the~Digit:~88'),
(4007594, 0, 0, 0, 0, ''),
(4007595, 4007526, 4007500, 2003, 0, '%accept0 == 88'),
(4007596, 0, 0, 0, 0, ''),
(4007597, 0, 0, 0, 0, '');
INSERT INTO cq_task
(id, id_next, id_nextfail, itemname1, itemname2, money, profession, sex, min_pk, max_pk, team, metempsychosis, query, marriage, client_active)
VALUES
(4007525, 4007525, 0000, '', '', 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(4007535, 4007535, 0000, '', '', 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(4007545, 4007545, 0000, '', '', 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(4007555, 4007555, 0000, '', '', 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(4007565, 4007565, 0000, '', '', 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(4007575, 4007575, 0000, '', '', 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(4007585, 4007585, 0000, '', '', 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0),
(4007595, 4007595, 0000, '', '', 0, 0, 999, -100000, 100000, 0999, 0000, 0, -1, 0);
|
I'm so afraid if it affect my database .. so can I delete all the script below ..