database.php

<?php

class database_connect
{

    var $db_connect_id;
    var $query_result;

    function database_connect( $sqlserver, $sqluser, $sqlpassword, $database )
    {
        $this->user = $sqluser;
        $this->password = $sqlpassword;
        $this->server = $sqlserver;
        $this->dbname = $database;
        $this->db_connect_id = @mysql_connect( $this->server, $this->user, $this->password );
        if ( $this->db_connect_id )
        {
            if ( $database != "" )
            {
                $this->dbname = $database;
                $dbselect = @mysql_select_db( $this->dbname );
                if ( !$dbselect )
                {
                    @mysql_close( $this->db_connect_id );
                    $this->db_connect_id = $dbselect;
                }
            }
            return $this->db_connect_id;
        }
        else
        {
            return false;
        }
    }

    function sql_close( )
    {
        if ( $this->db_connect_id )
        {
            if ( $this->query_result )
            {
                @mysql_free_result( $this->query_result );
            }
            $result = @mysql_close( $this->db_connect_id );
            return $result;
        }
        else
        {
            return false;
        }
    }

    function sql_query( $query = "" )
    {
        unset( $this->'query_result' );
        if ( $query != "" )
        {
            $this->query_result = @mysql_query( $query, $this->db_connect_id );
        }
        if ( $this->query_result )
        {
            unset( $this->$this->row->$this->query_result );
            return $this->query_result;
        }
        else
        {
            return false;
        }
    }

    function sql_numrows( $query_id = 0 )
    {
        if ( $query_id )
        {
            $query_id = $this->query_result;
        }
        if ( $query_id )
        {
            $result = @mysql_num_rows( $query_id );
            return $result;
        }
        else
        {
            return false;
        }
    }

    function sql_fetchrow( $query_id = 0 )
    {
        if ( !$query_id )
        {
            $query_id = $this->query_result;
        }
        if ( $query_id )
        {
            $this->row[$query_id] = @mysql_fetch_array( $query_id );
            return $this->row[$query_id];
        }
        else
        {
            return false;
        }
    }

    function sql_nextid( )
    {
        if ( $this->db_connect_id )
        {
            $result = @mysql_insert_id( $this->db_connect_id );
            return $result;
        }
        else
        {
            return false;
        }
    }

    function sql_error( $query_id = 0 )
    {
        return mysql_error( $this->db_connect_id );
    }

}

function table_exists( $tablename )
{
    global $db;
    global $prefix;
    $query = $db->sql_query( "SHOW TABLES LIKE '{$tablename}'" );
    if ( 0 < $db->sql_numrows( $query ) )
    {
        return true;
    }
    else
    {
        return false;
    }
}

if ( !defined( "_INDEX_" ) )
{
    exit( "You can't access this file directly!" );
}
if ( file_exists( "../config.php" ) )
{
    include( "../config.php" );
    if ( isset( $dbhost ) && $dbhost != "" && isset( $dbuname ) && $dbuname != "" && isset( $dbpass ) && $dbpass != "" && isset( $dbname ) && $dbname != "" && isset( $prefix ) && isset( $dbtype ) && $dbtype != "" )
    {
        define( "FORUMTYPE", "phpnuke" );
        $database_host = $dbhost;
        $database_user = $dbuname;
        $database_password = $dbpass;
        $database_name = $dbname;
    }
    else if ( isset( $dbhost ) && $dbhost != "" && isset( $dbuser ) && $dbuser != "" && isset( $dbpasswd ) && $dbpasswd != "" && isset( $dbname ) && $dbname != "" && isset( $table_prefix ) && isset( $dbms ) && $dbms != "" && !isset( $acm_type ) )
    {
        define( "FORUMTYPE", "phpbb2" );
        $database_host = $dbhost;
        $database_user = $dbuser;
        $database_password = $dbpasswd;
        $database_name = $dbname;
        $prefix = $table_prefix;
    }
    else if ( isset( $dbhost ) && $dbhost != "" && isset( $dbuser ) && $dbuser != "" && isset( $dbpasswd ) && $dbpasswd != "" && isset( $dbname ) && $dbname != "" && isset( $table_prefix ) && isset( $dbms ) && $dbms != "" && isset( $acm_type ) )
    {
        define( "FORUMTYPE", "phpbb3" );
        $database_host = $dbhost;
        $database_user = $dbuser;
        $database_password = $dbpasswd;
        $database_name = $dbname;
        $prefix = $table_prefix;
    }
    else
    {
        exit( ":: Error - Unable to load PHPBB/PHPNUKE configuration file data." );
    }
}
else if ( file_exists( "../includes/config.php" ) )
{
    include( "../includes/config.php" );
    if ( isset( $config['MasterServer']['servername'] ) && $config['MasterServer']['servername'] != "" && isset( $config['MasterServer']['username'] ) && $config['MasterServer']['username'] != "" && isset( $config['MasterServer']['password'] ) && $config['MasterServer']['password'] != "" && isset( $config['Database']['dbname'] ) && $config['Database']['dbname'] != "" && isset( $config['Database']['tableprefix'] ) && isset( $config['Database']['dbtype'] ) && $config['Database']['dbtype'] != "" )
    {
        define( "FORUMTYPE", "vbulletin" );
        $database_host = $config['MasterServer']['servername'];
        $database_user = $config['MasterServer']['username'];
        $database_password = $config['MasterServer']['password'];
        $database_name = $config['Database']['dbname'];
        $prefix = $config['Database']['tableprefix'];
    }
    else
    {
        exit( ":: Error - Unable to load VBulletin3 configuration file data." );
    }
}
else if ( file_exists( "../Settings.php" ) )
{
    include( "../Settings.php" );
    if ( isset( $db_server ) && $db_server != "" && isset( $db_user ) && $db_user != "" && isset( $db_passwd ) && $db_passwd != "" && isset( $db_name ) && $db_name != "" && isset( $db_prefix ) )
    {
        define( "FORUMTYPE", "smf" );
        $database_host = $db_server;
        $database_user = $db_user;
        $database_password = $db_passwd;
        $database_name = $db_name;
        $prefix = $db_prefix;
    }
    else
    {
        exit( ":: Error - Unable to load SMF Forum configuration file data." );
    }
}
else if ( file_exists( "../conf_global.php" ) )
{
    include( "../conf_global.php" );
    if ( isset( $INFO['sql_host'] ) && $INFO['sql_host'] != "" && isset( $INFO['sql_user'] ) && $INFO['sql_user'] != "" && isset( $INFO['sql_pass'] ) && $INFO['sql_pass'] != "" && isset( $INFO['sql_database'] ) && $INFO['sql_database'] != "" && isset( $INFO['sql_tbl_prefix'] ) )
    {
        define( "FORUMTYPE", "ipb" );
        $database_host = $INFO['sql_host'];
        $database_user = $INFO['sql_user'];
        $database_password = $INFO['sql_pass'];
        $database_name = $INFO['sql_database'];
        $prefix = $INFO['sql_tbl_prefix'];
    }
    else
    {
        exit( ":: Error - Unable to load IPB configuration file data." );
    }
}
else
{
    exit( "<b>::</b> Database configuration file does not exist. Please ensure script files are uploaded to the correct path." );
}
database_connect( $database_host, $database_user, $database_password, $database_name, false );
$db = new database_connect( );
?>