- <?php
- /*
- sqlin
- */
- class sqlin
- {
- //dowith_sql($value)
- function dowith_sql($str)
- {
- $str = str_replace("and","",$str);
- $str = str_replace("execute","",$str);
- $str = str_replace("update","",$str);
- $str = str_replace("count","",$str);
- $str = str_replace("chr","",$str);
- $str = str_replace("mid","",$str);
- $str = str_replace("master","",$str);
- $str = str_replace("truncate","",$str);
- $str = str_replace("char","",$str);
- $str = str_replace("declare","",$str);
- $str = str_replace("select","",$str);
- $str = str_replace("create","",$str);
- $str = str_replace("delete","",$str);
- $str = str_replace("insert","",$str);
- $str = str_replace("'","",$str);
- $str = str_replace(" ","",$str);
- $str = str_replace("or","",$str);
- $str = str_replace("=","",$str);
- $str = str_replace("%20","",$str);
- //echo $str;
- return $str;
- }
- //aticle()
- function sqlin()
- {
- foreach ($_GET as $key=>$value)
- {
- $_GET[$key]=$this->dowith_sql($value);
- }
- foreach ($_POST as $key=>$value)
- {
- $_POST[$key]=$this->dowith_sql($value);
- }
- }
- }
- $dbsql=new sqlin();
- include_once('../common.php');
- if ( empty( $_SGLOBAL['supe_uid'] ) )
- {
- echo "<script language="JavaScript">\r\n";
- echo "alert( "您还未登录,请返回登录!");\r\n";
- echo "location.href='../do.php?ac=login'";
- echo "</SCRIPT>-->";
- }
- $groupid = $_SGLOBAL['db']->result($_SGLOBAL['db']->query('SELECT groupid FROM '.tname('space').' where uid='.$_SGLOBAL['supe_uid']),0);
- if ($groupid != "1")
- {
- echo "<script language="JavaScript">\r\n";
- echo "alert( "你不是管理员,无权进入,本次操作已被记录");\r\n";
- echo "location.href='../space.php?do=home'";
- echo "</SCRIPT>-->";
- }
- if ( $_REQUEST['id'] == "seeall" )
- {
- ?>
- <style type="text/css">
- <!--
- .STYLE1 {color: #0000FF}
- .STYLE2 { font-size: 20px;
- font-weight: bold;}
- .STYLE3 {font-size: 14px}
- .n{TEXT-DECORATION:none}
- .pay_title{height:28px; line-height:28px; padding-left:10px; color:#C00000; font-size:12px; background-color:#ffff99; overflow:hidden; border-bottom:1px solid #ccc;}
- .STYLE5 {
- font-size: 24px;
- color: #0000FF;
- font-weight: bold;
- }
- .STYLE6 {color: #C00000}
- .STYLE7 {color: #0000FF}
- -->
- </style>
- <div style="margin:5px; font-size:12px; color:#333333; border:1px solid #CCC000; margin-top:0px; padding-top:0px;">
- <div align="center"><span class="STYLE5">开心农场牧场后台--紫贝佳缘1.0</span>
- </div><br>
- <div class="pay_title">
- <div align="center"><span class="STYLE6">注意:点击↓(降序)↑(升序)可进行排序。各个版本通用</span><span style="margin-left: 40px;font-weight: bold; "><a href="admin.php">返回后台</a></span><span style="margin-left: 50px;font-weight: bold; "><a href="../newfarm.php">返回农场</a></span></div>
- </div>
- <div align="center">
- <p class="STYLE2">所有用户农场牧场信息</p>
- <table width="860" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC" >
- <tr align="center" bgcolor="#FFFFFF">
- <td width="80" bgcolor="#FFFFFF"><span class="STYLE1">用户UID</span></td>
- <td width="80" align="center" bgcolor="#FFFFFF"><span class="STYLE1">用户名</span></td>
- <td width="110" bgcolor="#FFFFFF"><span class="STYLE1"><a class=n href="admin.php?id=seeall&px=1&cc=exp">↓</a>农场等级<a class=n href="admin.php?id=seeall&px=0&cc=exp">↑</a></span></td>
- <td width="100" bgcolor="#FFFFFF"><span class="STYLE1"><a class=n href="admin.php?id=seeall&px=1&cc=mc_exp">↓</a>牧场等级<a class=n href="admin.php?id=seeall&px=0&cc=mc_exp">↑</a></span></td>
- <td width="100" bgcolor="#FFFFFF"><span class="STYLE1"><a class=n href="admin.php?id=seeall&px=1&cc=charm">↓</a>魅力等级<a class=n href="admin.php?id=seeall&px=0&cc=charm">↑</a></span></td>
- <td width="100" bgcolor="#FFFFFF"><span class="STYLE1"><a class=n href="admin.php?id=seeall&px=1&cc=reclaim">↓</a>农田数<a class=n href="admin.php?id=seeall&px=0&cc=reclaim">↑</a></span></td>
- <td width="100" bgcolor="#FFFFFF"><span class="STYLE1"><a class=n href="admin.php?id=seeall&px=1&cc=money">↓</a>金币数<a class=n href="admin.php?id=seeall&px=0&cc=money">↑</a></span></td>
- <td width="100" bgcolor="#FFFFFF"><span class="STYLE1"><a class=n href="admin.php?id=seeall&px=1&cc=fb">↓</a>FB数<a class=n href="admin.php?id=seeall&px=0&cc=fb">↑</a></span></td>
- </tr>
- <?php
- if ( $_REQUEST['px'] == "1" )
- { $query = $_SGLOBAL['db']->query( "SELECT uid,money,exp,mc_exp,fb,reclaim,charm FROM ".tname( "plug_newfarm" )." where uid order by ".$_REQUEST['cc']." desc"); }
- if ( $_REQUEST['px'] == "0" )
- { $query = $_SGLOBAL['db']->query( "SELECT uid,money,exp,mc_exp,fb,reclaim,charm FROM ".tname( "plug_newfarm" )." where uid order by ".$_REQUEST['cc']." asc"); }
- while ( $value = $_SGLOBAL['db']->fetch_array( $query ))
- {
- $username = $_SGLOBAL['db']->result($_SGLOBAL['db']->query('SELECT username FROM '.tname('space').' where uid='.$value['uid']),0);
- $uid=$value['uid'];
- $reclaim=$value['reclaim'];
- $money=$value['money'];
- $fb=$value['fb'];
- $exp=$value['exp'];
- $exp=$exp-$exp%200;
- $nclevel=sqrt($exp/100+0.25)-0.5;
- $mc_exp=$value['mc_exp'];
- $mc_exp=$mc_exp-$mc_exp%200;
- $mclevel=sqrt($mc_exp/100+0.25)-0.5;
- if ( $value['charm'] < 180 ) $charm=0;
- if ( $value['charm'] >= 180 && $value['charm'] < 440) $charm=1;
- if ( $value['charm'] >= 440 && $value['charm'] < 800) $charm=2;
- if ( $value['charm'] >= 800 && $value['charm'] < 1300) $charm=3;
- if ( $value['charm'] >= 1300 && $value['charm'] < 2000) $charm=4;
- if ( $value['charm'] >= 2000 && $value['charm'] < 2800) $charm=5;
- if ( $value['charm'] >= 2800 && $value['charm'] < 3750) $charm=6;
- if ( $value['charm'] >= 3750 && $value['charm'] < 5000) $charm=7;
- if ( $value['charm'] >= 5000 && $value['charm'] < 6500) $charm=8;
- if ( $value['charm'] >= 6500 && $value['charm'] < 8300) $charm=9;
- if ( $value['charm'] >= 8300 && $value['charm'] < 10400) $charm=10;
- if ( $value['charm'] >= 10400 ) $charm="大于10级";
- ?>
- <tr align="center" bgcolor="#FFFFFF">
- <td width="80" bgcolor="#FFFFFF"><?php echo $uid; ?></td>
- <td width="120" bgcolor="#FFFFFF"><a href="../space.php?uid=<?php echo $uid;?>"><?php echo $username; ?></a></td>
- <td width="110" bgcolor="#FFFFFF"><?php echo $nclevel; ?></td>
- <td width="100" bgcolor="#FFFFFF"><?php echo $mclevel; ?></td>
- <td width="100" bgcolor="#FFFFFF"><?php echo $charm; ?></td>
- <td width="100" bgcolor="#FFFFFF"><?php echo $reclaim; ?></td>
- <td width="100" bgcolor="#FFFFFF"><?php echo $money; ?></td>
- <td width="100" bgcolor="#FFFFFF"><?php echo $fb; ?></td>
- </tr>
- <?php } ?>
- </table>
- </div>
- <br>
- <?php
- exit();
- }
- ?>
- <?php
- if ( $_REQUEST['user'] == "pd" )
- {
- $maxuid = $_SGLOBAL['db']->result($_SGLOBAL['db']->query('SELECT uid FROM '.tname('plug_newfarm').' where uid='.$_REQUEST['uid'] ),0);
- if($maxuid != null)
- {
- if ( $_REQUEST['id'] == "edit" )
- {
- if ( $_REQUEST['nclevel'] >= "0"&$_REQUEST['nclevel']!="直接填写数字")
- {
-
- $_SGLOBAL['db']->query("UPDATE ".tname('plug_newfarm')." set exp=".$_REQUEST['nclevel']."*100+100*".$_REQUEST['nclevel']."*".$_REQUEST['nclevel']." where uid=".$_REQUEST['uid']);
- }
- if ( $_REQUEST['mclevel'] >= "0"&$_REQUEST['mclevel']!="直接填写数字")
- {
-
- $_SGLOBAL['db']->query("UPDATE ".tname('plug_newfarm')." set mc_exp=".$_REQUEST['mclevel']."*200+100*".$_REQUEST['mclevel']."*".$_REQUEST['mclevel']."-".$_REQUEST['mclevel']."*100 where uid=".$_REQUEST['uid']);
- }
- if ( $_REQUEST['mllevel'] != "选择魅力等级")
- {
- $_SGLOBAL['db']->query("UPDATE ".tname('plug_newfarm')." set charm=".$_REQUEST['mllevel']." where uid=".$_REQUEST['uid']);
- }
- $_SGLOBAL['db']->query("UPDATE ".tname('plug_newfarm')." set exp=exp+".$_REQUEST['exp']." , charm=charm+".$_REQUEST['charm']." , reclaim=reclaim+".$_REQUEST['reclaim']." , money=money+".$_REQUEST['money']." , fb=fb+".$_REQUEST['fb']." , mc_exp=mc_exp+".$_REQUEST['mc_exp']." where uid=".$_REQUEST['uid']);
- $query = $_SGLOBAL['db']->query( "SELECT reclaim FROM ".tname( "plug_newfarm" )." where uid=".$_REQUEST['uid']);
- while ( $value = $_SGLOBAL['db']->fetch_array( $query ))
- { if($value['reclaim']<6)
- {
- $_SGLOBAL['db']->query("UPDATE ".tname('plug_newfarm')." set reclaim=reclaim-".$_REQUEST['reclaim']." where uid=".$_REQUEST['uid']);
- echo "<script language="JavaScript">\r\n";
- echo "alert( "农田数不能小于6,返回修改!");\r\n";
- echo " history.back();\r\n";
- echo "</script>";
- }
- }
- echo "<script language="JavaScript">\r\n";
- echo "alert( "更改成功!");\r\n";
- echo " history.back();\r\n";
- echo "</script>";
- }
- if ( $_REQUEST['id'] == "see" )
- {
- $query = $_SGLOBAL['db']->query( "SELECT money,exp,mc_exp,fb,reclaim,charm FROM ".tname( "plug_newfarm" )." where uid=".$_REQUEST['uid']);
- $username = $_SGLOBAL['db']->result($_SGLOBAL['db']->query('SELECT username FROM '.tname('space').' where uid='.$_REQUEST['uid']),0);
- $uid=$_REQUEST['uid'];
- while ( $value = $_SGLOBAL['db']->fetch_array( $query ))
- {
- $reclaim=$value['reclaim'];
- $money=$value['money'];
- $fb=$value['fb'];
- $exp=$value['exp'];
- $exp=$exp-$exp%200;
- $nclevel=sqrt($exp/100+0.25)-0.5;
- $mc_exp=$value['mc_exp'];
- $mc_exp=$mc_exp-$mc_exp%200;
- $mclevel=sqrt($mc_exp/100+0.25)-0.5;
- if ( $value['charm'] < 180 ) $charm=0;
- if ( $value['charm'] >= 180 && $value['charm'] < 440) $charm=1;
- if ( $value['charm'] >= 440 && $value['charm'] < 800) $charm=2;
- if ( $value['charm'] >= 800 && $value['charm'] < 1300) $charm=3;
- if ( $value['charm'] >= 1300 && $value['charm'] < 2000) $charm=4;
- if ( $value['charm'] >= 2000 && $value['charm'] < 2800) $charm=5;
- if ( $value['charm'] >= 2800 && $value['charm'] < 3750) $charm=6;
- if ( $value['charm'] >= 3750 && $value['charm'] < 5000) $charm=7;
- if ( $value['charm'] >= 5000 && $value['charm'] < 6500) $charm=8;
- if ( $value['charm'] >= 6500 && $value['charm'] < 8300) $charm=9;
- if ( $value['charm'] >= 8300 && $value['charm'] < 10400) $charm=10;
- if ( $value['charm'] >= 10400 ) $charm="大于10级";
- ?>
- <style type="text/css">
- <!--
- .STYLE1 {color: #0000FF}
- .STYLE2 {
- font-size: 20px;
- font-weight: bold;
- }
- .STYLE3 {color: #FF0000}
- .STYLE4 {
- font-size: 13px;
- color: #0000FF;
- }
- .pay_title{height:28px; line-height:28px; padding-left:10px; color:#C00000; font-size:12px; background-color:#ffff99; overflow:hidden; border-bottom:1px solid #ccc;}
- .STYLE5 {
- font-size: 24px;
- color: #0000FF;
- font-weight: bold;
- }
- .STYLE6 {color: #C00000}
- .STYLE7 {color: #0000FF}
- -->
- </style>
- <div style="margin:5px; font-size:12px; color:#333333; border:1px solid #CCC000; margin-top:0px; padding-top:0px;">
- <div align="center"><span class="STYLE5">开心农场牧场后台--紫贝佳缘1.0</span>
- </div><br>
- <div class="pay_title">
- <div align="center"><span class="STYLE6">注意:点击↓(降序)↑(升序)可进行排序。各个版本通用</span><span style="margin-left: 40px;font-weight: bold; "><a href="admin.php">返回后台</a></span><span style="margin-left: 50px;font-weight: bold; "><a href="../newfarm.php">返回农场</a></span></div>
- </div>
- <div align="center">
- <p class="STYLE2"><span class="STYLE3"><?php echo $username; ?></span>农场牧场信息</p>
- <table width="750"><tr align="right"><td><span class="STYLE4"><a href="admin.php?id=seeall&cc=uid&px=0"> 查看所有用户</a></span></td>
- </tr></table>
- <table width="750" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC" >
- <tr align="center" bgcolor="#FFFFFF">
- <td width="80" bgcolor="#FFFFFF"><span class="STYLE1">用户UID</span></td>
- <td width="120" bgcolor="#FFFFFF"><span class="STYLE1">用户名</span></td>
- <td width="80" bgcolor="#FFFFFF"><span class="STYLE1">农场等级</span></td>
- <td width="80" bgcolor="#FFFFFF"><span class="STYLE1">牧场等级</span></td>
- <td width="80" bgcolor="#FFFFFF"><span class="STYLE1">魅力等级</span></td>
- <td width="80" bgcolor="#FFFFFF"><span class="STYLE1">农田数</span></td>
- <td width="100" bgcolor="#FFFFFF"><span class="STYLE1">金币数</span></td>
- <td width="100" bgcolor="#FFFFFF"><span class="STYLE1">FB数</span></td>
- <td width="100" bgcolor="#FFFFFF">返回修改</td>
- </tr>
- <tr align="center" bgcolor="#FFFFFF">
- <td width="80" bgcolor="#FFFFFF"><?php echo $uid; ?></td>
- <td width="120" bgcolor="#FFFFFF"><a href="../space.php?uid=<?php echo $uid;?>"><?php echo $username; ?></a></td>
- <td width="80" bgcolor="#FFFFFF"><?php echo $nclevel; ?></td>
- <td width="80" bgcolor="#FFFFFF"><?php echo $mclevel; ?></td>
- <td width="80" bgcolor="#FFFFFF"><?php echo $charm; ?></td>
- <td width="80" bgcolor="#FFFFFF"><?php echo $reclaim; ?></td>
- <td width="100" bgcolor="#FFFFFF"><?php echo $money; ?></td>
- <td width="100" bgcolor="#FFFFFF"><?php echo $fb; ?></td>
- <td width="100" bgcolor="#FFFFFF"><a href="javascript:window.history.go(-1);">修改</a></td>
- </tr>
- </table>
- </div>
- <?php
- }
- }
- ?>
- <br></div>
- <?php
- exit(); }
- else{
- echo "<script language="JavaScript">\r\n";
- echo "alert( "无此用户!");\r\n";
- echo " history.back();\r\n";
- echo "</script>";
- exit();}
- }
- if ( $_REQUEST['uid'] == null )
- {
- ?>
- <head>
- <title>开心农场牧场后台--紫贝佳缘1.0</title>
- <style type="text/css">
- .pay_title{height:28px; line-height:28px; padding-left:10px; color:#C00000; font-size:12px; background-color:#ffff99; overflow:hidden; border-bottom:1px solid #ccc;}
- .STYLE22 {
- font-size: 24px;
- color: #0000FF;
- font-weight: bold;
- }
- .STYLE66 {color: #C00000; font-size: 13px;}
- .STYLE77 {color: #0000FF}
- </style>
- </head>
- <body>
- <script language="javascript">
- function checkvalue()
- {
- uid=document.form1.uid.value;
- if(document.form1.uid.value == "用户UID")
- {
- alert("请输入用户UID!");
- return false;
- }
- if(document.form1.uid.value == "")
- {
- alert("请输入用户UID!");
- return false;
- }
- if(document.form1.uid.value.search("^-?\\d+(\\.\\d+)?$")!=0)
- {
- alert("用户UID为数字!");
- return false;
- }
- window.open("admin.php?id=see&user=pd&uid="+uid,"_self","");
- }
- function checkdata()
- {
- if(document.form1.uid.value == "用户UID")
- {
- alert("请输入用户UID!");
- return false;
- }
- if(document.form1.uid.value == "")
- {
- alert("请输入用户UID!");
- return false;
- }
- if(document.form1.uid.value.search("^-?\\d+(\\.\\d+)?$")!=0)
- {
- alert("用户UID为数字!");
- return false;
- }
- }
- </script>
- <form id="form1" name="form1" method="post" action="admin.php?id=edit&user=pd" OnSubmit="return checkdata()" >
- <div style="margin:5px; font-size:13px; color:#333333; border:1px solid #CCC000; margin-top:0px; padding-top:0px;">
- <div align="center"><span class="STYLE22">开心农场牧场后台--紫贝佳缘1.0</span>
- </div><br>
- <div class="pay_title">
- <div align="center"><span class="STYLE77">说明:不更改的选项栏请填写0(如不更改等级请勿填写0,否则降更改为0级)各个版本通用</span><span style="margin-left: 40px;font-weight: bold; "><a href="admin.php?id=seeall&cc=uid&px=0">查看所有农场用户</a>
- </span><span style="margin-left: 55px;font-weight: bold; "><a href="../newfarm.php">返回农场</a></span> </div>
- </div>
- <div align="center"><br>
- <br><table width="850" border="0" cellspacing="1">
- <tr width="750">
- <td align="right" width="61"><span class="STYLE66">用户UID:</span></td>
- <td width="72" align="left"><input type="text" id="uid" name="uid" class="input_key" size="10" onFocus="this.value='';this.focus()" value="用户UID"/></td>
- <td width="657" align="left" ><span class="STYLE66"><a href="#" onClick="javascript:return checkvalue();">查看此用户农牧场信息</a></span></td>
- </tr> </table>
- <table width="850" border="0" cellspacing="1">
- <tr width="750">
- <td width="84" align="right"><span class="STYLE66">农场经验:</span></td>
- <td width="70"><input name="exp" type="text" class="input_key" id="exp" value="0" size="8"/></td>
- <td width="84" align="right" ><span class="STYLE66">牧场经验:</span></td>
- <td width="70">
- <input name="mc_exp" type="text" class="input_key" id="mc_exp" value="0" size="8"/>
- </td>
- <td width="84" align="right" ><span class="STYLE66">农场魅力:</span></td>
- <td width="70"><input name="charm" type="text" class="input_key" id="charm" value="0" size="8"/></td>
- <td width="84" align="right" ><span class="STYLE66">农田数目:</span></td>
- <td width="70"><input name="reclaim" type="text" class="input_key" id="reclaim" value="0" size="8"/></td>
- <td width="84" align="right" ><span class="STYLE66">金币数目:</span></td>
- <td width="70"><input name="money" type="text" class="input_key" id="money" value="0" size="8"/></td>
- <td width="84" align="right" ><span class="STYLE66">F币数目:</span></td>
- <td width="70"><input name="fb" type="text" class="input_key" id="fb" value="0" size="8" /></td>
- </tr>
- </table>
- <table width="850" border="0" cellspacing="1">
- <tr width="750" >
- <td width="92" align="right"><span class="STYLE66">
- 更改农场等级:</span></td>
- <td width="95" align="left">
- <input name="nclevel" id="nclevel" type="text" value="直接填写数字" size="14" onFocus="this.value='';this.focus()" onkeyup="this.value=this.value.replace(/[^\d]/g,'')" onafterpaste="this.value=this.value.replace(/[^\d]/g,'')" />
- </td>
- <td width="92" align="right"><span class="STYLE66">
- 更改牧场等级:</span></td>
- <td width="95" align="left">
- <input name="mclevel" id="mclevel" type="text" value="直接填写数字" size="14" onFocus="this.value='';this.focus()" onkeyup="this.value=this.value.replace(/[^\d]/g,'')" onafterpaste="this.value=this.value.replace(/[^\d]/g,'')" />
- </td>
- <td width="92" align="right"><span class="STYLE66">
- 更改魅力等级:</span></td>
- <td width="95" align="left">
- <select name="mllevel" id="mllevel" >
- <option selected="">选择魅力等级</option>
- <option value="0">魅力〇级</option>
- <option value="180">魅力一级</option>
- <option value="440">魅力二级</option>
- <option value="800">魅力三级</option>
- <option value="1300">魅力四级</option>
- <option value="2000">魅力五级</option>
- <option value="2800">魅力六级</option>
- <option value="3750">魅力七级</option>
- <option value="5000">魅力八级</option>
- <option value="6500">魅力九级</option>
- <option value="8300">魅力十级 </option>
- </select>
- </td>
- <td></td><td></td><td></td>
- </tr>
- </table>
- </div>
- <div align="center">
- <input type="submit" class="button" value="确定增加" />
-
- <input type="reset" value="重新输入" />
- </div>
- </div>
- </form>
- <?php } exit(); ?>
复制代码 请问如何设定? |