Jump to content
  • 0
LipESprY

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

Question

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! :D

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0

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

Share this post


Link to post
Share on other sites
  • 1

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.

 

Share this post


Link to post
Share on other sites
  • 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!

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.