Y YungJedi Active member Aug 6, 2018 #1 Hello everyone, I have a little oucis my forum and maintenance for cause update and I delete my administrator account before creating a new account, now I have more focus forum nor the panel aurriez you a solution ? thank you
Hello everyone, I have a little oucis my forum and maintenance for cause update and I delete my administrator account before creating a new account, now I have more focus forum nor the panel aurriez you a solution ? thank you
Y YungJedi Active member Aug 6, 2018 #2 https://xenforo.com/community/threa...min-password-through-mysql.20494/#post-262022 I followed this topic, but the user I changed did not focus on the entire panel Upvote 0 Downvote
https://xenforo.com/community/threa...min-password-through-mysql.20494/#post-262022 I followed this topic, but the user I changed did not focus on the entire panel
S S Thomas Well-known member Aug 6, 2018 #3 Does your user still exist? If not, create a new user and get the user id. Otherwise, get the user id of your old account. And then run these: SQL: UPDATE `xf_user` SET is_admin = 1 WHERE user_id = X; DELETE FROM `xf_admin` WHERE user_id = X; INSERT INTO `xf_admin` VALUES (X, 0x33, '1533331576', NULL, '0', '1'); Replace X with the user_id. This will give you super admin privileges. Upvote 0 Downvote
Does your user still exist? If not, create a new user and get the user id. Otherwise, get the user id of your old account. And then run these: SQL: UPDATE `xf_user` SET is_admin = 1 WHERE user_id = X; DELETE FROM `xf_admin` WHERE user_id = X; INSERT INTO `xf_admin` VALUES (X, 0x33, '1533331576', NULL, '0', '1'); Replace X with the user_id. This will give you super admin privileges.
