功能:用户提交自己的信息后,保存在数据库中,程序每一次读取当前结果时都要判断一次,如用户可设置几秒钟时参加竞拍,竞拍多少次,并且可以设置前面有多少人竞拍后我才参加,比较人性化的功能,实例代码如下:
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)) { //开源代码 Mou.Pw $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.savh.cn/thread-212.htm
转载请注明:Savh.Cn 发表