[geeklog-cvs] Geeklog-1.x/sql/updates mysql_1.4.1_to_1.4.2.php, 1.16, 1.17

[Oliver]

Update of /usr/home/geeklog2/cvsroot/geeklog/Geeklog-1.x/sql/updates
In directory qs1489.pair.com:/tmp/cvs-serv37796

Modified Files:
	mysql_1.4.1_to_1.4.2.php 
Log Message:
comments for static pages, upgrade code

Index: mysql_1.4.1_to_1.4.2.php
===================================================================
RCS file: /usr/home/geeklog2/cvsroot/geeklog/Geeklog-1.x/sql/updates/mysql_1.4.1_to_1.4.2.php,v
retrieving revision 1.16
retrieving revision 1.17
diff -C2 -d -r1.16 -r1.17
*** mysql_1.4.1_to_1.4.2.php	28 Jul 2007 20:32:16 -0000	1.16
--- mysql_1.4.1_to_1.4.2.php	9 Aug 2007 08:09:45 -0000	1.17
***************
*** 72,74 ****
--- 72,93 ----
  }
  
+ function upgrade_StaticpagesPlugin()
+ {
+     global $_TABLES;
+ 
+     // Polls plugin updates
+     $check_sql = "SELECT pi_name FROM {$_TABLES['plugins']} WHERE pi_name = 'staticpages';";
+     $check_rst = DB_query ($check_sql);
+     if (DB_numRows($check_rst) == 1) {
+         $P_SQL = array();
+         $P_SQL[] = "ALTER TABLE `{$_TABLES['staticpage']}` ADD commentcode tinyint(4) NOT NULL default '0' AFTER sp_label";
+ 
+         $P_SQL = INST_checkInnodbUpgrade($P_SQL);
+         for ($i = 0; $i < count ($P_SQL); $i++) {
+             DB_query (current ($P_SQL));
+             next ($P_SQL);
+         }
+     }
+ }
+ 
  ?>