<?php
// ###################### config ########################
//load page config file
$config['site'] = parse_ini_file('config/config.ini');
include('config/config.php');
//check install
if($config['site']['install'] != "yes")
{
header("location: Install.php");
exit;
}
//load server config
@$config['server'] = parse_ini_file($config['site']['server_path'].'config.lua');
if(isset($config['server']['mysqlhost']))
{
//new (0.2.6+) ots config.lua file
$mysqlhost = $config['server']['mysqlhost'];
$mysqluser = $config['server']['mysqluser'];
$mysqlpass = $config['server']['mysqlpass'];
$mysqldatabase = $config['server']['mysqldatabase'];
}
elseif(isset($config['server']['sqlhost']))
{
//old (0.2.4) ots config.lua file
$mysqlhost = $config['server']['sqlhost'];
$mysqluser = $config['server']['sqluser'];
$mysqlpass = $config['server']['sqlpass'];
$mysqldatabase = $config['server']['sqldatabase'];
}
$sqlitefile = $config['server']['sqlitedatabase'];
$passwordency = '';
if(strtolower($config['server']['usemd5passwords']) == 'yes' || strtolower($config['server']['passwordtype']) == 'md5')
$passwordency = 'md5';
if(strtolower($config['server']['passwordtype']) == 'sha1')
$passwordency = 'sha1';
// loads #####pot mainfile#####
include('pot/ots.php');
// pdo and pot connects to database
$ots = pot::getinstance();
if(strtolower($config['server']['sqltype']) == "mysql")
{
//connect to mysql database
try
{
$ots->connect(pot:b_mysql, array('host' => $mysqlhost, 'user' => $mysqluser, 'password' => $mysqlpass, 'database' => $mysqldatabase) );
}
catch(pdoexception $error)
{
echo 'database error - can\'t connect to mysql database. Possible reasons:<br>1. Mysql server is not running on host.<br>2. Mysql user, password, database or host isn\'t configured in: <b>'.$config['site']['server_path'].'config.lua</b> .<br>3. Mysql user, password, database or host is wrong.';
exit;
}
}
elseif(strtolower($config['server']['sqltype']) == "sqlite")
{
//connect to sqlite database
$link_to_sqlitedatabase = $config['site']['server_path'].$sqlitefile;
try
{
$ots->connect(pot:b_sqlite, array('database' => $link_to_sqlitedatabase));
}
catch(pdoexception $error)
{
echo 'database error - can\'t open sqlite database. Possible reasons:<br><b>'.$link_to_sqlitedatabase.'</b> - file isn\'t valid sqlite database.<br><b>'.$link_to_sqlitedatabase.'</b> - doesn\'t exist.<br><font color="red">wrong php configuration. Default php does not work with sqlite databases!</font>';
exit;
}
}
else
{
echo 'database error. Unknown database type in <b>'.$config['site']['server_path'].'config.lua</b> . Must be equal to: "<b>mysql</b>" or "<b>sqlite</b>". Now is: "<b>'.strtolower($config['server']['sqltype']).'<b>mysql"</b>';
exit;
}
$sql = pot::getinstance()->getdbhandle();
$layout_name = "layouts/".$layout_name = $config['site']['layout'];;
$layout_ini = parse_ini_file($layout_name.'/layout_config.ini');
foreach($layout_ini as $key => $value)
$config['site'][$key] = $value;
//###################### functions ######################
function ispremium($premdays, $lastday)
{
return ($premdays - (date("z", time()) + (365 * (date("y", time()) - date("y", $lastday))) - date("z", $lastday)) > 0);
}
//save config in ini file
function saveconfig_ini($config)
{
$file = fopen("config/config.ini", "w");
foreach($config as $param => $data)
{
$file_data .= $param.' = "'.str_replace('"', '', $data).'"
';
}
rewind($file);
fwrite($file, $file_data);
fclose($file);
}
//return password to db
function password_ency($password)
{
$ency = $globals['passwordency'];
if($ency == 'sha1')
return sha1($password);
elseif($ency == 'md5')
return md5($password);
elseif($ency == '')
return $password;
}
//delete player with name
function delete_player($name) {
$sql = $globals['sql'];
$player = new ots_player();
$player->find($name);
if($player->isloaded()) {
try { $sql->query("delete from player_skills where player_id = '".$player->getid()."';"); } catch(pdoexception $error) {}
try { $sql->query("delete from guild_invites where player_id = '".$player->getid()."';"); } catch(pdoexception $error) {}
try { $sql->query("delete from player_items where player_id = '".$player->getid()."';"); } catch(pdoexception $error) {}
try { $sql->query("delete from player_depotitems where player_id = '".$player->getid()."';"); } catch(pdoexception $error) {}
try { $sql->query("delete from player_spells where player_id = '".$player->getid()."';"); } catch(pdoexception $error) {}
try { $sql->query("delete from player_storage where player_id = '".$player->getid()."';"); } catch(pdoexception $error) {}
try { $sql->query("delete from player_viplist where player_id = '".$player->getid()."';"); } catch(pdoexception $error) {}
try { $sql->query("delete from player_deaths where player_id = '".$player->getid()."';"); } catch(pdoexception $error) {}
try { $sql->query("delete from player_deaths where killed_by = '".$player->getid()."';"); } catch(pdoexception $error) {}
$rank = $player->getrank();
if(!empty($rank)) {
$guild = $rank->getguild();
if($guild->getowner()->getid() == $player->getid()) {
$rank_list = $guild->getguildrankslist();
if(count($rank_list) > 0) {
$rank_list->orderby('level');
foreach($rank_list as $rank_in_guild) {
$players_with_rank = $rank_in_guild->getplayerslist();
$players_with_rank->orderby('name');
$players_with_rank_number = count($players_with_rank);
if($players_with_rank_number > 0) {
foreach($players_with_rank as $player_in_guild) {
$player_in_guild->setrank();
$player_in_guild->save();
}
}
$rank_in_guild->delete();
}
$guild->delete();
}
}
}
$player->delete();
return true;
}
}
//delete guild with id
function delete_guild($id) {
$guild = new ots_guild();
$guild->load($id);
if($guild->isloaded()) {
$rank_list = $guild->getguildrankslist();
if(count($rank_list) > 0) {
$rank_list->orderby('level');
foreach($rank_list as $rank_in_guild) {
$players_with_rank = $rank_in_guild->getplayerslist();
if(count($players_with_rank) > 0) {
foreach($players_with_rank as $player_in_guild) {
$player_in_guild->setrank();
$player_in_guild->save();
}
}
$rank_in_guild->delete();
}
}
$guild->delete();
return true;
}
else
return false;
}
//is it valid nick?
Function check_name($name)//sprawdza name
{
$temp = strspn("$name", "qwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjkl zxcv bnm- [ ] '");
if ($temp != strlen($name)) {
return false;
}
else
{
$ok = "/[a-za-z ']{1,25}/";
return (preg_match($ok, $name))? True: False;
}
}
//is it valid nick?
Function check_account_name($name)//sprawdza name
{
$temp = strspn("$name", "qwertyuiopasdfghjklzxcvbnm0123456789");
if ($temp != strlen($name))
return false;
if(strlen($name) > 32)
return false;
else
{
$ok = "/[a-z0-9]/";
return (preg_match($ok, $name))? True: False;
}
}
//is it valid nick for new char?
Function check_name_new_char($name)//sprawdza name
{
$name_to_check = strtolower($name);
//first word can't be:
//names blocked:
$names_blocked = array('gm','cm', 'god', 'tutor');
$first_words_blocked = array('gm ','cm ', 'god ','tutor ', "'", '-');
//name can't contain:
$words_blocked = array('gamemaster', 'game master', 'game-master', "game'master", '--', "''","' ", " '", '- ', ' -', "-'", "'-", 'fuck', 'sux', 'suck', 'noob', 'tutor');
foreach($first_words_blocked as $word)
if($word == substr($name_to_check, 0, strlen($word)))
return false;
if(substr($name_to_check, -1) == "'" || substr($name_to_check, -1) == "-")
return false;
if(substr($name_to_check, 1, 1) == ' ')
return false;
if(substr($name_to_check, -2, 1) == " ")
return false;
foreach($names_blocked as $word)
if($word == $name_to_check)
return false;
foreach($globals['config']['site']['monsters'] as $word)
if($word == $name_to_check)
return false;
foreach($globals['config']['site']['npc'] as $word)
if($word == $name_to_check)
return false;
for($i = 0; $i < strlen($name_to_check); $i++)
if($name_to_check[$i-1] == ' ' && $name_to_check[$i+1] == ' ')
return false;
foreach($words_blocked as $word)
if (!(strpos($name_to_check, $word) === false))
return false;
for($i = 0; $i < strlen($name_to_check); $i++)
if($name_to_check[$i] == $name_to_check[($i+1)] && $name_to_check[$i] == $name_to_check[($i+2)])
return false;
for($i = 0; $i < strlen($name_to_check); $i++)
if($name_to_check[$i-1] == ' ' && $name_to_check[$i+1] == ' ')
return false;
$temp = strspn("$name", "qwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjkl zxcv bnm- '");
if ($temp != strlen($name))
return false;
else
{
$ok = "/[a-za-z ']{1,25}/";
return (preg_match($ok, $name))? True: False;
}
}
//is rank name valid?
Function check_rank_name($name)//sprawdza name
{
$temp = strspn("$name", "qwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjkl zxcv bnm0123456789-[ ] ");
if ($temp != strlen($name)) {
return false;
}
else
{
$ok = "/[a-za-z ]{1,60}/";
return (preg_match($ok, $name))? True: False;
}
}
//is guild name valid?
Function check_guild_name($name)
{
$temp = strspn("$name", "qwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjkl zxcv bnm0123456789- ");
if ($temp != strlen($name)) {
return false;
}
else
{
$ok = "/[a-za-z ]{1,60}/";
return (preg_match($ok, $name))? True: False;
}
}
//is it valid password?
Function check_password($pass)//sprawdza haslo
{
$temp = strspn("$pass", "qwertyuiopasdfghjklzxcvbnmqwertyuiopasdfghjkl zxcv bnm1234567890");
if ($temp != strlen($pass)) {
return false;
}
else
{
$ok = "/[a-za-z0-9]{1,40}/";
return (preg_match($ok, $pass))? True: False;
}
}
//is it valid e-mail?
Function check_mail($email)//sprawdza mail
{
$ok = "/[a-za-z0-9._-]+@[a-za-z0-9-]+\.[a-za-z]{2,4}/";
return (preg_match($ok, $email))? True: False;
}
//################### display functions #####################
//return shorter text (news ticker)
function short_text($text, $chars_limit)
{
if (strlen($text) > $chars_limit)
return substr($text, 0, strrpos(substr($text, 0, $chars_limit), " ")).'...';
else return $text;
}
//return text to news msg
function news_place() {
if($globals['subtopic'] == "latestnews") {
//add tickers to site - without it tickers will not be showed
//$news .= $globals['news_content'];
/*
//featured article
$layout_name = $globals['layout_name'];
$news .= ' <div id="featuredarticle" class="box">
<div class="corner-tl" style="background-image:url('.$layout_name.'/images/content/corner-tl.gif);"></div>
<div class="corner-tr" style="background-image:url('.$layout_name.'/images/content/corner-tr.gif);"></div>
<div class="border_1" style="background-image:url('.$layout_name.'/images/content/border-1.gif);"></div>
<div class="bordertitletext" style="background-image:url('.$layout_name.'/images/content/title-background-green.gif);"></div>
<img class="title" src="'.$layout_name.'/images/strings/headline-featuredarticle.gif" alt="contentbox headline" />
<div class="border_2">
<div class="border_3">
<div class="boxcontent" style="background-image:url('.$layout_name.'/images/content/scroll.gif);">
<div id=\'teaserthumbnail\'><img src="'.$layout_name.'/images/news/features.jpg" width=150 height=100 border=0 alt="" /></div><div id=\'teasertext\'><div style="position: Relative; top: -2px; margin-bottom: 2px;" >
<b>tutaj wpisz tytul</b></div>
tutaj wpisz tresc newsa<br>
zdjecie laduje sie w <i>tibiacom/images/news/features.jpg</i><br>
skad sie laduje mozesz zmienic linijke ponad komentarzem
</div> </div>
</div>
</div>
<div class="border_1" style="background-image:url('.$layout_name.'/images/content/border-1.gif);"></div>
<div class="cornerwrapper-b"><div class="corner-bl" style="background-image:url('.$layout_name.'/images/content/corner-bl.gif);"></div></div>
<div class="cornerwrapper-b"><div class="corner-br" style="background-image:url('.$layout_name.'/images/content/corner-br.gif);"></div></div>
</div>';
*/
}
return $news;
}
//set monster of week
function logo_monster() {
return str_replace(" ", "", trim(mb_strtolower($globals['layout_ini']['logo_monster'])));
}
$statustimeout = 1;
foreach(explode("*", str_replace(" ", "", $config['server']['statustimeout'])) as $status_var)
if($status_var > 0)
$statustimeout = $statustimeout * $status_var;
$statustimeout = $statustimeout / 1000;
$config['status'] = parse_ini_file('config/serverstatus');
if($config['status']['serverstatus_lastcheck']+$statustimeout < time())
{
$config['status']['serverstatus_checkinterval'] = $statustimeout+3;
$config['status']['serverstatus_lastcheck'] = time();
$info = chr(6).chr(0).chr(255).chr(255).'info';
$sock = @fsockopen("127.0.0.1", $config['server']['port'], $errno, $errstr, 1);
if ($sock)
{
fwrite($sock, $info);
$data='';
while (!feof($sock))
$data .= fgets($sock, 1024);
fclose($sock);
preg_match('/players online="(\d+)" max="(\d+)"/', $data, $matches);
$config['status']['serverstatus_online'] = 1;
$config['status']['serverstatus_players'] = $matches[1];
$config['status']['serverstatus_playersmax'] = $matches[2];
preg_match('/uptime="(\d+)"/', $data, $matches);
$h = floor($matches[1] / 3600);
$m = floor(($matches[1] - $h*3600) / 60);
$config['status']['serverstatus_uptime'] = $h.'h '.$m.'m';
preg_match('/monsters total="(\d+)"/', $data, $matches);
$config['status']['serverstatus_monsters'] = $matches[1];
}
else
{
$config['status']['serverstatus_online'] = 0;
$config['status']['serverstatus_players'] = 0;
$config['status']['serverstatus_playersmax'] = 0;
}
$file = fopen("config/serverstatus", "w");
foreach($config['status'] as $param => $data)
{
$file_data .= $param.' = "'.str_replace('"', '', $data).'"
';
}
rewind($file);
fwrite($file, $file_data);
fclose($file);
}
//page views counter
$views_counter = "usercounter.dat";
// checking if the file exists
if (file_exists($views_counter)) {
// het bestand bestaat, waarde + 1
$actie = fopen($views_counter, "r+");
$page_views = fgets($actie, 9);
$page_views++;
rewind($actie);
fputs($actie, $page_views, 9);
fclose($actie);
}
else
{
// the file doesn't exist, creating a new one with value 1
$actie = fopen($views_counter, "w");
$page_views = 1;
fputs($actie, $page_views, 9);
fclose($actie);
}
?>
