Register for your free account! | Forgot your password?

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

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


Having Problems With Soul Box

Discussion on Having Problems With Soul Box within the EO PServer Hosting forum part of the Eudemons Online category.

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,710
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,710
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: 72
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 00:39.


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

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2019 elitepvpers All Rights Reserved.