[RELEASE]Eud SkillBugFix For Mannequin DB

Page 1 of 2 1 2
11/24/2009 17:39 PraDevil[ELITE]#1
This query use for fix your eudemon skill..i have two query translate..
first for malaysian server(JinOnline)
second for English server(EudemonOnline)

Code:
Malaysian Language
Code:
delete from cq_action where id >= 2222220 and id <= 2722225;

update cq_itemtype set id_action='2222220' where id='1033110';
update cq_itemtype set id_action='2322220' where id='1033060';
update cq_itemtype set id_action='2422220' where id='1033070';
update cq_itemtype set id_action='2522220' where id='1033020';
update cq_itemtype set id_action='2622220' where id='1033040';
update cq_itemtype set id_action='2722220' where id='1033000';

INSERT INTO `cq_action` VALUES ('2222220', '2222221', '2222222', '0802', '0', 'check 3000');
INSERT INTO `cq_action` VALUES ('2222221', '0000', '0000', '1010', '2005', 'Jin~anda~telah~belajar~kemahiran~ini');
INSERT INTO `cq_action` VALUES ('2222222', '2222223', '2222224', '0802', '0', 'learn 3000');
INSERT INTO `cq_action` VALUES ('2222224', '0000', '0000', '1010', '2005', 'Jin~anda~tidak~boleh~belajar~kemahiran~ini');
INSERT INTO `cq_action` VALUES ('2222223', '2222226', '0000', '1010', '2005', 'Tahniah~Jin~anda~telah~belajar~kemahiran~windbeards');
INSERT INTO `cq_action` VALUES ('2222226', '0000', '0000', '0502', '1033110', '0');
INSERT INTO `cq_action` VALUES ('2322220', '2322221', '2322222', '0802', '0', 'check 3011');
INSERT INTO `cq_action` VALUES ('2322221', '0000', '0000', '1010', '2005', 'Jin~anda~telah~belajar~kemahiran~ini');
INSERT INTO `cq_action` VALUES ('2322222', '2322223', '2322224', '0802', '0', 'learn 3011');
INSERT INTO `cq_action` VALUES ('2322223', '2322225', '0000', '1010', '2005', 'Jin~anda~tidak~boleh~belajar~kemahiran~ini');
INSERT INTO `cq_action` VALUES ('2322224', '0000', '0000', '1010', '2005', 'Tahniah~Jin~anda~telah~belajar~kemahiran~Thunder');
INSERT INTO `cq_action` VALUES ('2322225', '0000', '0000', '0502', '1033060', '0');
INSERT INTO `cq_action` VALUES ('2422220', '2422221', '2422222', '0802', '0', 'check 3006');
INSERT INTO `cq_action` VALUES ('2422221', '0000', '0000', '1010', '2005', 'Jin~anda~telah~belajar~kemahiran~ini');
INSERT INTO `cq_action` VALUES ('2422222', '2422223', '2422224', '0802', '0', 'learn 3006');
INSERT INTO `cq_action` VALUES ('2422223', '2422225', '0000', '1010', '2005', 'Jin~anda~tidak~boleh~belajar~kemahiran~ini');
INSERT INTO `cq_action` VALUES ('2422224', '0000', '0000', '1010', '2005', 'Tahniah~Jin~anda~telah~belajar~kemahiran~Lightning');
INSERT INTO `cq_action` VALUES ('2422225', '0000', '0000', '0502', '1033070', '0');
INSERT INTO `cq_action` VALUES ('2522220', '2522221', '2522222', '0802', '0', 'check 1002');
INSERT INTO `cq_action` VALUES ('2522221', '0000', '0000', '1010', '2005', 'Jin~anda~telah~belajar~kemahiran~ini');
INSERT INTO `cq_action` VALUES ('2522222', '2522223', '2522224', '0802', '0', 'learn 1002');
INSERT INTO `cq_action` VALUES ('2522223', '2522225', '0000', '1010', '2005', 'Jin~anda~tidak~boleh~belajar~kemahiran~ini');
INSERT INTO `cq_action` VALUES ('2522224', '0000', '0000', '1010', '2005', 'Tahniah~Jin~anda~telah~belajar~kemahiran~Whirlwind');
INSERT INTO `cq_action` VALUES ('2522225', '0000', '0000', '0502', '1033020', '0');
INSERT INTO `cq_action` VALUES ('2622220', '2622221', '2622222', '0802', '0', 'check 1006');
INSERT INTO `cq_action` VALUES ('2622221', '0000', '0000', '1010', '2005', 'Jin~anda~telah~belajar~kemahiran~ini');
INSERT INTO `cq_action` VALUES ('2622222', '2622223', '2622224', '0802', '0', 'learn 1006');
INSERT INTO `cq_action` VALUES ('2622223', '2622225', '0000', '1010', '2005', 'Jin~anda~tidak~boleh~belajar~kemahiran~ini');
INSERT INTO `cq_action` VALUES ('2622224', '0000', '0000', '1010', '2005', 'Tahniah~Jin~anda~telah~belajar~kemahiran~FireBlast');
INSERT INTO `cq_action` VALUES ('2622225', '0000', '0000', '0502', '1033040', '0');
INSERT INTO `cq_action` VALUES ('2722220', '2722221', '2722222', '0802', '0', 'check 8001');
INSERT INTO `cq_action` VALUES ('2722221', '0000', '0000', '1010', '2005', 'Jin~anda~telah~belajar~kemahiran~ini');
INSERT INTO `cq_action` VALUES ('2722222', '2722223', '2722224', '0802', '0', 'learn 8001');
INSERT INTO `cq_action` VALUES ('2722223', '2722225', '0000', '1010', '2005', 'Jin~anda~tidak~boleh~belajar~kemahiran~ini');
INSERT INTO `cq_action` VALUES ('2722224', '0000', '0000', '1010', '2005', 'Tahniah~Jin~anda~telah~belajar~kemahiran~WindChop');
INSERT INTO `cq_action` VALUES ('2722225', '0000', '0000', '0502', '1033000', '0');


