OwlCyberSecurity - MANAGER

Edit File: popular-games.php

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

# CÓDIGO ANTIGO ----------------------------------------------------------------
#$query = $db->prepare("SELECT * FROM game ORDER BY visitas DESC");
#$query->execute();
#$result = $query->fetchAll(PDO::FETCH_ASSOC);

$paginacao = new Paginacao($db);
$result = $paginacao->Registros("SELECT * FROM game WHERE publicado=true AND data_publicar <= NOW() ORDER BY visitas DESC"); // , ponto DESC
$linksPaginacao = $paginacao->links(URL_BASE . "popular-games/");

$pageTitle = _t("Popular Games") ." ". _t("Dress Up Games") ." - "._t("Kawaii Games");

$canonical = URL_BASE . "popular-games";

$linksBradCrup = [
    $canonical => _t("Popular Games"),
];
?>
<!doctype html>
<html>
    <head itemscope itemtype="http://schema.org/WebSite">
        <meta charset="utf-8">
        <title><?php echo $pageTitle ?></title>

<meta property="og:locale" content="en_us">
        <meta property="og:url" content="<?= $canonical ?>">
        <meta itemprop='name' property="og:title" content="<?php echo $pageTitle ?>">
        <meta property="og:site_name" content="<?php echo _t("Kawaii Games")?>">
        <meta property="og:description" content= "<?php echo _t("Girls games, dress up games, avatar doll creators and coloring games with the most views and votes.") ?>">
        <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); ?>

<?php
                            foreach ($result as $item) {
                                include("includes/game-item.php");
                            }//foreach
                            ?>

<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"); ?>

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

</body>
</html>