How to convert a (normal) user into an editor using MySQL query?

Question

Please correct my query

UPDATE qa_users SET level =??? WHERE userid =1234;

Thanks.

Answer 1

The levels are defined in the file qa-include/app/users.php. The level for "editor" is 50:

define('QA_USER_LEVEL_EDITOR', 50);

so change your query to this:

UPDATE qa_users SET level = 50 WHERE userid = 1234;