Navicat >> zf >> query >> new query >> run
INSERT INTO `cq_action` VALUES ('1001', '15003', '0000', '0102', '0', 'Desculpe. 0');INSERT INTO `cq_action` VALUES ('1002', '1003', '0000', '0101', '0', 'Então~vamos~lá~%user_name,~vou~dizer~como~conseguir~as~letras~para~fazer~essa~quest~fã~conquer~para~conseguir~as~letras~você~');INSERT INTO `cq_action` VALUES ('1003', '1004', '0000', '0101', '0', 'precisa~mata~os~seguintes~monstros~[Turtledove],~[Robin],~[Birdman],~[Bandit],~[Macaque],~[HawKing],~[SandMonster]~para~');INSERT INTO `cq_action` VALUES ('1004', '1005', '0000', '0101', '0', 'conseguir~as~letras~[C~O~N~Q~U~E~R].');INSERT INTO `cq_action` VALUES ('1005', '1006', '0000', '0102', '0', 'Ok,~valeu. 1007');INSERT INTO `cq_action` VALUES ('1006', '15003', '0000', '0102', '0', 'Vixi~não~valeu. 0');INSERT INTO `cq_action` VALUES ('1007', '1008', '0000', '0101', '0', 'Tenha~cuidado~%user_name~esses~monstros~são~muito~violentos~e~forte,~você~pode~morre~facilmente~para~eles~tenha~muito~cuidado.');INSERT INTO `cq_action` VALUES ('1008', '15003', '0000', '0102', '0', 'Obrigado~por~informar. 0');INSERT INTO `cq_action` VALUES ('1009', '1010', '1012', '1077', '1', 'select quest_id from cq_quest where quest_id=995 and user_id=%user_id');INSERT INTO `cq_action` VALUES ('1010', '1011', '0000', '0101', '0', 'Opa!~%user_name,~já~lhe~dei~sua~recompensa~quer~me~enganar~%user_name?');INSERT INTO `cq_action` VALUES ('1011', '15003', '0000', '0102', '0', 'Não,~desculpe. 0');INSERT INTO `cq_action` VALUES ('1012', '1013', '0000', '0101', '0', 'Olá~%user_name,~você~foi~rapido~já~conseguiu~todas~as~letras~da~quest~fã~conquer?');INSERT INTO `cq_action` VALUES ('1013', '1014', '0000', '0102', '0', 'Sim,~aqui~está. 1015');INSERT INTO `cq_action` VALUES ('1014', '15003', '0000', '0102', '0', 'Não,~ainda~falta~letra. 0');INSERT INTO `cq_action` VALUES ('1015', '1016', '1026', '0506', '0', '711214 711214 1');INSERT INTO `cq_action` VALUES ('1016', '1017', '1026', '0506', '0', '711215 711215 1');INSERT INTO `cq_action` VALUES ('1017', '1018', '1026', '0506', '0', '711216 711216 1');INSERT INTO `cq_action` VALUES ('1018', '1019', '1026', '0506', '0', '711217 711217 1');INSERT INTO `cq_action` VALUES ('1019', '1020', '1026', '0506', '0', '711218 711218 1');INSERT INTO `cq_action` VALUES ('1020', '1021', '1026', '0506', '0', '711219 711219 1');INSERT INTO `cq_action` VALUES ('1021', '1022', '1026', '0506', '0', '711220 711220 1');INSERT INTO `cq_action` VALUES ('1022', '1023', '0000', '1001', '0', 'e_money += 2000000');INSERT INTO `cq_action` VALUES ('1023', '1024', '0000', '0127', '0', 'INSERT INTO cq_quest set user_id=\"%user_id\",quest_id=\"995\",user_name=\"%user_name\",quest_done=\"OK\"');INSERT INTO `cq_action` VALUES ('1024', '1025', '0000', '0101', '0', 'Nossa!~%user_name,~você~é~demais~fez~a~quest~fã~conquer~rapidão,~ganhou~2.000.000~CPs.');INSERT INTO `cq_action` VALUES ('1025', '15003', '0000', '0102', '0', 'Obrigado. 0');INSERT INTO `cq_action` VALUES ('1026', '1027', '0000', '0101', '0', 'Está~faltando~letra~%user_name,~você~precisa~de~todas~para~completa~a~quest~fã~conquer.');INSERT INTO `cq_action` VALUES ('1027', '15003', '0000', '0102', '0', 'Desculpe. 0');
REPLACE INTO `cq_monstertype` VALUES ('0002', 'Turtledove', '0001', '0304', '81', '00', '0016', '0015', '0000', '0000', '0037', '0000', '0000', '0000', '0000', '0001', '0006', '0000', '1000', '0500', '0007', '3', '0360', '0000', '0000', '1028', '0500', '099', '000', '099', '000', '000', '099', '001', '1000000', '1001000', '0000', '0000', '0000', '0000', '10000', '02', '0', '0', '7000', '0');INSERT INTO `cq_action` VALUES ('1028', '1029', '0000', '0121', '0', '1 100');INSERT INTO `cq_action` VALUES ('1029', '8003410', '0000', '0801', '0', 'dropitem 711214');
REPLACE INTO `cq_monstertype` VALUES ('0003', 'Robin', '0001', '0132', '183', '00', '0035', '0031', '0000', '0002', '0036', '0000', '0000', '0000', '0000', '0001', '0008', '0000', '1000', '0500', '0012', '3', '0360', '0000', '0000', '1030', '0500', '000', '001', '000', '001', '001', '099', '003', '1000000', '1001000', '0000', '0000', '0000', '0000', '10000', '03', '6', '0', '7000', '0');INSERT INTO `cq_action` VALUES ('1030', '1031', '0000', '0121', '0', '1 100');INSERT INTO `cq_action` VALUES ('1031', '8003420', '0000', '0801', '0', 'dropitem 711215');
REPLACE INTO `cq_monstertype` VALUES ('0018', 'Birdman', '0001', '0205', '13422', '00', '0810', '0731', '0000', '0028', '0085', '0000', '0000', '0000', '0000', '0001', '0008', '0000', '1000', '0500', '0087', '3', '0360', '0000', '0001', '1032', '0500', '008', '017', '007', '017', '017', '007', '017', '1002000', '1001040', '0000', '0000', '0000', '0000', '10000', '18', '19', '0', '7000', '0');INSERT INTO `cq_action` VALUES ('1032', '1033', '0000', '0121', '0', '1 100');INSERT INTO `cq_action` VALUES ('1033', '7548480', '0000', '0801', '0', 'dropitem 711216');
REPLACE INTO `cq_monstertype` VALUES ('0007', 'Bandit', '0001', '0201', '817', '00', '0089', '0081', '0000', '0010', '0075', '0000', '0000', '0000', '0000', '0001', '0008', '0000', '1000', '0500', '0032', '3', '0360', '0000', '0001', '1034', '0500', '003', '005', '002', '005', '005', '099', '007', '1000010', '1001010', '0000', '0000', '0000', '0000', '10000', '07', '10', '0', '7000', '0');INSERT INTO `cq_action` VALUES ('1034', '1035', '0000', '0121', '0', '1 100');INSERT INTO `cq_action` VALUES ('1035', '5001270', '0000', '0801', '0', 'dropitem 711217');
REPLACE INTO `cq_monstertype` VALUES ('0010', 'Macaque', '0001', '0156', '2199', '00', '0173', '0156', '0000', '0018', '0078', '0000', '0000', '0000', '0000', '0001', '0008', '0000', '1000', '0500', '0047', '3', '0360', '0000', '0001', '1036', '0500', '004', '008', '004', '008', '008', '001', '009', '1000020', '1001020', '0000', '0000', '0000', '0000', '10000', '10', '12', '0', '7000', '0');INSERT INTO `cq_action` VALUES ('1036', '1037', '0000', '0121', '0', '1 100');INSERT INTO `cq_action` VALUES ('1037', '7547972', '0000', '0801', '0', 'dropitem 711218');
REPLACE INTO `cq_monstertype` VALUES ('0019', 'HawKing', '0001', '0205', '15432', '00', '0946', '0855', '0000', '0028', '0085', '0000', '0000', '0000', '0000', '0001', '0010', '0000', '1000', '1000', '0092', '3', '0360', '0000', '0001', '1038', '0500', '008', '018', '008', '018', '018', '007', '019', '1002000', '1001040', '0000', '0000', '0000', '0000', '10000', '19', '20', '0', '7000', '0');INSERT INTO `cq_action` VALUES ('1038', '1039', '0000', '0121', '0', '1 100');INSERT INTO `cq_action` VALUES ('1039', '30370', '0000', '0801', '0', 'dropitem 711219');
REPLACE INTO `cq_monstertype` VALUES ('0014', 'SandMonster', '0001', '0131', '5760', '00', '0439', '0397', '0000', '0021', '0087', '0000', '0000', '0000', '0000', '0001', '0008', '0000', '1000', '0500', '0067', '3', '0360', '0000', '0003', '1040', '0500', '006', '013', '006', '013', '013', '004', '013', '1000030', '1001030', '0000', '0000', '0000', '0000', '10000', '14', '15', '0', '7000', '0');INSERT INTO `cq_action` VALUES ('1040', '1041', '0000', '0121', '0', '1 100');INSERT INTO `cq_action` VALUES ('1041', '1052317', '0000', '0801', '0', 'dropitem 711220');
INSERT INTO `cq_task` VALUES ('0994', '0994', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('0995', '0995', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('0996', '0996', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('0997', '0997', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('0998', '0998', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('0999', '0999', '1002', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1000', '1000', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1001', '1001', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1002', '1002', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1003', '1003', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1004', '1004', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1005', '1005', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1006', '1006', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1007', '1007', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1008', '1008', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1009', '1009', '1012', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1010', '1010', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1011', '1011', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1012', '1012', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1013', '1013', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1014', '1014', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1015', '1015', '1026', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1016', '1016', '1026', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1017', '1017', '1026', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1018', '1018', '1026', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1019', '1019', '1026', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1020', '1020', '1026', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1021', '1021', '1026', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1022', '1022', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1023', '1023', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1024', '1024', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1025', '1025', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1026', '1026', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');INSERT INTO `cq_task` VALUES ('1027', '1027', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');
INSERT INTO `cq_itemtype` VALUES ('711214', 'LetterC[Q]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '01', '1000', '0', '0', '1', '5000');INSERT INTO `cq_itemtype` VALUES ('711215', 'LetterO[Q]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '01', '1000', '0', '0', '1', '5000');INSERT INTO `cq_itemtype` VALUES ('711216', 'LetterN[Q]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '01', '1000', '0', '0', '1', '5000');INSERT INTO `cq_itemtype` VALUES ('711217', 'LetterQ[Q]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '01', '1000', '0', '0', '1', '5000');INSERT INTO `cq_itemtype` VALUES ('711218', 'LetterU[Q]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '01', '1000', '0', '0', '1', '5000');INSERT INTO `cq_itemtype` VALUES ('711219', 'LetterE[Q]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '01', '1000', '0', '0', '1', '5000');INSERT INTO `cq_itemtype` VALUES ('711220', 'LetterR[Q]', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '10000', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '01', '1000', '0', '0', '1', '5000');
Add essa query da nova tabela cq_quest
DROP TABLE IF EXISTS `cq_quest`;CREATE TABLE `cq_quest` ( `id` int(11) NOT NULL auto_increment, `quest_id` int(10) unsigned NOT NULL default '0', `user_id` int(10) unsigned NOT NULL default '0', `user_name` char(16) binary NOT NULL default '', `quest_done` char(10) binary NOT NULL default '0', PRIMARY KEY (`id`)) TYPE=MyISAM;
Cliente/ani
Add ItemMinIcon.ani
[Item711214]FrameAmount=1Frame0=data/ItemMinIcon/7112141.dds
[Item711215]FrameAmount=1Frame0=data/ItemMinIcon/7112151.dds
[Item711216]FrameAmount=1Frame0=data/ItemMinIcon/7112161.dds
[Item711217]FrameAmount=1Frame0=data/ItemMinIcon/7112171.dds
[Item711218]FrameAmount=1Frame0=data/ItemMinIcon/7112181.dds
[Item711219]FrameAmount=1Frame0=data/ItemMinIcon/7112191.dds
[Item711220]FrameAmount=1Frame0=data/ItemMinIcon/7112201.dds
Cliente/ani
Add MapItemIcon.ani
[711214]FrameAmount=1Frame0=data/MapItemIcon/7112141.dds
[711215]FrameAmount=1Frame0=data/MapItemIcon/7112151.dds
[711216]FrameAmount=1Frame0=data/MapItemIcon/7112161.dds
[711217]FrameAmount=1Frame0=data/MapItemIcon/7112171.dds
[711218]FrameAmount=1Frame0=data/MapItemIcon/7112181.dds
[711219]FrameAmount=1Frame0=data/MapItemIcon/7112191.dds
[711220]FrameAmount=1Frame0=data/MapItemIcon/7112201.dds
Cliente/ini
Add itemtype.dat (obs. necessário DatCryptor)
711214 LetterC 0 0 0 0 0 0 0 0 0 0 10000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1000 0 0 0 0 QuestItem None 5711215 LetterO 0 0 0 0 0 0 0 0 0 0 10000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1000 0 0 0 0 QuestItem None 5711216 LetterN 0 0 0 0 0 0 0 0 0 0 10000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1000 0 0 0 0 QuestItem None 5711217 LetterQ 0 0 0 0 0 0 0 0 0 0 10000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1000 0 0 0 0 QuestItem None 5711218 LetterU 0 0 0 0 0 0 0 0 0 0 10000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1000 0 0 0 0 QuestItem None 5711219 LetterE 0 0 0 0 0 0 0 0 0 0 10000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1000 0 0 0 0 QuestItem None 5711220 LetterR 0 0 0 0 0 0 0 0 0 0 10000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1000 0 0 0 0 QuestItem None 5
Download do Patch:DownloadAkie
Autor: JuniorFerraz
