[xoops-svn] SF.net SVN: xoops:[8949] XoopsCore/branches/2.5.x/2.5.5

[<ma...@us...>]

Revision: 8949
          http://xoops.svn.sourceforge.net/xoops/?rev=8949&view=rev
Author:   mageg
Date:     2012-02-13 10:28:25 +0000 (Mon, 13 Feb 2012)
Log Message:
-----------
Fixed bug ID: 3201929

Modified Paths:
--------------
    XoopsCore/branches/2.5.x/2.5.5/htdocs/install/sql/mysql.structure.sql
    XoopsCore/branches/2.5.x/2.5.5/upgrade/upd-2.5.4-to-2.5.5/index.php

Modified: XoopsCore/branches/2.5.x/2.5.5/htdocs/install/sql/mysql.structure.sql
===================================================================
--- XoopsCore/branches/2.5.x/2.5.5/htdocs/install/sql/mysql.structure.sql	2012-02-13 03:45:49 UTC (rev 8948)
+++ XoopsCore/branches/2.5.x/2.5.5/htdocs/install/sql/mysql.structure.sql	2012-02-13 10:28:25 UTC (rev 8949)
@@ -34,7 +34,7 @@
 CREATE TABLE banner (
   bid smallint(5) unsigned NOT NULL auto_increment,
   cid tinyint(3) unsigned NOT NULL default '0',
-  imptotal mediumint(8) unsigned NOT NULL default '0',
+  imptotal int(10) unsigned NOT NULL default '0',
   impmade mediumint(8) unsigned NOT NULL default '0',
   clicks mediumint(8) unsigned NOT NULL default '0',
   imageurl varchar(255) NOT NULL default '',

Modified: XoopsCore/branches/2.5.x/2.5.5/upgrade/upd-2.5.4-to-2.5.5/index.php
===================================================================
--- XoopsCore/branches/2.5.x/2.5.5/upgrade/upd-2.5.4-to-2.5.5/index.php	2012-02-13 03:45:49 UTC (rev 8948)
+++ XoopsCore/branches/2.5.x/2.5.5/upgrade/upd-2.5.4-to-2.5.5/index.php	2012-02-13 10:28:25 UTC (rev 8949)
@@ -26,7 +26,7 @@
 
 class upgrade_255 extends xoopsUpgrade
 {
-    var $tasks = array('keys');
+    var $tasks = array('keys','imptotal');
 
 
     /**
@@ -85,6 +85,30 @@
         }
         return true;
     }
+    
+    /**
+     * Check imptotal
+     *
+     * @return bool
+     */
+    function check_imptotal()
+    {
+        return false;
+    }
+    
+    /**
+     * Apply imptotal
+     *
+     * @return bool
+     */
+    function apply_imptotal()
+    {
+        $sql = "ALTER TABLE `" . $GLOBALS['xoopsDB']->prefix("banner") . "` CHANGE `imptotal` `imptotal` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'";
+        if (!$result = $GLOBALS['xoopsDB']->queryF($sql)) {
+            return false;
+        }
+        return true;
+    }
 
     function upgrade_255()
     {

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.