How To Fix Negative Stats On Website (All Websites Packages)
Open query analyzer and select MuOnline database
and run query
PHP Code:
ALTER TABLE character ALTER COLUMN Strength int
ALTER TABLE character ALTER COLUMN Dexterity int
ALTER TABLE character ALTER COLUMN Vitality int
ALTER TABLE character ALTER COLUMN Energy int
ALTER TABLE character ALTER COLUMN Leadership int
I didn't test it, but i'm sure will work :)
NOTE: There will be no data lose after this query, if u don't trsut then make a backup
Re: How To Fix Negative Stats On Website (All Websites Packages)
Re: How To Fix Negative Stats On Website (All Websites Packages)
this wont work because negative stats is not db problem,is located in ds/gs.
Even if your column is bigint and support huge numbers it wont show the 65k number in a positive form because at read ds->gs->ds it convert in negative number so the fix will be:
Code:
maximum number + actual negative number = real positive number
in this case
Code:
65535 + (-1535) = 64000
