'blocks_poll_block',
'func_edit' => 'blocks_poll_select',
'func_update' => 'blocks_poll_update',
'text_type' => 'Poll',
'text_type_long' => 'Display poll',
'allow_multiple' => true,
'form_content' => false,
'form_refresh' => false,
// 'support_xhtml' => true,
'show_preview' => true
);
// Security
pnSecAddSchema('Pollblock::', 'Block title::');
/**
* poll functions
*/
function pollMain($pollID, $row)
{
if (!pnSecAuthAction(0, 'Pollblock::', "$row[title]::", ACCESS_READ)) {
return;
}
list($dbconn) = pnDBGetConn();
$pntable = pnDBGetTables();
// if pollID isn't set use the latest pollID. Skooter
if (!isset($pollID) ||
empty($pollID) ||
!is_numeric($pollID) ||
$pollID == 0 ) {
$pollID = pollLatest();
}
//could be a bug if pollID '1' is deleted. Skooter
//if(!isset($pollID)) {
// $pollID = 1;
//}
if(!isset($url)) {
$url = sprintf("modules.php?op=modload&name=NS-Polls&file=index&req=results&pollID=%d", $pollID);
}
$boxContent = "\n\n";
if (empty($row['title'])) {
$row['title'] = _POLL;
}
if (empty($row['position'])) {
$row['position'] = "c";
}
$row['content'] = $boxContent;
return themesideblock($row);
}
function pollLatest()
{
list($dbconn) = pnDBGetConn();
$pntable = pnDBGetTables();
$currentlang = pnUserGetLang();
if (pnConfigGetVar('multilingual') == 1) {
$column = &$pntable['poll_desc_column'];
$querylang = "WHERE ($column[planguage]='".pnVarPrepForStore($currentlang)."' OR $column[planguage]='')";
} else {
$querylang = '';
}
$column = &$pntable['poll_desc_column'];
$sql = "SELECT $column[pollid] FROM $pntable[poll_desc] $querylang ORDER BY $column[pollid] DESC";
$result = $dbconn->SelectLimit($sql,1);
$pollID = $result->fields;
return($pollID[0]);
}
function pollNewest()
{
$pollID = pollLatest();
$row = array();
$row[title] = '';
return pollMain($pollID,$row);
}
function pollCollector($pollID, $voteID, $forwarder)
{
list($dbconn) = pnDBGetConn();
$pntable = pnDBGetTables();
// Check that the user hasn't voted for this poll already
if (pnSessionGetVar("poll_voted$pollID")) {
$warn = "You already voted today!";
} else {
pnSessionSetVar("poll_voted$pollID", 1);
$column = &$pntable['poll_data_column'];
$dbconn->Execute("UPDATE $pntable[poll_data] SET $column[optioncount]=$column[optioncount]+1 WHERE ($column[pollid]=".(int)pnVarPrepForStore($pollID).") AND ($column[voteid]=".(int)pnVarPrepForStore($voteID).")");
$column = &$pntable['poll_desc_column'];
$dbconn->Execute("UPDATE $pntable[poll_desc] SET $column[voters]=$column[voters]+1 WHERE $column[pollid]=".(int)pnVarPrepForStore($pollID)."");
}
pnRedirect($forwarder);
}
function pollList()
{
if (!pnSecAuthAction(0, 'Polls::', "::", ACCESS_OVERVIEW)) {
return;
}
list($dbconn) = pnDBGetConn();
$pntable = pnDBGetTables();
$currentlang = pnUserGetLang();
$commentoptions = pnUserGetCommentOptions();
if (pnConfigGetVar('multilingual') == 1) {
$column = &$pntable['poll_desc_column'];
$querylang = "WHERE ($column[planguage]='".pnVarPrepForStore($currentlang)."' OR $column[planguage]='')";
} else {
$querylang = "";
}
$column = &$pntable['poll_desc_column'];
$result = $dbconn->Execute("SELECT $column[pollid], $column[polltitle], $column[timestamp], $column[voters] FROM $pntable[poll_desc] $querylang ORDER BY $column[timestamp]");
OpenTable();
OpenTable();
echo ""._PASTSURVEYS."
";
CloseTable();
echo "";
echo "";
$counter = 0;
$resultArray = array();
while($thisresult = $result->fields) {
$result->MoveNext();
$resultArray[$counter] = $thisresult;
$counter++;
}
for ($count = 0; $count < count($resultArray); $count++) {
$id = $resultArray[$count][0];
$pollTitle = $resultArray[$count][1];
$voters = $resultArray[$count][3];
$column = &$pntable['poll_data_column'];
$result2 = $dbconn->Execute("SELECT SUM($column[optioncount]) AS sum FROM $pntable[poll_data] WHERE $column[pollid]=".pnVarPrepForStore($id)."");
list($sum) = $result2->fields;
echo "· ".pnVarPrepForDisplay($pollTitle)." ";
echo "("._RESULTS." )"._RESULTS." - $sum "._LVOTES.")
';
CloseTable();
}
function pollResults($pollID)
{
list($dbconn) = pnDBGetConn();
$pntable = pnDBGetTables();
// if pollID isn't set use the latest pollID. Skooter
//if(!isset($pollID)) $pollID = 1; //could be a bug if pollID '1' is deleted. Skooter
if(!isset($pollID) || empty($pollID) ||
(is_numeric($pollID) && ($pollID == 0)) ) {
$pollID = pollLatest();
}
$column = &$pntable['poll_desc_column'];
$result = $dbconn->Execute("SELECT $column[polltitle] FROM $pntable[poll_desc] WHERE $column[pollid]=".(int)pnVarPrepForStore($pollID));
list($holdtitle) = $result->fields;
echo "".pnVarPrepForDisplay($holdtitle)." ";
/* cycle through all options */
$column = &$pntable['poll_data_column'];
$result = $dbconn->Execute("SELECT $column[optiontext], $column[optioncount] FROM $pntable[poll_data] WHERE ($column[pollid]=".(int)pnVarPrepForStore($pollID)." AND $column[optiontext] NOT LIKE \"\") ORDER BY $column[voteid]");
while(list($optionText, $optionCount) = $result->fields) {
$result->MoveNext();
echo "";
echo "".pnVarPrepForDisplay($optionText)." ";
echo " ";
if($sum) {
$percent = 100 * $optionCount / $sum;
} else {
$percent = 0;
}
echo "";
$percentInt = (int)$percent * 4 * pnConfigGetVar('BarScale');
$percent2 = (int)$percent;
$ThemeSel = pnUserGetTheme();
if ($percent > 0) {
echo " %.1f%% ", $percent);
// printf(" %.2f %% (%d) ", $percent, $optionCount);
echo "
";
// echo ""._TOTALVOTES." $sum "._ONEPERDAY." "._VOTING." | ");
echo(""._OTHERPOLLS." ]
");
return(1);
}
function blocks_poll_block($row)
{
// for MSSQL that always have an space
$row['content'] = trim($row['content']);
if (!empty($row['content'])) {
$pollID = $row['content'];
} else {
$pollID = pollLatest();
}
return pollMain($pollID, $row);
}
function blocks_poll_select($row)
{
list($dbconn) = pnDBGetConn();
$pntable = pnDBGetTables();
$zerochecked = "";
$onechecked = "";
if (!empty($row['content'])) {
$pollID = $row['content'];
$showspecific = 1;
$onechecked = "checked";
} else {
$pollID = 0;
$showspecific = 0;
$zerochecked = "checked";
}
$output = ""._POLL_DISPLAY.": "._POLL_LATEST." "._POLL_SPECIFIC." ";
// Get list of polls
$polltable = $pntable['poll_desc'];
$pollcolumn = $pntable['poll_desc_column'];
$sql = "SELECT $pollcolumn[polltitle],
$pollcolumn[pollid]
FROM $polltable
ORDER BY $pollcolumn[polltitle]";
$result = $dbconn->Execute($sql);
while(list($title, $id) = $result->fields) {
$result->MoveNext();
$output .= "";
}
$result->Close();
$output .= " ![\"$percent2](\"themes/$ThemeSel/images/leftbar.gif\")
";
echo "![\"$percent2](\"themes/$ThemeSel/images/mainbar.gif\")
";
echo "![\"$percent2](\"themes/$ThemeSel/images/rightbar.gif\")
";
} else {
echo "