Can be deleted registered users when they do not post any content after 3 weeks?

[toplisek]

Can be deleted (automatic, periodic) registered users when they do not post any content after 3 weeks?

[josiah]

You can find users who have not posted for a set period ....


admincp > users > search for users > advanced search > last post is ?

[toplisek]

You mean manually all the time?

I have issue with SPAM from Africa to Russia (1000 registered user within one month period).

[josiah]

What language is your forum using ?

[beishe8]

I have issue with SPAM from Africa to Russia (1000 registered user within one month period).

Use questions and answers,it will stop them from registering.

[toplisek]

questions and answers...
You mean pre-registered ANTI spam questions?

[Trevor Hannant]

Yes.

https://www.vbulletin.com/docs/html/...n-verification

[Loco.M]

Can be deleted (automatic, periodic) registered users when they do not post any content after 3 weeks?

yes you can prune users

[toplisek]

Is there some more info URL for this prune users ...

[Steve Machol]

Admin CP -> Users -> Prune / Move Users

[Panzer Max]

You can use an update query in phpMyAdmin to move users with 0 posts and who joined before a certain date to a spammer usergroup, then use the ACP>Move/Prune Users to delete them.

[toplisek]

update query in phpMyAdmin:which table and which fields

[Panzer Max]

Table user.

Be sure to do an SQL dump or back up of your db, BEFORE messing with it. If you can make a copy of the db as a TEST_DB, and practice on it first, even better.
First, you need to make a new Spammer usergroup in your ACP, and give it no permission to post or have signatures. When it is created, it should show you the usergroupid number on the right side, a drop down item that says Edit usergroup id:### V Go


Then run a SELECT query and see what the results are, to ensure you are culling the right bunch. This will not change any data, just present it:

SELECT userid, username, usergroupid, homepage, posts, joindate, lastactivity
FROM user
WHERE usergroupid=2 usergroupid 2 is the normal Registered Users group, check in your ACP>Usergroup Manager
AND joindate <1298937600 (before Mar 1 2011)
AND lastactivity - joindate < 1814400 (no activity since 21 days after joining)
AND posts < 3

If you are happy, you can move them to the spammer group with this UPDATE query:

UPDATE user SET usergroupid=999 whatever your SPAM usergropid number is, check in your ACP>Usergroup Manager
WHERE usergroupid=2
AND joindate <1298937600
AND lastactivity - joindate < 1814400
AND posts < 3


Now, all those spammers are in your Spammer usergroup. You can go into ACP>Move/Prune users and delete them. I suggest deleting in batches of ~200.

[toplisek]

Thanks for all details. Will test when I'm ready for this. there are many tasks. Is this improved inside V4?

[toplisek]

It works. Thank you for your help.

lastactivity is unknown.

What is definition of this? Is this logged time activity, thread activity, posts activity...