Having Problems With Soul Box

[dominicsott2003]

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

[ProSkyZ]

Thats not Soulbox problem its Soul Problem ...Idk a way to fix it .
Sorry

[dominicsott2003]

sry for the mistake and thanks for letting me no what it was

[funhacker]

Originally Posted by dominicsott2003

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

[dominicsott2003]

Originally Posted by funhacker

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

[funhacker]

Originally Posted by dominicsott2003

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

[chathouse]

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

[pimpjuc]

Hey bro heres a couple ways i fixed that issue
1. this is my original update script

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-

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

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

[chathouse]

little Update for between rooms.

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

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

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);