Change Vote Ability

As promised a few weeks ago, I finally found some time to make the much needed addition to allow users to change their votes in a poll. After examining the code a bit, I ended up reusing some of the vB code for this ... I hope this isn't a violation of the hacks rules. I read through them, and I think the code re-use is so small and specialized that it will be ok for redistribution via this forum. If it's not, please feel free to edit/lock this thread, I just ask that a moderator let me know what parts are unacceptable.

Here is the hack, it's fairly simple:

Open up poll.php:

At the bottom of the file, find ?>

Just above this, insert this code:

PHP Code:

// #################################### Change Vote ##########################################

if ($action=="changevote") 

{

  // other permissions?
  $permissions=getpermissions($forumid);
  if (!$permissions[canview] or !$permissions[canvote]) {
    show_nopermission();
  }

  $pollid=verifyid("poll",$pollid);
  $pollinfo=$DB_site->query_first("SELECT * FROM poll WHERE pollid='$pollid'");
  $voteinfo=$DB_site->query_first("SELECT * FROM pollvote WHERE userid='$bbuserinfo[userid]' AND pollid='$pollid'");

  $threadinfo=$DB_site->query_first("SELECT * FROM thread WHERE pollid='$pollid' AND open<>10");
  $threadcache[$threadinfo[threadid]]=$threadinfo;
  
  //check if poll is closed
  if (!$pollinfo[active] or !$threadinfo[open] or ($pollinfo[dateline]+($pollinfo[timeout]*86400)<time() and $pollinfo[timeout]!=0)){ //poll closed
     eval("standarderror(\"".gettemplate("error_pollclosed")."\");");
     exit;
  }

    //check if a user has already voted - abuse management
    if (!$uservoteinfo=$DB_site->query_first("SELECT userid FROM pollvote WHERE userid=$bbuserinfo[userid] AND pollid='$pollid'"))
    {
      //the user has not voted yet
      eval("standarderror(\"".gettemplate("error_userhasnotvoted")."\");");
      exit;
    }

    //Error checking complete, lets get the options
    $timenow = time();
    $DB_site->query("DELETE FROM pollvote WHERE pollid='$pollid' AND userid='$bbuserinfo[userid]' LIMIT 1");

    $splitvotes=explode("|||",$pollinfo[votes]);
    $splitvotes[$voteinfo[voteoption]-1]--;

    $counter=0;
    while ($counter<$pollinfo[numberoptions]) {
      $votesstring.="|||".intval($splitvotes[$counter]);
      $counter++;
    }
    if (substr($votesstring,0,3)=="|||") {
      $votesstring=substr($votesstring,3);
    }

    $DB_site->query("UPDATE poll SET votes='".addslashes($votesstring)."' WHERE pollid='$pollid'");

    //make last reply date == last vote date
    if ($updatelastpost){ //option selected in CP
      $DB_site->query("UPDATE thread SET lastpost=$timenow WHERE threadid=$threadinfo[threadid]");
    }

    // redirect
    eval("standardredirect(\"".gettemplate("redirect_pollchange")."\",\"showthread.php?s=$session[sessionhash]&threadid=$threadinfo[threadid]\");");
  } 


Save poll.php and upload it.

In your templates, you will need to add two templates and modify 1 existing one.

First:

Add template " error_userhasnotvoted "

The text of the template should be: 

You have not voted on this thread, so you can not change your vote.

Second:

Add template " redirect_pollchange "

The text of the template should be:

You have deleted your vote.  You will be taken to the poll, where you will be allowed to revote.

Lastly:

Edit your "showthread_pollresults_voted" template.

Change the text to:

You have already voted on this poll!
<BR>If you wish to change your vote, click <a href="poll.php?action=changevote&pollid=$pollinfo[pollid]">here</a>.

That's it...

Now your users will have the option to erase thier vote and revote. Not <i>quite</i> as elegant as allowing them to actually revote, but it will suffice for now ... at least for me. Someone feel free to expand on this if they want something a bit more robust.

Thanks, and good luck!

-Flare

Thanks - problem fixed

Worked a dream thanks for that

[maverick1236]

it installed fine-but where is option to change vote?

[Admin]

Awesome hack, great job!

[kyrnel]

Im getting a parse error at line 536 which (for me) is this line

PHP Code:

{ 


That the 3rd line of your added code.

Dont know why it is causing a parse error, I checked the last line of code for the missing slash, it is ok.

Im using 2.2.0 if that makes a difference.

any ideas? thanks

[kyrnel]

I quoted your original message to see if there are differences and the "{" (open round brackets) is showing up as "& #123" (without a space)
I dont know if that affects everyone or not, but you would think that the [ PHP ] tag would display php code as it really is.. hmm

well i copied the code from the edit window and it works fine now..thanks for the hack...

[Syphin]

Great hack... =) And only way i could get it to work, was from the edit box also... =/

But it works great now.. ^^

-Syphin

[Meta]

Nice hack ... works fine.

Thank you, Flare!

[josh929]

GREAT hack Flare!!

[Stud_Muffin]

Installed in vb 2.3.0 ok.