[fusionregistry commit] r14 - branches/dev_cache/upload/sources/components_public/fusionscripts/fusionregistry/upgrade/up...

[codesite...@google.com]

Author: registry.fusion
Date: Sun Aug 3 10:42:47 2008
New Revision: 14

Added:
branches/dev_cache/upload/sources/components_public/fusionscripts/fusionregistry/upgrade/upgrade_30005/mysql_updates.sql.php
Modified:
branches/dev_cache/upload/sources/components_public/fusionscripts/fusionregistry/upgrade/upgrade_30005/version_upgrade.php

Log:
Resolve Issue 1: Slow view item page

Added: branches/dev_cache/upload/sources/components_public/fusionscripts/fusionregistry/upgrade/upgrade_30005/mysql_updates.sql.php
==============================================================================
--- (empty file)
+++
branches/dev_cache/upload/sources/components_public/fusionscripts/fusionregistry/upgrade/upgrade_30005/mysql_updates.sql.php
Sun Aug 3 10:42:47 2008
@@ -0,0 +1,3 @@
+<?php exit(); ?>
+ALTER TABLE `ibf_registry_gallery` ADD INDEX ( `image_id` );
+ALTER TABLE `ibf_registry_gallery` ADD INDEX ( `item_id` );
\ No newline at end of file

Modified: branches/dev_cache/upload/sources/components_public/fusionscripts/fusionregistry/upgrade/upgrade_30005/version_upgrade.php
==============================================================================
---
branches/dev_cache/upload/sources/components_public/fusionscripts/fusionregistry/upgrade/upgrade_30005/version_upgrade.php (original)
+++
branches/dev_cache/upload/sources/components_public/fusionscripts/fusionregistry/upgrade/upgrade_30005/version_upgrade.php
Sun Aug 3 10:42:47 2008
@@ -78,6 +78,10 @@
{
switch( $this->ipsclass->input['kitact'] )
{
+ case 'sql':
+ $this->update_sql();
+ break;
+
case 'cleanup':
$this->do_cleanup();
break;
@@ -88,7 +92,27 @@
}
}

+ /**
+ * Run sql updates
+ */
+ function update_sql()
+ {
+ require './instagrade/sql_importer.php';
+
+ $sql_importer = new sql_importer();
+ $sql_importer->ipsclass =& $this->ipsclass;
+ $sql_importer->auto_run();

+ $executed = 0;
+
+ // First install our new tables
+ if ( file_exists( './upgrade_' .
$this->instagrade->current_upgrade . '/mysql_updates.sql.php' ) )
+ {
+ $executed = $sql_importer->execute_sql_file('./upgrade_' . $this->instagrade->current_upgrade . '/mysql_updates.sql.php');
+ }
+
+ $this->instagrade->redirect(
$this->base_url."&kitact=cleanup", "SQL updates complete, $executed
queries run...." );
+ }

/**
* Only thing we need to do is update the DB version
@@ -130,7 +154,7 @@
This upgrade kit will upgrade you from
<b>"{$this->instagrade->version_history[$this->upgrade_from]}"</b> to <b>"{$this->instagrade->version_history[$this->this_version]}"</b>
<br />
<br />
-<div align='center'><a href="{$this->base_url}&kitact=cleanup"
class='button' style='color: #003366'>Continue >></a></div>
+<div align='center'><a href="{$this->base_url}&kitact=sql"
class='button' style='color: #003366'>Continue >></a></div>
<br />
<br />
<div align='center'>Upgrade kits still to run after this upgrade: {$this->mod_to_run}</div>