Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: How to delete 8916 pages of spam users.  (Read 2592 times)

0 Members and 1 Guest are viewing this topic.

wardsweb

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 21
How to delete 8916 pages of spam users.
« 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?
Logged

allvip

  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Posts: 1362
Re: How to delete 8916 pages of spam users.
« Reply #1 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).
Logged

wardsweb

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 21
Re: How to delete 8916 pages of spam users.
« Reply #2 on: February 02, 2015, 04:54:16 am »

That will wor, delete all users except the admin.
Logged

allvip

  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Posts: 1362
Re: How to delete 8916 pages of spam users.
« Reply #3 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.
Logged

wardsweb

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 21
Re: How to delete 8916 pages of spam users.
« Reply #4 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.
Logged

allvip

  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Posts: 1362
Re: How to delete 8916 pages of spam users.
« Reply #5 on: February 02, 2015, 05:32:28 am »

Click Topic solved if you are ok with the solution.
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 20 queries.