<?php
/**
* Module Prestashop FooterCustom
*
* @author    Prestacrea
* @copyright Prestacrea
* @license   See PDF documentation
* @website   http://www.prestacrea.com
*/

Configuration::updateValue('FC_IMG', 1);
Configuration::updateValue('FC_TOPBLOCK', 1);
Configuration::updateValue('FC_BOTTOMBLOCK', 1);
Configuration::updateValue('FC_REINSURANCE', 1);
Configuration::updateValue('FC_RESPONSIVE', 1);
Configuration::updateValue('FC_SOCIAL', 1);
Configuration::updateValue('FC_WIDTH', 1170);
Configuration::updateValue('FC_BLOCKSWIDTH', 0);
Configuration::updateValue('FC_BASEFONTFAMILY', 'Arial');
Configuration::updateValue('FC_TITLESFONTFAMILY', 'Arial');
Configuration::updateValue('FC_BASEFONTSIZE', 12);
Configuration::updateValue('FC_TITLESFONTSIZE', 16);
Configuration::updateValue('FC_MAINCOLOR', 'b6e2ed');
Configuration::updateValue('FC_ALTCOLOR', '3e838f');
Configuration::updateValue('FC_TOPCOLOR', '333333');
Configuration::updateValue('FC_BOTTOMCOLOR', 'eeeeee');
Configuration::updateValue('FC_TOPFONTCOLOR', 'ffffff');
Configuration::updateValue('FC_BOTTOMFONTCOLOR', '444444');
Configuration::updateValue('FC_NEWSLETTER', 1);

Db::getInstance()->Execute('CREATE TABLE IF NOT EXISTS '._DB_PREFIX_.'footercustom_company (`id` int(6) NOT NULL, `id_shop` int(10) unsigned NOT NULL, `name` varchar(255) NOT NULL, `address1` varchar(255) NOT NULL, `address2` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `mail` varchar(255) NOT NULL, PRIMARY KEY(`id_shop`, `id`)) ENGINE=MyISAM default CHARSET=utf8');

Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_company (`id`, `id_shop`, `name`, `address1`, `address2`, `phone`, `mail`) VALUES ("1", "1", "Prestashop SA", "41 boulevard des Capucines", "75002 Paris France", "+33 (0)1 40 18 30 04", "contact@prestashop.com")');

Db::getInstance()->Execute('CREATE TABLE IF NOT EXISTS '._DB_PREFIX_.'footercustom_blocktitles (`id_lang` int(2) NOT NULL, `id_shop` int(10) unsigned NOT NULL, `title1` varchar(255) NOT NULL, `title2` varchar(255) NOT NULL, `title3` varchar(255) NOT NULL, PRIMARY KEY(`id_lang`, `id_shop`)) ENGINE=MyISAM default CHARSET=utf8');

Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_blocktitles (`id_lang`, `id_shop`, `title1`, `title2`, `title3`) VALUES ("1", "1", "Informations", "Nos produits", "A propos")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_blocktitles (`id_lang`, `id_shop`, `title1`, `title2`, `title3`) VALUES ("2", "1", "Informations", "Nos produits", "A propos")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_blocktitles (`id_lang`, `id_shop`, `title1`, `title2`, `title3`) VALUES ("3", "1", "Informations", "Nos produits", "A propos")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_blocktitles (`id_lang`, `id_shop`, `title1`, `title2`, `title3`) VALUES ("4", "1", "Informations", "Nos produits", "A propos")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_blocktitles (`id_lang`, `id_shop`, `title1`, `title2`, `title3`) VALUES ("5", "1", "Informations", "Nos produits", "A propos")');

Db::getInstance()->Execute('CREATE TABLE IF NOT EXISTS '._DB_PREFIX_.'footercustom (`id_block` int(10) NOT NULL AUTO_INCREMENT, PRIMARY KEY(`id_block`)) ENGINE=MyISAM default CHARSET=utf8');

