Version Notes
For a list of changes, please see https://fishpig.co.uk/magento/extensions/attribute-splash-pages/#changelog
Download this release
Release Info
Developer | fishpig |
Extension | Fishpigs_Attribute_Splash_Page |
Version | 3.3.9.3 |
Comparing to | |
See all releases |
Code changes from version 3.3.9.2 to 3.3.9.3
- app/code/community/Fishpig/AttributeSplash/Model/Resource/Group.php +103 -70
- app/code/community/Fishpig/AttributeSplash/etc/config.xml +1 -1
- app/code/community/Fishpig/AttributeSplash/sql/attributeSplash_setup/mysql4-upgrade-1.9.5-1.9.6.php +0 -3
- app/code/community/Fishpig/AttributeSplash/sql/attributeSplash_setup/mysql4-upgrade-2.0.1-2.0.2.php +0 -3
- app/code/community/Fishpig/AttributeSplash/sql/attributeSplash_setup/mysql4-upgrade-3.3.3.0-3.3.4.0.php +0 -7
- app/code/community/Fishpig/AttributeSplash/sql/attributeSplash_setup/mysql4-upgrade-3.3.8.19-3.3.8.20.php +0 -17
- app/code/community/Fishpig/AttributeSplash/sql/attributeSplash_setup/mysql4-upgrade-3.3.9.2-3.3.9.3.php +14 -0
- package.xml +4 -4
app/code/community/Fishpig/AttributeSplash/Model/Resource/Group.php
CHANGED
@@ -126,27 +126,6 @@ class Fishpig_AttributeSplash_Model_Resource_Group extends Fishpig_AttributeSpla
|
|
126 |
public function fixTables()
|
127 |
{
|
128 |
$this->_installTable();
|
129 |
-
|
130 |
-
try {
|
131 |
-
$value = $this->_getReadAdapter()->fetchOne(
|
132 |
-
$this->_getReadAdapter()
|
133 |
-
->select()
|
134 |
-
->from(Mage::getSingleton('core/resource')->getTableName('attributesplash_group'), $this->getIdFieldName())
|
135 |
-
->limit(1)
|
136 |
-
);
|
137 |
-
|
138 |
-
if (!$value) {
|
139 |
-
foreach(array('group_index', 'group_store', 'group') as $table) {
|
140 |
-
# $this->_getWriteAdapter()->query('DROP TABLE ' . Mage::getSingleton('core/resource')->getTableName('attributesplash_' . $table));
|
141 |
-
}
|
142 |
-
}
|
143 |
-
else {
|
144 |
-
|
145 |
-
}
|
146 |
-
}
|
147 |
-
catch (Exception $e) {
|
148 |
-
throw $e;
|
149 |
-
}
|
150 |
}
|
151 |
|
152 |
/**
|
@@ -174,7 +153,6 @@ class Fishpig_AttributeSplash_Model_Resource_Group extends Fishpig_AttributeSpla
|
|
174 |
(
|
175 |
`group_id` int(11) unsigned NOT NULL auto_increment,
|
176 |
`attribute_id` smallint(5) unsigned NOT NULL default 0,
|
177 |
-
`store_id` smallint(5) unsigned NOT NULL default 0,
|
178 |
`display_name` varchar(255) NOT NULL default '',
|
179 |
`short_description` TEXT NOT NULL default '',
|
180 |
`description` TEXT NOT NULL default '',
|
@@ -191,74 +169,29 @@ class Fishpig_AttributeSplash_Model_Resource_Group extends Fishpig_AttributeSpla
|
|
191 |
`created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
|
192 |
`updated_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
|
193 |
|
194 |
-
PRIMARY KEY (`group_id`)
|
195 |
-
|
196 |
-
KEY `FK_ATTRIBUTE_ID_SPLASH_GROUP2` (`attribute_id`),
|
197 |
-
CONSTRAINT `FK_ATTRIBUTE_ID_SPLASH_GROUP2`
|
198 |
-
FOREIGN KEY (`attribute_id`)
|
199 |
-
REFERENCES `{$this->getTable('eav/attribute')}` (`attribute_id`)
|
200 |
-
ON DELETE CASCADE
|
201 |
-
ON UPDATE CASCADE,
|
202 |
-
|
203 |
-
KEY `FK_STORE_ID_SPLASH_GROUP2` (`store_id`),
|
204 |
-
CONSTRAINT `FK_STORE_ID_SPLASH_GROUP2`
|
205 |
-
FOREIGN KEY (`store_id`)
|
206 |
-
REFERENCES `{$this->getTable('core/store')}` (`store_id`)
|
207 |
-
ON DELETE CASCADE
|
208 |
-
ON UPDATE CASCADE
|
209 |
)
|
210 |
ENGINE=InnoDB
|
211 |
DEFAULT CHARSET=utf8
|
212 |
COMMENT='AttributeSplash: Group';
|
213 |
-
|
214 |
-
ALTER TABLE {$groupTable} ADD UNIQUE `UNIQUE_ATTRIBUTE_ID_STORE_ID_SPLASH_GROUP2` (attribute_id, store_id);
|
215 |
|
216 |
CREATE TABLE IF NOT EXISTS {$groupStoreTable} (
|
217 |
`group_id` int(11) unsigned NOT NULL auto_increment,
|
218 |
`store_id` smallint(5) unsigned NOT NULL default 0,
|
219 |
|
220 |
-
PRIMARY KEY (`group_id`, `store_id`)
|
221 |
-
|
222 |
-
KEY `FK_PAGE_ID_SPLASH_GROUP2_STORE` (`group_id`),
|
223 |
-
CONSTRAINT `FK_PAGE_ID_SPLASH_GROUP2_STORE`
|
224 |
-
FOREIGN KEY (`group_id`)
|
225 |
-
REFERENCES `{$groupTable}` (`group_id`)
|
226 |
-
ON DELETE CASCADE
|
227 |
-
ON UPDATE CASCADE,
|
228 |
-
|
229 |
-
KEY `FK_STORE_ID_SPLASH_GROUP2_STORE` (`store_id`),
|
230 |
-
CONSTRAINT `FK_STORE_ID_SPLASH_GROUP2_STORE`
|
231 |
-
FOREIGN KEY (`store_id`)
|
232 |
-
REFERENCES `{$this->getTable('core/store')}` (`store_id`)
|
233 |
-
ON DELETE CASCADE
|
234 |
-
ON UPDATE CASCADE
|
235 |
|
236 |
)
|
237 |
ENGINE=InnoDB
|
238 |
DEFAULT CHARSET=utf8
|
239 |
COMMENT='AttributeSplash: Group / Store';
|
240 |
|
241 |
-
ALTER TABLE {$groupStoreTable} ADD UNIQUE `UNIQUE_ATTRIBUTE_ID_STORE_ID_SPLASH_GROUP2_STORE` (`group_id`,`store_id`);
|
242 |
|
243 |
CREATE TABLE IF NOT EXISTS {$groupIndexTable} (
|
244 |
`group_id` int(11) unsigned NOT NULL,
|
245 |
`store_id` smallint(5) unsigned NOT NULL,
|
246 |
|
247 |
-
PRIMARY KEY (`group_id`, `store_id`)
|
248 |
-
|
249 |
-
KEY `FK_GROUP_ID_SPLASH_GROUP2_INDEX` (`group_id`),
|
250 |
-
CONSTRAINT `FK_GROUP_ID_SPLASH_GROUP2_INDEX`
|
251 |
-
FOREIGN KEY (`group_id`)
|
252 |
-
REFERENCES `{$groupTable}` (`group_id`)
|
253 |
-
ON DELETE CASCADE
|
254 |
-
ON UPDATE CASCADE,
|
255 |
-
|
256 |
-
KEY `FK_STORE_ID_SPLASH_GROUP2_INDEX` (`store_id`),
|
257 |
-
CONSTRAINT `FK_STORE_ID_SPLASH_GROUP2_INDEX`
|
258 |
-
FOREIGN KEY (`store_id`)
|
259 |
-
REFERENCES `{$this->getTable('core/store')}` (`store_id`)
|
260 |
-
ON DELETE CASCADE
|
261 |
-
ON UPDATE CASCADE
|
262 |
)
|
263 |
ENGINE=InnoDB
|
264 |
DEFAULT CHARSET=utf8
|
@@ -267,6 +200,7 @@ class Fishpig_AttributeSplash_Model_Resource_Group extends Fishpig_AttributeSpla
|
|
267 |
|
268 |
try {
|
269 |
$this->_getWriteAdapter()->query($sql);
|
|
|
270 |
}
|
271 |
catch (Exception $e) {
|
272 |
Mage::logException($e);
|
@@ -275,4 +209,103 @@ class Fishpig_AttributeSplash_Model_Resource_Group extends Fishpig_AttributeSpla
|
|
275 |
}
|
276 |
}
|
277 |
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
278 |
}
|
126 |
public function fixTables()
|
127 |
{
|
128 |
$this->_installTable();
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
129 |
}
|
130 |
|
131 |
/**
|
153 |
(
|
154 |
`group_id` int(11) unsigned NOT NULL auto_increment,
|
155 |
`attribute_id` smallint(5) unsigned NOT NULL default 0,
|
|
|
156 |
`display_name` varchar(255) NOT NULL default '',
|
157 |
`short_description` TEXT NOT NULL default '',
|
158 |
`description` TEXT NOT NULL default '',
|
169 |
`created_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
|
170 |
`updated_at` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
|
171 |
|
172 |
+
PRIMARY KEY (`group_id`)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
173 |
)
|
174 |
ENGINE=InnoDB
|
175 |
DEFAULT CHARSET=utf8
|
176 |
COMMENT='AttributeSplash: Group';
|
|
|
|
|
177 |
|
178 |
CREATE TABLE IF NOT EXISTS {$groupStoreTable} (
|
179 |
`group_id` int(11) unsigned NOT NULL auto_increment,
|
180 |
`store_id` smallint(5) unsigned NOT NULL default 0,
|
181 |
|
182 |
+
PRIMARY KEY (`group_id`, `store_id`)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
183 |
|
184 |
)
|
185 |
ENGINE=InnoDB
|
186 |
DEFAULT CHARSET=utf8
|
187 |
COMMENT='AttributeSplash: Group / Store';
|
188 |
|
|
|
189 |
|
190 |
CREATE TABLE IF NOT EXISTS {$groupIndexTable} (
|
191 |
`group_id` int(11) unsigned NOT NULL,
|
192 |
`store_id` smallint(5) unsigned NOT NULL,
|
193 |
|
194 |
+
PRIMARY KEY (`group_id`, `store_id`)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
195 |
)
|
196 |
ENGINE=InnoDB
|
197 |
DEFAULT CHARSET=utf8
|
200 |
|
201 |
try {
|
202 |
$this->_getWriteAdapter()->query($sql);
|
203 |
+
$this->fixIndexes();
|
204 |
}
|
205 |
catch (Exception $e) {
|
206 |
Mage::logException($e);
|
209 |
}
|
210 |
}
|
211 |
}
|
212 |
+
|
213 |
+
public function fixIndexes()
|
214 |
+
{
|
215 |
+
$tables = array(
|
216 |
+
'group',
|
217 |
+
'group_index',
|
218 |
+
'group_store',
|
219 |
+
);
|
220 |
+
|
221 |
+
$db = $this->_getWriteAdapter();
|
222 |
+
|
223 |
+
try {
|
224 |
+
foreach($tables as $table) {
|
225 |
+
$indexesSql = 'SHOW INDEX FROM ' . $this->getTable('attributeSplash/' . $table);
|
226 |
+
|
227 |
+
if ($indexes = $db->fetchAll($indexesSql)) {
|
228 |
+
foreach($indexes as $index) {
|
229 |
+
if ($index['Key_name'] === 'PRIMARY') {
|
230 |
+
continue;
|
231 |
+
}
|
232 |
+
|
233 |
+
try {
|
234 |
+
$db->query(sprintf('ALTER TABLE %s DROP FOREIGN KEY %s', $index['Table'], $index['Key_name']));
|
235 |
+
$db->query(sprintf('DROP INDEX `%s` ON %s', $index['Key_name'], $index['Table']));
|
236 |
+
}
|
237 |
+
catch (Exception $e) {}
|
238 |
+
}
|
239 |
+
}
|
240 |
+
}
|
241 |
+
|
242 |
+
try {
|
243 |
+
$db->query('ALTER TABLE ' . $this->getTable('attributeSplash/group') . ' DROP COLUMN `store_id`');
|
244 |
+
}
|
245 |
+
catch (Exception $e) {}
|
246 |
+
|
247 |
+
// Splash Group: Attribute ID
|
248 |
+
$this->_addForeginKey(
|
249 |
+
'FK_FIX_SPLASH_GROUP_ATTRIBUTE_ID',
|
250 |
+
$this->getTable('attributeSplash/group'),
|
251 |
+
'attribute_id',
|
252 |
+
$this->getTable('eav/attribute')
|
253 |
+
);
|
254 |
+
|
255 |
+
// Splash Group Store: Group ID
|
256 |
+
$this->_addForeginKey(
|
257 |
+
'FK_FIX_SPLASH_GROUP_STORE_GROUP_ID',
|
258 |
+
$this->getTable('attributeSplash/group_store'),
|
259 |
+
'group_id',
|
260 |
+
$this->getTable('attributeSplash/group')
|
261 |
+
);
|
262 |
+
|
263 |
+
// Splash Group Store: Store ID
|
264 |
+
$this->_addForeginKey(
|
265 |
+
'FK_FIX_SPLASH_GROUP_STORE_STORE_ID',
|
266 |
+
$this->getTable('attributeSplash/group_store'),
|
267 |
+
'store_id',
|
268 |
+
$this->getTable('core/store')
|
269 |
+
);
|
270 |
+
|
271 |
+
// ALTER TABLE {$groupStoreTable} ADD UNIQUE `UNIQUE_ATTRIBUTE_ID_STORE_ID_SPLASH_GROUP2_STORE` (`group_id`,`store_id`);
|
272 |
+
|
273 |
+
// Splash Group Store: Group ID
|
274 |
+
$this->_addForeginKey(
|
275 |
+
'FK_FIX_SPLASH_GROUP_INDEX_GROUP_ID',
|
276 |
+
$this->getTable('attributeSplash/group_index'),
|
277 |
+
'group_id',
|
278 |
+
$this->getTable('attributeSplash/group')
|
279 |
+
);
|
280 |
+
|
281 |
+
// Splash Group Store: Store ID
|
282 |
+
$this->_addForeginKey(
|
283 |
+
'FK_FIX_SPLASH_GROUP_INDEX_STORE_ID',
|
284 |
+
$this->getTable('attributeSplash/group_index'),
|
285 |
+
'store_id',
|
286 |
+
$this->getTable('core/store')
|
287 |
+
);
|
288 |
+
}
|
289 |
+
catch (Exception $e) {
|
290 |
+
echo 'End: ' . $e->getMessage() . '<pre>' . $e->getTraceAsString();
|
291 |
+
exit;
|
292 |
+
}
|
293 |
+
}
|
294 |
+
|
295 |
+
protected function _addForeginKey($keyName, $target, $tfield, $source, $sfield = null)
|
296 |
+
{
|
297 |
+
try {
|
298 |
+
$this->_getWriteAdapter()->query(sprintf(
|
299 |
+
'ALTER TABLE %s ADD CONSTRAINT %s FOREIGN KEY (%s) REFERENCES %s(%s) ON DELETE CASCADE ON UPDATE CASCADE;',
|
300 |
+
$target,
|
301 |
+
$keyName,
|
302 |
+
$tfield,
|
303 |
+
$source,
|
304 |
+
$sfield ? $sfield : $tfield
|
305 |
+
));
|
306 |
+
}
|
307 |
+
catch (Exception $e) {
|
308 |
+
# echo $e->getMessage() . '<br/><br/>';
|
309 |
+
}
|
310 |
+
}
|
311 |
}
|
app/code/community/Fishpig/AttributeSplash/etc/config.xml
CHANGED
@@ -2,7 +2,7 @@
|
|
2 |
<config>
|
3 |
<modules>
|
4 |
<Fishpig_AttributeSplash>
|
5 |
-
<version>3.3.9.
|
6 |
</Fishpig_AttributeSplash>
|
7 |
</modules>
|
8 |
<global>
|
2 |
<config>
|
3 |
<modules>
|
4 |
<Fishpig_AttributeSplash>
|
5 |
+
<version>3.3.9.3</version>
|
6 |
</Fishpig_AttributeSplash>
|
7 |
</modules>
|
8 |
<global>
|
app/code/community/Fishpig/AttributeSplash/sql/attributeSplash_setup/mysql4-upgrade-1.9.5-1.9.6.php
CHANGED
@@ -17,7 +17,6 @@
|
|
17 |
CREATE TABLE IF NOT EXISTS {$this->getTable('attributesplash_page')} (
|
18 |
`page_id` int(11) unsigned NOT NULL auto_increment,
|
19 |
`option_id` int (11) unsigned NOT NULL default 0,
|
20 |
-
`store_id` smallint(5) unsigned NOT NULL default 0,
|
21 |
`display_name` varchar(255) NOT NULL default '',
|
22 |
`image` varchar(255) NOT NULL default '',
|
23 |
`short_description` varchar(255) NOT NULL default '',
|
@@ -35,8 +34,6 @@
|
|
35 |
KEY `FK_STORE_ID_SPLASH_PAGE` (`store_id`),
|
36 |
CONSTRAINT `FK_STORE_ID_SPLASH_PAGE` FOREIGN KEY (`store_id`) REFERENCES `{$this->getTable('core_store')}` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE
|
37 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='AttributeSplash: Page';
|
38 |
-
|
39 |
-
ALTER TABLE {$this->getTable('attributesplash_page')} ADD UNIQUE `FK_SPLASH_PAGE_OPTION_ID_STORE_ID_UNIQUE` (option_id, store_id);
|
40 |
|
41 |
");
|
42 |
|
17 |
CREATE TABLE IF NOT EXISTS {$this->getTable('attributesplash_page')} (
|
18 |
`page_id` int(11) unsigned NOT NULL auto_increment,
|
19 |
`option_id` int (11) unsigned NOT NULL default 0,
|
|
|
20 |
`display_name` varchar(255) NOT NULL default '',
|
21 |
`image` varchar(255) NOT NULL default '',
|
22 |
`short_description` varchar(255) NOT NULL default '',
|
34 |
KEY `FK_STORE_ID_SPLASH_PAGE` (`store_id`),
|
35 |
CONSTRAINT `FK_STORE_ID_SPLASH_PAGE` FOREIGN KEY (`store_id`) REFERENCES `{$this->getTable('core_store')}` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE
|
36 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='AttributeSplash: Page';
|
|
|
|
|
37 |
|
38 |
");
|
39 |
|
app/code/community/Fishpig/AttributeSplash/sql/attributeSplash_setup/mysql4-upgrade-2.0.1-2.0.2.php
CHANGED
@@ -13,7 +13,6 @@
|
|
13 |
CREATE TABLE IF NOT EXISTS {$this->getTable('attributeSplash/group')} (
|
14 |
`group_id` int(11) unsigned NOT NULL auto_increment,
|
15 |
`attribute_id` smallint(5) unsigned NOT NULL default 0,
|
16 |
-
`store_id` smallint(5) unsigned NOT NULL default 0,
|
17 |
`display_name` varchar(255) NOT NULL default '',
|
18 |
`short_description` varchar(255) NOT NULL default '',
|
19 |
`description` TEXT NOT NULL default '',
|
@@ -30,8 +29,6 @@
|
|
30 |
KEY `FK_STORE_ID_SPLASH_GROUP` (`store_id`),
|
31 |
CONSTRAINT `FK_STORE_ID_SPLASH_GROUP` FOREIGN KEY (`store_id`) REFERENCES `{$this->getTable('core_store')}` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE
|
32 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='AttributeSplash: Group';
|
33 |
-
|
34 |
-
ALTER TABLE {$this->getTable('attributeSplash/group')} ADD UNIQUE `UNIQUE_SPLASH_GROUP_ATTRIBUTE_ID_STORE_ID` (attribute_id, store_id);
|
35 |
|
36 |
");
|
37 |
|
13 |
CREATE TABLE IF NOT EXISTS {$this->getTable('attributeSplash/group')} (
|
14 |
`group_id` int(11) unsigned NOT NULL auto_increment,
|
15 |
`attribute_id` smallint(5) unsigned NOT NULL default 0,
|
|
|
16 |
`display_name` varchar(255) NOT NULL default '',
|
17 |
`short_description` varchar(255) NOT NULL default '',
|
18 |
`description` TEXT NOT NULL default '',
|
29 |
KEY `FK_STORE_ID_SPLASH_GROUP` (`store_id`),
|
30 |
CONSTRAINT `FK_STORE_ID_SPLASH_GROUP` FOREIGN KEY (`store_id`) REFERENCES `{$this->getTable('core_store')}` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE
|
31 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='AttributeSplash: Group';
|
|
|
|
|
32 |
|
33 |
");
|
34 |
|
app/code/community/Fishpig/AttributeSplash/sql/attributeSplash_setup/mysql4-upgrade-3.3.3.0-3.3.4.0.php
CHANGED
@@ -7,12 +7,5 @@
|
|
7 |
*/
|
8 |
|
9 |
$this->startSetup();
|
10 |
-
|
11 |
-
try {
|
12 |
-
$this->run("ALTER TABLE {$this->getTable('attributeSplash/group')} DROP index attribute_id");
|
13 |
-
}
|
14 |
-
catch (Exception $e) {
|
15 |
-
|
16 |
-
}
|
17 |
|
18 |
$this->endSetup();
|
7 |
*/
|
8 |
|
9 |
$this->startSetup();
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10 |
|
11 |
$this->endSetup();
|
app/code/community/Fishpig/AttributeSplash/sql/attributeSplash_setup/mysql4-upgrade-3.3.8.19-3.3.8.20.php
CHANGED
@@ -7,22 +7,5 @@
|
|
7 |
*/
|
8 |
|
9 |
$this->startSetup();
|
10 |
-
|
11 |
-
try {
|
12 |
-
$tableName = $this->getTable('attributesplash/group');
|
13 |
-
|
14 |
-
if ($indexes = $this->getConnection('core_read')->fetchAll("SHOW INDEX FROM " . $tableName)) {
|
15 |
-
foreach($indexes as $index) {
|
16 |
-
if ($index['Column_name'] === 'attribute_id') {
|
17 |
-
$this->run("DROP INDEX " . $index['Key_name'] . " ON " . $tableName);
|
18 |
-
}
|
19 |
-
}
|
20 |
-
}
|
21 |
-
|
22 |
-
$this->run("ALTER TABLE {$this->getTable('attributeSplash/group_store')} ADD UNIQUE `FK_SPLASH_PAGE_GROUP_ID_STORE_ID_FIX` (`group_id`,`store_id`);");
|
23 |
-
}
|
24 |
-
catch (Exception $e) {
|
25 |
-
Mage::logException($e);
|
26 |
-
}
|
27 |
|
28 |
$this->endSetup();
|
7 |
*/
|
8 |
|
9 |
$this->startSetup();
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
10 |
|
11 |
$this->endSetup();
|
app/code/community/Fishpig/AttributeSplash/sql/attributeSplash_setup/mysql4-upgrade-3.3.9.2-3.3.9.3.php
ADDED
@@ -0,0 +1,14 @@
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
+
<?php
|
2 |
+
/**
|
3 |
+
* @category Fishpig
|
4 |
+
* @package Fishpig_AttributeSplash
|
5 |
+
* @license http://fishpig.co.uk/license.txt
|
6 |
+
* @author Ben Tideswell <help@fishpig.co.uk>
|
7 |
+
*/
|
8 |
+
|
9 |
+
$this->startSetup();
|
10 |
+
|
11 |
+
Mage::getResourceModel('attributeSplash/group')->fixIndexes();
|
12 |
+
|
13 |
+
$this->endSetup();
|
14 |
+
|
package.xml
CHANGED
@@ -1,7 +1,7 @@
|
|
1 |
<?xml version="1.0"?>
|
2 |
<package>
|
3 |
<name>Fishpigs_Attribute_Splash_Page</name>
|
4 |
-
<version>3.3.9.
|
5 |
<stability>stable</stability>
|
6 |
<license uri="http://fishpig.co.uk/license.txt">FishPig EULA</license>
|
7 |
<channel>community</channel>
|
@@ -10,9 +10,9 @@
|
|
10 |
<description>This module allows you to create splash pages (landing pages) for your product attributes. These pages function much like category pages, allowing yo to display products, static blocks or both. The module works with the category navigation and layered navigation and includes fully customisable SEO URL's.</description>
|
11 |
<notes>For a list of changes, please see https://fishpig.co.uk/magento/extensions/attribute-splash-pages/#changelog</notes>
|
12 |
<authors><author><name>fishpig</name><user>fishpig</user><email>ben@fishpig.co.uk</email></author></authors>
|
13 |
-
<date>2017-05-
|
14 |
-
<time>
|
15 |
-
<contents><target name="magecommunity"><dir name="Fishpig"><dir name="AttributeSplash"><dir name="Block"><dir name="Adminhtml"><file name="Dashboard.php" hash="731dbb40a55071d02bd92e43473109fa"/><file name="Extend.php" hash="b953e4661405165bcf29b59aeda42a3b"/><dir name="Form"><dir name="Field"><file name="Urlkey.php" hash="b3f2e813188d6f8805b2caeb4f834bf6"/></dir></dir><dir name="Group"><dir name="Edit"><file name="Form.php" hash="fc927b79309df561773fe578fb1fad09"/><dir name="Tab"><file name="Abstract.php" hash="96e479a7eca8cb742f27a9eed619d65e"/><file name="Content.php" hash="30d24e08d83bb222f2b1a8169c4f3d48"/><file name="Design.php" hash="1fbc5babddc70729a1dcacb1fabbe034"/><file name="General.php" hash="c7c3d088f4a538c6b4d9a784aab88242"/><file name="Meta.php" hash="7058642a220347deeda6ea431fc054f1"/><file name="Seo.php" hash="a95471b43c44140ea07c24618f8b531e"/></dir><file name="Tabs.php" hash="b03a68cc45f8b68733d1627ab3538411"/></dir><file name="Edit.php" hash="79e7d29d23acd9c72ea37794c8d29231"/><file name="Grid.php" hash="c9a8ff43a063d389cc7d0ec093575988"/></dir><file name="Group.php" hash="7804d0272717593ef7afaa2261f7302c"/><dir name="Page"><dir name="Edit"><file name="Form.php" hash="ec8609e766d4e6e7176cc9e0c9e8b6bc"/><file name="Js.php" hash="45e4e33068189377e9bcac1a51b5ba47"/><dir name="Tab"><file name="Abstract.php" hash="577c17bec36fbffc6f8cd3231ba8a243"/><file name="Attributes.php" hash="dab45d890fa5566f8b940ced03ec48b1"/><file name="Content.php" hash="820db5968e8efcd80b8fcc70e74bff34"/><file name="Customfields.php" hash="02e904b03eba46e73bfe58d2a20ebee4"/><file name="Design.php" hash="48dc187093ec327a1877fb1ade16bb33"/><file name="General.php" hash="70c6893aca12ea2561cbf8119f19a799"/><file name="Images.php" hash="e1482076b30cfa9a60b71c5b9b9a68ac"/><file name="Meta.php" hash="c98f7455bfffe42a853d96e03fc38f07"/></dir><file name="Tabs.php" hash="391842403a007c35324aa8fd09ebef04"/></dir><file name="Edit.php" hash="e381e3a218bab4fca9f73e13b38992ec"/><file name="Grid.php" hash="509c695f523f07d01a4932a55f1dbc1f"/><dir name="Helper"><file name="Image.php" hash="562c6c1db32c28dec6b82465515ca0ea"/></dir></dir><file name="Page.php" hash="563f0973d5ca0c292f47f0f58e9537e0"/><file name="Xmlsitemap.php" hash="2dad376de1cbb3315f0c21446f9d1388"/></dir><dir name="Group"><file name="View.php" hash="90bddc0ab61ca3641239afd33e09e7e3"/></dir><dir name="Layer"><file name="View.php" hash="6912ebb70ef922f595f3dc1a2ce4477f"/></dir><dir name="Page"><dir name="View"><dir name="Product"><file name="List.php" hash="90d4af1ec0a4570f8677927ae71cc42c"/></dir></dir><file name="View.php" hash="dbb394a410de1cb4cb23c1bb45d6212b"/></dir></dir><dir name="Controller"><dir name="Adminhtml"><file name="Abstract.php" hash="cec926ac96555146b3df067ae6704fbe"/></dir><file name="Router.php" hash="ba23f63bcf040f6de68b59e7aa571958"/></dir><dir name="FPAdmin"><dir name="Block"><dir name="Adminhtml"><file name="Extend.php" hash="75e04a5ca9087172cfab1b98cad7b263"/></dir></dir><dir name="etc"><file name="config.xml" hash="b521b9303c7c8199e91cfda651dda1b1"/></dir><dir name="template"><file name="large.phtml" hash="0b2108b293d9dd694b2e31b0d3c84273"/><file name="small.phtml" hash="0aba9ac21006fa9f7811911d352bc89a"/></dir></dir><dir name="Helper"><file name="Data.php" hash="7b72101f7119271cd8d2a18bf64ada34"/><file name="Image.php" hash="ebffad52f40a213d5ec19f3918cd3c15"/></dir><dir name="Model"><file name="Abstract.php" hash="d3a5f25da7f7499a4d1b69a7be2d4def"/><file name="Group.php" hash="f131e5dca3b850a025b9b3c96d121be2"/><file name="Indexer.php" hash="41ad895ca63e0ebe96c5cd767f97b1d2"/><file name="Layer.php" hash="917e65bfa003edbb8b408c61fddf7d7a"/><file name="Observer.php" hash="76659169460564fbc869a12c39c3fda3"/><file name="Page.php" hash="247a78c4095843e24015accc207b98eb"/><dir name="Resource"><file name="Abstract.php" hash="e95a46fd676650126b9709ef5c156a86"/><dir name="Collection"><file name="Abstract.php" hash="47b5eca5bd1a3753fafce198bf803f16"/></dir><dir name="Group"><file name="Collection.php" hash="b6a383408392624d962a0b71f5c94116"/></dir><file name="Group.php" hash="
|
16 |
<compatible/>
|
17 |
<dependencies><required><php><min>5.2.0</min><max>8.0.0</max></php></required></dependencies>
|
18 |
</package>
|
1 |
<?xml version="1.0"?>
|
2 |
<package>
|
3 |
<name>Fishpigs_Attribute_Splash_Page</name>
|
4 |
+
<version>3.3.9.3</version>
|
5 |
<stability>stable</stability>
|
6 |
<license uri="http://fishpig.co.uk/license.txt">FishPig EULA</license>
|
7 |
<channel>community</channel>
|
10 |
<description>This module allows you to create splash pages (landing pages) for your product attributes. These pages function much like category pages, allowing yo to display products, static blocks or both. The module works with the category navigation and layered navigation and includes fully customisable SEO URL's.</description>
|
11 |
<notes>For a list of changes, please see https://fishpig.co.uk/magento/extensions/attribute-splash-pages/#changelog</notes>
|
12 |
<authors><author><name>fishpig</name><user>fishpig</user><email>ben@fishpig.co.uk</email></author></authors>
|
13 |
+
<date>2017-05-25</date>
|
14 |
+
<time>14:38:18</time>
|
15 |
+
<contents><target name="magecommunity"><dir name="Fishpig"><dir name="AttributeSplash"><dir name="Block"><dir name="Adminhtml"><file name="Dashboard.php" hash="731dbb40a55071d02bd92e43473109fa"/><file name="Extend.php" hash="b953e4661405165bcf29b59aeda42a3b"/><dir name="Form"><dir name="Field"><file name="Urlkey.php" hash="b3f2e813188d6f8805b2caeb4f834bf6"/></dir></dir><dir name="Group"><dir name="Edit"><file name="Form.php" hash="fc927b79309df561773fe578fb1fad09"/><dir name="Tab"><file name="Abstract.php" hash="96e479a7eca8cb742f27a9eed619d65e"/><file name="Content.php" hash="30d24e08d83bb222f2b1a8169c4f3d48"/><file name="Design.php" hash="1fbc5babddc70729a1dcacb1fabbe034"/><file name="General.php" hash="c7c3d088f4a538c6b4d9a784aab88242"/><file name="Meta.php" hash="7058642a220347deeda6ea431fc054f1"/><file name="Seo.php" hash="a95471b43c44140ea07c24618f8b531e"/></dir><file name="Tabs.php" hash="b03a68cc45f8b68733d1627ab3538411"/></dir><file name="Edit.php" hash="79e7d29d23acd9c72ea37794c8d29231"/><file name="Grid.php" hash="c9a8ff43a063d389cc7d0ec093575988"/></dir><file name="Group.php" hash="7804d0272717593ef7afaa2261f7302c"/><dir name="Page"><dir name="Edit"><file name="Form.php" hash="ec8609e766d4e6e7176cc9e0c9e8b6bc"/><file name="Js.php" hash="45e4e33068189377e9bcac1a51b5ba47"/><dir name="Tab"><file name="Abstract.php" hash="577c17bec36fbffc6f8cd3231ba8a243"/><file name="Attributes.php" hash="dab45d890fa5566f8b940ced03ec48b1"/><file name="Content.php" hash="820db5968e8efcd80b8fcc70e74bff34"/><file name="Customfields.php" hash="02e904b03eba46e73bfe58d2a20ebee4"/><file name="Design.php" hash="48dc187093ec327a1877fb1ade16bb33"/><file name="General.php" hash="70c6893aca12ea2561cbf8119f19a799"/><file name="Images.php" hash="e1482076b30cfa9a60b71c5b9b9a68ac"/><file name="Meta.php" hash="c98f7455bfffe42a853d96e03fc38f07"/></dir><file name="Tabs.php" hash="391842403a007c35324aa8fd09ebef04"/></dir><file name="Edit.php" hash="e381e3a218bab4fca9f73e13b38992ec"/><file name="Grid.php" hash="509c695f523f07d01a4932a55f1dbc1f"/><dir name="Helper"><file name="Image.php" hash="562c6c1db32c28dec6b82465515ca0ea"/></dir></dir><file name="Page.php" hash="563f0973d5ca0c292f47f0f58e9537e0"/><file name="Xmlsitemap.php" hash="2dad376de1cbb3315f0c21446f9d1388"/></dir><dir name="Group"><file name="View.php" hash="90bddc0ab61ca3641239afd33e09e7e3"/></dir><dir name="Layer"><file name="View.php" hash="6912ebb70ef922f595f3dc1a2ce4477f"/></dir><dir name="Page"><dir name="View"><dir name="Product"><file name="List.php" hash="90d4af1ec0a4570f8677927ae71cc42c"/></dir></dir><file name="View.php" hash="dbb394a410de1cb4cb23c1bb45d6212b"/></dir></dir><dir name="Controller"><dir name="Adminhtml"><file name="Abstract.php" hash="cec926ac96555146b3df067ae6704fbe"/></dir><file name="Router.php" hash="ba23f63bcf040f6de68b59e7aa571958"/></dir><dir name="FPAdmin"><dir name="Block"><dir name="Adminhtml"><file name="Extend.php" hash="75e04a5ca9087172cfab1b98cad7b263"/></dir></dir><dir name="etc"><file name="config.xml" hash="b521b9303c7c8199e91cfda651dda1b1"/></dir><dir name="template"><file name="large.phtml" hash="0b2108b293d9dd694b2e31b0d3c84273"/><file name="small.phtml" hash="0aba9ac21006fa9f7811911d352bc89a"/></dir></dir><dir name="Helper"><file name="Data.php" hash="7b72101f7119271cd8d2a18bf64ada34"/><file name="Image.php" hash="ebffad52f40a213d5ec19f3918cd3c15"/></dir><dir name="Model"><file name="Abstract.php" hash="d3a5f25da7f7499a4d1b69a7be2d4def"/><file name="Group.php" hash="f131e5dca3b850a025b9b3c96d121be2"/><file name="Indexer.php" hash="41ad895ca63e0ebe96c5cd767f97b1d2"/><file name="Layer.php" hash="917e65bfa003edbb8b408c61fddf7d7a"/><file name="Observer.php" hash="76659169460564fbc869a12c39c3fda3"/><file name="Page.php" hash="247a78c4095843e24015accc207b98eb"/><dir name="Resource"><file name="Abstract.php" hash="e95a46fd676650126b9709ef5c156a86"/><dir name="Collection"><file name="Abstract.php" hash="47b5eca5bd1a3753fafce198bf803f16"/></dir><dir name="Group"><file name="Collection.php" hash="b6a383408392624d962a0b71f5c94116"/></dir><file name="Group.php" hash="481f3a82a2117880cd6140e63da2796d"/><dir name="Page"><file name="Collection.php" hash="389e342252a9066cf4da11c80937a233"/></dir><file name="Page.php" hash="94324433973bf8d753e5bbbbe24105a8"/></dir><dir name="System"><dir name="Config"><dir name="Source"><dir name="Attribute"><file name="Abstract.php" hash="9ddfa2eb83e6ec8d257bcd2d6977f384"/><file name="Splashable.php" hash="40fa08332ff34bc41e201c31b96d51fd"/><file name="Splashed.php" hash="314567f1f80a1010b78f0c5349abaf4e"/></dir><file name="Layout.php" hash="f51ca8be6325f2e62a181c891b14cbfe"/></dir></dir></dir></dir><dir name="controllers"><dir name="Adminhtml"><dir name="AttributeSplash"><file name="GroupController.php" hash="01427ff74943bd8481a33dfc1b6e6f52"/><file name="PageController.php" hash="603555062a96300bcdd2c566c0885ec1"/></dir><file name="AttributeSplashController.php" hash="1f5efa878705b26b5de86927d31bdc1e"/></dir><file name="GroupController.php" hash="9f25aa2a2019e3027370af6270fa1d38"/><file name="PageController.php" hash="afd636c7d362a73ceef721a171a5518f"/><file name="SitemapController.php" hash="09d50b324c03ad40c68a1aafbe42f279"/></dir><dir name="etc"><file name="adminhtml.xml" hash="759d7ffa40031d14f5667fe60e0ad007"/><file name="config.xml" hash="58bb32d08a52d1a2d21e5522078b7f06"/><file name="system.xml" hash="08cf41c7cfc59c289e1b3277abfacb90"/></dir><file name="license.txt" hash="e8fb4ab53f05a8b4b7fea01d7d0df63b"/><file name="notes.txt" hash="ee78d53165c33f5025893a2695f9945e"/><dir name="sql"><dir name="attributeSplash_setup"><file name="mysql4-upgrade-1.9.5-1.9.6.php" hash="87dd0800165a9ee687ce4d1f37f8bd45"/><file name="mysql4-upgrade-2.0.1-2.0.2.php" hash="30648850f5fe5d872b87073521b0fb0b"/><file name="mysql4-upgrade-2.0.12-2.0.13.php" hash="44e236b5c00275822f2766fb3aade050"/><file name="mysql4-upgrade-2.0.5-2.0.6.php" hash="faf4d7ec465632381368434253a7dc62"/><file name="mysql4-upgrade-2.0.6-2.0.7.php" hash="766e934cfeb6e4c3a55690ed1beb13b7"/><file name="mysql4-upgrade-2.0.8-2.0.9.php" hash="b78dc758c2d8f11eb80e31652f92b317"/><file name="mysql4-upgrade-2.0.9-2.0.10.php" hash="6185c7fb4faf6fcd95cd0365fe0b5e03"/><file name="mysql4-upgrade-2.2.0.5-2.2.0.6.php" hash="9abf789a0889edb189cee65e6d4a128d"/><file name="mysql4-upgrade-2.2.0.7-2.2.0.8.php" hash="83cb47a19873315987be7811d9ace297"/><file name="mysql4-upgrade-2.2.0.8-2.2.0.9.php" hash="4c3c9829a93e902700f1ed835b60c521"/><file name="mysql4-upgrade-2.2.1.0-2.2.1.1.php" hash="ccc977f076d9e2aef34a2aa02e3212b3"/><file name="mysql4-upgrade-2.2.1.1-2.2.1.2.php" hash="8ab5b8f8e3ddd7634668b0311414b3b2"/><file name="mysql4-upgrade-3.0.1.10-3.0.1.11.php" hash="687d031221740324a60fccb26fd12fea"/><file name="mysql4-upgrade-3.0.1.9-3.0.1.10.php" hash="8fcb189115b17e39a288ba8df70a4e28"/><file name="mysql4-upgrade-3.0.4.0-3.0.5.0.php" hash="5ee9cd2cb04000b95a59163c1eddbda7"/><file name="mysql4-upgrade-3.1.1.0-3.1.2.0.php" hash="6ea402356d9faa250d5231725f8944b1"/><file name="mysql4-upgrade-3.3.3.0-3.3.4.0.php" hash="6c9a6300d3ce739aa985340194d13d96"/><file name="mysql4-upgrade-3.3.6.2-3.3.6.3.php" hash="003475ce5b5f3495a4433b827f3d54cb"/><file name="mysql4-upgrade-3.3.8.11-3.3.8.12.php" hash="1518d10ebed9cfabec1ef7bb9acf220f"/><file name="mysql4-upgrade-3.3.8.15-3.3.8.16.php" hash="6c9a6300d3ce739aa985340194d13d96"/><file name="mysql4-upgrade-3.3.8.19-3.3.8.20.php" hash="6c9a6300d3ce739aa985340194d13d96"/><file name="mysql4-upgrade-3.3.9.2-3.3.9.3.php" hash="bb6b66397ffde0bf8568c624782d6c0f"/></dir></dir></dir></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file name="attribute-splash.xml" hash="d7a57972d4a657c1d9acf77dade557c9"/></dir></dir></dir></dir><dir name="frontend"><dir name="base"><dir name="default"><dir name="layout"><file name="attribute-splash.xml" hash="53384dd50dff358dd73ce8ce9f8e1c5a"/></dir><dir name="template"><dir name="attribute-splash"><dir><dir name="group"><file name="view.phtml" hash="d4f3be1b65ed5d209a116153822c43ba"/></dir><dir name="page"><file name="view.phtml" hash="7cf47164bc5d140de566294a93942677"/></dir></dir></dir></dir></dir></dir></dir></target><target name="mage"><dir name="app"><dir name="etc"><dir name="modules"><file name="Fishpig_AttributeSplash.xml" hash="80fa9d54cefcd44305240d05508a56ee"/></dir></dir></dir></target><target name="mageskin"><dir name="frontend"><dir name="base"><dir name="default"><dir name="css"><file name="attribute-splash.css" hash="c3b1103f0174a7b17496aaf75a2b4e78"/></dir></dir></dir></dir></target></contents>
|
16 |
<compatible/>
|
17 |
<dependencies><required><php><min>5.2.0</min><max>8.0.0</max></php></required></dependencies>
|
18 |
</package>
|