User:Jacknstock

LOL FIRED

LOL FIRED

LOL FIRED

LOL FIRED

LOL FIRED

LOL FIRED

LOL FIRED

mysql> select u.user_name, u.user_id, ur.ur_rights, ug.ug_group from user_rights as ur, user as u, user_groups as ug where
      ur.ur_user=u.user_id and ug.ug_user=u.user_id and u.user_name = 'Jacknstock';
+------------+---------+-----------+-----------+
| user_name  | user_id | ur_rights | ug_group  |
+------------+---------+-----------+-----------+
| Jacknstock |     212 | sysop     | checkuser |
| Jacknstock |     212 | sysop     | sysop     |
+------------+---------+-----------+-----------+
2 rows in set (0.00 sec)



mysql> update user_rights SET ur_rights='' WHERE ur_user = 212;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0


mysql> delete from user_groups where ug_user = 212;
Query OK, 2 rows affected (0.02 sec)