Website [Gesior] Rank Reset Please

ILex WilL · Fevereiro 9, 2023

Olá Gostaria de ajuda para colocar rank reset no gesior ao lado do Level, já vi alguns tópicos mas não deu certo.

Uso o AdvanceResetSystem 2.0:

Spoiler

--[[ <(Advanced Reset System 2.0)>

Autor: MarcelloMkez. Contato: ([email protected])
Versão: 2.0
Testado em: 8.50 e 8.60
TFS: 0.3.6 and 0.4.0
Fórum: http://www.xtibia.com/forum/topic/142463-advanced-reset-system-20/

-=[Características]=-
~( Versão 2.0 )~

- Resets agora Armazenados na DataBase; (Sem Valor de Storage)
- Instala o System e cria a Tabela de Resets com o comando "/installreset";
- Resets no Look do jogador ex: 22:10 You see Marcello [Reset 2] (Level 8). He is an elder druid.;
- [sTAGES] para "Premium Account" e "Free Account"; ]]

--=[Functions]=--

-- installReset()' [instala o Sistema.]
-- tableResetInstall()' [Verifica Se o Sistema ja foi instaladao.]
-- nowReseting()' [Verifica, retorna o erro ou reseta.]
-- getPlayerReset(cid)' [Pega numero de resets do player.]
-- checLevelStageReset(cid)' [Verifica o Level para Resetar.]
-- newReset(cid)' [Verifica todas as Condições de Reset.]
-- addValue(value)' [Adiciona numero de resets.]

--=[Comandos de Jogadores]=--
-- "/installreset" -- Só será usado uma vez, para instalar o sistema.
-- "!resetar" -- Para Resetar.

function onSay(cid, words, param)

if words =="!resetar" then

--[ Condições de Reset ] --
local coNdConf = {

needPz = true, -- Precisa estar em Pz pra resetar? [true, false]
needPa = false, -- Precisa ser Premium Account Pra resetar? [true, false]
withe = false, -- Players com Pk Withe podem resetar? [true, false]
red = false, -- Players com Pk Red pode resetar? [true, false]
battle = false, -- Players precisão estar sem battle pra resetar? [true, false]
teleport = false, -- Teleportar Player para o templo após resetar? [true, false]
look = true, -- Aparecer Resets no Look do Player? [true, false]
pid = getPlayerGUID(cid), -- Não Mexer.

--[ Configurações do Reset ] --
resetConf = {

Level = 50000, -- Level Necessário para Resetar. [Valor]
backLvl = 8, -- Level que voltará após o Reset. [Valor]
time = 3, -- Tempo para o Player deslogar ao resetar, em segundos. [Valor]

},
}
--[[>> STAGES <<]]--
x=true;X=true -- Não Mexer.
local stage = {Abilitar = {x}, Desabilitar = {}, --<< Abilitar Stages?? >>-- [{x};{}]

-- [RESETS] | [PREMMY] | [FREE]
stage1= {resets= 10, premmy= 50000, free= 50000},
stage2= {resets= 11, premmy= 60000, free= 60000}, -- EXPLICANDO e Configurando stages. (Se estiver Abilitado [Abilitar = {x}])
stage3= {resets= 30, premmy= 70000, free= 70000}, -- resets = Número de resets para o Stage;
stage4= {resets= 40, premmy= 80000, free= 80000}, -- premmy = Level necessário para Premium Accounts;
stage5= {resets= 60, premmy= 100000, free= 100000}, -- free = Level necessário para Free Accounts;
stage6= {resets= 29, premmy= 380, free= 390}, -- Coloque em Ordem...
stage7= {resets= 35, premmy= 400, free= 410}, -- [OBS: MARQUE UM "X" PARA ABILITAR OU DESABILITAR OS STAGES]
stage8= {resets= 40, premmy= 410, free= 440}, -- EX: para desabilitar mude: Abilitar = {}, Desabilitar = {x}
stage9= {resets= 45, premmy= 450, free= 450},
stage10={resets= 50, premmy= 465, free= 465},

}
--[[>> FIM STAGES <<]]--

--=[Pega Valor de Resets]=--
function getPlayerReset(cid)
local qr = db.getResult("SELECT `reset` FROM `players` WHERE `id`= "..coNdConf.pid..";")
rss = qr:getDataInt("reset", coNdConf.pid)
if rss < 0 then
rss = 0
end
return rss
end

local success = " ~~ Sucesso! ~~ \nVocê tem agora "..(getPlayerReset(cid)+1).." resets. \nVocê será deslogado em "..coNdConf.resetConf.time.." segundos." ;err = doPlayerSendTextMessage
local qrt = db.getResult("SELECT `reset` FROM `players` WHERE `id`= "..coNdConf.pid..";");rss_db = qrt:getDataInt("reset", coNdConf.pid)
local lvl_query = "UPDATE `players` SET `level` = "..(coNdConf.resetConf.backLvl)..", `experience` = 0 WHERE `id`= " .. coNdConf.pid .. ";"
local reset_query = "UPDATE `players` SET `reset` = "..(getPlayerReset(cid)+(1)).." WHERE `id`= " .. coNdConf.pid .. ";"
local nolook_query = "UPDATE `players` SET `description` = '' WHERE `players`.`id`= " .. coNdConf.pid .. ";"
local look_query = "UPDATE `players` SET `description` = ' [Reset "..(getPlayerReset(cid)+(1)).."]' WHERE `players`.`id`= " .. coNdConf.pid .. ";"

--=[Reseta]=--
function addValue(value)
if coNdConf.look == false then
doRemoveCreature(cid)
db.executeQuery(lvl_query);db.executeQuery(reset_query);db.executeQuery(nolook_query)
else
doRemoveCreature(cid)
db.executeQuery(lvl_query);db.executeQuery(reset_query);db.executeQuery(look_query)
return LUA_NO_ERROR
end
end

function nowReseting()
if (getPlayerLevel(cid) < coNdConf.resetConf.Level) then
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "- Level Necessário Para o Reset ["..coNdConf.resetConf.Level.."]. Faltam "..coNdConf.resetConf.Level-getPlayerLevel(cid).." level's para você Resetar. -")
return true
end
if getPlayerLevel(cid) >= coNdConf.resetConf.Level and (coNdConf.teleport == false) then
doPlayerPopupFYI(cid, success)
addEvent(addValue, coNdConf.resetConf.time*1000, value)
else
doPlayerPopupFYI(cid, success)
addEvent(doTeleportThing, coNdConf.resetConf.time*900, cid, getTownTemplePosition(getPlayerTown(cid)))
addEvent(addValue, coNdConf.resetConf.time*1000, value)
return true
end
end

--[sTAGES Nao mexer em nada.]--
function checkLevelStageReset(cid)

local stages = {
{resets= stage.stage1.resets, premmy= stage.stage1.premmy, free= stage.stage1.free},
{resets= stage.stage2.resets, premmy= stage.stage2.premmy, free= stage.stage2.free},
{resets= stage.stage3.resets, premmy= stage.stage3.premmy, free= stage.stage3.free},
{resets= stage.stage4.resets, premmy= stage.stage4.premmy, free= stage.stage4.free},
{resets= stage.stage5.resets, premmy= stage.stage5.premmy, free= stage.stage5.free},
{resets= stage.stage6.resets, premmy= stage.stage6.premmy, free= stage.stage6.free},
{resets= stage.stage7.resets, premmy= stage.stage7.premmy, free= stage.stage7.free},
{resets= stage.stage8.resets, premmy= stage.stage8.premmy, free= stage.stage8.free},
{resets= stage.stage9.resets, premmy= stage.stage9.premmy, free= stage.stage9.free},
{resets=stage.stage10.resets, premmy=stage.stage10.premmy, free=stage.stage10.free},
}
local resets = getPlayerReset(cid)
for i, tab in ipairs(stages) do
if resets <= tab.resets then
coNdConf.resetConf.Level = isPremium(cid) and tab.premmy or tab.free
break
end
end
if (getPlayerLevel(cid) < coNdConf.resetConf.Level) then
err(cid, MESSAGE_STATUS_CONSOLE_BLUE, "- Level Necessário Para o Reset ["..coNdConf.resetConf.Level.."]. Faltam "..coNdConf.resetConf.Level-getPlayerLevel(cid).." level's para você Resetar. -")
return TRUE
end

if getPlayerLevel(cid) >= coNdConf.resetConf.Level and (coNdConf.teleport == false) then
doPlayerPopupFYI(cid, success)
addEvent(addValue, coNdConf.resetConf.time*1000, value)
else
doPlayerPopupFYI(cid, success)
addEvent(addValue, coNdConf.resetConf.time*1000, value)
addEvent(doTeleportThing, coNdConf.resetConf.time*900, cid, getTownTemplePosition(getPlayerTown(cid)))
return true
end
end
function newReset(cid)
if(coNdConf.needPz == true) and (getTilePzInfo(getCreaturePosition(cid)) == LUA_ERROR) then
err(cid,MESSAGE_STATUS_CONSOLE_BLUE,"- Você Precisa estar em Protection Zone Para Resetar. -") return TRUE end
if(coNdConf.needPa == true) and not isPremium(cid) then
err(cid,MESSAGE_STATUS_CONSOLE_BLUE,"- Você Precisa ser Premium Account para Resetar. -") return TRUE end
if(coNdConf.withe == false) and (getCreatureSkullType(cid) == 3) then
err(cid,MESSAGE_STATUS_CONSOLE_BLUE,"- Você não pode resetar em condições de PK Withe. -") return TRUE end
if(coNdConf.red == false) and (getCreatureSkullType(cid) == 4) then
err(cid,MESSAGE_STATUS_CONSOLE_BLUE,"- Você não pode resetar em condições de PK Red. -") return TRUE end
if(coNdConf.battle == true) and (getCreatureCondition(cid, CONDITION_INFIGHT) == TRUE) then
err(cid,MESSAGE_STATUS_CONSOLE_BLUE,"- Você Precisa estar sem Battle para Resetar. -") return TRUE end

local xy = {true,false}
table.insert(stage.Abilitar, false)
table.insert(stage.Desabilitar, false)
if stage.Abilitar[1] == xy[1] and stage.Desabilitar[1] == xy[2] then
checkLevelStageReset(cid)
elseif stage.Abilitar[1] == xy[2] and stage.Desabilitar[1] == xy[1] then
nowReseting()
else
doPlayerPopupFYI(cid, "LUA_ERROR; Configure corretamente o Sistema de STAGES!")
end
return true
end
function tableResetInstall()
print(not rss_db and LUA_ERROR or "Tabela de Resets: Instalada ... [success] ")
addEvent(newReset, 1000, cid)
return false
end
if tableResetInstall() then
end
end
--=[install System]=--
function installReset()
if db.executeQuery("ALTER TABLE `players` ADD reset INT(11) NOT NULL DEFAULT 0;") then
print("[MarcelloMkez] -= Advanced Reset System 2.0 por DataBase =- Instalado com sucesso!")
return TRUE
end
print('[Advanced Reset System/MarcelloMkez] Não foi possível instalar o Sistema.')
return FALSE
end
local tt = {
"Preparando Instalação...",
"Instalando: TableReset Db...",
"Instalando: getPlayerReset()...",
"Instalando: addValue()...",
"Instalando: checkLevelStageReset()...",
"Instalando: newReset() and nowReseting()...",
"Finalizando Instalação...",
"...",
success = {
"Iniciando...",
"function: TableReset Db... [success]",
"function: getPlayerReset()... [success]",
"function: addValue(value)... [success]",
"function: checkLevelStageReset()... [success]",
"function: newReset() and nowReseting()... [success]",
"Fim da Instalação. ",
"by: ~~ MarcelloMkez ~~ \nContato: [email protected]",
inst = {"MarcelloMkez","Advanced Reset System 2.0 por DataBase"

},

}
if words == "/installreset" and getPlayerAccess(cid) >= 3 then
function install()
if installReset() then
print(""..tt.success[7].."")
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE,""..tt.success[8].."")
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "["..tt.success.inst[1].."] -="..tt.success.inst[2].."=- Instalado com sucesso!")
else
print("["..tt.success.inst[1].."] FALHA NA INSTALAÇÃO! [O sistema ja foi instalado].")
doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "["..tt.success.inst[1].."] FALHA NA INSTALAÇÃO! [O sistema ja foi instalado].")
end
return 1
end
function concl(cid)
local typetx = MESSAGE_STATUS_CONSOLE_BLUE
print(""..tt.success[7].."")
print(""..tt[8].."")
doPlayerSendTextMessage(cid, typetx,""..tt.success[7].."")
doPlayerSendTextMessage(cid, typetx,""..tt[8].."")
addEvent(install, 1000,cid)
end
function finall(cid)
local typetx = MESSAGE_STATUS_CONSOLE_BLUE
print(""..tt.success[6].."")
print(""..tt[7].."")
doPlayerSendTextMessage(cid, typetx,""..tt.success[6].."")
doPlayerSendTextMessage(cid, typetx,""..tt[7].."")
addEvent(concl, 3000,cid)
end
function installDd(cid)
local typetx = MESSAGE_STATUS_CONSOLE_BLUE
print(""..tt.success[5].."")
print(""..tt[6].."")
doPlayerSendTextMessage(cid, typetx,""..tt.success[5].."")
doPlayerSendTextMessage(cid, typetx,""..tt[6].."")
addEvent(finall, 1000,cid)
end
function installCc(cid)
local typetx = MESSAGE_STATUS_CONSOLE_BLUE
print(""..tt.success[4].."")
print(""..tt[5].."")
doPlayerSendTextMessage(cid, typetx,""..tt.success[4].."")
doPlayerSendTextMessage(cid, typetx,""..tt[5].."")
addEvent(installDd, 1000,cid)
end
function installBb(cid)
local typetx = MESSAGE_STATUS_CONSOLE_BLUE
print(""..tt.success[3].."")
print(""..tt[4].."")
doPlayerSendTextMessage(cid, typetx,""..tt.success[3].."")
doPlayerSendTextMessage(cid, typetx,""..tt[4].."")
addEvent(installCc, 1000,cid)
end
function installAa(cid)
local typetx = MESSAGE_STATUS_CONSOLE_BLUE
print(""..tt.success[2].."")
print(""..tt[3].."")
doPlayerSendTextMessage(cid, typetx,""..tt.success[2].."")
doPlayerSendTextMessage(cid, typetx,""..tt[3].."")
addEvent(installBb, 1000,cid)
end
function toInstall()
local typetx = MESSAGE_STATUS_CONSOLE_BLUE
print(""..tt.success[1].."")
print(""..tt[2].."")
doPlayerSendTextMessage(cid, typetx,""..tt.success[1].."")
doPlayerSendTextMessage(cid, typetx,""..tt[2].."")
addEvent(installAa, 1000,cid)
end
function preparation()
local typetx = MESSAGE_STATUS_CONSOLE_BLUE
print(""..tt[1].."")
doPlayerSendTextMessage(cid, typetx,""..tt[1].."")
addEvent(toInstall, 3000,cid)
end
if preparation() then
end
end
return 1
end
--=[by: MarcelloMkez]=--

e aqui está meu Layout.php:

Spoiler

<?php

   $update_interval = 1;
   if (!isset($world_id)) {
       $world_id = 0;
       $world_name = $config['server']['serverName'];
   }

   $order = $_REQUEST['order'];
   if($order == 'level')
       $orderby = 'level';
   elseif($order == 'vocation')
       $orderby = 'vocation';

   if(empty($orderby))
       $orderby = 'name';
       $tmp_file_name = 'cache/whoisonline-'.$orderby.'-'.$world_id.'.tmp';

   if(file_exists($tmp_file_name) && filemtime($tmp_file_name) > (time() - $update_interval)){
       $tmp_file_content = explode(",", file_get_contents($tmp_file_name));
       $number_of_players_online = $tmp_file_content[0];
       $players_rows = $tmp_file_content[1];
   } else{
       $players_online_data = $SQL->query('SELECT * FROM players WHERE world_id = '.(int) $world_id.' AND online > 0 ORDER BY '.$orderby);$number_of_players_online = 0;
       foreach($players_online_data as $player){
           $number_of_players_online++;
           $acc = $SQL->query('SELECT * FROM '.$SQL->tableName('accounts').' WHERE '.$SQL->fieldName('id').' = '.$player['account_id'].'')->fetch();
           if(is_int($number_of_players_online / 2))
               $bgcolor = $config['site']['darkborder'];
       }
   }

date_default_timezone_set('America/Sao_Paulo');

   $nextOpenTimes = array(
       'Sunday 21:00',
       'Monday 21:00',
       'Tuesday 21:00',
       'Wednesday 21:00',
       'Thursday 21:00',
       'Friday 21:00',
       'Saturday 21:00',
   );
   $daysOpen = array('Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat');

   function getNextCastleOpening($daysOpen, $nextOpenTimes)
   {
       if (in_array(date('D'), $daysOpen) && date('H') == '21' && date('M')) {
           return 0;
       }

       $openTimes = array();
       $currentTime = strtotime('now');
       foreach ($nextOpenTimes as $nextOpenTime) {
           $openTime = strtotime($nextOpenTime);
           if ($openTime < $currentTime) {
               continue;
           }

array_push($openTimes, $openTime - $currentTime);
}

       usort($openTimes, function($a, $b) {
       return $a > $b;
       });

return $openTimes[0];
}

$openTime = getNextCastleOpening($daysOpen, $nextOpenTimes);
$elementId = 'NextCastleOpening';

function anti_injection($sql){
       // remove palavras que contenham sintaxe sql
       $sql = preg_replace(sql_regcase("/(from|select|insert|delete|where|drop table|show tables|#|\*|--|\\\\)/"),"",$sql);
       $sql = trim($sql);//limpa espaços vazio
       $sql = strip_tags($sql);//tira tags html e php
       $sql = addslashes($sql);//Adiciona barras invertidas a uma string
       return $sql;
   }
?>
<html>
<head>
<link href="//use.fontawesome.com/releases/v5.0.6/css/all.css" rel="stylesheet">
<meta charset="utf-8">
<title><?PHP echo $title ?></title>
<meta name="description" content="Tibia is a free massively multiplayer online role-playing game (MMORPG)">
<meta name="author" content="Felipe">
<meta http-equiv="content-language" content="en">
<meta name="keywords" content="free online rpg, free mmorpg, mmorpg, mmog, online role playing game, online multiplayer game, internet game, online rpg, rpg">

<link rel="shortcut icon" href="<?PHP echo $layout_name; ?>/images/general/favicon.ico" type="image/x-icon">
<link rel="icon" href="<?PHP echo $layout_name; ?>/images/general/favicon.ico" type="image/x-icon">

<link href="<?PHP echo $layout_name; ?>/css/basic_d.css" rel="stylesheet" type="text/css">
<link href="<?PHP echo $layout_name; ?>/css/news.css" rel="stylesheet" type="text/css">

<body onBeforeUnLoad="SaveMenu();" onUnload="SaveMenu();" data-twttr-rendered="true">
<script type="text/javascript">
window.fbAsyncInit = function() {
FB.init({
appId : 497232093667125, // App ID
status : true, // check login status
cookie : true, // enable cookies to allow the server to access the session
xfbml : true // parse XFBML
});
FB.Event.subscribe('auth.login', function() {
var URLHelper = "?";
if (window.location.search.replace("?", "").length > 0) {
URLHelper = "&";
}
if (FB_TryLogin == 1) {
window.location = window.location + URLHelper + "step=facebooktrylogin&wasreloaded=1";
} else if (FB_TryLogin == 2) {
window.location = window.location + URLHelper + "page=facebooktrylogin&wasreloaded=1";
} else {
window.location = window.location + URLHelper + "wasreloaded=1";
}
});
FB.Event.subscribe('auth.logout', function(a_Response) {
if (a_Response.status !== 'connected') {
window.location.href=window.location.href;
} else {
/* nothing to do here*/
}
});
FB.Event.subscribe('auth.statusChange', function(response) {
if (FB_ForceReload == 1 && response.status == "connected") {
var URLHelper = "?";
if (window.location.search.replace("?", "").length > 0) {
URLHelper = "&";
}
window.location = window.location + URLHelper + "step=facebooktrylogin&wasreloaded=1";
}
});
};
(function(d){
var js, id = 'facebook-jssdk', ref = d.getElementsByTagName('script')[0];
if (d.getElementById(id)) {return;}
js = d.createElement('script'); js.id = id; js.async = true;
js.src = "//connect.facebook.net/en_US/all.js";
ref.parentNode.insertBefore(js, ref);
}(document));
</script>
<a name="top"></a>
<div id="MainHelper1">
   <div id="MainHelper2">
   <div id="ArtworkHelper1">
   <div id="ArtworkHelper2">
       
   </div>
   </div>
   <div id="DeactivationContainer" onclick="DisableDeactivationContainer();"></div>

