⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.148
Server IP:
63.250.38.6
Server:
Linux premium90.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64
Server Software:
LiteSpeed
PHP Version:
8.1.33
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
home
/
nnvixbtb
/
Monitem.ca
/
sql_upgrade
/
history
/
View File Name :
update3_429.txt
CREATE TABLE clic_products_recommendations_to_categories ( id INT(11) NOT NULL AUTO_INCREMENT, products_id INT(11) NOT NULL, categories_id INT(11) NOT NULL, PRIMARY KEY (id), INDEX idx_products_id (products_id), INDEX idx_categories_id (categories_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ALTER TABLE `clic_products_recommendations` ADD `product_tag` VARCHAR(255) Default NULL AFTER `recommendation_date`; ALTER TABLE `clic_products_recommendations` ADD `customers_group_id` INT(11) NOT NULL DEFAULT '0' AFTER `product_tag`; ALTER TABLE `clic_products_recommendations` CHANGE `id` `id` INT(11) NOT NULL AUTO_INCREMENT; ## seo recommendations ALTER TABLE `clic_seo` ADD `seo_language_recommendations_title` TEXT NULL DEFAULT NULL AFTER `seo_defaut_language_title_h1`, ADD `seo_language_recommendations_description` TEXT NULL DEFAULT NULL AFTER `seo_language_recommendations_title`, ADD `seo_language_recommendations_keywords` TEXT NULL DEFAULT NULL AFTER `seo_language_recommendations_description`; #page manager INSERT INTO `clic_pages_manager` VALUES(16, '_self', 7, 1, 5, 3, '0', NULL, NULL, '2018-07-31 09:23:54', NULL, NULL, 0, 0); INSERT INTO `clic_pages_manager_description` VALUES(16, 'Index', '', 'Products&Recommendations', 1, '', '', ''); INSERT INTO `clic_pages_manager_description` VALUES(16, 'Index', '', 'Products&Recommendations', 2, '', '', ''); #english INSERT INTO `clic_configuration` VALUES(1608, 'Analysis strategy', 'CLICSHOPPING_APP_RECOMMENDATIONS_PR_STRATEGY', 'Range', 'Please choose your strategy', 6, 0, NULL, '2023-08-04 09:50:46', NULL, NULL); INSERT INTO `clic_configuration` VALUES(1609, 'Sentiment score weighting', 'CLICSHOPPING_APP_RECOMMENDATIONS_PR_WEIGHTING_SENTIMENT', '1.5', 'It is the ability to refine or modify the relative importance or influence of the sentiment score. <br />\n<strong>The neutral value</strong> considered positive is 0.8 for a sentiment weight of 1.5', 6, 0, NULL, '2023-08-04 09:50:46', NULL, NULL); INSERT INTO `clic_configuration` VALUES(1610, 'Sort Order', 'CLICSHOPPING_APP_RECOMMENDATIONS_PR_SORT_ORDER', '30', 'Sort Order (Lowest is displayed in first)', 6, 0, NULL, '2023-08-04 09:50:46', NULL, NULL); INSERT INTO `clic_configuration` VALUES(1611, 'Max Score', 'CLICSHOPPING_APP_RECOMMENDATIONS_PR_MAX_SCORE', '0.5', 'Show products frequently rejected by customer recommendations (must be between -1 and 1)<br />\nMust be equal to or less than min score', 6, 0, NULL, '2023-08-04 09:50:46', NULL, NULL); INSERT INTO `clic_configuration` VALUES(1612, 'Min Score', 'CLICSHOPPING_APP_RECOMMENDATIONS_PR_MIN_SCORE', '0.5', 'Show frequently accepted products for customer recommendations (must be between -1 and 1)', 6, 0, NULL, '2023-08-04 09:50:46', NULL, NULL); INSERT INTO `clic_configuration` VALUES(1613, 'Status', 'CLICSHOPPING_APP_RECOMMENDATIONS_PR_STATUS', 'True', 'Do you want to activate this module ?', 6, 0, NULL, '2023-08-04 09:50:46', NULL, NULL); INSERT INTO `clic_configuration` VALUES(1614, 'Parameter [Recommendations Products App]', 'MODULE_MODULES_PRODUCTS_PRODUCT_RECOMMENDATIONS_INSTALLED', 'Marketing\\Recommendations\\PR', 'Parameter [Recommendations Products App]', 6, 0, NULL, '2023-08-04 09:50:46', NULL, NULL); INSERT INTO `clic_configuration` VALUES(1615, 'Installed Modules', 'MODULE_MODULES_PRODUCTS_RECOMMENDATIONS_INSTALLED', 'pre_products_recommendations.php', 'This is automatically updated. No need to edit.', 6, 0, '2023-08-04 09:56:35', '2023-08-04 09:56:21', NULL, NULL); INSERT INTO `clic_configuration` VALUES(1616, 'Do you want to enable this module ?', 'MODULE_PRODUCTS_RECOMMENDATIONS_STATUS', 'True', 'Do you want to enable this module in your shop ?', 6, 1, NULL, '2023-08-04 09:56:35', NULL, 'clic_cfg_set_boolean_value(array(\'True\', \'False\'))'); INSERT INTO `clic_configuration` VALUES(1617, 'Please select your template ?', 'MODULE_PRODUCTS_RECOMMENDATIONS_TEMPLATE', 'template_bootstrap_column_5.php', 'Select your template', 6, 2, NULL, '2023-08-04 09:56:35', NULL, 'clic_cfg_set_multi_template_pull_down'); INSERT INTO `clic_configuration` VALUES(1618, 'Please indicate the number of product do you want to display', 'MODULE_PRODUCTS_RECOMMENDATIONS_MAX_DISPLAY', '6', 'Indicate the number of product do you want to display', 6, 3, NULL, '2023-08-04 09:56:35', NULL, ''); INSERT INTO `clic_configuration` VALUES(1619, 'Please indicate the number of column that you want to display ?', 'MODULE_PRODUCTS_RECOMMENDATIONS_COLUMNS', '4', 'Choose a number between 1 and 12', 6, 3, NULL, '2023-08-04 09:56:35', NULL, 'clic_cfg_set_content_module_width_pull_down'); INSERT INTO `clic_configuration` VALUES(1620, 'Do you want to display a short description ?', 'MODULE_PRODUCTS_RECOMMENDATIONS_SHORT_DESCRIPTION', '', 'Please indicate a number of your short description', 6, 4, NULL, '2023-08-04 09:56:35', NULL, ''); INSERT INTO `clic_configuration` VALUES(1621, 'Do you want to remove words of your short description ?', 'MODULE_PRODUCTS_RECOMMENDATIONS_SHORT_DESCRIPTION_DELETE_WORLDS', '', 'Indicate Remove words of your short description for the first caracters', 6, 4, NULL, '2023-08-04 09:56:35', NULL, ''); INSERT INTO `clic_configuration` VALUES(1622, 'Do you want to display a message News / Specials / Favorites / Featured ?', 'MODULE_PRODUCTS_RECOMMENDATIONS_TICKER', 'False', 'Display a message News / Specials / Favorites / Featured', 6, 1, NULL, '2023-08-04 09:56:35', NULL, 'clic_cfg_set_boolean_value(array(\'True\', \'False\'))'); INSERT INTO `clic_configuration` VALUES(1623, 'Do you want to display the discount pourcentage (specials) ?', 'MODULE_PRODUCTS_RECOMMENDATIONS_POURCENTAGE_TICKER', 'False', 'Display the discount pourcentage (specials)', 6, 1, NULL, '2023-08-04 09:56:35', NULL, 'clic_cfg_set_boolean_value(array(\'True\', \'False\'))'); INSERT INTO `clic_configuration` VALUES(1624, 'Do you want to display the stock ?', 'MODULE_PRODUCTS_RECOMMENDATIONS_DISPLAY_STOCK', 'none', 'Display the stock (in stock, sold out, out of stock) ?', 6, 6, NULL, '2023-08-04 09:56:35', NULL, 'clic_cfg_set_boolean_value(array(\'none\', \'image\', \'number\'))'); INSERT INTO `clic_configuration` VALUES(1625, 'Please indicate a arrival date sort order', 'MODULE_PRODUCTS_RECOMMENDATIONS_LIST_DATE_ADDED', '1', 'This option allow to choose an order to display the product. Lowest is displayed in first; 0 for nothing', 6, 5, NULL, '2023-08-04 09:56:35', NULL, ''); INSERT INTO `clic_configuration` VALUES(1626, 'Please indicate a price sort order', 'MODULE_PRODUCTS_RECOMMENDATIONS_LIST_PRICE', '', 'This option allow to choose an order to display the product. Lowest is displayed in first; 0 for nothing', 6, 6, NULL, '2023-08-04 09:56:35', NULL, ''); INSERT INTO `clic_configuration` VALUES(1627, 'Please indicate a model sort order', 'MODULE_PRODUCTS_RECOMMENDATIONS_LIST_MODEL', '', 'This option allow to choose an order to display the product. Lowest is displayed in first; 0 for nothing', 6, 7, NULL, '2023-08-04 09:56:35', NULL, ''); INSERT INTO `clic_configuration` VALUES(1628, 'Please indicate a quantity sort order', 'MODULE_PRODUCTS_RECOMMENDATIONS_LIST_QUANTITY', '', 'This option allow to choose an order to display the product. Lowest is displayed in first; 0 for nothing', 6, 8, NULL, '2023-08-04 09:56:35', NULL, ''); INSERT INTO `clic_configuration` VALUES(1629, 'Please indicate a weight sort order', 'MODULE_PRODUCTS_RECOMMENDATIONS_LIST_WEIGHT', '', 'This option allow to choose an order to display the product. Lowest is displayed in first; 0 for nothing', 6, 9, NULL, '2023-08-04 09:56:35', NULL, ''); INSERT INTO `clic_configuration` VALUES(1630, 'Please choose the image size', 'MODULE_PRODUCTS_RECOMMENDATIONS_IMAGE_MEDIUM', 'Small', 'What image size do you want to display?', 6, 10, NULL, '2023-08-04 09:56:35', NULL, 'clic_cfg_set_boolean_value(array(\'Small\', \'Medium\'))'); INSERT INTO `clic_configuration` VALUES(1631, 'Do you want to remove the details button ?', 'MODULE_PRODUCTS_RECOMMENDATIONS_DELETE_BUY_BUTTON', 'False', 'Remove the button details', 6, 11, NULL, '2023-08-04 09:56:35', NULL, 'clic_cfg_set_boolean_value(array(\'True\', \'False\'))'); INSERT INTO `clic_configuration` VALUES(1632, 'Sort order', 'MODULE_PRODUCTS_RECOMMENDATIONS_SORT_ORDER', '100', 'Sort order of display. Lowest is displayed first. The sort order must be different on every module', 6, 12, NULL, '2023-08-04 09:56:35', NULL, ''); #french INSERT INTO `clic_configuration` VALUES(1608, 'Stratégie d\'analyse', 'CLICSHOPPING_APP_RECOMMENDATIONS_PR_STRATEGY', 'Range', 'Veuillez choisir votre stratégie', 6, 0, NULL, '2023-08-04 09:50:46', NULL, NULL); INSERT INTO `clic_configuration` VALUES(1609, 'Pondération du score du sentiment', 'CLICSHOPPING_APP_RECOMMENDATIONS_PR_WEIGHTING_SENTIMENT', '1.5', 'C\'est la capacité d\'affiner ou de modifier l\'importance relative ou l\'influence du score du sentiment. <br />\n<strong>La valeur neutre</strong> considéré comme positive est de 0,8 pour une pondération du sentiment de 1,5', 6, 0, NULL, '2023-08-04 09:50:46', NULL, NULL); INSERT INTO `clic_configuration` VALUES(1610, 'Ordre de tri d\'affichage', 'CLICSHOPPING_APP_RECOMMENDATIONS_PR_SORT_ORDER', '30', 'Ordre de tri pour l\'affichage (Le plus petit nombre est montré en premier)', 6, 0, NULL, '2023-08-04 09:50:46', NULL, NULL); INSERT INTO `clic_configuration` VALUES(1611, 'Max Score', 'CLICSHOPPING_APP_RECOMMENDATIONS_PR_MAX_SCORE', '0.5', 'Afficher les produits fréquemment rejetés par les recommandations des clients (doit être compris entre -1 et 1)<br />\nDoit être égal ou inférieur au min score', 6, 0, NULL, '2023-08-04 09:50:46', NULL, NULL); INSERT INTO `clic_configuration` VALUES(1612, 'Min Score', 'CLICSHOPPING_APP_RECOMMENDATIONS_PR_MIN_SCORE', '0.5', 'Afficher les produits fréquemment acceptés pour les recommandations des clients (doit être compris entre -1 et 1)', 6, 0, NULL, '2023-08-04 09:50:46', NULL, NULL); INSERT INTO `clic_configuration` VALUES(1613, 'Statut', 'CLICSHOPPING_APP_RECOMMENDATIONS_PR_STATUS', 'True', 'Souhaitez-vous activer ce module ?', 6, 0, NULL, '2023-08-04 09:50:46', NULL, NULL); INSERT INTO `clic_configuration` VALUES(1614, 'Parameter [Recommendations Products App]', 'MODULE_MODULES_PRODUCTS_PRODUCT_RECOMMENDATIONS_INSTALLED', 'Marketing\\Recommendations\\PR', 'Parameter [Recommendations Products App]', 6, 0, NULL, '2023-08-04 09:50:46', NULL, NULL); INSERT INTO `clic_configuration` VALUES(1615, 'Installed Modules', 'MODULE_MODULES_PRODUCTS_RECOMMENDATIONS_INSTALLED', 'pre_products_recommendations.php', 'This is automatically updated. No need to edit.', 6, 0, '2023-08-04 09:56:35', '2023-08-04 09:56:21', NULL, NULL); INSERT INTO `clic_configuration` VALUES(1616, 'Souhaitez-vous activer ce module ?', 'MODULE_PRODUCTS_RECOMMENDATIONS_STATUS', 'True', 'Souhaitez-vous activer ce module ?', 6, 1, NULL, '2023-08-04 09:56:35', NULL, 'clic_cfg_set_boolean_value(array(\'True\', \'False\'))'); INSERT INTO `clic_configuration` VALUES(1617, 'Veuillez sélectionner votre modèle ?', 'MODULE_PRODUCTS_RECOMMENDATIONS_TEMPLATE', 'template_bootstrap_column_5.php', 'Sélectionner votre modèle', 6, 2, NULL, '2023-08-04 09:56:35', NULL, 'clic_cfg_set_multi_template_pull_down'); INSERT INTO `clic_configuration` VALUES(1618, 'Veuillez indiquer le nombre de produits que vous souhaitez afficher', 'MODULE_PRODUCTS_RECOMMENDATIONS_MAX_DISPLAY', '6', 'Indiquez le nombre de produit que vous souhaitez afficher', 6, 3, NULL, '2023-08-04 09:56:35', NULL, ''); INSERT INTO `clic_configuration` VALUES(1619, 'Veuillez indiquer le nombre de colonne que vous souhaitez afficher', 'MODULE_PRODUCTS_RECOMMENDATIONS_COLUMNS', '4', 'Choisissez un nombre entre 1 et 12', 6, 3, NULL, '2023-08-04 09:56:35', NULL, 'clic_cfg_set_content_module_width_pull_down'); INSERT INTO `clic_configuration` VALUES(1620, 'Voulez-vous afficher une courte description ?', 'MODULE_PRODUCTS_RECOMMENDATIONS_SHORT_DESCRIPTION', '', 'Veuillez indiquer un numéro de votre courte description', 6, 4, NULL, '2023-08-04 09:56:35', NULL, ''); INSERT INTO `clic_configuration` VALUES(1621, 'Voulez-vous supprimer des mots de votre courte description ?', 'MODULE_PRODUCTS_RECOMMENDATIONS_SHORT_DESCRIPTION_DELETE_WORLDS', '', 'Indiquez Supprimer les mots de votre courte description pour les premiers caractères', 6, 4, NULL, '2023-08-04 09:56:35', NULL, ''); INSERT INTO `clic_configuration` VALUES(1622, 'Voulez-vous afficher un message News / Specials / Favorites / Featured ?', 'MODULE_PRODUCTS_RECOMMENDATIONS_TICKER', 'False', 'Afficher un message Actualités / Spéciaux / Favoris / En vedette', 6, 1, NULL, '2023-08-04 09:56:35', NULL, 'clic_cfg_set_boolean_value(array(\'True\', \'False\'))'); INSERT INTO `clic_configuration` VALUES(1623, 'Voulez-vous afficher le pourcentage de remise (promotions) ?', 'MODULE_PRODUCTS_RECOMMENDATIONS_POURCENTAGE_TICKER', 'False', 'Afficher le pourcentage de remise (promotions)', 6, 1, NULL, '2023-08-04 09:56:35', NULL, 'clic_cfg_set_boolean_value(array(\'True\', \'False\'))'); INSERT INTO `clic_configuration` VALUES(1624, 'Voulez-vous afficher le stock ?', 'MODULE_PRODUCTS_RECOMMENDATIONS_DISPLAY_STOCK', 'none', 'Afficher le stock (en stock, épuisé, épuisé) ?', 6, 6, NULL, '2023-08-04 09:56:35', NULL, 'clic_cfg_set_boolean_value(array(\'none\', \'image\', \'number\'))'); INSERT INTO `clic_configuration` VALUES(1625, 'Veuillez indiquer un ordre de tri par date d\'arrivée', 'MODULE_PRODUCTS_RECOMMENDATIONS_LIST_DATE_ADDED', '1', 'Cette option permet de choisir une commande pour afficher le produit. Le plus bas est affiché en premier, 0 pour rien', 6, 5, NULL, '2023-08-04 09:56:35', NULL, ''); INSERT INTO `clic_configuration` VALUES(1626, 'Veuillez indiquer un ordre de tri de prix', 'MODULE_PRODUCTS_RECOMMENDATIONS_LIST_PRICE', '', 'Cette option permet de choisir une commande pour afficher le produit. Le plus bas est affiché en premier, 0 pour rien', 6, 6, NULL, '2023-08-04 09:56:35', NULL, ''); INSERT INTO `clic_configuration` VALUES(1627, 'Veuillez indiquer un ordre de tri du modèle', 'MODULE_PRODUCTS_RECOMMENDATIONS_LIST_MODEL', '', 'Cette option permet de choisir une commande pour afficher le produit. Le plus bas est affiché en premier, 0 pour rien', 6, 7, NULL, '2023-08-04 09:56:35', NULL, ''); INSERT INTO `clic_configuration` VALUES(1628, 'Veuillez indiquer un ordre de tri par quantité', 'MODULE_PRODUCTS_RECOMMENDATIONS_LIST_QUANTITY', '', 'Cette option permet de choisir une commande pour afficher le produit. Le plus bas est affiché en premier, 0 pour rien', 6, 8, NULL, '2023-08-04 09:56:35', NULL, ''); INSERT INTO `clic_configuration` VALUES(1629, 'Veuillez indiquer un ordre de tri de poids', 'MODULE_PRODUCTS_RECOMMENDATIONS_LIST_WEIGHT', '', 'Cette option permet de choisir une commande pour afficher le produit. Le plus bas est affiché en premier, 0 pour rien', 6, 9, NULL, '2023-08-04 09:56:35', NULL, ''); INSERT INTO `clic_configuration` VALUES(1630, 'Veuillez choisir la taille de l\'image', 'MODULE_PRODUCTS_RECOMMENDATIONS_IMAGE_MEDIUM', 'Small', 'Quelle taille d\'image voulez-vous afficher ?', 6, 10, NULL, '2023-08-04 09:56:35', NULL, 'clic_cfg_set_boolean_value(array(\'Small\', \'Medium\'))'); INSERT INTO `clic_configuration` VALUES(1631, 'Voulez-vous supprimer le bouton Détails ?', 'MODULE_PRODUCTS_RECOMMENDATIONS_DELETE_BUY_BUTTON', 'False', 'Supprimer le bouton', 6, 11, NULL, '2023-08-04 09:56:35', NULL, 'clic_cfg_set_boolean_value(array(\'True\', \'False\'))'); INSERT INTO `clic_configuration` VALUES(1632, 'Ordre de tri d\'affichage', 'MODULE_PRODUCTS_RECOMMENDATIONS_SORT_ORDER', '100', 'Ordre de tri pour l\'affichage (Le plus petit nombre est montré en premier). L\'ordre de tri doit être différent pour chaque module', 6, 12, NULL, '2023-08-04 09:56:35', NULL, '');