Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Eudemons Online > EO PServer Hosting
You last visited: Today at 23:50

  • Please register to post and access all features, it's quick, easy and FREE!


Having Problems With Soul Box

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2009
Posts: 102
Received Thanks: 40
Having Problems With Soul Box

Please if anyone knows how to fix the soul box when u change from a warrior or mage to a pallidine can u pleas post it here. An thank u for helping



dominicsott2003 is offline  
Old 09/16/2009, 15:18   #2
 
elite*gold: 0
Join Date: Sep 2009
Posts: 156
Received Thanks: 50
Thats not Soulbox problem its Soul Problem ...Idk a way to fix it .
Sorry


ProSkyZ is offline  
Thanks
1 User
Old 09/16/2009, 15:34   #3
 
elite*gold: 0
Join Date: Jan 2009
Posts: 102
Received Thanks: 40
sry for the mistake and thanks for letting me no what it was
dominicsott2003 is offline  
Old 09/17/2009, 08:58   #4
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,695
Quote:
Originally Posted by dominicsott2003 View Post
Please if anyone knows how to fix the soul box when u change from a warrior or mage to a pallidine can u pleas post it here. An thank u for helping
This is because when you change the class from warrior to paladin your soul_lev is not set so you must set it. Not sure if the cq_action type 1001 will edit the soul_lev


funhacker is offline  
Thanks
2 Users
Old 09/17/2009, 14:06   #5
 
elite*gold: 0
Join Date: Jan 2009
Posts: 102
Received Thanks: 40
Quote:
Originally Posted by funhacker View Post
This is because when you change the class from warrior to paladin your soul_lev is not set so you must set it. Not sure if the cq_action type 1001 will edit the soul_lev
anyway u can put the edit on here for me i am new to this and havnt figured it quite out yet thanks for the help
dominicsott2003 is offline  
Old 09/17/2009, 15:09   #6
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,695
Quote:
Originally Posted by dominicsott2003 View Post
anyway u can put the edit on here for me i am new to this and havnt figured it quite out yet thanks for the help
Well I made a scheduled script that would update the cq_user every 30minutes. But I suggest you write your own it's the best way to learn.

Linking tables: cq_user cq_soul_value_lev

Table field links (fields that link the 2 tables) : cq_user.level cq_soul_value_lev.req_lev

Field to edit: cq_user.soul_lev
Field value: = cq_soul_value_lev.soul_lev
funhacker is offline  
Thanks
1 User
Old 02/24/2011, 17:55   #7
 
elite*gold: 0
Join Date: Dec 2009
Posts: 220
Received Thanks: 59
Code:
SELECT
cq_user.`level`,
cq_soul_value_lev.req_lev
FROM
cq_soul_value_lev ,
cq_user
The selection of works now, but I guess I've forgotten something for Entry into the cq_user.soul_value_lev.

Can anyone help me as yet or add the last missing piece? thank you



chathouse is offline  
Old 02/27/2011, 03:40   #8
 
elite*gold: 0
Join Date: Sep 2008
Posts: 78
Received Thanks: 71
Hey bro heres a couple ways i fixed that issue
1. this is my original update script
Code:
UPDATE cq_user SET soul_value_lev=22 WHERE profession=30 and soul_value_lev=0 and level=255;

UPDATE cq_user SET soul_value_lev=21 WHERE profession=30 and soul_value_lev=0 and level=250;

UPDATE cq_user SET soul_value_lev=20 WHERE profession=30 and soul_value_lev=0 and level=240;

UPDATE cq_user SET soul_value_lev=19 WHERE profession=30 and soul_value_lev=0 and level=230;

UPDATE cq_user SET soul_value_lev=18 WHERE profession=30 and soul_value_lev=0 and level=220;

UPDATE cq_user SET soul_value_lev=17 WHERE profession=30 and soul_value_lev=0 and level=210;

UPDATE cq_user SET soul_value_lev=16 WHERE profession=30 and soul_value_lev=0 and level=200;

UPDATE cq_user SET soul_value_lev=15 WHERE profession=30 and soul_value_lev=0 and level=190;

UPDATE cq_user SET soul_value_lev=14 WHERE profession=30 and soul_value_lev=0 and level=180;

UPDATE cq_user SET soul_value_lev=13 WHERE profession=30 and soul_value_lev=0 and level=170;

UPDATE cq_user SET soul_value_lev=12 WHERE profession=30 and soul_value_lev=0 and level=160;

UPDATE cq_user SET soul_value_lev=11 WHERE profession=30 and soul_value_lev=0 and level=150;

UPDATE cq_user SET soul_value_lev=10 WHERE profession=30 and soul_value_lev=0 and level=140;

UPDATE cq_user SET soul_value_lev=9 WHERE profession=30 and soul_value_lev=0 and level=130;

