Announcement

Collapse
No announcement yet.

how do I delete a mass amount of users off a vbulletin board at once?

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

  • how do I delete a mass amount of users off a vbulletin board at once?

    I'm trying to help my friend to delete all zero posters (around 400) off her board,how do I do this...we've been trying for 2 days...

  • #2
    Try to search in these forums.

    Or use a sql query like this (e.g. in phpmyadmin)
    Code:
    delete from user WHERE POSTS = 0 AND lastpost<UNIX_TIMESTAMP('2001-02-01')
    The date is in year-month-day format.

    Comment


    • #3
      o.k...huh?

      Comment


      • #4
        Don't do all that.

        Simply go to your control panel, press the "Prune" link under the "Users" section.

        Make sure "Usergroup" should be "Any"

        Leave "Has not logged on for x days" blank

        Leave "Registered before date: (yyyy-mm-dd format)" blank

        Put a 1 in the "Has less than x posts" section

        then press "find users"

        Comment


        • #5
          lilgreg70 please enter your license information in your profile. See my sig for more info. Thanks!
          Chen Avinadav
          Better to remain silent and be thought a fool than to speak out and remove all doubt.

          גם אני מאוכזב מסיקור תחרות לתור מוטור של NRG הרשת ע"י מעריב

          Comment


          • #6
            what about the userfield table? won't that orphan those records?

            Comment


            • #7
              the delete sql that is

              Comment


              • #8
                Yes, because Prune Users does not take into account any of the other information collected when a user registers.


                Comment

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