leyu_admin/admin/member_rank.php

<?php
/**
 * 会员权限管理
 *
 * @version        $Id: member_rank.php 1 12:37 2010年7月20日Z tianya $
 * @package        DedeCMS.Administrator
 * @copyright      Copyright (c) 2007 - 2010, DesDev, Inc.
 * @license        http://help.dedecms.com/usersguide/license.html
 * @link           http://www.dedecms.com
 */
require_once(dirname(__FILE__)."/config.php");
CheckPurview('member_Type');
if(empty($dopost)) $dopost = '';

//保存更改
if($dopost=='save')
{
    $startID = 1;
    $endID = $idend;
    for(;$startID <= $endID;$startID++)
    {
        $query = '';
        $id = ${"ID_".$startID};
        $name = ${"name_".$startID};
        $rank = ${"rank_".$startID};
        $money = ${"money_".$startID};
        $scores = ${"scores_".$startID};
        if(isset(${"check_".$startID}))
        {
            if($rank>0)
            {
                $query = "UPDATE `#@__arcrank` SET membername='$name',money='$money',rank='$rank',scores='$scores' WHERE id='$id' ";            
            }
        }
        else
        {
            $query = "DELETE FROM `#@__arcrank` WHERE id='$id' AND rank<>10";
        }
        if($query!='') $dsql->ExecuteNoneQuery($query);
    }
    if(isset($check_new))
    {
        if($rank_new > 0 && $name_new != '' && $rank_new > 10)
        {
            $inquery = "INSERT INTO `#@__arcrank`(`rank`,`membername`,`adminrank`,`money`,`scores`,`purviews`) VALUES('$rank_new','$name_new','5','$money_new','$scores',''); ";
            $dsql->ExecuteNoneQuery($inquery);
        }
    }
    echo "<script> alert('成功更新会员等级表！'); </script>";
}
if($dopost == 'del')
{
    $dsql->ExecuteNoneQuery("DELETE FROM `#@__arcrank` WHERE id='$id' AND rank<>10");
    ShowMsg("删除成功！","member_rank.php");
    exit();
}

$dsql->SetQuery("SELECT * FROM `#@__arcrank` WHERE rank>0 ORDER BY rank");
$dsql->Execute();
include DedeInclude('templets/member_rank.htm');