"; if($DB_TYPE == "MYSQL") { $result=mysql_query($query,$DB); if(!$result) { echo "Error in query [$query] [".mysql_error()."]"; } return $result; } if($DB_TYPE == "POSTGRESQL") { $result=pg_exec($DB,$query); return $result; } } function DBexecute($query, $skip_error_messages=0) { global $DB,$DB_TYPE; $result = FALSE; if($DB_TYPE == "MYSQL") { $result=mysql_query($query,$DB); if(!$result && $skip_error_messages==0) { error("SQL error: ".mysql_error()); error("Query: $query"); } } if($DB_TYPE == "POSTGRESQL") { $result=pg_exec($DB,$query); } //SDI("DBexecute($query) = '".$result."'"); return $result; } function DBfetch($result) { global $DB_TYPE; if($DB_TYPE == "MYSQL") { $row=mysql_fetch_array($result); return $row; } if($DB_TYPE == "POSTGRESQL") { $row=pg_fetch_array($result); return $row; } return FALSE; } function get_field($result,$rownum,$fieldnum) { global $DB_TYPE; if($DB_TYPE == "MYSQL") { mysql_data_seek($result,$rownum); $row=mysql_fetch_row($result); return $row[$fieldnum]; } if($DB_TYPE == "POSTGRESQL") { $row=pg_fetch_row($result,$rownum); if(!$row) { echo "Error getting row"; exit; } return $row[$fieldnum]; } } function DBnum_rows($result) { global $DB_TYPE; if($DB_TYPE == "MYSQL") { return mysql_num_rows($result); } if($DB_TYPE == "POSTGRESQL") { return pg_numrows($result); } return 0; } function DBinsert_id($result,$table,$field) { global $DB,$DB_TYPE; if($DB_TYPE == "MYSQL") { return mysql_insert_id($DB); } if($DB_TYPE == "POSTGRESQL") { $oid=pg_getlastoid($result); // echo "OID:$oid
"; $sql="select $field from $table where oid=$oid"; $result=DBselect($sql); return get_field($result,0,0); } } function zbx_dbstr($var) { return "'".addslashes($var)."'"; } ?>