diff options
| author | Silvio Rhatto <rhatto@riseup.net> | 2023-08-30 20:14:54 -0300 | 
|---|---|---|
| committer | Silvio Rhatto <rhatto@riseup.net> | 2023-08-30 20:14:54 -0300 | 
| commit | 46e32815aaad22553cf3001a797efb8d1bf7a3f3 (patch) | |
| tree | 2f01eff8b93ca2fff456cfc2c5881850d0a25dc7 /src/SemanticScuttle/db | |
| parent | dd5335583618235ec9df212f0c3a80277955dc7d (diff) | |
| parent | 01ebd549e71c82f3df2a7663255001b7c5521aca (diff) | |
| download | semanticscuttle-46e32815aaad22553cf3001a797efb8d1bf7a3f3.tar.gz semanticscuttle-46e32815aaad22553cf3001a797efb8d1bf7a3f3.tar.bz2 | |
Merge branch 'master' into develop
Diffstat (limited to 'src/SemanticScuttle/db')
| -rw-r--r-- | src/SemanticScuttle/db/db2.php | 4 | ||||
| -rw-r--r-- | src/SemanticScuttle/db/mssql-odbc.php | 6 | ||||
| -rw-r--r-- | src/SemanticScuttle/db/mssql.php | 8 | ||||
| -rw-r--r-- | src/SemanticScuttle/db/mysql.php | 12 | ||||
| -rw-r--r-- | src/SemanticScuttle/db/mysql4.php | 12 | ||||
| -rw-r--r-- | src/SemanticScuttle/db/mysqli.php | 14 | ||||
| -rw-r--r-- | src/SemanticScuttle/db/oracle.php | 4 | ||||
| -rw-r--r-- | src/SemanticScuttle/db/postgres.php | 10 | ||||
| -rw-r--r-- | src/SemanticScuttle/db/sqlite.php | 4 | 
9 files changed, 37 insertions, 37 deletions
| diff --git a/src/SemanticScuttle/db/db2.php b/src/SemanticScuttle/db/db2.php index b1abf1a..117ecae 100644 --- a/src/SemanticScuttle/db/db2.php +++ b/src/SemanticScuttle/db/db2.php @@ -36,7 +36,7 @@ class sql_db  	//  	// Constructor  	// -	function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency = true) +	function __construct($sqlserver, $sqluser, $sqlpassword, $database, $persistency = true)  	{  		$this->persistency = $persistency;  		$this->user = $sqluser; @@ -414,4 +414,4 @@ class sql_db  } // if ... define -?>
\ No newline at end of file +?> diff --git a/src/SemanticScuttle/db/mssql-odbc.php b/src/SemanticScuttle/db/mssql-odbc.php index a2d3d02..f8b7db3 100644 --- a/src/SemanticScuttle/db/mssql-odbc.php +++ b/src/SemanticScuttle/db/mssql-odbc.php @@ -184,7 +184,7 @@ class sql_db  	function _odbc_execute_query($query)  	{  		$result = false; -		 +  		if (eregi("^SELECT ", $query))  		{  			$result = @odbc_exec($this->db_connect_id, $query);  @@ -459,7 +459,7 @@ class sql_db  			{  				$this->sql_transaction('rollback');  			} -			 +  			trigger_error($message, E_USER_ERROR);  		} @@ -573,4 +573,4 @@ class sql_db  } // if ... define -?>
\ No newline at end of file +?> diff --git a/src/SemanticScuttle/db/mssql.php b/src/SemanticScuttle/db/mssql.php index 2b17b9e..8358d27 100644 --- a/src/SemanticScuttle/db/mssql.php +++ b/src/SemanticScuttle/db/mssql.php @@ -134,7 +134,7 @@ class sql_db  			if (!$this->query_result)  			{  				$this->num_queries++; -				 +  				if (($this->query_result = @mssql_query($query, $this->db_connect_id)) === false)  				{  					$this->sql_error($query); @@ -285,7 +285,7 @@ class sql_db  		}  		$row = @mssql_fetch_array($query_id, MSSQL_ASSOC); -		 +  		if ($row)  		{  			foreach ($row as $key => $value) @@ -431,7 +431,7 @@ class sql_db  			{  				$this->sql_transaction('rollback');  			} -			 +  			trigger_error($message, E_USER_ERROR);  		} @@ -548,4 +548,4 @@ class sql_db  } // if ... define -?>
\ No newline at end of file +?> diff --git a/src/SemanticScuttle/db/mysql.php b/src/SemanticScuttle/db/mysql.php index a646e0d..88b59d8 100644 --- a/src/SemanticScuttle/db/mysql.php +++ b/src/SemanticScuttle/db/mysql.php @@ -94,7 +94,7 @@ class sql_db  			case 'commit':  				$result = @mysql_query('COMMIT', $this->db_connect_id);  				$this->transaction = false; -				 +  				if (!$result)  				{  					@mysql_query('ROLLBACK', $this->db_connect_id); @@ -291,7 +291,7 @@ class sql_db  			}  			return $result;  		} -		 +  		return false;  	} @@ -372,7 +372,7 @@ class sql_db  			return mysql_escape_string($msg);  		}		  	} -	 +  	function sql_error($sql = '')  	{  		if (!$this->return_on_error) @@ -386,7 +386,7 @@ class sql_db  			{  				$this->sql_transaction('rollback');  			} -			 +  			trigger_error($message, E_USER_ERROR);  		} @@ -463,7 +463,7 @@ class sql_db  							{  								$html_table = TRUE;  								$html_hold .= '<table class="bg" width="100%" cellspacing="1" cellpadding="4" border="0" align="center"><tr>'; -								 +  								foreach (array_keys($row) as $val)  								{  									$html_hold .= '<th nowrap="nowrap">' . (($val) ? ucwords(str_replace('_', ' ', $val)) : ' ') . '</th>'; @@ -549,4 +549,4 @@ class sql_db  } // if ... define -?>
\ No newline at end of file +?> diff --git a/src/SemanticScuttle/db/mysql4.php b/src/SemanticScuttle/db/mysql4.php index 0639518..c13bcbd 100644 --- a/src/SemanticScuttle/db/mysql4.php +++ b/src/SemanticScuttle/db/mysql4.php @@ -94,7 +94,7 @@ class sql_db  			case 'commit':  				$result = @mysql_query('COMMIT', $this->db_connect_id);  				$this->transaction = false; -				 +  				if (!$result)  				{  					@mysql_query('ROLLBACK', $this->db_connect_id); @@ -291,7 +291,7 @@ class sql_db  			}  			return $result;  		} -		 +  		return false;  	} @@ -372,7 +372,7 @@ class sql_db  			return mysql_escape_string($msg);  		}		  	} -	 +  	function sql_error($sql = '')  	{  		if (!$this->return_on_error) @@ -386,7 +386,7 @@ class sql_db  			{  				$this->sql_transaction('rollback');  			} -			 +  			trigger_error($message, E_USER_ERROR);  		} @@ -463,7 +463,7 @@ class sql_db  							{  								$html_table = TRUE;  								$html_hold .= '<table class="bg" width="100%" cellspacing="1" cellpadding="4" border="0" align="center"><tr>'; -								 +  								foreach (array_keys($row) as $val)  								{  									$html_hold .= '<th nowrap="nowrap">' . (($val) ? ucwords(str_replace('_', ' ', $val)) : ' ') . '</th>'; @@ -549,4 +549,4 @@ class sql_db  } // if ... define -?>
\ No newline at end of file +?> diff --git a/src/SemanticScuttle/db/mysqli.php b/src/SemanticScuttle/db/mysqli.php index 9a2709a..fcff848 100644 --- a/src/SemanticScuttle/db/mysqli.php +++ b/src/SemanticScuttle/db/mysqli.php @@ -129,7 +129,7 @@ class sql_db  			}  			$this->query_result = ($cache_ttl && method_exists($cache, 'sql_load')) ? $cache->sql_load($query) : false; -			 +  			if (!$this->query_result)  			{  				$this->num_queries++; @@ -286,7 +286,7 @@ class sql_db  			unset($this->rowset[$cur_index]);  			unset($this->row[$cur_index]); -			 +  			$result = array();  			while ($this->rowset[$cur_index] = $this->sql_fetchrow($query_id))  			{ @@ -316,7 +316,7 @@ class sql_db  			else  			{  				$cur_index = (is_object($query_id)) ? $query_id->cur_index : $query_id; -	 +  				if (empty($this->row[$cur_index]) && empty($this->rowset[$cur_index]))  				{  					if ($this->row[$cur_index] = $this->sql_fetchrow($query_id)) @@ -382,7 +382,7 @@ class sql_db  	function sql_escape($msg) {  		return mysqli_real_escape_string($this->db_connect_id, $msg);  	} -	 +  	function sql_error($sql = '')  	{  		if (!$this->return_on_error) @@ -396,7 +396,7 @@ class sql_db  			{  				$this->sql_transaction('rollback');  			} -			 +  			trigger_error($message, E_USER_ERROR);  		} @@ -473,7 +473,7 @@ class sql_db  							{  								$html_table = TRUE;  								$html_hold .= '<table class="bg" width="100%" cellspacing="1" cellpadding="4" border="0" align="center"><tr>'; -								 +  								foreach (array_keys($row) as $val)  								{  									$html_hold .= '<th nowrap="nowrap">' . (($val) ? ucwords(str_replace('_', ' ', $val)) : ' ') . '</th>'; @@ -559,4 +559,4 @@ class sql_db  } // if ... define -?>
\ No newline at end of file +?> diff --git a/src/SemanticScuttle/db/oracle.php b/src/SemanticScuttle/db/oracle.php index 7ef10e5..8b983d3 100644 --- a/src/SemanticScuttle/db/oracle.php +++ b/src/SemanticScuttle/db/oracle.php @@ -34,7 +34,7 @@ class sql_db  	//  	// Constructor  	// -	function sql_db($sqlserver, $sqluser, $sqlpassword, $database="", $persistency = true) +	function __construct($sqlserver, $sqluser, $sqlpassword, $database="", $persistency = true)  	{  		$this->persistency = $persistency;  		$this->user = $sqluser; @@ -465,4 +465,4 @@ class sql_db  } // if ... define -?>
\ No newline at end of file +?> diff --git a/src/SemanticScuttle/db/postgres.php b/src/SemanticScuttle/db/postgres.php index b5bad20..2085359 100644 --- a/src/SemanticScuttle/db/postgres.php +++ b/src/SemanticScuttle/db/postgres.php @@ -58,7 +58,7 @@ class sql_db  				{  					$this->connect_string .= "host=$sqlserver ";  				} -			 +  				if ($port)  				{  					$this->connect_string .= "port=$port "; @@ -152,7 +152,7 @@ class sql_db  			}  			$this->query_result = ($cache_ttl && method_exists($cache, 'sql_load')) ? $cache->sql_load($query) : false; -			 +  			if (!$this->query_result)  			{  				$this->num_queries++; @@ -308,7 +308,7 @@ class sql_db  		}  		$result = @pg_fetch_array($query_id, NULL, PGSQL_ASSOC); -		 +  		if ($result)  		{  			$this->rownum[$query_id]++; @@ -477,7 +477,7 @@ class sql_db  			{  				$this->sql_transaction('rollback');  			} -			 +  			trigger_error($message, E_USER_ERROR);  		} @@ -594,4 +594,4 @@ class sql_db  } // if ... defined -?>
\ No newline at end of file +?> diff --git a/src/SemanticScuttle/db/sqlite.php b/src/SemanticScuttle/db/sqlite.php index 1591396..64d4371 100644 --- a/src/SemanticScuttle/db/sqlite.php +++ b/src/SemanticScuttle/db/sqlite.php @@ -368,7 +368,7 @@ class sql_db  			{  				$this->sql_transaction('rollback');  			} -			 +  			trigger_error($message, E_USER_ERROR);  		} @@ -384,4 +384,4 @@ class sql_db  } // if ... define -?>
\ No newline at end of file +?> | 
