Просмотр архива Форум PHPWEB


<?php
/***************************************************************************
 *                              admin_ranks.php
 *                            -------------------
 *      Разработка: phpBB Group.
 *      Оптимизация под WAP: Гутник Игорь ( чел ).
 *          2009 год
 ***************************************************************************/

if( !empty($setmodules) )
{
    $file = basename(__FILE__);
    $module['Users']['Ranks'] = $file;
    return;
}

define('IN_PHPBB', 1);

$phpbb_root_path = "./../";
require($phpbb_root_path . 'extension.inc');

$cancel = ( isset($HTTP_POST_VARS['cancel']) || isset($_POST['cancel']) ) ? true : false;
$no_page_header = $cancel;

require('./pagestart.' . $phpEx);


if ($cancel)
{
    redirect('admin/' . append_sid("admin_ranks.$phpEx", true));
}

if( isset($HTTP_GET_VARS['mode']) || isset($HTTP_POST_VARS['mode']) )
{
    $mode = (isset($HTTP_GET_VARS['mode'])) ? $HTTP_GET_VARS['mode'] : $HTTP_POST_VARS['mode'];
    $mode = htmlspecialchars($mode);
}
else 
{

    if( isset($HTTP_POST_VARS['add']) )
    {
        $mode = "add";
    }
    else if( isset($HTTP_POST_VARS['save']) )
    {
        $mode = "save";
    }
    else
    {
        $mode = "";
    }
}

$mode = ( in_array($mode, array('add', 'edit', 'save', 'delete')) ) ? $mode : '';

if( $mode != "" )
{
    if( $mode == "edit" || $mode == "add" )
    {

        $rank_id = ( isset($HTTP_GET_VARS['id']) ) ? intval($HTTP_GET_VARS['id']) : 0;
        
        $s_hidden_fields = "";
        
        if( $mode == "edit" )
        {
            if( empty($rank_id) )
            {
                message_die(GENERAL_MESSAGE, $lang['Must_select_rank']);
            }

            $sql = "SELECT * FROM " . RANKS_TABLE . "
                WHERE rank_id = $rank_id";
            if(!$result = $db->sql_query($sql))
            {
                message_die(GENERAL_ERROR, "Couldn't obtain rank data", "", __LINE__, __FILE__, $sql);
            }
            
            $rank_info = $db->sql_fetchrow($result);
            $s_hidden_fields .= '<input type="hidden" name="id" value="' . $rank_id . '" />';

        }
        else
        {
            $rank_info['rank_special'] = 0;
        }

        $s_hidden_fields .= '<input type="hidden" name="mode" value="save" />';

        $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'] != "" ) ? '<img src="../' . $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" )
    {

        $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;
        }

        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 .= "<br /><br />" . sprintf($lang['Click_return_rankadmin'], "<a href="" . append_sid("admin_ranks.$phpEx") . "">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href="" . append_sid("index.$phpEx?pane=right") . "">", "</a>");

        message_die(GENERAL_MESSAGE, $message);

    }
    else if( $mode == "delete" )
    {
    
        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;
        }

        $confirm = isset($HTTP_POST_VARS['confirm']);
        
        if( $rank_id && $confirm )
        {
            $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'] . "<br /><br />" . sprintf($lang['Click_return_rankadmin'], "<a href="" . append_sid("admin_ranks.$phpEx") . "">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href="" . append_sid("index.$phpEx?pane=right") . "">", "</a>");

            message_die(GENERAL_MESSAGE, $message);

        }
        elseif( $rank_id && !$confirm)
        {
            $template->set_filenames(array(
                'body' => 'admin/confirm_body.tpl')
            );

            $hidden_fields = '<input type="hidden" name="mode" value="delete" /><input type="hidden" name="id" value="' . $rank_id . '" />';

            $template->assign_vars(array(
                'MESSAGE_TITLE' => $lang['Confirm'],
                'MESSAGE_TEXT' => $lang['Confirm_delete_rank'],

                'L_YES' => $lang['Yes'],
                'L_NO' => $lang['No'],

                'S_CONFIRM_ACTION' => append_sid("admin_ranks.$phpEx"),
                'S_HIDDEN_FIELDS' => $hidden_fields)
            );
        }
        else
        {
            message_die(GENERAL_MESSAGE, $lang['Must_select_rank']);
        }
    }

    $template->pparse("body");

    include('./page_footer_admin.'.$phpEx);
}

$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_class = ( !($i % 2) ) ? 'row_easy' : 'row_hard';

    $rank_is_special = ( $special_rank ) ? $lang['Yes'] : $lang['No'];
    
    $template->assign_block_vars("ranks", array(
        "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&amp;id=$rank_id"),
        "U_RANK_DELETE" => append_sid("admin_ranks.$phpEx?mode=delete&amp;id=$rank_id"))
    );
}

$template->pparse("body");

include('./page_footer_admin.'.$phpEx);

?>