/home
/u800617633
/domains
/eurocarnavales.es
/public_html
/system
/composer_library
/db
/mysqli.php
while ($row = $query->fetch_assoc()) {
$data[] = $row;
}
$result = new \stdClass();
$result->num_rows = $query->num_rows;
$result->row = isset($data[0]) ? $data[0] : array();
$result->rows = $data;
$result->sql = $sql;
$query->close();
return $result;
}
else {
return true;
}
}
else {
throw new \Exception('Error: ' . $this->connection->error . '<br />Error No: ' . $this->connection->errno . '<br />' . $sql);
}
}
public function escape($value)
{
return $this->connection->real_escape_string($value);
}
public function countAffected()
{
return $this->connection->affected_rows;
}
public function getLastId()
{
return $this->connection->insert_id;
}
public function connected()
{
Arguments
"Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND pe.quantity > 0 AND pe.location IS NOT NULL AND pe.location = p.model AND...' at line 1<br />Error No: 1064<br />SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) INNER JOIN product p ON (p2c.product_id = p.product_id) INNER JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '2' AND (p.status = '1') AND p.searchable = 1 AND DATE(p.date_available) <= DATE(NOW()) AND (DATE(p.date_expiration) >= DATE(NOW()) OR p.date_expiration is null OR UNIX_TIMESTAMP(`date_expiration`) = 0 OR UNIX_TIMESTAMP(`date_expiration`) is null) AND p.price > 0 AND cp.path_id IN (108) AND p.model IS NOT NULL AND TRIM(p.model) <> '' AND p.model IN (SELECT pe.location FROM product pe WHERE AND pe.quantity > 0 AND pe.location IS NOT NULL AND pe.location = p.model AND (pe.status = 1) AND pe.color_id = '20' AND pe.color_value_id = '597') AND p.outlet = '0'"
/home
/u800617633
/domains
/eurocarnavales.es
/public_html
/system
/composer_library
/db.php
<?php
class DB {
private $adaptor;
public function __construct($adaptor, $hostname, $username, $password, $database, $port = NULL) {
$class = 'DB\\' . $adaptor;
if (class_exists($class)) {
$this->adaptor = new $class($hostname, $username, $password, $database, $port);
} else {
throw new \Exception('Error: Could not load database adaptor ' . $adaptor . '!');
}
}
public function query($sql, $params = array()) {
return $this->adaptor->query($sql, $params);
}
public function escape($value) {
return $this->adaptor->escape($value);
}
public function countAffected() {
return $this->adaptor->countAffected();
}
public function getLastId() {
return $this->adaptor->getLastId();
}
public function connected() {
return $this->adaptor->connected();
}
public function version() {
return $this->adaptor->version();
}
}
Arguments
"SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) INNER JOIN product p ON (p2c.product_id = p.product_id) INNER JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '2' AND (p.status = '1') AND p.searchable = 1 AND DATE(p.date_available) <= DATE(NOW()) AND (DATE(p.date_expiration) >= DATE(NOW()) OR p.date_expiration is null OR UNIX_TIMESTAMP(`date_expiration`) = 0 OR UNIX_TIMESTAMP(`date_expiration`) is null) AND p.price > 0 AND cp.path_id IN (108) AND p.model IS NOT NULL AND TRIM(p.model) <> '' AND p.model IN (SELECT pe.location FROM product pe WHERE AND pe.quantity > 0 AND pe.location IS NOT NULL AND pe.location = p.model AND (pe.status = 1) AND pe.color_id = '20' AND pe.color_value_id = '597') AND p.outlet = '0'"
[]
/home
/u800617633
/domains
/eurocarnavales.es
/public_html
/catalog
/model
/catalog
/product.php
public function getTotalProducts($data = []) {
$product_data = false;
if ($this->config->get('cache_type')) {
$data['config_customer_group_id'] = $this->config->get('config_customer_group_id');
$data['config_news_field'] = $this->config->get('config_news_field');
$data['config_sort_order_product'] = $this->config->get('config_sort_order_product');
$data['config_sort_order_product_ext'] = $this->config->get('config_sort_order_product_ext');
$data['user'] = !!$this->user->isLogged();
$cache = md5(http_build_query($data));
$c_key = 'products.' . (int)$this->config->get('config_store_id') . '.' . (int)$this->config->get('config_language_id') . '.total.' . $cache;
$product_data = $this->cache->get($c_key);
}
if ($product_data === false) {
$sql = "SELECT COUNT(DISTINCT p.product_id) AS total";
$sql .= $this->filterProducts($data, 'count');
$query = $this->db->query($sql);
if ($this->config->get('cache_type')) {
$this->cache->set($c_key, $query->row);
}
return $query->row['total'];
}
return $product_data['total'];
}
public function getProfile($product_id, $recurring_id) {
$product_profile_data = false;
if ($this->config->get('cache_type')) {
$data['product_id'] = $product_id;
$data['recurring_id'] = $recurring_id;
$data['config_customer_group_id'] = $this->config->get('config_customer_group_id');
$cache = md5(http_build_query($data));
$c_key = 'product.' . $product_id . '.' . (int)$this->config->get('config_language_id') . '.profile.' . $cache;
$product_profile_data = $this->cache->get($c_key);
Arguments
"SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) INNER JOIN product p ON (p2c.product_id = p.product_id) INNER JOIN product_description pd ON (p.product_id = pd.product_id) WHERE pd.language_id = '2' AND (p.status = '1') AND p.searchable = 1 AND DATE(p.date_available) <= DATE(NOW()) AND (DATE(p.date_expiration) >= DATE(NOW()) OR p.date_expiration is null OR UNIX_TIMESTAMP(`date_expiration`) = 0 OR UNIX_TIMESTAMP(`date_expiration`) is null) AND p.price > 0 AND cp.path_id IN (108) AND p.model IS NOT NULL AND TRIM(p.model) <> '' AND p.model IN (SELECT pe.location FROM product pe WHERE AND pe.quantity > 0 AND pe.location IS NOT NULL AND pe.location = p.model AND (pe.status = 1) AND pe.color_id = '20' AND pe.color_value_id = '597') AND p.outlet = '0'"
/home
/u800617633
/domains
/eurocarnavales.es
/public_html
/system
/engine
/loader.php
$file = $file_cus;
$class = 'Model' . CUSTOMER . preg_replace('/[^a-zA-Z0-9]/', '', substr($route, 0, strrpos($route, '/')));
}
}
if (is_file($file)) {
include_once($file);
$model[$route] = new $class($registry);
} else {
throw new \Exception('Error: Could not load model ' . substr($route, 0, strrpos($route, '/')) . '!');
}
}
$method = substr($route, strrpos($route, '/') + 1);
$callable = array($model[$route], $method);
if (is_callable($callable)) {
$output = call_user_func_array($callable, $args);
} else {
throw new \Exception('Error: Could not call model/' . $route . '!');
}
// Trigger the post events
$result = $registry->get('event')->trigger('model/' . $route . '/after', array(&$route, &$args, &$output));
if ($result) {
return $result;
}
return $output;
};
}
}
Arguments
array:20 [
"filter_sub_category" => true
"filter_category_id" => "108"
"filter_filter" => ""
"filter_attribute" => ""
"filter_date" => ""
"filter_color" => array:2 [
0 => "20"
1 => "597"
]
"filter_size" => []
"filter_latest" => ""
"filter_outlet" => ""
"filter_from_price" => ""
"filter_to_price" => ""
"sort" => "p.sort_order"
"order" => "DESC"
"start" => 0
"limit" => 24
"config_customer_group_id" => "1"
"config_news_field" => "field"
"config_sort_order_product" => array:2 [
"sort" => "p.sort_order"
"order" => "DESC"
]
"config_sort_order_product_ext" => ""
"user" => false
]
/home
/u800617633
/domains
/eurocarnavales.es
/public_html
/system
/engine
/proxy.php
$this->{$key} = $value;
}
public function __call($key, $args) {
$arg_data = array();
$args = func_get_args();
foreach ($args as $arg) {
if ($arg instanceof Ref) {
$arg_data[] =& $arg->getRef();
} else {
$arg_data[] =& $arg;
}
}
if (isset($this->{$key})) {
return call_user_func_array($this->{$key}, $arg_data);
/*} elseif (Str::starts_with($key, 'findBy')) {
$args_data = array(strtolower(str_replace('findBy', '', $key)), $arg_data);
return call_user_func_array($this->{'findBy'}, $args_data);*/
} elseif (Str::starts_with($key, 'findBy')) {
return $this->findBy(Str::snake(str_replace('findBy', '', $key)), $arg_data);
} else {
$trace = debug_backtrace();
exit('<b>Notice</b>: Undefined property: Proxy::' . $key . ' in <b>' . $trace[1]['file'] . '</b> on line <b>' . $trace[1]['line'] . '</b>');
}
}
}
Arguments
array:1 [
0 => array:15 [
"filter_sub_category" => true
"filter_category_id" => "108"
"filter_filter" => ""
"filter_attribute" => ""
"filter_date" => ""
"filter_color" => array:2 [
0 => "20"
1 => "597"
]
"filter_size" => []
"filter_latest" => ""
"filter_outlet" => ""
"filter_from_price" => ""
"filter_to_price" => ""
"sort" => "p.sort_order"
"order" => "DESC"
"start" => 0
"limit" => 24
]
]
array:1 [
0 => array:15 [
"filter_sub_category" => true
"filter_category_id" => "108"
"filter_filter" => ""
"filter_attribute" => ""
"filter_date" => ""
"filter_color" => array:2 [
0 => "20"
1 => "597"
]
"filter_size" => []
"filter_latest" => ""
"filter_outlet" => ""
"filter_from_price" => ""
"filter_to_price" => ""
"sort" => "p.sort_order"
"order" => "DESC"
"start" => 0
"limit" => 24
]
]
/home
/u800617633
/domains
/eurocarnavales.es
/public_html
/catalog
/controller
/product
/category.php
$filter_data['filter_name'] = $search;
$filter_data['filter_model_like'] = $search;
$filter_data['filter_description'] = $search;
$filter_data['filter_short_description'] = $search;
if ($this->config->get('config_search_tags', 0))
$filter_data['filter_tag'] = $search;
} elseif (empty($filter_data['filter_category_id']) && empty($filter_data['filter_filter']) && empty($filter_data['filter_from_price']) && empty($filter_data['filter_to_price']) && $this->config->get('config_product_featured')) {
$filter_data['filter_featured'] = 1;
if (!isset($this->request->get['sort']))
$filter_data['sort'] = 'p.featured';
if (!isset($this->request->get['order']))
$filter_data['order'] = 'DESC';
}
if (isset($this->request->get['tag']))
$filter_data['filter_tag'] = $this->request->get['tag'];
$product_total = $this->model_catalog_product->getTotalProducts($filter_data);
$data['limit_row'] = $this->config->get('config_theme._product_limit_row', 4);
$data['products'] = $this->recuperar_productos($filter_data, $url);
$url = '';
if (isset($this->request->get['filter'])) {
if (is_array($this->request->get['filter'])) {
$url .= '&' . array_string_index($this->request->get['filter'], 'filter');
} else {
$url .= '&filter=' . $this->request->get['filter'];
}
}
if (isset($this->request->get['limit'])) {
$url .= '&limit=' . $this->request->get['limit'];
}
Arguments
"getTotalProducts"
array:2 [
0 => "getTotalProducts"
1 => array:1 [
0 => array:15 [
"filter_sub_category" => true
"filter_category_id" => "108"
"filter_filter" => ""
"filter_attribute" => ""
"filter_date" => ""
"filter_color" => array:2 [
0 => "20"
1 => "597"
]
"filter_size" => []
"filter_latest" => ""
"filter_outlet" => ""
"filter_from_price" => ""
"filter_to_price" => ""
"sort" => "p.sort_order"
"order" => "DESC"
"start" => 0
"limit" => 24
]
]
]
/home
/u800617633
/domains
/eurocarnavales.es
/public_html
/system
/engine
/action.php
$class = 'Controller' . CUSTOMER . preg_replace('/[^a-zA-Z0-9]/', '', $this->route);
}
else {
$file = DIR_APPLICATION . 'controller/' . $this->route . '.php';
$class = 'Controller' . preg_replace('/[^a-zA-Z0-9]/', '', $this->route);
}
// Initialize the class
if (is_file($file)) {
include_once $file;
$controller = new $class($registry);
}
else {
return new \Exception('Error: Could not call ' . $this->route . '/' . $this->method . '!');
}
$reflection = new ReflectionClass($class);
if ($reflection->hasMethod($this->method) && $reflection->getMethod($this->method)->getNumberOfRequiredParameters() <= count($args)) {
return call_user_func_array(array($controller, $this->method), $args);
}
else {
return new \Exception('Error: Could not call ' . $this->route . '/' . $this->method . '!');
}
}
}
/home
/u800617633
/domains
/eurocarnavales.es
/public_html
/catalog
/controller
/startup
/router.php
} else {
$route = $this->config->get('action_default');
}
// Sanitize the call
$route = preg_replace('/[^a-zA-Z0-9_\/]/', '', (string)$route);
$data = [];
// Trigger the pre events
$result = $this->event->trigger('controller/' . $route . '/before', array(&$route, &$data));
if (!is_null($result)) {
return $result;
}
// We dont want to use the loader class as it would make an controller callable.
$action = new Action($route);
// Any output needs to be another Action object.
if(!empty($_GET['_t']) && $_GET['_t'] == 'cu') $output = $action->execute($this->registry,[],'customer');
else $output = $action->execute($this->registry);
// Trigger the post events
$result = $this->event->trigger('controller/' . $route . '/after', array(&$route, &$data, &$output));
if (!is_null($result)) {
return $result;
}
return $output;
}
}
Arguments
/home
/u800617633
/domains
/eurocarnavales.es
/public_html
/system
/engine
/action.php
$class = 'Controller' . CUSTOMER . preg_replace('/[^a-zA-Z0-9]/', '', $this->route);
}
else {
$file = DIR_APPLICATION . 'controller/' . $this->route . '.php';
$class = 'Controller' . preg_replace('/[^a-zA-Z0-9]/', '', $this->route);
}
// Initialize the class
if (is_file($file)) {
include_once $file;
$controller = new $class($registry);
}
else {
return new \Exception('Error: Could not call ' . $this->route . '/' . $this->method . '!');
}
$reflection = new ReflectionClass($class);
if ($reflection->hasMethod($this->method) && $reflection->getMethod($this->method)->getNumberOfRequiredParameters() <= count($args)) {
return call_user_func_array(array($controller, $this->method), $args);
}
else {
return new \Exception('Error: Could not call ' . $this->route . '/' . $this->method . '!');
}
}
}
/home
/u800617633
/domains
/eurocarnavales.es
/public_html
/system
/engine
/front.php
public function dispatch(Action $action, Action $error) {
$this->error = $error;
foreach ($this->pre_action as $pre_action) {
$result = $this->execute($pre_action);
if ($result instanceof Action) {
$action = $result;
break;
}
}
while ($action instanceof Action) {
$action = $this->execute($action);
}
}
private function execute(Action $action) {
$result = $action->execute($this->registry);
if ($result instanceof Action) {
return $result;
}
if ($result instanceof Exception) {
$action = $this->error;
$this->error = null;
return $action;
}
}
}
Arguments
/home
/u800617633
/domains
/eurocarnavales.es
/public_html
/system
/engine
/front.php
public function addPreAction(Action $pre_action) {
$this->pre_action[] = $pre_action;
}
public function dispatch(Action $action, Action $error) {
$this->error = $error;
foreach ($this->pre_action as $pre_action) {
$result = $this->execute($pre_action);
if ($result instanceof Action) {
$action = $result;
break;
}
}
while ($action instanceof Action) {
$action = $this->execute($action);
}
}
private function execute(Action $action) {
$result = $action->execute($this->registry);
if ($result instanceof Action) {
return $result;
}
if ($result instanceof Exception) {
$action = $this->error;
$this->error = null;
return $action;
}
}
}
Arguments
/home
/u800617633
/domains
/eurocarnavales.es
/public_html
/system
/framework.php
// Model Autoload
if ($config->has('model_autoload')) {
foreach ($config->get('model_autoload') as $value) {
$loader->model($value);
}
}
// Front Controller
$controller = new Front($registry);
$registry::setInstance($registry);
// Pre Actions
if ($config->has('action_pre_action')) {
foreach ($config->get('action_pre_action') as $value) {
$controller->addPreAction(new Action($value));
}
}
// Dispatch
$controller->dispatch(new Action($config->get('action_router')), new Action($config->get('action_error')));
// Output
$response->setCompression($config->get('config_compression'));
$response->output();
Arguments
/home
/u800617633
/domains
/eurocarnavales.es
/public_html
/system
/startup.php
require_once(DIR_SYSTEM . 'engine/controller.php');
require_once(DIR_SYSTEM . 'engine/event.php');
require_once(DIR_SYSTEM . 'engine/front.php');
require_once(DIR_SYSTEM . 'engine/loader.php');
require_once(DIR_SYSTEM . 'engine/model.php');
require_once(DIR_SYSTEM . 'engine/registry.php');
require_once(DIR_SYSTEM . 'engine/proxy.php');
// Libs
require_once(DIR_SYSTEM . 'composer_library/str.php');
require_once(DIR_SYSTEM . 'composer_library/arr.php');
// Helper
require_once(DIR_SYSTEM . 'helper/general.php');
require_once(DIR_SYSTEM . 'helper/utf8.php');
require_once(DIR_SYSTEM . 'helper/json.php');
require_once(DIR_SYSTEM . 'helper/html.php');
function start($application_config) {
require_once(DIR_SYSTEM . 'framework.php');
}
Arguments
"/home/u800617633/domains/eurocarnavales.es/public_html/system/framework.php"
/home
/u800617633
/domains
/eurocarnavales.es
/public_html
/index.php
<?php
ini_set('display_errors',1);
// Version
define('VERSION', '2.3.0.2');
// Configuration
if (is_file('config/config.php')) {
require_once('config/config.php');
}
// Install
if (!defined('DIR_APPLICATION')) {
header('Location: install/index.php');
exit;
}
// Startup
require_once(DIR_SYSTEM . 'startup.php');
start('catalog');
Arguments