21,893
社区成员




$ms =& ms();
$this->assign('set_avatar', $ms->user->set_avatar($id));
$this->assign('user', $user);
$this->assign('phone_tel', explode('-', $user['phone_tel']));
/* 导入jQuery的表单验证插件 */
$this->import_resource(array(
'script' => 'jquery.plugins/jquery.validate.js'
));
$page = $this->_get_page();
//tixian code
$con = mysql_connect("localhost","a0527232048","abc");
mysql_select_db("a0527232048",$con);
$sql="select * from ecm_configs where id=1";
$rows=array();
$rows=mysql_query($sql,$con);
while($row=mysql_fetch_array($rows))
{
$ct1=$row[10];//兑换条件最低积分
$ct2=$row[11]; //兑换时间
$ct3=$row[12]/100; //兑换比率
}
if ($jf1==0 and $jf2==0 and $jf3==0)
{
$sql2="SELECT m.user_name, IFNULL(sum(c.cons), 0) AS cons
FROM ecm_member AS m LEFT JOIN caifujifen AS c ON c.to2=m.user_id
WHERE 1 GROUP BY m.user_name
ORDER BY cons desc";
}
if ($jf1==0 and $jf2==0 and $jf3==1)
{
$sql2="select * from (SELECT m.user_name, IFNULL(sum(c.cons), 0) AS cons
FROM ecm_member AS m LEFT JOIN caifujifen AS c ON c.to2=m.user_id
WHERE 1 GROUP BY m.user_name
ORDER BY cons desc) as t where cons>=".$ct1."";
}
if ($jf1!==0 and $jf2!==0 and $jf3==2)
{
$sql2="select * from (SELECT m.user_name, IFNULL(sum(c.cons), 0) AS cons
FROM ecm_member AS m LEFT JOIN caifujifen AS c ON c.to2=m.user_id
WHERE 1 GROUP BY m.user_name
ORDER BY cons desc) as t where cons>=".$jf1." and cons<=".$jf2."";
}
$rows2=mysql_query($sql2,$con);
$lists=array();
$page['item_count'] = mysql_num_rows($rows2);
while($row2=mysql_fetch_row($rows2))
{
$username=$row2[0];
$jifen=$row2[1];
$mon=$jifen*$ct3;
$lists[]="<tr><td width=50></td>".$username."</td><td width=100>".$jifen."</td><td width=100>".$mon."</td><td width=250><td><td width=100><a href=#>a</a></td>";
}
//tixian code end
$this->_format_page($page);
$this->assign('page_info', $page);
//$this->assign('cftj',zdcfjf($id));
$this->assign('txlist',$sql2);
$this->display('user.tixian.html');
<table class="tab1">
<tr><td width="50" align="center"><strong>ID</strong></td><td width="100" align="center"><strong>用户</strong></td><td width="100" align="center"><strong>财富积分</strong></td><td width="350" align="center"><strong>可提现金额</strong></td><td width="100" align="center"><strong>操作</strong></td></tr>
{foreach from=$txlist item=txlist }
{$txlist}
{/foreach}
</table>
function tixian()
{
$ms =& ms();
$this->assign('set_avatar', $ms->user->set_avatar($id));
$this->assign('user', $user);
$this->assign('phone_tel', explode('-', $user['phone_tel']));
/* 导入jQuery的表单验证插件 */
$this->import_resource(array(
'script' => 'jquery.plugins/jquery.validate.js'
));
$page = $this->_get_page();
//tixian code
$con = mysql_connect("localhost","a0527232048","21740200");
mysql_select_db("a0527232048",$con);
$sql="select * from ecm_configs where id=1";
$rows=array();
$rows=mysql_query($sql,$con);
while($row=mysql_fetch_array($rows))
{
$ct1=$row[10];//兑换条件最低积分
$ct2=$row[11]; //兑换时间
$ct3=$row[12]/100; //兑换比率
}
if ($jf1==0 and $jf2==0 and $jf3==0)
{
$sql2="SELECT m.user_name, IFNULL(sum(c.cons), 0) AS cons
FROM ecm_member AS m LEFT JOIN caifujifen AS c ON c.to2=m.user_id
WHERE 1 GROUP BY m.user_name
ORDER BY cons desc";
}
if ($jf1==0 and $jf2==0 and $jf3==1)
{
$sql2="select * from (SELECT m.user_name, IFNULL(sum(c.cons), 0) AS cons
FROM ecm_member AS m LEFT JOIN caifujifen AS c ON c.to2=m.user_id
WHERE 1 GROUP BY m.user_name
ORDER BY cons desc) as t where cons>=".$ct1."";
}
if ($jf1!==0 and $jf2!==0 and $jf3==2)
{
$sql2="select * from (SELECT m.user_name, IFNULL(sum(c.cons), 0) AS cons
FROM ecm_member AS m LEFT JOIN caifujifen AS c ON c.to2=m.user_id
WHERE 1 GROUP BY m.user_name
ORDER BY cons desc) as t where cons>=".$jf1." and cons<=".$jf2."";
}
$rows2=mysql_query($sql2,$con);
$lists=array();
$page['item_count'] = mysql_num_rows($rows2);
while($row2=mysql_fetch_row($rows2))
{
$username=$row2[0];
$jifen=$row2[1];
$mon=$jifen*$ct3;
$lists[]="<tr><td width=50></td>".$username."</td><td width=100>".$jifen."</td><td width=100>".$mon."</td><td width=250><td><td width=100><a href=#>a</a></td>";
}
//tixian code end
$this->_format_page($page);
$this->assign('page_info', $page);
//$this->assign('cftj',zdcfjf($id));
$this->assign('txlist',$lists);
$this->display('user.tixian.html');
}
//积分提现结束