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: e aqui está meu Layout.php:

[Gesior] Rank Reset Please

Postado Fevereiro 13, 2023 2 anos

Administrador

Me manda o script da widget

7 horas atrás, ILex WilL disse:

Isso na home pag, aqui no caso:

Ao Lado do Level

Contato :
https://www.linkedin.com/in/rafhael-oliveira/
Servidores :
https://www.pokemmorpg.com
Projetos :
https://github.com/thetibiaking

Citar

Mention

Postado Fevereiro 13, 2023 2 anos

Autor

11 horas atrás, Underewar disse:

Me manda o script da widget

é o layout, não?

Will

Citar

Mention

Postado Fevereiro 13, 2023 2 anos

Administrador
Solução

@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 2 anos por Underewar (veja o histórico de edições)

Contato :
https://www.linkedin.com/in/rafhael-oliveira/
Servidores :
https://www.pokemmorpg.com
Projetos :
https://github.com/thetibiaking

Citar

Mention

ILex WilL e Erimyth reagiu a isso
1
1

Postado Fevereiro 13, 2023 2 anos

Autor

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>';
   }
}
?>

Will

Citar

Mention

Postado Fevereiro 14, 2023 2 anos

Administrador

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 2 anos por Underewar (veja o histórico de edições)

Contato :
https://www.linkedin.com/in/rafhael-oliveira/
Servidores :
https://www.pokemmorpg.com
Projetos :
https://github.com/thetibiaking

Citar

Mention

ILex WilL reagiu a isso
1

Entrar

[Gesior] Rank Reset Please

Featured Replies

Top Posters In This Topic

Popular Days

Most Popular Posts

Under

Under

Under

Posted Images

Participe da conversa

Quem Está Navegando 0

Conteúdo Similar

Estatísticas dos Fóruns

Top Posters In This Topic

Popular Days

Most Popular Posts

Under

Under

Under

Posted Images

Informação Importante

Account

Navigation

Pesquisar