OwlCyberSecurity - MANAGER

Edit File: random-game.php

<?php
include("includes/config.php");
include("includes/conexao.php");

$query = $db->prepare("SELECT * FROM game WHERE publicado=true AND data_publicar <= NOW() ORDER BY RAND() LIMIT 1");
$query->execute();

$result = $query->fetch(PDO::FETCH_ASSOC);

$idg = $result['idg'];
$ponto_do_game = $result['votos'] > 0 ? $result['ponto'] / $result['votos'] : 0;
$ponto_do_game = number_format($ponto_do_game, 2);

# contar visualização para contar apenas uma vez que acessa
if (!isset($_SESSION["game-{$idg}"])) {
    $queryContar = $db->prepare("UPDATE game SET visitas=visitas+1 WHERE idg=:idg");
    $queryContar->execute(array('idg' => $idg));

$_SESSION["game-{$idg}"] = true;
}

$pageTitle = _t("Random Game") ." ". _tDb($result, 'game') ." - ". _t("Kawaii Games");

$linksBradCrup = [
    "/random-game" => _t("Random Game"),
    "/game//{$idg}" => _tDb($result, "game"),
];
?>
<!doctype html>
<html>
    <head itemscope itemtype="https://schema.org/WebSite">
        <meta charset="utf-8">
        <title><?php echo $pageTitle ?></title>

<meta property="og:locale" content="en_us">
        <meta property="og:url" content="<?= URL_BASE ?>random-game">
        <meta property="og:title" content="<?php echo $pageTitle ?>">
        <meta itemprop='name' property="og:site_name" content="<?php echo _t("Kawaii Games") ?>">
        <meta property="og:description" content= "<?= substr(_tDb($result, 'descricao'), 0, 152) ?>">
        <meta property="og:image" content="//www.kawaiigames.net/kawaii_games_logo.fw.png">

<?php if($idg == 634){ // game: japao-nosso-de-cada-dia-pritt-and-lohgann-dress-up?>
            <script>wgAutoInit = false;</script>
        <?php }?>
		
        
        <script type="text/javascript" src="//st.wgplayer.com/kawaiigames.net/wgAds.desktop.conf.js"></script>
        <script type="text/javascript" src="//st.wgplayer.com/kawaiigames.net/js/CNekQpJN5i0KOw3gBbIVMQ/2360998025/wgAds.js"></script>

<?php include ("includes/head.php"); ?>

</head>

<?php include ("includes/topo.php"); ?>

<div class="container">
            <div class="row">

<?php include ("includes/menu-esquerdo.php"); ?>

<div class="col-md-10" itemscope itemtype="https://schema.org/Game">
                    <?php echo breadcrumb_links($linksBradCrup); ?>
                    <div class="box-central">
                        
                        <div class="boxVotacao pull-right">
                            <input type="range" value="<?= $ponto_do_game ?>" step="0.5" id="backing5">
                            <div class="rateit" id="game-rateit" 
                                data-productid="<?= $idg ?>"
                                data-rateit-backingfld="#backing5" 
                                data-rateit-resetable="false"
                                data-rateit-ispreset="true"
                                data-rateit-min="0" 
                                data-rateit-max="5" 
                                data-rateit-starwidth="20" 
                                data-rateit-starheight="20"
                                <?php if (isset($_SESSION["game-votado-{$idg}"])) { ?>
                                    data-rateit-readonly="true"
                                <?php } ?>
                                >
                            </div>

<div class="pull-right" id="game_resultado_pontuacao"></div>
                            <script>GameResultadoVotacao(<?= $idg ?>);</script>
                        </div>

<?php
                            if (!empty($result['tipo_descricao'])) {
                                echo '<span class="tipo_descricao">' . $result['tipo_descricao'] . '</span>';
                            }
                            ?>
                        </h1>

<div class="text-center area-jogo">
                            <?php
                            if ($result['tipo'] == "html5" || $result['tipo'] == "embed") {
                                $url = $result['tipo'] == "html5" ? URL_BASE_GAMES . "jogos/" . $result['swf'] ."/" : $result['swf'];
                                ?>
                                <div class="game-canvas">
                                    <embed width="100%" height="100%" frameborder='0' marginwidth='0' marginheight='0' scrolling='no' src="<?= $url ?>" style="border: 0px; display: inline-block; margin: 0; padding: 0" />
                                </div>
                                <?php
                            } else {
                                ?>
                                <div class="game-canvas">
                                    <?php
                                    if($isMobile){
                                    ?>
                                    <div class="text-center">
                                        <br />
                                        <br />
                                        <br />
                                        <br />
                                        <br />
                                        <h3 class="fonte-rosa">This game does not work on mobile devices.</h3>
                                        <h4 class="fonte-rosa">Play on the computer <br /> or go to the <a href="/mobile-games">mobile games</a> session</h4>
                                    </div>
                                    <?php
                                    }
                                    else{
                                    ?>
                                        <embed width="800" height="600" src="<?= URL_BASE_GAMES ?>jogos/<?= $result['swf'] ?>">
                                        <?php
                                    }
                                    ?>
                                </div>
                                <?php
                            }
                            ?>
                        </div>

