Announcement

Collapse
No announcement yet.

Resetting Post Count...

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

  • Resetting Post Count...

    How the heck do i reset the post counts for all users? need to set to zero to start over.

    Thanks

  • #2
    You can run this query:

    UPDATE user SET posts = 0;
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment


    • #3
      weird.. says i am not authorized to run the query.. yet i am listing as super admin in the config.php file...

      Comment


      • #4
        To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

        // ****** USERS WITH QUERY RUNNING PERMISSIONS ******
        // The users specified here will be allowed to run queries from the control panel.
        // See the above entries for more information on the format.
        // Please note that the ability to run queries is quite powerful. You may wish
        // to remove all user IDs from this list for security reasons.
        $canrunqueries = 'x';

        ...with x being your userid number.
        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


        • #5
          ahhh, cool.

          Thanks!

          Now, any shot you can fix my next problem.... I have a ton of posts dated 12-31-1969 or something like that.. from an import...need to get rid of all those...

          how?

          demo of my forum to see is forums.fanhost.com/index.php

          Comment


          • #6
            Please follow the 'After the Import' instructions here:

            http://www.vbulletin.com/docs/html/i...rsion=30501500

            This should solve those issues.
            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


            • #7
              followed it perfectly.. nothing..

              still have the same issues.

              Comment


              • #8
                What did you import from? You may have to redo the import to fix this.
                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


                • #9
                  ubb... i did it the hard way and just deleted the posts manually.

                  Comment

                  Loading...
                  Working...
                  X