EQEmulator Forums - Problems Setting Flag.

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)

- - Problems Setting Flag. (https://www.eqemulator.org/forums/showthread.php?t=3845)

SystemShark

11-12-2002 05:32 AM

Problems Setting Flag.

I've been talking with people in the MIRC chat and even though they were super nice in trying to help me with my Flag problems, still not working.

I need to set my account to ServerOP status. Ive done it through DOS, through msql, through FQadmin, through MySqlFront.. nothing. When I flag my account to 255, reguardless of how I do it, I can only reach 127 status..which is *GM*, limiting the abilities I should have as the admin hosting the server.

I tried making a new account but still only 127. If anyone has any ideas on how to help please post! Thanks. =)

_SystemShark
[MHz Core Server]

tamarae

11-12-2002 06:10 AM

Just outta curiosity, why 255? 200 will give you all of the commands.

Xarslik

11-12-2002 09:01 AM

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.

SystemShark

11-13-2002 12:18 AM

Thanks for the help. I had someone in the irc log in and change the file to help me out.

I did 255 because its higher, duh... IM SERVER OP!! UBAH!! =p

Thanks again. Safe hunting all.

_SystemShark
[MHz Core]

All times are GMT -4. The time now is 01:24 PM.