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]); }