forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: wardsweb on February 02, 2015, 03:51:38 am

Title: How to delete 8916 pages of spam users.
Post by: wardsweb on February 02, 2015, 03:51:38 am

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?

Title: Re: How to delete 8916 pages of spam users.
Post by: allvip on February 02, 2015, 04:43:09 am

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).

Title: Re: How to delete 8916 pages of spam users.
Post by: wardsweb on February 02, 2015, 04:54:16 am

That will wor, delete all users except the admin.

Title: Re: How to delete 8916 pages of spam users.
Post by: allvip on February 02, 2015, 05:01:43 am

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

Code: [Select]

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.

Title: Re: How to delete 8916 pages of spam users.
Post by: wardsweb on February 02, 2015, 05:26:29 am

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.

Title: Re: How to delete 8916 pages of spam users.
Post by: allvip on February 02, 2015, 05:32:28 am

Click Topic solved if you are ok with the solution.