UPDATE cq_user SET soul_value=100000 WHERE profession=30 and soul_value=0;
this sets levels etc correctly.
Next can be added to the classchange potion and TQ baby
2. this is an actual fix from a chinese forum you need to find the last line of the paladin change class script
ie-
Code:
INSERT INTO cq_action
   (`Id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (9996963, 0000 9996960, 0125, 2011, 'Congratulations,%user_name~transfered~paladin~successfully!~Let~us~cheer~for~him!!!');
you want to add this next line which in fact uses type 1001
Code:
INSERT INTO cq_action
   (`Id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
   (9996960, 0000, 0000, 1001, 0, 'soul + = 400');
when adding to last line of normal script add this lines id to id_nextfail not id_next
hope this helps ya
pimpjuc is offline  
Thanks
3 Users
Old 02/27/2011, 11:50   #9
 
elite*gold: 0
Join Date: Dec 2009
Posts: 220
Received Thanks: 59
little Update for between rooms.

Example: value_lev_1 || greater is than ">=1" | less than "<50" (CharLevel 2 - 49)

Code:
UPDATE cq_user SET soul_value_lev=1 WHERE level >=1 AND level <50 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=2 WHERE level >=50 AND level <70 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=3 WHERE level >=70 AND level <90 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=4 WHERE level >=90 AND level <100 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=5 WHERE level >=100 AND level <110 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=6 WHERE level >=110 AND level <120 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=7 WHERE level >=120 AND level <125 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=8 WHERE level >=125 AND level <130 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=9 WHERE level >=130 AND level <140 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=10 WHERE level >=140 AND level <150 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=11 WHERE level >=150 AND level <160 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=12 WHERE level >=160 AND level <170 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=13 WHERE level >=170 AND level <180 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=14 WHERE level >=180 AND level <190 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=15 WHERE level >=190 AND level <200 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=16 WHERE level >=200 AND level <210 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=17 WHERE level >=210 AND level <220 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=18 WHERE level >=220 AND level <230 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=19 WHERE level >=230 AND level <240 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=20 WHERE level >=240 AND level <250 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=21 WHERE level >=250 AND level <255 and profession=30 and soul_value_lev=0;

UPDATE cq_user SET soul_value_lev=22 WHERE profession=30 and soul_value_lev=0 and level=255;

UPDATE cq_user SET soul_value=100000 WHERE profession=30 and soul_value=0;
The adjustment for the New_Soulslvl255.sql

Code:
INSERT INTO `cq_soul_value_lev` VALUES (0001, 1, 1, 30000);
INSERT INTO `cq_soul_value_lev` VALUES (0002, 2, 50, 45000);
INSERT INTO `cq_soul_value_lev` VALUES (0003, 3, 70, 60000);
INSERT INTO `cq_soul_value_lev` VALUES (0004, 4, 90, 75000);
INSERT INTO `cq_soul_value_lev` VALUES (0005, 5, 100, 90000);
INSERT INTO `cq_soul_value_lev` VALUES (0006, 6, 110, 105000);
INSERT INTO `cq_soul_value_lev` VALUES (0007, 7, 120, 120000);
INSERT INTO `cq_soul_value_lev` VALUES (0008, 8, 125, 150000);
INSERT INTO `cq_soul_value_lev` VALUES (0009, 9, 130, 180000);
INSERT INTO `cq_soul_value_lev` VALUES (0010, 10, 140, 200000);
INSERT INTO `cq_soul_value_lev` VALUES (0011, 11, 150, 300000);
INSERT INTO `cq_soul_value_lev` VALUES (0012, 12, 160, 400000);
INSERT INTO `cq_soul_value_lev` VALUES (0013, 13, 170, 500000);
INSERT INTO `cq_soul_value_lev` VALUES (0014, 14, 180, 600000);
INSERT INTO `cq_soul_value_lev` VALUES (0015, 15, 190, 700000);
INSERT INTO `cq_soul_value_lev` VALUES (0016, 16, 200, 1000000);
INSERT INTO `cq_soul_value_lev` VALUES (0017, 17, 210, 1100000);
INSERT INTO `cq_soul_value_lev` VALUES (0018, 18, 220, 1200000);
INSERT INTO `cq_soul_value_lev` VALUES (0019, 19, 230, 1300000);
INSERT INTO `cq_soul_value_lev` VALUES (0020, 20, 240, 1400000);
INSERT INTO `cq_soul_value_lev` VALUES (0021, 21, 250, 1500000);
INSERT INTO `cq_soul_value_lev` VALUES (0022, 22, 255, 5000000);


chathouse is offline  
Thanks
1 User
Reply



« [New Server] Demons Brazuka | [New Server] Leaguo EO new Server »

Similar Threads
Soul Spear Soul Bug(SWSRO?)
08/25/2010 - SRO PServer Ask the Experts - 4 Replies
uh hi is there like another media pk2 for my bugged soul spear soul move. cuz the second attack does not work with the original
SjSRO / Soul Spear Soul Lv58 Skill Edit Lv76.
11/11/2009 - SRO PServer Guides & Releases - 3 Replies
Hi All . This My First PK2 Edition :) . I Think Some people so bored Old SkillS :) Soul Spear Soul And Soul Spear Emperor http://img14.imageshack.us/img14/3676/lv58.jpg>>>Changed>>>http://img14.imageshack.us/img14/2765/lv76.jpg DataPK2 http://img245.imageshack.us/img245/1067/dgrtvsjpg.gif
[SibiBOT] Soul Spear - Soul bug
06/20/2009 - SRO PServer Ask the Experts - 11 Replies
I botting my char which is glavie, so of course I have Soul spear skills... Im was botting with Soul Spear - Soul from 58, now when i reach 71 and upgrade it to lv 7 bot dont want to find it...When it was lv 6 bot found it... U experts maybe now whats wrong with that? Thank you for answers and bye!
sibi bot soul spear soul
06/10/2009 - SRO PServer Ask the Experts - 8 Replies
Hi , i just lvled up my soul spear soul to lvl 7 , and now my skill is gone from the list do any1 know a fix for this or do i have to live whit that?
[Problems]Having problems in Cabal Wudijt
07/01/2008 - Cabal Main - Discussions / Questions - 0 Replies
1>im having problems in registering in Wudijt can anyone help me give me working link 2>i cant seem to update my red cabal online is it offline? 3>when i load Cabal.exe the cabal window will just dissapear please help me,i followed everyone's advice but it doesnt work, can anyone tell me what the real problem? thanks! ^_^



All times are GMT +1. The time now is 23:50.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.