文档介绍:蚆螂芀数据库连接关键代码蕿膅/*初始化数据库类*/蒂require(ROOT_PATH.'includes/');节$db=newcls_mysql($db_host,$db_user,$db_pass,$db_name);蚇$db_host=$db_user=$db_pass=$db_name=NULL;薅芃查看用户关键代码部分聿聿/*------------------------------------------------------*/羄//--用户帐号列表羃/*------------------------------------------------------*/膀膈if($_REQUEST['act']=='list')蚇{螃/*检查权限*/节admin_priv('users_manage');芆$sql="SELECTrank_id,rank_name,min_pointsFROM".$ecs->table('user_rank')."ORDERBYmin_pointsASC";肇$rs=$db->query($sql);蒄聿$ranks=array();蚈while($row=$db->FetchRow($rs))薆{膄$ranks[$row['rank_id']]=$row['rank_name'];肀}螇羆$smarty->assign('user_ranks',$ranks);羅$smarty->assign('ur_here',$_LANG['03_users_list']);膂$smarty->assign('action_link',array('text'=>$_LANG['04_users_add'],'href'=>'?act=add'));腿莅$user_list=user_list();蚅罿$smarty->assign('user_list',$user_list['user_list']);芈$smarty->assign('filter',$user_list['filter']);螄$smarty->assign('record_count',$user_list['record_count']);膁$smarty->assign('page_count',$user_list['page_count']);羀$smarty->assign('full_page',1);莆$smarty->assign('sort_user_id','<imgsrc="images/">');芄袂assign_query_info();肂$smarty->display('');螈}羇蚂衿修改用户关键代码部分袇莆/*------------------------------------------------------*/莂//--更新用户帐号袁/*------------------------------------------------------*/艿螆elseif($_REQUEST['act']=='update')膃{羂/*检查权限*/莇admin_priv('users_manage');膅$username=empty($_POST['username'])?'':trim($_POST['username']);袃$password=empty($_POST['password'])?'':trim($_POST['password']);蝿$email=empty($_POST['email'])?'':trim($_POST['email']);螀$sex=empty($_POST['sex'])?0:intval($_POST['sex']);蚅$sex=in_array($sex,array(0,1,2))?$sex:0;蚄$birthday=$_POST['birthdayYear'].'-'.$_POST['birthdayMonth'].'-'.$_POST['birthdayDay'];袁$rank=empty($_POST['user_rank'])?0:intval($_POST['user_rank']);袈$credit_line=empty($_POST['credit_line'])?0:floatval($_POST['credit_line']);肄莄$users=&init_users();袂羇if(!$users->edit_user(array('username'=>$username,'password'=>$passw