Small pally prob with manniquen DB

[joey123321]

ok so i have a small issue with the pallys on the new manniquen server like when they change their class from warrior or something to pally theres no soul for them any way to fix it?

[commandcom]

umm i did look theres 2 place where you need to update value to make soul work
it need to update soul and soul_value field in cq_user i tried here different tricks but i dont have time atm to mess with it look at id 3500546 in cq_action field param is soul_value += 1000
but need to set it to update soul_value field aswell
i will look later as its kinda important thingy

[funhacker]

Originally Posted by commandcom

umm i did look theres 2 place where you need to update value to make soul work
it need to update soul and soul_value field in cq_user i tried here different tricks but i dont have time atm to mess with it look at id 3500546 in cq_action field param is soul_value += 1000
but need to set it to update soul_value field aswell
i will look later as its kinda important thingy

sorry thats wrong,

you need to have it edit the soul_value_lev as this is what allows them to have the soul in the first place, one way would be to edit levels another would be via the database itself ACME just runs an SQL script every 30minutes to update any paladins with lvl0 soul

[commandcom]

yea right i got that allready but no idea how to execute it in cq_action
i did add aditional fields to update all these 3 value but still doesnt work good
maybe its better way to do it via website then character is offline and can edit these values

[commandcom]

yea right i got that allready but no idea how to execute it in cq_action
i did add aditional fields to update all these 3 value but still doesnt work good
maybe its better way to do it via website then character is offline and can edit these values

[Necron33]

Well,follow funhacker's words Just run a sql script,for me I'm writing a PHP script so one click query done,lol.