View file modules/db.php

<?php
if(!defined('DRK'))die('Hacking attempt...');

function serveraddy()
{
if($_SERVER['SERVER_ADDR']=="127.0.0.1")return true;
else return false;
}

$databasehost="localhost";
$databaseuser="root";
$databasepass="rootwdp";
$databasename="wdv3";
ini_set("display_errors", "0");
mysql_connect($databasehost, $databaseuser, $databasepass) or
die("could not connect to the database");
mysql_select_db($databasename) or die("invalid database!!");
ini_set("display_errors", "1");

function query($rows,$table,$where="")
{
if(!empty($where))$where=" WHERE $where";
$sql=mysql_query("SELECT $rows FROM $table$where")or die(error(mysql_errno()."<br/>".mysql_error()));
return $sql;
}

function joined_query($rows,$table,$table2,$on,$where="")
{
if(!empty($where))$where=" WHERE $where";
$sql=mysql_query("SELECT $rows FROM $table a INNER JOIN $table2 b ON $on $where")or die(error(mysql_errno()."<br/>".mysql_error()));
return $sql;
}

function num_rows($rows,$table,$where="")
{
if(!empty($where))$where=" WHERE $where";
$sql=mysql_query("SELECT $rows FROM $table$where")or die(error(mysql_errno()."<br/>".mysql_error()));
return mysql_num_rows($sql);
}

function fetch_array($row,$table,$where="")
{
if(!empty($where))$where=" WHERE $where";
$sql=mysql_query("SELECT $row FROM $table$where")or die(error(mysql_errno()."<br/>".mysql_error()));
$a=mysql_fetch_array($sql);
if($row!="*")return $a["$row"];
return $a;
}

function insert($table,$set)
{
$sql=mysql_query("INSERT INTO $table VALUES ($set)")or die(error(mysql_errno()."<br/>".mysql_error()));
return $sql;
}

function update($table,$set,$where)
{
$sql=mysql_query("UPDATE $table SET $set WHERE $where")or die(error(mysql_errno()."<br/>".mysql_error()));
return $sql;
}

function delete($table,$where="")
{
if(!empty($where))$where=" WHERE $where";
$sql=mysql_query("DELETE FROM $table$where")or die(error(mysql_errno()."<br/>".mysql_error()));
return $sql;
}

function ses_table($row,$sesid){
$a=fetch_array("*",sessions,"sesid='$sesid'");
$b=$a["$row"];
return $b;
}

function users_table($row,$uid){
$a=fetch_array("*",users,"id='$uid'");
$b=$a["$row"];
return $b;
}

function profiles_table($row,$uid){
$a=fetch_array("*",userprofiles,"uid='$uid'");
$b=$a["$row"];
return $b;
}

function UserFromId($uid){
$a=fetch_array("*",users,"id='$uid'");
$b=$a["username"];
return $b;
}

function IdFromUser($user){
$a=fetch_array("*",users,"LOWER(username)=LOWER('$user')");
$b=$a["id"];
return $b;
}

function IdFromSes($ses){
$user=ses_table("username",$ses);
$a=fetch_array("*",users,"LOWER(username)=LOWER('$user')");
$b=$a["id"];
return $b;
}

function makeSelect($table,$where="",$row1="",$row2="")
{
$obj="\n";
$sql="SELECT * FROM $table";
if(!empty($where))$sql.=" WHERE $where";
$query=query("*",$table,$where);
if(mysql_num_rows($query)>0){
while($row=mysql_fetch_array($query)){
$obj.="<option value=\"$row[$row1]\">$row[$row2]</option>\n";
}
}
return $obj;
}

?>