[Release]Flower Card Event

Enjoy~

Full Query~

[quote]

delete from cq_action where id >= 684500000 and id <= 684500024;

INSERT INTO `cq_action` VALUES ('684500000', '684500001', '0000', '0101', '0', '%user_name,~Im~your~Card~exchanger.');
INSERT INTO `cq_action` VALUES ('684500001', '684500002', '0000', '0101', '0', 'You~need~~Gold~Card~to~claim~your~Superb~reward!. ');
INSERT INTO `cq_action` VALUES ('684500002', '684500003', '0000', '0102', '0', '30~Flower~Card~to~1~OceanCard. 684500007');
INSERT INTO `cq_action` VALUES ('684500003', '684500004', '0000', '0102', '0', '30~OceanCard~to~1~SilverCard. 684500013');
INSERT INTO `cq_action` VALUES ('684500004', '684500006', '0000', '0102', '0', '30~SilverCard~to~1~GoldCard. 684500019');
INSERT INTO `cq_action` VALUES ('684500006', '4000027', '0000', '0102', '0', 'Later!. 0');

INSERT INTO `cq_action` VALUES ('684500007', '684500008', '684500012', '0502', '1027000', '30');
INSERT INTO `cq_action` VALUES ('684500008', '684500010', '684500009', '0508', '0', '1 0 50');
INSERT INTO `cq_action` VALUES ('684500009', '0000', '0000', '0126', '0', 'You~dont~have~enough~room~with~you!');
INSERT INTO `cq_action` VALUES ('684500010', '684500011', '0000', '0501', '1027010', '1 500');
INSERT INTO `cq_action` VALUES ('684500011', '0000', '0000', '0126', '0', 'Congratulations!~You~received~1~OceanCard!');
INSERT INTO `cq_action` VALUES ('684500012', '0000', '0000', '0126', '0', 'Im~Sorry,~u~dont~have~enough~event~items');

INSERT INTO `cq_action` VALUES ('684500013', '684500014', '684500018', '0502', '1027010', '30');
INSERT INTO `cq_action` VALUES ('684500014', '684500016', '684500015', '0508', '0', '1 0 50');
INSERT INTO `cq_action` VALUES ('684500015', '0000', '0000', '0126', '0', 'You~dont~have~enough~room~with~you!');
INSERT INTO `cq_action` VALUES ('684500016', '684500017', '0000', '0501', '1027020', '1 500');
INSERT INTO `cq_action` VALUES ('684500017', '0000', '0000', '0126', '0', 'Congratulations!~You~received~1~SilverCard!');
INSERT INTO `cq_action` VALUES ('684500018', '0000', '0000', '0126', '0', 'Im~Sorry,~u~dont~have~enough~event~items');

INSERT INTO `cq_action` VALUES ('684500019', '684500020', '684500024', '0502', '1027020', '30');
INSERT INTO `cq_action` VALUES ('684500020', '684500022', '684500021', '0508', '0', '1 0 50');
INSERT INTO `cq_action` VALUES ('684500021', '0000', '0000', '0126', '0', 'You~dont~have~enough~room~with~you!');
INSERT INTO `cq_action` VALUES ('684500022', '684500023', '0000', '0501', '1027030', '1 500');
INSERT INTO `cq_action` VALUES ('684500023', '0000', '0000', '0126', '0', 'Congratulations!~You~received~1~GoldCard!');
INSERT INTO `cq_action` VALUES ('684500024', '0000', '0000', '0126', '0', 'Im~Sorry,~u~dont~have~enough~event~items');

delete from cq_task where id >= 684500000 and id <= 684500019;