</div>
                    <br />
                    
					
                    <br />

<amp-ad width="100vw" height="320"
                            type="adsense"
                            data-ad-client="ca-pub-6135483131884855"
                            data-ad-slot="2142958168"
                            data-auto-format="rspv"
                            data-full-width="">
                          <div overflow=""></div>
                    </amp-ad>
                    
                        
                    <div class="box-central">
                        <h2 class="barra-rosa titulo"> 
                            <strong class=" pull-right">
                                <?= _tDb($result, 'visitas') ?> 
                                <?php echo _t("Views")?>
                            </strong> 
                            <?php echo _t("Description") ?>
                        </h2>
                       
                        <div class="row">
                            <div class="col-md-12 textao text-justify">
                                <p><?php echo str_replace("<a", '<a rel="nofollow"', _tDb($result, 'descricao')) ?></p>
                                <?php include 'includes/game-tags.php'; ?>
                            </div> 
                        </div>

<div class="a2a_kit a2a_kit_size_32 a2a_default_style">
                                    <a class="a2a_dd" href="https://www.addtoany.com/share"></a>
                                    <a class="a2a_button_facebook"></a>
                                    <a class="a2a_button_twitter"></a>
                                    <a class="a2a_button_google_plus"></a>
                                </div>
                                <script>
                                    var a2a_config = a2a_config || {};
                                    a2a_config.linkname = "Kawaii Games";
                                </script>
                                <script async src="https://static.addtoany.com/menu/page.js"></script>
                                
                            </div>

<?php
                            if ($result['tipo'] == 'embed') {
                                ?>
                                <div class="col-md-7 textao">
                                    <p><strong><?php echo _t("URL Share") ?>:</strong></p>
                                    <input type="text" class="form-control" value="<?= $result['swf'] ?>">
                                </div> 
                                <?php
                            } else if ($result['tipo'] == 'html5') {
                                ?>
                                <div class="col-md-7 textao">
                                    <p><strong><?php echo _t("URL Share") ?>:</strong></p>
                                    <input type="text" class="form-control" value="<?= URL_BASE_GAMES ?>jogos/<?= $result['swf'] ?>">
                                </div> 
                                <?php
                            } else {
                                ?>
                                <div class="col-md-7 textao">
                                    <p><strong><?php echo _t("Embed code") ?>:</strong></p>
                                    <input type="text" class="form-control" value="<embed width='800' height='600' src='<?= URL_BASE_GAMES ?>jogos/<?= $result['swf'] ?>'>">
                                </div>

<div class="col-md-2 textao text-right">
                                    <p><strong><?php echo _t("Download") ?></strong></p>
                                    <a href="<?= URL_BASE_GAMES ?>jogos/<?= $result['swf'] ?>" target="_blank">
                                        <i class="fa fa-download fa-5x" aria-hidden="true"></i>
                                    </a>
                                </div>
                                <?php
                            }
                            ?>

</div>
                    </div>

<br>

<?php
                                $queryRec = $db->prepare("SELECT * FROM game WHERE publicado=true AND data_publicar <= NOW() AND categoria=:categoria ORDER BY RAND() LIMIT 6");
                                $queryRec->execute(array('categoria' => $result['categoria']));

$resultRec = $queryRec->fetchAll(PDO::FETCH_ASSOC);

foreach ($resultRec as $itemRec) {
                                    $item = $itemRec;
                                    include("includes/game-item.php");
                                }
                                ?>

</div>

</aside>
                        </div>

<br>

<div class="box-central">
                        <h2 class="barra-rosa titulo"><?php echo _t("Comments") ?></h2>
                        <div class="textao">

<div id="disqus_thread"></div>
                            <script>
                                (function () {
                                    var d = document, s = d.createElement('script');
                                    s.src = '//kawaiigames.disqus.com/embed.js';
                                    s.setAttribute('data-timestamp', +new Date());
                                    (d.head || d.body).appendChild(s);
                                })();
                            </script>

</div>
                        <script id="dsq-count-scr" src="//kawaiigames.disqus.com/count.js" async></script>
                    </div>
                </div>

</div>
        </div>

<?php include ("includes/rodape.php"); ?>

<?php include ("includes/snigel-stickerboard.php"); ?>

<?php include ("includes/infolinks-ads.php"); ?>
    </body>
</html>