/nacridan/backup/lib/adodb_lite/adodb.inc.php

<?php

/**
 * ADOdb Lite is a PHP class to encapsulate multiple database APIs and is compatible with 
 * a subset of the ADODB Command Syntax. 
 * Currently supports Frontbase, MaxDB, miniSQL, MSSQL, MSSQL Pro, MySQLi, MySQLt, MySQL, PostgresSQL,
 * PostgresSQL64, PostgresSQL7, PostgresSQL8, SqLite, SqLite Pro, Sybase and Sybase ASE.
 * 
 */
if (! defined('_ADODB_LAYER'))
    define('_ADODB_LAYER', 1);

if (! defined('ADODB_DIR'))
    define('ADODB_DIR', dirname(__FILE__));

$ADODB_vers = 'V1.12 ADOdb Lite 29 November 2005  (c) 2005 Mark Dickenson. All rights reserved. Released LGPL.';

define('ADODB_FETCH_DEFAULT', 0);
define('ADODB_FETCH_NUM', 1);
define('ADODB_FETCH_ASSOC', 2);
define('ADODB_FETCH_BOTH', 3);

GLOBAL $ADODB_FETCH_MODE;
$ADODB_FETCH_MODE = ADODB_FETCH_DEFAULT;
// DEFAULT, NUM, ASSOC or BOTH. Default follows native driver default...

/**
 * Database connection
 * Usage: $db = new ADONewConnection('dbtype');
 *
 * @access public
 * @param string $dbtype            
 */
function &ADONewConnection($dbtype = 'mysql', $modules = '')
{
    global $ADODB_FETCH_MODE;
    $false = false;
    
    @include (ADODB_DIR . '/adodb.config.php');
    
    if (strpos($dbtype, '://')) {
        $dsn_array = @parse_url(rawurldecode($dbtype));
        
        if (! $dsn_array || ! $dsn_array['scheme'])
            return $false;
        
        $dbtype = $dsn_array['scheme'];
        $modules = (! empty($dsn_array['fragment'])) ? $dsn_array['fragment'] : $modules;
    } else
        $dsn_array = array(
            'scheme' => ''
        );
    
    $dbtype = strtolower($dbtype);
    include_once ADODB_DIR . '/adodbSQL_drivers/' . $dbtype . '/' . $dbtype . '_driver.inc';
    $last_module = 'driver';
    if (! empty($modules)) {
        $module_list = explode(":", strtolower($modules));
        foreach ($module_list as $mod) {
            $mod = trim($mod);
            include_once ADODB_DIR . '/adodbSQL_drivers/' . $dbtype . '/' . $dbtype . '_' . $mod . '_module.inc';
            $last_module = $mod;
        }
        $extention = $dbtype . '_' . $last_module . '_ADOConnection';
    } else {
        $extention = $dbtype . '_' . $last_module . '_ADOConnection';
    }
    $object = new $extention();
    $object->last_module_name = $last_module;
    $object->raiseErrorFn = (defined('ADODB_ERROR_HANDLER')) ? ADODB_ERROR_HANDLER : false;
    $object->query_count = 0;
    $object->query_time_total = 0;
    
    if (! empty($dsn_array['scheme'])) {
        if (isset($dsn_array['port']))
            $object->port = $dsn_array['port'];
        $persistent = false;
        $forcenew = false;
        if (isset($dsn_array['query'])) {
            $option_array = explode('&', $dsn_array['query']);
            foreach ($option_array as $element => $value) {
                $array = explode('=', $value);
                $data = isset($array[1]) ? $array[1] : 1;
                switch (strtolower($array[0])) {
                    case 'persist':
                    case 'persistent':
                        $persistent = $data;
                        break;
                    case 'debug':
                        $object->debug = (integer) $data;
                        break;
                    case 'fetchmode':
                        $ADODB_FETCH_MODE = constant($data);
                        break;
                    case 'clientflags':
                        $object->clientFlags = $data;
                        break;
                    case 'port':
                        $object->port = $data;
                        break;
                    case 'socket':
                        $object->socket = $data;
                        break;
                    case 'forcenew':
                        $forcenew = $data;
                        break;
                }
            }
        }
        
        $dsn_array['host'] = isset($dsn_array['host']) ? $dsn_array['host'] : '';
        $dsn_array['user'] = isset($dsn_array['user']) ? $dsn_array['user'] : '';
        $dsn_array['pass'] = isset($dsn_array['pass']) ? $dsn_array['pass'] : '';
        $dsn_array['path'] = isset($dsn_array['path']) ? substr($dsn_array['path'], 1) : '';
        
        $result = $object->_connect($dsn_array['host'], $dsn_array['user'], $dsn_array['pass'], $dsn_array['path'], $persistent, $forcenew);
        
        if (! $result)
            return $false;
    }
    
    return $object;
}

/**
 * Alternative Database connection
 * Usage: $db = new NewADOConnection('dbtype');
 *
 * @access public
 * @param string $dbtype            
 */
function &NewADOConnection($dbtype = '', $module = '')
{
    $tmp = & ADONewConnection($dbtype, $module);
    return $tmp;
}

