时间:2021-07-01 10:21:17 帮助过:2人阅读
function auto($second,$gid,$shutuid)
{
global $table_prefix;
//取出此商品已经竞拍次数
$maxnumber=0;
$unumber=array();
$query=mysql教程_query("select id,uid from `".$table_prefix."buylog` where gid=".$gid);
while($rows=mysql_fetch_assoc($query))
{
$maxnumber++;
if(isset($unumber[$rows['uid']]))
{
$unumber[$rows['uid']]++;
}
else
{
$unumber[$rows['uid']]=0;
}
}
//取出自动竞拍的会员
$sql="select uid,username,number,second,maxnumber,gid,ip from `".$table_prefix."autobuy` where gid=".$gid;
$query=mysql_query($sql);
$allow=array();
$shutuid=explode(',',$shutuid);
while($rows=mysql_fetch_assoc($query))
{
$seconds=explode(',',$rows['second']);
$unumber[$rows['uid']]=isset($unumber[$rows['uid']])?$unumber[$rows['uid']]:0;
if(in_array($second,$seconds) && !in_array($rows['uid'],$shutuid) && $rows['maxnumber']<=$maxnumber && $rows['number']>$unumber[$rows['uid']]) //包含时刻,并且不在黑名单,符合此会员竞拍次数设置
{
$allow[]=$rows['uid'];
}
}
$allowuser=array();
if($allow)
{
$query=mysql_query('select uid,username,money,ip from `'.$table_prefix.'user` where uid in ('.implode(',',$allow).')');
while($rows=mysql_fetch_assoc($query))
{
$allowuser[]=$rows;
}
}
unset($allow,$sql,$number,$maxnumber,$shutuid,$query,$u);
return $allowuser;
}
http://www.bkjia.com/PHPjc/444827.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/444827.htmlTechArticle用户提交自己的信息后,保存在数据库教程中,程序每一次读取当前结果时都要判断一次,如用户可设置几秒钟时参加竞拍,竞拍多少次,...