Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+7 votes
1.9k views
in Q2A Core by
In the MySQL database, qa_users table, there is a "Flags" field with a number assigned to each user. My database has users with 0, 1, 4, and 5. What does this mean? Does it have to do with their access or if they've confirmed their email?
Q2A version: 1.5.4

2 Answers

+1 vote
by

Nice question. The meaning of flags is defined in qa-include/qa-app-users.php with binary(bit). In the case of test, I change direct flags in command-line or phpMyAdmin of MySQL. The specific field (related password) in the qa_users table is binary. When you change flags in phpMyAdmin, you must never use GUI for editing specific record. You have to change it by UPDATE phrase. If you change flags of specific record by phpMyAdmin GUI, password hash will be broken, and, user can't log in to your site.

+2 votes
by
Once I was dealing with flags as well and wrote a small tutorial in this answer:

http://www.question2answer.org/qa/16098/how-to-find-flag-qa_user_flags_user_blocked-from-user-flag?show=16102#a16102

This will let you understand the system of binary flags.
...