/**
* Class constructor
*
* @param Db_MySqlDatabase db
*
*/
public function __construct(MySqlDatabase $db, Logger $logger = null)
{
if ($logger === null) {
$this->setLogger(new SessionLogger());
} else {
$this->setLogger($logger);
}
$this->db_link = $db->getLink();
}
public static function getInstance()
{
if (!isset(self::$instance)) {
self::$instance = new self();
}
return self::$instance;
}
/**
* Extract all images in database
* @access public
* @return hash hash of extracted images
* @static
*/
public static function selectAll()
{
$config = Configuration::getMysqlConfiguration();
$query = "select * from immagini";
try {
$database = new MySqlDatabase($config['dbHost'], $config['dbUser'], $config['dbPassword'], $config['dbName'], $config['dbPort']);
$connection = $database->dbConnect();
$result = $database->executeQuery($query, $connection);
$i = 0;
$images = array();
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
$images[$i] = $row;
$i++;
}
return $images;
} catch (Error $e) {
$e->printHtmlError();
$e->reportOnGitHub(array("mysql error", "image"));
}
}
public static function convertMySqlDB2MongoDB($mysqldb_name, $mongodb_name)
{
// connect to mysql database
$tables = MySqlDatabase::getAllTableFrom($mysqldb_name);
// connect to mongo
$mongo_connection = new Mongo();
// create database
$mongo_database = $mongo_connection->{$mongodb_name};
foreach ($tables as $index => $name) {
// create collection in MongoDB
$collection = $mongo_database->{$name};
$table_data = MySqlDatabase::getAllDataFrom($name);
foreach ($table_data as $row_id => $row) {
// insert document
$collection->save($row);
}
}
}
/**
* get all data from database
* @param $table table name
* @param $condition condition for querying
* @return Array
*/
public static function getAllDataFrom($table, $condition = null)
{
MySqlDatabase::connect();
$sql = "select * from {$table} ";
if ($condition != null) {
$sql .= $condition;
}
$result = mysql_query($sql) or die(mysql_error());
$table_result = array();
$r = 0;
while ($row = mysql_fetch_assoc($result)) {
$arr_row = array();
$c = 0;
while ($c < mysql_num_fields($result)) {
$col = mysql_fetch_field($result, $c);
$arr_row[$col->name] = $row[$col->name];
$c++;
}
$table_result[$r] = $arr_row;
$r++;
}
return $table_result;
}
define('FLGR_BASE', implode('/', $tmp));
// Включаем конфигурационный файл
require_once FLGR_BASE . '/config.php';
$dbglog = '';
require_once FLGR_COMMON . '/common.php';
// Все общие функции
// unk.jpg
if ('/photos/thumbnails' == unslashify($_SERVER['REQUEST_URI'])) {
header('Content-type: image/jpeg');
readfile(FLGR_PHOTOS_THUMBNAILS . '/unk.jpg');
exit;
}
// Включаем профайлер
$Profiler = new PhpQuickProfiler(PhpQuickProfiler::getMicroTime());
// DataBase
$Db = new MySqlDatabase(DB_HOST, DB_USER, DB_PASSWORD);
$Db->connect(true);
$Db->changeDatabase(DB_NAME);
$Db->query('SET NAMES cp1251');
// Использование деструктора объекта в качестве
// единой точки выхода
if (bIsDbgIp()) {
class PqpOuter
{
public function __destruct()
{
global $Profiler;
global $Db;
// FORCE_QUIT - это аjax ответ :)
if (!defined('FORCE_QIUT')) {
if (defined('DBG_PROFILER')) {
<?php
/**
* Города и страны
*/
//define('FLGR_BASE', dirname(__FILE__));
$tmp = explode(DIRECTORY_SEPARATOR, $_SERVER['DOCUMENT_ROOT']);
// Важно использовать DIRECTORY_SEPARATOR вместо '/' при разборе
define('FLGR_BASE', implode('/', $tmp));
// Включаем конфигурационный файл
require_once FLGR_BASE . '/config.php';
require_once FLGR_COMMON . '/common.php';
// Все общие функции
// DataBase
$Db = new MySqlDatabase(DB_HOST, DB_USER, DB_PASSWORD);
$Db->connect(true);
$Db->changeDatabase(DB_NAME);
$Db->query('SET NAMES cp1251');
// Components // ***TODO***: Кэшировать в файле алиасы таблиц, чтобы не дергать каждый раз базу
$Components = new Components();
foreach ($Components->getAllTablesAndAliases() as $v) {
$v['alias'] = 'DB_TBL_' . strtoupper($v['alias']);
if (!defined($v['alias'])) {
define($v['alias'], $v['name']);
//dbg($v['alias']);
}
}
// BREADCRUMBS
//$BreadCrumbs->addBreadCrumbs($sKey, $sTitle);
$file = file_get_contents(__FILE__);
$pos = strpos($file, '?' . '>') + 2;
<?php
//version 2.3
define('INSIDE', true);
include 'includes/functions/classes/MySqlDatabase.php';
$db_rss = new MySqlDatabase();
header('Content-type: text/xml; charset="utf-8"');
$rss_titulo = $db_rss->game_config["game_name"];
$rss_url = dirname("http://" . $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF']) . "/";
$rss_descripcion = "Noticias de {$db_rss->game_config["game_name"]}";
$rss_email = $db_rss->game_config["user_mail"] . "@" . $db_rss->game_config["smtp_mail"];
// Escribimos el archivo RSS
echo '<?xml version="1.0" encoding="iso-8859-1"?>';
echo "<rss version=\"0.92\">\n <channel>\n <docs>{$rss_url}rss.php</docs>\n <title>{$rss_titulo}</title>\n <link>{$rss_url}</link>\n <description>{$rss_descripcion}</description>\n <language>es</language>\n <managingEditor>{$rss_email}</managingEditor>\n <webMaster>{$rss_email}</webMaster>\n <copyright>Copyright 2009 - 2010 Xnova-Svn</copyright>\n <generator>Xnova Svn RSS</generator>\n";
$rss_query = $db_rss->query("SELECT * FROM `{{table}}` ORDER BY `news_id` DESC LIMIT 0 , 10", 'news');
while ($rss = mysql_fetch_array($rss_query)) {
echo "<item>\n";
echo "<title><![CDATA[" . $rss["news_titulo"] . "]]></title>\n";
echo "<link><![CDATA[" . $rss_url . "game.php?page=news&idnew=" . $rss["news_id"] . "]]></link>\n";
echo "<description><![CDATA[" . $rss["news_news"] . "]]></description>\n";
echo "<pubDate>" . date("d-m-y H:i:s", $rss["news_date"]) . "</pubDate>\n";
echo "</item>\n";
}
echo "</channel>";
echo "</rss>";
if (filesize($svn_root . 'config.php') == 0) {
exit(header("location:" . $svn_root . "install/"));
}
}
if (!file_exists($svn_root . 'config.php') && INSTALL != true) {
exit(header("location:" . $svn_root . "install/"));
}
$phpEx = "php";
include_once $svn_root . 'includes/constants.' . $phpEx;
include_once $svn_root . 'includes/functions.' . $phpEx;
include_once $svn_root . "includes/functions/classes/class.TemplatePower.inc." . $phpEx;
include $svn_root . 'includes/functions/classes/Console.' . $phpEx;
include $svn_root . 'includes/functions/classes/PhpQuickProfiler.' . $phpEx;
include $svn_root . 'includes/functions/classes/MySqlDatabase.' . $phpEx;
include $svn_root . 'includes/functions/classes/class.plugins.' . $phpEx;
$db = new MySqlDatabase();
include $svn_root . "includes/displays." . $phpEx;
$displays = new displays();
include $svn_root . 'includes/functions/classes/class.user.' . $phpEx;
$users = new users();
if (INSTALL != true) {
$plugin = new plugins();
include $svn_root . 'includes/vars.' . $phpEx;
include $svn_root . 'includes/functions/CreateOneMoonRecord.' . $phpEx;
include $svn_root . 'includes/functions/CreateOnePlanetRecord.' . $phpEx;
define('DEFAULT_LANG', $db->game_config['lang'] == '' ? "es" : $db->game_config['lang']);
includeLang('GAME');
if ($InLogin != true) {
$users->CheckUser();
if ($db->game_config['game_disable'] == 1 && $users->user['authlevel'] == 0) {
$displays->message(stripslashes($db->game_config['close_reason']));