Code:
English Language
Code:
delete from cq_action where id >= 2222220 and id <= 2722225;

update cq_itemtype set id_action='2222220' where id='1033110';
update cq_itemtype set id_action='2322220' where id='1033060';
update cq_itemtype set id_action='2422220' where id='1033070';
update cq_itemtype set id_action='2522220' where id='1033020';
update cq_itemtype set id_action='2622220' where id='1033040';
update cq_itemtype set id_action='2722220' where id='1033000';

INSERT INTO `cq_action` VALUES ('2222220', '2222221', '2222222', '0802', '0', 'check 3000');
INSERT INTO `cq_action` VALUES ('2222221', '0000', '0000', '1010', '2005', 'your~eudemon~has~learned~this~skill');
INSERT INTO `cq_action` VALUES ('2222222', '2222223', '2222224', '0802', '0', 'learn 3000');
INSERT INTO `cq_action` VALUES ('2222224', '0000', '0000', '1010', '2005', 'your~eudemon~cant~learn~this~skill');
INSERT INTO `cq_action` VALUES ('2222223', '2222226', '0000', '1010', '2005', 'Congratulations~your~eudemon~has~learned~windbeads');
INSERT INTO `cq_action` VALUES ('2222226', '0000', '0000', '0502', '1033110', '0');
INSERT INTO `cq_action` VALUES ('2322220', '2322221', '2322222', '0802', '0', 'check 3011');
INSERT INTO `cq_action` VALUES ('2322221', '0000', '0000', '1010', '2005', 'your~eudemon~has~learned~this~skill');
INSERT INTO `cq_action` VALUES ('2322222', '2322223', '2322224', '0802', '0', 'learn 3011');
INSERT INTO `cq_action` VALUES ('2322223', '2322225', '0000', '1010', '2005', 'your~eudemon~cant~learn~this~skill');
INSERT INTO `cq_action` VALUES ('2322224', '0000', '0000', '1010', '2005', 'Congratulations~your~eudemon~has~learned~Thunder');
INSERT INTO `cq_action` VALUES ('2322225', '0000', '0000', '0502', '1033060', '0');
INSERT INTO `cq_action` VALUES ('2422220', '2422221', '2422222', '0802', '0', 'check 3006');
INSERT INTO `cq_action` VALUES ('2422221', '0000', '0000', '1010', '2005', 'your~eudemon~has~learned~this~skill');
INSERT INTO `cq_action` VALUES ('2422222', '2422223', '2422224', '0802', '0', 'learn 3006');
INSERT INTO `cq_action` VALUES ('2422223', '2422225', '0000', '1010', '2005', 'your~eudemon~cant~learn~this~skill');
INSERT INTO `cq_action` VALUES ('2422224', '0000', '0000', '1010', '2005', 'Congratulations~your~eudemon~has~learned~Lightning');
INSERT INTO `cq_action` VALUES ('2422225', '0000', '0000', '0502', '1033070', '0');
INSERT INTO `cq_action` VALUES ('2522220', '2522221', '2522222', '0802', '0', 'check 1002');
INSERT INTO `cq_action` VALUES ('2522221', '0000', '0000', '1010', '2005', 'your~eudemon~has~learned~this~skill');
INSERT INTO `cq_action` VALUES ('2522222', '2522223', '2522224', '0802', '0', 'learn 1002');
INSERT INTO `cq_action` VALUES ('2522223', '2522225', '0000', '1010', '2005', 'your~eudemon~cant~learn~this~skill');
INSERT INTO `cq_action` VALUES ('2522224', '0000', '0000', '1010', '2005', 'Congratulations~your~eudemon~has~learned~Whirlwind');
INSERT INTO `cq_action` VALUES ('2522225', '0000', '0000', '0502', '1033020', '0');
INSERT INTO `cq_action` VALUES ('2622220', '2622221', '2622222', '0802', '0', 'check 1006');
INSERT INTO `cq_action` VALUES ('2622221', '0000', '0000', '1010', '2005', 'your~eudemon~has~learned~this~skill');
INSERT INTO `cq_action` VALUES ('2622222', '2622223', '2622224', '0802', '0', 'learn 1006');
INSERT INTO `cq_action` VALUES ('2622223', '2622225', '0000', '1010', '2005', 'your~eudemon~cant~learn~this~skill');
INSERT INTO `cq_action` VALUES ('2622224', '0000', '0000', '1010', '2005', 'Congratulations~your~eudemon~has~learned~FireBlast');
INSERT INTO `cq_action` VALUES ('2622225', '0000', '0000', '0502', '1033040', '0');
INSERT INTO `cq_action` VALUES ('2722220', '2722221', '2722222', '0802', '0', 'check 8001');
INSERT INTO `cq_action` VALUES ('2722221', '0000', '0000', '1010', '2005', 'your~eudemon~has~learned~this~skill');
INSERT INTO `cq_action` VALUES ('2722222', '2722223', '2722224', '0802', '0', 'learn 8001');
INSERT INTO `cq_action` VALUES ('2722223', '2722225', '0000', '1010', '2005', 'your~eudemon~cant~learn~this~skill');
INSERT INTO `cq_action` VALUES ('2722224', '0000', '0000', '1010', '2005', 'Congratulations~your~eudemon~has~learned~WindChop');
INSERT INTO `cq_action` VALUES ('2722225', '0000', '0000', '0502', '1033000', '0');
please thank me if this help..other question or something please let me know..
11/24/2009 19:42 ~Dark-Warrior~#2
ohh Niice.
11/24/2009 20:31 wbl4352#3
thank you bro.. what about your hex editing now? wahahaha
11/24/2009 21:53 PraDevil[ELITE]#4
Quote:
Originally Posted by ~Dark-Warrior~ View Post
ohh Niice.
thanks bro..give me support to other release..

