<?php

require 'database.php';
Database::setUsername('root');
Database::setPassword('');
Database::setHostname('localhost');
Database::setDatabase('test');
Database::setDBLink('default');
Database::connect();
$rowSingleAccount1 = Database::fetch("SELECT * FROM account WHERE id = :id", [['id', 1, 'int']]);
$rowSingleAccount2 = Database::fetch("SELECT * FROM account WHERE id = :id", [['id', 1, 'int']]);
echo '<pre>';
print_r($rowSingleAccount1);
print_r($rowSingleAccount2);
echo '</pre>';
$rowMultiAccount = Database::fetchAll("SELECT * FROM account");
echo '<pre>';
print_r($rowMultiAccount);
echo '</pre>';
// $fullname = 'Peter';
// Database::exec("INSERT INTO account(fullname)
// VALUES(:fullname)", [
// 	['fullname', $fullname, 'str']
// ]);
echo '<hr />';
echo '<pre>';
print_r(Database::getStatistics());
echo '</pre>';
Example #2
0
<?
$INC_PATH = "/home/imperial/domains/game.imperial-battle.com/private_html/includes_01/";

require($INC_PATH.'classes/class.database.php');
require($INC_PATH.'classes/class.user.php');
require($INC_PATH.'classes/class.battleenginecollection.php');
session_start();

require($INC_PATH.'config.inc.php');
require($INC_PATH.'functions.inc.php');

/* New database object */
$db = new Database;
$db->setIP($dbconf['ip']);
$db->setPort($dbconf['port']);
$db->setUsername($dbconf['username']);
$db->setPassword($dbconf['password']);
$db->setDatabase($dbconf['database']);
$db->connect();
$db->selectDatabase();

/* New user object */
if ((!$user) && (!$_SESSION['user'])) {
	$user = new User($table['players'], 'id', 'username', 'password', $db);
	$_SESSION['user'] = $user;
}
if (($_SESSION['user']) && (!$user)) {
	$user = $_SESSION['user'];
}
?>
Example #3
0
 public function loadForSource($url)
 {
     $datasrc = dirname(dirname(__FILE__)) . '/Resources/data/databases/DataSources.xml';
     if (extension_loaded('apc') && ini_get('apc.enabled')) {
         $xml = $this->loadFileFromCache($url);
         $simulator = new \SimpleXMLElement($xml, LIBXML_NOWARNING, false);
         $xml = $this->loadFileFromCache($datasrc);
         $datasources = new \SimpleXMLElement($xml, LIBXML_NOWARNING, false);
     } else {
         $simulator = new \SimpleXMLElement($url, LIBXML_NOWARNING, true);
         $datasources = new \SimpleXMLElement($datasrc, LIBXML_NOWARNING, true);
     }
     foreach ($datasources->DataSource as $datasource) {
         $datasourceObj = new DataSource($this, (int) $datasource['id'], (string) $datasource['name'], (string) $datasource['type']);
         $datasourceObj->setUri((string) $datasource['uri']);
         $datasourceObj->setMethod((string) $datasource['method']);
         $datasourceObj->setDatabase((int) $datasource['database']);
         $datasourceObj->setDescription((string) $datasource->Description);
         $this->datasources[] = $datasourceObj;
     }
     if ($datasources->Databases) {
         foreach ($datasources->Databases->Database as $database) {
             $databaseObj = new Database($this, (int) $database['id'], (string) $database['type'], (string) $database['name']);
             $databaseObj->setLabel((string) $database['label']);
             $databaseObj->setHost((string) $database['host']);
             $databaseObj->setPort((int) $database['port']);
             $databaseObj->setUser((string) $database['user']);
             if ((string) $database['password'] != '') {
                 $databaseObj->setPassword((string) $database['password']);
             } elseif ((string) $database['user'] != '') {
                 try {
                     $user = $this->controller->get('kernel')->getContainer()->getParameter('database_user');
                     if ((string) $database['user'] == $user) {
                         $databaseObj->setPassword($this->controller->get('kernel')->getContainer()->getParameter('database_password'));
                     }
                 } catch (\Exception $e) {
                 }
             }
             $this->databases[] = $databaseObj;
         }
     }
     if ($simulator->DataSet) {
         foreach ($simulator->DataSet->children() as $child) {
             if ($child->getName() == "DataGroup") {
                 foreach ($child->Data as $data) {
                     $dataObj = new Data($this, (int) $data['id'], (string) $data['name']);
                     $dataObj->setLabel((string) $data['label']);
                     $dataObj->setType((string) $data['type']);
                     $this->datas[] = $dataObj;
                 }
             } elseif ($child->getName() == "Data") {
                 $dataObj = new Data($this, (int) $child['id'], (string) $child['name']);
                 $dataObj->setLabel((string) $child['label']);
                 $dataObj->setType((string) $child['type']);
                 $this->datas[] = $dataObj;
             }
         }
     }
     if ($simulator->Sources) {
         foreach ($simulator->Sources->Source as $source) {
             $sourceObj = new Source($this, (int) $source['id'], (string) $source['datasource'], (string) $source['returnType']);
             $sourceObj->setRequest((string) $source['request']);
             $sourceObj->setSeparator((string) $source['separator']);
             $sourceObj->setDelimiter((string) $source['delimiter']);
             $sourceObj->setReturnPath((string) $source['returnPath']);
             foreach ($source->Parameter as $parameter) {
                 $parameterObj = new Parameter($sourceObj, (string) $parameter['type']);
                 $parameterObj->setName((string) $parameter['name']);
                 $parameterObj->setFormat((string) $parameter['format']);
                 $parameterObj->setData((int) $parameter['data']);
                 $sourceObj->addParameter($parameterObj);
             }
             $this->sources[] = $sourceObj;
         }
     }
 }
Example #4
0
 protected function getDatabase($datasource, $withDbName = true)
 {
     $dbid = (int) $datasource['database'];
     $databases = $this->datasources->xpath("/DataSources/Databases/Database[@id='" . $dbid . "']");
     $dbtype = (string) $databases[0]['type'];
     $dbname = (string) $databases[0]['name'];
     $database = new Database(null, $dbid, $dbtype, $dbname);
     if ((string) $databases[0]['label'] != "") {
         $database->setLabel((string) $databases[0]['label']);
     } else {
         $database->setLabel($dbname);
     }
     if ((string) $databases[0]['host'] != "") {
         $database->setHost((string) $databases[0]['host']);
     }
     if ((string) $databases[0]['port'] != "") {
         $database->setPort((int) $databases[0]['port']);
     }
     if ((string) $databases[0]['user'] != "") {
         $database->setUser((string) $databases[0]['user']);
     }
     if ((string) $databases[0]['password'] != "") {
         $database->setPassword((string) $databases[0]['password']);
     } elseif ((string) $databases[0]['user'] != "") {
         try {
             $user = $this->parameters['database_user'];
             if ((string) $databases[0]['user'] == $user) {
                 $database->setPassword($this->parameters['database_password']);
             }
         } catch (\Exception $e) {
         }
     }
     $database->connect($withDbName);
     return $database;
 }