I have a guild on my server whos gp goes - when i edit it goes back into -
anyway to stop this ?
I have a guild on my server whos gp goes - when i edit it goes back into -
anyway to stop this ?
yeah i ve Got the same Problem
I Guess reason is High Exp rate
when anyone Know hot to fix that pls share with us
THX
Low info for me.. can upload more info? Ty..
mmh
kay see
User have a Guild Created and after some Mutch Time with Mutch Guild member
Going the Guild Ponits going in minus like This -xxxxxxx
and when i fix it with a Char have mutch sp points and i spend it to the Guild
is Going up and minus Gone after some time stay Guildpoints again in minus
idk what more information you will need to help us fix the problem
Best regards
anyone have a idea with the Guild GP go into Negative =?
That is due to a Data Type overflow.
SHARD -> _Guild -> GatheredSP datatype is an INT value.
If the Guild GP goes more than 2147483647 you will get that - error.
SQL Server Max Int Value
How to fix it?
Use the SMC to restore the negative guild points. (Server have to be "out of service" in order to be able to edit it).
How to prevent it?
1.- If I remember well, there is an SP that manages the incoming GP, just play a bit there.
2.- Make some kind of manual query to control it every time you reset the server.
3.- Make a triger for preventing the update of that column if the total GP is over the INT max value.
Its up to you. Have fun.
thnx maybe thats helpOriginally Posted by valcro
another way, reduce them ^^
use SRO_VT_SHARD_INT
Update _Guild
set GatheredSP = 'New Guild SP here'
where GatheredSP >= '2147483647 '
Another way , make a char fill it with sp's , join that guild and then donate the points that show on " - " status and then the points will be normal again :)
Reply With Quote