models/CSERDmodel/CSERDModelBase.php5

<?php
abstract class CSERDModelBase extends SDatabaseModel {
    public static $DB_INFO = array(
        // XXX: replace with appropriate credentials for database
        0 => array(
            'host' => 'mysql-be.shodor.org',
            'user' => 'adm_cserd',
            'name' => 'db_cserd'
        ),
         'adm_cserd' => 'VePuGpv6' 
         //'adm_cserd' => 'saRdV7Fd' 
    );

    public static $DEPENDENCIES = array(
        'CSERDreviewSubject' => array(
            'CSERDreview' => 'reviewId',
            'CSERDsubject' => 'subjectId'
        ),
        'CSERDuserLoginLog' => array(
            'CSERDuser' => 'userId'
        ),
        'CSERDcomment' => array(
            'CSERDreview' => 'reviewId',
            'CSERDuser' => 'authorId'
        ),
        'CSERDreview' => array(
            'CSERDuser' => 'ownerId'
        ),
        'CSERDresponse' => array(
            'CSERDquestion' => 'questionId',
            'CSERDreview' => 'reviewId'
        ),
        'CSERDuserDetail' => array(
            'CSERDdetail' => 'detailId',
            'CSERDuser' => 'userId'
        ),
        'CSERDuserPageviewLog' => array(
            'CSERDuser' => 'userId'
        )
    );

    public static $REVERSE_DEPENDENCIES = array(
        'CSERDdetail' => array(
            'CSERDuserDetail' => 'detailId'
        ),
        'CSERDquestion' => array(
            'CSERDresponse' => 'questionId'
        ),
        'CSERDsubject' => array(
            'CSERDreviewSubject' => 'subjectId'
        ),
        'CSERDreview' => array(
            'CSERDreviewSubject' => 'reviewId',
            'CSERDcomment' => 'reviewId',
            'CSERDresponse' => 'reviewId'
        ),
        'CSERDuser' => array(
            'CSERDuserLoginLog' => 'userId',
            'CSERDcomment' => 'authorId',
            'CSERDreview' => 'ownerId',
            'CSERDuserDetail' => 'userId',
            'CSERDuserPageviewLog' => 'userId'
        )
    );

    public function __construct() {
        parent::__construct();

        $this->registerDBI(self::getDBI());

        // TODO: add any additional object initialization here...
    }

    public static function init($user = false, $server = false) {
        global $cserd_DB_INFO;

        if(isset($GLOBALS['cserd_DB_INFO'])) {
            self::$DB_INFO = array_merge(self::$DB_INFO, $GLOBALS['cserd_DB_INFO']);
            if(isset($GLOBALS['cserd_DB_INFO'][0])) {
                self::$DB_INFO[0] = array_merge(self::$DB_INFO[0], $GLOBALS['cserd_DB_INFO'][0]);
                unset(self::$DB_INFO[1]);
            }
        }

        if($user === false) {
            if(isset($GLOBALS['cserd_DB_USER']))
                $user = $GLOBALS['cserd_DB_USER'];
            else
                $user = self::$DB_INFO[0]['user'];
        }

        if(!isset(self::$DB_INFO[$user])) {
            self::setStaticError('Unknown database user "' . $user . '" given!');
            return false;
        }

        $pass = self::$DB_INFO[$user];

        if($server === false) {
            if(isset($GLOBALS['cserd_DB_SERVER']))
                $server = $GLOBALS['cserd_DB_SERVER'];
            else
                $server = self::$DB_INFO[0]['host'];
        }

        $name = self::$DB_INFO[0]['name'];

        new DBI2('cserd', $server, $name, $user, $pass);

        // TODO: any additional global initialization here

        return true;
    }

    public static function getDBI() {
        $dbi = DBI2::getDBI('cserd');
        if(!$dbi) {
            if(!self::init())
                return null;
            $dbi = DBI2::getDBI('cserd');
        }
        return $dbi;
    }
}

?>

---