POLL Module

[pcwacht]

Allmost ready with my POLL module

Current features :
Unlimited polls, one per section
Unlimited questions
Scores editable
IP logged for one vote per ip

Only need to implement time out for iplogging
once per vote, once per week, day, 12 hour, 1 hour

What other features are required, so I can implement them in the first release.

John

[pcwacht]

Time has been added, you can give the amount of hours the voter's  ip will be checked against.
ie:
24 = one day
168 = one week
720 = one month
99999999 = a very long time

Best place for this module is in a side block.
See this post for the poll module : http://forum.websitebaker.org/index.php/topic,1256.msg11290.html#msg11290

Have fun!
John

[pcwacht]

and here is the snippet wich can be used with the poll-module
you need to change the poll_id to the one you want!

Code:

$poll_id=1;   // **** change this *****

// the rest shouldn't be altered..

$show_poll=$_REQUEST['show'];
$query_content = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_polls WHERE poll_id = '$poll_id'");
$poll_data = $query_content->fetchRow();
$txt_vote = $poll_data['txt_vote'];
$txt_voted = $poll_data['txt_voted'];
$txt_picture = WB_URL."/modules/polls/".$poll_data['txt_picture'];
$txt_nopolls = $poll_data['txt_nopolls'];
$txt_results = $poll_data['txt_results'];
$poll_id = $poll_data['poll_id'];
if($query_content->numRows() > 0) {                            # If there is a poll
$fetch_content = $query_content->fetchRow();
$ip = $_SERVER['REMOTE_ADDR'];                             # Check for voted allready
$data = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_polls_votes  WHERE `vote_ip` = '" . $ip . "' AND `poll_id` = '" . $poll_id . "' AND `vote_datum` > '" . time() . "'" );
$datapoll = $data->fetchRow();

    if ((!$_POST['vote']) && (!$datapoll) && (!$show_poll)) {  # Check if form submitted and not voted yet and no request to show results!
$options = explode(",", $poll_data['poll_keuzes']);    # Split options and count them in loop
    $aant = count($options)-1;
    $poll .= "<center>".$poll_data['poll_stelling']."</center><br />" ;
    $poll .= "<form method=\"POST\" action=\"" . $_SERVER['PHP_SELF'] . "\">";
    for($i = 0; $i <= $aant; $i++) {                       # Loop and make input radios  
    $j = $i+1;
       $poll .= "<input type=\"radio\" value=\"" . $j . "\" name=\"poll\" />" . $options[$i] . "<br />";
    }
    $poll .= "<br /><center><input type=\"submit\" class=\"button\" name=\"vote\" value=\"$txt_vote\" /></center></form>";
    $poll .= "<center><a href=\"".$_SERVER[PHP_SELF]."?show=1\">".$txt_results."</a></center>";
    echo $poll;
} else {                                                   # Add data to database and check for a value
        if($_POST['poll']) {                                   # Option selected - Update votes
           $vote=$_POST['poll'];
           $stemmen = explode(",", $poll_data['poll_scores']);# Split the vote scores
            $vote--;                                      
           (int) $stemmen[$vote]++;                           # add one to the selected option  
           $stem = implode(",", $stemmen);                    # Remake the data and add to database
           $poll_data['poll_scores']=$stem;
           $database->query("UPDATE ".TABLE_PREFIX."mod_polls SET `poll_scores` = '" . $stem . "' WHERE `poll_id` = '" . $poll_data['poll_id'] . "'");
$date_time = time()+($poll_data['poll_ttl']*60*60);
$database->query("INSERT INTO ".TABLE_PREFIX."mod_polls_votes SET `vote_ip` = '" . $ip . "',`poll_id` = '" . $poll_data['poll_id'] . "', `vote_datum` = '" . $date_time . "'");
            # Make sure to show poll
            $datapoll="1" ;
       }
    }
if(($datapoll) || ($show_poll)) {                          # If allready voted or requested show results
$options = explode(",", $poll_data['poll_keuzes']);    # Split options and scores
   $scores = explode(",", $poll_data['poll_scores']);
    $option = count($options)-1;
   $votes = array_sum($scores);                           # Count the votes and show them
   $results .= "<center>".$poll_data['poll_stelling']."</center><br />";
    $results .= "<p>";
   for($i = 0;$i <= $option; $i++) {                      # Loop through results
    $results .= $options[$i] . "<br />";
        if ($votes>0) {
        $num = (int) ($scores[$i] / ($votes/100)) ;
        } else {
        $num=0;
        }
    $results .= "<img src=\"".$txt_picture."\" width=\"" . $num/2 . "\" height=\"10\" /> " . $num . "%";
       $results .= "<br />";
    }
   $results .= "</p>";
   $results .= $txt_voted . $votes . "<br />";
    echo $results;            
}
} else {                                                       # No polls!
echo $txt_nopolls;
}

