Version Notes
NOTE: Please download the Latest release 1.4.0 from Releases section!
Download this release
Release Info
Developer | Magento Core Team |
Extension | Banners |
Version | 1.4.0 |
Comparing to | |
See all releases |
Code changes from version 1.3.5 to 1.4.0
- app/code/local/Mage/Banners/Block/Adminhtml/Banners/Edit/Tab/Form.php +10 -1
- app/code/local/Mage/Banners/Helper/Data.php +6 -2
- app/code/local/Mage/Banners/Model/Mysql4/Banners.php +44 -0
- app/code/local/Mage/Banners/Model/Mysql4/Banners/Collection.php +17 -0
- app/code/local/Mage/Banners/etc/config.xml +4 -2
- app/code/local/Mage/Banners/etc/system.xml +7 -1
- app/code/local/Mage/Banners/sql/banners_setup/mysql4-install-1.3.5.php +0 -65
- app/code/local/Mage/Banners/sql/banners_setup/mysql4-install-1.4.0.php +73 -0
- app/code/local/Mage/Banners/sql/banners_setup/{mysql4-uninstall-1.3.5.php → mysql4-uninstall-1.4.0.php} +2 -0
- app/code/local/Mage/Banners/sql/banners_setup/mysql4-upgrade-0.1.0-1.4.0.php +53 -0
- app/code/local/Mage/Banners/sql/banners_setup/mysql4-upgrade-1.3.1-1.3.2-1.3.3-1.3.4.php +0 -66
- app/design/adminhtml/default/default/layout/banners.xml +1 -1
- app/design/frontend/default/default/layout/banners.xml +1 -1
- media/Banners/data.xml +1 -1
- media/Banners/images/Thumbs.db +0 -0
- media/Banners/images/medium/Thumbs.db +0 -0
- package.xml +5 -5
app/code/local/Mage/Banners/Block/Adminhtml/Banners/Edit/Tab/Form.php
CHANGED
@@ -69,7 +69,16 @@ class Mage_Banners_Block_Adminhtml_Banners_Edit_Tab_Form extends Mage_Adminhtml_
|
|
69 |
),
|
70 |
),
|
71 |
));
|
72 |
-
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
73 |
$fieldset->addField('status', 'select', array(
|
74 |
'label' => Mage::helper('banners')->__('Status'),
|
75 |
'name' => 'status',
|
69 |
),
|
70 |
),
|
71 |
));
|
72 |
+
|
73 |
+
$fieldset->addField('store_id','multiselect',array(
|
74 |
+
'name' => 'stores[]',
|
75 |
+
'label' => Mage::helper('banners')->__('Store View'),
|
76 |
+
'title' => Mage::helper('banners')->__('Store View'),
|
77 |
+
'required' => true,
|
78 |
+
'values' => Mage::getSingleton('adminhtml/system_store')->getStoreValuesForForm(false, true)
|
79 |
+
));
|
80 |
+
|
81 |
+
|
82 |
$fieldset->addField('status', 'select', array(
|
83 |
'label' => Mage::helper('banners')->__('Status'),
|
84 |
'name' => 'status',
|
app/code/local/Mage/Banners/Helper/Data.php
CHANGED
@@ -338,11 +338,15 @@ class Mage_Banners_Helper_Data extends Mage_Core_Helper_Abstract
|
|
338 |
$read= $resource->getConnection('core_read');
|
339 |
$bannersTable = $resource->getTableName('banners');
|
340 |
|
341 |
-
$
|
|
|
|
|
|
|
|
|
342 |
->from($bannersTable,array('banners_id','title','bannerimage','link','target','textblend','content','status'))
|
343 |
->where('status',1)
|
344 |
->order('created_time ASC') ;
|
345 |
-
$banners = $read->fetchAll($select)
|
346 |
|
347 |
$bannersXML = '';
|
348 |
$bannersXML .= '<?xml version="1.0" encoding="utf-8" ?>';
|
338 |
$read= $resource->getConnection('core_read');
|
339 |
$bannersTable = $resource->getTableName('banners');
|
340 |
|
341 |
+
$banners = Mage::getModel('banners/banners')->getCollection()
|
342 |
+
->addStoreFilter(Mage::app()->getStore(true)->getId())
|
343 |
+
->getData();
|
344 |
+
|
345 |
+
/*$select = $read->select()
|
346 |
->from($bannersTable,array('banners_id','title','bannerimage','link','target','textblend','content','status'))
|
347 |
->where('status',1)
|
348 |
->order('created_time ASC') ;
|
349 |
+
$banners = $read->fetchAll($select);*/
|
350 |
|
351 |
$bannersXML = '';
|
352 |
$bannersXML .= '<?xml version="1.0" encoding="utf-8" ?>';
|
app/code/local/Mage/Banners/Model/Mysql4/Banners.php
CHANGED
@@ -7,4 +7,48 @@ class Mage_Banners_Model_Mysql4_Banners extends Mage_Core_Model_Mysql4_Abstract
|
|
7 |
// Note that the banners_id refers to the key field in your database table.
|
8 |
$this->_init('banners/banners', 'banners_id');
|
9 |
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10 |
}
|
7 |
// Note that the banners_id refers to the key field in your database table.
|
8 |
$this->_init('banners/banners', 'banners_id');
|
9 |
}
|
10 |
+
|
11 |
+
|
12 |
+
protected function _afterLoad(Mage_Core_Model_Abstract $object)
|
13 |
+
{
|
14 |
+
|
15 |
+
$select = $this->_getReadAdapter()->select()
|
16 |
+
->from($this->getTable('banners_store'))
|
17 |
+
->where('banners_id = ?', $object->getId());
|
18 |
+
|
19 |
+
if ($data = $this->_getReadAdapter()->fetchAll($select)) {
|
20 |
+
$storesArray = array();
|
21 |
+
foreach ($data as $row) {
|
22 |
+
$storesArray[] = $row['store_id'];
|
23 |
+
}
|
24 |
+
$object->setData('store_id', $storesArray);
|
25 |
+
}
|
26 |
+
|
27 |
+
return parent::_afterLoad($object);
|
28 |
+
|
29 |
+
}
|
30 |
+
|
31 |
+
/**
|
32 |
+
* Process page data before saving
|
33 |
+
*
|
34 |
+
* @param Mage_Core_Model_Abstract $object
|
35 |
+
*/
|
36 |
+
protected function _afterSave(Mage_Core_Model_Abstract $object)
|
37 |
+
{
|
38 |
+
|
39 |
+
$condition = $this->_getWriteAdapter()->quoteInto('banners_id = ?', $object->getId());
|
40 |
+
$this->_getWriteAdapter()->delete($this->getTable('banners_store'), $condition);
|
41 |
+
|
42 |
+
foreach ((array)$object->getData('stores') as $store) {
|
43 |
+
$storeArray = array();
|
44 |
+
$storeArray['banners_id'] = $object->getId();
|
45 |
+
$storeArray['store_id'] = $store;
|
46 |
+
$this->_getWriteAdapter()->insert($this->getTable('banners_store'), $storeArray);
|
47 |
+
}
|
48 |
+
|
49 |
+
return parent::_afterSave($object);
|
50 |
+
|
51 |
+
}
|
52 |
+
|
53 |
+
|
54 |
}
|
app/code/local/Mage/Banners/Model/Mysql4/Banners/Collection.php
CHANGED
@@ -7,4 +7,21 @@ class Mage_Banners_Model_Mysql4_Banners_Collection extends Mage_Core_Model_Mysql
|
|
7 |
parent::_construct();
|
8 |
$this->_init('banners/banners');
|
9 |
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10 |
}
|
7 |
parent::_construct();
|
8 |
$this->_init('banners/banners');
|
9 |
}
|
10 |
+
|
11 |
+
public function addStoreFilter($store)
|
12 |
+
{
|
13 |
+
if ($store instanceof Mage_Core_Model_Store) {
|
14 |
+
$store = array($store->getId());
|
15 |
+
}
|
16 |
+
|
17 |
+
$this->getSelect()->join(
|
18 |
+
array('store_table' => $this->getTable('banners_store')),
|
19 |
+
'main_table.banners_id = store_table.banners_id',
|
20 |
+
array()
|
21 |
+
)
|
22 |
+
->where('store_table.store_id in (?)', array(0, $store));
|
23 |
+
|
24 |
+
return $this;
|
25 |
+
}
|
26 |
+
|
27 |
}
|
app/code/local/Mage/Banners/etc/config.xml
CHANGED
@@ -3,14 +3,13 @@
|
|
3 |
/**
|
4 |
* @category Mage
|
5 |
* @package Mage_Banners
|
6 |
-
* @author ModuleCreator
|
7 |
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
|
8 |
*/
|
9 |
-->
|
10 |
<config>
|
11 |
<modules>
|
12 |
<Mage_Banners>
|
13 |
-
<version>
|
14 |
</Mage_Banners>
|
15 |
</modules>
|
16 |
<frontend>
|
@@ -96,6 +95,9 @@
|
|
96 |
<banners>
|
97 |
<table>banners</table>
|
98 |
</banners>
|
|
|
|
|
|
|
99 |
</entities>
|
100 |
</banners_mysql4>
|
101 |
</models>
|
3 |
/**
|
4 |
* @category Mage
|
5 |
* @package Mage_Banners
|
|
|
6 |
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
|
7 |
*/
|
8 |
-->
|
9 |
<config>
|
10 |
<modules>
|
11 |
<Mage_Banners>
|
12 |
+
<version>1.4.0</version>
|
13 |
</Mage_Banners>
|
14 |
</modules>
|
15 |
<frontend>
|
95 |
<banners>
|
96 |
<table>banners</table>
|
97 |
</banners>
|
98 |
+
<banners_store>
|
99 |
+
<table>banners_store</table>
|
100 |
+
</banners_store>
|
101 |
</entities>
|
102 |
</banners_mysql4>
|
103 |
</models>
|
app/code/local/Mage/Banners/etc/system.xml
CHANGED
@@ -1,5 +1,11 @@
|
|
1 |
<?xml version="1.0"?>
|
2 |
-
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
<config>
|
4 |
<tabs>
|
5 |
<banners translate="label" module="banners">
|
1 |
<?xml version="1.0"?>
|
2 |
+
<!--
|
3 |
+
/**
|
4 |
+
* @category Mage
|
5 |
+
* @package Mage_Banners
|
6 |
+
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
|
7 |
+
*/
|
8 |
+
-->
|
9 |
<config>
|
10 |
<tabs>
|
11 |
<banners translate="label" module="banners">
|
app/code/local/Mage/Banners/sql/banners_setup/mysql4-install-1.3.5.php
DELETED
@@ -1,65 +0,0 @@
|
|
1 |
-
<?php
|
2 |
-
|
3 |
-
$installer = $this;
|
4 |
-
|
5 |
-
$installer->startSetup();
|
6 |
-
|
7 |
-
$installer->run("
|
8 |
-
|
9 |
-
-- DROP TABLE IF EXISTS {$this->getTable('banners')};
|
10 |
-
CREATE TABLE `banners` (
|
11 |
-
`banners_id` int(11) unsigned NOT NULL auto_increment,
|
12 |
-
`title` varchar(255) NOT NULL default '',
|
13 |
-
`bannerimage` varchar(255) NOT NULL default '',
|
14 |
-
`filethumbgrid` text,
|
15 |
-
`link` varchar(255) default NULL,
|
16 |
-
`target` varchar(255) default NULL,
|
17 |
-
`textblend` varchar(255) default NULL,
|
18 |
-
`content` text NOT NULL,
|
19 |
-
`status` smallint(6) NOT NULL default '0',
|
20 |
-
`created_time` datetime default NULL,
|
21 |
-
`update_time` datetime default NULL,
|
22 |
-
PRIMARY KEY (`banners_id`)
|
23 |
-
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
|
24 |
-
|
25 |
-
");
|
26 |
-
|
27 |
-
$installer->run("
|
28 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','advanced/modules_disable_output/Mage_Banners','0');
|
29 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/general/banner_width','564');
|
30 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/general/banner_height','345');
|
31 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/general/banner_backgroundcolor','FFFFFF');
|
32 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/textsettings/text_size','12');
|
33 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/textsettings/text_color','');
|
34 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/textsettings/text_area_width','200');
|
35 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/textsettings/text_line_spacing','0');
|
36 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/textsettings/text_margin_left','12');
|
37 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/textsettings/text_letter_spacing','-0.5');
|
38 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/textsettings/text_margin_bottom','5');
|
39 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/textsettings/text_background_blur','1');
|
40 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/textsettings/text_background_transparency','30');
|
41 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/textsettings/text_background_color','333333');
|
42 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/transition/transition_type','4');
|
43 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/transition/transition_blur','1');
|
44 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/transition/transition_speed','10');
|
45 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/transition/transition_delay_time_fixed','10');
|
46 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/transition/transition_random_effects','0');
|
47 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/transition/transition_delay_time_per_word','.5');
|
48 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/showhide/show_timer_clock','0');
|
49 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/showhide/show_next_button','0');
|
50 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/showhide/show_back_button','0');
|
51 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/showhide/show_number_buttons','0');
|
52 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/showhide/show_number_buttons_always','0');
|
53 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/showhide/show_number_buttons_horizontal','1');
|
54 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/showhide/show_number_buttons_ascending','1');
|
55 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/showhide/show_play_pause_on_timer','1');
|
56 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/showhide/align_buttons_left','0');
|
57 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/showhide/align_text_top','0');
|
58 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/showhide/auto_play','0');
|
59 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/general/auto_play','1');
|
60 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/general/image_resize_to_fit','1');
|
61 |
-
insert into `core_config_data` (`scope`, `scope_id`, `path`, `value`) values('default','0','banners/general/image_randomize_order','0');
|
62 |
-
|
63 |
-
");
|
64 |
-
|
65 |
-
$installer->endSetup();
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
app/code/local/Mage/Banners/sql/banners_setup/mysql4-install-1.4.0.php
ADDED
@@ -0,0 +1,73 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?php
|
2 |
+
|
3 |
+
$installer = $this;
|
4 |
+
|
5 |
+
$installer->startSetup();
|
6 |
+
|
7 |
+
$installer->run("
|
8 |
+
DROP TABLE IF EXISTS `banners`;
|
9 |
+
CREATE TABLE `banners` (
|
10 |
+
`banners_id` int(11) unsigned NOT NULL auto_increment,
|
11 |
+
`title` varchar(255) NOT NULL default '',
|
12 |
+
`bannerimage` varchar(255) NOT NULL default '',
|
13 |
+
`filethumbgrid` text,
|
14 |
+
`link` varchar(255) default NULL,
|
15 |
+
`target` varchar(255) default NULL,
|
16 |
+
`textblend` varchar(255) default NULL,
|
17 |
+
`content` text NOT NULL,
|
18 |
+
`status` smallint(6) NOT NULL default '0',
|
19 |
+
`created_time` datetime default NULL,
|
20 |
+
`update_time` datetime default NULL,
|
21 |
+
PRIMARY KEY (`banners_id`)
|
22 |
+
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
|
23 |
+
|
24 |
+
DROP TABLE IF EXISTS `banners_store`;
|
25 |
+
CREATE TABLE `banners_store` (
|
26 |
+
`banners_id` int(11) NOT NULL,
|
27 |
+
`store_id` smallint(5) unsigned NOT NULL,
|
28 |
+
PRIMARY KEY (`banners_id`,`store_id`),
|
29 |
+
KEY `FK_BANNERS_STORE_STORE` (`store_id`)
|
30 |
+
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Banners Stores';
|
31 |
+
");
|
32 |
+
|
33 |
+
|
34 |
+
|
35 |
+
|
36 |
+
$installer->setConfigData('advanced/modules_disable_output/Mage_Banners','0');
|
37 |
+
$installer->setConfigData('banners/general/banner_width','564');
|
38 |
+
$installer->setConfigData('banners/general/banner_height','345');
|
39 |
+
$installer->setConfigData('banners/general/banner_backgroundcolor','FFFFFF');
|
40 |
+
$installer->setConfigData('banners/textsettings/text_size','12');
|
41 |
+
$installer->setConfigData('banners/textsettings/text_color','');
|
42 |
+
$installer->setConfigData('banners/textsettings/text_area_width','200');
|
43 |
+
$installer->setConfigData('banners/textsettings/text_line_spacing','0');
|
44 |
+
$installer->setConfigData('banners/textsettings/text_margin_left','12');
|
45 |
+
$installer->setConfigData('banners/textsettings/text_letter_spacing','-0.5');
|
46 |
+
$installer->setConfigData('banners/textsettings/text_margin_bottom','5');
|
47 |
+
$installer->setConfigData('banners/textsettings/text_background_blur','1');
|
48 |
+
$installer->setConfigData('banners/textsettings/text_background_transparency','30');
|
49 |
+
$installer->setConfigData('banners/textsettings/text_background_color','333333');
|
50 |
+
$installer->setConfigData('banners/transition/transition_type','4');
|
51 |
+
$installer->setConfigData('banners/transition/transition_blur','1');
|
52 |
+
$installer->setConfigData('banners/transition/transition_speed','10');
|
53 |
+
$installer->setConfigData('banners/transition/transition_delay_time_fixed','10');
|
54 |
+
$installer->setConfigData('banners/transition/transition_random_effects','0');
|
55 |
+
$installer->setConfigData('banners/transition/transition_delay_time_per_word','.5');
|
56 |
+
$installer->setConfigData('banners/showhide/show_timer_clock','0');
|
57 |
+
$installer->setConfigData('banners/showhide/show_next_button','0');
|
58 |
+
$installer->setConfigData('banners/showhide/show_back_button','0');
|
59 |
+
$installer->setConfigData('banners/showhide/show_number_buttons','0');
|
60 |
+
$installer->setConfigData('banners/showhide/show_number_buttons_always','0');
|
61 |
+
$installer->setConfigData('banners/showhide/show_number_buttons_horizontal','1');
|
62 |
+
$installer->setConfigData('banners/showhide/show_number_buttons_ascending','1');
|
63 |
+
$installer->setConfigData('banners/showhide/show_play_pause_on_timer','1');
|
64 |
+
$installer->setConfigData('banners/showhide/align_buttons_left','0');
|
65 |
+
$installer->setConfigData('banners/showhide/align_text_top','0');
|
66 |
+
$installer->setConfigData('banners/showhide/auto_play','0');
|
67 |
+
$installer->setConfigData('banners/general/auto_play','1');
|
68 |
+
$installer->setConfigData('banners/general/image_resize_to_fit','1');
|
69 |
+
$installer->setConfigData('banners/general/image_randomize_order','0');
|
70 |
+
|
71 |
+
$installer->endSetup();
|
72 |
+
|
73 |
+
?>
|
app/code/local/Mage/Banners/sql/banners_setup/{mysql4-uninstall-1.3.5.php → mysql4-uninstall-1.4.0.php}
RENAMED
@@ -26,6 +26,8 @@ $installer->startSetup();
|
|
26 |
|
27 |
$installer->run("
|
28 |
DROP TABLE `{$this->getTable('banners')}`;
|
|
|
|
|
29 |
");
|
30 |
|
31 |
$installer->endSetup();
|
26 |
|
27 |
$installer->run("
|
28 |
DROP TABLE `{$this->getTable('banners')}`;
|
29 |
+
DROP TABLE `{$this->getTable('banners_store')}`;
|
30 |
+
|
31 |
");
|
32 |
|
33 |
$installer->endSetup();
|
app/code/local/Mage/Banners/sql/banners_setup/mysql4-upgrade-0.1.0-1.4.0.php
ADDED
@@ -0,0 +1,53 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?php
|
2 |
+
/**
|
3 |
+
* Scalena_News extension
|
4 |
+
*
|
5 |
+
* NOTICE OF LICENSE
|
6 |
+
*
|
7 |
+
* This source file is subject to the Open Software License (OSL 3.0)
|
8 |
+
* that is bundled with this package in the file LICENSE.txt.
|
9 |
+
* It is also available through the world-wide-web at this URL:
|
10 |
+
* http://opensource.org/licenses/osl-3.0.php
|
11 |
+
*
|
12 |
+
* @category Scalena
|
13 |
+
* @package Scalena_News
|
14 |
+
* @copyright Copyright (c) 2009 Scalena Agency SA
|
15 |
+
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
|
16 |
+
*/
|
17 |
+
|
18 |
+
/**
|
19 |
+
* @category Scalena
|
20 |
+
* @package Scalena_News
|
21 |
+
* @author Anthony Charrex <anthony@scalena.com>
|
22 |
+
*/
|
23 |
+
|
24 |
+
$installer = $this;
|
25 |
+
$connection = $installer->getConnection();
|
26 |
+
$installer->startSetup();
|
27 |
+
|
28 |
+
$installer->run("
|
29 |
+
DROP TABLE IF EXISTS `{$this->getTable('banners_store')}`;
|
30 |
+
CREATE TABLE IF NOT EXISTS `{$this->getTable('banners_store')}` (
|
31 |
+
`banners_id` int(11) NOT NULL,
|
32 |
+
`store_id` smallint(5) unsigned NOT NULL,
|
33 |
+
PRIMARY KEY (`banners_id`,`store_id`),
|
34 |
+
KEY `FK_BANNERS_STORE_STORE` (`store_id`)
|
35 |
+
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Usol Banners Stores';
|
36 |
+
");
|
37 |
+
|
38 |
+
$connection->addConstraint('FK_BANNERS_STORE_STORE',
|
39 |
+
$installer->getTable('banners_store'), 'store_id',
|
40 |
+
$installer->getTable('core_store'), 'store_id',
|
41 |
+
'CASCADE', 'CASCADE', true
|
42 |
+
);
|
43 |
+
|
44 |
+
$connection->addConstraint('banners_store_ibfk_1',
|
45 |
+
$installer->getTable('banners_store'), 'banners_id',
|
46 |
+
$installer->getTable('banners'), 'banners_id',
|
47 |
+
'CASCADE', 'CASCADE', true
|
48 |
+
);
|
49 |
+
$installer->endSetup();
|
50 |
+
|
51 |
+
?>
|
52 |
+
|
53 |
+
|
app/code/local/Mage/Banners/sql/banners_setup/mysql4-upgrade-1.3.1-1.3.2-1.3.3-1.3.4.php
DELETED
@@ -1,66 +0,0 @@
|
|
1 |
-
<?php
|
2 |
-
/**
|
3 |
-
* Testimonial extension
|
4 |
-
*
|
5 |
-
* NOTICE OF LICENSE
|
6 |
-
*
|
7 |
-
* This source file is subject to the Open Software License (OSL 3.0)
|
8 |
-
* that is bundled with this package in the file LICENSE.txt.
|
9 |
-
* It is also available through the world-wide-web at this URL:
|
10 |
-
* http://opensource.org/licenses/osl-3.0.php
|
11 |
-
*
|
12 |
-
* @category Usol
|
13 |
-
* @package Testimonial
|
14 |
-
* @copyright Copyright (c) 2009 Unitedsol.net
|
15 |
-
*/
|
16 |
-
|
17 |
-
/**
|
18 |
-
* @category Testimonial
|
19 |
-
* @package Testimonial
|
20 |
-
* @author Kamran Rafiq Malik <kamran.malik@unitedsol.net>
|
21 |
-
*/
|
22 |
-
|
23 |
-
$installer = $this;
|
24 |
-
$connection = $installer->getConnection();
|
25 |
-
|
26 |
-
$installer->startSetup();
|
27 |
-
|
28 |
-
$installer->setConfigData('banners/general/banner_width', '600');
|
29 |
-
$installer->setConfigData('banners/general/banner_height', '400');
|
30 |
-
$installer->setConfigData('banners/general/banner_backgroundcolor', 'FFFFFF');
|
31 |
-
$installer->setConfigData('banners/general/auto_play', 'yes');
|
32 |
-
$installer->setConfigData('banners/general/image_resize_to_fit', 'yes');
|
33 |
-
$installer->setConfigData('banners/general/image_randomize_order', 'no');
|
34 |
-
|
35 |
-
$installer->setConfigData('banners/textsettings/text_size', '12');
|
36 |
-
$installer->setConfigData('banners/textsettings/text_color', '');
|
37 |
-
$installer->setConfigData('banners/textsettings/text_area_width', '200');
|
38 |
-
$installer->setConfigData('banners/textsettings/text_line_spacing', '0');
|
39 |
-
$installer->setConfigData('banners/textsettings/text_margin_left', '12');
|
40 |
-
$installer->setConfigData('banners/textsettings/text_letter_spacing', '-0.5');
|
41 |
-
$installer->setConfigData('banners/textsettings/text_margin_bottom', '5');
|
42 |
-
$installer->setConfigData('banners/textsettings/text_background_blur', 'yes');
|
43 |
-
$installer->setConfigData('banners/textsettings/text_background_transparency', '30');
|
44 |
-
$installer->setConfigData('banners/textsettings/text_background_color', '333333');
|
45 |
-
|
46 |
-
$installer->setConfigData('banners/transition/transition_type', '5');
|
47 |
-
$installer->setConfigData('banners/transition/transition_blur', 'yes');
|
48 |
-
$installer->setConfigData('banners/transition/transition_speed', '10');
|
49 |
-
$installer->setConfigData('banners/transition/transition_delay_time_fixed', '10');
|
50 |
-
$installer->setConfigData('banners/transition/transition_random_effects', 'no');
|
51 |
-
$installer->setConfigData('banners/transition/transition_delay_time_per_word', '.5');
|
52 |
-
|
53 |
-
$installer->setConfigData('banners/showhide/show_timer_clock', 'yes');
|
54 |
-
$installer->setConfigData('banners/showhide/show_next_button', 'yes');
|
55 |
-
$installer->setConfigData('banners/showhide/show_back_button', 'yes');
|
56 |
-
$installer->setConfigData('banners/showhide/show_number_buttons', 'yes');
|
57 |
-
$installer->setConfigData('banners/showhide/show_number_buttons_always', 'no');
|
58 |
-
$installer->setConfigData('banners/showhide/show_number_buttons_horizontal', 'yes');
|
59 |
-
$installer->setConfigData('banners/showhide/show_number_buttons_ascending', 'no');
|
60 |
-
$installer->setConfigData('banners/showhide/show_play_pause_on_timer', 'yes');
|
61 |
-
$installer->setConfigData('banners/showhide/align_buttons_left', 'no');
|
62 |
-
$installer->setConfigData('banners/showhide/align_text_top', 'no');
|
63 |
-
|
64 |
-
$installer->endSetup();
|
65 |
-
|
66 |
-
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
app/design/adminhtml/default/default/layout/banners.xml
CHANGED
@@ -1,5 +1,5 @@
|
|
1 |
<?xml version="1.0"?>
|
2 |
-
<layout version="
|
3 |
<banners_adminhtml_banners_index>
|
4 |
<reference name="content">
|
5 |
<block type="banners/adminhtml_banners" name="banners" />
|
1 |
<?xml version="1.0"?>
|
2 |
+
<layout version="1.4.0">
|
3 |
<banners_adminhtml_banners_index>
|
4 |
<reference name="content">
|
5 |
<block type="banners/adminhtml_banners" name="banners" />
|
app/design/frontend/default/default/layout/banners.xml
CHANGED
@@ -1,5 +1,5 @@
|
|
1 |
<?xml version="1.0"?>
|
2 |
-
<layout version="
|
3 |
<default>
|
4 |
</default>
|
5 |
<banners_index_index>
|
1 |
<?xml version="1.0"?>
|
2 |
+
<layout version="1.4.0">
|
3 |
<default>
|
4 |
</default>
|
5 |
<banners_index_index>
|
media/Banners/data.xml
CHANGED
@@ -1 +1 @@
|
|
1 |
-
<?xml version="1.0" encoding="utf-8" ?><Banner bannerWidth="564" bannerHeight="345" bannerBackgroundColor="FFFFFF" autoPlay="yes" imageResizeToFit="yes" imageRandomizeOrder="no" textSize="12" textColor="" textAreaWidth="200" textLineSpacing="0" textLetterSpacing="-0.5" textMarginLeft="12" textMarginBottom="5" textBackgroundBlur="yes" textBackgroundColor="333333" textBackgroundTransparency="30" transitionType="4" transitionRandomEffects="no" transitionDelayTimeFixed="10" transitionDelayTimePerWord=".5" transitionSpeed="10" transitionBlur="yes" showTimerClock="no" showNextButton="no" showBackButton="no" showNumberButtons="no" showNumberButtonsAlways="no" showNumberButtonsHorizontal="yes" showNumberButtonsAscending="yes" showPlayPauseOnTimer="yes" alignButtonsLeft="no" alignTextTop="no" > <item buttonLabel="" image="http://10.10.10.102/kamran/
|
1 |
+
<?xml version="1.0" encoding="utf-8" ?><Banner bannerWidth="564" bannerHeight="345" bannerBackgroundColor="FFFFFF" autoPlay="yes" imageResizeToFit="yes" imageRandomizeOrder="no" textSize="12" textColor="" textAreaWidth="200" textLineSpacing="0" textLetterSpacing="-0.5" textMarginLeft="12" textMarginBottom="5" textBackgroundBlur="yes" textBackgroundColor="333333" textBackgroundTransparency="30" transitionType="4" transitionRandomEffects="no" transitionDelayTimeFixed="10" transitionDelayTimePerWord=".5" transitionSpeed="10" transitionBlur="yes" showTimerClock="no" showNextButton="no" showBackButton="no" showNumberButtons="no" showNumberButtonsAlways="no" showNumberButtonsHorizontal="yes" showNumberButtonsAscending="yes" showPlayPauseOnTimer="yes" alignButtonsLeft="no" alignTextTop="no" > <item buttonLabel="" image="http://10.10.10.102/kamran/newbannertest/media/Banners/images/jareck.jpg" link="http://www.unitedsol.net" target="_blank" delay="" textBlend="yes"> <![CDATA[Test Case]]> </item> </Banner>
|
media/Banners/images/Thumbs.db
DELETED
Binary file
|
media/Banners/images/medium/Thumbs.db
ADDED
Binary file
|
package.xml
CHANGED
@@ -1,18 +1,18 @@
|
|
1 |
<?xml version="1.0"?>
|
2 |
<package>
|
3 |
<name>Banners</name>
|
4 |
-
<version>1.
|
5 |
<stability>stable</stability>
|
6 |
<license uri="http://opensource.org/licenses/osl-3.0.php">OSL V3.0</license>
|
7 |
<channel>community</channel>
|
8 |
<extends/>
|
9 |
<summary>Banner is a flexible solution that allow to manage banners in the easiest way.</summary>
|
10 |
<description>Banner is a flexible solution that allow to manage banners in the easiest way.</description>
|
11 |
-
<notes>NOTE: Please download the Latest release 1.
|
12 |
<authors><author><name>Kamran Rafiq Malik</name><user>auto-converted</user><email>kamran.malik@unitedsol.net</email></author></authors>
|
13 |
-
<date>2010-
|
14 |
-
<time>
|
15 |
-
<contents><target name="mage"><dir name="media"><dir name="Banners"><dir name="images"><file name="
|
16 |
<compatible/>
|
17 |
<dependencies/>
|
18 |
</package>
|
1 |
<?xml version="1.0"?>
|
2 |
<package>
|
3 |
<name>Banners</name>
|
4 |
+
<version>1.4.0</version>
|
5 |
<stability>stable</stability>
|
6 |
<license uri="http://opensource.org/licenses/osl-3.0.php">OSL V3.0</license>
|
7 |
<channel>community</channel>
|
8 |
<extends/>
|
9 |
<summary>Banner is a flexible solution that allow to manage banners in the easiest way.</summary>
|
10 |
<description>Banner is a flexible solution that allow to manage banners in the easiest way.</description>
|
11 |
+
<notes>NOTE: Please download the Latest release 1.4.0 from Releases section!</notes>
|
12 |
<authors><author><name>Kamran Rafiq Malik</name><user>auto-converted</user><email>kamran.malik@unitedsol.net</email></author></authors>
|
13 |
+
<date>2010-06-23</date>
|
14 |
+
<time>07:50:05</time>
|
15 |
+
<contents><target name="mage"><dir name="media"><dir name="Banners"><dir name="images"><dir name="medium"><file name="Thumbs.db" hash="3e0e7ae4da88353d97092b62405ebaa1"/></dir><file name="logo.png" hash="e33c86d89150a2d02f293f99aad7c062"/></dir><dir name="swf"><file name="banner.fla" hash="6c9b61429a2cf82af339e0dfe7b89911"/><file name="banner.swf" hash="3aa22fdf4e195134e9da0c781a5c6670"/><file name="swfobject.js" hash="b687734407abd950392ae2344b283b2c"/></dir><file name="banner.swf" hash="3aa22fdf4e195134e9da0c781a5c6670"/><file name="data.xml" hash="532ad0e21c6dcb004bb37cce44d3b330"/></dir></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file name="banners.xml" hash="bd3eb7e548e2d2f9fdac611db5fd4454"/></dir></dir></dir></dir><dir name="frontend"><dir name="default"><dir name="default"><dir name="layout"><file name="banners.xml" hash="6260cade01f56d225b4aadd2fc4e397b"/></dir><dir name="template"><dir name="banners"><file name="banners.phtml" hash="824bda76e9eec726073d89de03ce48a1"/></dir></dir></dir></dir></dir></target><target name="magelocal"><dir name="Mage"><dir name="Banners"><dir name="Block"><dir name="Adminhtml"><dir name="Banners"><dir name="Edit"><dir name="Tab"><file name="Form.php" hash="b55f503557ccd000fd0a69efe7f1c47d"/></dir><file name="Form.php" hash="5d28449951793e81ddbe3c5be99fad57"/><file name="Tabs.php" hash="f2bf342dfb322366e4d509a35aafd8d5"/></dir><file name="Edit.php" hash="4b31a335d0cce9c08c83033effd2ecd1"/><file name="Grid.php" hash="899bb9d583533515949c0ac2daea7c37"/></dir><file name="Banners.php" hash="f2445f14f813ce3276ddb6968112c0cc"/></dir><file name="Banners.php" hash="3bdaf9b98b564cca8056547f916d0f79"/></dir><dir name="controllers"><dir name="Adminhtml"><file name="BannersController.php" hash="03a7b537274fa9def54501e956f511dc"/></dir><file name="IndexController.php" hash="a78df40c48b7ae16740ce79d047a7102"/></dir><dir name="etc"><file name="config.xml" hash="83e0a52f33d6bf9b7493b6d4f8212d07"/><file name="system.xml" hash="1eb7784c5706faf24f94fe93a8a6c4ef"/></dir><dir name="Helper"><file name="Data.php" hash="f4fe69ea498a8ad619b3e1d699843b06"/></dir><dir name="Model"><dir name="Mysql4"><dir name="Banners"><file name="Collection.php" hash="4d89b80928d48fd839522d696da60170"/></dir><file name="Banners.php" hash="10c2560e75e717b4f7acb71a7f959bae"/></dir><file name="Banners.php" hash="07374201a9f0549c2986f42ece034a8b"/><file name="Status.php" hash="0cf9313a923b991e71949ff8c993156c"/></dir><dir name="sql"><dir name="banners_setup"><file name="mysql4-install-1.4.0.php" hash="d245d9d611f8fc96e50318f1c7cf3867"/><file name="mysql4-uninstall-1.4.0.php" hash="14573ee9a2208d78384e5fd56a0d348d"/><file name="mysql4-upgrade-0.1.0-1.4.0.php" hash="e6b7ba94dc396e4f026ab7812e853d41"/></dir></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Mage_Banners.xml" hash="00231c699a70c089c808243400500e5e"/></dir></target><target name="magelib"><dir name="Varien"><dir name="Data"><dir name="Form"><dir name="Element"><file name="Thumbnail.php" hash="8909f9c5df2188e6eefc3f6509cafa76"/></dir></dir></dir></dir></target></contents>
|
16 |
<compatible/>
|
17 |
<dependencies/>
|
18 |
</package>
|