Changeset 4886 for trunk/include/dblayer/functions_pgsql.inc.php

Timestamp:

Feb 13, 2010, 10:27:42 PM (14 years ago)

Author:

nikrou

Message:

Feature 1255 : bug in pwg_session_write() with postgresql.
replace into doesn't exists. Must do two queries

File:

• trunk/include/dblayer/functions_pgsql.inc.php (modified) (1 diff)

trunk/include/dblayer/functions_pgsql.inc.php

@@ -71 +71 @@
   global $conf,$page,$debug,$t2;
 
+  $replace_pattern = '`REPLACE INTO\s(\S*)\s*([^)]*\))\s*VALUES\(([^,]*),(.*)\)\s*`mi';  
+
   $start = get_moment();
-  ($result = pg_query($query)) or die($query."\n<br>".pg_last_error());
+
+  if (preg_match($replace_pattern, $query, $matches)
+      && $matches[1]==SESSIONS_TABLE)
+  {
+    $select_query = '
+SELECT id FROM '.$matches[1].'
+  WHERE id='.$matches[3];
+    ( $result = pg_query($select_query)) or die($query."\n<br>".pg_last_error());
+    if (pwg_db_num_rows($result)==1)
+    {
+      $query = '
+UPDATE '.$matches[1].'
+  SET expiration=now()
+  WHERE id='.$matches[3];
+    }
+    else
+    {
+      $query = '
+INSERT INTO '.$matches[1].'
+  '.$matches[2].' VALUES('.$matches[3].','.$matches[4].')';
+    }
+    ( $result = pg_query($query)) or die($query."\n<br>".pg_last_error());      
+  }
+  else 
+  {
+    ($result = pg_query($query)) or die($query."\n<br>".pg_last_error());
+  }
 
   $time = get_moment() - $start;