<div id="Bodycontainer">
   <div id="ContentRow">
   <div id="MenuColumn">
   <div id="LeftArtwork">
       <a href="/?subtopic=latestnews">
                       <img id="TibiaLogoArtworkTop" src="<?PHP echo $layout_name; ?>/images/header/tibia-logo-artwork-top.gif" alt="logoartwork">
                   </a>
   </div>
           <?PHP include "loginbox.php"; ?>
               <?php include "downloadbox.php"; ?>
               <div id='Menu'>
<div id='MenuTop' style='background-image:url(<?PHP echo "$layout_name"; ?>/images/general/box-top.gif);'></div>
<div id='news' class='menuitem'>
<span onClick="MenuItemAction('news')">
<div class='MenuButton' style='background-image:url(<?PHP echo "$layout_name"; ?>/images/menu/button-background.gif);'>
<div onMouseOver='MouseOverMenuItem(this);' onMouseOut='MouseOutMenuItem(this);'><div class='Button' style='background-image:url(<?PHP echo "$layout_name"; ?>/images/menu/button-background-over.gif);'></div>
<span id='news_Lights' class='Lights'>
<div class='light_lu' style='background-image:url(<?PHP echo "$layout_name"; ?>/images/menu/green-light.gif);'></div>
<div class='light_ld' style='background-image:url(<?PHP echo "$layout_name"; ?>/images/menu/green-light.gif);'></div>
<div class='light_ru' style='background-image:url(<?PHP echo "$layout_name"; ?>/images/menu/green-light.gif);'></div>
</span>
       <div id="news_Icon" class="Icon" style="background-image:url(<?php echo $layout_name; ?>/images/global/menu/icon-news.gif);"></div>
<div id="community_Label" class="menufonts">News</div>
<div id='news_Extend' class='Extend' style='background-image:url(<?PHP echo "$layout_name"; ?>/images/general/plus.gif);'></div>
</div>
</div>
</span>
<div id="news_Submenu" class="Submenu">
                           <a href="?subtopic=latestnews">
                               <div id="submenu_latestnews" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                               <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                               <div id="ActiveSubmenuItemIcon_latestnews" class="ActiveSubmenuItemIcon" style="background-image: url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                               <div id="ActiveSubmenuItemLabel_latestnews" class="SubmenuitemLabel">Latest News</div>
                               <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                               </div>
                           </a>
                           <a href="?subtopic=archive">
                               <div id="submenu_archive" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                               <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                                   <div id="ActiveSubmenuItemIcon_archive" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                                   <div id="ActiveSubmenuItemLabel_archive" class="SubmenuitemLabel">News Archive</div>
                                   <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                               </div>
                           </a>
                           <a href="?subtopic=monster_boost">
                               <div id="submenu_monster_boost" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                               <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                                   <div id="ActiveSubmenuItemIcon_monster_boost" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                                   <div id="ActiveSubmenuItemLabel_monster_boost" class="SubmenuitemLabel">Monster Boost <img src="images/hot.gif"></div>
                                   <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                               </div>
                           </a>
                       </div>
                   </div>
               <div id="guilds" class="menuitem">
                   <span onclick="MenuItemAction('guilds')">
                   <div class='MenuButton' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/button-background.gif);'>
<div onMouseOver='MouseOverMenuItem(this);' onMouseOut='MouseOutMenuItem(this);'><div class='Button' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/button-background-over.gif);'></div>
<span id="wars_Lights" class="Lights">
<div class='light_lu' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/green-light.gif);'></div>
<div class='light_ld' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/green-light.gif);'></div>
<div class='light_ru' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/green-light.gif);'></div>
</span>
<div id="wars_Icon" class="Icon" style="background-image:url(<?php echo $layout_name; ?>/images/global/menu/icon-wars.gif);"></div>
<div id="wars_Label" class="menufonts">Wars</div>
       <div id="wars_Extend" class="Extend" style="background-image: url(<?PHP echo $layout_name; ?>/images/general/plus.gif);"></div>
</div>
</div>
</span>
               <div id="guilds_Submenu" class="Submenu">
                   <a href="?subtopic=guilds">
                       <div id="submenu_guilds" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                           <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                           <div id="ActiveSubmenuItemIcon_guilds" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                           <div id="ActiveSubmenuItemLabel_guilds" class="SubmenuitemLabel">Guilds</div>
                           <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       </div>
                   </a>
                   <a href="?subtopic=citywar">
                       <div id="submenu_citywar" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                           <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                           <div id="ActiveSubmenuItemIcon_citywar" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                           <div id="ActiveSubmenuItemLabel_citywar" class="SubmenuitemLabel"><font color="#ef0928">War Anti-Entrosa </font><img src="/layouts/tibiarl/images/battle.gif"></div>
                           <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       </div>
                   </a>
                   
                   <a href="?subtopic=wars">
                       <div id="submenu_wars" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                           <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                           <div id="ActiveSubmenuItemIcon_wars" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                           <div id="ActiveSubmenuItemLabel_wars" class="SubmenuitemLabel">War System <img src="/layouts/tibiarl/images/red-green.gif"></div>
                           <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       </div>
                   </a>
                   
               </div>
           </div>
               <div id="library" class="menuitem">
                   <span onclick="MenuItemAction('library')">
<div class='MenuButton' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/button-background.gif);'>
<div onMouseOver='MouseOverMenuItem(this);' onMouseOut='MouseOutMenuItem(this);'><div class='Button' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/button-background-over.gif);'></div>
<span id='library_Lights' class='Lights'>
<div class='light_lu' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/green-light.gif);'></div>
<div class='light_ld' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/green-light.gif);'></div>
<div class='light_ru' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/green-light.gif);'></div>
</span>
                                           <div id="library_Icon" class="Icon" style="background-image:url(<?php echo $layout_name; ?>/images/global/menu/icon-library.gif);"></div>
                                           <div id="community_Label" class="menufonts">Library</div>
<div id='library_Extend' class='Extend' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/plus.gif);'></div>
</div>
</div>
</span>
               <div id="library_Submenu" class="Submenu">
                   <a href="?subtopic=serverinfo">
                       <div id="submenu_serverinfo" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                           <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                           <div id="ActiveSubmenuItemIcon_serverinfo" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                           <div id="ActiveSubmenuItemLabel_serverinfo" class="SubmenuitemLabel">Server Info</div>
                           <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       </div>
                   </a>
                   
                   
                   
                   <a href="?subtopic=miningsystem">
                       <div id="submenu_mining" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                           <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                           <div id="ActiveSubmenuItemIcon_mining" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                           <div id="ActiveSubmenuItemLabel_mining" class="SubmenuitemLabel">Mining <img src="/images/hot.gif"></div>
                           <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       </div>
                   </a>
                   
                   
                   <a href="?subtopic=exerciseweapon"> 
                       <div id="submenu_exerciseweapon" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                           <div id="ActiveSubmenuItemIcon_exerciseweapon" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       </div>
                   </a>
                   <a href="?subtopic=founderaura"> 
                       <div id="submenu_founderaura" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                           <div id="ActiveSubmenuItemIcon_founderaura" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       </div>
                   </a>
                   <a href="?subtopic=founderoutfit"> 
                       <div id="submenu_founderoutfit" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                           <div id="ActiveSubmenuItemIcon_founderoutfit" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       </div>
                   </a>
                   <a href="?subtopic=experiencetable">
                       <div id="submenu_experiencetable" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                           <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                           <div id="ActiveSubmenuItemIcon_experiencetable" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                           <div id="ActiveSubmenuItemLabel_experiencetable" class="SubmenuitemLabel">Experience Table</div>
                           <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       </div>
                   </a>
               </div>
           </div>
           <div id="community" class="menuitem">
               <span onclick="MenuItemAction('community')">
<div class='MenuButton' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/button-background.gif);'>
<div onMouseOver='MouseOverMenuItem(this);' onMouseOut='MouseOutMenuItem(this);'><div class='Button' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/button-background-over.gif);'></div>
<span id='community_Lights' class='Lights'>
<div class='light_lu' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/green-light.gif);'></div>
<div class='light_ld' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/green-light.gif);'></div>
<div class='light_ru' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/green-light.gif);'></div>
</span>
                                           <div id="community_Icon" class="Icon" style="background-image:url(<?php echo $layout_name; ?>/images/global/menu/icon-community.gif);"></div>
<div id="community_Label" class="menufonts">Community</div>
<div id='community_Extend' class='Extend' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/plus.gif);'></div>

</div>
</div>
</span>
           <div id="community_Submenu" class="Submenu">
               <a href="?subtopic=characters">
                   <div id="submenu_characters" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_characters" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_characters" class="SubmenuitemLabel">Characters</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
               <a href="?subtopic=whoisonline">
                   <div id="submenu_whoisonline" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_whoisonline" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_whoisonline" class="SubmenuitemLabel">Who is online</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
               <a href="?subtopic=highscores">
                   <div id="submenu_highscores" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_highscores" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_highscores" class="SubmenuitemLabel">Highscores</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
               <a href="?subtopic=killstatistics">
                   <div id="submenu_killstatistics" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_killstatistics" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_killstatistics" class="SubmenuitemLabel">Kill Statistics</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
               <a href="?subtopic=houses">
                   <div id="submenu_houses" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_houses" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_houses" class="SubmenuitemLabel">Houses</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
               <a href="?subtopic=castsystem">
                   <div id="submenu_castsystem" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_castsystem" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_castsystem" class="SubmenuitemLabel">Cast System</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
               <a href="?subtopic=polls">
                   <div id="submenu_polls" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_polls" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_polls" class="SubmenuitemLabel">Polls</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
                               <a href="?subtopic=sellpoints">
                   <div id="submenu_sellpoints" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_sellpoints" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_sellpoints" class="SubmenuitemLabel">Pontos in Game</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
                                               <a href="?subtopic=loteria">
                   <div id="submenu_loteria" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_loteria" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_loteria" class="SubmenuitemLabel">Loteria VIP</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
           </div>
       </div>
       <div id="events" class="menuitem">
               <span onclick="MenuItemAction('events')">
                   <div class='MenuButton' style='background-image:url(./layouts/tibiarl/images/menu/button-background.gif);'>
<div onMouseOver='MouseOverMenuItem(this);' onMouseOut='MouseOutMenuItem(this);'><div class='Button' style='background-image:url(./layouts/tibiarl/images/menu/button-background-over.gif);'></div>
<span id='events_Lights' class='Lights'>
<div class='light_lu' style='background-image:url(./layouts/tibiarl/images/menu/green-light.gif);'></div>
<div class='light_ld' style='background-image:url(./layouts/tibiarl/images/menu/green-light.gif);'></div>
<div class='light_ru' style='background-image:url(./layouts/tibiarl/images/menu/green-light.gif);'></div>
</span>
                                           <div id="community_Icon" class="Icon" style="background-image:url(<?php echo $layout_name; ?>/images/global/menu/icon-events.gif);"></div>
<div id="community_Label" class="menufonts">Events</div>
<div id='events_Extend' class='Extend' style='background-image:url(./layouts/tibiarl/images/general/plus.gif);'></div>

   </div>
</div>
</span>
           <div id="events_Submenu" class="Submenu">
           
               <a href="?subtopic=dtt">
                   <div id="submenu_dtt" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_dtt" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_dtt" class="SubmenuitemLabel">Defend The Tower</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
               <a href="?subtopic=battlefield">
                   <div id="submenu_battlefield" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_battlefield" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_battlefield" class="SubmenuitemLabel">Battlefield</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
               <a href="?subtopic=snowball">
                   <div id="submenu_snowball" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_snowball" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_snowball" class="SubmenuitemLabel">SnowBall War</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
               <a href="?subtopic=boss">
                   <div id="submenu_boss" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_boss" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_boss" class="SubmenuitemLabel">Boss Stremoxy</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
                   <a href="?subtopic=ctf">
                   <div id="submenu_ctf" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_ctf" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_ctf" class="SubmenuitemLabel">Capture The Flag</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
               <a href="?subtopic=dtk">
                   <div id="submenu_dtk" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_dtk" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_dtk" class="SubmenuitemLabel">Defend The King</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
                   <a href="?subtopic=rtb">
                   <div id="submenu_rtb" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_rtb" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_rtb" class="SubmenuitemLabel">Real Team Battle</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
                   <a href="?subtopic=rushevent">
                   <div id="submenu_rushevent" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_rushevent" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_rushevent" class="SubmenuitemLabel">Rush Event</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
                                   <a href="?subtopic=safezone">
                   <div id="submenu_safezone" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_safezone" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_safezone" class="SubmenuitemLabel">SafeZone Event</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>

</div>
</div>
           <div id="forum" class="menuitem">
               <span onclick="MenuItemAction('forum')">
                   <div class='MenuButton' style='background-image:url(./layouts/tibiarl/images/menu/button-background.gif);'>
<div onMouseOver='MouseOverMenuItem(this);' onMouseOut='MouseOutMenuItem(this);'><div class='Button' style='background-image:url(./layouts/tibiarl/images/menu/button-background-over.gif);'></div>
<span id='forum_Lights' class='Lights'>
<div class='light_lu' style='background-image:url(./layouts/tibiarl/images/menu/green-light.gif);'></div>
<div class='light_ld' style='background-image:url(./layouts/tibiarl/images/menu/green-light.gif);'></div>
<div class='light_ru' style='background-image:url(./layouts/tibiarl/images/menu/green-light.gif);'></div>
</span>
                                       <div id="forum_Icon" class="Icon" style="background-image:url(<?php echo $layout_name; ?>/images/global/menu/icon-forum.gif);"></div>
                                       <div id="community_Label" class="menufonts">Forum</div>
<div id='forum_Extend' class='Extend' style='background-image:url(./layouts/tibiarl/images/general/plus.gif);'></div>

   </div>
</div>
</span>
           <div id="forum_Submenu" class="Submenu">
               <a href="?subtopic=forum">
                   <div id="submenu_forum" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_forum" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_forum" class="SubmenuitemLabel">Server Forum</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
           </div>
       </div>
           <div id="account" class="menuitem">
               <span onClick="MenuItemAction('account')">
<div class='MenuButton' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/button-background.gif);'>
<div onMouseOver='MouseOverMenuItem(this);' onMouseOut='MouseOutMenuItem(this);'><div class='Button' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/button-background-over.gif);'></div>
<span id='account_Lights' class='Lights'>
<div class='light_lu' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/green-light.gif);'></div>
<div class='light_ld' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/green-light.gif);'></div>
<div class='light_ru' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/green-light.gif);'></div>
</span>
                                       <div id="account_Icon" class="Icon" style="background-image:url(<?php echo $layout_name; ?>/images/global/menu/icon-account.gif);"></div>
                                       <div id="community_Label" class="menufonts">Account</div>
<div id='account_Extend' class='Extend' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/plus.gif);'></div>
</div>
</div>
</span>
           <div id="account_Submenu" class="Submenu">
           <?PHP
           if($group_id_of_acc_logged >= $config['site']['access_admin_panel']){
           ?>
               <a href="?subtopic=cpanel">
                   <div id="submenu_cpanel" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_cpanel" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_cpanel" class="SubmenuitemLabel"><font color=red>Admin Panel</font></div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
           <?PHP } ?>
               <a href="?subtopic=accountmanagement">
                   <div id="submenu_accountmanagement" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_accountmanagement" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_accountmanagement" class="SubmenuitemLabel">Account Management</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
               <a href="?subtopic=createaccount">
                   <div id="submenu_createaccount" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                   <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_createaccount" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_createaccount" class="SubmenuitemLabel">Create Account</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
               <?PHP
               if($config['site']['download_page']){
               ?>
               <a href="?subtopic=download">
                   <div id="submenu_download" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_download" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_download" class="SubmenuitemLabel"><font color="#00FFFF">Download Client</font></div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
               <?PHP } ?>
               <a href="?subtopic=lostaccount">
                   <div id="submenu_lostaccount" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_lostaccount" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_lostaccount" class="SubmenuitemLabel">Lost Account?</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
           </div>
       </div>
           <div id="team" class="menuitem">
               <span onclick="MenuItemAction('team')">
<div class='MenuButton' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/button-background.gif);'>
<div onMouseOver='MouseOverMenuItem(this);' onMouseOut='MouseOutMenuItem(this);'><div class='Button' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/button-background-over.gif);'></div>
<span id='team_Lights' class='Lights'>
<div class='light_lu' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/green-light.gif);'></div>
<div class='light_ld' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/green-light.gif);'></div>
<div class='light_ru' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/green-light.gif);'></div>
</span>
                                       <div id="support_Icon" class="Icon" style="background-image:url(<?php echo $layout_name; ?>/images/global/menu/icon-support.gif);"></div>
                                       <div id="community_Label" class="menufonts">Support</div>
<div id='team_Extend' class='Extend' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/plus.gif);'></div>
</div>
</div>
</span>

           <div id="team_Submenu" class="Submenu">
               <a href="?subtopic=ticket">
                   <div id="submenu_ticket" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_ticket" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_ticket" class="SubmenuitemLabel">Ticket <img class="ticket" src="/images/hot.gif"></div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
               <a href="?subtopic=tibiarules">
                   <div id="submenu_tibiarules" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_tibiarules" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_tibiarules" class="SubmenuitemLabel">Tibia Rules</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
               <a href="?subtopic=team">
                   <div id="submenu_team" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div class="LeftChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                       <div id="ActiveSubmenuItemIcon_team" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                       <div id="ActiveSubmenuItemLabel_team" class="SubmenuitemLabel">Support List</div>
                       <div class="RightChain" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);"></div>
                   </div>
               </a>
           </div>
       </div>
       <?PHP
           if($config['site']['shop_system']){
       ?>
           <div id="shops" class="menuitem">
               <span onclick="MenuItemAction('shops')">
<div class='MenuButton' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/button-background.gif);'>
<div onMouseOver='MouseOverMenuItem(this);' onMouseOut='MouseOutMenuItem(this);'><div class='Button' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/button-background-over.gif);'></div>
<span id='shops_Lights' class='Lights'>
<div class='light_lu' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/green-light.gif);'></div>
<div class='light_ld' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/green-light.gif);'></div>
<div class='light_ru' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/green-light.gif);'></div>
</span>
                                       <div id="shop_Icon" class="Icon" style="background-image:url(<?php echo $layout_name; ?>/images/global/menu/icon-shops.gif);"></div>
                                       <div id="community_Label" class="menufonts">Shop</div>
