X-Git-Url: https://git.defcon.no/?a=blobdiff_plain;f=api%2Flib%2Fdb_functions.php;fp=api%2Flib%2Fdb_functions.php;h=6ec0f53766dea32ae5c691619ff6a67088dfa6c4;hb=220a8d4c07bfb4cb6be8122fda7dc6ceb0d1da8f;hp=0000000000000000000000000000000000000000;hpb=e9dd114b2570a41c4f517bdee270fbc2c791de92;p=hermes

diff --git a/api/lib/db_functions.php b/api/lib/db_functions.php
new file mode 100644
index 0000000..6ec0f53
--- /dev/null
+++ b/api/lib/db_functions.php
@@ -0,0 +1,49 @@
+<?php
+require_once('config.php');
+require_once('lib/common_functions.php');
+
+function sql_dbquery( $db, $query )
+{
+	if ( ! mysql_select_db( $db ) ) return false;
+	$result = mysql_query( $query );
+	if ( !$result ) return false;
+	if (mysql_num_rows($result) == 0) return false;
+	return $result;
+}
+function sql_dbexec ( $db, $query )
+{
+	if ( ! mysql_select_db( $db ) ) return false;
+	$result = mysql_query( $query );
+	if ( !$result ) return false;
+	return $result;
+}
+function sql_dbquery_single( $db, $query )
+{
+	$result = sql_dbquery( $db, $query );
+	if ( ! $result ) return false;
+	if ( mysql_num_rows($result) != 1) return false;
+	$data = mysql_fetch_assoc( $result );
+	return $data;
+}
+function sql_dbtest_numrows ( $db, $query, $numrows )
+{
+	$result = sql_dbquery( $db, $query );
+
+	if ( ! $result ) return false;
+	if ( mysql_num_rows($result) == $numrows ) return true;
+	return false;
+}
+function sql_dbexec_rows ( $db, $query )
+{
+	if ( ! mysql_select_db( $db ) ) return false;
+	$result = mysql_query( $query );
+	if ( !$result ) return -1;
+	return mysql_affected_rows();
+}
+function sql_clean( $string )
+{
+	return addslashes( $string );
+}
+
+
+?>