/** * Constructor */ private function __construct() { $connection = DbSimple_Generic::connect('mysqli://' . DB_USER . ':' . DB_PASS . '@' . DB_SERVER . '/' . DB_NAME); $connection->query("SET names utf8"); $connection->setErrorHandler('dbErrorHandler'); $connection->setLogger('dbLogger'); }
public function __construct() { global $g_config; // Подключаем модули для работы с DbSimple (не по подгрузится автолоудером) $path = dirname(__FILE__) . '/DbSimple/'; require_once $path . 'Generic.php'; require_once $path . 'Mysql.php'; require_once $path . 'Postgresql.php'; require_once $path . 'my/MyDataBaseLog.php'; $dbs = $g_config['dbSimple']['databases']; // Собираем все объекты в $o $o = new stdClass(); foreach ($dbs as $db => $conn) { $dsn = $conn['dsn']; $cacheFunc = isset($conn['pCacheFunc']) ? $conn['pCacheFunc'] : NULL; $o->{$db} = DbSimple_Generic::connect($dsn); if ($g_config['dbSimple']['logDbError']) { MyDataBaseLog::SetFuncOnError(array(__CLASS__, 'DbSimpleError')); $o->{$db}->setLogger(array('MyDataBaseLog', 'Log')); $o->{$db}->setErrorHandler(array('MyDataBaseLog', 'Error')); } if ($cacheFunc) { $o->{$db}->setCacher($cacheFunc); } } // Регистрируем все базы данных как объект $g_databases $GLOBALS['g_databases'] = $o; }
public function __construct($config) { include_once "core/dbsimple/Generic.php"; $this->rDB = DbSimple_Generic::connect($config['rdb']); $this->rDB->setErrorHandler("databaseErrorHandler"); $this->rDB->query("SET NAMES ? ", $config['db_encoding']); }
function __construct() { require_once "dbsimple/config.php"; require_once "dbsimple/DbSimple/Generic.php"; require_once "data_connection.php"; $this->db = @DbSimple_Generic::connect('mysqli://' . $UserName . ':' . $Password . '@' . $ServerName . '/' . $Database); }
function __construct($file = null) { global $db_config; include_once 'dbsimple/Generic.php'; // including simple conecting for DB $this->DB = DbSimple_Generic::connect($db_config['dbc_dns']); $this->DB->setErrorHandler("databaseErrorHandler"); // $this->DB->setLogger("databaseLogHandler"); // $this->DB->setIdentPrefix($db_config['db_prefix']); $this->initDB(); if ($file == null) { return; } if ($this->file = fopen(self::$_dir . $file, "rb")) { $ex = explode('.', $file); $this->name = $ex[0]; $this->dom = new DOMDocument(); $this->dom->preserveWhiteSpace = false; $this->dom->substituteEntities = true; $xmlfile = 'xml/' . $this->name . '.xml'; if (file_exists($xmlfile)) { $this->dom->Load($xmlfile); $this->XML = $this->dom->getElementsByTagName('file')->item(0); $this->format = $this->XML->getAttribute('format'); return; } } else { $this->error = sprintf($this->_STR['FILE_NOT_EXISTS'], $file); } }
function db_connect($hostName, $userName, $dbPassword, $dbName) { // Подключаемся к БД. $dbc = DbSimple_Generic::connect('mysqli://' . $userName . ':' . $dbPassword . '@' . $hostName . '/' . $dbName); $dbc->query('set names ?', 'utf8'); return $dbc; }
/** * Initialize database & template handlers, sets up sql/site configs * @category Main system functions * @example Connector::__construct() * @return bool **/ public function __construct() { include 'configuration.php'; require_once 'libs/DbSimple/Generic.php'; require_once 'libs/Smarty-2.6.26/Smarty.class.php'; $this->mysqlconfig = $ArmoryConfig['mysql']; $this->armoryconfig = $ArmoryConfig['settings']; $this->aDB = DbSimple_Generic::connect('mysql://' . $this->mysqlconfig['user_armory'] . ':' . $this->mysqlconfig['pass_armory'] . '@' . $this->mysqlconfig['host_armory'] . '/' . $this->mysqlconfig['name_armory']); $this->cDB = DbSimple_Generic::connect('mysql://' . $this->mysqlconfig['user_characters'] . ':' . $this->mysqlconfig['pass_characters'] . '@' . $this->mysqlconfig['host_characters'] . '/' . $this->mysqlconfig['name_characters']); $this->rDB = DbSimple_Generic::connect('mysql://' . $this->mysqlconfig['user_realmd'] . ':' . $this->mysqlconfig['pass_realmd'] . '@' . $this->mysqlconfig['host_realmd'] . '/' . $this->mysqlconfig['name_realmd']); $this->wDB = DbSimple_Generic::connect('mysql://' . $this->mysqlconfig['user_mangos'] . ':' . $this->mysqlconfig['pass_mangos'] . '@' . $this->mysqlconfig['host_mangos'] . '/' . $this->mysqlconfig['name_mangos']); /* temporary disabled // Test connection if(!$this->aDB->selectCell("SELECT `id` FROM `classes` LIMIT 1")) { $this->databaseError('Can not execute query to armory database ("<i>%s</i>")!<br />Check you configuration.php for correct values.', $this->mysqlconfig['name_armory']); } if(!$this->cDB->selectCell("SELECT `guid` FROM `characters` LIMIT 1")) { $this->databaseError('Can not execute query to characters database ("<i>%s</i>")!<br />Check you configuration.php for correct values.', $this->mysqlconfig['name_characters']); } if(!$this->rDB->selectCell("SELECT `name` FROM `realmlist` LIMIT 1")) { $this->databaseError('Can not execute query to realmd database ("<i>%s</i>")!<br />Check you configuration.php for correct values.', $this->mysqlconfig['name_realmd']); } if(!$this->wDB->selectCell("SELECT `entry` FROM `item_template` LIMIT 1")) { $this->databaseError('Can not execute query to mangos database ("<i>%s</i>")!<br />Check you configuration.php for correct values.', $this->mysqlconfig['name_mangos']); } */ $this->aDB->query("SET NAMES ?", $this->mysqlconfig['charset_armory']); $this->cDB->query("SET NAMES ?", $this->mysqlconfig['charset_characters']); $this->rDB->query("SET NAMES ?", $this->mysqlconfig['charset_realmd']); $this->wDB->query("SET NAMES ?", $this->mysqlconfig['charset_mangos']); $this->tpl = new Smarty(); return true; }
function BDConnect() { $db = DbSimple_Generic::connect("mysqli://{$this->user}:{$this->pass}@{$this->host}/{$this->bd_name}"); $db->query("SET NAMES utf8"); $db->setErrorHandler('databaseErrorHandler'); $db->setLogger('myLogger'); return $db; }
public function connectDB() { // Подключаемся к БД. $db = DbSimple_Generic::connect("mysqli://{$this->db_user}:{$this->db_password}@{$this->db_host}/{$this->db_name}"); $db->query("SET NAMES utf8"); // Устанавливаем обработчик ошибок. $db->setErrorHandler('installErrorHandler'); $db->setLogger('myLogger'); return $db; }
public function __construct($ini_file_name) { if (!($ini_array = $this->get_params_from_ini_file($ini_file_name))) { echo 'Отсутствует ' . $this->ini_file_name . ' файл. Перейдите к <a href="install.php">установке</a>'; exit; } $this->db = DbSimple_Generic::connect('mysqli://' . $ini_array['UserName'] . ':' . $ini_array['Password'] . '@' . $ini_array['ServerName'] . '/' . $ini_array['Database']); $this->db->setErrorHandler('databaseErrorHandler'); $this->db->setLogger('myLogger'); }
function &connectMysql($conf) { global $config; require_once $config['root_dir'] . '/includes/dbsimple/Generic.php'; require_once $config['root_dir'] . '/includes/dbsimple/Mysql.php'; extract($conf); $database =& DbSimple_Generic::connect(array('scheme' => 'mysql', 'user' => $user, 'pass' => $pass, 'host' => $host, 'path' => $db)); $database->setErrorHandler('defaultDatabaseErrorHandler'); $database->setIdentPrefix($prefix); return $database; }
/** * Получает объект БД * * @param array $aConfig - конфиг подключения к БД(хост, логин, пароль, тип бд, имя бд) * @return DbSimple */ public function GetConnect($aConfig = null) { /** * Если конфиг не передан то используем главный конфиг БД из config.php */ if (is_null($aConfig)) { $aConfig = Config::Get('db.params'); } $sDSN = $aConfig['type'] . 'wrapper://' . $aConfig['user'] . ':' . $aConfig['pass'] . '@' . $aConfig['host'] . ':' . $aConfig['port'] . '/' . $aConfig['dbname']; /** * Создаём хеш подключения, уникальный для каждого конфига */ $sDSNKey = md5($sDSN); /** * Проверяем создавали ли уже коннект с такими параметрами подключения(DSN) */ if (isset($this->aInstance[$sDSNKey])) { return $this->aInstance[$sDSNKey]; } else { /** * Если такого коннекта еще не было то создаём его */ $oDbSimple = DbSimple_Generic::connect($sDSN); /** * Устанавливаем хук на перехват ошибок при работе с БД */ $oDbSimple->setErrorHandler('databaseErrorHandler'); /** * Если нужно логировать все SQL запросы то подключаем логгер */ if (Config::Get('sys.logs.sql_query')) { $oDbSimple->setLogger('databaseLogger'); } /** * Устанавливаем настройки соединения, по хорошему этого здесь не должно быть :) * считайте это костылём */ $oDbSimple->query("set character_set_client='utf8'"); $oDbSimple->query("set character_set_results='utf8'"); $oDbSimple->query("set collation_connection='utf8_bin'"); /** * Сохраняем коннект */ $this->aInstance[$sDSNKey] = $oDbSimple; /** * Возвращаем коннект */ return $oDbSimple; } }
private function _boot() { session_start(); ob_start(); $this->_oConfig = new Config($this->_sConfigFile); setlocale(LC_ALL, $this->config->project->locale); require_once $_SERVER['DOCUMENT_ROOT'] . $this->config->db->lib_path . '/Generic.php'; require_once $_SERVER['DOCUMENT_ROOT'] . $this->config->db->lib_path . '/Mysql.php'; $this->_oDb = \DbSimple_Generic::connect("mysql://" . $this->config->db->user . ($this->config->db->password ? ":" . $this->config->db->password : '') . "@" . $this->config->db->host . "/" . $this->config->db->database); $this->db->setIdentPrefix($this->config->db->table_prefix); $this->db->query("SET NAMES utf8"); $oRoutesConfig = new Config($_SERVER['DOCUMENT_ROOT'] . $this->config->router->path); $this->_oRequest = new Request($oRoutesConfig->routes); $this->_oView = new View($this->config->templates->path, $this->_oRequest->lang); $this->_oDirector = new Director($this->options); }
function __construct() { global $config; include_once dirname(__FILE__) . '/dbsimple/Generic.php'; $this->cDB = DbSimple_Generic::connect($config['cdb']); $this->cDB->setErrorHandler("databaseErrorHandler"); $this->cDB->query("SET NAMES ? ", $config['db_encoding']); $this->rDB = DbSimple_Generic::connect($config['rdb']); $this->rDB->setErrorHandler("databaseErrorHandler"); $this->rDB->query("SET NAMES ? ", $config['db_encoding']); $this->wDB = DbSimple_Generic::connect($config['wdb']); $this->wDB->setErrorHandler("databaseErrorHandler"); $this->wDB->query("SET NAMES ? ", $config['db_encoding']); if ($config['buildClient'] < 11723) { print "Некорректно настроен конфиг. Неизвесная сборка клиента (" . $config['buildClient'] . ")"; } }
/** * Возвращает экземпляр класса для подключения к бд * * @param string $dbAlias * @return DbSimple_Generic */ public static function get($dbAlias) { if (!isset(self::$_instances[$dbAlias])) { $db = DbSimple_Generic::connect(self::$_configs[$dbAlias]['connectUri']); if (self::$_configs[$dbAlias]['initSQL']) { $db->query(self::$_configs[$dbAlias]['initSQL']); } $db->setErrorHandler(array(__CLASS__, 'databaseErrorHandler')); $db->addIgnoreInTrace(__CLASS__ . '::databaseErrorHandler'); if (self::$_configs[$dbAlias]['debug']) { $db->setLogger(array(__CLASS__, 'databaseLogger')); $db->addIgnoreInTrace(__CLASS__ . '::databaseLogger'); } self::$_instances[$dbAlias] = $db; } return self::$_instances[$dbAlias]; }
/** * Получает объект БД * * @param array|null $aConfig - конфиг подключения к БД(хост, логин, пароль, тип бд, имя бд), если null, то используются параметры из конфига Config::Get('db.params') * @param bool $bForce Создавать принудительно новый коннект, даже если он уже существует * @return DbSimple_Generic_Database DbSimple */ public function GetConnect($aConfig = null, $bForce = false) { /** * Получаем DSN */ $sDSN = $this->GetDSNByConfig($aConfig); /** * Создаём хеш подключения, уникальный для каждого конфига */ $sDSNKey = md5($sDSN); /** * Проверяем создавали ли уже коннект с такими параметрами подключения(DSN) */ if (isset($this->aInstance[$sDSNKey]) and !$bForce) { return $this->aInstance[$sDSNKey]; } else { /** * Если такого коннекта еще не было то создаём его */ $oDbSimple = DbSimple_Generic::connect($sDSN); /** * Устанавливаем хук на перехват ошибок при работе с БД */ $oDbSimple->setErrorHandler(array($this, 'CallbackError')); /** * Если нужно логировать все SQL запросы то подключаем логгер */ if (Config::Get('sys.logs.sql_query')) { $oDbSimple->setLogger(array($this, 'CallbackQuery')); } /** * Устанавливаем настройки соединения, по хорошему этого здесь не должно быть :) * считайте это костылём */ $oDbSimple->query("set character_set_client='utf8', character_set_results='utf8', collation_connection='utf8_bin' "); /** * Сохраняем коннект */ $this->aInstance[$sDSNKey] = $oDbSimple; /** * Возвращаем коннект */ return $oDbSimple; } }
public static function connect($idx) { if (self::isConnected($idx)) { return; } $options =& self::$optionsCache[$idx]; $interface = DbSimple_Generic::connect(self::createConnectSyntax($options)); if (!$interface || $interface->error) { die('Failed to connect to database.'); } $interface->setErrorHandler(['DB', 'errorHandler']); $interface->query('SET NAMES ?', 'utf8'); if ($options['prefix']) { $interface->setIdentPrefix($options['prefix']); } self::$interfaceCache[$idx] =& $interface; self::$connectionCache[$idx] = true; }
private function __construct() { require_once "./lib/dbsimple/config.php"; require_once "./lib/dbsimple/DbSimple/Generic.php"; //проверим заполнен ли конфигурационный файл с подключением к БД в случае ошибки перенаправим на установку if (!file_get_contents('base.conf')) { header('Location: http://' . $_SERVER['HTTP_HOST'] . '/install'); exit; } $this->getConfig(); //получаем конфиг к подключению к базе данных $this->db = DbSimple_Generic::connect("mysql://{$this->_conf['user_name']}:{$this->_conf['password']}@{$this->_conf['server_name']}/{$this->_conf['database']}"); //в случае возникновения ошибки if (!empty($this->db->error)) { $this->db = $this->databaseError($this->db->error['code'], $this->db->error['message']); return $this->db; } $this->db->query("SET NAMES UTF8"); }
protected function _getDbConnect($sDsn) { if (Config::Get('db.params.lazy')) { // lazy connection //F::IncludeLib('DbSimple3/lib/DbSimple/Connect.php'); $oDbSimple = new DbSimple_Connect($sDsn); foreach ($this->aInitSql as $sSql) { $oDbSimple->addInit($sSql); } } else { // immediate connection //F::IncludeLib('DbSimple3/lib/DbSimple/Generic.php'); $oDbSimple = DbSimple_Generic::connect($sDsn); foreach ($this->aInitSql as $sSql) { $oDbSimple->query($sSql); } } return $oDbSimple; }
function initialize(IConfigParameter $configuration) { $dsn = $configuration->get('DSN'); if (!$dsn) { $connection_file = $configuration->get('connection_file'); if (!$connection_file) { throw new DbException("Connection file not defined"); } $p = pathinfo($connection_file); $dir = Project::NS()->path($p['dirname']); $f = $dir . $p['basename']; if (!file_exists($f) || !is_file($f)) { throw new DbException("Connection file not exists"); } $config = new ConfigParameter(file_get_contents($f)); $dsn = $config->get('DSN'); if (!$dsn) { throw new DbException("DSN not exitsts at connection file"); } } $this->_caching = $configuration->get('caching'); if ($configuration->get('cache_prefix')) { $this->_cache_prefix = $configuration->get('cache_prefix'); } if ($configuration->get('cache_module_id')) { $this->_cache_module_id = $configuration->get('cache_module_id'); } else { // No cache module defined // TODO:: write NOTICE to log $this->_caching = false; } $this->_DSN = $dsn; $this->_common_config($configuration); $this->_driver = DbSimple_Generic::connect($this->_DSN); if (!is_object($this->_driver)) { throw new DbException("No connection to database"); } $this->_driver->query("SET NAMES utf8"); $this->_driver->setLogger($configuration->get('native_logger')); //$this -> _driver -> setLogger('myLogger'); Project::setDatabase($this); }
public static function connect($idx) { if (self::isConnected($idx)) { return; } $options =& self::$optionsCache[$idx]; $interface = DbSimple_Generic::connect(self::createConnectSyntax($options)); if (!$interface || $interface->error) { die('Failed to connect to database.'); } $interface->setErrorHandler(['DB', 'errorHandler']); $interface->query('SET NAMES ?', 'utf8'); if ($options['prefix']) { $interface->setIdentPrefix($options['prefix']); } // kill STRICT_TRANS_TABLES and STRICT_ALL_TABLES off. It prevents usage of implicit default values. if ($idx == DB_AOWOW) { $interface->query('SET SESSION sql_mode = \'NO_ENGINE_SUBSTITUTION\''); } self::$interfaceCache[$idx] =& $interface; self::$connectionCache[$idx] = true; }
function c() { global $conn; if (self::$conn) { return self::$conn; } self::$conn = DbSimple_Generic::connect(sprintf("mysql://%s:%s@%s/%s", Z::config("db_user"), Z::config("db_password"), Z::config("db_host"), Z::config("db_database"))); /* Set error handler */ if (!function_exists("databaseErrorHandler")) { function databaseErrorHandler($message, $info) { // Если использовалась @, ничего не делать. if (!error_reporting()) { return; } // Выводим подробную информацию об ошибке. var_dump($message); var_dump($info); // debug($message); // debug($info); exit; } } self::$conn->setErrorHandler('databaseErrorHandler'); /*$conn->setLogger('myLogger'); function myLogger($db, $sql) { // Находим контекст вызова этого запроса. // $caller = $db->findLibraryCaller(); // $tip = "at ".@$caller['file'].' line '.@$caller['line']; // Печатаем запрос (конечно, Debug_HackerConsole лучше). // echo "<xmp title=\"$tip\">"; // print_r($sql); // echo "</xmp>"; debug($sql); } */ self::$conn->query("SET names utf8"); }
/** * Initialize database & template handlers, sets up sql/site configs * @category Main system functions * @example Connector::__construct() * @return bool **/ public function Connector() { if (!@(include 'configuration.php')) { die('<b>Error</b>: unable to load configuration file!'); } if (!@(require_once 'libs/DbSimple/Generic.php')) { die('<b>Error</b>: unable to load database class!'); } $this->mysqlconfig = $ArmoryConfig['mysql']; $this->armoryconfig = $ArmoryConfig['settings']; $this->realmData = $ArmoryConfig['multiRealm']; $this->aDB = DbSimple_Generic::connect('mysql://' . $this->mysqlconfig['user_armory'] . ':' . $this->mysqlconfig['pass_armory'] . '@' . $this->mysqlconfig['host_armory'] . '/' . $this->mysqlconfig['name_armory']); $this->aDB->query("SET NAMES ?", $this->mysqlconfig['charset_armory']); $this->rDB = DbSimple_Generic::connect('mysql://' . $this->mysqlconfig['user_realmd'] . ':' . $this->mysqlconfig['pass_realmd'] . '@' . $this->mysqlconfig['host_realmd'] . '/' . $this->mysqlconfig['name_realmd']); if (isset($_GET['r'])) { $realmName = urldecode($_GET['r']); $realm_info = $this->aDB->selectRow("SELECT `id`, `version` FROM `armory_realm_data` WHERE `name`=?", $realmName); if (!$realm_info) { $this->cDB = DbSimple_Generic::connect('mysql://' . $this->mysqlconfig['user_characters'] . ':' . $this->mysqlconfig['pass_characters'] . '@' . $this->mysqlconfig['host_characters'] . '/' . $this->mysqlconfig['name_characters']); $this->wDB = DbSimple_Generic::connect('mysql://' . $this->mysqlconfig['user_mangos'] . ':' . $this->mysqlconfig['pass_mangos'] . '@' . $this->mysqlconfig['host_mangos'] . '/' . $this->mysqlconfig['name_mangos']); $this->cDB->query("SET NAMES ?", $this->mysqlconfig['charset_characters']); $this->wDB->query("SET NAMES ?", $this->mysqlconfig['charset_mangos']); } elseif (isset($this->realmData[$realm_info['id']])) { $this->connectionData = $this->realmData[$realm_info['id']]; $this->cDB = DbSimple_Generic::connect('mysql://' . $this->connectionData['user_characters'] . ':' . $this->connectionData['pass_characters'] . '@' . $this->connectionData['host_characters'] . '/' . $this->connectionData['name_characters']); $this->cDB->query("SET NAMES ?", $this->connectionData['charset_characters']); $this->currentRealmInfo = array('name' => $this->connectionData['name'], 'id' => $realm_info['id'], 'version' => $realm_info['version'], 'connected' => true); if (isset($this->connectionData['name_mangos'])) { $this->wDB = DbSimple_Generic::connect('mysql://' . $this->connectionData['user_mangos'] . ':' . $this->connectionData['pass_mangos'] . '@' . $this->connectionData['host_mangos'] . '/' . $this->connectionData['name_mangos']); $this->wDB->query("SET NAMES ?", $this->connectionData['charset_mangos']); } else { $this->wDB = DbSimple_Generic::connect('mysql://' . $this->mysqlconfig['user_mangos'] . ':' . $this->mysqlconfig['pass_mangos'] . '@' . $this->mysqlconfig['host_mangos'] . '/' . $this->mysqlconfig['name_mangos']); $this->wDB->query("SET NAMES ?", $this->mysqlconfig['charset_mangos']); } } else { $this->cDB = DbSimple_Generic::connect('mysql://' . $this->mysqlconfig['user_characters'] . ':' . $this->mysqlconfig['pass_characters'] . '@' . $this->mysqlconfig['host_characters'] . '/' . $this->mysqlconfig['name_characters']); $this->wDB = DbSimple_Generic::connect('mysql://' . $this->mysqlconfig['user_mangos'] . ':' . $this->mysqlconfig['pass_mangos'] . '@' . $this->mysqlconfig['host_mangos'] . '/' . $this->mysqlconfig['name_mangos']); $this->cDB->query("SET NAMES ?", $this->mysqlconfig['charset_characters']); $this->wDB->query("SET NAMES ?", $this->mysqlconfig['charset_mangos']); } } else { $this->cDB = DbSimple_Generic::connect('mysql://' . $this->mysqlconfig['user_characters'] . ':' . $this->mysqlconfig['pass_characters'] . '@' . $this->mysqlconfig['host_characters'] . '/' . $this->mysqlconfig['name_characters']); $this->wDB = DbSimple_Generic::connect('mysql://' . $this->mysqlconfig['user_mangos'] . ':' . $this->mysqlconfig['pass_mangos'] . '@' . $this->mysqlconfig['host_mangos'] . '/' . $this->mysqlconfig['name_mangos']); $this->cDB->query("SET NAMES ?", $this->mysqlconfig['charset_characters']); $this->wDB->query("SET NAMES ?", $this->mysqlconfig['charset_mangos']); } if (!$this->currentRealmInfo) { $this->currentRealmInfo = array('name' => $this->realmData[1]['name'], 'id' => 1, 'version' => $this->armoryconfig['server_version'], 'connected' => true); } if (!$this->connectionData) { $this->connectionData = $this->realmData[1]; } $this->rDB->query("SET NAMES ?", $this->mysqlconfig['charset_realmd']); $user_locale = strtolower(substr($_SERVER['HTTP_ACCEPT_LANGUAGE'], 0, 2)); if ($user_locale && ($http_locale = self::IsAllowedLocale($user_locale))) { $this->_locale = isset($_SESSION['armoryLocale']) ? $_SESSION['armoryLocale'] : $http_locale; } else { $this->_locale = isset($_SESSION['armoryLocale']) ? $_SESSION['armoryLocale'] : $this->armoryconfig['defaultLocale']; } $this->_locale = isset($_SESSION['armoryLocale']) ? $_SESSION['armoryLocale'] : $this->armoryconfig['defaultLocale']; switch ($this->_locale) { case 'en_gb': case 'en_us': $this->_loc = 0; break; /* case 'ko_kr': $this->_loc = 1; break; */ /* case 'ko_kr': $this->_loc = 1; break; */ case 'fr_fr': $this->_loc = 2; break; case 'de_de': $this->_loc = 3; break; /* case 'zh_cn': $this->_loc = 4; // China break; case 'zh_tw': $this->_loc = 5; // Taiwan break; */ /* case 'zh_cn': $this->_loc = 4; // China break; case 'zh_tw': $this->_loc = 5; // Taiwan break; */ case 'es_es': $this->_loc = 6; break; case 'es_mx': $this->_loc = 7; break; case 'ru_ru': $this->_loc = 8; break; } }
{ $mangos['db_port'] = ( int )$MW->getConfig->generic->use_alternate_mangosdb_port ; } // Connects to WORLD DB $WSDB = DbSimple_Generic::connect( "" . $mangos['db_type'] . "://" . $mangos['db_username'] . ":" . $mangos['db_password'] . "@" . $mangos['db_host'] . ":" . $mangos['db_port'] . "/" . $mangos['db_name'] . "" ) ; if ( $WSDB ) $WSDB->setErrorHandler( 'databaseErrorHandler' ) ; if ( $WSDB ) $WSDB->query( "SET NAMES " . $mangos['db_encoding'] ) ; // Connects to CHARACTERS DB $CHDB = DbSimple_Generic::connect( "" . $mangos['db_type'] . "://" . $mangos['db_username'] . ":" . $mangos['db_password'] . "@" . $mangos['db_host'] . ":" . $mangos['db_port'] . "/" . $mangos['db_char'] . "" ) ; if ( $CHDB ) $CHDB->setErrorHandler( 'databaseErrorHandler' ) ; if ( $CHDB ) $CHDB->query( "SET NAMES " . $mangos['db_encoding'] ) ; //Load characters list if ( isset( $user['id'] ) && $user['id'] > 0 ) { $characters = $CHDB->select( 'SELECT guid,name FROM `characters` WHERE account=?d', $user['id'] ) ; if ( isset( $_COOKIE['cur_selected_character'] ) ) { foreach ( $characters as $character ) {
if (!$realmid) { $strErrorMsg = 'Not realmid'; $bResult = false; } if ($bResult) { $realm_info = get_realm_byid($realmid); if (!$realm_info['CharacterDatabaseInfo']) { $strErrorMsg = 'Check field <u>CharacterDatabaseInfo</u> in table `realmlist` for realm id=' . $realm_info['id']; $bResult = false; } } AddMangosFields($realm_info['Version']); $charinfo_link = $realm_info['WowdCharInfoLink']; if ($bResult) { $wsdb_info = parse_worlddb_info($realm_info['CharacterDatabaseInfo']); $WSDB = DbSimple_Generic::connect("" . $config['db_type'] . "://" . $wsdb_info['user'] . ":" . $wsdb_info['password'] . "@" . $wsdb_info['host'] . ":" . $wsdb_info['port'] . "/" . $wsdb_info['db'] . ""); if (!$WSDB) { $strErrorMsg = 'Not Connect'; $bResult = false; } } $action = $_GET['action']; $guid = $_GET['guid']; $char_online = false; if ($bResult) { $WSDB->setErrorHandler('databaseErrorHandler'); $WSDB->query("SET NAMES " . $config['db_encoding']); $query = $WSDB->selectrow("SELECT * FROM `characters` WHERE `account`=?d and `guid`=?d ORDER BY `name`", $user['id'], $guid); $my_char; if (!$query) { $strErrorMsg = 'Персонаж на вашем аккаунте не обнаружен';
include 'RepositoryAds.php'; include 'Advertisement.php'; include 'AdvCompany.php'; include 'AdvPrivate.php'; //include 'AdvertisementFactory.php'; // загрузка данных из фала server_name,user_name, password, database $filename = './User.txt'; if (file_exists($filename)) { $temp_str = file_get_contents('./User.txt'); if (isset($temp_str)) { $user = unserialize(file_get_contents('./User.txt')); // действие в случае удачи } else { ?> <a href="instal.php">Проверьте введенные данные</a><?php exit('Ошибка чтения файла'); // или другое действие при неудачном чтении файла } } else { ?> <a href="instal.php">Проверьте введенные данные</a><?php exit('Ошибка чтения файла'); } //подключение к серверу SQL $bd = DbSimple_Generic::connect("mysqli://{$user['user_name']}:{$user['password']}@{$user['server_name']}/{$user['database']}"); // Устанавливаем обработчик ошибок. $bd->setErrorHandler('databaseErrorHandler'); $bd->setLogger('myLogger'); $bd->query('SET NAMES utf8'); //установка кодировки utf8 $location = basename($_SERVER['PHP_SELF']);
<?php error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE); ini_set('display_errors', 1); require_once "settings.php"; require_once "functions.php"; require_once "FirePHPCore/FirePHP.class.php"; require_once MY_DBSIMPLE_DIR . "DbSimple/Generic.php"; require_once MY_DBSIMPLE_DIR . "config.php"; require_once MY_SMARTY_DIR . '/libs/Smarty.class.php'; $firePHP = FirePHP::getInstance(true); $firePHP->setEnabled(true); $smarty = new Smarty(); $smarty->compile_check = true; $smarty->template_dir = MY_SMARTY_DIR . 'templates'; $smarty->compile_dir = MY_SMARTY_DIR . 'templates_c'; $smarty->cache_dir = MY_SMARTY_DIR . 'cache'; $smarty->config_dir = MY_SMARTY_DIR . 'configs'; if (!($iniArray = getParamsFromIniFile(INI_FILE_NAME))) { echo 'Отсутствует ' . INI_FILE_NAME . ' файл. Перейдите к <a href="install.php">установке</a>'; exit; } $db = DbSimple_Generic::connect('mysqli://' . $iniArray['UserName'] . ':' . $iniArray['Password'] . '@' . $iniArray['ServerName'] . '/' . $iniArray['Database']); $db->setErrorHandler('databaseErrorHandler'); $db->setLogger('myLogger');
$users_online = array(); $guests_online = 0; $messages = ''; $redirect = ''; $sidebarmessages = ''; $context_menu = array(); // Connetcts to DB // DB layer documentation at http://en.dklab.ru/lib/DbSimple/ function databaseErrorHandler($message, $info) { if (!error_reporting()) { return; } output_message('alert', "SQL Error: {$message}<br><pre>" . print_r($info, true) . "</pre>"); } $DB = DbSimple_Generic::connect("" . $config['db_type'] . "://" . $config['db_username'] . ":" . $config['db_password'] . "@" . $config['db_host'] . ":" . $config['db_port'] . "/" . $config['db_name'] . ""); $DB->setErrorHandler('databaseErrorHandler'); $DB->query("SET NAMES " . $config['db_encoding']); // Load settings from db or cache // loadSettings(); // Build path vars // $config['site_href'] = str_replace('//', '/', str_replace('\\', '/', dirname($_SERVER['SCRIPT_NAME']) . '/')); $config['site_domain'] = $_SERVER['HTTP_HOST']; $config['base_href'] = 'http://' . $config['site_domain'] . '' . $config['site_href']; $config['template_href'] = $config['site_href'] . 'templates/' . $config['template'] . '/'; // Check lang ====================================== if (isset($_COOKIE['Language'])) { $config['lang'] = $_COOKIE['Language']; } loadLanguages(); // ================================================
ini_set('display_errors', 1); require_once "../dbsimple/config.php"; require_once "../dbsimple/DbSimple/Generic.php"; require_once '../FirePHPCore/lib/FirePHPCore/FirePHP.class.php'; $firePHP = FirePHP::getInstance(true); $firePHP->setEnabled(true); require '../smarty/libs/Smarty.class.php'; $smarty = new Smarty(); $smarty->compile_check = true; //$smarty->debugging = true; $smarty->template_dir = '../smarty/templates'; $smarty->compile_dir = '../smarty/templates_c'; $smarty->cache_dir = '../smarty/cache'; $smarty->config_dir = '../smarty/configs'; // Подключаемся к БД. $db = DbSimple_Generic::connect('mysqli://*****:*****@127.0.0.1/ads'); //DNS $db->setErrorHandler('databaseErrorHandler'); $db->setLogger('myLogger'); function databaseErrorHandler($message, $info) { if (!error_reporting()) { return; } echo "SQL Error: {$message}<br><pre>"; print_r($info); echo "</pre>"; exit; } function myLogger($db, $sql, $caller) {
continue; } if ($dsnOwn != '*' && strtolower($e) != strtolower($dsnOwn)) { continue; } $dsn = trim(@join("", file("{$full}/{$dsnFile}"))); if ($dsn) { $DSN = array_merge($DSN, preg_split('/\\s+/s', $dsn)); } } } else { $DSN[] = $dsnOwn; } } foreach ($DSN as $dsn) { $DB =& DbSimple_Generic::connect($dsn); $DB->setLogger('queryLogger'); $DB->setErrorHandler('errorHandler'); main($DB); } function queryLogger(&$DB, $query) { if (preg_match('/^\\s*--\\s+(\\d|error)/', $query)) { return; } printr($query, "Query"); } function errorHandler($msg, $error) { if (!error_reporting()) { return;