Last active
October 25, 2018 12:50
-
-
Save Maksold/3899834 to your computer and use it in GitHub Desktop.
#magento - Interakting slider fix bug with installation
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
/** | |
* Interakting Slider | |
* | |
* NOTICE OF LICENSE | |
* | |
* This source file is subject to the Open Software License (OSL 3.0) | |
* that is bundled with this package in the file LICENSE.txt. | |
* It is also available through the world-wide-web at this URL: | |
* http://opensource.org/licenses/osl-3.0.php | |
* If you did not receive a copy of the license and are unable to | |
* obtain it through the world-wide-web, please send an email | |
* to [email protected] and you will be sent a copy immediately. | |
* | |
* @category BusinessDecision | |
* @package BusinessDecision_Interaktingslider | |
* @author Business & Decision Picardie - [email protected] | |
* @copyright Copyright (c) 2009 Business & Decision (http://www.businessdecision.com) | |
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) | |
*/ | |
$installer = $this; | |
$installer->startSetup(); | |
$installer->run(" | |
CREATE TABLE IF NOT EXISTS `{$this->getTable('interaktingslider_slide')}` ( | |
`slide_id` smallint(6) NOT NULL auto_increment, | |
`name` varchar(255) NOT NULL, | |
`content` text, | |
`from_time` datetime default NULL, | |
`to_time` datetime default NULL, | |
`is_active` tinyint(1) NOT NULL default '1', | |
PRIMARY KEY (`slide_id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Interaktingslider Slides'; | |
CREATE TABLE IF NOT EXISTS `{$this->getTable('interaktingslider_slide_position')}` ( | |
`slide_id` smallint(6) NOT NULL, | |
`store_id` smallint(5) unsigned NOT NULL, | |
`position` smallint(6) default NULL, | |
PRIMARY KEY (`slide_id`,`store_id`), | |
KEY `FK_CAROUSEL_SLIDE_POSITION_STORE` (`store_id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Interaktingslider Slides Position'; | |
CREATE TABLE IF NOT EXISTS `{$this->getTable('interaktingslider_slide_store')}` ( | |
`slide_id` smallint(6) NOT NULL, | |
`store_id` smallint(5) unsigned NOT NULL, | |
PRIMARY KEY (`slide_id`,`store_id`), | |
KEY `FK_CAROUSEL_SLIDE_STORE_STORE` (`store_id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Interaktingslider Slides to Stores'; | |
ALTER TABLE `{$this->getTable('interaktingslider_slide_position')}` | |
ADD FOREIGN KEY (`slide_id`) REFERENCES `{$this->getTable('interaktingslider_slide')}` (`slide_id`) ON DELETE CASCADE ON UPDATE CASCADE, | |
ADD FOREIGN KEY (`store_id`) REFERENCES `{$this->getTable('core_store')}` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE; | |
ALTER TABLE `{$this->getTable('interaktingslider_slide_store')}` | |
ADD FOREIGN KEY (`slide_id`) REFERENCES `{$this->getTable('interaktingslider_slide')}` (`slide_id`) ON DELETE CASCADE ON UPDATE CASCADE, | |
ADD FOREIGN KEY (`store_id`) REFERENCES `{$this->getTable('core_store')}` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE; | |
"); | |
/* | |
* SQL with errors | |
*/ | |
/* | |
$installer->run(" | |
INSERT INTO `{$this->getTable('interaktingslider_slide')}` (`slide_id`, `name`, `content`, `from_time`, `to_time`, `is_active`) VALUES(1, 'Diapo 1', '<p style=\"text-align: center; width: 100%; height: 220px; background-color: rgb(255, 255, 255); margin-top: 10px;\"><img height=\"54\" border=\"0\" align=\"middle\" width=\"200\" src=\"/media/upload/image/is_logo_interakting.png\" /><span style=\"font-size: large;\"><span style=\"font-family: Verdana;\"><br /><br />Interakting slider</span></span><span style=\"font-family: Arial;\"><br /><br />Ce module magento vous permettra de faire défiler des contenus simplement éditables en back office.</span><br /><br />Si vous avez besoin de renseignements ou de développements spécifiques magento, n''hésitez pas:<a href=\"mailto:[email protected]?subject=Interakting%20Slider\"><br /><br />[email protected]</a></p>', '2009-11-06 04:46:36', NULL, 1),(2, 'Diapo 2', '<p style=\"text-align: center; width: 100%; height: 220px; background-color: rgb(255, 255, 255); margin-top: 10px;\"><img height=\"54\" width=\"200\" src=\"/media/upload/image/is_logo_interakting.png\" alt=\"\" /><span style=\"font-size: large;\"><span style=\"font-family: Verdana;\"><br /><br />Interakting slider</span></span><span style=\"font-family: Arial;\"><br /><br />This extension of Magento will give you the ability to display some contents that can be skinned in the back office</span><br /><br />If you need some informations or a specific development on Magento don''t wait more time:<br /><br /><a href=\"mailto:[email protected]?subject=Interakting%20Slider\">[email protected]</a></p>', '2009-11-06 06:46:36', NULL, 1),(3, 'Diapo 3', '<p style=\"text-align: center; margin-top: 20px;\">Personnalisez moi dans votre panel d''administration!! <br /><br /><img height=\"134\" width=\"600\" src=\"/media/upload/image/is_back_fr.png\" alt=\"\" /></p>', '2009-11-06 10:46:36', NULL, 1), | |
(4, 'Diapo 4', '<p style=\"text-align: center; margin-top: 20px;\">Skinned me in your back office !!<br /><br /><img height=\"144\" width=\"600\" src=\"/media/upload/image/is_back_eng.png\" alt=\"\" /></p>', '2009-11-06 10:46:36', NULL, 1); | |
INSERT INTO `{$this->getTable('interaktingslider_slide_store')}` (`slide_id`, `store_id`) VALUES | |
(1, 0), | |
(2, 0), | |
(3, 0), | |
(4, 0); | |
"); | |
*/ | |
$installer->endSetup(); | |
?> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hello,
I want to ask you do you mby have pact of fix for BusinessDecision_Interaktingslider for Magento security patch 6788?
Regards,
Vladimir