What is the possibles values of 'state' column on 'login' table?

[LipESprY 0]

Hello, everyone!!

The title is very explicit: "What is the possibles values of 'state' column on 'login' table?"

-- `login` table
+-----------------+-----------------------+------+-----+---------+----------------+
| Field           | Type                  | Null | Key | Default | Extra          |
+-----------------+-----------------------+------+-----+---------+----------------+
| state           | int(11) unsigned      | NO   |     | 0       |                |
+-----------------+-----------------------+------+-----+---------+----------------+

I know the value 5 for blocked account. This field have more possible values? Which are?

Thanks!

[bWolfie 138]

interesting question. i tried looking through source but couldnt find anything. hope for an answer. not urgent, curious myself is all.

[4144 364]

if state 0, account not banned

if state is non zero, banned. And value (state - 1) will be sent to client in auth error packet.

This mean any non zero values only have any meaning for client.

 

[LipESprY 0]

20 hours ago, Myriad said:

interesting question. i tried looking through source but couldnt find anything. hope for an answer. not urgent, curious myself is all.

Yeah! I've tested @ban, @block, @jail, @mute and the `state` field was altered only for @block with the value 5. I'm using updated version of Hercules (at this time, Hercules v2017.12.17).

 

17 hours ago, 4144 said:

if state 0, account not banned

if state is non zero, banned. And value (state - 1) will be sent to client in auth error packet.

This mean any non zero values only have any meaning for client.

 

Wtf?! It was so easy. I've tried several situations, like I've mentioned above.

Only remembering: On this case, the `state` field value non zero is for blocked accounts. Banned accounts is identify by `unban_time` field on same table. 

Thank you @4144 and @Myriad by your time and reply! That solved my question!