Quote:
Originally Posted by wbl4352 View Post
thank you bro.. what about your hex editing now? wahahaha
im also noob in hex edit..forget it..dont make a spam..maybe in other time im learn hard for it..
11/25/2009 06:56 funhacker#5
I didn't read much as I really dislike SQL dumps, but you may want to include the new cq_task entries you will need for those items you changed.
11/25/2009 07:19 PraDevil[ELITE]#6
Quote:
Originally Posted by funhacker View Post
I didn't read much as I really dislike SQL dumps, but you may want to include the new cq_task entries you will need for those items you changed.
if u have more road to solve this problem please share with us bro..i would like to thank u if find the the prob then make it completely..i need ur help..im also newbie and noob in private server..thanks..
11/28/2009 03:24 tuyup01#7
Nice..job ..Tq share it
11/28/2009 03:53 CyberServer#8
ehehhe so when u want share ur db info too tuyup...
11/29/2009 13:48 SoulNecturn#9
ymmmm

maybe I scan this release in rush but do I see it properly?

If its FIX for SKILL CRYSTALS that are used on Eudemons ... then ymmmm isnt this "FIX" making possible to learn all those skills by ALL types of Eudemons??? MEaning warrior/mage and paladin type... ???? This is what I see basing on this release :/

Anyway just wanned to ask/INFORM? anyone who would wish to run this "FIX" :)

Besides good job - at least an idea ;)

Regards
11/29/2009 15:17 PraDevil[ELITE]#10
soulerman u make me sick O_o anyways thank for remind i will try fixing this prob completely just not for now..thank again..
11/30/2009 15:44 CyberServer#11
well he is so profesional but for us this is good release already since we still newbies..
hehehe but anyways congratz bro u rock men :p
02/12/2010 10:59 RADoss#12
thank you for sharing this, as im sure you know, these DBs can be a pain to figure out. But helping each other like this will make us newbies capable of a proper release.
04/03/2010 10:15 zerofighter0#13
where to find cq_action
04/03/2010 10:48 PraDevil[ELITE]#14
database side thru navicat
07/29/2010 08:02 reloaded90#15
NICE BRO
Page 1 of 2 1 2