ExecuteNoneQuery("SELECT a.id,a.title,a.litpic,a.description,a.senddate,b.typename,b.typedir,b.namerule FROM `#@__archives` a INNER JOIN `#@__arctype` b ON a.typeid=b.id and a.typeid in ($typeid) And a.arcrank=0 And a.flag not like '%c%' order by a.id desc limit $start,$number"); while($rs=mysql_fetch_assoc($query)) { $typedir = substr($rs['typedir'],strpos($rs['typedir'],'/'),50); $urlid = substr($rs['namerule'],strpos($rs['namerule'],'/'),50); $urlid = str_replace('{Y}',date('Y',$rs['senddate']),$urlid); $urlid = str_replace('{M}',date('m',$rs['senddate']),$urlid); $urlid = str_replace('{D}',date('d',$rs['senddate']),$urlid); $urlid = str_replace('{aid}',$rs['id'],$urlid); $pathus =$typedir.$urlid; $title = mb_substr($rs['title'],0,13,'utf-8'); $urlid = $rs['namerule']; $description = mb_substr($rs['description'],0,32,'utf-8'); $date = date('Y / m / d',$rs['senddate']); $str .= "

$\"{$rs[title]}\"$

{$rs[title]}

{$rs[description]}more...

{$date}

"; } echo $str; exit; }else if($cd == 2){ $id = (int)$id; $sonid = GetSonIds($id); $query = "SELECT SUM(`clicknum`) as num FROM #@__arctype where id in ($sonid)"; $affect = $dsql->GetOne($query); echo "document.write('".$affect['num']."');"; exit; }else if($cd == 3){ $id = (int)$id; $ip = GetIP(); $ipqy = "SELECT id FROM #@__click_ip where ip='$ip' and SUBSTRING(NOW(),1,10)=FROM_UNIXTIME(`senddate`,'%Y-%m-%d') and typeid='$id'"; $ipfect = $dsql->GetOne($ipqy); if($ipfect){ echo "10000000"; exit; } $query = "update #@__arctype set `clicknum`=`clicknum`+1 where id='$id'"; $dsql->ExecuteNoneQuery($query); $time= time(); $qt = "insert into #@__click_ip (`ip`,`senddate`,`typeid`) values('$ip','$time','$id')"; $dsql->ExecuteNoneQuery($qt); $sonid = GetSonIds($id); $query2 = "SELECT SUM(`clicknum`) as num FROM #@__arctype where id in ($sonid)"; $affect = $dsql->GetOne($query2); echo $affect['num']; exit; }else if($cd == 4){ //$ipdress = GetIP(); $ipqy = "SELECT phone FROM #@__yuyue where SUBSTRING(NOW(),1,10)=FROM_UNIXTIME(UNIX_TIMESTAMP(created),'%Y-%m-%d') and phone='$phone'"; $ipfect = $dsql->GetOne($ipqy); //判断电话是否重复 if($ipfect && $_COOKIE['yx_xf']){ echo "10000000"; exit; } $time= time(); $created = date("Y-m-d H:i"); $qt = "insert into #@__yuyue (`username`,`sex`,`phone`,`ipdress`,`created`) values('$username','$sex','$phone','$ipdress','$created')"; $dsql->ExecuteNoneQuery($qt); if(!$dsql){ echo "22"; exit; }else{ setcookie("yx_xf",1,time()+24*60*60*1000); } } ?>