You last visited: Today at 15:32
Advertisement
[RELEASE]Eud SkillBugFix For Mannequin DB
Discussion on [RELEASE]Eud SkillBugFix For Mannequin DB within the EO PServer Guides & Releases forum part of the EO PServer Hosting category.
11/24/2009, 17:39
#1
elite*gold: 0
Join Date: Nov 2009
Posts: 1,486
Received Thanks: 919
[RELEASE]Eud SkillBugFix For Mannequin DB
This query use for fix your eudemon skill..i have two query translate..
first for malaysian server(JinOnline)
second for English server(EudemonOnline)
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:
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
#2
elite*gold: 0
Join Date: Apr 2009
Posts: 179
Received Thanks: 55
ohh Niice.
11/24/2009, 20:31
#3
elite*gold: 0
Join Date: May 2008
Posts: 21
Received Thanks: 2
thank you bro.. what about your hex editing now? wahahaha
11/24/2009, 21:53
#4
elite*gold: 0
Join Date: Nov 2009
Posts: 1,486
Received Thanks: 919
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..
11/25/2009, 06:56
#5
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,747
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
#6
elite*gold: 0
Join Date: Nov 2009
Posts: 1,486
Received Thanks: 919
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..
11/28/2009, 03:24
#7
elite*gold: 0
Join Date: May 2007
Posts: 75
Received Thanks: 25
Nice..job ..Tq share it
11/28/2009, 03:53
#8
elite*gold: 0
Join Date: Nov 2009
Posts: 565
Received Thanks: 108
ehehhe so when u want share ur db info too tuyup...
11/29/2009, 13:48
#9
elite*gold: 100
Join Date: Oct 2008
Posts: 636
Received Thanks: 1,216
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
#10
elite*gold: 0
Join Date: Nov 2009
Posts: 1,486
Received Thanks: 919
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
#11
elite*gold: 0
Join Date: Nov 2009
Posts: 565
Received Thanks: 108
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
02/12/2010, 10:59
#12
elite*gold: 0
Join Date: May 2006
Posts: 33
Received Thanks: 3
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
#13
elite*gold: 0
Join Date: Mar 2010
Posts: 4
Received Thanks: 0
where to find cq_action
04/03/2010, 10:48
#14
elite*gold: 0
Join Date: Nov 2009
Posts: 1,486
Received Thanks: 919
database side thru navicat
07/29/2010, 08:02
#15
elite*gold: 0
Join Date: Dec 2009
Posts: 167
Received Thanks: 15
NICE BRO
[HELP]mannequin
09/03/2009 - EO PServer Hosting - 1 Replies
how can i add mannequin in to my private server??
can somebody teach me??
did i need some scrip or client side??
pls help..i will hit thanks button..
[Release]Mannequin MsgServer 999*CrownRank
02/23/2009 - EO PServer Guides & Releases - 7 Replies
Hello,
This release is the msgserver for the Mannequin Server files. This msg server makes the crown limit for pets 999*. What this does, is if your pet is 999* or below it can still have a crown rank. Why release this? Because it was simple enough to make. Just take the msgserver thats in this rar file and put it where you have your GameServer folder located.
Downloads
MegalUpload
MEGAUPLOAD - The leading online storage and file delivery service
[Help]me need help with mannequin db
02/21/2009 - EO PServer Hosting - 2 Replies
Me have server that use mannequin db by cyberghoser1.
Me needing help pets 110* no have ranks.
Can anyone helping me?
SOrry my bad english.
[RELEASE]Mannequin Database (FREE & NO LIMITS)
12/06/2008 - EO PServer Guides & Releases - 15 Replies
Yeah guys, its me again.
I got tired of EO and i decided to move on to other game private servers.
I was working on this for awhile last week but gave up since i lost interest in the game.
Well so im releasing this.
Count it as my last release here.
I will still come by epvpers and answer questions and stuff time to time.
Well this is the RAW Mannequin database.
Nothing is changed/translated.
I'm sorry, but you have to translate and do everything by yourself.
[Mannequin] IS HERE NOW :)
11/26/2008 - EO PServer Hosting - 9 Replies
I have got the Mannequin Running 100%
It will be Added to the selling Service soon :)
http://img26.picoodle.com/img/img26/3/11/26/f_Unt itledm_6f4496b.jpg
All times are GMT +2. The time now is 15:33 .
![[RELEASE]Eud SkillBugFix For Mannequin DB](https://www.elitepvpers.com/forum/iconimages/eo-pserver-guides-releases/release-eud-skillbugfix-mannequin-db_ltr.gif){kind=small}
![PraDevil[ELITE]'s Avatar](https://www.elitepvpers.com/forum/customavatars/avatar1857785_25.gif){kind=avatar}
[RELEASE]Eud SkillBugFix For Mannequin DB
![PraDevil[ELITE] is offline](images/elitepvpers/statusicon/user_offline.gif){kind=small}