function &NewDataDictionary(&$connection, $dbtype = false)
{
    if (! $dbtype)
        $dbtype = $connection->dbtype;
    include_once ADODB_DIR . '/adodb-datadict.inc.php';
    include_once ADODB_DIR . '/adodbSQL_drivers/' . $dbtype . '/' . $dbtype . '_datadict.inc';
    
    $class = "ADODB2_$dbtype";
    $dict = new $class();
    $dict->connection = &$connection;
    $dict->upperName = strtoupper($dbtype);
    $dict->quote = $connection->nameQuote;
    $dict->debug_echo = $connection->debug_echo;
    
    return $dict;
}

class ADOConnection
{

    var $connectionId = false;

    var $record_set = false;

    var $database;

    var $dbtype;

    var $host;

    var $open;

    var $password;

    var $username;

    var $persistent;

    var $debug = false;

    var $debug_echo = true;

    var $debug_output;

    var $forcenewconnection = false;

    var $createdatabase = false;

    var $last_module_name;

    var $socket = false;

    var $port = false;

    var $clientFlags = 0;

    var $nameQuote = '"';

    var $sysDate = false;
    // / name of function that returns the current date
    var $sysTimeStamp = false;
    // / name of function that returns the current timestamp
    var $sql;

    var $raiseErrorFn = false;

    var $query_count = 0;

    var $query_time_total = 0;

    function ADOConnection()
    {}

    /**
     * Returns floating point version number of ADOdb Lite
     * Usage: $db->Version();
     *
     * @access public
     */
    function Version()
    {
        global $ADODB_vers;
        return (float) substr($ADODB_vers, 1);
    }

    /**
     * Returns true if connected to database
     * Usage: $db->IsConnected();
     *
     * @access public
     */
    function IsConnected()
    {
        if ($this->connectionId === false || $this->connectionId == false)
            return false;
        else
            return true;
    }

    /**
     * Normal Database connection
     * Usage: $result = $db->Connect('host', 'username', 'password', 'database');
     *
     * @access public
     * @param string $database            
     * @param string $host            
     * @param string $password            
     * @param string $username            
     * @param string $forcenew
     *            // private
     */
    function Connect($host = "", $username = "", $password = "", $database = "", $forcenew = false)
    {
        return $this->_connect($host, $username, $password, $database, false, $forcenew);
    }

    /**
     * Persistent Database connection
     * Usage: $result = $db->PConnect('host', 'username', 'password', 'database');
     *
     * @access public
     * @param string $database            
     * @param string $host            
     * @param string $password            
     * @param string $username            
     */
    function PConnect($host = "", $username = "", $password = "", $database = "")
    {
        return $this->_connect($host, $username, $password, $database, true, false);
    }

    /**
     * Force New Database connection
     * Usage: $result = $db->NConnect('host', 'username', 'password', 'database');
     *
     * @access public
     * @param string $database            
     * @param string $host            
     * @param string $password            
     * @param string $username            
     */
    function NConnect($host = "", $username = "", $password = "", $database = "")
    {
        return $this->_connect($host, $username, $password, $database, false, true);
    }

    /**
     * Returns SQL query and instantiates sql statement & resultset driver
     * Usage: $linkId =& $db->execute( 'SELECT * FROM foo ORDER BY id' );
     *
     * @access public
     * @param string $sql            
     * @return mixed Resource ID, Array
     */
    function &Execute($sql, $inputarr = false)
    {
        $rs = & $this->do_query($sql, - 1, - 1, $inputarr);
        return $rs;
    }

    /**
     * Returns SQL query and instantiates sql statement & resultset driver
     * Usage: $linkId =& $db->SelectLimit( 'SELECT * FROM foo ORDER BY id', $nrows, $offset );
     * $nrows and $offset are optional
     *
     * @access public
     * @param string $sql            
     * @param string $nrows            
     * @param string $offset            
     * @return mixed Resource ID, Array
     */
    function &SelectLimit($sql, $nrows = -1, $offset = -1, $inputarr = false, $secs2cache = 0)
    {
        $rs = & $this->do_query($sql, $offset, $nrows, $inputarr);
        return $rs;
    }

    /**
     * Display debug output and database error.
     *
     * @access private
     */
    function outp($text, $newline = false)
    {
        $this->debug_output = "<br>\n(" . $this->dbtype . "): " . htmlspecialchars($text) . "<br>\n Error (" . $this->ErrorNo() . '): ' . $this->ErrorMsg() . "<br>\n";
        if ($this->debug_echo)
            echo $this->debug_output;
    }
}

/**
 * Empty result record set for updates, inserts, ect
 *
 * @access private
 */
class ADORecordSet_empty
{

    var $fields = false;

    var $EOF = true;

    function MoveNext()
    {
        return;
    }

    function RecordCount()
    {
        return 0;
    }

    function FieldCount()
    {
        return 0;
    }

    function EOF()
    {
        return TRUE;
    }

    function Close()
    {
        return true;
    }
}

class ADOFieldObject
{

    var $name = '';

    var $max_length = 0;

    var $type = "";
}

?>