} echo ""._MOREPOLLS.""; CloseTable(); echo ""; cookiedecode($user); if (($pollcomm) AND ($mode != "nocomments")) { echo "

"; include("modules/Surveys/comments.php"); } include ("footer.php"); } elseif($voteID > 0) { pollCollector($pollID, $voteID); } elseif($pollID != pollLatest()) { include ('header.php'); OpenTable(); echo "
"._SURVEY."
"; CloseTable(); echo "

"; echo "
"; pollMain($pollID); echo "
"; include ('footer.php'); } else { include ('header.php'); OpenTable(); echo "
"._CURRENTSURVEY."
"; CloseTable(); echo "

"; pollNewest(); echo "
"; include ('footer.php'); } /*********************************************************/ /* Functions */ /*********************************************************/ function pollMain($pollID) { global $boxTitle, $boxContent, $pollcomm, $user, $cookie, $prefix, $dbi, $module_name, $db; $pollID = intval($pollID); if(!isset($pollID)) $pollID = 1; if(!isset($url)) $url = sprintf("modules.php?name=$module_name&op=results&pollID=%d", $pollID); $boxContent .= "
"; $boxContent .= "sql_query("DELETE FROM ".$prefix."_poll_check WHERE time < '$past'"); $row = $db->sql_fetchrow($db->sql_query("SELECT ip FROM ".$prefix."_poll_check WHERE (ip='$ip') AND (pollID='$pollID')")); $ips = $row['ip']; $ctime = time(); if ($ip == $ips) { $voteValid = 0; } else { $db->sql_query("INSERT INTO ".$prefix."_poll_check (ip, time, pollID) VALUES ('$ip', '$ctime', '$pollID')"); $voteValid = "1"; } /* Fix end */ /* update database if the vote is valid */ if($voteValid>0) { $db->sql_query("UPDATE ".$prefix."_poll_data SET optionCount=optionCount+1 WHERE pollID='$pollID' AND voteID='$voteID'"); if ($voteID != "") { $db->sql_query("UPDATE ".$prefix."_poll_desc SET voters=voters+1 WHERE pollID='$pollID'"); update_points(8); } Header("Location: $forwarder"); } else { Header("Location: $forwarder"); } /* a lot of browsers can't handle it if there's an empty page */ echo ""; } function pollList() { global $user, $cookie, $prefix, $multilingual, $currentlang, $admin, $dbi, $module_name, $db; if (isset($cookie[4])) { $r_options .= "&mode=$cookie[4]"; } if (isset($cookie[5])) { $r_options .= "&order=$cookie[5]"; } if (isset($cookie[6])) { $r_options .= "&thold=$cookie[6]"; } if ($multilingual == 1) { $querylang = "WHERE planguage='$currentlang' AND artid='0'"; } else { $querylang = "WHERE artid='0'"; } $result = sql_query("SELECT pollID, pollTitle, timeStamp, voters FROM ".$prefix."_poll_desc $querylang ORDER BY timeStamp DESC", $dbi); $counter = 0; OpenTable(); OpenTable(); echo "
"._PASTSURVEYS."
"; CloseTable(); echo "
"; while($object = sql_fetch_object($result, $dbi)) { $resultArray[$counter] = array($object->pollID, $object->pollTitle, $object->timeStamp, $object->voters); $counter++; } for ($count = 0; $count < count($resultArray); $count++) { $id = $resultArray[$count][0]; $id = intval($id); $i = intval($i); $pollTitle = $resultArray[$count][1]; $voters = $resultArray[$count][3]; for($i = 0; $i < 12; $i++) { $result2 = sql_query("SELECT optionCount FROM ".$prefix."_poll_data WHERE pollID='$id' AND voteID='$i'", $dbi); $object = sql_fetch_object($result2, $dbi); $optionCount = $object->optionCount; $sum = (int)$sum+$optionCount; } echo "· $pollTitle "; if (is_admin($admin)) { $editing = " - Edit"; } else { $editing = ""; } echo "("._RESULTS." - $sum "._LVOTES."$editing)
\n"; $sum = 0; } echo "
" ."
"; OpenTable(); echo "
"._SURVEYSATTACHED."
"; CloseTable(); echo "
"; if ($multilingual == 1) { $querylang = "WHERE planguage='$currentlang' AND artid!='0'"; } else { $querylang = "WHERE artid!='0'"; } $counter = 0; $result3 = sql_query("SELECT pollID, pollTitle, timeStamp, voters FROM ".$prefix."_poll_desc $querylang ORDER BY timeStamp DESC", $dbi); while($object = sql_fetch_object($result3, $dbi)) { $resultArray2[$counter] = array($object->pollID, $object->pollTitle, $object->timeStamp, $object->voters); $counter++; } for ($count = 0; $count < count($resultArray2); $count++) { $id = $resultArray2[$count][0]; $id = intval($id); $i = intval($i); $pollTitle = $resultArray2[$count][1]; $voters = $resultArray2[$count][3]; for($i = 0; $i < 12; $i++) { $result4 = sql_query("SELECT optionCount FROM ".$prefix."_poll_data WHERE pollID='$id' AND voteID='$i'", $dbi); $object = sql_fetch_object($result4, $dbi); $optionCount = $object->optionCount; $sum = (int)$sum+$optionCount; } echo "· $pollTitle "; if (is_admin($admin)) { $editing = " - Edit"; } else { $editing = ""; } $res = $db->sql_query("select sid, title from ".$prefix."_stories where pollID='$id'"); list($sid, $title) = $db->sql_fetchrow($res); $sid = intval($sid); $title = stripslashes(check_html($title, "nohtml")); echo "("._RESULTS." - $sum "._LVOTES."$editing)
\n" .""._ATTACHEDTOARTICLE." $title

\n"; $sum = ""; } echo "
"; CloseTable(); } function pollResults($pollID) { global $resultTableBgColor, $resultBarFile, $Default_Theme, $user, $cookie, $prefix, $dbi, $admin, $module_name, $db; if(!isset($pollID)) $pollID = 1; $pollID = intval($pollID); $result = $db->sql_query("SELECT pollID, pollTitle, timeStamp, artid FROM ".$prefix."_poll_desc WHERE pollID='$pollID'"); $holdtitle = $db->sql_fetchrow($result); echo "
Опрос: $holdtitle[1]


"; $i = intval($i); for($i = 0; $i < 12; $i++) { $result2 = sql_query("SELECT optionCount FROM ".$prefix."_poll_data WHERE pollID='$pollID' AND voteID='$i'", $dbi); $object = sql_fetch_object($result2, $dbi); $optionCount = $object->optionCount; $sum = (int)$sum+$optionCount; } echo ""; /* cycle through all options */ for($i = 1; $i <= 12; $i++) { /* select next vote option */ $result3 = sql_query("SELECT pollID, optionText, optionCount, voteID FROM ".$prefix."_poll_data WHERE pollID='$pollID' AND voteID='$i'", $dbi); $object = sql_fetch_object($result3, $dbi); if(is_object($object)) { $optionText = $object->optionText; $optionCount = $object->optionCount; if($optionText != "") { echo ""; if($sum) { $percent = 100 * $optionCount / $sum; } else { $percent = 0; } echo ""; } } } echo "
"; echo "$optionText"; echo ""; $percentInt = (int)$percent * 4 * 1; $percent2 = (int)$percent; if(is_user($user)) { if($cookie[9]=="") $cookie[9]=$Default_Theme; if(!$file=@opendir("themes/$cookie[9]")) { $ThemeSel = $Default_Theme; } else { $ThemeSel = $cookie[9]; } } else { $ThemeSel = $Default_Theme; } if (file_exists("themes/$ThemeSel/images/survey_leftbar.gif") AND file_exists("themes/$ThemeSel/images/survey_mainbar.gif") AND file_exists("themes/$ThemeSel/images/survey_rightbar.gif")) { $l_size = getimagesize("themes/$ThemeSel/images/survey_leftbar.gif"); $m_size = getimagesize("themes/$ThemeSel/images/survey_mainbar.gif"); $r_size = getimagesize("themes/$ThemeSel/images/survey_rightbar.gif"); $leftbar = "survey_leftbar.gif"; $mainbar = "survey_mainbar.gif"; $rightbar = "survey_rightbar.gif"; } else { $l_size = getimagesize("themes/$ThemeSel/images/leftbar.gif"); $m_size = getimagesize("themes/$ThemeSel/images/mainbar.gif"); $r_size = getimagesize("themes/$ThemeSel/images/rightbar.gif"); $leftbar = "leftbar.gif"; $mainbar = "mainbar.gif"; $rightbar = "rightbar.gif"; } if (file_exists("themes/$ThemeSel/images/survey_mainbar_d.gif")) { $m1_size = getimagesize("themes/$ThemeSel/images/survey_mainbar_d.gif"); $mainbar_d = "survey_mainbar_d.gif"; if ($percent2 > 0 AND $percent2 <= 23) { $salto = "\"$percent2"; } elseif ($percent2 > 24 AND $percent2 < 50) { $a = $percentInt - 100; $salto = "\"$percent2" ."\"$percent2" ."\"$percent2"; } elseif ($percent2 > 49 AND $percent2 < 75) { $a = $percentInt - 200; $salto = "\"$percent2" ."\"$percent2" ."\"$percent2" ."\"$percent2" ."\"$percent2"; } elseif ($percent2 > 74 AND $percent2 <= 100) { $a = $percentInt - 300; $salto = "\"$percent2" ."\"$percent2" ."\"$percent2" ."\"$percent2" ."\"$percent2" ."\"$percent2" ."\"$percent2"; } } if ($percent > 0) { echo "\"$percent2"; if (file_exists("themes/$ThemeSel/images/survey_mainbar_d.gif")) { echo "$salto"; } else { echo "\"$percent2"; } echo "\"$percent2"; } else { echo "\"$percent2"; if (!file_exists("themes/$ThemeSel/images/survey_mainbar_d.gif")) { echo "\"$percent2"; } echo "\"$percent2"; } printf(" %.2f%% (%s)", $percent, $optionCount); echo "

"; ech