Forums

Unfortunately no one can be told what FluxBB is - you have to see it for yourself.

You are not logged in.

#1 2012-08-23 02:16:50

partikule
Member
From: France, Paris
Registered: 2012-08-22
Posts: 7
Website

Maintenance : Clean and delete inactive / spam users

After few month, you will certainly notice that some registered users never post anything or simply never logged in.
Many reasons to that :
1. These users can be humans, but generally, if one human register to your forum, he will at least post one time.
2. These users can be fake users generated by spam bots (If you activated "Verify registrations", the user has to use the password he got from the forum. Most of the lazy spammers will use a fake email address and never receive the password, so never be able to post anything)

Anyway, lets say you have dozen of inactive users and you want to "clean" your users table :

1. Make a backup of your users table,
2. If you don't do the point 1, do not go further,
3. Have a look at the number of iinactive users :

select id, username, DATEDIFF(now(), from_unixtime(last_visit)) as days 
from users
where num_posts = 0
 -- exclude the "Guest" user
and id != 1
 -- Inactive since more than 90 days
and DATEDIFF(now(), from_unixtime(last_visit)) > 90
order by days ASC;

4. Delete the inactive users

delete from users 
where num_posts = 0
and id != 1 -- exclude the "Guest" user
and DATEDIFF(now(), from_unixtime(last_visit)) > 90;

5. To see the new number of users on the bottom of your board index, delete the file /cache/cache_users_info.php

Tested and validated on 1.5.0.

Last edited by partikule (2012-08-23 02:25:18)


Partikule, Agence web à Paris : http://www.partikule.net
Créateur de Ionize CMS : http://www.ionizecms.com
Forum : http://www.ionizecms.com/forum

Offline

#2 2012-08-23 08:31:50

Franz
Lead developer
From: Germany
Registered: 2008-05-13
Posts: 6,719
Website

Re: Maintenance : Clean and delete inactive / spam users

Thank you. Stickied.


fluxbb.de | develoPHP

"As code is more often read than written it's really important to write clean code."

Offline

#3 2012-08-24 22:21:11

Studio384
Former Developer
From: Belgium
Registered: 2012-04-11
Posts: 681
Website

Re: Maintenance : Clean and delete inactive / spam users

Great help for my forum! Thanks!

Offline

#4 2012-09-09 13:20:58

partikule
Member
From: France, Paris
Registered: 2012-08-22
Posts: 7
Website

Re: Maintenance : Clean and delete inactive / spam users

@Studio384 : Thanks !
The next post will be on how detect and delete spam users and their linked post...
Like "cs55slb55i" and his post .... wink


Partikule, Agence web à Paris : http://www.partikule.net
Créateur de Ionize CMS : http://www.ionizecms.com
Forum : http://www.ionizecms.com/forum

Offline

#5 2012-09-12 07:23:50

Jack
Member
Registered: 2010-12-24
Posts: 485
Website

Re: Maintenance : Clean and delete inactive / spam users

Very useful, has it the same behaviour with older version (such as 1.4.2)?

[I reply by myself: yes]

Last edited by Jack (2013-11-19 22:31:10)


Sorry I don't speak English smile
FluxBB Italy

Offline

#6 2017-01-25 22:22:55

Mo
Member
From: Missouri - USA
Registered: 2017-01-25
Posts: 14
Website

Re: Maintenance : Clean and delete inactive / spam users

Pretty cool you can do actions like this.  Now I just have to figure out what that code is and how to actually use it.  I'm guessing its php but I have no idea right now.  I have 90 days to figure it out I guess.  Right now I just keep a list of who is who in my forum and I'm always checking the profiles of new users to see if its a spam bot or other nasty.


Working hard at doing stuff I don't know how to do.

Offline

#7 2018-03-28 14:44:38

m88web
New member
Registered: 2018-03-28
Posts: 1

Re: Maintenance : Clean and delete inactive / spam users

How to enable capcha for register new account to protect machine spam?

Offline

#8 2018-03-28 15:14:23

Bryan256
Member
Registered: 2017-12-13
Posts: 34

Re: Maintenance : Clean and delete inactive / spam users

You need to install some kind of captcha mod or plugin, there seem to be many:
Topics with posts containing 'captcha'
=========================================

https://fluxbb.org/forums/viewtopic.php?id=7995
===================================
https://fluxbb.org/resources/mods/real-register-captcha

I don't use a captcha myself, so am not sure which ones works best.

Offline

Board footer

Powered by FluxBB