$value ) { if ( 'mem' == $value ) $query .= " IDMember = '$key' OR "; } $query = "UPDATE ProfilesSettings SET `Status` = 'Active' WHERE " . $query . " '1'='0' "; db_res( $query ); } elseif ( $_POST['delete'] ) { $query = ''; foreach ( $_POST as $key => $value ) { if ( 'mem' == $value ) $query .= " IDMember = '$key' OR "; } $query1 = "SELECT `BackgroundFilename` FROM ProfilesSettings WHERE " . $query . " '1'='0' "; $res = db_res( $query1 ); while( $arr = mysql_fetch_array( $res ) ) { if( file_exists($dir['profileBackground'] . $arr['BackgroundFilename']) ) unlink($dir['profileBackground'] . $arr['BackgroundFilename']); } $query2 = "UPDATE ProfilesSettings SET `BackgroundFilename` = '' WHERE " . $query . " '1'='0' "; db_res( $query2 ); } // =================================================================== // - 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; // ------------------------------ if ( isset($_GET['iUser']) ) { $iUser = (int)$_GET['iUser']; $sqlUser = " AND `IDMember` = '$iUser'"; } if (isset($_GET['status']) && $_GET['status'] == 'active') { $sqlMain = "`Status` = 'Active'"; $sConf = ''; } else { $sqlMain = "( `Status` != 'Active' OR `Status` IS NULL )"; $sConf = '| '; } // ------------------------------ $sql = "SELECT COUNT(*) FROM ProfilesSettings WHERE `BackgroundFilename` != '' && `BackgroundFilename` IS NOT NULL && $sqlMain $sqlUser"; $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 `IDMember`, `BackgroundFilename` FROM ProfilesSettings WHERE `BackgroundFilename` != '' && `BackgroundFilename` IS NOT NULL && $sqlMain $sqlUser LIMIT $real_first_p, $p_per_page" ); $_page['header'] = "Profiles PostModeration"; $_page['header_text'] = "Profiles that need to be checked by admin"; $_page['js'] = 1; TopCodeAdmin(); ContentBlockHead("Uploaded (and not yet approved) background images:"); ?>