Insert into cq_task values (684500000,684500000,0,'','',0,0,999,-100000,100000,999,0,0,-1,0);
INSERT INTO `cq_task` VALUES ('684500007', '684500007', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('684500013', '684500013', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('684500019', '684500019', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');


delete from cq_action WHERE id>=684700000 AND id<=684700042;

INSERT INTO `cq_action` VALUES ('684700000', '684700001', '0000', '0101', '0', '%user_name,~Im~event~items~exchanger.choose~your~ reward~below.');
INSERT INTO `cq_action` VALUES ('684700001', '684700002', '0000', '0101', '0', 'You~need~Gold~Card~to~claim~your~reward.');
INSERT INTO `cq_action` VALUES ('684700002', '684700003', '0000', '0102', '0', '3~Gold~Card~change~to~+100~Gear. 684700009');
INSERT INTO `cq_action` VALUES ('684700003', '684700004', '0000', '0102', '0', '1~Gold~Card~Change~to~30M~Eps. 684700015');
INSERT INTO `cq_action` VALUES ('684700004', '684700005', '0000', '0102', '0', '10~Gold~Card~Change~to~255+~Gear. 684700019');
INSERT INTO `cq_action` VALUES ('684700005', '684700006', '0000', '0102', '0', '1~Gold~Card~Change~to~5500~Xp~Booster. 684700025');
INSERT INTO `cq_action` VALUES ('684700006', '684700007', '0000', '0102', '0', '2~Gold~Card~Change~to~9900~uni. 684700031');
INSERT INTO `cq_action` VALUES ('684700007', '684700008', '0000', '0102', '0', '2~Gold~Card~Change~5500~Exp~Ball. 684700037');
INSERT INTO `cq_action` VALUES ('684700008', '4000026', '0000', '0102', '0', 'No~Thanks!. 0');

INSERT INTO `cq_action` VALUES ('684700009', '684700010', '684700014', '0502', '1027030', '3');
INSERT INTO `cq_action` VALUES ('684700010', '684700012', '684700011', '0508', '0', '1 0 50');
INSERT INTO `cq_action` VALUES ('684700011', '0000', '0000', '0126', '0', 'You~dont~have~enough~room~with~you!');
INSERT INTO `cq_action` VALUES ('684700012', '684700013', '0000', '0501', '1021084', '1 1');
INSERT INTO `cq_action` VALUES ('684700013', '0000', '0000', '0126', '0', 'Congratulations!~You~received~+100~Gear!');
INSERT INTO `cq_action` VALUES ('684700014', '0000', '0000', '0126', '0', 'Im~Sorry,~u~dont~have~enough~event~items');


INSERT INTO `cq_action` VALUES ('684700015', '684700016', '684700018', '0502', '1027030', '1');
INSERT INTO `cq_action` VALUES ('684700016', '684700017', '0000', '1001', '0', 'e_money += 30000000');
INSERT INTO `cq_action` VALUES ('684700017', '0000', '0000', '0126', '0', 'Congratulations!~You~received~30,000,000~Eps!');
INSERT INTO `cq_action` VALUES ('684700018', '0000', '0000', '0126', '0', 'Im~Sorry,~u~dont~have~enough~event~items');

INSERT INTO `cq_action` VALUES ('684700019', '684700020', '684700024', '0502', '1027030', '10');
INSERT INTO `cq_action` VALUES ('684700020', '684700022', '684700021', '0508', '0', '1 0 50');
INSERT INTO `cq_action` VALUES ('684700021', '0000', '0000', '0126', '0', 'You~dont~have~enough~room~with~you!');
INSERT INTO `cq_action` VALUES ('684700022', '684700023', '0000', '0501', '1021394', '1 1');
INSERT INTO `cq_action` VALUES ('684700023', '0000', '0000', '0126', '0', 'Congratulations!~You~received~+255~Gear!');
INSERT INTO `cq_action` VALUES ('684700024', '0000', '0000', '0126', '0', 'Im~Sorry,~u~dont~have~enough~event~items');

INSERT INTO `cq_action` VALUES ('684700025', '684700026', '684700030', '0502', '1027030', '1');
INSERT INTO `cq_action` VALUES ('684700026', '684700028', '684700027', '0508', '0', '1 0 50');
INSERT INTO `cq_action` VALUES ('684700027', '0000', '0000', '0126', '0', 'You~dont~have~enough~room~with~you!');
INSERT INTO `cq_action` VALUES ('684700028', '684700029', '0000', '0501', '1021082', '5500 5500');
INSERT INTO `cq_action` VALUES ('684700029', '0000', '0000', '0126', '0', 'Congratulations!~You~received~5500~Xp~Booster!');
INSERT INTO `cq_action` VALUES ('684700030', '0000', '0000', '0126', '0', 'Im~Sorry,~u~dont~have~enough~event~items');

INSERT INTO `cq_action` VALUES ('684700031', '684700032', '684700036', '0502', '1027030', '2');
INSERT INTO `cq_action` VALUES ('684700032', '684700034', '684700033', '0508', '0', '1 0 50');
INSERT INTO `cq_action` VALUES ('684700033', '0000', '0000', '0126', '0', 'You~dont~have~enough~room~with~you!');
INSERT INTO `cq_action` VALUES ('684700034', '684700035', '0000', '0501', '1020000', '9900 9900');
INSERT INTO `cq_action` VALUES ('684700035', '0000', '0000', '0126', '0', 'Congratulations!~You~received~9900~UniXO!');
INSERT INTO `cq_action` VALUES ('684700036', '0000', '0000', '0126', '0', 'Im~Sorry,~u~dont~have~enough~event~items');

INSERT INTO `cq_action` VALUES ('684700037', '684700038', '684700042', '0502', '1027030', '2');
INSERT INTO `cq_action` VALUES ('684700038', '684700040', '684700039', '0508', '0', '1 0 50');
INSERT INTO `cq_action` VALUES ('684700039', '0000', '0000', '0126', '0', 'You~dont~have~enough~room~with~you!');
INSERT INTO `cq_action` VALUES ('684700040', '684700041', '0000', '0501', '1020250', '5500 5500');
INSERT INTO `cq_action` VALUES ('684700041', '0000', '0000', '0126', '0', 'Congratulations!~You~received~5500~ExpBall!');
INSERT INTO `cq_action` VALUES ('684700042', '0000', '0000', '0126', '0', 'Im~Sorry,~u~dont~have~enough~event~items');


delete from cq_task WHERE id>=684700000 AND id<=684700037;

INSERT INTO `cq_task` VALUES ('684700000', '684700000', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('684700009', '684700009', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('684700015', '684700015', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('684700019', '684700019', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('684700025', '684700025', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('684700031', '684700031', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_task` VALUES ('684700037', '684700037', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');

delete from cq_action where id >= 623000008 and id <= 623000032;

INSERT INTO `cq_action` VALUES ('623000008', '623000018', '623000009', '5001', '0', '== 1');
INSERT INTO `cq_action` VALUES ('623000009', '623000019', '623000010', '5001', '0', '== 2');
INSERT INTO `cq_action` VALUES ('623000010', '623000020', '623000011', '5001', '0', '== 3');
INSERT INTO `cq_action` VALUES ('623000011', '623000021', '623000012', '5001', '0', '== 4');
INSERT INTO `cq_action` VALUES ('623000012', '623000022', '623000013', '5001', '0', '== 5');
INSERT INTO `cq_action` VALUES ('623000013', '623000023', '623000015', '5001', '0', '== 6');
INSERT INTO `cq_action` VALUES ('623000015', '623000025', '0000', '5001', '0', '== 7');
INSERT INTO `cq_action` VALUES ('623000018', '623000026', '0000', '1001', '0', 'e_money += 15');
INSERT INTO `cq_action` VALUES ('623000019', '623000027', '0000', '1001', '0', 'e_money += 20');
INSERT INTO `cq_action` VALUES ('623000020', '623000028', '0000', '1001', '0', 'e_money += 25');
INSERT INTO `cq_action` VALUES ('623000021', '623000029', '0000', '1001', '0', 'e_money += 30');
INSERT INTO `cq_action` VALUES ('623000022', '623000030', '0000', '1001', '0', 'e_money += 35');
INSERT INTO `cq_action` VALUES ('623000023', '623000031', '0000', '1001', '0', 'e_money += 40');
INSERT INTO `cq_action` VALUES ('623000025', '623000032', '0000', '1001', '0', 'e_money += 50');
INSERT INTO `cq_action` VALUES ('623000026', '0000', '0000', '1010', '2005', 'You found 15 Points from EventMonster!');
INSERT INTO `cq_action` VALUES ('623000027', '0000', '0000', '1010', '2005', 'You found 20 Points from EventMonster!');
INSERT INTO `cq_action` VALUES ('623000028', '0000', '0000', '1010', '2005', 'You found 25 Points from EventMonster!');
INSERT INTO `cq_action` VALUES ('623000029', '0000', '0000', '1010', '2005', 'You found 30 Points from EventMonster!');
INSERT INTO `cq_action` VALUES ('623000030', '0000', '0000', '1010', '2005', 'You found 35 Points from EventMonster!');
INSERT INTO `cq_action` VALUES ('623000031', '0000', '0000', '1010', '2005', 'You found 40 Points from EventMonster!');
INSERT INTO `cq_action` VALUES ('623000032', '0000', '0000', '1010', '2005', 'You found 50 Points from EventMonster!');



delete from cq_monstertype where id = 5577;

INSERT INTO `cq_monstertype` VALUES ('5577', 'Valefor', '0069', '0451', '0', '0', '40000', '00', '05000', '01000', '0000', '0000', '0083', '0000', '0000','0000', '0000', '0001', '0015', '0000', '1000', '0000', '0060', '32771', '0000', '0000', '0003', '623000008', '0000', '000', '000', '000', '000', '000','000', '000', '0000', '500000', '0000', '0000', '0000', '0043', '0000', '10000', '0100', '0030', '0060', '5577', '000', '0000000000', '0000000000','0000000000', '0000000000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

delete from cq_dropitemrule where id = 700;

INSERT INTO `cq_dropitemrule` VALUES ('700', '5577', '0001', '51000000', '1027000', '0000', '1027000', '0000', '1027000', '1027000', '0000', '1027000','0000', '1027000', '0000', '1027000', '1027000', '0000', '1027000');




delete from cq_generator where id >= 63100000 and id <= 63100024;

INSERT INTO `cq_generator` VALUES ('63100000', '12000', '0483', '0203', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100001', '12000', '0404', '0232', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100002', '12000', '0275', '0255', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100003', '12000', '0247', '0345', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100004', '12000', '0207', '0424', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100005', '12000', '0583', '0308', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100006', '12000', '0525', '0370', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100007', '12000', '0537', '0448', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100008', '12000', '0436', '0510', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100009', '12000', '0449', '0559', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100010', '12000', '0591', '0597', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100011', '12000', '0693', '0626', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100012', '12000', '0695', '0515', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100013', '12000', '0897', '0561', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100014', '12000', '0905', '0658', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100015', '12000', '0985', '0744', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100016', '12000', '0892', '0786', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100017', '12000', '0912', '0899', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100018', '12000', '0970', '0972', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100019', '12000', '0875', '0972', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100020', '12000', '0876', '1105', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100021', '12000', '0973', '01101', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000','0000','0000');
INSERT INTO `cq_generator` VALUES ('63100022', '12000', '0925', '01252', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000','0000','0000');
INSERT INTO `cq_generator` VALUES ('63100023', '12000', '0763', '0971', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');
INSERT INTO `cq_generator` VALUES ('63100024', '12000', '0760', '1080', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');

INSERT INTO `cq_itemtype` VALUES ('1027000', 'FlowerCard', '0', '0', '0', '0', '0', '0', '0', '0', '28', '0', '0', '00', '0', '0', '0', '0', '0', '0', '0', '1', '500', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('1027010', 'OceanCard', '0', '0', '0', '0', '0', '0', '0', '0', '28', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('1027020', 'SilverCard', '0', '0', '0', '0', '0', '0', '0', '0', '28', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('1027030', 'GoldCard', '0', '0', '0', '0', '0', '0', '0', '0', '28', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '500', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `cq_npc` VALUES ('3044', '0', '0', 'Alyah', '0123', '30447', '0', '0', '-1', '1000', '0299', '0404', '835001', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '0', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000');

Insert into cq_action values
(835001,835002,0,101,0,'You~wanna~go~Flower~Card~e vent~Map~now?'),
(835002,835005,0,102,0,'Go~Now 835003'),
(835003,835004,0,1003,0,'12000 380 110'),
(835004,0,0,126,0,'Welcome!'),
(835005,835006,0,102,0,'Later 0'),
(835006,835007,0,104,0,'0 0 998006'),
(835007,0,0,120,0,'');
Insert into cq_task values
(835003,835003,0,'','',0,0,999,-100000,100000,999,0,0,-1,0),
(835001,835001,0,'','',0,0,999,-100000,100000,999,0,0,-1,0);


INSERT INTO `cq_npc` VALUES ('123409', '0', '0', 'EventChanger1', '0001', '1234097', '0', '0', '-1', '1000', '0293', '0404', '684500000', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '0', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000');
INSERT INTO `cq_npc` VALUES ('123410', '0', '0', 'EventChanger2', '0001', '1234107', '0', '0', '-1', '1000', '0296', '0404', '684700000', '0000', '0000', '0000', '0000', '0000', '0000', '0000', '0', '0', '0', '0', '0', '0000', '00', '00', '0000', '01', '0000', '0000', '0000', '0000', '0000');


note: if you want change to another map u must change the generator map id and coordinates like this

Quote:
INSERT INTO `cq_generator` VALUES ('63100000', '[Your Map id]', '[Coordinate X]', '[Coordinate Y]', '050', '0050', '0200', '0010', '150', '5577', '0000', '0000', '0000', '0000','0000');


Note 2:and if you want change the award it like this

Quote:
INSERT INTO `cq_action` VALUES ('684700025', '684700026', '684700030', '0502', '1027030', '1');
INSERT INTO `cq_action` VALUES ('684700026', '684700028', '684700027', '0508', '0', '1 0 50');
INSERT INTO `cq_action` VALUES ('684700027', '0000', '0000', '0126', '0', 'You~dont~have~enough~room~with~you!');
INSERT INTO `cq_action` VALUES ('684700028', '684700029', '0000', '0501', '[Your Item id]', '1 1');
INSERT INTO `cq_action` VALUES ('684700029', '0000', '0000', '0126', '0', 'Congratulations!~You~received~[item name]!');
INSERT INTO `cq_action` VALUES ('684700030', '0000', '0000', '0126', '0', 'Im~Sorry,~u~dont~have~enough~event~items');


And Client Side File~

http://www.fixways.net/forum/attachment.php?attachmentid=119&d=1300597855
Happy Enjoying~


_________________
I Hope I Can Be A Moderator Soon !