Db::getInstance()->Execute('CREATE TABLE IF NOT EXISTS '._DB_PREFIX_.'footercustom_lang (`id_block` int(10) NOT NULL AUTO_INCREMENT, `id_shop` int(10) unsigned NOT NULL, `id_lang` int(10) NOT NULL, `title` varchar(255) NOT NULL, `link` varchar(255) NOT NULL, `inblock` int(10) NOT NULL, `position` int(10) NOT NULL, PRIMARY KEY(`id_lang`, `id_block`)) ENGINE=MyISAM default CHARSET=utf8');

Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom (`id_block`) VALUES ("1")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom (`id_block`) VALUES ("2")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom (`id_block`) VALUES ("3")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom (`id_block`) VALUES ("4")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom (`id_block`) VALUES ("5")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom (`id_block`) VALUES ("6")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom (`id_block`) VALUES ("7")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom (`id_block`) VALUES ("8")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom (`id_block`) VALUES ("9")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom (`id_block`) VALUES ("10")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom (`id_block`) VALUES ("11")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom (`id_block`) VALUES ("12")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom (`id_block`) VALUES ("13")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom (`id_block`) VALUES ("14")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom (`id_block`) VALUES ("15")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom (`id_block`) VALUES ("16")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom (`id_block`) VALUES ("17")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom (`id_block`) VALUES ("18")');

Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("1", "1", "1", "Livraisons et retours", "index.php", "1", "1")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("1", "1", "2", "Livraisons et retours", "index.php", "1", "1")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("1", "1", "3", "Livraisons et retours", "index.php", "1", "1")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("1", "1", "4", "Livraisons et retours", "index.php", "1", "1")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("1", "1", "5", "Livraisons et retours", "index.php", "1", "1")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("2", "1", "1", "Garantie satisfaction", "index.php", "1", "2")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("2", "1", "2", "Garantie satisfaction", "index.php", "1", "2")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("2", "1", "3", "Garantie satisfaction", "index.php", "1", "2")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("2", "1", "4", "Garantie satisfaction", "index.php", "1", "2")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("2", "1", "5", "Garantie satisfaction", "index.php", "1", "2")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("3", "1", "1", "Paiement sécurisé", "index.php", "1", "3")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("3", "1", "2", "Paiement sécurisé", "index.php", "1", "3")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("3", "1", "3", "Paiement sécurisé", "index.php", "1", "3")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("3", "1", "4", "Paiement sécurisé", "index.php", "1", "3")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("3", "1", "5", "Paiement sécurisé", "index.php", "1", "3")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("4", "1", "1", "Programme fidélité", "index.php", "1", "4")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("4", "1", "2", "Programme fidélité", "index.php", "1", "4")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("4", "1", "3", "Programme fidélité", "index.php", "1", "4")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("4", "1", "4", "Programme fidélité", "index.php", "1", "4")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("4", "1", "5", "Programme fidélité", "index.php", "1", "4")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("5", "1", "1", "Questions fréquentes", "index.php", "1", "5")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("5", "1", "2", "Questions fréquentes", "index.php", "1", "5")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("5", "1", "3", "Questions fréquentes", "index.php", "1", "5")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("5", "1", "4", "Questions fréquentes", "index.php", "1", "5")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("5", "1", "5", "Questions fréquentes", "index.php", "1", "5")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("6", "1", "1", "Plan du site", "index.php", "1", "6")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("6", "1", "2", "Plan du site", "index.php", "1", "6")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("6", "1", "3", "Plan du site", "index.php", "1", "6")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("6", "1", "4", "Plan du site", "index.php", "1", "6")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("6", "1", "5", "Plan du site", "index.php", "1", "6")');

Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("7", "1", "1", "Promotions", "index.php", "2", "1")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("7", "1", "2", "Promotions", "index.php", "2", "1")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("7", "1", "3", "Promotions", "index.php", "2", "1")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("7", "1", "4", "Promotions", "index.php", "2", "1")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("7", "1", "5", "Promotions", "index.php", "2", "1")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("8", "1", "1", "Nouveautés", "index.php", "2", "2")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("8", "1", "2", "Nouveautés", "index.php", "2", "2")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("8", "1", "3", "Nouveautés", "index.php", "2", "2")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("8", "1", "4", "Nouveautés", "index.php", "2", "2")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("8", "1", "5", "Nouveautés", "index.php", "2", "2")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("9", "1", "1", "Meilleures ventes", "index.php", "2", "3")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("9", "1", "2", "Meilleures ventes", "index.php", "2", "3")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("9", "1", "3", "Meilleures ventes", "index.php", "2", "3")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("9", "1", "4", "Meilleures ventes", "index.php", "2", "3")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("9", "1", "5", "Meilleures ventes", "index.php", "2", "3")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("10", "1", "1", "Notre sélection", "index.php", "2", "4")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("10", "1", "2", "Notre sélection", "index.php", "2", "4")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("10", "1", "3", "Notre sélection", "index.php", "2", "4")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("10", "1", "4", "Notre sélection", "index.php", "2", "4")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("10", "1", "5", "Notre sélection", "index.php", "2", "4")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("11", "1", "1", "Liste des marques", "index.php", "2", "5")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("11", "1", "2", "Liste des marques", "index.php", "2", "5")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("11", "1", "3", "Liste des marques", "index.php", "2", "5")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("11", "1", "4", "Liste des marques", "index.php", "2", "5")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("11", "1", "5", "Liste des marques", "index.php", "2", "5")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("12", "1", "1", "Liste des fournisseurs", "index.php", "2", "6")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("12", "1", "2", "Liste des fournisseurs", "index.php", "2", "6")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("12", "1", "3", "Liste des fournisseurs", "index.php", "2", "6")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("12", "1", "4", "Liste des fournisseurs", "index.php", "2", "6")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("12", "1", "5", "Liste des fournisseurs", "index.php", "2", "6")');

Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("13", "1", "1", "Qui sommes-nous", "index.php", "3", "1")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("13", "1", "2", "Qui sommes-nous", "index.php", "3", "1")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("13", "1", "3", "Qui sommes-nous", "index.php", "3", "1")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("13", "1", "4", "Qui sommes-nous", "index.php", "3", "1")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("13", "1", "5", "Qui sommes-nous", "index.php", "3", "1")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("14", "1", "1", "Nos magasins", "index.php", "3", "2")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("14", "1", "2", "Nos magasins", "index.php", "3", "2")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("14", "1", "3", "Nos magasins", "index.php", "3", "2")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("14", "1", "4", "Nos magasins", "index.php", "3", "2")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("14", "1", "5", "Nos magasins", "index.php", "3", "2")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("15", "1", "1", "Mentions légales", "index.php", "3", "3")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("15", "1", "2", "Mentions légales", "index.php", "3", "3")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("15", "1", "3", "Mentions légales", "index.php", "3", "3")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("15", "1", "4", "Mentions légales", "index.php", "3", "3")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("15", "1", "5", "Mentions légales", "index.php", "3", "3")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("16", "1", "1", "Conditions générales", "index.php", "3", "4")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("16", "1", "2", "Conditions générales", "index.php", "3", "4")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("16", "1", "3", "Conditions générales", "index.php", "3", "4")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("16", "1", "4", "Conditions générales", "index.php", "3", "4")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("16", "1", "5", "Conditions générales", "index.php", "3", "4")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("17", "1", "1", "Service client", "index.php", "3", "5")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("17", "1", "2", "Service client", "index.php", "3", "5")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("17", "1", "3", "Service client", "index.php", "3", "5")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("17", "1", "4", "Service client", "index.php", "3", "5")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("17", "1", "5", "Service client", "index.php", "3", "5")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("18", "1", "1", "Contactez-nous", "index.php", "3", "6")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("18", "1", "2", "Contactez-nous", "index.php", "3", "6")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("18", "1", "3", "Contactez-nous", "index.php", "3", "6")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("18", "1", "4", "Contactez-nous", "index.php", "3", "6")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_lang (`id_block`, `id_shop`, `id_lang`, `title`, `link`, `inblock`, `position`) VALUES ("18", "1", "5", "Contactez-nous", "index.php", "3", "6")');

