public function editSlider($ptslider_id, $data) {
$this->db->query("UPDATE " . DB_PREFIX . "ptslider SET name = '" . $this->db->escape($data['name']) . "', status = '" . (int) $data['status'] . "', auto = '" . (int) $data['auto'] . "', delay = '" . (int) $data['delay'] . "', hover = '" . (int) $data['hover'] . "', nextback = '" . (int) $data['nextback'] . "', effect = '" . $data['effect'] . "', contrl = '" . (int) $data['contrl'] . "' WHERE ptslider_id = '" . (int) $ptslider_id . "'");
$this->db->query("DELETE FROM " . DB_PREFIX . "ptslider_image WHERE ptslider_id = '" . (int) $ptslider_id . "'");
$this->db->query("DELETE FROM " . DB_PREFIX . "ptslider_image_description WHERE ptslider_id = '" . (int) $ptslider_id . "'");
if (isset($data['ptslider_image'])) {
foreach ($data['ptslider_image'] as $ptslider_image) {
$slider_store = "";
if(isset($data['slider_store'])) {
$slider_store = implode(',', $data['slider_store']);
}
$this->db->query("INSERT INTO " . DB_PREFIX . "ptslider_image SET ptslider_id = '" . (int) $ptslider_id . "', link = '" . $this->db->escape($ptslider_image['link']) . "', type = '" . $this->db->escape($ptslider_image['type']) . "', image = '" . $this->db->escape($ptslider_image['image']) . "', slider_store = '" . $slider_store . "'");
$ptslider_image_id = $this->db->getLastId();
foreach ($ptslider_image['ptslider_image_description'] as $language_id => $ptslider_image_description) {
$this->db->query("INSERT INTO " . DB_PREFIX . "ptslider_image_description SET ptslider_image_id = '" . (int) $ptslider_image_id . "', language_id = '" . (int) $language_id . "', ptslider_id = '" . (int) $ptslider_id . "', title = '" . $this->db->escape($ptslider_image_description['title']) . "', sub_title = '" . $this->db->escape($ptslider_image_description['sub_title']) . "', description = '" . $this->db->escape($ptslider_image_description['description']) . "'");
}
}
}
}
<?php
// * @source See SOURCE.txt for source and other copyright.
// * @license GNU General Public License version 3; see LICENSE.txt
class ControllerCommonHeader extends Controller {
public function index() {
// Analytics
$this->load->model('setting/extension');
$data['analytics'] = array();
$analytics = $this->model_setting_extension->getExtensions('analytics');
foreach ($analytics as $analytic) {
if ($this->config->get('analytics_' . $analytic['code'] . '_status')) {
$data['analytics'][] = $this->load->controller('extension/analytics/' . $analytic['code'], $this->config->get('analytics_' . $analytic['code'] . '_status'));
}
}
if ($this->request->server['HTTPS']) {
$server = $this->config->get('config_ssl');
} else {
$server = $this->config->get('config_url');
}
if (is_file(DIR_IMAGE . $this->config->get('config_icon'))) {
$this->document->addLink($server . 'image/' . $this->config->get('config_icon'), 'icon');
}
$data['title'] = $this->document->getTitle();
$data['base'] = $server;
$data['description'] = $this->document->getDescription();
$data['keywords'] = $this->document->getKeywords();
$data['links'] = $this->document->getLinks();
$data['robots'] = $this->document->getRobots();
$data['styles'] = $this->document->getStyles();
$data['scripts'] = $this->document->getScripts('header');
$data['lang'] = $this->language->get('code');
$data['direction'] = $this->language->get('direction');
$data['name'] = $this->config->get('config_name');
if (is_file(DIR_IMAGE . $this->config->get('config_logo'))) {
$data['logo'] = $server . 'image/' . $this->config->get('config_logo');
} else {
$data['logo'] = '';
}
$this->load->language('common/header');
$host = isset($this->request->server['HTTPS']) && (($this->request->server['HTTPS'] == 'on') || ($this->request->server['HTTPS'] == '1')) ? HTTPS_SERVER : HTTP_SERVER;
if ($this->request->server['REQUEST_URI'] == '/') {
$data['og_url'] = $this->url->link('common/home');
} else {
$data['og_url'] = $host . substr($this->request->server['REQUEST_URI'], 1, (strlen($this->request->server['REQUEST_URI'])-1));
}
$data['og_image'] = $this->document->getOgImage();
// Wishlist
if ($this->customer->isLogged()) {
$this->load->model('account/wishlist');
$data['text_wishlist'] = sprintf($this->language->get('text_wishlist'), $this->model_account_wishlist->getTotalWishlist());
} else {
$data['text_wishlist'] = sprintf($this->language->get('text_wishlist'), (isset($this->session->data['wishlist']) ? count($this->session->data['wishlist']) : 0));
}
$data['text_logged'] = sprintf($this->language->get('text_logged'), $this->url->link('account/account', '', true), $this->customer->getFirstName(), $this->url->link('account/logout', '', true));
$data['home'] = $this->url->link('common/home');
$data['wishlist'] = $this->url->link('account/wishlist', '', true);
$data['logged'] = $this->customer->isLogged();
$data['account'] = $this->url->link('account/account', '', true);
$data['register'] = $this->url->link('account/register', '', true);
$data['login'] = $this->url->link('account/login', '', true);
$data['order'] = $this->url->link('account/order', '', true);
$data['transaction'] = $this->url->link('account/transaction', '', true);
$data['download'] = $this->url->link('account/download', '', true);
$data['logout'] = $this->url->link('account/logout', '', true);
$data['shopping_cart'] = $this->url->link('checkout/cart');
$data['checkout'] = $this->url->link('checkout/checkout', '', true);
$data['contact'] = $this->url->link('information/contact');
$data['telephone'] = $this->config->get('config_telephone');
$data['language'] = $this->load->controller('common/language');
$data['currency'] = $this->load->controller('common/currency');
$data['currency'] = $this->load->controller('common/currency');
if ($this->config->get('configblog_blog_menu')) {
$data['blog_menu'] = $this->load->controller('blog/menu');
} else {
$data['blog_menu'] = '';
}
$data['search'] = $this->load->controller('common/search');
$data['cart'] = $this->load->controller('common/cart');
$data['menu'] = $this->load->controller('common/menu');
return $this->load->view('common/header', $data);
}
}