X-Git-Url: http://git.vanrenterghem.biz/www.vanrenterghem.biz.git/blobdiff_plain/4b1ce0d83844cfd7c55e75a60ccb239882cd62e3..83ab5456767602f2a9860a7db7247f002ec96945:/phpBB2_old/admin/admin_ranks.php diff --git a/phpBB2_old/admin/admin_ranks.php b/phpBB2_old/admin/admin_ranks.php deleted file mode 100644 index bd6eb05..0000000 --- a/phpBB2_old/admin/admin_ranks.php +++ /dev/null @@ -1,376 +0,0 @@ -sql_query($sql)) - { - message_die(GENERAL_ERROR, "Couldn't obtain rank data", "", __LINE__, __FILE__, $sql); - } - - $rank_info = $db->sql_fetchrow($result); - $s_hidden_fields .= ''; - - } - else - { - $rank_info['rank_special'] = 0; - } - - $s_hidden_fields .= ''; - - $rank_is_special = ( $rank_info['rank_special'] ) ? "checked=\"checked\"" : ""; - $rank_is_not_special = ( !$rank_info['rank_special'] ) ? "checked=\"checked\"" : ""; - - $template->set_filenames(array( - "body" => "admin/ranks_edit_body.tpl") - ); - - $template->assign_vars(array( - "RANK" => $rank_info['rank_title'], - "SPECIAL_RANK" => $rank_is_special, - "NOT_SPECIAL_RANK" => $rank_is_not_special, - "MINIMUM" => ( $rank_is_special ) ? "" : $rank_info['rank_min'], - "IMAGE" => ( $rank_info['rank_image'] != "" ) ? $rank_info['rank_image'] : "", - "IMAGE_DISPLAY" => ( $rank_info['rank_image'] != "" ) ? '' : "", - - "L_RANKS_TITLE" => $lang['Ranks_title'], - "L_RANKS_TEXT" => $lang['Ranks_explain'], - "L_RANK_TITLE" => $lang['Rank_title'], - "L_RANK_SPECIAL" => $lang['Rank_special'], - "L_RANK_MINIMUM" => $lang['Rank_minimum'], - "L_RANK_IMAGE" => $lang['Rank_image'], - "L_RANK_IMAGE_EXPLAIN" => $lang['Rank_image_explain'], - "L_SUBMIT" => $lang['Submit'], - "L_RESET" => $lang['Reset'], - "L_YES" => $lang['Yes'], - "L_NO" => $lang['No'], - - "S_RANK_ACTION" => append_sid("admin_ranks.$phpEx"), - "S_HIDDEN_FIELDS" => $s_hidden_fields) - ); - - } - else if( $mode == "save" ) - { - // - // Ok, they sent us our info, let's update it. - // - - $rank_id = ( isset($HTTP_POST_VARS['id']) ) ? intval($HTTP_POST_VARS['id']) : 0; - $rank_title = ( isset($HTTP_POST_VARS['title']) ) ? trim($HTTP_POST_VARS['title']) : ""; - $special_rank = ( $HTTP_POST_VARS['special_rank'] == 1 ) ? TRUE : 0; - $min_posts = ( isset($HTTP_POST_VARS['min_posts']) ) ? intval($HTTP_POST_VARS['min_posts']) : -1; - $rank_image = ( (isset($HTTP_POST_VARS['rank_image'])) ) ? trim($HTTP_POST_VARS['rank_image']) : ""; - - if( $rank_title == "" ) - { - message_die(GENERAL_MESSAGE, $lang['Must_select_rank']); - } - - if( $special_rank == 1 ) - { - $max_posts = -1; - $min_posts = -1; - } - - // - // The rank image has to be a jpg, gif or png - // - if($rank_image != "") - { - if ( !preg_match("/(\.gif|\.png|\.jpg)$/is", $rank_image)) - { - $rank_image = ""; - } - } - - if ($rank_id) - { - if (!$special_rank) - { - $sql = "UPDATE " . USERS_TABLE . " - SET user_rank = 0 - WHERE user_rank = $rank_id"; - - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, $lang['No_update_ranks'], "", __LINE__, __FILE__, $sql); - } - } - $sql = "UPDATE " . RANKS_TABLE . " - SET rank_title = '" . str_replace("\'", "''", $rank_title) . "', rank_special = $special_rank, rank_min = $min_posts, rank_image = '" . str_replace("\'", "''", $rank_image) . "' - WHERE rank_id = $rank_id"; - - $message = $lang['Rank_updated']; - } - else - { - $sql = "INSERT INTO " . RANKS_TABLE . " (rank_title, rank_special, rank_min, rank_image) - VALUES ('" . str_replace("\'", "''", $rank_title) . "', $special_rank, $min_posts, '" . str_replace("\'", "''", $rank_image) . "')"; - - $message = $lang['Rank_added']; - } - - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't update/insert into ranks table", "", __LINE__, __FILE__, $sql); - } - - $message .= "

" . sprintf($lang['Click_return_rankadmin'], "", "") . "

