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

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

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

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


    admincp > users > search for users > advanced search > last post is ?
    <<<<<<<<< It is over there !

    Comment


    • #3
      You mean manually all the time?

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

      Comment


      • #4
        What language is your forum using ?
        <<<<<<<<< It is over there !

        Comment


        • #5
          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.


          vB5 is unequivocally the best forum software, but not yet...

          Comment


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

            Comment


            • #8
              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
              -- Web Developer for hire
              ---Online Marketing Tools and Articles

              Comment


              • #9
                Is there some more info URL for this prune users ...

                Comment


                • #10
                  Admin CP -> Users -> Prune / Move Users
                  Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                  Change CKEditor Colors to Match Style (for 4.1.4 and above)

                  Steve Machol Photography


                  Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                  Comment


                  • #11
                    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.

                    Comment


                    • #12
                      update query in phpMyAdmin:which table and which fields

                      Comment


                      • #13
                        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.

                        Comment


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

                          Comment


                          • #15
                            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.

                            Comment

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