How to delete 8916 pages of spam users.

[wardsweb]

Even with my registration turned off, hackers managed to register 8916 pages of users yesterday. I have upgraded the gallery today to the latest version. How do I do a mass delete, instead of one page at a time for almost 9000 pages?

[allvip]

If you want to delete all users is very simple.
Let me know if you want to delete all users and keep only you (the admin users).

[wardsweb]

That will wor, delete all users except the admin.

[allvip]

Open your_gallery_folder/include/init.inc.php and paste at the end after }

Code Select Expand

cpg_db_query("DELETE FROM {$CONFIG['TABLE_USERS']} WHERE user_group = '2' AND user_regdate < NOW() - INTERVAL 1 HOUR");


then refresh users page

You shoul have all users delete but not the admin and users registred in the last hour.

Go back to init.inc.php and delete the code.

[wardsweb]

I did as instructed. It deleted all but the original first page of users (21 users). It did delete test, but I have added it back in.

[allvip]

Click Topic solved if you are ok with the solution.