Soul 0/0 :/

05/25/2010 20:51 WickedSweet#1

is there a way or a query i can run to fix this issue were paladin players are haveing no soul it shows as 0/0 and they cant even use soul boxes. ty

05/25/2010 21:06 Eurion#2

This should rectify the issue. Just run it as a mysql query. It should update the users soul_value_lev correctly based on their level. Once you run it, they should only have to relog.

Code:

                  UPDATE cq_user SET soul_value_lev='1' WHERE level > 1 AND level < 50;
		  UPDATE cq_user SET soul_value_lev='2' WHERE level > 49 AND level < 70;
		  UPDATE cq_user SET soul_value_lev='3' WHERE level > 69 AND level < 90;
		  UPDATE cq_user SET soul_value_lev='4' WHERE level > 89 AND level < 100;
		  UPDATE cq_user SET soul_value_lev='5' WHERE level > 99 AND level < 110;
		  UPDATE cq_user SET soul_value_lev='6' WHERE level > 109 AND level < 120;
		  UPDATE cq_user SET soul_value_lev='7' WHERE level > 119 AND level < 125;
		  UPDATE cq_user SET soul_value_lev='8' WHERE level > 124 AND level < 130;
		  UPDATE cq_user SET soul_value_lev='9' WHERE level > 129;

05/25/2010 21:13 WickedSweet#3

ty very much bro worked great

05/26/2010 00:29 .Ash#4

Why not try searching?? its already been answered..

[Only registered and activated users can see links. Click Here To Register...]

05/26/2010 01:03 Eurion#5

Your solution doesn't fix this issue. The issue comes to light while changing classes, without updating the soul_value_lev, even if you do go into the database and add soul, it will not allow a player to gain soul/use soul boxes. That is why I gave him my query written up.

It will update the character tables based on level just as if they were true pallys.