用户提交自己的信息后,保存在数据库中,程序每一次读取当前结果时都要判断一次,如用户可设置几秒钟时参加竞拍,竞拍多少次,并且可以设置前面有多少人竞拍后我才参加,都是一些人性化的功能,实例代码如下:
- 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;
- }
|