" . sprintf($lang['Click_return_admin_index'], "", ""); - - message_die(GENERAL_MESSAGE, $message); - - } - else if( $mode == "delete" ) - { - // - // Ok, they want to delete their rank - // - - if( isset($HTTP_POST_VARS['id']) || isset($HTTP_GET_VARS['id']) ) - { - $rank_id = ( isset($HTTP_POST_VARS['id']) ) ? intval($HTTP_POST_VARS['id']) : intval($HTTP_GET_VARS['id']); - } - else - { - $rank_id = 0; - } - - if( $rank_id ) - { - $sql = "DELETE FROM " . RANKS_TABLE . " - WHERE rank_id = $rank_id"; - - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't delete rank data", "", __LINE__, __FILE__, $sql); - } - - $sql = "UPDATE " . USERS_TABLE . " - SET user_rank = 0 - WHERE user_rank = $rank_id"; - - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, $lang['No_update_ranks'], "", __LINE__, __FILE__, $sql); - } - - $message = $lang['Rank_removed'] . "

" . sprintf($lang['Click_return_rankadmin'], "", "") . "

" . sprintf($lang['Click_return_admin_index'], "", ""); - - message_die(GENERAL_MESSAGE, $message); - - } - else - { - message_die(GENERAL_MESSAGE, $lang['Must_select_rank']); - } - } - else - { - // - // They didn't feel like giving us any information. Oh, too bad, we'll just display the - // list then... - // - $template->set_filenames(array( - "body" => "admin/ranks_list_body.tpl") - ); - - $sql = "SELECT * FROM " . RANKS_TABLE . " - ORDER BY rank_min, rank_title"; - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't obtain ranks data", "", __LINE__, __FILE__, $sql); - } - - $rank_rows = $db->sql_fetchrowset($result); - $rank_count = count($rank_rows); - - $template->assign_vars(array( - "L_RANKS_TITLE" => $lang['Ranks_title'], - "L_RANKS_TEXT" => $lang['Ranks_explain'], - "L_RANK" => $lang['Rank_title'], - "L_RANK_MINIMUM" => $lang['Rank_minimum'], - "L_SPECIAL_RANK" => $lang['Special_rank'], - "L_EDIT" => $lang['Edit'], - "L_DELETE" => $lang['Delete'], - "L_ADD_RANK" => $lang['Add_new_rank'], - "L_ACTION" => $lang['Action'], - - "S_RANKS_ACTION" => append_sid("admin_ranks.$phpEx")) - ); - - for( $i = 0; $i < $rank_count; $i++) - { - $rank = $rank_rows[$i]['rank_title']; - $special_rank = $rank_rows[$i]['rank_special']; - $rank_id = $rank_rows[$i]['rank_id']; - $rank_min = $rank_rows[$i]['rank_min']; - - if($special_rank) - { - $rank_min = $rank_max = "-"; - } - - $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2']; - $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2']; - - $template->assign_block_vars("ranks", array( - "ROW_COLOR" => "#" . $row_color, - "ROW_CLASS" => $row_class, - "RANK" => $rank, - "RANK_MIN" => $rank_min, - - "SPECIAL_RANK" => ( $special_rank == 1 ) ? $lang['Yes'] : $lang['No'], - - "U_RANK_EDIT" => append_sid("admin_ranks.$phpEx?mode=edit&id=$rank_id"), - "U_RANK_DELETE" => append_sid("admin_ranks.$phpEx?mode=delete&id=$rank_id")) - ); - } - } -} -else -{ - // - // Show the default page - // - $template->set_filenames(array( - "body" => "admin/ranks_list_body.tpl") - ); - - $sql = "SELECT * FROM " . RANKS_TABLE . " - ORDER BY rank_min ASC, rank_special ASC"; - if( !$result = $db->sql_query($sql) ) - { - message_die(GENERAL_ERROR, "Couldn't obtain ranks data", "", __LINE__, __FILE__, $sql); - } - $rank_count = $db->sql_numrows($result); - - $rank_rows = $db->sql_fetchrowset($result); - - $template->assign_vars(array( - "L_RANKS_TITLE" => $lang['Ranks_title'], - "L_RANKS_TEXT" => $lang['Ranks_explain'], - "L_RANK" => $lang['Rank_title'], - "L_RANK_MINIMUM" => $lang['Rank_minimum'], - "L_SPECIAL_RANK" => $lang['Rank_special'], - "L_EDIT" => $lang['Edit'], - "L_DELETE" => $lang['Delete'], - "L_ADD_RANK" => $lang['Add_new_rank'], - "L_ACTION" => $lang['Action'], - - "S_RANKS_ACTION" => append_sid("admin_ranks.$phpEx")) - ); - - for($i = 0; $i < $rank_count; $i++) - { - $rank = $rank_rows[$i]['rank_title']; - $special_rank = $rank_rows[$i]['rank_special']; - $rank_id = $rank_rows[$i]['rank_id']; - $rank_min = $rank_rows[$i]['rank_min']; - - if( $special_rank == 1 ) - { - $rank_min = $rank_max = "-"; - } - - $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2']; - $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2']; - - $rank_is_special = ( $special_rank ) ? $lang['Yes'] : $lang['No']; - - $template->assign_block_vars("ranks", array( - "ROW_COLOR" => "#" . $row_color, - "ROW_CLASS" => $row_class, - "RANK" => $rank, - "SPECIAL_RANK" => $rank_is_special, - "RANK_MIN" => $rank_min, - - "U_RANK_EDIT" => append_sid("admin_ranks.$phpEx?mode=edit&id=$rank_id"), - "U_RANK_DELETE" => append_sid("admin_ranks.$phpEx?mode=delete&id=$rank_id")) - ); - } -} - -$template->pparse("body"); - -include('./page_footer_admin.'.$phpEx); - -?>