1 files changed, 62 insertions, 0 deletions
diff --git a/includes/database.inc b/includes/database.inc
new file mode 100644
index 000000000..3721fbd65
--- /dev/null
+++ b/includes/database.inc
@@ -0,0 +1,62 @@
+<?
+/*
+ * These functions build the foundation for accessing the database:
+ * it is a general database abstraction layer suitable for several
+ * databases.  Currently, the only supported database is MySQL but
+ * it should be straightforward to port it to any other database:
+ * just adjust the handlers to your needs.
+ */
+
+function db_connect() {
+  global $dbhost, $dbuname, $dbpass, $dbname;
+  mysql_pconnect($dbhost, $dbuname, $dbpass) or die(mysql_Error());
+  mysql_select_db($dbname) or die ("Unable to select database");
+   // NOTE: we are using a persistent connection!
+}
+
+function db_insert($query, $debug = false) {
+  // NOTE:
+  //   add spam- and/or flood-checks
+
+  db_query($query, $debug);
+}
+
+function db_query($query, $debug = false) {
+  ### perform query:
+  $qid = mysql_query($query);
+
+  ### debug output (if required):
+  if ($debug || empty($qid)) {
+    print "<PRE>query: ". htmlspecialchars($query) ."<BR>error message: ". mysql_error() ."</PRE>";
+  }
+ 
+  ### return result from query: 
+  return $qid;
+}
+
+function db_fetch_object($qid) {
+  if ($qid) return mysql_fetch_object($qid);
+}
+
+function db_num_rows($qid) {
+  if ($qid) return mysql_num_rows($qid);
+}
+
+function db_fetch_row($qid) {
+  if ($qid) return mysql_fetch_row($qid);
+}
+
+function db_fetch_array($qid) {
+  if ($qid) return mysql_fetch_array($qid);
+}
+
+function db_result($qid, $field) {
+  if ($qid) return mysql_result($qid, $field);
+}
+
+#
+# Automatically connect to database:
+#
+db_connect();
+
+?>
+\ No newline at end of file