alert('Ñïàñèáî çà ãîëîñîâàíèå. Âàø ãîëîñ ó÷òåí.');"; echo ""; } else { echo ""; echo ""; } } // ============================== // ========== Âûâîä ============= // ============================== // ============= // === menu ==== // ============= if (!isset($_GET['action'])) { echo"
Óïðàâëåíèå îïðîñàìè
"; echo"
  • Òåêóùèå îïðîñû
  • Ìîè îïðîñû
    • "; } if (isset($_GET['action']) && $_GET['action']=='current') { // äåëàë â ñïåøêå çàïðîñû êîðÿâûå echo"
    Òåêóùèå îïðîñû
    "; echo"
    "; // Âûâîä ãîëîñîâàíèé $sql = "SELECT a.* FROM zlo_users_audience as a, zlo_users_audience_option as op WHERE a.`date_end` > NOW() AND a.`show`=1 AND op.audience_id=a.id GROUP BY a.id ORDER BY a.`date_start`"; $result = mysql_query($sql) or die(mysql_error()); $total=mysql_affected_rows(); if ($total!=0) { $j=0; while ($audience=mysql_fetch_assoc($result)) { // Ïðîâåðÿåì íå ãîëîñîâàë ëè ðàíåå $sql2="SELECT * FROM zlo_users_audience_answers WHERE audience_id='".$audience['id']."' AND user_id='".$_SESSION['user']['id']."'"; $result2 = mysql_query($sql2) or die(mysql_error()); if (mysql_affected_rows()==0) { $sql2="SELECT * FROM zlo_users_audience_option WHERE audience_id='".$audience['id']."'"; $result2 = mysql_query($sql2) or die(mysql_error()); if (mysql_affected_rows()!=0) { $i=0; echo"
    "; echo"
    ".$audience['title']."
    ".$audience['text']."
    "; while ($option=mysql_fetch_assoc($result2)) { $i++; echo"
    "; } echo"
    "; echo"
    "; } } else { $j++; } } if($total==$j){ echo"Â äàííûé ìîìåíò íåò îïðîñîâ";} } else { echo"Â äàííûé ìîìåíò íåò îïðîñîâ"; } echo"
    "; } // ============= // == passed === // ============= if (isset($_GET['action']) && $_GET['action']=='passed' && !isset($_GET['audience'])) { echo"
    Ìîè îïðîñû
    "; // Âûâîä ïðîãîëîñîâàí³õ îïðîñîâ $sql = "SELECT a.title, a.id, w.audience_id FROM zlo_users_audience_answers as w, zlo_users_audience as a WHERE w.user_id='".$_SESSION['user']['id']."' AND a.`show`=1 AND a.id=w.audience_id"; $result = mysql_query($sql) or die(mysql_error()); if (mysql_affected_rows()!=0) { echo"
    "; while ($audience=mysql_fetch_assoc($result)) { echo"
  • ".$audience['title']."
    • "; } echo"
    "; } else { echo"Âû íå ó÷àñòâîâàëè â ãîëîñîâàíèÿõ";} } // ============== // === result === // ============== if (isset($_GET['action']) && $_GET['action']=='passed' && isset($_GET['audience'])) { // Èíôî î ãîëîñîâàíèè $sql = "SELECT a.*, w.value FROM zlo_users_audience as a, zlo_users_audience_answers as w WHERE w.audience_id=a.id AND a.id='".$_GET['audience']."' AND w.user_id='".$_SESSION['user']['id']."' "; $result = mysql_query($sql) or die(mysql_error()); if (mysql_affected_rows()!=0) { $audience=mysql_fetch_assoc($result); $sql2=" SELECT * FROM zlo_users_audience_option WHERE audience_id = '".$audience['id']."' "; $result2 = mysql_query($sql2) or die(mysql_error()); if (mysql_affected_rows()!=0) { $i=0; echo"
    ".$audience['title']."
    ".$audience['text']."
    "; while ($option=mysql_fetch_assoc($result2)) { $i++; if($option['id']==$audience['value']) {$checked="checked='checked'";} else {$checked='';} echo"
    "; } echo"
    "; } } } ?>