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?
Small pally prob with manniquen DB
12/11/2008 05:17
joey123321#1
12/11/2008 16:14
commandcom#2
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 ;)
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 ;)
12/12/2008 09:01
funhacker#3
sorry thats wrong,Quote:
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 ;)
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
12/12/2008 16:21
commandcom#4
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
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
12/12/2008 16:21
commandcom#5
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
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
12/12/2008 20:49
Necron33#6
Well,follow funhacker's words Just run a sql script,for me I'm writing a PHP script so one click query done,lol.