query($sql) as $row) {
//echo $row['id']." ".$row['title']." ".$row['plays']."
";
//header("Location: $redirURL");
// echo ''. $siteurl . 'game/' . $row['gid'] . '/'.$catCat.'/' . $gameurl . '.html';
$arrayGameID[] = $row['id'];
}
$rndGameID = array_rand($arrayGameID, 1);
//echo $rndGameID . "
";
$sql = "SELECT g.id AS gid, g.code, g.title AS gTitle, c.name AS catName FROM `games` g LEFT JOIN `categories` c ON g.category = c.id WHERE g.id = " . $arrayGameID[$rndGameID] . "";
foreach ($pdo->query($sql) as $row) {
// echo $row['gid']." ".$row['gTitle']."
";
// echo "URL: ".$row['code']."
";
// echo "Kategorie: " . cleanGameCat($row['catName']) . "
";
$catCat = cleanGameCat($row['catName']);
$gameurl = cleanGameURL($row['gTitle']);
$redirURL = $siteurl . 'game/' . $row['gid'] . '/' . $catCat . '/' . $gameurl . '.html';
// header("Location: $redirURL");
//echo ''. $siteurl . 'game/' . $row['gid'] . '/'.$catCat.'/' . $gameurl . '.html';
}
?>
rd.zocke.es
you'll be redirected to: