[Phpfreechat-svn] SF.net SVN: phpfreechat: [1085] trunk/src/containers/mysql.class.php

[<ke...@us...>]

Revision: 1085
          http://phpfreechat.svn.sourceforge.net/phpfreechat/?rev=1085&view=rev
Author:   kerphi
Date:     2007-08-06 06:12:26 -0700 (Mon, 06 Aug 2007)

Log Message:
-----------
Optimize the setMeta method in the mysql container

Modified Paths:
--------------
    trunk/src/containers/mysql.class.php

Modified: trunk/src/containers/mysql.class.php
===================================================================
--- trunk/src/containers/mysql.class.php	2007-08-05 01:26:12 UTC (rev 1084)
+++ trunk/src/containers/mysql.class.php	2007-08-06 13:12:26 UTC (rev 1085)
@@ -165,12 +165,13 @@
 
     if ($leafvalue == NULL){$leafvalue="";};
     
-    $sql_select = "SELECT * FROM ".$c->container_cfg_mysql_table." WHERE `server`='$server' AND `group`='$group' AND `subgroup`='$subgroup' AND `leaf`='$leaf'";
+    $sql_count = "SELECT COUNT(*) AS C FROM ".$c->container_cfg_mysql_table." WHERE `server`='$server' AND `group`='$group' AND `subgroup`='$subgroup' AND `leaf`='$leaf' LIMIT 1";
     $sql_insert="REPLACE INTO ".$c->container_cfg_mysql_table." (`server`, `group`, `subgroup`, `leaf`, `leafvalue`, `timestamp`) VALUES('$server', '$group', '$subgroup', '$leaf', '".addslashes($leafvalue)."', '".time()."')";
     $sql_update="UPDATE ".$c->container_cfg_mysql_table." SET `leafvalue`='".addslashes($leafvalue)."', `timestamp`='".time()."' WHERE  `server`='$server' AND `group`='$group' AND `subgroup`='$subgroup' AND `leaf`='$leaf'";
-    
-    $res = mysql_query($sql_select, $db);
-    if( !(mysql_num_rows($res)>0) )
+
+    $res = mysql_query($sql_count, $db);
+    $row = mysql_fetch_array($res, MYSQL_ASSOC);
+    if( $row['C'] == 0 )
     {
       if ($c->debug)
         file_put_contents("/tmp/debug.txt", "\nsetSQL(".$sql_insert.")", FILE_APPEND | LOCK_EX);


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