connect("mysql://" . $UDWBaseconf['world']['user'] . ":" . $UDWBaseconf['world']['pass'] . "@" . $UDWBaseconf['world']['host'] . "/" . $UDWBaseconf['world']['db']);
$DB->setErrorHandler('databaseErrorHandler');
$DB->setIdentPrefix($UDWBaseconf['world']['table_prefix']);
$DB->query('SET NAMES ?', 'utf8');
// Connect to the realm DB
if ($UDWBaseconf['realmd']) {
$rDB = $DBSimple->connect("mysql://" . $UDWBaseconf['realmd']['user'] . ":" . $UDWBaseconf['realmd']['pass'] . "@" . $UDWBaseconf['realmd']['host'] . "/" . $UDWBaseconf['realmd']['db']);
$rDB->setErrorHandler('databaseErrorHandler');
$rDB->setIdentPrefix($UDWBaseconf['realmd']['table_prefix']);
$rDB->query('SET NAMES ?', 'utf8');
}
/**
* Error handling
*
* @param type $message
* @param type $info
* @return type
*/
function databaseErrorHandler($message, $info) {
// If @ has been used, do nothing.
if (!error_reporting())
return;
// Display detailed error information
echo "SQL Error: $message
";
print_r($info);
echo "";
exit();
}
// For debugging information, enable the debug setting
if ($UDWBaseconf['debug'])
$DB->setLogger('myLogger');
/**
*
* @global type $smarty
* @param type $db
* @param type $sql
*/
function myLogger($db, $sql) {
global $smarty;
$smarty->uDebug('!DbSimple', $sql, 5000);
}
/**
* PRECACHING
*
* Contents of the file:
*
* - cache_delete_timestamp
* - serialized data
* - serialized allitems
* - serialized allspells
* - serialized exdata
* - serialized zonedata
*
*/
$cache_types = array(
1 => 'npc_page',
2 => 'npc_listing',
3 => 'object_page',
4 => 'object_listing',
5 => 'item_page',
6 => 'item_tooltip',
7 => 'item_listing',
8 => 'itemset_page',
9 => 'itemset_listing',
10 => 'quest_page',
11 => 'quest_tooltip',
12 => 'quest_listing',
13 => 'spell_page',
14 => 'spell_tooltip',
15 => 'spell_listing',
16 => 'zone_page',
17 => 'zone_listing',
18 => 'faction_page',
19 => 'faction_listing'
);
/**
*
* @global array $cache_types
* @global type $allitems
* @global type $allspells
* @global type $UDWBaseconf
* @global type $exdata
* @global type $zonedata
* @param type $type
* @param type $type_id
* @param type $data
* @param type $prefix
* @return type
*/
function save_cache($type, $type_id, $data, $prefix = '') {
global $cache_types, $allitems, $allspells, $UDWBaseconf, $exdata, $zonedata;
$type_str = $cache_types[$type];
if (empty($type_str))
return false;
// {$type_str}_{$type_id}.aww
$file = fopen($prefix . '.cache/world/' . $type_str . '_' . $type_id . '_' . $_SESSION['locale'] . '.aww', 'w+');
$time = time() + $UDWBaseconf['udwbase']['cache_time'];
if (!$file)
return false;
// записываем дату в файл
fputs($file, $time);
fputs($file, "\n" . serialize($data) . "\n");
if ($allitems)
fputs($file, serialize($allitems));
fputs($file, "\n");
if ($allspells)
fputs($file, serialize($allspells));
fputs($file, "\n");
if ($exdata)
fputs($file, serialize($exdata));
fputs($file, "\n");
if ($zonedata)
fputs($file, serialize($zonedata));
fclose($file);
return true;
}
/**
*
* @global array $cache_types
* @global type $smarty
* @global type $allitems
* @global type $allspells
* @global type $exdata
* @global type $zonedata
* @param type $type
* @param type $type_id
* @return type
*/
function load_cache($type, $type_id) {
global $cache_types, $smarty, $allitems, $allspells, $exdata, $zonedata;
$type_str = $cache_types[$type];
if (empty($type_str))
return false;
$data = @file_get_contents($prefix . '.cache/world/' . $type_str . '_' . $type_id . '_' . $_SESSION['locale'] . '.aww');
if (!$data)
return false;
$data = explode("\n", $data);
if ($data[0] < time())
return false;
if ($data[2])
$allitems = unserialize($data[2]);
if ($data[3])
$allspells = unserialize($data[3]);
if ($data[4])
$smarty->assign('exdata', unserialize($data[4]));
if ($data[5])
$smarty->assign('zonedata', unserialize($data[5]));
return unserialize($data[1]);
}