have fun!

[Bennie_wijs]

Looks good.

As soon as a need a poll, I will download yours  

[babsy]

it looks great... and i will use it soon

[babsy]

HI...

now i need this poll, but, im not sure how to insert it....

i have downloaded the module (but where exacly should i copy the code, - i tryed copying it on to the template itself, but it only appeared as text...?

 

[pcwacht]

put the text between
<?php and ?> so the webserver will know it is php.

You don't need the <?php and ?> when inserting the text in a code section!

John

[babsy]

Hi again...

and thanks alot... works like a charm...
now i only have to play with it, to make it look like i want to 

thanks!

its is on www.kjolurin.com

[remob]

@ phil

where one can I download your fantastic polling module? the download links mentioned above unfortunately does not work any more

thanks

[i2Paq]

@ phil John

where one can I download your fantastic polling module? the download links mentioned above unfortunately does not work any more

thanks

Maybe babsy or John can put up a new link (or we can have it in the modules section if it's finished  )

[pcwacht]

here you go:

[babsy]

Hi again.... this is probably a very very stupid question!

but how can i make a new poll... I just want a new question with new votes! to i have to install it again??

i tryed just to change the question, but that did´nt to it??

[pcwacht]

If you have a poll running and you want other questions, just overtype them
If you want another poll with diff questions, make a new section

If you use the snippet to include the poll in your template make sure to adjust the poll_id!


John

[remob]

if you want to run the poll module with webseitebaker 2.6.0 you have to change the info.php

add the new variable $module_function to the file

Code:

$module_function = 'page';

and the module works perfect

[pcwacht]

k, it needs to be updated.
Will do so soon.

John

[Hans]

In 2.6.1 I can't get the poll module working in a block 
Hans
[Edit] Sorry, I put the code in a code-block, now it works great.

[mufti]

Hi.. nice Module. Thx to the author!

Question:

i want the module to run under the menue. (is use the ROUND Template). The Menu is on the left side.
Is that possible? If yes - what have i to do exacktly? Thanx for your help!

my site: www.musichall-oppau.de

Greetz,
André

[Liakoni]

In 2.6.1 i get " Table 'wb._wbmod_polls' doesn't exist "
I changed the  file info.php $module_function= 'page'; but it didn't worked .

[pcwacht]

When you get the error : Table 'wb._wbmod_polls' doesn't exist "

there went something wrong during installation

Did you install the mod through admin-addons-modules-install?

What you can try, reload modules (admin->settings-show advanced-bottom of page)

Think this will work.

John

[Liakoni]

When you get the error : Table 'wb._wbmod_polls' doesn't exist "

there went something wrong during installation

Did you install the mod through admin-addons-modules-install?

What you can try, reload modules (admin->settings-show advanced-bottom of page)

Think this will work.

John

I didn't install it correct.
But what file should i select to make install through  admin-addons-modules-install ?

My mistake. I install it correct this time.

Thanks!!!