<div id='shops_Extend' class='Extend' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/plus.gif);'></div>
</div>
</div>
</span>
           <div id="shops_Submenu" class="Submenu">
               <a href='?subtopic=accountmanagement'>
                   <div id='submenu_donate' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'>
                   <div class='LeftChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
                       <div id='ActiveSubmenuItemIcon_donate' class='ActiveSubmenuItemIcon' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);'></div>
                       <div class='SubmenuitemLabel'><span style='color:yellow'><i class='fa fa-credit-card' aria-hidden='true'></i> Donatar</span></div>
                       <div class='RightChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
                   </div>
               </a>
               <a href='?subtopic=shopsystem'>
                   <div id='submenu_shopsystem' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'>
                       <div class='LeftChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
                       <div id='ActiveSubmenuItemIcon_shopsystem' class='ActiveSubmenuItemIcon' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);'></div>
                       <div class='SubmenuitemLabel'><span style='color:#00fb54'><i class='fa fa-shopping-cart' aria-hidden='true'></i> Shop Offer</span></div>
                       <div class='RightChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
                   </div>
               </a>
               <a href='?subtopic=shopguild'>
                   <div id='submenu_shopguild' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'>
                       <div class='LeftChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
                       <div id='ActiveSubmenuItemIcon_shopguild' class='ActiveSubmenuItemIcon' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);'></div>
                       <div class='SubmenuitemLabel'><span style='color:orange'><i class="fa fa-users" aria-hidden="true"></i> Shop Guild</span></div>
                       <div class='RightChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
                   </div>
               </a>
               <a href="?subtopic=pagconcluido"> 
                   <div id="submenu_pagconcluido" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div id="ActiveSubmenuItemIcon_pagconcluido" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                   </div>
               </a>
               <a href="?subtopic=paypalcancel"> 
                   <div id="submenu_paypalcancel" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div id="ActiveSubmenuItemIcon_paypalcancel" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                   </div>
               </a>
               <a href="?subtopic=paypalconcluido"> 
                   <div id="submenu_paypalconcluido" class="Submenuitem" onmouseover="MouseOverSubmenuItem(this)" onmouseout="MouseOutSubmenuItem(this)">
                       <div id="ActiveSubmenuItemIcon_paypalconcluido" class="ActiveSubmenuItemIcon" style="background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);"></div>
                   </div>
               </a>
               <?PHP
               if($logged){
               ?>
               <a href='?subtopic=shopsystem&action=show_history'>
                   <div id='submenu_show_history' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'>
                       <div class='LeftChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
                       <div id='ActiveSubmenuItemIcon_show_history' class='ActiveSubmenuItemIcon' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);'></div>
                       <div class='SubmenuitemLabel'>Shop History</div>
                       <div class='RightChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
                   </div>
               </a>
               <a href='?subtopic=shopguild&action=show_history'>
                   <div id='submenu_show_history' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'>
                       <div class='LeftChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
                       <div id='ActiveSubmenuItemIcon_show_history' class='ActiveSubmenuItemIcon' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);'></div>
                       <div class='SubmenuitemLabel'>Shop Guild History</div>
                       <div class='RightChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
                   </div>
               </a>
               <?PHP } ?>
               <?PHP
               if($group_id_of_acc_logged >= $config['site']['access_admin_panel']){
               ?>
               <a href='?subtopic=shopadmin'>
                   <div id='submenu_shopadmin' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'>
                       <div class='LeftChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
                       <div id='ActiveSubmenuItemIcon_shopadmin' class='ActiveSubmenuItemIcon' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);'></div>
                       <div class='SubmenuitemLabel'><font color=0099FF>Shop Admin</font></div>
                       <div class='RightChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
                   </div>
               </a>
               <a href='?subtopic=shopguildadmin'>
                   <div id='submenu_shopguildadmin' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'>
                       <div class='LeftChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
                       <div id='ActiveSubmenuItemIcon_shopguildadmin' class='ActiveSubmenuItemIcon' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);'></div>
                       <div class='SubmenuitemLabel'><font color=#EB8305>ShopGuild Admin</font></div>
                       <div class='RightChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
                   </div>
               </a>
               <?PHP } ?>
           </div>
       </div>
       <?PHP } ?>
       <div id="MenuBottom" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/box-bottom.gif);"></div>
       </div>
       <script type="text/javascript">InitializePage();</script></div>
               <div id="ContentColumn">
                   <div id="Content" class="Content">
                       <div id="ContentHelper">
                                       <style type="text/css" media="all">
                       /*CSS BY Leandro*/
                       #clockcontainer {
                           position: absolute;
                           display: block;
                           margin-left: 30%;
                           top: -150px;
                       }
                       #clockdiv {
                           font-family: sans-serif;
                           color: #5a2800;
                           font-weight: 100;
                           text-align: center;
                           font-size: 18px;
                           background: rgb(209, 190, 167);
                           padding: 8px;
                           border-radius: 5px;
                           border: 3px solid #5f4d41;
                           margin: 0 auto;
                           display: block;
                           width: 337px;
                       }

                       #clockdiv > div {
                           padding: 5px 10px;
                           background: #f1e0c6;
                           display: inline-block;
                           border: 2px solid #5f4d41;
                           border-radius: 5px;
                       }

                       #clockdiv div > span {
                           padding: 6px 6px;
                           border-radius: 3px;
                           background: #d4c0a1;
                           display: inline-block;
                           font-size: 34px;
                           width: 40px;
                       }

                       .smalltext {
                           padding-top: 5px;
                           font-size: 14px;
                       }
}
</style>
<?php if($config['site']['clockactive'] == true)
{
?>
   <div id="clockcontainer">
                       <div id="clockdiv">
                       <div class="" style="background: #540909;width: 98%;margin-left: -7px;margin-bottom: 5px;border: none !important;border-radius: 0 !important;">
                               <table border="0">
                                   <tbody>
                                       <tr>
                                           <td style="text-align: center;font-weight: bold;width: 319px;">
                                               <font color="white"><img alt="Cuckoo Clock.gif" src="https://www.tibiawiki.com.br/images/archive/c/c8/20121020213104%21Cuckoo_Clock.gif" width="32" height="32" style="position: absolute;margin-left: -43px;margin-top: -7px;">Tempo para Abertura<img alt="Cuckoo Clock.gif" src="https://www.tibiawiki.com.br/images/archive/c/c8/20121020213104%21Cuckoo_Clock.gif" width="32" height="32" style="position: absolute;margin-left: 10px;margin-top: -7px;"></font>
                                           </td>
                                       </tr>
                                   </tbody>
                               </table>
                           </div>
                       <div>
                           <span class="days"></span>
                           <div class="smalltext">Dias</div>
                       </div>
                       <div>
                           <span class="hours"></span>
                           <div class="smalltext">Horas</div>
                       </div>
                       <div>
                           <span class="minutes"></span>
                           <div class="smalltext">Minutos</div>
                       </div>
                       <div>
                           <span class="seconds"></span>
                           <div class="smalltext">Segundos</div>
                       </div>
                       </div>
                   </div>

<?php } ?>
   <script>
   function getTimeRemaining(a){var b=Date.parse(a)-Date.parse(new Date),c=Math.floor(b/1e3%60),d=Math.floor(b/1e3/60%60),e=Math.floor(b/36e5%24),f=Math.floor(b/864e5);return{total:b,days:f,hours:e,minutes:d,seconds:c}}function initializeClock(a,b){function h(){var a=getTimeRemaining(b);d.innerHTML=a.days,e.innerHTML=("0"+a.hours).slice(-2),f.innerHTML=("0"+a.minutes).slice(-2),g.innerHTML=("0"+a.seconds).slice(-2),a.total<=0&&clearInterval(i)}var c=document.getElementById(a),d=c.querySelector(".days"),e=c.querySelector(".hours"),f=c.querySelector(".minutes"),g=c.querySelector(".seconds");h();var i=setInterval(h,1e3)}var deadline="April 02 2020 19:00:00";initializeClock("clockdiv",deadline);

   </script>

<script type="text/javascript" src="<?PHP echo $layout_name; ?>/newsticker.js"></script>
               <?PHP echo $news_content; ?>
               <div id="news" class="Box">
               <div class="Corner-tl" style="background-image:url(<?PHP echo $layout_name; ?>/images/content/corner-tl.gif);"></div>
                   <div class="Corner-tr" style="background-image:url(<?PHP echo $layout_name; ?>/images/content/corner-tr.gif);"></div>
                   <div class="Border_1" style="background-image:url(<?PHP echo $layout_name; ?>/images/content/border-1.gif);"></div>
                   <div class="BorderTitleText" style="background-image:url(<?PHP echo $layout_name; ?>/images/content/title-background-green.gif);"></div>
               <img id="ContentBoxHeadline" class="Title" src="pages/headline.php?txt=<?PHP echo ucwords(str_replace('_', ' ', strtolower($subtopic))); ?>" alt="Contentbox headline">
               <div class="Border_2">
                   <div class="Border_3">
                   <div class="BoxContent" style="background-image:url(<?PHP echo $layout_name; ?>/images/content/scroll.gif);">
                               <?PHP echo $main_content; ?>
                   </div>
                   </div>
               </div>
                   <div class="Border_1" style="background-image:url(<?PHP echo $layout_name; ?>/images/content/border-1.gif);"></div>
                   <div class="CornerWrapper-b"><div class="Corner-bl" style="background-image:url(<?PHP echo $layout_name; ?>/images/content/corner-bl.gif);"></div></div>
                   <div class="CornerWrapper-b"><div class="Corner-br" style="background-image:url(<?PHP echo $layout_name; ?>/images/content/corner-br.gif);"></div></div>
               </div>
   <div id="ThemeboxesColumn">
   <div id="DeactivationContainerThemebox" onclick="DisableDeactivationContainer();"></div>
   <div id="RightArtwork">
       <img id="Monster" src="images/monster/Doomhowl.gif" onclick="window.location = #" alt="Monster of the Week">
       <img id="PedestalAndOnline" src="<?PHP echo $layout_name; ?>/images/header/pedestal-and-online.gif" alt="Monster Pedestal and Players Online Box">
       <div id="PlayersOnline" onClick="window.location='?subtopic=whoisonline'">
                           <?PHP
                           $existe = $SQL->query("SELECT COUNT(*) as online FROM `players` WHERE `online` = 1")->fetch();
                               echo '<b><font color="#ff6633">[ '.$existe['online'] . ' ]</font></b>';
                               echo '<br><b><font color="green">ONLINE</b><br></font>';
                           ?>
                       </div>
           </div>
   <div id="Themeboxes">
<?php

$skills = $SQL->query('SELECT * FROM players WHERE deleted = 0 AND group_id = 1 AND world_id = 0 AND account_id != 3 ORDER BY level DESC LIMIT 10');

?>

<style type="text/css" media="all">
.Toplevelbax {
top: -1px;
position: relative;
   margin-left: -15px;
margin-bottom: -10px;
width: 300px;
height: 440px;
}

.top_level_x
{
   position:absolute;
   top:15px;
   left:30px;
   height:290px;
   width:270px;
   z-index:20;
   text-align:center;
   padding-top:8px;
   font-family:Tahoma,Geneva,sans-serif;
   font-size:9.2pt;
   color:#fc3;
   font-weight:700;
   text-align:right;
   text-decoration:inherit;
   text-shadow:.1em .1em #333
}

a.topfonte
{
   font-family:Verdana,Arial,Helvetica;
   font-size:12px;
   color:#fc3;
   text-decoration:none
}

a:hover.topfonte
{
   font-family:Verdana,Arial,Helvetica;
   font-size:12px;
   color:#CCC;
   text-decoration:none
}

</style>
<div id="Topbar" class="Toplevelbax" style="background-image:url(<?PHP echo $layout_name; ?>/images/header/toplevel.png);">
<div class="top_level_x">
<?php

$a = 1;

foreach($skills as $skill) {

echo '
<div align="left"><a href="?subtopic=characters&name='.$skill['name'].'" class="topfonte">

<font color="white">    '.$a.' - </font>'.$skill['name'].'

<br>

<small><font color="white">      Level: ('.$skill['level'].')</font></small>

<br>

</a>

</div>';

$a++;

}

?>
</div>
</div><div id="Topbar" class="Toplevelbox" style="background-image:url(<?PHP echo $layout_name; ?>/images/themeboxes/top_level_top.gif);">
                               <div style="background:url(<?PHP echo $layout_name; ?>/images/themeboxes/castle/swords.gif);width: 32px;height: 32px;position: relative;margin-left: 10px;margin-top: -70px;"></div>
                               <span class="topleveltext">War Castle</span>
                               <div id="RankingBox" class="Themebox" style="height: auto;display: table;margin-top: 27px;">
                                   <div id="menusrank"></div>
                                   <table style="font-family: sans-serif; font-size: 12px; height: auto; display: block; background-image:url(<?PHP echo $layout_name; ?>/images/themeboxes/castle/box-bg.gif); margin-bottom: 5px; margin-top: -6px">
                                       <tr>
                                           <td style="">
                                               <div class="warText">
                                                   <?php
                               $castle = $SQL->query("SELECT * FROM `real_castle` ORDER BY `guild_id` DESC LIMIT 1")->fetchAll();
                               foreach($castle as $castles)
                               {
                                   setlocale(LC_ALL, 'pt_BR', 'pt_BR.utf-8', 'pt_BR.utf-8', 'portuguese');
                                   date_default_timezone_set('America/Sao_Paulo');
                                   $g_id = $SQL->query("SELECT * FROM `guilds` WHERE `id` = ".$castles["guild_id"]."")->fetch();
                                   echo '
                                   <a href="?subtopic=guilds&action=show&guild='.$castles["guild_id"].'">
                                       <div id="realcastleimg"><img src="guild_image.php?id='.$castles['guild_id'].'" width="64" height="64"></div>
                                       <div id="rtext">
                                           <a class="realcastlelink" href="?subtopic=guilds&action=show&guild='.$castles["guild_id"].'">'.$castles["guild_name"].'</a>
                                           <span class="guildtexthoras"><br><br>Próxima batalha:<br> '.$castles["tomorrow"].' às 21:00</span>
                                       </div>
                                   </a>';
                               }
                           ?>

<br>

                                               </div>
                                           </td>
                                       </tr>
                                   </table>
                                   <div class="Bottom3" style="background-image:url(<?PHP echo $layout_name; ?>/images/themeboxes/castle/box-bottom.gif);"></div>
                               </div>
                           </div>

                           
                           <div id="Suportbox" class="support" style="background-image: url('layouts/tibiarl/images/themeboxes/suportbox_mini.gif');">
                               <span class="topleveltext">Suporte</span>
                               <a href="/?subtopic=ticket" method="post" style="padding:0px;margin:0px;" >
                               <div class="ThemeboxButton" onmouseover="MouseOverBigButton(this);" onmouseout="MouseOutBigButton(this);" style="background-image: url('layouts/tibiarl/images/buttons/sbutton.gif');"><div class="BigButtonOver" style="background-image: url('layouts/tibiarl/images/buttons/sbutton_over.gif'); visibility: hidden;"></div>
                                   <div class="ButtonText" style="background-image: url('layouts/tibiarl/images/buttons/openticket.gif');"></div>
                               </div>
                               </a>
                           </div>

<?PHP
                               $time = time();
                               $viewpoll = $SQL->query("SELECT * FROM `z_polls` where end > '$time' ORDER BY id DESC LIMIT 1");
                               foreach($viewpoll as $p){
                               $polls .= '<center>'.$p['question'].'</center>';
                                   if(isset($p['id'])){
                                   echo '<div id="CurrentPollBox" class="Themebox" style="background-image:url('.$layout_name.'/images/themeboxes/current-poll/currentpollbox.gif);">
                                   <div id="CurrentPollText">'.$polls.'</div>
                                   <a class="ThemeboxButton" href="index.php?subtopic=polls&id= '.$p['id'].'" onMouseOver="MouseOverBigButton(this);" onMouseOut="MouseOutBigButton(this);" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif);"><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif);"></div>
                                       <div class="ButtonText" style="background-image:url('.$layout_name.'/images/buttons/_sbutton_votenow.gif);"></div>
                                   </a>
                                   <div class="Bottom" style="background-image:url('.$layout_name.'/images/general/box-bottom.gif);"></div>
                                   </div>';
                                   }
                               }
                       ?>

   </div>
   </div>
</div>
       </div>
<div id="Footer">
   Copyright by CipSoft GmbH. All rights reserved.<br>
           Edited by <b>RealBaiak</b>.
</div>
   </div>
</div>
</div>
</div>
</div>

<script type="text/javascript">
// disable all control elements which are not part of the content container element
if (g_Deactivated == true) {
document.getElementById('LoginButtonContainer').style.zIndex = "1";
document.getElementById('DeactivationContainer').style.display = "block";
document.getElementById('DeactivationContainer').style.zIndex = "50";
document.getElementById('DeactivationContainerThemebox').style.display = "block";
document.getElementById('Monster').style.cursor = "auto";
document.getElementById('PlayersOnline').style.cursor = "auto";
document.getElementById('ThemeboxesColumn').style.opacity = "0.30";
document.getElementById('ThemeboxesColumn').style.MozOpacity = "0.30";
document.getElementById('ThemeboxesColumn').filters.alpha.opacity = "0.75";
document.getElementById('ThemeboxesColumn').style.filter = "alpha(opacity=50); opacity: 0.30";
document.getElementById('Monster').setAttribute("onclick", "")
document.getElementById('PlayersOnline').setAttribute("onclick", "")
}
</script>
<script> $(document).ready(function() {
       var ajaxCall = function() {
           $.post("count.php", function( data ) { $( "#PlayersOnline" ).html( data ); });
       };
       setInterval(ajaxCall, 3000);
       });
   </script>
   <div id="HelperDivContainer" style="background-image: url(<?PHP echo $layout_name; ?>/images/content/scroll.gif);">
       <div class="HelperDivArrow" style="background-image: url(<?PHP echo $layout_name; ?>/images/content/helper-div-arrow.png);"></div>
       <div id="HelperDivHeadline"></div>
       <div id="HelperDivText"></div>
        <center>
           <img class="Ornament" src="<?PHP echo $layout_name; ?>/images/content/ornament.gif">
       </center>
   <br>
   </div>
</body>
</html>

Muvuka · Fevereiro 10, 2023

Gesior Rank Reset.rar

Editado Fevereiro 10, 2023 por Muvuka (veja o histórico de edições)

ILex WilL · Fevereiro 12, 2023

Onde eu coloco isso? Poderia me explicar?

Underewar · Fevereiro 12, 2023

12 horas atrás, ILex WilL disse:

Onde eu coloco isso? Poderia me explicar?

Você quer colocar no rank panel na home page? ou no na pagina /rank

ILex WilL · Fevereiro 12, 2023

4 horas atrás, Underewar disse:

Você quer colocar no rank panel na home page? ou no na pagina /rank

Isso na home pag, aqui no caso:

Ao Lado do Level

Underewar · Fevereiro 13, 2023

Me manda o script da widget

7 horas atrás, ILex WilL disse:

Isso na home pag, aqui no caso:

Ao Lado do Level

ILex WilL · Fevereiro 13, 2023

11 horas atrás, Underewar disse:

Me manda o script da widget

é o layout, não?

Underewar · Fevereiro 13, 2023

@edit

Vou fazer pra voce não tinha visto o layout.php no topico.

Pelo que entendi a sua table players ja possui a coluna resets certo?

Então basta adicionar esta linha no seu render

		<small><font color="white">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Resets: ('.$skill['reset'].')</font></small>
	

Tente melhorar os arquivos em php que você estiver editando, estão desorganizados.

Existem ferramentas para te ajudar nessa parte.
Vai te ajudar a entender os códigos.

Seria uma boa trocar o nome dessa variavel skills as skill por players as player.

Vou deixar o layout php atualizado aqui.

Para você entender como voce pode pegar dados da dabatase e colocar na sua tela.

Você vai precisar sempre procurar e armazenar esse dado, você pode fazer isso utilizando uma variavel, no caso do php para usar uma variavel.

