OwlCyberSecurity - MANAGER

Edit File: game(SEM-MICRODATA).php

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

#echo '<pre>';
#print_r($_GET); exit;
$idg = filter_input(INPUT_GET, 'id');

$query = $db->prepare("SELECT * FROM game WHERE idg=:idg OR  url=:url");
$query->execute(array('idg' => $idg, 'url' => $idg));

$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;
}

/* WGPlayer meta og image implementation */
$querywg = $db->prepare("SELECT * FROM game WHERE idg=:idg  OR  url=:url");
$querywg->execute(array('idg' => $idg, 'url' => $idg));
$resultwg = $querywg->fetch();

$pageTitle = _tDb($result, "game") ." ". _t("Dress Up Games") ." - ". _t("Kawaii Games");
?>
<!doctype html>
<html>
    <head>
        <meta charset="utf-8">
        <title><?= $pageTitle ?></title>

<meta property="og:locale" content="en_us">
        <meta property="og:url" content="<?= URL_BASE ?>game/<?= $result['url'] ?>">
        <meta property="og:title" content="<?= $pageTitle ?>">
        <meta itemprop='name' property="og:site_name" content="<?php echo _t("Kawaii Games") ?>">
        <meta property="og:description" content= "<?= _tDb($result, "game") ?>, <?= substr(_tDb($result, 'descricao'), 0, 100) ?>">
        
        <meta property="og:image" content="http://games.kawaiigames.net/icones/<?php echo $resultwg['imagem'] ?>">

<?php 
        /*
        
        
        <script type="text/javascript" src="http://st.wgplayer.com/kawaiigames.net/wgAds.desktop.conf.js"></script>
        <script type="text/javascript" src="http://st.wgplayer.com/kawaiigames.net/js/CNekQpJN5i0KOw3gBbIVMQ/2360998025/wgAds.js"></script>

*/
        ?>

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

</head>

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

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

<div class="col-md-10">
                    <div class="box-central">

<h2 class="barra-rosa titulo">
                            <div class="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>
<?= _tDb($result,'game') ?>
                            <?php
                            if (!empty($result['tipo_descricao'])) {
                                echo '<span class="tipo_descricao">' . $result['tipo_descricao'] . '</span>';
                            }
                            ?>
                        </h2>

<div class="text-center area-jogo" id="gameContainer">
<?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"><?= _t("This game does not work on mobile devices.")?></h3>
                                        <h4 class="fonte-rosa"><?= _t("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 />

<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 class="col-md-5 text-center">

<div id='snhb-incontent-02-0'></div>

</aside>
                        </div>

<br>

<div class="box-central" id="box-comments">
                        <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"); ?>
        
        <script>
            $(function(){
                $('.mobile .area-jogo').css("min-height",'auto');
                $('.mobile #logo, .mobile aside, .mobile #box-comments, .mobile #box-description, .mobile #box-recommend, .mobile .barra-rosa').remove();
            })
        </script>
    </body>
</html>