 |
| |
 |
NEWEST GAMES |
 |
|
 |
$topsqlf = "SELECT * FROM `games` ORDER BY `id` DESC LIMIT 0,4";
$topresultf = mysql_query($topsqlf) or die('Error, query failed ' . mysql_error());
while($toprowf = mysql_fetch_array($topresultf))
{
$sbtf = $toprowf['sub_cat_url'];
if($sbtf != '')
{
$sprf = '/';
$subtf = $sbtf.$sprf;
}else{
$subtf = '';
}
$urlpf = $toprowf['cat_url']."/".$subtf;
$fntf = $toprowf['content_name'];
$gnametf = substr($fntf,0,strrpos($fntf,'.'));
?>
|
=$toprowf['title'];?>
$words = $toprowf['description'];
$someWords = $words;
$wordChunks = explode(" ", $someWords);
for($i = 0; $i < 16; $i++){
echo "$wordChunks[$i] ";
}
?>...
|
|
 |
|
}
?>
|
|
|
 |
|
|
|
|
 |
 |
TOP GAMES |
 |
|
 |
|
|
$topsqlf = "SELECT * FROM `games` ORDER BY `views` DESC LIMIT 0,8";
$topresultf = mysql_query($topsqlf) or die('Error, query failed ' . mysql_error());
while($toprowf = mysql_fetch_array($topresultf))
{
$sbtf = $toprowf['sub_cat_url'];
if($sbtf != '')
{
$sprf = '/';
$subtf = $sbtf.$sprf;
}else{
$subtf = '';
}
$vs = $toprowf['views'];
$urlpf = $toprowf['cat_url']."/".$subtf;
$fntf = $toprowf['content_name'];
$gnametf = substr($fntf,0,strrpos($fntf,'.'));
?>
}
?>
|
|
|
|
|
 |
|
|
|
|
|
$s = 0;
$sqlcat = "SELECT * FROM `games` WHERE `main_cat` = 'general' GROUP BY `cat_name` ORDER BY `cat_name` ASC";
$resultcat = mysql_query($sqlcat) or die('Error, query failed ' . mysql_error());
while($rowcat = mysql_fetch_array($resultcat))
{
$topsql = "SELECT * FROM `games` WHERE `cat_url` = '$rowcat[cat_url]' ORDER BY rand() DESC LIMIT 0,2";
$topsqls = "SELECT * FROM `games` WHERE `cat_url` = '$rowcat[cat_url]' ORDER BY rand() DESC LIMIT 0,3";
$s++;
$xs = $s%2;
if($xs ==0)
{
$color1='CADE61';
$colors = "EDF586";
$imgbg='gbg.gif';
$imgbgl='gl.gif';
$img1='g1.gif';
$img2='g2.gif';
$img3='g3.gif';
$img4='g4.gif';
$box='box1.gif';
$box4='box2.gif';
$sp='sp.gif';
$bluerr='gr.gif';
$bluelo='glo.gif';
}
else
{
$color1='B0D5FD';
$colors = "C6E0FD";
$imgbg='bluebg.gif';
$imgbgl='blueleft.gif';
$img1='blue1.gif';
$img2='blue2.gif';
$img3='blue3.gif';
$img4='blue4.gif';
$box='box3.gif';
$box4='box4.gif';
$sp='sp.gif';
$bluerr='bluerr.gif';
$bluelo='bluelo.gif';
}
?>
}
?>
|
include 'common/add_home.html';
include 'common/down.html';
?>
| | |