Dentro de uma função php inicie a variavel com $ podemos utilizar o comando query do sql para pesquisar na database, precisamos passar algumas parametros o primeiro dele sendo oque nós estamos buscando nesse caso o * representa todos os dados da tabela players, que seria o segundo argumento ai então um terceiro argumento where ou seja selecionaremos todas as colunas da tabela players onde a coluna deleted seja = 0 e o group id seja 1(group_id do player no seu server)
Agora que ja temos nossa pesquisar armazenada em uma variavel podemos imprimir na tela do usuario.
- Crie uma tag e passe como valor dela a sua variavel de pesquisa
- lembrando que para usar o nome de uma variavel em uma tag html é preciso utllizar '.nomedavariavel['nomeDaColuna'].'

		<?php
	
				/* Podemos criar a variavel aqui dentro utilizando o $ : 
			
*/
						$Pesquisar_Todos_Players = $SQL->query('
					
						SELECT * FROM players 
					
						WHERE deleted = 0 AND group_id = 1 
					
						AND account_id != 1 ORDER BY level DESC LIMIT 5');
					
?>
								<small>
							
								<font color="white">Nome do player: ('.$Pesquisar_Todos_Players['name'].')
							
								</font>
							
								</small>

layout.php

Tente pesquisar oque ORDER BY level DESC LIMIT 5

Está parte ordena por level decrescente no maximo 5, tente pesquisar sobre as querys SQLS

Editado Fevereiro 13, 2023 por Underewar (veja o histórico de edições)

ILex WilL · Fevereiro 13, 2023

3 horas atrás, Underewar disse:

@edit

Vou fazer pra voce não tinha visto o layout.php no topico.

Pelo que entendi a sua table players ja possui a coluna resets certo?

Então basta adicionar esta linha no seu render

<small><font color="white">      Resets: ('.$skill['reset'].')</font></small>

Tente melhorar os arquivos em php que você estiver editando, estão desorganizados.

Existem ferramentas para te ajudar nessa parte.
Vai te ajudar a entender os códigos.

Seria uma boa trocar o nome dessa variavel skills as skill por players as player.

Vou deixar o layout php atualizado aqui.

Para você entender como voce pode pegar dados da dabatase e colocar na sua tela.

Você vai precisar sempre procurar e armazenar esse dado, você pode fazer isso utilizando uma variavel, no caso do php para usar uma variavel.

Dentro de uma função php inicie a variavel com $ podemos utilizar o comando query do sql para pesquisar na database, precisamos passar algumas parametros o primeiro dele sendo oque nós estamos buscando nesse caso o * representa todos os dados da tabela players, que seria o segundo argumento ai então um terceiro argumento where ou seja selecionaremos todas as colunas da tabela players onde a coluna deleted seja = 0 e o group id seja 1(group_id do player no seu server)

Agora que ja temos nossa pesquisar armazenada em uma variavel podemos imprimir na tela do usuario.

Crie uma tag e passe como valor dela a sua variavel de pesquisa

lembrando que para usar o nome de uma variavel em uma tag html é preciso utllizar '.nomedavariavel['nomeDaColuna'].'

<?php

/* Podemos criar a variavel aqui dentro utilizando o $ :

*/

$Pesquisar_Todos_Players = $SQL->query('

SELECT * FROM players

WHERE deleted = 0 AND group_id = 1

AND account_id != 1 ORDER BY level DESC LIMIT 5');

?>

<small>

<font color="white">Nome do player: ('.$Pesquisar_Todos_Players['name'].')

</font>

</small>

layout.php 88 kB · 1 download

Tente pesquisar oque ORDER BY level DESC LIMIT 5

Está parte ordena por level decrescente no maximo 5, tente pesquisar sobre as querys SQLS

Obrigado mano deu certo, obg pelas dicas tbm.

ficou assim:

coloquei esse codigo antes para o reset ser antes tbm, e tbm editei a parte, ORDER BY level DESC LIMIT 10, POR: ORDER BY reset DESC LIMIT 10, para os resets serem os primeiros.

E estou com mais 1 erro, Se puder me ajuda agradeço.

seguinte, na page dos player nao mostra os resets deles:

aqui esta meu Characters.php:

Spoiler

<?PHP
$main_content .='
<style type="text/css">
a.equipment{border:none;cursor:help}a.equipment img{border:none}a.equipment span{visibility:hidden;display:none}a.equipment:hover{position:relative;text-decoration:none}a:hover.equipment span{border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;box-shadow:3px 3px 3px rgba(0,0,0,.4);-webkit-box-shadow:3px 3px rgba(0,0,0,.4);-moz-box-shadow:3px 3px rgba(0,0,0,.4);font-family:Verdana,sans-serif;position:absolute;left:.25em;top:1.25em;z-index:99;background:#333;border:2px solid #111;font-weight:400;text-align:center;text-decoration:none;padding:.1em;width:175px;display:block;opacity:.95;filter:alpha(opacity=95);z-index:150}#equipment .EquipTitleNormal{font-size:12px;color:#1eff00}#equipment .EquipTitleMagical{font-size:12px;color:#0070dd}#equipment .EquipTitleDonation{font-size:12px;font-weight:700;color:yellow}#equipment .EquipText{font-size:10px;color:#fff}.CharAttrHeader{font-size:10px;font-weight:700;text-align:right;padding-right:5px;background:#d4c0a1}.CharAttrText{font-size:9px;text-align:left;background:#f1e0c6}.ItemSlotStroke{color:#fff;text-shadow:-1px -1px 0 #000,1px -1px 0 #000,-1px 1px 0 #000,1px 1px 0 #000;position:absolute;padding-top:18px;z-index:150}#equipment a:hover span,#equipment a:active span,#equipment a:focus span{visibility:visible}#equipment a:hover,#equipment a:focus{visibility:visible}

/* Looks great, now animating it */
background-size: 25px 14px, 100% 100%, 100% 100%;
-webkit-animation: move 5s linear 0 infinite;
}

@-webkit-keyframes move {
   0% {background-position: 0px 0px, 0 0, 0 0}
   100% {background-position: -100px 0px, 0 0, 0 0}
}
</style>
<script>
function imgError(image) {
   image.onerror = "";
   image.src = "/images/items/no.gif";
   return true;
}
</script>
<style>
.questbkinicial {
   background-image: url(images/equipment/quest_top_bk.png);
   width: 74.5%;
   height: 17px;
   margin-left: -21px;
   margin-top: -21px;
   position: absolute;
}
.questbox {
   width: 88%;
   height: 192px;
   border: 2px solid #423636;
   overflow: auto;
   margin: 0 auto 2px;
   padding: 19px;
   margin-bottom: 10px;
   margin-left: 5px;
   background-image: url(images/equipment/bktds.png);
   box-shadow: 0 5px 2px 0 rgba(0,0,0,0.42),0 8px 7px 0 rgba(0,0,0,0.2)!important;
}

.Content .BoxContent .questbox div {
   font-size: 9pt;
   font-weight: bold;
   color: #b5b5b5;
}
.questlisttext{
   margin-left: 5px;
   padding: 1px;
   color: #b5b5b5;
}
.questcompletedtext {
   color: #00bc48;
   font-size: 10px;
}
#scrolls::-webkit-scrollbar-thumb {
   border-radius: 3px;
   -webkit-box-shadow: inset 0 0 2px rgb(172, 172, 172);
}
#scrolls::-webkit-scrollbar {
   width: 15px;
   background-color: #272727;
}
#scrolls::-webkit-scrollbar-track {
   background-color: #272727;
}
#scrolls::-webkit-scrollbar-button {
   background-color: rgb(45, 42, 51);
}
.questcheast {
   background-image: url(images/equipment/quest_cheast.png);
   width: 200px;
   height: 200px;
   position: absolute;
   margin-left: 38%;
   opacity: 0.5;
   -webkit-filter: grayscale(100%);
}
.tasklistimg{
   background-image: url(images/equipment/task_list_img.png);
   width: 200px;
   height: 200px;
   position: absolute;
   margin-left: 38%;
   opacity: 0.5;
   -webkit-filter: grayscale(100%);
}
.questcolor {
   color: #9E9E9E;
}
.boxdepotitems {
   margin-bottom: 10px;
   margin-left: 0px;
   margin-top: 3px;
   margin: 3px;
   width: 32px;
   height: 32px;
   background: rgba(155, 155, 155, 0.53);
   border-radius: 10px;
   border: 1.5px solid #434040;
   box-shadow: inset 0px 0px 10px rgba(0,0,0,0.5);
}
</style>
';

date_default_timezone_set('America/Araguaina');
$name = stripslashes(ucwords(strtolower(trim($_REQUEST['name']))));
if(empty($name))
       $main_content .= 'Here you can get detailed information about a certain player on '.$config['server']['serverName'].'.<BR> <FORM AUTOCOMPLETE="OFF" ACTION="?subtopic=characters" METHOD=post>
   <div class="TableContainer">
       <div class="CaptionContainer">
           <div class="CaptionInnerContainer">
               <span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
               <span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
               <div class="Text">Search Character</div>
               <span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
               <span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
               <span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
                   </div>
                       </div>
                           <table class="Table5" cellpadding="0" cellspacing="0">
                               <tbody>
                                   <tr>
                                       <td>
                                       <div class="InnerTableContainer">
                                           <table style="width:100%;">
                                               <tbody>
                                               <tr>
                                                   <td>
                                                       <div class="TableShadowContainerRightTop" >
                                                           <div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rt.gif);" ></div>
                                                       </div>
                                                       <div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rm.gif);" >
                                                           <div class="TableContentContainer" >
<TABLE WIDTH=100% BORDER=0 CELLSPACING=0 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['darkborder'].'">
       <TABLE BORDER=0 CELLPADDING=0>
           <TR>
               <TD>Name:</TD>
               <TD><input name="name" maxlength="30" type="text" onkeyup="showResult(this.value)" class="custom-field" value="" /></TD>
               <TD><INPUT TYPE=image NAME="Submit" SRC="'.$layout_name.'/images/buttons/sbutton_submit.gif" BORDER=0 WIDTH=120 HEIGHT=18></TD>
           </TR>
           <tr>
           <td></td>
           <td style="max-height: 0px; display: inline-block;">   <div style="background-color: white; z-index: 1000; position: absolute; width: 170px;" class="" id="livesearch"></div></td>
           </tr>
       </TABLE></TD></TR></TABLE>
                                                           </div>
                                                       </div>
                                                       <div class="TableShadowContainer" >
                                                           <div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bm.gif);" >
                                                               <div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bl.gif);" ></div>
                                                               <div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-br.gif);" ></div>
                                                           </div>
                                                       </div>
                                                   </td>
                                               </tr>
                                           </div>
                                       </td>
                                   </tr>
                               </tbody>
                           </table>
                       </div>
                   </td>
               </tr>
           </tbody>
       </table>
   </div></FORM>';
