$value ) { if ( 'poll' == $value ) $query .= " `id_poll` = '$key' or "; } $query = "UPDATE ProfilesPolls SET `poll_approval` = 1 WHERE " . $query . " 1 = 0 "; db_res( $query ); } elseif ( $_POST['delete'] ) { $query = ''; foreach ( $_POST as $key => $value ) { if ( 'poll' == $value ) $query .= " id_poll = '$key' or "; } $query = "DELETE FROM ProfilesPolls WHERE " . $query . " 1 = 0 "; db_res( $query ); } // =================================================================== // - GET variables -------------- // =================================================================== $page = (int)$_GET[page]; $p_per_page = (int)$_GET[p_per_page]; //$real_first_p = (int)($page - 1) * $p_per_page; //$page_first_p = $real_first_p + 1; $max_photo_height = $max_photo_height + 2; $max_photo_width = $max_photo_width + 2; if ( !$page ) $page = 1; if ( !$p_per_page ) $p_per_page = 10; // ------------------------------ $sql = "SELECT COUNT(*) FROM ProfilesPolls WHERE `poll_approval` = '0'"; $p_num = db_arr( $sql ); $p_num = $p_num[0]; $pages_num = ceil( $p_num / $p_per_page ); $real_first_p = (int)($page - 1) * $p_per_page; $page_first_p = $real_first_p + 1; $result = db_res( "SELECT `id_profile`, `id_poll` FROM ProfilesPolls WHERE `poll_approval` = 0 LIMIT $real_first_p, $p_per_page;" ); $_page['header'] = "Polls PostModeration"; $_page['header_text'] = "Polls that need to be checked by admin"; $_page['js'] = 1; $_page['js_name'] = 'profile_poll.js'; TopCodeAdmin(); ContentBlockHead("Created (and not yet approved) profile polls:"); ?>