[Openupload-svn-update] SF.net SVN: openupload:[132] trunk/lib/modules/db

[<ts...@us...>]

Revision: 132
          http://openupload.svn.sourceforge.net/openupload/?rev=132&view=rev
Author:   tsdogs
Date:     2008-11-07 19:09:35 +0000 (Fri, 07 Nov 2008)

Log Message:
-----------
Add database connection close

Modified Paths:
--------------
    trunk/lib/modules/db/mysql.inc.php
    trunk/lib/modules/db/pgsql.inc.php

Modified: trunk/lib/modules/db/mysql.inc.php
===================================================================
--- trunk/lib/modules/db/mysql.inc.php	2008-11-07 19:08:56 UTC (rev 131)
+++ trunk/lib/modules/db/mysql.inc.php	2008-11-07 19:09:35 UTC (rev 132)
@@ -12,12 +12,16 @@
   function init() {
   /* connect to the database */
     mysql_connect($this->config['host'],$this->config['user'],$this->config['password'])
-        or die(tr('ERROR: connection to database failed!'));
+        or die('ERROR: connection to database failed!');
 
-    $this->db = mysql_select_db($this->config['name']);// or die('ERROR: database could not be opened');
+    $this->db = mysql_select_db($this->config['name']) or die('ERROR: database could not be opened');
   }
 
 
+  function free() {
+    mysql_close();
+  }
+
   function newId($tbl,$field = 'id',$keys = array ()) {
     $sql = 'SELECT max(`'.$field.'`) as newid FROM `'.$this->prefix.$tbl.'`';
     if (count($keys)>0) {

Modified: trunk/lib/modules/db/pgsql.inc.php
===================================================================
--- trunk/lib/modules/db/pgsql.inc.php	2008-11-07 19:08:56 UTC (rev 131)
+++ trunk/lib/modules/db/pgsql.inc.php	2008-11-07 19:09:35 UTC (rev 132)
@@ -23,6 +23,10 @@
     $this->db = pg_connect($str) or die('ERROR: connection to db failed!');
   }
 
+  function free() {
+    pg_close($this->db);
+  }
+
   function newId($tbl,$field = 'id',$keys = array ()) {
     $sql = 'SELECT max("'.$field.'") as newid FROM "'.$this->prefix.$tbl.'"';
     if (count($keys)>0) {


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