else
{
   if(check_name($name))
   {
       $player = new Player();
       $player->find($name);
       if($player->isLoaded())
       {
           $account = $player->getAccount();
           $account_db = new Account();
           if($config['site']['show_flag'])
           {
               $flagg = $account->getCustomField("flag");
               $flag = '<image src="/images/flags/'.$flagg.'.gif"/> ';
           }
           $main_content .= '
   <div class="TableContainer">
       <div class="CaptionContainer">
           <div class="CaptionInnerContainer">
               <span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
               <span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
               <div class="Text">Character Information</div>
               <span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
               <span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
               <span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
                   </div>
                       </div>
                           <table class="Table5" cellpadding="0" cellspacing="0">
                               <tbody>
                                   <tr>
                                       <td>
                                       <div class="InnerTableContainer">
                                           <table style="width:100%;">
                                               <tbody>
                                               <tr>
                                                   <td>
                                                       <div class="TableShadowContainerRightTop" >
                                                           <div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rt.gif);" ></div>
                                                       </div>
                                                       <div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rm.gif);" >
                                                           <div class="TableContentContainer" >
           <TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100%><TR><TD></TD><TD><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>';
           if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
               $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD WIDTH=20% style="border:1px solid #faf0d7;">Name:</TD><TD style="border:1px solid #faf0d7;"><font color="';
               if ($group_id_of_acc_logged >= $config['site']['access_admin_panel'])
               $main_content .= '">'.$player->getName().' <small><b>[PlayerID</b>: '.$player->getID().'<b>]</b></font></small> <small><font size=1><b>[AccID</b>: '.$player->getAccountID().'<b>]</b><br><b>[AccName</b>: '.$account->getName().'<b>]</b> <b>[Email</b>: '.$account->getMail().'<b>]</b><br><b>[Password</b> <b>(</b><font size=1><font color=red>SHA1</font></font><b>)</b>: '.$account->getPassword().'<b>]</b> <b>[RK</b>: '.$account->getKey().'<b>]</b></font></small>';
           else
               $main_content .= '">'.$player->getName().'</font> '.$flag.'';
               $main_content .= ($player->isOnline()) ? '<img src="images/online.gif"/>' : '<img src="images/offline.gif"/>';
               if($player->isDeleted())
                   $main_content .= '<font color="red"> [DELETED]</font>';
               if($player->isNameLocked())
                   $main_content .= '<font color="red"> [NAMELOCK]</font>';
           /*
           if($player->getOldName())
           {
               if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
                   if($player->isNameLocked())
                       $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD style="border:1px solid #faf0d7;">Proposition:</TD><TD style="border:1px solid #faf0d7;">'.$player->getOldName().'</TD></TR>';
                   else
                       $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD style="border:1px solid #faf0d7;">Old name:</TD><TD style="border:1px solid #faf0d7;">'.$player->getOldName().'</TD></TR>';
           }
           */

           if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
               $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>Sex:</TD><TD>';
               $main_content .= ($player->getSex() == 0) ? 'female' : 'male';
               $main_content .= '</TD></TR>';
           if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
               $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>Profession:</TD><TD>' . htmlspecialchars(Website::getVocationName($player->getVocation(), $player->getPromotion())) . '</TD></TR>';
           if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
               $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>Level:</TD><TD>'.$player->getLevel().'</TD></TR>';
           if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
               $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD style="border:1px solid #faf0d7;">resets:</TD><TD style="border:1px solid #faf0d7;">'.$player->getPlayerGUID.'</TD></TR>';
           if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
               $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>World:</TD><TD>'.$config['site']['worlds'][$player->getWorld()].'</TD></TR>';
           if(!empty($towns_list[$player->getWorld()][$player->getTownId()]))
           {
               if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
                   $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD style="border:1px solid #faf0d7;">Residence:</TD><TD style="border:1px solid #faf0d7;">'.$towns_list[$player->getWorld()][$player->getTownId()].'</TD></TR>';
           }
           if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
               $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD style="border:1px solid #faf0d7;">Marital status:</TD><TD style="border:1px solid #faf0d7;">';
               $marriage = new Player();
               $marriage->load($player->getMarriage());
               if($marriage->isLoaded())
                   $main_content .= 'married to <a href="?subtopic=characters&name='.urlencode($marriage->getName()).'"><b>'.$marriage->getName().'</b></a></TD></TR>';
               else
                   $main_content .= 'single</TD></TR>';
           $house = $SQL->query( 'SELECT `houses`.`name`, `houses`.`town`, `houses`.`lastwarning` FROM `houses` WHERE `houses`.`world_id` = '.$player->getWorld().' AND `houses`.`owner` = '.$player->getId().';' )->fetchAll();
           if ( count( $house ) != 0 )
           {
               if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
                   $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD style="border:1px solid #faf0d7;">House:</TD><TD colspan="2" style="border:1px solid #faf0d7;">';
                   $main_content .= $house[0]['name'].' ('.$towns_list[$player->getWorld()][$house[0]['town']].') is paid until '.date("j M Y G:i", $house[0]['lastwarning']).'</TD></TR>';
           }
           $rank_of_player = $player->getRank();
           if(!empty($rank_of_player))
           {
               {
                   $guild_id = $rank_of_player->getGuild()->getId();
                   $guild_name = $rank_of_player->getGuild()->getName();
                   if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
               $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD style="border:1px solid #faf0d7;">Guild Membership:</TD><TD style="border:1px solid #faf0d7;">'.$rank_of_player->getName().' of the <a href="?subtopic=guilds&action=view&GuildName='.$guild_name.'">'.$guild_name.'</a></TD></TR>';
               }
           }
           if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
               $lastlogin = $player->getLastLogin();
               if(empty($lastlogin))
                   $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD style="border:1px solid #faf0d7;">Last login:</TD><TD colspan="2" style="border:1px solid #faf0d7;">Never logged in.</TD></TR>';
               else
                   $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD style="border:1px solid #faf0d7;">Last login:</TD><TD colspan="2" style="border:1px solid #faf0d7;">'.date("j F Y, g:i a", $lastlogin).'</TD></TR>';

           $comment = $player->getCustomField("comment");
           $newlines = array("\r\n", "\n", "\r");
           $comment_with_lines = str_replace($newlines, '<br />', $comment, $count);
           if($count < 50)
               $comment = $comment_with_lines;
           if(!empty($comment))
           {
               if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
               $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD VALIGN=top style="border:1px solid #faf0d7;">Comment:</TD><TD style="border:1px solid #faf0d7;">'.htmlspecialchars($comment).'</TD></TR>';
           }
           if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
               $account_status .= ($account->isPremium()) ? 'Premium Account' : 'Free Account';
               $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD style="border:1px solid #faf0d7;">Account Status:</TD><TD style="border:1px solid #faf0d7;">'.$account_status.'</TD></TR>';

if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD style="border:1px solid #faf0d7;">Balance:</TD><TD style="border:1px solid #faf0d7;"><font color="#00CD00"><b>$</b></font> '.number_format($player->getBalance(), 0 ,'','.').' <b>G</b>old <b>C</b>oins.</TD></TR>';

if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
// Equip

           $number_of_items = 1;
           $items = simplexml_load_file($config['site']['serverPath'].'/data/items/items.xml') or die('<b>Could not load items!</b>');
           $itemcont = 0;
foreach($items->item as $v)
$itemList[(int)$v['id']] = ucwords(strtolower($v['name']));
$itensname = $config['site']['itensname'];
               $list = array('2','1','3','6','4','5','9','7','10','8');
               $contentEquipment .='
               <style type="text/css">.signBgrnd{background-image:url(images/equipment/outfit.jpg);background-repeat:no-repeat;position:relative;float:left;left:9px;top:-37px;margin-top:38px;margin-bottom:-58px;padding:15px;height:202px;width:146px;box-shadow:0 10px 16px 0 rgba(0,0,0,0.42),0 6px 20px 0 rgba(0,0,0,0.3)!important}.signBgrnd .wep{position:absolute;top:90px;left:11px;width:32px;height:32px}.signBgrnd .wep img{background-image:url(\'images/items/bg.png\');max-width:100%}.signBgrnd .arm{position:absolute;top:76px;left:48px;width:32px;height:32px}.signBgrnd .arm img{background-image:url(\'images/items/bg.png\');max-width:100%}.signBgrnd .helm{position:absolute;top:39px;left:48px;width:32px;height:32px}.signBgrnd .helm img{background-image:url(\'images/items/bg.png\');max-width:100%}.signBgrnd .legs{position:absolute;top:113px;left:48px;width:32px;height:32px}.signBgrnd .legs img{background-image:url(\'images/items/bg.png\');max-width:100%}.signBgrnd .boots{position:absolute;top:150px;left:48px;width:32px;height:32px}.signBgrnd .boots img{background-image:url(\'images/items/bg.png\');max-width:100%}.signBgrnd .ring{position:absolute;top:127px;left:11px;width:32px;height:32px}.signBgrnd .ring img{background-image:url(\'images/items/bg.png\');max-width:100%}.signBgrnd .amulet{position:absolute;top:53px;left:11px;width:32px;height:32px}.signBgrnd .amulet img{background-image:url(\'images/items/bg.png\');max-width:100%}.signBgrnd .backpack{position:absolute;top:53px;left:85px;width:32px;height:32px}.signBgrnd .backpack img{background-image:url(\'images/items/bg.png\');max-width:100%}.signBgrnd .shield{position:absolute;top:90px;left:85px;width:32px;height:32px}.signBgrnd .shield img{background-image:url(\'images/items/bg.png\');max-width:100%}.signBgrnd .arrow{position:absolute;top:127px;left:85px;width:32px;height:32px}.signBgrnd .arrow img{background-image:url(\'images/items/bg.png\');max-width:100%}.signBgrnd .cap{position:absolute;top:162px;left:89px;width:32px;height:32px;font-size:6.3pt;font-family:inherit;text-shadow:-1px -1px 0 rgba(0,0,0,0.50),1px -1px 0 rgba(0,0,0,0.50),-1px 1px 0 rgba(0,0,0,0.50),1px 1px 0 rgba(0,0,0,0.50);font-weight:400;color:rgba(255,255,255,0.61);font-weight:bold}.signBgrnd .soul{position:absolute;top:162px;left:15px;width:32px;height:32px;font-size:6.3pt;font-family:inherit;text-shadow:-1px -1px 0 rgba(0,0,0,0.50),1px -1px 0 rgba(0,0,0,0.50),-1px 1px 0 rgba(0,0,0,0.50),1px 1px 0 rgba(0,0,0,0.50);color:rgba(255,255,255,0.61);font-weight:700}</style>';
           if ($get_ativaEquips['ativaEquips'] == 0 || $group_id_of_acc_logged >= $config['site']['access_admin_panel']) {
               $contentEquipment .= '<div id="equipment" class="signBgrnd">';
               foreach ($list as $pid => $name)
               {
                   $top = $SQL->query('SELECT * FROM player_items WHERE player_id = '.$player->getId().' AND pid = '.$list[$pid].' AND itemtype;')->fetch();
                   if($top[itemtype] == true)
                   {
                       if($list[$pid] == '1')
                       {
                           $contentEquipment .= '<div class="helm"><a class="equipment" style="text-align:center;"><span class="itemStroke">1</span></a><a class="equipment">
       <img onerror="imgError(this);" src="images/items/'.$top[itemtype].'.gif"/><span><font class="EquipTitleDonation">'.$itemList[(int)$top[itemtype]].'</font><br>' .(($top['count'] >= 2) ? '<font class="EquipText"><b>Quantidade:</b> '.$top['count'].'<br/>' : '').'</font>   <font class="EquipText">'.$itensname[$top[itemtype]].'</font></font></span></a></div>';
                       }
                       elseif($list[$pid] == '2')
                       {
                           $contentEquipment .= '<div class="amulet"><a class="equipment" style="text-align:center;"><span class="itemStroke">1</span></a><a class="equipment">
       <img onerror="imgError(this);" src="images/items/'.$top[itemtype].'.gif"/><span><font class="EquipTitleDonation">'.$itemList[(int)$top[itemtype]].'</font><br>' .(($top['count'] >= 2) ? '<font class="EquipText"><b>Quantidade:</b> '.$top['count'].'<br/>' : '').'</font>   <font class="EquipText">'.$itensname[$top[itemtype]].'</font></font></span></a></div>';
                       }
                       elseif($list[$pid] == '3')
                       {
                           $contentEquipment .= '<div class="backpack"><a class="equipment" style="text-align:center;"><span class="itemStroke">1</span></a><a class="equipment">
       <img onerror="imgError(this);" src="images/items/'.$top[itemtype].'.gif"/><span><font class="EquipTitleDonation">'.$itemList[(int)$top[itemtype]].'</font><br>' .(($top['count'] >= 2) ? '<font class="EquipText"><b>Quantidade:</b> '.$top['count'].'<br/>' : '').'</font>   <font class="EquipText">'.$itensname[$top[itemtype]].'</font></font></span></a></div>';
                       }
                       elseif($list[$pid] == '4')
                       {
                           $contentEquipment .= '<div class="arm"><a class="equipment" style="text-align:center;"><span class="itemStroke">1</span></a><a class="equipment">
       <img onerror="imgError(this);" src="images/items/'.$top[itemtype].'.gif"/><span><font class="EquipTitleDonation">'.$itemList[(int)$top[itemtype]].'</font><br>' .(($top['count'] >= 2) ? '<font class="EquipText"><b>Quantidade:</b> '.$top['count'].'<br/>' : '').'</font>   <font class="EquipText">'.$itensname[$top[itemtype]].'</font></font></span></a></div>';
                       }
                       elseif($list[$pid] == '5')
                       {
                           $contentEquipment .= '<div class="shield"><a class="equipment" style="text-align:center;"><span class="itemStroke">1</span></a><a class="equipment">
       <img onerror="imgError(this);" src="images/items/'.$top[itemtype].'.gif"/><span><font class="EquipTitleDonation">'.$itemList[(int)$top[itemtype]].'</font><br>' .(($top['count'] >= 2) ? '<font class="EquipText"><b>Quantidade:</b> '.$top['count'].'<br/>' : '').'</font>   <font class="EquipText">'.$itensname[$top[itemtype]].'</font></font></span></a></div>';
                       }
                       elseif($list[$pid] == '6')
                       {
                           $contentEquipment .= '<div class="wep"><a class="equipment" style="text-align:center;"><span class="itemStroke">1</span></a><a class="equipment">
       <img onerror="imgError(this);" src="images/items/'.$top[itemtype].'.gif"/><span><font class="EquipTitleDonation">'.$itemList[(int)$top[itemtype]].'</font><br>' .(($top['count'] >= 2) ? '<font class="EquipText"><b>Quantidade:</b> '.$top['count'].'<br/>' : '').'</font>   <font class="EquipText">'.$itensname[$top[itemtype]].'</font></font></span></a></div>';
                       }
                       elseif($list[$pid] == '7')
                       {
                           $contentEquipment .= '<div class="legs"><a class="equipment" style="text-align:center;"><span class="itemStroke">1</span></a><a class="equipment">
       <img onerror="imgError(this);" src="images/items/'.$top[itemtype].'.gif"/><span><font class="EquipTitleDonation">'.$itemList[(int)$top[itemtype]].'</font><br>' .(($top['count'] >= 2) ? '<font class="EquipText"><b>Quantidade:</b> '.$top['count'].'<br/>' : '').'</font>   <font class="EquipText">'.$itensname[$top[itemtype]].'</font></font></span></a></div>';
                       }
                       elseif($list[$pid] == '8')
                       {
                           $contentEquipment .= '<div class="boots"><a class="equipment" style="text-align:center;"><span class="itemStroke">1</span></a><a class="equipment">
       <img onerror="imgError(this);" src="images/items/'.$top[itemtype].'.gif"/><span><font class="EquipTitleDonation">'.$itemList[(int)$top[itemtype]].'</font><br>' .(($top['count'] >= 2) ? '<font class="EquipText"><b>Quantidade:</b> '.$top['count'].'<br/>' : '').'</font>   <font class="EquipText">'.$itensname[$top[itemtype]].'</font></font></span></a></div>';
                       }
                       elseif($list[$pid] == '9')
                       {
                           $contentEquipment .= '<div class="ring"><a class="equipment" style="text-align:center;"><span class="itemStroke">1</span></a><a class="equipment">
       <img onerror="imgError(this);" src="images/items/'.$top[itemtype].'.gif"/><span><font class="EquipTitleDonation">'.$itemList[(int)$top[itemtype]].'</font><br>' .(($top['count'] >= 2) ? '<font class="EquipText"><b>Quantidade:</b> '.$top['count'].'<br/>' : '').'</font>   <font class="EquipText">'.$itensname[$top[itemtype]].'</font></font></span></a></div>';
                       }
                       elseif($list[$pid] == '10')
                       {
                           $contentEquipment .= '<div class="arrow"><a class="equipment" style="text-align:center;"><span class="itemStroke">1</span></a><a class="equipment">
       <img onerror="imgError(this);" src="images/items/'.$top[itemtype].'.gif"/><span><font class="EquipTitleDonation">'.$itemList[(int)$top[itemtype]].'</font><br>' .(($top['count'] >= 2) ? '<font class="EquipText"><b>Quantidade:</b> '.$top['count'].'<br/>' : '').'</font>   <font class="EquipText">'.$itensname[$top[itemtype]].'</font></font></span></a></div>';
                       }
                       $contentEquipment .= '<div class="cap"><a class="equipment" style=" color: rgb(199, 197, 193)";>Cap:<br>'.$player->getcap().'<span><font class="EquipTitleDonation">Cap:</font><br>   <font class="EquipText">'.$player->getcap().'</font></span></a></div>';
                       $contentEquipment .= '<div class="soul"><a class="equipment" style=" color: rgb(199, 197, 193)";>Soul:<br>'.$player->getsoul().'<span><font class="EquipTitleDonation">Soul:</font><br>   <font class="EquipText">'.$player->getsoul().'</font></span></a></div>';
                   }
               }
               $hp = ($player->getHealth() / $player->getHealthMax() * 100);
               $mana = ($player->getMana() / $player->getManaMax() * 100);
               $contentEquipment .= '</div>';
           }

               $contentEquipment .= '<style>/* CSS by Leandro */.manapercent {width: '.$mana.'%;max-width: 100%;margin-left: 36.2px;height: 5px;position: absolute;margin-top: 20px;}.lifebarpercent {width: '.$hp.'%;max-width: 100%;margin-left: 36.2px;height: 5px;position: absolute;margin-top: 7px;}.hptext{position:absolute;font-size:8pt;margin-left:102px;margin-top:-1px;font-weight:700;color:#b5b5b5}.manatext{position:absolute;font-size:8pt;margin-left:102px;margin-top:-1px;font-weight:700;color:#b5b5b5}.lifebarbk{background:url(images/equipment/lifebarra.png);height:12px;border-radius:10px;max-width:13.5%}.manabk{background:url(images/equipment/manabar.png);height:12px;border-radius:10px;max-width:13.5%}.SkillsBgrnd{background-image:url(images/equipment/skillsbackground.png);background-repeat:no-repeat;position:relative;float:left;left:18px;top:-37px;margin-top:38px;margin-bottom:-23px;padding:15px;height:202px;width:154px;box-shadow:0 10px 16px 0 rgba(0,0,0,0.42),0 6px 20px 0 rgba(0,0,0,0.3)!important}.SkillsBgrnd .exp{position:absolute;font-size:7pt;font-weight:700;color:#b5b5b5;margin:0 auto;width:145px;text-align:right}.SkillsBgrnd .level{position:absolute;margin:0 auto;width:145px;text-align:right;margin-top:13px;margin-bottom:1px;font-size:7pt;font-weight:700;color:#b5b5b5}.SkillsBgrnd .hitpoints{position:absolute;margin:0 auto;width:145px;text-align:right;margin-top:28px;font-size:7pt;font-weight:700;color:#b5b5b5}.SkillsBgrnd .mana{position:absolute;margin:0 auto;width:145px;text-align:right;margin-top:42px;font-size:7pt;font-weight:700;color:#b5b5b5}.SkillsBgrnd .soul{position:absolute;margin:0 auto;width:145px;text-align:right;margin-top:56px;font-size:7pt;font-weight:700;color:#b5b5b5}.SkillsBgrnd .cap{position:absolute;margin:0 auto;width:145px;text-align:right;margin-top:70px;margin-bottom:1px;font-size:7pt;font-weight:700;color:#b5b5b5}.SkillsBgrnd .stamina{position:absolute;margin:0 auto;width:145px;text-align:right;margin-top:84px;margin-bottom:3px;font-size:7pt;font-weight:700;color:#b5b5b5}.SkillsBgrnd .magiclevel{position:absolute;margin:0 auto;width:145px;text-align:right;margin-top:98px;font-size:7pt;font-weight:700;color:#b5b5b5}.SkillsBgrnd .Fist{position:absolute;margin:0 auto;width:145px;text-align:right;margin-top:116px;font-size:7pt;font-weight:700;color:#b5b5b5}.SkillsBgrnd .Club{position:absolute;margin:0 auto;width:145px;text-align:right;margin-top:130px;font-size:7pt;font-weight:700;color:#b5b5b5}.SkillsBgrnd .Sword{position:absolute;margin:0 auto;width:145px;text-align:right;margin-top:145px;font-size:7pt;font-weight:700;color:#b5b5b5}.SkillsBgrnd .Axe{position:absolute;margin:0 auto;width:145px;text-align:right;margin-top:159px;font-size:7pt;font-weight:700;color:#b5b5b5}.SkillsBgrnd .Distance{position:absolute;margin:0 auto;width:145px;text-align:right;margin-top:172px;font-size:7pt;font-weight:700;color:#b5b5b5}.SkillsBgrnd .Shield{position:absolute;margin:0 auto;width:145px;text-align:right;margin-top:186px;font-size:7pt;font-weight:700;color:#b5b5b5}.SkillsBgrnd .Fishing{position:absolute;margin:0 auto;width:145px;text-align:right;margin-top:200px;font-size:7pt;font-weight:700;color:#b5b5b5}.OutfitBgrnd{background-image:url(images/equipment/outfitbackgrounds.jpg);background-repeat:no-repeat;position:relative;float:left;left:27px;top:-37px;margin-top:38px;margin-bottom:-25px;padding:15px 0;height:202px;width:178px;box-shadow:0 10px 16px 0 rgba(0,0,0,0.42),0 6px 20px 0 rgba(0,0,0,0.3)!important}.OutfitBgrnd img{margin-left:-27px !important;margin-top:-32px !important}.OutfitBgrnd .grayimg{filter:none;-webkit-filter:grayscale(100%);-moz-filter:grayscale(100%);-ms-filter:grayscale(100%);-o-filter:grayscale(100%);opacity:.5;filter:alpha(opacity=50);margin-left:-25pt;margin-top:-25px}.OutfitBgrnd .OutfitPlayer{margin:0;height:64px;width:64px}.OutfitBgrnd .OutfitName{position:absolute;margin:0 auto;width:145px;height:10px;text-align:center;top:203px;font-size:8pt;font-weight:700;color:#b5b5b5}</style><div class="lifebarpercent"><span class="hptext">'.$player->getHealth().'</span><div class="lifebarbk"></div></div></div><div class="manapercent"><span class="manatext">'.$player->getMana().'</span><div class="manabk"></div></div></div>';//Skills By Leandro

           //Stamina by leandro
           function getStamina($value){
               $h = floor($value / 3600000);
               $m = floor(($value - $h * 3600000) / 60000);
               if($m == '0') {
                   $m = '00';
               }
               $zero = array (1 => 1,2 => 2,3 => 3,4 => 4,5 => 5,6 => 6,7 => 7,8 => 8,9 => 9);
               if ($m == $zero[$m]) {
                   $m = '0'.$m;
               }
               return $h.':'.$m;
               }

               $stamina = ($player->getStamina() / 151200000 *42);
               if ((gmdate("s", $stamina)) >= (gmdate("s", "40")))
               $sorange = 'lime';
               if ((gmdate("s", $stamina)) <= (gmdate("s", "40")))
               $sorange = 'orange';
               if ((gmdate("s", $stamina)) <= (gmdate("s", "14")))
               $sorange = 'red';

           $contentEquipment .= '<table><div id="equipment" class="SkillsBgrnd"><div class="exp">'.number_format($player->getExperience()).'</div><div class="level">'.$player->getLevel().'</div><div class="hitpoints"><font style="text-shadow: -1px -1px 0 rgba(0,0,0,0.50),1px -1px 0 rgba(0,0,0,0.50),-1px 1px 0 rgba(0,0,0,0.50),1px 1px 0 rgba(0,0,0,0.50);" color="red">'.number_format($player->getHealth()).'</font></div><div class="mana"><font style="text-shadow: -1px -1px 0 rgba(0,0,0,0.50),1px -1px 0 rgba(0,0,0,0.50),-1px 1px 0 rgba(0,0,0,0.50),1px 1px 0 rgba(0,0,0,0.50);" color="DodgerBlue">'.number_format($player->getMana()).'</font></div><div class="soul">'.$player->getsoul().'</div><div class="cap">'.number_format($player->getcap()).'</div><div class="stamina"><font style="text-shadow: -1px -1px 0 rgba(0,0,0,0.50),1px -1px 0 rgba(0,0,0,0.50),-1px 1px 0 rgba(0,0,0,0.50),1px 1px 0 rgba(0,0,0,0.50);" color="'.$sorange.'">'.getStamina($player->getStamina()).'</font></div><div class="magiclevel">'.$player->getMagLevel().'</div><div class="Fist">'.$player->getSkill(0).'</div><div class="Club">'.$player->getSkill(1).'</div><div class="Sword">'.$player->getSkill(2).'</div><div class="Axe">'.$player->getSkill(3).'</div><div class="Distance">'.$player->getSkill(4).'</div><div class="Shield">'.$player->getSkill(5).'</div><div class="Fishing">'.$player->getSkill(6).'</div>       </div></table>';

               //Outfits By Leandro
               $outfitsfemale = array(
                   65539 => 136, //citizen
                   131075 => 137, //hunter
                   196611 => 141, //mage
                   262147 => 139, //knight
                   327683 => 140, //nobleman
                   393219 => 138, //summoner
                   458755 => 142, //warrior
                   524291 => 147, //barbarian
                   589827 => 148, //druid
                   655363 => 149, //wizard
                   720899 => 150, //oriental
                   786435 => 155, //pirate
                   851971 => 156, //assassin
                   917507 => 157, //beggar
                   983043 => 158, //shaman
                   1048579 => 252, //norseman
                   1114115 => 269, //nightmare
                   1179651 => 270, //jester
                   1245187 => 279, //brotherhood
                   1310723 => 288, //demonhunter
                   1376259 => 324, //yalaharian
                   1441795 => 336, //warmaster
                   1507331 => 366 //wayfarer
               ); // storages

               $outfitsmale = array(
                   65539 => 128, //citizen
                   131075 => 129, //hunter
                   196611 => 130, //mage
                   262147 => 131, //knight
                   327683 => 132, //nobleman
                   393219 => 133, //summoner
                   458755 => 134, //warrior
                   524291 => 143, //barbarian
                   589827 => 144, //druid
                   655363 => 145, //wizard
                   720899 => 146, //oriental
                   786435 => 151, //pirate
                   851971 => 152, //assassin
                   917507 => 153, //beggar
                   983043 => 154, //shaman
                   1048579 => 251, //norseman
                   1114115 => 268, //nightmare
                   1179651 => 273, //jester
                   1245187 => 278, //brotherhood
                   1310723 => 289, //demonhunter
                   1376259 => 325, //yalaharian
                   1441795 => 335, //warmaster
                   1507331 => 367 //wayfarer
               ); // storages

               if ($player->getSex() == 1) $outfitskeys = $outfitsmale;
               else $outfitskeys = $outfitsfemale;

               $contentEquipment .= '
               <table>
                   <div id="equipment" class="OutfitBgrnd">';

                       $contentEquipment .= '
                       <div style="text-align: center;margin-top: 11px;">';
                           foreach ($outfitskeys as $outfits => $id)
                           {
                               $outfitquery = $SQL->query("SELECT * FROM `player_storage` WHERE `player_id` = '" . $player->getId() . "' AND `player_storage`.`value` = " .$outfits . ";")->fetch();

                               if ($outfitquery == true )
                               {
                                   $contentEquipment .= '<img src="' . $config['site']['outfit_images_url'] . '?id='.$id.'&addons=3&head='.$player->getCustomField("lookhead").'&body='.$player->getCustomField("lookbody").'&legs='.$player->getCustomField("looklegs").'&feet='.$player->getCustomField("lookfeet").'">';
                               } else {
                                   $contentEquipment .= '<img class="grayimg" src="' . $config['site']['outfit_images_url'] . '?id='.$id.'&addons=3&head=0&body=0&legs=0&feet=0">';
                               }

                           }
                           $contentEquipment .= '
                       </div>
                   </div>
               </table>';

               $main_content .= '<tr bgcolor="'.$bgcolor.'"><td style="border:1px solid #faf0d7;">Inventário:</td><td style="border:1px solid #faf0d7;"><img id="ButtonEMail" onMouseDown="ToggleMaskedText(\'EMail\');" style="cursor:pointer;" src="'.$layout_name.'/images/general/show.gif"/><span id="DisplayEMail" ></span><span id="MaskedEMail" style="visibility:hidden;display:none" ></span><span id="ReadableEMail" style="visibility:hidden;display:none" ><br><br>'.$contentEquipment.'</span></td></tr>';
               // Task list show
               if($config['site']['showTasks'])
               {
                       $tasks = $config['site']['tasks'];
                       $taskCount = count($config['site']['tasks']);
                       $taskCountDone = 0;
                       foreach($tasks as $storage => $name)
                       {
                           $task = $SQL->query('SELECT * FROM player_storage WHERE player_id = '.$player->getId().' AND `key` = '.$tasks[$storage].';')->fetch();
                           $taskList .= '<div class="tastlistbk"><span class="testquestbox"><span class="questcolor">»</span> '.$storage.' ';
                           if($task == false)
                           {
                               $taskList .= '</span></div>';
                           }
                           else
                           {
                               $taskList .= '<span style="font-weight: 600;color: rgba(79, 195, 79, 0.71);;font-size: 9px;">(Completed)</span></span></div>';
                               $taskCountDone++;
                           }
                       }
                   $ilosc_procent = ( $taskCountDone / $taskCount ) * 100;
                   $main_content .= '<div id="scrolls" class="questbox"><div class="questbkinicial"><div class="questlisttext">Task List: <span class="questcompletedtext">'.round($ilosc_procent, 0).'% Completed</span></div></div><div class="tasklistimg"></div><table>'.$taskList.'</table></div></span></td></tr>';
               }
               // Task end list show*/
               if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
                   $main_content .= '
                   <tr bgcolor="'.$bgcolor.'"><td style="border:1px solid #faf0d7;">Outfit:</td>
                   <td style="border:1px solid #faf0d7;">
                   <img id="ButtonOutfit" onMouseDown="ToggleMaskedText(\'Outfit\');" style="cursor:pointer;" src="'.$layout_name.'/images/show.gif"/>
                   <span class="itemStroke"></span>
                   <span id="DisplayOutfit" >
                   </span>
                   <span id="MaskedOutfit" style="visibility:hidden;display:none" >
                   </span>
                   <span id="ReadableOutfit" style="visibility:hidden;display:none">
                   <br><br>
                   <img id="ImagemOutfit" alt="img" src="' . $config['site']['outfit_images_url'] . '?id=' . $player->getLookType() . '&addons=' . $player->getLookAddons() . '&head=' . $player->getLookHead() . '&body=' . $player->getLookBody() . '&legs=' . $player->getLookLegs() . '&feet=' . $player->getLookFeet() . '" width="64" height="64" style="width: 64px; height: 64px; position: absolute; background-position: 0 0; background-repeat: no-repeat; left: 137px; margin-top: -10px;"/>
                   <img style="margin-bottom: 10px;margin-left: 0px;margin-top: 3px;margin: 3px;width: 57px;height: 57px;background: rgba(155, 155, 155, 0.53);border-radius: 10px;border: 1.5px solid #434040;box-shadow: inset 0px 0px 10px rgba(0,0,0,0.5);" src="images/outfitbg.gif" width="64" height="64">
                   </td>
                   </tr>
                   </span>';
               if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
                   $rank_of_player = $player->getRank();
                   if(!empty($rank_of_player))
                   {
                       {
                       $guild_id = $rank_of_player->getGuild()->getId();
                       $guild_name = $rank_of_player->getGuild()->getName();
                       $main_content .= '
                       <TR BGCOLOR="'.$bgcolor.'"><td colspan="2">
                       <img src="/guild_image.php?id='.$guild_id.'" width="100" height="100" border="0" style="border: 1.5pt solid #333332;border-radius: 10px;background-color: rgba(2, 18, 34, 0.38);box-shadow: inset 0px 0px 10px rgba(0,0,0,0.5);margin-left: 10%;"/></a></br>
                       <div style="position: absolute;margin-top: -100px;margin-left: 30%;">
                       <b style="font-size: x-large;">'.$rank_of_player->getName().' da Guild <span style="color: brown !important;">'.$guild_name.'</span></b></br>Rank: '.$rank_of_player->getName().' of the <a href="?subtopic=guilds&action=show&guild='.$guild_id.'">'.$guild_name.'</a><br>';
                       $castle24 = $SQL->query('SELECT `winner_id`, `winner_guild`, `winner_guild_id`, `data`,`hora` FROM `castle` ORDER BY `id` DESC;');
                       $exclusivecastle = $SQL->query('SELECT `winner_id`, `winner_guild`, `winner_guild_id`, `data`,`hora` FROM `exclusivecastle` ORDER BY `id` DESC;');
                       foreach($castle24 as $info) {
                           if ($info['winner_guild_id'] == ''.$guild_id.'')
                           $main_content .= '
                           <img src="images/castle.png" style="margin:0 0px -1px 0" border="0"><b> <span style="background: transparent url(images/bg.gif);color:white;text-shadow: black 1px 1px 10px;">Guild dona do Castle 24 Horas atualmente. </b></span><img src="images/castle.png" style="margin:0 0px -1px 0" border="0"><br>';
                       }
                       foreach($exclusivecastle as $info) {
                           if ($info['winner_guild_id'] == ''.$guild_id.'')
                           $main_content .= '
                           <img src="images/castle.png" style="margin:0 0px -1px 0" border="0"><b> <span style="background: transparent url(images/bg.gif);color:white;text-shadow: black 1px 1px 10px;">Guild dona do Exclusive Castle atualmente! </b></span><img src="images/castle.png" style="margin:0 0px -1px 0" border="0">';
                       }
                       $main_content .= '</div></TD></TR>';
                       }
                   }
               $main_content .= '</TD></TR></TABLE></TABLE>
                                                           </div>
                                                       </div>
                                                       <div class="TableShadowContainer" >
                                                           <div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bm.gif);" >
                                                               <div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bl.gif);" ></div>
                                                               <div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-br.gif);" ></div>
                                                           </div>
                                                       </div>
                                                   </td>
                                               </tr>
                                           </div>
                                       </td>
                                   </tr>
                               </tbody>
                           </table>
                       </div>
                   </td>
               </tr>
           </tbody>
       </table>
   </div>';

