一款自動競拍出價程序

用戶提交自己的信息後，保存在數據庫教程中，程序每一次讀取當前結果時都要判斷一次，如用戶可設置幾秒鐘時參加競拍，競拍多少次，並且可以設置前面有多少人競拍後我才參加，都是一些人性化的功能//自動出價

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;
}