View file votes/inc/all.php

<?
user_access('votes_settings',null,'index.php?'.SID);
$set['title']='Все опросы'; // заголовок страницы
include_once '../sys/inc/thead.php';
title();

$k_page=$k_post=$k_post_all;
$page=page($k_page);
$start=$page-1;






if ($k_post==0)
{
err();
aut();
echo "<table class='post'>\n";
echo "   <tr>\n";
echo "  <td class='p_t'>\n";
echo "Нет опросов\n";
echo "  </td>\n";
echo "   </tr>\n";
}
else
{
$survey = mysql_fetch_assoc(mysql_query("SELECT * FROM `survey_s` ORDER BY `id` DESC LIMIT $start, 1"));

if (isset($_GET['close']) && $_GET['close']==$survey['id'])
{
$survey['time_close']=$time;
mysql_query("UPDATE `survey_s` SET `time_close` = '$survey[time_close]' WHERE `id` = '$survey[id]' LIMIT 1");
admin_log('Опросы','Управление опросами',"Опрос '$survey[surv]' завершен досрочно");
msg("Опрос досрочно завершен");
}
if (isset($_GET['delete']) && $_GET['delete']==$survey['id'])
{
mysql_query("DELETE FROM `survey_s` WHERE `id` = '$survey[id]' LIMIT 1");
mysql_query("DELETE FROM `survey_r` WHERE `id_sur` = '$survey[id]'");
mysql_query("DELETE FROM `survey_v` WHERE `id_s` = '$survey[id]'");
admin_log('Опросы','Управление опросами',"Опрос '$survey[surv]' удален");
msg("Опрос успешно удален");
$survey = mysql_fetch_assoc(mysql_query("SELECT * FROM `survey_s` ORDER BY `id` DESC LIMIT $start, 1"));
}
err();
aut();
echo "<table class='post'>\n";
echo "   <tr>\n";
if ($set['set_show_icon']==2){
echo "  <td class='icon48' rowspan='2'>\n";
echo "<img src='/style/themes/$set[set_them]/votes/vote.png' alt='' />";
echo "  </td>\n";
}
elseif ($set['set_show_icon']==1)
{
echo "  <td class='icon14'>\n";
echo icons('votes.png','code');
echo "  </td>\n";
}
echo "  <td class='p_t'>\n";
echo "Опрос (".vremja($survey['time'])."):";
echo "  </td>\n";
echo "   </tr>\n";
echo "   <tr>\n";
if ($set['set_show_icon']==1)echo "  <td class='p_m' colspan='2'>\n"; else echo "  <td class='p_m'>\n";
echo output_text($survey['surv']);
echo "  </td>\n";
echo "   </tr>\n";
echo "   <tr>\n";
echo "  <td class='main_menu' colspan='2'>\n";

$all_sur=mysql_result(mysql_query("SELECT COUNT(*) FROM `survey_v` WHERE `id_s` = '$survey[id]'"), 0);
$q=mysql_query("SELECT `survey_r`.`msg`, COUNT(`survey_v`.`id_user`) AS `count` FROM `survey_r` LEFT JOIN `survey_v`
 ON `survey_r`.`id` = `survey_v`.`id_r` WHERE `survey_r`.`id_sur` = '$survey[id]' GROUP BY `survey_r`.`id` ORDER BY `count` DESC");
 echo mysql_error();
while($res=mysql_fetch_assoc($q))
{
echo "$res[msg]<br />\n";
echo "<img src='img.php?p=".@intval($res['count']/$all_sur*100)."&amp;k=$res[count]&amp;a=$all_sur' alt='' /><br />\n";
//echo "<div style='height:5px;background-color:#ffffff;border: 1px solid #cccccc;width: 120px;'><div style='height:5px;background-color:#B3C0ED;width:".@intval($res['count']/$all_sur*100)."%;'>&nbsp;</div></div>";
}



if ($survey['time_close']>$time)
echo "<a href='?survey=all&amp;page=$page&amp;close=$survey[id]'>Окончить опрос</a><br />\n";
else
echo "<a href='?survey=all&amp;page=$page&amp;delete=$survey[id]'>Удалить опрос</a><br />\n";

echo "  </td>\n";
echo "   </tr>\n";
}
echo "</table>\n";


if ($k_page>1)str("?survey=all&amp;",$k_page,$page); // Вывод страниц

echo "<div class='foot'>\n";
echo "&laquo;<a href='?$passgen'>Меню опросов</a><br />\n";
echo "</div>\n";
?>