Announcement

Collapse
No announcement yet.

Reset poll

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

  • Reset poll

    Hello

    I started a poll on my forum but the members came up with quite a few new listings for the poll

    6 people voted but I want to clear all votes and allow the people who aleady voted to re vote

    How do I do this??

    Thanks
    PLEASE VISIT US HERE. THANKS IN ADVANCE

  • #2
    There is no way of doing this, except perhaps by modifying the database directly. It would be easier just to start a new poll.
    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


    • #3
      Oh no

      This poll is huge
      PLEASE VISIT US HERE. THANKS IN ADVANCE

      Comment


      • #4
        Then modify the database directly.
        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
          How do I do that steve??
          PLEASE VISIT US HERE. THANKS IN ADVANCE

          Comment


          • #6
            You'd have to do this manually, and frankly since I've never done it I hesitate to offer any specific suggestions. You might want to set up a test poll, then go into the database and play with that first. Whatever you do, make a backup of your db first.
            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
              what database do you modify??
              Steve
              Thanks

              I can't belive VB would not let you reset the votes so people could revote

              My God I hope VB3 has this.
              PLEASE VISIT US HERE. THANKS IN ADVANCE

              Comment


              • #8
                The vB database of course. (The one specified in your config.php file.)
                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
                  LOL

                  Sorry I ment to ask what file not database

                  Thanks I will hold off untill I see if anyone has done this before I mess with configphp



                  If anyone knows how to do this it would be appreciated

                  Thanks
                  PLEASE VISIT US HERE. THANKS IN ADVANCE

                  Comment


                  • #10
                    phpMyAdmin --> Click the 'Poll' table (to your left) --> Browse (to your right) --> Click 'Edit' next to the poll you want to reset.

                    If you have 10 options in your poll and your options are 1, 2, 3, 4, 6, 7, 8, 9, 10 your 'options' field would look like

                    1|||2|||3|||4|||5|||6|||7|||8|||9|||10
                    And - your 'votes' field would look like
                    3|||5|||0|||7|||10|||2|||1|||1|||6|||0
                    (depending on which options has certain amouts of votes.

                    I.E. Option '1' would have 3 votes

                    Change your 'votes' field to i.e.
                    0|||0|||0|||0|||0|||0|||0|||0|||0|||0
                    (In other words, all 0's)

                    Next run the following query:

                    DELETE from pollvote WHERE pollvoteid = (Your Poll ID Number Goes Here)

                    Backup Your Database First!

                    Comment


                    • #11
                      Thanks Cary
                      PLEASE VISIT US HERE. THANKS IN ADVANCE

                      Comment


                      • #12
                        Originally posted by Cary
                        phpMyAdmin --> Click the 'Poll' table (to your left) --> Browse (to your right) --> Click 'Edit' next to the poll you want to reset.

                        If you have 10 options in your poll and your options are 1, 2, 3, 4, 6, 7, 8, 9, 10 your 'options' field would look like



                        And - your 'votes' field would look like
                        (depending on which options has certain amouts of votes.

                        I.E. Option '1' would have 3 votes

                        Change your 'votes' field to i.e. (In other words, all 0's)

                        Next run the following query:

                        DELETE from pollvote WHERE pollvoteid = (Your Poll ID Number Goes Here)

                        Backup Your Database First!
                        Cary, that won't work... the query should be:

                        DELETE FROM pollvote WHERE pollid=(poll ID)

                        Comment


                        • #13
                          Originally posted by MUG
                          Cary, that won't work... the query should be:

                          DELETE FROM pollvote WHERE pollid=(poll ID)
                          Thanks for the correction.

                          Comment


                          • #14
                            Just a little update. Although this thread is older, it still works perfectly with vbulletin 4.1. I just did it without a hitch.

                            Plug-in developers take note: there is definitely demand for a simple "reset poll" plugin. Would be easy (I think)

                            Comment

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