View Single Post
  #3  
Old 11-12-2002, 09:01 AM
Xarslik
Hill Giant
 
Join Date: Oct 2002
Location: System.Web
Posts: 107
Default

Easy, SystemShark.

I had the exact same problem, this is due to a bug in the db.sql file.

Run mysql.exe, "use eq" or whatever your DB may be, and enter this:

Code:
alter table account modify status int(5) not null default '0';
Then try and set your status again.

The problem lies in the fact that right now your status column is a signed byte(3) meaning it supports values of -128 to 127, instead of being unsigned (0 - 255). The above line sets it to an int, allowing 255 and greater status, while still allowing negative for the ban and suspended status.
__________________
~ Xarslik
[ Xarslik's Arena Challenge Server ]
Reply With Quote