$p = abs(intval(Tools::getValue('p', 1)));
if ($p < 1) $p = 1;
$n = abs(intval(Tools::getValue('n', intval(Configuration::get('PS_PRODUCTS_PER_PAGE')))));

$pics = Db::getInstance()->ExecuteS("select * from "._DB_PREFIX_."mgallery order by id desc limit ".((intval($p) - 1) * intval($n)).','.intval($n));

$count = Db::getInstance()->ExecuteS("select * from "._DB_PREFIX_."mgallery order by id desc");
$nbProducts = count($count);
include(dirname(__FILE__).'/pagination.php');

// checks if template exists
        if (!$_template->source->exists) {
            if ($_template->parent instanceof Smarty_Internal_Template) {
                $parent_resource = " in '{$_template->parent->template_resource}'";
            } else {
                $parent_resource = '';
            }
            throw new SmartyException("Unable to load template {$_template->source->type} '{$_template->source->name}'{$parent_resource}");
        }