Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Steve Machol
    replied
    Admin CP -> Users -> Prune / Move Users

    Leave a comment:


  • toplisek
    replied
    I have managed to do. Thank you for all help.
    Just this: How can I delete in one way all Spammers inside Spammers group?

    Can be done with QUERY as you posted update.

    Leave a comment:


  • toplisek
    replied
    It works. Thank you for your help.

    lastactivity is unknown.

    What is definition of this? Is this logged time activity, thread activity, posts activity...
    Last edited by toplisek; Fri 24 Jun '11, 6:37am.

    Leave a comment:


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

    Leave a comment:


  • Panzer Max
    replied
    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.

    Leave a comment:


  • toplisek
    replied
    update query in phpMyAdmin:which table and which fields

    Leave a comment:


  • Panzer Max
    replied
    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.

    Leave a comment:


  • Steve Machol
    replied
    Admin CP -> Users -> Prune / Move Users

    Leave a comment:


  • toplisek
    replied
    Is there some more info URL for this prune users ...

    Leave a comment:


  • Loco.M
    replied
    Originally posted by toplisek View Post
    Can be deleted (automatic, periodic) registered users when they do not post any content after 3 weeks?
    yes you can prune users

    Leave a comment:


  • Trevor Hannant
    replied
    Yes.

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

    Leave a comment:


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

    Leave a comment:


  • beishe8
    replied
    Originally posted by toplisek View Post
    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.

    Leave a comment:


  • josiah
    replied
    What language is your forum using ?

    Leave a comment:


  • toplisek
    replied
    You mean manually all the time?

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

    Leave a comment:

widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X