Changeset 5424 for extensions/grum_plugins_classes-2/tables.class.inc.php

Timestamp:

Mar 28, 2010, 7:17:31 PM (15 years ago)

Author:

grum

Message:

Update the plugin for compatibility with Piwigo 2.1

File:

• extensions/grum_plugins_classes-2/tables.class.inc.php (modified) (13 diffs)

extensions/grum_plugins_classes-2/tables.class.inc.php

@@ -1 @@
-<?php 
+<?php
 
 /* -----------------------------------------------------------------------------
   class name: manage_tables
-  class version: 1.4
-  date: 2008-12-28
+  class version: 1.5
+  date: 2010-03-28
   ------------------------------------------------------------------------------
-  author: grum at grum.dnsalias.com
+  author: grum at piwigo.org
   << May the Little SpaceFrog be with you >>
   ------------------------------------------------------------------------------
-  
+
   this class provides base functions to manage tables while plugin installation
     - constructor manage_tables($tables)
@@ -31 +31 @@
                         + $resultbooelan option for return
                     + add multi_queries($queries) function
-                    + add import($filename) function 
+                    + add import($filename) function
   v1.4 - 2009-03-01 + PHP5 migration (use of public/protected/private)
                     + export => DROP TABLE IF EXISTS
                     + import => if DROP TABLE without IF EXISTS, add IF EXISTS
+  v1.5 - 2010-03-28 + Uses piwigo pwg_db_* functions instead of mysql_* functions
 
    -------------------------------------------------------------------------- */
@@ -46 +47 @@
     $this->tables = $tables;
   }
-  
-  /* 
+
+  /*
       create tables
       $tables_def is an array of SQL CREATE queries
 
-      return true if everything is ok, otherwise tablename 
+      return true if everything is ok, otherwise tablename
   */
   public function create_tables($tables_def)
@@ -71 +72 @@
   }
 
-  /* update tables definition 
+  /* update tables definition
      $tables_alteration : array of arrays
       example :
@@ -81 +82 @@
         "attribute2" => " ADD COLUMN `attribute2` text null default ''"));
 
-      return true if no error, otherwise return table.fields of error 
+      return true if no error, otherwise return table.fields of error
   */
   public function update_tables_fields($tables_alteration)
@@ -98 +99 @@
       {
         $columns=array();
-        while($row=mysql_fetch_assoc($result))
-        { 
-          array_push($columns, $row['Field']); 
+        while($row=pwg_db_fetch_assoc($result))
+        {
+          array_push($columns, $row['Field']);
         }
 
@@ -121 +122 @@
 
 
-  /* 
+  /*
       delete tables listed in $this->tables_list
   */
@@ -170 +171 @@
     if($result)
     {
-      while($row=mysql_fetch_row($result))
+      while($row=pwg_db_fetch_row($result))
       {
         if(isset($list[$row[0]]))
@@ -207 +208 @@
                   if empty, assume that all tables have to be exported
       $infos : additional info written in exported file (as comment)
-      $resultboolean : if true, result is true/false ; 
+      $resultboolean : if true, result is true/false ;
                        if false, if result, return a string with nfo about export
   */
@@ -295 +296 @@
         if($result)
         {
-          while($row=mysql_fetch_row($result))
+          while($row=pwg_db_fetch_row($result))
           {
             $text.=sprintf("%s; -- EOQ\n", $row[1]);
@@ -316 +317 @@
           {
             $tmp=array();
-            while($row=mysql_fetch_row($result))
+            while($row=pwg_db_fetch_row($result))
             {
               $tmp[]=$row[0];
@@ -323 +324 @@
           $colnames='('.implode(',', $tmp).')';
         }
-    
+
         $sql='SELECT * FROM '.$this->tables[$key];
         $result=pwg_query($sql);
         if($result)
         {
-          while($row=mysql_fetch_row($result))
+          while($row=pwg_db_fetch_row($result))
           {
             foreach($row as $key2 => $val2)
@@ -403 +404 @@
     execute multiple query
       each query have to be separated by a "-- EOQ\n"
-      
+
       $queries : sql queries
   */