# Mostras as quests
$quests = $config['site']['quests'];
$questCount = count($config['site']['quests']);
$questCountDone = 0;
$colunmNum = 1;


$questList .= '<tr bgcolor="'.$bgcolor.'">';
foreach($quests as $storage => $name) {
$quest = $SQL->query("SELECT * FROM `player_storage` WHERE `player_id` = '" . $player->getId() . "' AND `key` = '" . $quests[$storage] . "';")->fetch();

$questList .= '
<td width="1%" style="border:1px solid #faf0d7;">
<img src="images/'.(($quest == true) ? 'true' : 'false').'.png">
</td>
<td width="47%" style="font-size:12px;border:1px solid #faf0d7;'.(($quest == false) ? '' : 'font-weight:bold;color:green;').'">'.$storage.'</td>';

if ($quest == true)
$questCountDone++;

if ($colunmNum % 1 == 0) {
if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
$questList .= '</tr><tr bgcolor="'.$bgcolor.'">';
}
$colunmNum++;
}

$questList .= '</tr>';

$resultados = count($quests);
$resultFinal = round(($questCountDone/$resultados)*100);
$resultFinal = str_pad($resultFinal, 2, "0", STR_PAD_LEFT);

$main_content .= '
<br />
<div class="TableContainer">
<div class="CaptionContainer">
<div class="CaptionInnerContainer">
<span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
<span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
<span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
<span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
<div class="Text">Quests Completas</div>
<span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
<span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
<span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
<span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
</div>
</div>
<table class="Table5" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td>
<div class="InnerTableContainer">
<table style="width:100%;">
<tbody>
<tr>
<td>
<div class="TableShadowContainerRightTop">
<div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rt.gif);"></div>
</div>
<div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rm.gif);">
<div class="TableContentContainer">
<table border="0" cellspacing="1" cellpadding="4" width="100%"><tbody><tr bgcolor="#505050"><td colspan="2" width="15%" class="white"><img id="ButtonQuests" onmousedown="ToggleMaskedText(\'Quests\');" style="vertical-align:middle;cursor:pointer;" src="'.$layout_name.'/images/general/show.gif"> <b>Quests: </b></td><td> <progress max="100" value="'.$resultFinal.'"></progress></b></td><td class="white"><b>'.$resultFinal.'%</b></td></tr></tbody></table>
<span id="DisplayQuests"></span>
<span id="MaskedQuests" style="visibility:hidden;display:none"></span><span id="ReadableQuests" style="visibility:hidden;display:none"><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR bgcolor='.$config['site']['vdarkborder'].'></TR>'.$questComplet.''.$questList.'</TABLE></span>
</div>
</div>
<div class="TableShadowContainer">
<div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bm.gif);">
<div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bl.gif);"></div>
<div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-br.gif);"></div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>';

           /* Quest list show By Leandrozera
               $quests = $config['site']['quests'];
                   $questCount = count($config['site']['quests']);
                   $questCountDone = 0;
                   $colunmNum = 1;

                   # Mostras as quests
                   $questList .= '<tr bgcolor="'.$bgcolor.'">';
                   foreach($quests as $storage => $name) {
                       $quest = $SQL->query("SELECT * FROM `player_storage` WHERE `player_id` = '" . $player->getId() . "' AND `key` = '" . $quests[$storage] . "';")->fetch();

                       $questList .= '
                           <td width="1%" style="border:1px solid #faf0d7;">
                               <img src="images/'.(($quest == false) ? 'false' : 'true').'.png">
                           </td>
                           <td width="47%" style="font-size:12px;border:1px solid #faf0d7;'.(($quest == false) ? '' : 'font-weight:bold;color:green;').'">'.$storage.'</td>';

                       if ($quest == true)
                           $questCountDone++;

                       if ($colunmNum % 2 == 0) {
                           if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
                           $questList .= '</tr><tr bgcolor="'.$bgcolor.'">';
                       }
                       $colunmNum++;
                   }

                   $questList .= '</tr>';
           /////////////////////////////////////////


           // Quest list show By Leandrozera
               $pegatasks = $config['site']['tasks'];
                   $tasksCount = count($config['site']['tasks']);
                   $tasksCountDone = 0;
                   $colunmNum = 1;

                   # Mostras as tasks
                   $tasksList .= '<tr bgcolor="'.$bgcolor.'">';
                   foreach($pegatasks as $name => $storage) {
                       $tasks = $SQL->query("SELECT * FROM `player_storage` WHERE `player_id` = '" . $player->getId() . "' AND `key` = '" . $storage . "' AND `value` >= '1'")->fetch();

                       $tasksList .= '
                           <td width="1%" style="border:1px solid #faf0d7;">
                               <img src="images/'.(($tasks == false) ? 'false' : 'true').'.png">
                           </td>
                           <td width="47%" style="font-size:12px;border:1px solid #faf0d7;'.(($tasks == false) ? '' : 'font-weight:bold;color:green;').'">'.$name.'</td>';

                       if ($tasks == true)
                           $tasksCountDone++;

                       if ($colunmNum % 2 == 0) {
                           if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
                           $tasksList .= '</tr><tr bgcolor="'.$bgcolor.'">';
                       }
                       $colunmNum++;
                   }

                   $tasksList .= '</tr>';
           /////////////////////////////////////////
           $resultados = count($quests);
           $resultFinal = round(($questCountDone/$resultados)*100);
           $resultFinal = str_pad($resultFinal, 2, "0", STR_PAD_LEFT);
           $resultadostask = count($pegatasks);
           $resultFinaltask = round(($tasksCountDone/$resultadostask)*100);
           $resultFinaltask = str_pad($resultFinaltask, 2, "0", STR_PAD_LEFT);


               $main_content .= '
               <br />
                   <div class="TableContainer">
                       <div class="CaptionContainer">
                           <div class="CaptionInnerContainer">
                               <span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
                               <span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
                               <span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
                               <span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
                               <div class="Text">Other Infos</div>
                               <span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
                               <span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
                               <span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
                               <span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
                           </div>
                       </div>
                       <table class="Table5" cellpadding="0" cellspacing="0">
                           <tbody>
                               <tr>
                                   <td>
                                       <div class="InnerTableContainer">
                                           <table style="width:100%;">
                                               <tbody>
                                                   <tr>
                                                       <td>
                                                           <div class="TableShadowContainerRightTop">
                                                               <div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rt.gif);"></div>
                                                           </div>
                                                           <div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rm.gif);">
                                                               <div class="TableContentContainer">
                                                                   <table border="0" cellspacing="1" cellpadding="4" width="100%"><tbody><tr bgcolor="#505050"><td colspan="2" width="15%" class="white"><img id="ButtonQuests" onmousedown="ToggleMaskedText(\'Quests\');" style="vertical-align:middle;cursor:pointer;" src="'.$layout_name.'/images/general/show.gif"> <b>Quests: </b></td><td> <progress max="100" value="'.$resultFinal.'"></progress></b></td><td class="white"><b>'.$resultFinal.'%</b></td></tr></tbody></table>
                                                                   <span id="DisplayQuests"></span>
                                                                   <span id="MaskedQuests" style="visibility:hidden;display:none"></span><span id="ReadableQuests" style="visibility:hidden;display:none"><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR bgcolor='.$config['site']['vdarkborder'].'></TR>'.$questComplet.''.$questList.'</TABLE></span>
                                                               </div>
                                                           </div>
                                                           <div class="TableShadowContainer">
                                                               <div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bm.gif);">
                                                                   <div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bl.gif);"></div>
                                                                   <div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-br.gif);"></div>
                                                               </div>
                                                           </div>
                                                       </td>
                                                   </tr>
                                               </tbody>
                                           </table>
                                           <table style="width:100%;margin-top: -6px;">
                                               <tbody>
                                                   <tr>
                                                       <td>
                                                           <div class="TableShadowContainerRightTop">
                                                               <div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rt.gif);"></div>
                                                           </div>
                                                           <div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rm.gif);">
                                                               <div class="TableContentContainer">
                                                                   <table border="0" cellspacing="1" cellpadding="4" width="100%"><tbody><tr bgcolor="#505050"><td colspan="2" width="15%" class="white"><img id="ButtonTasks" onmousedown="ToggleMaskedText(\'Tasks\');" style="vertical-align:middle;cursor:pointer;" src="'.$layout_name.'/images/general/show.gif"> <b>Tasks: </b></td><td> <progress max="100" value="'.$resultFinaltask.'"></progress></td><td class="white"><b>'.$resultFinaltask.'%</b></td></tr></tbody></table>
                                                                   <span id="DisplayTasks"></span>
                                                                   <span id="MaskedTasks" style="visibility:hidden;display:none"></span><span id="ReadableTasks" style="visibility:hidden;display:none"><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR bgcolor='.$config['site']['vdarkborder'].'></TR>'.$tasksComplet.''.$tasksList.'</TABLE></span>
                                                               </div>
                                                           </div>
                                                           <div class="TableShadowContainer">
                                                               <div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bm.gif);">
                                                                   <div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bl.gif);"></div>
                                                                   <div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-br.gif);"></div>
                                                               </div>
                                                           </div>
                                                       </td>
                                                   </tr>
                                               </tbody>
                                           </table>
                                       </div>
                                   </td>
                               </tr>
                           </tbody>
                       </table>
                   </div>';
                   */

           // Vip List show
           if($config['site']['showVipList'])
           {
               // Table player_viplist: player_id, vip_id
               // Table account_viplist: account_id, world_id, player_id
               $vip = 0;
               if($config['server']['separateVipListPerCharacter'] == false)
                   $vipLists = $SQL->query('SELECT * FROM `account_viplist` WHERE `account_id` = '.$account->getId().';');
               else
                   $vipLists = $SQL->query('SELECT * FROM `player_viplist` WHERE `player_id` = '.$player->getId().';');
               foreach($vipLists as $vipList)
               {
                   if($config['server']['separateVipListPerCharacter'] == false)
                       $result = $SQL->query('SELECT * FROM `players` WHERE `id` = '.$vipList['player_id'].';');
                   else
                       $result = $SQL->query('SELECT * FROM `players` WHERE `id` = '.$vipList['vip_id'].';');
                   foreach($result as $listVip)
                   {
                       $vip++;
                       if($config['site']['show_flag'])
                       {
                           $accounts = $SQL->query('SELECT * FROM accounts WHERE id = '.$listVip['account_id'].'')->fetch();
                           $flags = '<image src="http://images.boardhost.com/flags/'.$accounts['flag'].'.png"/> ';
                       }
                       if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
                           $vipResult .= '<tr bgcolor='.$bgcolor.'>
                               <td>'.$vip.'</td>
                               <td>
                                   '.$flags.'<a href="index.php?subtopic=characters&name='.urlencode($listVip['name']).'">'.$listVip['name'].'</a>';
                                   if($config['site']['showMoreInfo'])
                                       $vipResult .= '<br><small>Level: '.$listVip['level'].', '.$vocation_name[$listVip['world_id']][$listVip['promotion']][$listVip['vocation']].', '.$config['site']['worlds'][$listVip['world_id']].'</small>';
                               $vipResult .= '</td>
                           </tr>';
                   }
               }
               if($vip > 0)
                   $main_content .= '<br><table border=0 cellspacing=1 cellpadding=4 width=100%><TR bgcolor='.$config['site']['vdarkborder'].'><TD align="left" COLSPAN=2 CLASS=white><B>Vip List</B></TD></TR>'.$vipResult.'</table>';
           }
           // Deaths list
           $deads = 0;
           $player_deaths = $SQL->query('SELECT `id`, `date`, `level` FROM `player_deaths` WHERE `player_id` = '.$player->getId().' ORDER BY `date` DESC LIMIT 0,'.$config['site']['limitDeath'].'');
           foreach($player_deaths as $death)
           {
               if(is_int($number_of_rows / 2))
                   $bgcolor = $config['site']['darkborder']; else $bgcolor = $config['site']['lightborder'];
               $number_of_rows++; $deads++;
               $dead_add_content .= "<tr bgcolor=\"".$bgcolor."\">
                   <td width=\"20%\" align=\"center\" style=\"border:1px solid #faf0d7;\">".date("j M Y, H:i", $death['date'])."</td>
                   <td style=\"border:1px solid #faf0d7;\">";
               $killers = $SQL->query("SELECT environment_killers.name AS monster_name, players.name AS player_name, players.deleted AS player_exists FROM killers LEFT JOIN environment_killers ON killers.id = environment_killers.kill_id
                   LEFT JOIN player_killers ON killers.id = player_killers.kill_id LEFT JOIN players ON players.id = player_killers.player_id
                   WHERE killers.death_id = ".$SQL->quote($death['id'])." ORDER BY killers.final_hit DESC, killers.id ASC")->fetchAll();
               $i = 0;
               $count = count($killers);
               foreach($killers as $killer)
               {
                   $i++;
                   if(in_array($i, array(1, $count)))
                       $killer['monster_name'] = str_replace(array("an ", "a "), array("", ""), $killer['monster_name']);
                   if($killer['player_name'] != "")
                   {
                       if($i == 1)
                           $dead_add_content .= "Killed at level <b>".$death['level']."</b> by ";
                       else
                           if($i == $count)
                               $dead_add_content .= " and by ";
                           else
                               $dead_add_content .= ", ";
                       if($killer['monster_name'] != "")
                           $dead_add_content .= $killer['monster_name']." summoned by ";
                       if($killer['player_exists'] == 0)
                           $dead_add_content .= "<a href=\"index.php?subtopic=characters&name=".urlencode($killer['player_name'])."\">";
                       $dead_add_content .= $killer['player_name'];
                       if($killer['player_exists'] == 0)
                           $dead_add_content .= "</a>";
                   }
                   else
                   {
                       if($i == 1)
                           $dead_add_content .= "Died at level <b>".$death['level']."</b> by ";
                       else
                           if($i == $count)
                               $dead_add_content .= " and by ";
                           else
                               $dead_add_content .= ", ";
                       $dead_add_content .= $killer['monster_name'];
                   }
                   if($i == $count)
                       $dead_add_content .= ".";
               }
               $dead_add_content .= ".</td></tr>";
           } if($deads == 0) {
               if(is_int($number_of_rows / 2)) $bgcolor = $config['site']['darkborder']; else $bgcolor = $config['site']['lightborder'];
               $dead_add_content .= "<tr bgcolor=\"".$bgcolor."\">
               <td style=\"border:1px solid #faf0d7;\"><center>This player doesn't have any deaths yet!</center></td></tr>";
           }

//frags list by Xampy

$frags_limit = 250; // frags limit to show? // default: 10
$player_frags = $SQL->query('SELECT `player_deaths`.*, `players`.`name`, `killers`.`unjustified` FROM `player_deaths` LEFT JOIN `killers` ON `killers`.`death_id` = `player_deaths`.`id` LEFT JOIN `player_killers` ON `player_killers`.`kill_id` = `killers`.`id` LEFT JOIN `players` ON `players`.`id` = `player_deaths`.`player_id` WHERE `player_killers`.`player_id` = '.$player->getId().' AND `killers`.`unjustified` = 0 ORDER BY `date` DESC LIMIT 0,'.$frags_limit.';');
           if(count($player_frags))
{
               $frag_add_content .= '
   <br><div class="TableContainer">
       <div class="CaptionContainer">
           <div class="CaptionInnerContainer">
               <span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
               <span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
               <div class="Text">Frags and Deaths</div>
               <span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
               <span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
               <span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
                   </div>
                       </div>
                           <table class="Table5" cellpadding="0" cellspacing="0">
                               <tbody>
                                   <tr>
                                       <td>
                                       <div class="InnerTableContainer">
                                           <table style="width:100%;">
                                               <tbody>
                                               <tr>
                                                   <td>
                                                       <div class="TableShadowContainerRightTop" >
                                                           <div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rt.gif);" ></div>
                                                       </div>
                                                       <div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rm.gif);" >
                                                           <div class="TableContentContainer" >
<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2 CLASS=white><img id="ButtonInjust" onMouseDown="ToggleMaskedText(\'Injust\');" style="vertical-align:middle;cursor:pointer;" src="'.$layout_name.'/images/global/general/show.gif"/> <B>Frags Justified</B></TD></TR></TABLE>

               <span id="DisplayInjust" ></span>
               <span id="MaskedInjust" style="visibility:hidden;display:none" ></span>';
$frags = 0;
$frag_add_content .= '<span id="ReadableInjust" style="visibility:hidden;display:none" ><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>';
               foreach($player_frags as $frag)
{
$frags++;
if(is_int($number_of_rows / 2)) $bgcolor = $config['site']['darkborder']; else $bgcolor = $config['site']['lightborder'];
$number_of_rows++;
$frag_add_content .= "<tr bgcolor=\"".$bgcolor."\">
<td width=\"20%\" align=\"center\" style=\"border:1px solid #faf0d7;\">".date("j M Y, H:i", $frag['date'])."</td>
<td style=\"border:1px solid #faf0d7;\">".(($player->getSex() == 0) ? 'She' : 'He')." fragged <a href=\"index.php?subtopic=characters&name=".$frag[name]."\">".$frag[name]."</a> at level ".$frag[level]."";

$frag_add_content .= ". (".(($frag[unjustified] == 0) ? "<font size=\"1\" color=\"green\">Justified</font>" : "<font size=\"1\" color=\"red\">Unjustified</font>").")</td></tr>";
} if($frags == 0) {
                   if(is_int($number_of_rows / 2)) $bgcolor = $config['site']['darkborder']; else $bgcolor = $config['site']['lightborder'];
$frag_add_content .= "<tr bgcolor=\"".$bgcolor."\">
<td style=\"border:1px solid #faf0d7;\"><center>This player doesn't have any frags yet!</center></td></tr>";
               }
if($frags >= 0)
$main_content .= $frag_add_content . '</TABLE></span>                                                           </div>
                                                       </div>
                                                       <div class="TableShadowContainer" >
                                                           <div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bm.gif);" >
                                                               <div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bl.gif);" ></div>
                                                               <div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-br.gif);" ></div>
                                                           </div>
                                                       </div>';
               }

           //frags list by Xampy

$frags_limit = 250; // frags limit to show? // default: 10
$player_frags_unjust = $SQL->query('SELECT `player_deaths`.*, `players`.`name`, `killers`.`unjustified` FROM `player_deaths` LEFT JOIN `killers` ON `killers`.`death_id` = `player_deaths`.`id` LEFT JOIN `player_killers` ON `player_killers`.`kill_id` = `killers`.`id` LEFT JOIN `players` ON `players`.`id` = `player_deaths`.`player_id` WHERE `player_killers`.`player_id` = '.$player->getId().' AND `killers`.`unjustified` = 1 ORDER BY `date` DESC LIMIT 0,'.$frags_limit.';');
if(count($player_frags_unjust))
{
               $frag_unjust_add_content .= '
                                                       <div class="TableShadowContainerRightTop" >
                                                           <div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rt.gif);" ></div>
                                                       </div>
                                                       <div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rm.gif);" >
                                                           <div class="TableContentContainer" >
<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2 CLASS=white><img id="ButtonUnjust" onMouseDown="ToggleMaskedText(\'Unjust\');" style="vertical-align:middle;cursor:pointer;" src="'.$layout_name.'/images/global/general/show.gif"/> <B>Frags Unjustified</B></TD></TR></TABLE>
               <span id="DisplayUnjust" ></span>
               <span id="MaskedUnjust" style="visibility:hidden;display:none" ></span>';

$frags = 0;
$frag_unjust_add_content .= '<span id="ReadableUnjust" style="visibility:hidden;display:none" ><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>';

               foreach($player_frags_unjust as $frag_unjust)
{
$frags++;
if(is_int($number_of_rows / 2)) $bgcolor = $config['site']['darkborder']; else $bgcolor = $config['site']['lightborder'];
$number_of_rows++;
$frag_unjust_add_content .= "<tr bgcolor=\"".$bgcolor."\">
<td width=\"20%\" align=\"center\" style=\"border:1px solid #faf0d7;\">".date("j M Y, H:i", $frag_unjust['date'])."</td>
<td style=\"border:1px solid #faf0d7;\">".(($player->getSex() == 0) ? 'She' : 'He')." fragged <a href=\"index.php?subtopic=characters&name=".$frag_unjust[name]."\">".$frag_unjust[name]."</a> at level ".$frag_unjust[level]."";

$frag_unjust_add_content .= ". (".(($frag_unjust[unjustified] == 0) ? "<font size=\"1\" color=\"green\">Justified</font>" : "<font size=\"1\" color=\"red\">Unjustified</font>").")</td></tr>";
} if($frags == 0) {
                   if(is_int($number_of_rows / 2)) $bgcolor = $config['site']['darkborder']; else $bgcolor = $config['site']['lightborder'];
$frag_unjust_add_content .= "<tr bgcolor=\"".$bgcolor."\">
<td style=\"border:1px solid #faf0d7;\"><center>This player doesn't have any unjustified frags yet!</center></td></tr>";
               }
