include("config.inc.php"); if(!isset($_GET["name"])){ header("Location: " . $base . "index.php"); die(); } $cat_name=mysql_real_escape_string($_GET["name"]); if($cat_name == "willekeurig"){ $category_name="Willekeurig"; $game_query="SELECT * FROM game WHERE 1 ORDER BY rand() LIMIT 60;"; }elseif($cat_name == "nieuwst"){ $category_name="Nieuwst"; $game_query="SELECT * FROM game WHERE 1 ORDER BY date DESC LIMIT 60;"; }elseif($cat_name == "populairst"){ $category_name="Populairst"; $game_query="SELECT * FROM game WHERE 1 ORDER BY views DESC LIMIT 60;"; }else{ $query="SELECT * FROM category WHERE name='$cat_name';"; $result=mysql_query($query); if(mysql_num_rows($result) == 0){ header("Location: " . $base . "index.php"); die(); } $category=mysql_fetch_object($result); $category_name = $category->name; $game_query="SELECT * FROM game WHERE category='" . $category->id . "' ORDER BY views DESC;"; } include("top.inc.php"); //De kleur berekenen switch(strtolower($category_name)){ case "willekeurig": $color="blue"; break; case "populairst": $color="green"; break; case "nieuwst": $color="orange"; break; case "behendigheid": $color="blue"; break; case "denk": $color="rose"; break; case "humor": $color="yellow"; break; case "avontuur": $color="brown"; break; case "afreageren": $color="orange"; break; case "multiplayer": $color="rose"; break; case "shooter": $color="darkrose"; break; case "race": $color="green"; break; case "sport": $color="orange"; break; case "vliegen": $color="brown"; break; case "retro": $color="bluepurple"; break; case "vecht": $color="green"; break; case "spongebob": $color="yellow"; break; case "casino": $color="darkgreen"; break; } $result=mysql_query($game_query); $count=mysql_num_rows($result); ?>