Db::getInstance()->Execute('CREATE TABLE IF NOT EXISTS '._DB_PREFIX_.'footercustom_newsletter (`id` int(6) NOT NULL AUTO_INCREMENT, `email` varchar(255) NOT NULL, `newsletter_date_add` DATETIME NULL, `ip_registration_newsletter` varchar(15) NOT NULL, `http_referer` VARCHAR(255) NULL, PRIMARY KEY(`id`)) ENGINE=MyISAM default CHARSET=utf8');

Db::getInstance()->Execute('CREATE TABLE IF NOT EXISTS '._DB_PREFIX_.'footercustom_social (`id` int(6) NOT NULL, `id_shop` int(10) unsigned NOT NULL, `facebook` varchar(255) NOT NULL, `twitter` varchar(255) NOT NULL, `google` varchar(255) NOT NULL, `pinterest` varchar(255) NOT NULL, `blog` varchar(255) NOT NULL, `rss` varchar(255) NOT NULL, PRIMARY KEY(`id_shop`, `id`)) ENGINE=MyISAM default CHARSET=utf8');

Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_social (`id`, `id_shop`, `facebook`, `twitter`, `google`, `pinterest`, `blog`, `rss`) VALUES ("1", "1", "http://www.facebook.com/prestashop", "https://twitter.com/prestashop", "https://plus.google.com/+prestashop/posts", "http://www.pinterest.com/prestashop", "http://www.prestashop.com/blog/fr", "")');

