[RELEASE]Eud SkillBugFix For Mannequin DB

PraDevil[ELITE] · 11/24/2009, 17:39

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..

~Dark-Warrior~ · 11/24/2009, 19:42

ohh Niice.

wbl4352 · 11/24/2009, 20:31

thank you bro.. what about your hex editing now? wahahaha

PraDevil[ELITE] · 11/24/2009, 21:53

Quote:

Originally Posted by ~Dark-Warrior~

ohh Niice.

thanks bro..give me support to other release..

Quote:

Originally Posted by wbl4352

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..

funhacker · 11/25/2009, 06:56

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.

PraDevil[ELITE] · 11/25/2009, 07:19

Quote:

Originally Posted by funhacker

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..

tuyup01 · 11/28/2009, 03:24

Nice..job ..Tq share it

CyberServer · 11/28/2009, 03:53

ehehhe so when u want share ur db info too tuyup...

SoulNecturn · 11/29/2009, 13:48

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

PraDevil[ELITE] · 11/29/2009, 15:17

soulerman u make me sick O_o anyways thank for remind i will try fixing this prob completely just not for now..thank again..

CyberServer · 11/30/2009, 15:44

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

RADoss · 02/12/2010, 10:59

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.

zerofighter0 · 04/03/2010, 10:15

where to find cq_action

PraDevil[ELITE] · 04/03/2010, 10:48

database side thru navicat

~~reloaded90~~ · 07/29/2010, 08:02

NICE BRO