'".date("Y-m-d H:i:s",time()-3600*1440*1)."' and `Views` > 0 ";
$order = "order by `Views` DESC";
$poppath="";
}
if(isset($whcase))
{
$where=" and ".join(" and ",$whcase);
}
$photors = mysql_query("Select `postid`,`zoneid`,`catid`,`userid`,`Username`,`post_topic`,`postdate`,`Views` from `post_photo` where `active` = 1 and `catid` <> 999 {$where} {$order} LIMIT {$poplistsize}");
$vidrs = mysql_query("Select `postid`,`zoneid`,`catid`,`userid`,`extcode`,`Username`,`post_topic`,`postdate`,`Views` from `post_video` where `active` = 1 and `Views` > 100 AND postid <> 1058 {$order} LIMIT {$poplistsize}");
$webrs = mysql_query("Select `postid`,`zoneid`,`catid`,`userid`,`Username`,`post_topic`,`postdate`,`Views` from `post_web` where `active` = 1 and `catid` <> 999 {$where} {$order} LIMIT {$poplistsize}");
while($vidrow=@mysql_fetch_assoc($vidrs))
{
$vidrow["zonename"]="vid";
$vidrow["zonep"]=$__syslang["Videos"] ;
$postlist[]=$vidrow;
$viewlist[count($postlist)-1]=$vidrow["Views"];
}
while($photorow=@mysql_fetch_assoc($photors))
{
$photorow["zonename"]="photo";
$photorow["zonep"]=$__syslang["Photo"] ;
$postlist[]=$photorow;
$viewlist[count($postlist)-1]=$photorow["Views"];
}
while($webphotorow=@mysql_fetch_assoc($webrs))
{
$webphotorow["zonename"]="web";
$webphotorow["zonep"]=$__syslang["webzone"] ;
$postlist[]=$webphotorow;
$viewlist[count($postlist)-1]=$webphotorow["Views"];
}
arsort ($viewlist);
reset ($viewlist);
$i=0;
//foreach($viewlist as $k => $v)
$firstcount=0;
if(count($viewlist)==0){ echo "".$__syslang["no_record"]."" ; }
foreach($viewlist as $k => $v)
{
if($i >= 10 ) break ;
$i++;
//echo $postlist[$k][post_topic]."(".$postlist[$k][Views].")"." ";
?>
|
|
|
}
?>
|
999 order by `postid` DESC LIMIT {$poplistsize}");
if(!@mysql_num_rows($vidrs)){ echo "".$__syslang["no_record"]."" ; }
while($vidrow=@mysql_fetch_assoc($vidrs))
{
$i++;
$vidrow["zonename"]="vid";
$vidrow["zonep"]=$__syslang["Videos"] ;
?>
|
/.html">
|
| |
}
?>
|