query( "DELETE FROM " . PREFIX . "_vote WHERE id='$id'" );
$db->query( "DELETE FROM " . PREFIX . "_vote_result WHERE vote_id='$id'" );
@unlink( ENGINE_DIR . '/cache/system/vote.php' );
msg( "info", $lang['vote_str_2'], $lang['vote_str_2'], "?mod=editvote" );
}
if( $_GET['action'] == "clear" ) {
if( $_REQUEST['user_hash'] == "" or $_REQUEST['user_hash'] != $dle_login_hash ) {
die( "Hacking attempt! User not found" );
}
$db->query( "UPDATE " . PREFIX . "_vote set vote_num='0' WHERE id='$id'" );
$db->query( "DELETE FROM " . PREFIX . "_vote_result WHERE vote_id='$id'" );
@unlink( ENGINE_DIR . '/cache/system/vote.php' );
msg( "info", $lang['vote_clear3'], $lang['vote_clear3'], "?mod=editvote" );
}
if( $_GET['action'] == "off" ) {
if( $_REQUEST['user_hash'] == "" or $_REQUEST['user_hash'] != $dle_login_hash ) {
die( "Hacking attempt! User not found" );
}
$db->query( "UPDATE " . PREFIX . "_vote set approve='0' WHERE id='$id'" );
@unlink( ENGINE_DIR . '/cache/system/vote.php' );
}
if( $_GET['action'] == "on" ) {
if( $_REQUEST['user_hash'] == "" or $_REQUEST['user_hash'] != $dle_login_hash ) {
die( "Hacking attempt! User not found" );
}
$db->query( "UPDATE " . PREFIX . "_vote set approve='1' WHERE id='$id'" );
@unlink( ENGINE_DIR . '/cache/system/vote.php' );
}
if( $_GET['action'] == "views" AND $_GET['id']) {
$id = intval ($_GET['id']);
$row = $db->super_query( "SELECT id, title, category, body, vote_num FROM " . PREFIX . "_vote WHERE id='$id'" );
$title = stripslashes( $row['title'] );
$body = stripslashes( $row['body'] );
$body = explode( "
", $body );
$max = $row['vote_num'];
$db->query( "SELECT answer, count(*) as count FROM " . PREFIX . "_vote_result WHERE vote_id='$id' GROUP BY answer" );
$pn = 0;
$entry = "";
$answer = array ();
while ( $row = $db->get_row() ) {
$answer[$row['answer']]['count'] = $row['count'];
}
$db->free();
for($i = 0; $i < sizeof( $body ); $i ++) {
++ $pn;
if( $pn > 5 ) $pn = 1;
$num = $answer[$i]['count'];
if( ! $num ) $num = 0;
if( $max != 0 ) $proc = (100 * $num) / $max;
else $proc = 0;
$proc = round( $proc, 2 );
$entry .= "$body[$i] - $num ($proc%)
\n";
}
if ( !$title ) $entry = $lang['vote_notfound'];
$entry = "$entry
";
echoheader( "", "" );
echo <<
HTML;
echofooter();
} else {
$js_array[] = "engine/classes/js/menu.js";
echoheader( "vote", $lang[editvote] );
// ********************************************************************************
// Список голосований
// ********************************************************************************
echo "
";
/* Vote List */
$db->query( "SELECT * FROM " . PREFIX . "_vote ORDER BY id DESC" );
$entries = "";
while ( $row = $db->get_row() ) {
$item_id = $row['id'];
$item_date = date( "d.m.Y", strtotime( $row['date'] ) );
$title = htmlspecialchars( stripslashes( $row['title'] ) );
if ( $row['start'] ) $start_date = date( "d.m.Y H:i", $row['start'] ); else $start_date = "--";
if ( $row['end'] ) $end_date = date( "d.m.Y H:i", $row['end'] ); else $end_date = "--";
if( dle_strlen( $title, $config['charset'] ) > 74 ) {
$title = dle_substr( $title, 0, 70, $config['charset'] ) . " ...";
}
$item_num = $row['vote_num'];
if( empty( $row['category'] ) ) {
$item_category = "--";
} elseif( $row['category'] == "all" ) {
$item_category = $lang['edit_all'];
} else {
$item_category = $cat[$row['category']];
}
;
if( $row['approve'] ) {
$status = "led_green.gif";
$lang['led_title'] = $lang['led_on_title'];
$led_action = "off";
} else {
$status = "led_gray.gif";
$lang['led_title'] = $lang['led_off_title'];
$led_action = "on";
}
$entries .= "
|
$item_date - {$title} |
{$start_date} |
{$end_date} |
![](\"engine/skins/images/" "\\"\"") |
{$row['vote_num']} |
{$item_category} |
![](\"engine/skins/images/browser_action.gif\") |
|
";
}
$db->free();
if( empty( $entries ) ) {
$entries = "| " . $lang['vote_nodata'] . " |
";
}
echo <<
HTML;
echofooter();
}
?> 