Db::getInstance()->Execute('CREATE TABLE IF NOT EXISTS '._DB_PREFIX_.'footercustom_reinsurance (`id_block` int(10) NOT NULL AUTO_INCREMENT, `id_shop` int(10) unsigned NOT NULL, `id_lang` int(10) NOT NULL, `title` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `link` varchar(255) NOT NULL, PRIMARY KEY(`id_lang`, `id_shop`, `id_block`)) ENGINE=MyISAM default CHARSET=utf8');

Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("1", "1", "1", "Livraison 48H", "Votre commande est preparée et livrée chez vous sous 48h", "index.php")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("1", "1", "2", "Livraison 48H", "Votre commande est preparée et livrée chez vous sous 48h", "index.php")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("1", "1", "3", "Livraison 48H", "Votre commande est preparée et livrée chez vous sous 48h", "index.php")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("1", "1", "4", "Livraison 48H", "Votre commande est preparée et livrée chez vous sous 48h", "index.php")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("1", "1", "5", "Livraison 48H", "Votre commande est preparée et livrée chez vous sous 48h", "index.php")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("2", "1", "1", "Paiement sécurisé", "Les moyens de paiement proposés sont tous totalement sécurisés", "index.php")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("2", "1", "2", "Paiement sécurisé", "Les moyens de paiement proposés sont tous totalement sécurisés", "index.php")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("2", "1", "3", "Paiement sécurisé", "Les moyens de paiement proposés sont tous totalement sécurisés", "index.php")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("2", "1", "4", "Paiement sécurisé", "Les moyens de paiement proposés sont tous totalement sécurisés", "index.php")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("2", "1", "5", "Paiement sécurisé", "Les moyens de paiement proposés sont tous totalement sécurisés", "index.php")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("3", "1", "1", "Garantie satisfaction", "Si vous n\'êtes pas satisfait de votre achat vous êtes remboursé", "index.php")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("3", "1", "2", "Garantie satisfaction", "Si vous n\'êtes pas satisfait de votre achat vous êtes remboursé", "index.php")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("3", "1", "3", "Garantie satisfaction", "Si vous n\'êtes pas satisfait de votre achat vous êtes remboursé", "index.php")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("3", "1", "4", "Garantie satisfaction", "Si vous n\'êtes pas satisfait de votre achat vous êtes remboursé", "index.php")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("3", "1", "5", "Garantie satisfaction", "Si vous n\'êtes pas satisfait de votre achat vous êtes remboursé", "index.php")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("4", "1", "1", "Service client", "Le service client est a votre disposition du lundi au vendredi de 9h à 18h", "index.php")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("4", "1", "2", "Service client", "Le service client est a votre disposition du lundi au vendredi de 9h à 18h", "index.php")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("4", "1", "3", "Service client", "Le service client est a votre disposition du lundi au vendredi de 9h à 18h", "index.php")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("4", "1", "4", "Service client", "Le service client est a votre disposition du lundi au vendredi de 9h à 18h", "index.php")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_reinsurance (`id_block`, `id_shop`, `id_lang`, `title`, `description`, `link`) VALUES ("4", "1", "5", "Service client", "Le service client est a votre disposition du lundi au vendredi de 9h à 18h", "index.php")');

