OwlCyberSecurity - MANAGER

Edit File: game-category.php

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

$categoria = filter_input(INPUT_GET, 'categoria');

# RECUPERANDO O ID DA CATEGORIA 
$querycateg = $db->prepare("SELECT * FROM categorias WHERE urlamigavel=:urlamigavel");
$querycateg->execute(array('urlamigavel' => $categoria));
$resultcateg = $querycateg->fetch(PDO::FETCH_ASSOC);

$categoria_id = $resultcateg['idc'];

# BUSCANDO OS JOGOS DA CATEGORIA
$paginacao = new Paginacao($db);
$result = $paginacao->Registros("SELECT * FROM game WHERE publicado=true AND data_publicar <= NOW() AND categoria=:categoria ORDER BY idg DESC", array('categoria' => $categoria_id));
$linksPaginacao = $paginacao->links(URL_BASE . "game-category/{$categoria}/");

$description = _tDb($resultcateg, 'categoria');
$cont = 0;

foreach ($result as $item) {
    $cont++;
    if($cont >= 4){break;}
    $description .= ", " . _tDb($item, 'game');
}

$pageTitle = _tDb($resultcateg, 'categoria') ." ". _t("Dress Up Games") ." - ". _t("Kawaii Games");

$canonical = URL_BASE . "game-category/{$categoria}";

$linksBradCrup = [
    $canonical => _tDb($resultcateg, 'categoria'),
];
?>
<!doctype html>
<html>
    <head itemscope itemtype="http://schema.org/WebSite">
        <meta charset="utf-8">
        <title><?= $pageTitle?></title>

<meta property="og:locale" content="en_us">
        <meta property="og:url" content="<?= $canonical ?>">
        <meta property="og:title" content="<?= $pageTitle?>">
        <meta itemprop='name' property="og:site_name" content="<?php echo _t("Kawaii Games")?>">
        <meta property="og:description" content= "<?= $description ?>">
        <meta property="og:image" content="//www.kawaiigames.net/kawaii_games_logo.fw.png">

<?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">
                    
                    <?php echo breadcrumb_links($linksBradCrup); ?>

<a href="#comecoSite" class="scroll">
                                <i class="glyphicon glyphicon-circle-arrow-up"></i>
                            </a>

</div>

<?php echo $linksPaginacao; ?>
                    </div>
                </div>

</div>
        </div>

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

</body>
</html>