How to delete all banned accounts [MySQL]
#2

The first query will delete the user completely.. What you need is to UPDATE users and set the column to not banned.

So basically, an example:
pawn Код:
UPDATE users SET banned=0 WHERE banned=1;
DELETE FROM banusers;
The first query depends on your table structure.
Reply


Messages In This Thread
How to delete all banned accounts [MySQL] - by GospodinX - 09.07.2018, 18:40
Re: How to delete all banned accounts [MySQL] - by Calisthenics - 09.07.2018, 18:44
Re: How to delete all banned accounts [MySQL] - by GospodinX - 09.07.2018, 18:46
Re: How to delete all banned accounts [MySQL] - by Calisthenics - 09.07.2018, 18:54

Forum Jump:


Users browsing this thread: 2 Guest(s)