Db::getInstance()->Execute('CREATE TABLE IF NOT EXISTS '._DB_PREFIX_.'footercustom_editor (`id_lang` int(2) NOT NULL, `id_shop` int(10) unsigned NOT NULL, `editor` text NOT NULL, PRIMARY KEY(`id_lang`, `id_shop`)) ENGINE=MyISAM default CHARSET=utf8');

Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_editor (`id_lang`, `id_shop`, `editor`) VALUES ("1", "1", "<p style=\"text-align:center\"><span style=\"font-weight:bold\">Le module FooterCustom permet d\'afficher une image, les coordonnées de votre société, des blocs avec les liens de votre choix, un espace d\'inscription a la newsletter, un espace réseaux sociaux, des blocs de réassurance et un espace contenant tout type d\'informations (images, textes, liens...)</span></p><p style=\"text-align:center\"><img src=\"modules/footercustom/views/img/front/logo_payment.png\" alt=\"\" width=\"447\" height=\"35\"/></p>")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_editor (`id_lang`, `id_shop`, `editor`) VALUES ("2", "1", "<p style=\"text-align:center\"><span style=\"font-weight:bold\">Le module FooterCustom permet d\'afficher une image, les coordonnées de votre société, des blocs avec les liens de votre choix, un espace d\'inscription a la newsletter, un espace réseaux sociaux, des blocs de réassurance et un espace contenant tout type d\'informations (images, textes, liens...)</span></p><p style=\"text-align:center\"><img src=\"modules/footercustom/views/img/front/logo_payment.png\" alt=\"\" width=\"447\" height=\"35\"/></p>")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_editor (`id_lang`, `id_shop`, `editor`) VALUES ("3", "1", "<p style=\"text-align:center\"><span style=\"font-weight:bold\">Le module FooterCustom permet d\'afficher une image, les coordonnées de votre société, des blocs avec les liens de votre choix, un espace d\'inscription a la newsletter, un espace réseaux sociaux, des blocs de réassurance et un espace contenant tout type d\'informations (images, textes, liens...)</span></p><p style=\"text-align:center\"><img src=\"modules/footercustom/views/img/front/logo_payment.png\" alt=\"\" width=\"447\" height=\"35\"/></p>")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_editor (`id_lang`, `id_shop`, `editor`) VALUES ("4", "1", "<p style=\"text-align:center\"><span style=\"font-weight:bold\">Le module FooterCustom permet d\'afficher une image, les coordonnées de votre société, des blocs avec les liens de votre choix, un espace d\'inscription a la newsletter, un espace réseaux sociaux, des blocs de réassurance et un espace contenant tout type d\'informations (images, textes, liens...)</span></p><p style=\"text-align:center\"><img src=\"modules/footercustom/views/img/front/logo_payment.png\" alt=\"\" width=\"447\" height=\"35\"/></p>")');
Db::getInstance()->Execute('INSERT IGNORE INTO '._DB_PREFIX_.'footercustom_editor (`id_lang`, `id_shop`, `editor`) VALUES ("5", "1", "<p style=\"text-align:center\"><span style=\"font-weight:bold\">Le module FooterCustom permet d\'afficher une image, les coordonnées de votre société, des blocs avec les liens de votre choix, un espace d\'inscription a la newsletter, un espace réseaux sociaux, des blocs de réassurance et un espace contenant tout type d\'informations (images, textes, liens...)</span></p><p style=\"text-align:center\"><img src=\"modules/footercustom/views/img/front/logo_payment.png\" alt=\"\" width=\"447\" height=\"35\"/></p>")');