if($frags >= 0)
$main_content .= $frag_unjust_add_content . '</TABLE></span>
                                                       </div>
                                                       </div>
                                                       <div class="TableShadowContainer" >
                                                           <div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bm.gif);" >
                                                               <div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bl.gif);" ></div>
                                                               <div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-br.gif);" ></div>
                                                           </div>
                                                       </div>
                                                       <div class="TableShadowContainerRightTop" >
                                                           <div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rt.gif);" ></div>
                                                       </div>
                                               <div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rm.gif);" >
                                                   <div class="TableContentContainer" >
                                               <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2 CLASS=white><img id="ButtonDeaths" onMouseDown="ToggleMaskedText(\'Deaths\');" style="vertical-align:middle;cursor:pointer;" src="'.$layout_name.'/images/global/general/show.gif"/> <B>Deaths</B></TD></TR></TABLE>
                                               <span id="DisplayDeaths" ></span>
                                               <span id="MaskedDeaths" style="visibility:hidden;display:none" ></span>
                                               <span id="ReadableDeaths" style="visibility:hidden;display:none">
                                               <TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
                                               ' . $dead_add_content . '
                                               </TABLE></span>
                                                   </div>
                                               </div>
                                               <div class="TableShadowContainer" >
                                                   <div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bm.gif);" >
                                                   <div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bl.gif);" ></div>
                                                   <div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-br.gif);" ></div>
                                                   </div>
                                               </div>
                                           </td>
                                       </tr>
                                   </div>
                               </td>
                           </tr>
                       </tbody>
                   </table>
               </div>
           </tbody>
       </table>
   </div>';
               }


           // onther info
           if(!$player->getHideChar() || $group_id_of_acc_logged >= $config['site']['access_admin_panel'])
           {
               $main_content .= '<BR>
<div class="TableContainer">
       <div class="CaptionContainer">
           <div class="CaptionInnerContainer">
               <span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
               <span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
               <div class="Text">Account Information</div>
               <span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
               <span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
               <span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
                   </div>
                       </div>
                           <table class="Table5" cellpadding="0" cellspacing="0">
                               <tbody>
                                   <tr>
                                       <td>
                                       <div class="InnerTableContainer">
                                           <table style="width:100%;">
                                               <tbody>
                                               <tr>
                                                   <td>
                                                       <div class="TableShadowContainerRightTop" >
                                                           <div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rt.gif);" ></div>
                                                       </div>
                                                       <div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rm.gif);" >
                                                           <div class="TableContentContainer" >
<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>';

   $group = $player->getGroup();
if ($group == 2){$group_name = 'Tutor';}
if ($group == 3){$group_name = 'Senior Tutor';}
if ($group == 4){$group_name = 'Gamemaster';}
if ($group == 5){$group_name = 'Community Manager';}
if ($group == 6){$group_name = 'God';}
if ($group == 7){$group_name = 'Administrador';}

if($group != 1)
{

$main_content .= '<TR BGCOLOR='.$config['site']['darkborder'].'><TD style="border:1px solid #faf0d7;">Position:</TD><TD style="border:1px solid #faf0d7;">'.$group_name.'</TD></TR>';
}


               $name = $account->getRLName();
               if(!empty($name)){
               $main_content .= '<TR BGCOLOR='.$config['site']['lightborder'].'><TD WIDTH=20% style="border:1px solid #faf0d7;">Real Name:</TD><TD style="border:1px solid #faf0d7;">'.htmlspecialchars($account->getRLName()).'</TD></TR>';
               }
               $location = $account->getLocation();
               if(!empty($location)){
               $main_content .= '<TR BGCOLOR='.$config['site']['darkborder'].'><TD WIDTH=20% style="border:1px solid #faf0d7;">Location:</TD><TD style="border:1px solid #faf0d7;">'.htmlspecialchars($account->getLocation()).'</TD></TR>';
               }
               if($account->getCreateDate())
               {
                   if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
                   $main_content .= '<TR BGCOLOR='.$config['site']['lightborder'].'><TD WIDTH=20% style="border:1px solid #faf0d7;">Created:</TD><TD style="border:1px solid #faf0d7;">'.date("j F Y, g:i a", $account->getCreateDate()).'</TD></TR>';

               /*Vip Status*/
if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['darkborder']; } $number_of_rows++;
$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD style="border:1px solid #faf0d7;">Account Status:</TD><TD style="border:1px solid #faf0d7;">';
$main_content .= ($account->isPremium()) ? '<font color="#00CD00" style="text-shadow: 1px 1px #014b01;"><b>Premium Account</b></font>' : '<font color="#FF0000" style="text-shadow: 1px 1px #580208;"><b>Free Account</b></font>';
               }
               if($account->isBanned())
if($account->getBanTime() > 0)
                       $main_content .= '<font color="red"> [Banished until '.date("j F Y, G:i", $account->getBanTime()).']</font>';
                   else
                       $main_content .= '<font color="red"> [Banished FOREVER]</font>';

               $main_content .= '</TABLE>
                                                           </div>
                                                       </div>
                                                       <div class="TableShadowContainer" >
                                                           <div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bm.gif);" >
                                                               <div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bl.gif);" ></div>
                                                               <div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-br.gif);" ></div>
                                                           </div>
                                                       </div>
                                                   </td>
                                               </tr>
                                           </div>
                                       </td>
                                   </tr>
                               </tbody>
                           </table>
                       </div>
                   </td>
               </tr>
           </tbody>
       </table>
   </div>';
               $main_content .= '<BR>
<div class="TableContainer">
       <div class="CaptionContainer">
           <div class="CaptionInnerContainer">
               <span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
               <span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
               <div class="Text">Characters</div>
               <span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
               <span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
               <span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
                   </div>
                       </div>
                           <table class="Table5" cellpadding="0" cellspacing="0">
                               <tbody>
                                   <tr>
                                       <td>
                                       <div class="InnerTableContainer">
                                           <table style="width:100%;">
                                               <tbody>
                                               <tr>
                                                   <td>
                                                       <div class="TableShadowContainerRightTop" >
                                                           <div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rt.gif);" ></div>
                                                       </div>
                                                       <div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rm.gif);" >
                                                           <div class="TableContentContainer" >
<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%>
                   <TR BGCOLOR='.$config['site']['darkborder'].'><TD style="border:1px solid #faf0d7;"><b>Outfit</b></TD><TD style="border:1px solid #faf0d7;"><B>Name</B></TD><TD style="border:1px solid #faf0d7;"width="20%"><B>World</B></TD><TD style="border:1px solid #faf0d7;"><b>Status</b></TD><TD style="border:1px solid #faf0d7;"><B> </B></TD></TR>';
               $account_players = $account->getPlayersList();
               $player_number = 0;
               foreach($account_players as $player_list)
               {
                   if(!$player_list->getHideChar() || $group_id_of_acc_logged >= $config['site']['access_admin_panel'])
                   {
                       $player_number++;
                       if(is_int($player_number / 2))
                           $bgcolor = $config['site']['darkborder'];
                       else
                           $bgcolor = $config['site']['lightborder'];
                       if(!$player_list->isOnline())
                           $player_list_status = '<font color="red" style="text-shadow: 1px 1px #043d00;"><b>Offline</b></font>';
                       else
                           $player_list_status = '<font color="lime" style="text-shadow: 1px 1px #043d00;"><b>Online</b></font>';
                       $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><td style="border:1px solid #faf0d7;"><div style="position: relative; width: 32px; height: 32px;"><div style="background-image: url('. $config['site']['outfit_images_url'] .'?id='.$player_list->getCustomField("looktype").'&addons='.$player_list->getCustomField("lookaddons").'&head='.$player_list->getCustomField("lookhead").'&body='.$player_list->getCustomField("lookbody").'&legs='.$player_list->getCustomField("looklegs").'&feet='.$player_list->getCustomField("lookfeet").'); position: absolute; width: 64px; height: 80px; background-position: bottom right; background-repeat: no-repeat; right: -10px; bottom: 0px;"></div></div>
                   </td><TD WIDTH=18% style="border:1px solid #faf0d7;"><NOBR>'.$player_number.'. '.$player_list->getName();
                       $main_content .= ($player_list->isDeleted()) ? '<font color="red"> [DELETED]</font>' : '';
                       $main_content .= '</NOBR></TD><TD WIDTH=12% style="border:1px solid #faf0d7;">'.$config['site']['worlds'][$player_list->getWorld()].'<TD WIDTH="60%" style="border:1px solid #faf0d7;"><b>'.$player_list_status.'</b></TD><TD style="border:1px solid #faf0d7;"><TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0><FORM ACTION="?subtopic=characters" METHOD=post><TR><TD><INPUT TYPE=hidden NAME=name VALUE="'.$player_list->getName().'"><INPUT TYPE=image NAME="View '.$player_list->getName().'" ALT="View '.$player_list->getName().'" SRC="'.$layout_name.'/images/buttons/sbutton_view.gif" BORDER=0 WIDTH=120 HEIGHT=18></TD></TR></FORM></TABLE></TD></TR>';
                   }
               }
               $main_content .= '</TABLE>
                                                           </div>
                                                       </div>
                                                       <div class="TableShadowContainer" >
                                                           <div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bm.gif);" >
                                                               <div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bl.gif);" ></div>
                                                               <div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-br.gif);" ></div>
                                                           </div>
                                                       </div>
                                                   </td>
                                               </tr>
                                           </div>
                                       </td>
                                   </tr>
                               </tbody>
                           </table>
                       </div>
                   </td>
               </tr>
           </tbody>
       </table>
   </div>';
           }
           $main_content .= '<BR><FORM AUTOCOMPLETE="OFF" ACTION="?subtopic=characters" METHOD=post>
<div class="TableContainer">
       <div class="CaptionContainer">
           <div class="CaptionInnerContainer">
               <span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
               <span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
               <div class="Text">Search Character</div>
               <span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
               <span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
               <span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
                   </div>
                       </div>
                           <table class="Table5" cellpadding="0" cellspacing="0">
                               <tbody>
                                   <tr>
                                       <td>
                                       <div class="InnerTableContainer">
                                           <table style="width:100%;">
                                               <tbody>
                                               <tr>
                                                   <td>
                                                       <div class="TableShadowContainerRightTop" >
                                                           <div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rt.gif);" ></div>
                                                       </div>
                                                       <div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rm.gif);" >
                                                           <div class="TableContentContainer" >
                                                           <TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['darkborder'].'" style="border:1px solid #faf0d7;"><TABLE BORDER=0 CELLPADDING=1><TR><TD>Name:</TD><TD><INPUT NAME="name" onkeyup="showResult(this.value)" VALUE=""SIZE=29 MAXLENGTH=29></TD><TD><INPUT TYPE=image NAME="Submit" SRC="'.$layout_name.'/images/buttons/sbutton_submit.gif" BORDER=0 WIDTH=120 HEIGHT=18></TD></TR>           <tr>
           <td></td>
           <td style="max-height: 0px; display: inline-block;">   <div style="background-color: white; z-index: 1000; position: absolute; width: 170px;" class="" id="livesearch"></div></td>
           </tr></TABLE></TD></TR></TABLE>
                                                           </div>
                                                       </div>
                                                       <div class="TableShadowContainer" >
                                                           <div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bm.gif);" >
                                                               <div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bl.gif);" ></div>
                                                               <div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-br.gif);" ></div>
                                                           </div>
                                                       </div>
                                                   </td>
                                               </tr>
                                           </div>
                                       </td>
                                   </tr>
                               </tbody>
                           </table>
                       </div>
                   </td>
               </tr>
           </tbody>
       </table>
   </div></FORM>';
           $main_content .= '</TABLE>';
       }
       else
           $search_errors[] = 'Character <b>'.$name.'</b> does not exist.';
   }
   else
       $search_errors[] = 'This name contains invalid letters. Please use only A-Z, a-z and space.';
   if(!empty($search_errors))
   {
       $main_content .= '<div class="SmallBox" > <div class="MessageContainer" > <div class="BoxFrameHorizontal" style="background-image:url('.$layout_name.'/images/content/box-frame-horizontal.gif);" /></div> <div class="BoxFrameEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div> <div class="BoxFrameEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div> <div class="ErrorMessage" > <div class="BoxFrameVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);" /></div> <div class="BoxFrameVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);" /></div> <div class="AttentionSign" style="background-image:url('.$layout_name.'/images/content/attentionsign.gif);" /></div><b>The Following Errors Have Occurred:</b><br/>';
       foreach($search_errors as $search_error)
       $main_content .= '<li>'.$search_error;
       $main_content .= '</div> <div class="BoxFrameHorizontal" style="background-image:url('.$layout_name.'/images/content/box-frame-horizontal.gif);" /></div> <div class="BoxFrameEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div> <div class="BoxFrameEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div> </div></div><br/>';
       $main_content .= '<BR><FORM AUTOCOMPLETE="OFF" ACTION="?subtopic=characters" METHOD=post>
   <div class="TableContainer">
       <div class="CaptionContainer">
           <div class="CaptionInnerContainer">
               <span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
               <span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
               <div class="Text">Search Character</div>
               <span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);"></span>
               <span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif);"></span>
               <span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
               <span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);"></span>
                   </div>
                       </div>
                           <table class="Table5" cellpadding="0" cellspacing="0">
                               <tbody>
                                   <tr>
                                       <td>
                                       <div class="InnerTableContainer">
                                           <table style="width:100%;">
                                               <tbody>
                                               <tr>
                                                   <td>
                                                       <div class="TableShadowContainerRightTop" >
                                                           <div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rt.gif);" ></div>
                                                       </div>
                                                       <div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-rm.gif);" >
                                                           <div class="TableContentContainer" >
                                                           <TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['darkborder'].'"><TABLE BORDER=0 CELLPADDING=1><TR><TD>Name:</TD><TD><INPUT onkeyup="showResult(this.value)" NAME="name" VALUE=""SIZE=29 MAXLENGTH=29></TD><TD><INPUT TYPE=image NAME="Submit" SRC="'.$layout_name.'/images/buttons/sbutton_submit.gif" BORDER=0 WIDTH=120 HEIGHT=18></TD></TR><tr>
                                                           <td></td>
                                                           <td style="max-height: 0px; display: inline-block;">   <div style="background-color: white; z-index: 1000; position: absolute; width: 170px;" class="" id="livesearch"></div></td>
                                                           </tr></TABLE>
                                                           </TD></TR></TABLE>
                                                           </div>
                                                       </div>
                                                       <div class="TableShadowContainer" >
                                                           <div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bm.gif);" >
                                                               <div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-bl.gif);" ></div>
                                                               <div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/global/content/table-shadow-br.gif);" ></div>
                                                           </div>
                                                       </div>
                                                   </td>
                                               </tr>
                                           </div>
                                       </td>
                                   </tr>
                               </tbody>
                           </table>
                       </div>
                   </td>
               </tr>
           </tbody>
       </table>
   </div></FORM>';
   }
}
?>

Underewar · Fevereiro 14, 2023

Bom nesse caso para pesquisar você precisa utilizar um constructor que ja esta sendo usado na pagina para pegar as informações.
Esse é o constructor, você nao precisa entendelo. Mas precisa saber que existe.

$player = new Player();

$player->find($name);

if($player->isLoaded())

