PHP Website::getDBHandle方法代碼示例

 public function __construct()
 {
     foreach (Website::getDBHandle()->query('SELECT * FROM ' . Website::getDBHandle()->tableName('groups')) as $group) {
         $groupData = array();
         $groupData['id'] = $group['id'];
         $groupData['name'] = $group['name'];
         $this->groups[$groupData['id']] = new Group($groupData);
     }
 }

 public function __toString()
 {
     $table = '';
     $name = Website::getDBHandle()->fieldName($this->name);
     if (!empty($this->table)) {
         $table = Website::getDBHandle()->tableName($this->table) . '.';
     }
     return $table . $name;
 }

 public function getDatabaseHandler()
 {
     /* CUSTOM VERSION, FASTER, BUT IT IS POSSIBLE TO SHOW DATABASE PASSWORD WHEN ERROR OCCUR
     	CAN BE INTERESTING IF YOU EXECUTE 1000 OR 10.000 SQL QUERIES PER PAGE, FOR NORMAL USEAGE NOT NEEDED
     		if(!isset($this->SQL))
     			$this->SQL = Website::getDBHandle();
     
     		return $this->SQL;
     */
     return Website::getDBHandle();
 }

 public function __toString()
 {
     if ($this->leftSide instanceof SQL_Field or $this->leftSide instanceof SQL_Filter) {
         $ret = $this->leftSide->__toString();
     } else {
         $ret = Website::getDBHandle()->quote($this->leftSide);
     }
     $ret .= $this->filterType;
     if ($this->rightSide instanceof SQL_Field or $this->rightSide instanceof SQL_Filter) {
         $ret .= $this->rightSide->__toString();
     } else {
         $ret .= Website::getDBHandle()->quote($this->rightSide);
     }
     if ($this->bracket) {
         return '(' . $ret . ')';
     } else {
         return $ret;
     }
 }

         Website::getDBHandle()->setDatabaseName(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_DATABASE));
     } else {
         new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_DATABASE . '</b> in server config file.');
     }
     if (Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_USER)) {
         Website::getDBHandle()->setDatabaseUsername(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_USER));
     } else {
         new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_USER . '</b> in server config file.');
     }
     if (Website::getServerConfig()->isSetKey(SERVERCONFIG_SQL_PASS)) {
         Website::getDBHandle()->setDatabasePassword(Website::getServerConfig()->getValue(SERVERCONFIG_SQL_PASS));
     } else {
         new Error_Critic('#E-7', 'There is no key <b>' . SERVERCONFIG_SQL_PASS . '</b> in server config file.');
     }
     Website::updatePasswordEncryption();
     $SQL = Website::getDBHandle();
 }
 if ($step == 'start') {
     echo '<h1>STEP ' . $step . '</h1>Informations<br>';
     echo 'Welcome to Gesior Account Maker installer. <b>After 5 simple steps account maker will be ready to use!</b><br />';
     // check access to write files
     $writeable = array('config/config.php', 'cache', 'cache/flags', 'cache/DONT_EDIT_usercounter.txt', 'cache/DONT_EDIT_serverstatus.txt', 'custom_scripts', 'install.txt');
     foreach ($writeable as $fileToWrite) {
         if (is_writable($fileToWrite)) {
             echo '<span style="color:green">CAN WRITE TO FILE: <b>' . $fileToWrite . '</b></span><br />';
         } else {
             echo '<span style="color:red">CANNOT WRITE TO FILE: <b>' . $fileToWrite . '</b> - edit file access for PHP [on linux: chmod]</span><br />';
         }
     }
 } elseif ($step == 1) {
     if (isset($_REQUEST['server_path'])) {

error_reporting(E_ALL ^ E_STRICT ^ E_NOTICE);
// true = show sent queries and SQL queries status/status code/error message
define('DEBUG_DATABASE', false);
define('INITIALIZED', true);
// if not defined before, set 'false' to load all normal
if (!defined('ONLY_PAGE')) {
    define('ONLY_PAGE', false);
}
// check if site is disabled/requires installation
include_once './system/load.loadCheck.php';
// fix user data, load config, enable class auto loader
include_once './system/load.init.php';
// DATABASE
include_once './system/load.database.php';
if (DEBUG_DATABASE) {
    Website::getDBHandle()->setPrintQueries(true);
}
// DATABASE END
// LOGIN
if (!ONLY_PAGE) {
    include_once './system/load.login.php';
}
// LOGIN END
// COMPAT
// some parts in that file can be blocked because of ONLY_PAGE constant
include_once './system/load.compat.php';
// COMPAT END
// LOAD PAGE
include_once './system/load.page.php';
// LOAD PAGE END
// LAYOUT

 public static function isPlayerOnline($playerID)
 {
     if (!isset(self::$onlineList)) {
         self::$onlineList = array();
         $onlines = Website::getDBHandle()->query('SELECT ' . Website::getDBHandle()->fieldName('player_id') . ' FROM ' . Website::getDBHandle()->tableName('players_online'))->fetchAll();
         foreach ($onlines as $online) {
             self::$onlineList[$online['player_id']] = $online['player_id'];
         }
     }
     return isset(self::$onlineList[$playerID]);
 }