- [ZBX-283] fixes in SQL statement (Artem)

git-svn-id: svn://svn.zabbix.com/trunk@5270 97f52cf1-0a1b-0410-bd0e-c28be96e8082

1 files changed, 20 insertions, 4 deletions

diff --git a/frontends/php/include/db.inc.php b/frontends/php/include/db.inc.php
index 201f951b..c724fd3a 100644
--- a/frontends/php/include/db.inc.php
+++ b/frontends/php/include/db.inc.php
@@ -438,24 +438,40 @@
 
 /* string value prepearing */
 if(isset($DB_TYPE) && $DB_TYPE == "ORACLE") {
-	function	zbx_dbstr($var)	{
+	function zbx_dbstr($var)	{
 		return "'".ereg_replace('\'','\'\'',$var)."'";	
 	}
+	
+	function zbx_dbcast_2bigint($field){
+		return ' CAST('.$field.' AS NUMBER(20)) ';
+	}
 }
 else if(isset($DB_TYPE) && $DB_TYPE == "MYSQL") {
-	function	zbx_dbstr($var)	{
+	function zbx_dbstr($var)	{
 		return "'".mysql_real_escape_string($var)."'";
 	}
+	
+	function zbx_dbcast_2bigint($field){
+		return ' CAST('.$field.' AS UNSIGNED) ';
+	}
 }
 else if(isset($DB_TYPE) && $DB_TYPE == "POSTGRESQL") {
-	function	zbx_dbstr($var)	{
+	function zbx_dbstr($var)	{
 		return "'".pg_escape_string($var)."'";
 	}
+	
+	function zbx_dbcast_2bigint($field){
+		return ' CAST('.$field.' AS BIGINT) ';
+	}
 }
 else {			
-	function	zbx_dbstr($var)	{
+	function zbx_dbstr($var)	{
 		return "'".addslashes($var)."'";
 	}
+	
+	function zbx_dbcast_2bigint($field){
+		return ' CAST('.$field.' AS BIGINT) ';
+	}
 } 
 
 	function	zbx_dbconcat($params)