{

$account = $player->getAccount();

$account_db = new Account();

Para isso crie uma nova função em :
libs/OTS_Player.php

uma nova chamada para o reset

public function getReset()

{

if( !isset($this->data['reset']) )

{

throw new E_OTS_NotLoaded();

}

return $this->data['reset'];

}

Tambem é necessario criar um novo getter para o constructor;

Dentro da função getter ;

public function __get($name)

case 'reset':

return $this->getReset();

Agora o setter

public function __set($name, $value)

case 'reset':

return $this->setReset($value);

Agora sim você pode pesquisar utilizando a função getReset() que vai buscar o data desse contexto atual, que no caso é um constructor da chamada player no banco de dados.

Agora chame no render da pagina com:

$player->getReset()

$main_content .= '<TR BGCOLOR="'.$bgcolor.'">

<TD style="border:1px solid #faf0d7;">resets:</TD>

<TD style="border:1px solid #faf0d7;">'

.$player->getReset().'

</TD>

</TR>';

Characters.txt

Me manda o seu OTS_Player.php

@ILex WilL

Editado Fevereiro 14, 2023 por Underewar (veja o histórico de edições)

ILex WilL · Fevereiro 14, 2023

17 minutos atrás, Underewar disse:

Bom nesse caso para pesquisar você precisa utilizar um constructor que ja esta sendo usado na pagina para pegar as informações.
Esse é o constructor, você nao precisa entendelo. Mas precisa saber que existe.

$player = new Player();

$player->find($name);

if($player->isLoaded())

{

$account = $player->getAccount();

$account_db = new Account();

Para isso crie uma nova função em :
libs/OTS_Player.php

Pule uma linha na linha 209 e crie uma nova chamada para o reset

public function getReset()

{

if( !isset($this->data['reset']) )

{

throw new E_OTS_NotLoaded();

}

return $this->data['reset'];

}

Agora sim você pode pesquisar utilizando a função getReset() que vai buscar o data desse contexto atual, que no caso é um constructor da chamada player no banco de dados.

Agora chame no render da pagina com:

$player->getReset()

$main_content .= '<TR BGCOLOR="'.$bgcolor.'">

<TD style="border:1px solid #faf0d7;">resets:</TD>

<TD style="border:1px solid #faf0d7;">'

.$player->getReset().'

</TD>

</TR>';

Characters.txt 114 kB · 0 downloads

Me manda o seu OTS_Player.php

@ILex WilL

Colocando seu characters deu esse erro:

Fatal error: Call to undefined method Player::getReset() in C:\xampp\htdocs\pages\characters.php on line 251

aqui está meu Player.php:

Spoiler

<?php
if(!defined('INITIALIZED'))
exit;

class Player extends ObjectData
{
   const LOADTYPE_ID = 'id';
   const LOADTYPE_NAME = 'name';
   const LOADTYPE_ACCOUNT_ID = 'account_id';
   public static $table = 'players';
   public $data = array('name' => null, 'world_id' => null, 'group_id' => null, 'account_id' => null, 'level' => null, 'vocation' => null, 'health' => null, 'healthmax' => null, 'experience' => null, 'lookbody' => null, 'lookfeet' => null, 'lookhead' => null, 'looklegs' => null, 'looktype' => null, 'lookaddons' => null, 'maglevel' => null, 'mana' => null, 'manamax' => null, 'manaspent' => null, 'soul' => null, 'town_id' => null, 'posx' => null, 'posy' => null, 'posz' => null, 'conditions' => null, 'cap' => null, 'sex' => null, 'lastlogin' => null, 'lastip' => null, 'save' => null, 'skull' => null, 'skulltime' => null, 'rank_id' => null, 'guildnick' => null, 'lastlogout' => null, 'blessings' => null, 'balance' => null, 'stamina' => null, 'direction' => null, 'loss_experience' => null, 'loss_mana' => null, 'loss_skills' => null, 'loss_containers' => null, 'loss_items' => null, 'premend' => null, 'online' => null, 'marriage' => null, 'promotion' => null, 'deleted' => null, 'description' => null, 'create_ip' => null, 'create_date' => null, 'comment' => null, 'hide_char' => null, 'signature' => null);
   public static $fields = array('id', 'name', 'world_id', 'group_id', 'account_id', 'level', 'vocation', 'health', 'healthmax', 'experience', 'lookbody', 'lookfeet', 'lookhead', 'looklegs', 'looktype', 'lookaddons', 'maglevel', 'mana', 'manamax', 'manaspent', 'soul', 'town_id', 'posx', 'posy', 'posz', 'conditions', 'cap', 'sex', 'lastlogin', 'lastip', 'save', 'skull', 'skulltime', 'rank_id', 'guildnick', 'lastlogout', 'blessings', 'balance', 'stamina', 'direction', 'loss_experience', 'loss_mana', 'loss_skills', 'loss_containers', 'loss_items', 'premend', 'online', 'marriage', 'promotion', 'deleted', 'description', 'create_ip', 'create_date', 'comment', 'hide_char', 'signature');
   public static $skillFields = array('player_id', 'skillid', 'value',   'count');
   public $items;
   public $storages;
   public $skills;
   public $account;
   public $rank;

public function __construct($search_text = null, $search_by = self::LOADTYPE_ID)
{
if($search_text != null)
$this->load($search_text, $search_by);
}

   public function load($search_text, $search_by = self::LOADTYPE_ID)
   {
       if(in_array($search_by, self::$fields))
           $search_string = $this->getDatabaseHandler()->fieldName($search_by) . ' = ' . $this->getDatabaseHandler()->quote($search_text);
       else
           new Error_Critic('', 'Wrong Player search_by type.');
       $fieldsArray = array();
       foreach(self::$fields as $fieldName)
           $fieldsArray[] = $this->getDatabaseHandler()->fieldName($fieldName);

$this->data = $this->getDatabaseHandler()->query('SELECT ' . implode(', ', $fieldsArray) . ' FROM ' . $this->getDatabaseHandler()->tableName(self::$table) . ' WHERE ' . $search_string)->fetch();
}

   public function loadById($id)
   {
       $this->load($id, self::LOADTYPE_ID);
   }

   public function loadByName($name)
   {
       $this->load($name, self::LOADTYPE_NAME);
   }

   public function save($forceInsert = false)
   {
       if(!isset($this->data['id']) || $forceInsert)
       {
           $keys = array();
           $values = array();
           foreach(self::$fields as $key)
               if($key != 'id')
               {
                   $keys[] = $this->getDatabaseHandler()->fieldName($key);
                   $values[] = $this->getDatabaseHandler()->quote($this->data[$key]);
               }
           $this->getDatabaseHandler()->query('INSERT INTO ' . $this->getDatabaseHandler()->tableName(self::$table) . ' (' . implode(', ', $keys) . ') VALUES (' . implode(', ', $values) . ')');
           $this->setID($this->getDatabaseHandler()->lastInsertId());
       }
       else
       {
           $updates = array();
           foreach(self::$fields as $key)
               $updates[] = $this->getDatabaseHandler()->fieldName($key) . ' = ' . $this->getDatabaseHandler()->quote($this->data[$key]);
           $this->getDatabaseHandler()->query('UPDATE ' . $this->getDatabaseHandler()->tableName(self::$table) . ' SET ' . implode(', ', $updates) . ' WHERE ' . $this->getDatabaseHandler()->fieldName('id') . ' = ' . $this->getDatabaseHandler()->quote($this->data['id']));
       }
   }

   public function getItems($forceReload = false)
   {
       if(!isset($this->items) || $forceReload)
           $this->items = new ItemsList($this->getID());

return $this->items;
}

   public function saveItems()
   {
       if(isset($this->items))
       {
           // if any script changed ID of player, function should save items with new player id
           $this->items->setPlayerId($this->getID());
           $this->items->save();
       }
       else
           new Error_Critic('', 'Player::saveItems() - items not loaded, cannot save');
   }

   public function loadStorages()
   {
       $this->storages = array();
       // load all
       $storages = $this->getDatabaseHandler()->query('SELECT ' . $this->getDatabaseHandler()->fieldName('player_id') . ', ' . $this->getDatabaseHandler()->fieldName('key') .
           ', ' . $this->getDatabaseHandler()->fieldName('value') . ' FROM ' .$this->getDatabaseHandler()->tableName('player_storage') .
           ' WHERE ' . $this->getDatabaseHandler()->fieldName('player_id') . ' = ' . $this->getDatabaseHandler()->quote($this->data['id']))->fetchAll();
       foreach($storages as $storage)
       {
           $this->storages[$storage['key']] = $storage['value'];
       }
   }

   public function saveStorages()
   {
       if(isset($this->storages))
       {
           $this->getDatabaseHandler()->query('DELETE FROM ' .$this->getDatabaseHandler()->tableName('player_storage') . ' WHERE ' . $this->getDatabaseHandler()->fieldName('player_id') . ' = ' . $this->getDatabaseHandler()->quote($this->data['id']));
           foreach($this->storages as $key => $value)
           {
               //save each
               $this->getDatabaseHandler()->query('INSERT INTO ' . $this->getDatabaseHandler()->tableName('player_storage') . ' (' . $this->getDatabaseHandler()->fieldName('player_id') . ', ' .
                   $this->getDatabaseHandler()->fieldName('key') . ', ' . $this->getDatabaseHandler()->fieldName('value') . ', ) VALUES (' .
                   $this->getDatabaseHandler()->quote($this->data['id']) . ', ' . $this->getDatabaseHandler()->quote($key) . ', ' . $this->getDatabaseHandler()->quote($value) . ')');
           }
       }
       else
           new Error_Critic('', 'Player::saveStorages() - storages not loaded, cannot save');
   }

   public function getStorage($key)
   {
       if(!isset($this->storages))
       {
           $this->loadStorages();
       }
       if(isset($this->storages[$key]))
           return $this->storages[$key];
       else
           return null;
   }

   public function getStorages()
   {
       if(!isset($this->storages))
       {
           $this->loadStorages();
       }
       return $this->storages;
   }

   public function setStorage($key, $value)
   {
       if(!isset($this->storages))
       {
           $this->loadStorages();
       }
       $this->storages[$key] = $value;
   }

   public function removeStorage($key)
   {
       if(!isset($this->storages))
       {
           $this->loadStorages();
       }
       if(isset($this->storages[$key]))
           unset($this->storages[$key]);
   }

   public function loadSkills()
   {
       $fieldsArray = array();
       foreach(self::$skillFields as $fieldName)
           $fieldsArray[] = $this->getDatabaseHandler()->fieldName($fieldName);

       $skills = $this->getDatabaseHandler()->query('SELECT ' . implode(', ', $fieldsArray) . ' FROM ' . $this->getDatabaseHandler()->fieldName('player_skills') . ' WHERE ' . $this->getDatabaseHandler()->fieldName('player_id') . ' = ' . $this->getDatabaseHandler()->quote($this->getID()))->fetchAll();
       $this->skills = array();
       foreach($skills as $skill)
           $this->skills[$skill['skillid']] = $skill;
   }

   public function getSkills($forceReload = false)
   {
       if(!isset($this->skills) || $forceReload)
           $this->loadSkills();

return $this->skills;
}

   public function getSkill($id, $forceReload = false)
   {
       if(!isset($this->skills) || $forceReload)
           $this->loadSkills();

       if(isset($this->skills[$id]))
           return $this->skills[$id]['value'];
       else
           new Error_Critic('', 'Player::getSkill() - Skill ' . htmlspecialchars($id) . ' does not exist');
   }

   public function setSkill($id, $value)
   {
       $this->skills[$id]['value'] = $value;
   }

   public function getSkillCount($id, $forceReload = false)
   {
       if(!isset($this->skills) || $forceReload)
           $this->loadSkills();

       if(isset($this->skills[$id]))
           return $this->skills[$id]['count'];
       else
           new Error_Critic('', 'Player::getSkillCount() - Skill ' . htmlspecialchars($id) . ' does not exist');
   }

   public function setSkillCount($id, $count)
   {
       $this->skills[$id]['count'] = $count;
   }

   public function saveSkills()
   {
       if(isset($this->skills))
       {
           $this->getDatabaseHandler()->query('DELETE FROM ' . $this->getDatabaseHandler()->tableName('player_skills') . ' WHERE ' . $this->getDatabaseHandler()->fieldName('player_id') . ' = ' . $this->getDatabaseHandler()->quote($this->getID()));

           if(count($this->skills) > 0)
           {
               $keys = array();
               foreach(self::$skillFields as $key)
                   $keys[] = $this->getDatabaseHandler()->fieldName($key);

               $query = 'INSERT INTO ' . $this->getDatabaseHandler()->tableName('player_skills') . ' (' . implode(', ', $keys) . ') VALUES ';
               foreach($this->skills as $skill)
               {
                   $fieldValues = array();
                   foreach(self::$skillFields as $key)
                       if($key != 'player_id')
                           $fieldValues[] = $this->getDatabaseHandler()->quote($skill[$key]);
                       else
                           $fieldValues[] = $this->getDatabaseHandler()->quote($this->getID());
                   $this->getDatabaseHandler()->query($query . '(' . implode(', ', $fieldValues) . ')');
               }
           }
       }
       else
           new Error_Critic('', 'Player::saveSkills() - skills not loaded, cannot save');
   }

   public function loadAccount()
   {
       $this->account = new Account($this->getAccountID());
   }

   public function getAccount($forceReload = false)
   {
       if(!isset($this->account) || $forceReload)
           $this->loadAccount();

return $this->account;
}

   public function setAccount($account)
   {
       $this->account = $account;
       $this->setAccountID($account->getID());
   }

   public function loadRank()
   {
       $this->rank = new GuildRank($this->getRankID());
   }

   public function getRank($forceReload = false)
   {
       if(!isset($this->rank) || $forceReload)
           $this->loadRank();

if($this->data['rank_id'] == 0)
{
return null;
}

return $this->rank;
}

   public function setRank($rank = null)
   {
       if(isset($rank))
       {
           $this->rank = $rank;
           $this->setRankID($rank->getID());
       }
       else
       {
           $this->rank = new GuildRank();
           $this->setRankID(0);
       }
   }

   public function hasGuild()
   {
       return $this->getRank()->isLoaded();
   }

   public function removeGuildInvitations()
   {
       $this->getDatabaseHandler()->query('DELETE FROM ' . $this->getDatabaseHandler()->tableName('guild_invites') . ' WHERE ' . $this->getDatabaseHandler()->fieldName('player_id') . ' = ' . $this->getDatabaseHandler()->quote($this->getID()));
   }

   public function unban()
   {
       $bans = new DatabaseList('Ban');
       $filterType = new SQL_Filter(new SQL_Field('type'), SQL_Filter::EQUAL, Ban::TYPE_PLAYER);
       $filterValue = new SQL_Filter(new SQL_Field('value'), SQL_Filter::EQUAL, $this->data['id']);
       $filterActive = new SQL_Filter(new SQL_Field('active'), SQL_Filter::EQUAL, 1);
       $filter = new SQL_Filter($filterType, SQL_Filter::CRITERIUM_AND, $filterValue);
       $filter = new SQL_Filter($filter, SQL_Filter::CRITERIUM_AND, $filterActive);
       $bans->setFilter($filter);
       foreach($bans as $ban)
       {
           $ban->setActive(0);
           $ban->save();
       }
   }

   public function isBanned()
   {
       $bans = new DatabaseList('Ban');
       $filterType = new SQL_Filter(new SQL_Field('type'), SQL_Filter::EQUAL, Ban::TYPE_PLAYER);
       $filterParam = new SQL_Filter(new SQL_Field('param'), SQL_Filter::EQUAL, Ban::PLAYERBAN_BANISHMENT);
       $filterValue = new SQL_Filter(new SQL_Field('value'), SQL_Filter::EQUAL, $this->data['id']);
       $filterActive = new SQL_Filter(new SQL_Field('active'), SQL_Filter::EQUAL, 1);
       $filter = new SQL_Filter($filterType, SQL_Filter::CRITERIUM_AND, $filterValue);
       $filter = new SQL_Filter($filter, SQL_Filter::CRITERIUM_AND, $filterActive);
       $filter = new SQL_Filter($filter, SQL_Filter::CRITERIUM_AND, $filterParam);
       $bans->setFilter($filter);
       $isBanned = false;
       foreach($bans as $ban)
       {
           if($ban->getExpires() <= 0 || $ban->isExpires() > time())
               $isBanned = true;
       }
       return $isBanned;
   }

   public function isNamelocked()
   {
       $bans = new DatabaseList('Ban');
       $filterType = new SQL_Filter(new SQL_Field('type'), SQL_Filter::EQUAL, Ban::TYPE_PLAYER);
       $filterParam = new SQL_Filter(new SQL_Field('param'), SQL_Filter::EQUAL, Ban::PLAYERBAN_LOCK);
       $filterValue = new SQL_Filter(new SQL_Field('value'), SQL_Filter::EQUAL, $this->data['id']);
       $filterActive = new SQL_Filter(new SQL_Field('active'), SQL_Filter::EQUAL, 1);
       $filter = new SQL_Filter($filterType, SQL_Filter::CRITERIUM_AND, $filterValue);
       $filter = new SQL_Filter($filter, SQL_Filter::CRITERIUM_AND, $filterActive);
       $filter = new SQL_Filter($filter, SQL_Filter::CRITERIUM_AND, $filterParam);
       $bans->setFilter($filter);
       return (count($bans) > 0);
   }

public function delete()
{
$this->db->query('UPDATE ' . $this->getDatabaseHandler()->tableName(self::$table) . ' SET ' . $this->getDatabaseHandler()->fieldName('deleted') . ' = 1 WHERE ' . $this->getDatabaseHandler()->fieldName('id') . ' = ' . $this->getDatabaseHandler()->quote($this->data['id']));

unset($this->data['id']);
   }
/*
* default tfs 0.3.6 fields
*/
   public function setID($value){$this->data['id'] = $value;}
   public function getID(){return $this->data['id'];}
   public function setAccountID($value){$this->data['account_id'] = $value;}
   public function getAccountID(){return $this->data['account_id'];}
   public function setWorldID($value){$this->data['world_id'] = $value;}
   public function getWorldID(){return $this->data['world_id'];}
   public function setName($value){$this->data['name'] = $value;}
   public function getName(){return $this->data['name'];}
   public function setGroupID($value){$this->data['group_id'] = $value;}
   public function getGroupID(){return $this->data['group_id'];}
   public function setVocation($value){$this->data['vocation'] = $value;}
   public function getVocation(){return $this->data['vocation'];}
   public function setPromotion($value){$this->data['promotion'] = $value;}
   public function getPromotion(){return $this->data['promotion'];}
   public function setLevel($value){$this->data['level'] = $value;}
   public function getLevel(){return $this->data['level'];}
   public function setExperience($value){$this->data['experience'] = $value;}
   public function getExperience(){return $this->data['experience'];}
   public function setHealth($value){$this->data['health'] = $value;}
   public function getHealth(){return $this->data['health'];}
   public function setHealthMax($value){$this->data['healthmax'] = $value;}
   public function getHealthMax(){return $this->data['healthmax'];}
   public function setMana($value){$this->data['mana'] = $value;}
   public function getMana(){return $this->data['mana'];}
   public function setManaMax($value){$this->data['manamax'] = $value;}
   public function getManaMax(){return $this->data['manamax'];}
   public function setMagLevel($value){$this->data['maglevel'] = $value;}
   public function getMagLevel(){return $this->data['maglevel'];}
   public function setManaSpent($value){$this->data['manaspent'] = $value;}
   public function getManaSpent(){return $this->data['manaspent'];}
   public function setSex($value){$this->data['sex'] = $value;}
   public function getSex(){return $this->data['sex'];}
   public function setTown($value){$this->data['town_id'] = $value;}
   public function getTown(){return $this->data['town_id'];}
   public function setPosX($value){$this->data['posx'] = $value;}
   public function getPosX(){return $this->data['posx'];}
   public function setPosY($value){$this->data['posy'] = $value;}
   public function getPosY(){return $this->data['posy'];}
   public function setPosZ($value){$this->data['posz'] = $value;}
   public function getPosZ(){return $this->data['posz'];}
   public function setCapacity($value){$this->data['cap'] = $value;}
   public function getCapacity(){return $this->data['cap'];}
   public function setSoul($value){$this->data['soul'] = $value;}
   public function getSoul(){return $this->data['soul'];}
   public function setConditions($value){$this->data['conditions'] = $value;}
   public function getConditions(){return $this->data['conditions'];}
   public function setLastIP($value){$this->data['lastip'] = $value;}
   public function getLastIP(){return $this->data['lastip'];}
   public function setLastLogin($value){$this->data['lastlogin'] = $value;}
   public function getLastLogin(){return $this->data['lastlogin'];}
   public function setLastLogout($value){$this->data['lastlogout'] = $value;}
   public function getLastLogout(){return $this->data['lastlogout'];}
   public function setSkull($value){$this->data['skull'] = $value;}
   public function getSkull(){return $this->data['skull'];}
   public function setSkullTime($value){$this->data['skulltime'] = $value;}
   public function getSkullTime(){return $this->data['skulltime'];}
   public function setRankID($value){$this->data['rank_id'] = $value;}
   public function getRankID(){return $this->data['rank_id'];}
   public function setGuildNick($value){$this->data['guildnick'] = $value;}
   public function getGuildNick(){return $this->data['guildnick'];}
   public function setSave($value = 1){$this->data['save'] = (int) $value;}
   public function getSave(){return $this->data['save'];}
   public function setBlessings($value){$this->data['blessings'] = $value;}
   public function getBlessings(){return $this->data['blessings'];}
   public function setBalance($value){$this->data['balance'] = $value;}
   public function getBalance(){return $this->data['balance'];}
   public function setStamina($value){$this->data['stamina'] = $value;}
   public function getStamina(){return $this->data['stamina'];}
   public function setDirection($value){$this->data['direction'] = $value;}
   public function getDirection(){return $this->data['direction'];}
   public function setLossExperience($value){$this->data['loss_experience'] = $value;}
   public function getLossExperience(){return $this->data['loss_experience'];}
   public function setLossMana($value){$this->data['loss_mana'] = $value;}
   public function getLossMana(){return $this->data['loss_mana'];}
   public function setLossSkills($value){$this->data['loss_skills'] = $value;}
   public function getLossSkills(){return $this->data['loss_skills'];}
   public function setLossContainers($value){$this->data['loss_containers'] = $value;}
   public function getLossContainers(){return $this->data['loss_containers'];}
   public function setLossItems($value){$this->data['loss_items'] = $value;}
   public function getLossItems(){return $this->data['loss_items'];}
   public function setOnline($value){$this->data['online'] = (int) $value;}
   public function getOnline(){return (bool) $this->data['online'];}
   public function setMarriage($value){$this->data['marriage'] = $value;}
   public function getMarriage(){return $this->data['marriage'];}
   public function setDeleted($value){$this->data['deleted'] = (int) $value;}
   public function isDeleted(){return (bool) $this->data['deleted'];}
   public function setDescription($value){$this->data['description'] = $value;}
   public function getDescription(){return $this->data['description'];}
   public function setLookBody($value){$this->data['lookbody'] = $value;}
   public function getLookBody(){return $this->data['lookbody'];}
   public function setLookFeet($value){$this->data['lookfeet'] = $value;}
   public function getLookFeet(){return $this->data['lookfeet'];}
   public function setLookHead($value){$this->data['lookhead'] = $value;}
   public function getLookHead(){return $this->data['lookhead'];}
   public function setLookLegs($value){$this->data['looklegs'] = $value;}
   public function getLookLegs(){return $this->data['looklegs'];}
   public function setLookType($value){$this->data['looktype'] = $value;}
   public function getLookType(){return $this->data['looktype'];}
   public function setLookAddons($value){$this->data['lookaddons'] = $value;}
   public function getLookAddons(){return $this->data['lookaddons'];}
/*
* Custom AAC fields
* create_ip , INT, default 0
* create_date , INT, default 0
* hide_char , INT, default 0
* comment , TEXT, default ''
*/
   public function setCreateIP($value){$this->data['create_ip'] = $value;}
   public function getCreateIP(){return $this->data['create_ip'];}
   public function setCreateDate($value){$this->data['create_date'] = $value;}
   public function getCreateDate(){return $this->data['create_date'];}
   public function setHidden($value){$this->data['hide_char'] = (int) $value;}
   public function isHidden(){return (bool) $this->data['hide_char'];}
   public function setComment($value){$this->data['comment'] = $value;}
   public function getComment(){return $this->data['comment'];}
/*
* for compability with old scripts
*/
   public function setGroup($value){$this->setGroupID($value);}
   public function getGroup(){return $this->getGroupID();}
   public function setWorld($value){$this->setWorldID($value);}
   public function getWorld(){return $this->getWorldID();}
   public function isOnline(){return $this->getOnline() == 1;}
   public function getCreated(){return $this->getCreateDate();}
   public function setCreated($value){$this->setCreateDate($value);}
   public function setCap($value){$this->setCapacity($value);}
   public function getCap(){return $this->getCapacity();}
   public function isSaveSet(){return $this->getSave();}
   public function unsetSave(){$this->setSave(0);}
   public function getTownId(){return $this->getTown();}
   public function getHideChar(){return $this->isHidden();}
   public function find($name){$this->loadByName($name);}
}

Underewar · Fevereiro 14, 2023

Editei o seu agora deve funcionar.

OTS_Player.php

ILex WilL · Fevereiro 14, 2023

Parse error: syntax error, unexpected $end, expecting T_FUNCTION in C:\xampp\htdocs\classes\player.php on line 498

deu esse erro ai agr

Edit: Deu certo mano era só colocar mais um "}" la no final para fechar o php.

Muito Obg denovo mano me ajudou de maais, obbggdo...

Editado Fevereiro 14, 2023 por ILex WilL (veja o histórico de edições)

Underewar · Fevereiro 14, 2023

10 minutos atrás, ILex WilL disse:

Parse error: syntax error, unexpected $end, expecting T_FUNCTION in C:\xampp\htdocs\classes\player.php on line 498

deu esse erro ai agr

Edit: Deu certo mano era só colocar mais um "}" la no final para fechar o php.

Muito Obg denovo mano me ajudou de maais, obbggdo...

tmj

Mateus Robeerto · Maio 25, 2023

poderia mandar gesior com reset completo? ou so essa parte themebox top reset?

Entrar

Website [Gesior] Rank Reset Please

Posts Recomendados

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Participe da conversa

Quem Está Navegando 0 membros estão online

Conteúdo Similar

TibiaKing

Open Tibia Server

Redes Sociais

Anuncie no TibiaKing

Informação Importante