• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[Gesior AAC] Characters.php new look

Kavvson

Gdy boli cie glowa wez
Joined
Jun 25, 2008
Messages
1,177
Reaction score
72
Location
Poland
I dont support Gesior but someone requested it so i publish it.

Dont ask me for help in it :)

Just paste all into characters.php

2ltpl5h.jpg

PHP:
<?PHP
$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 ACTION="?subtopic=characters" METHOD=post><TABLE  WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD  CLASS="vdarkBorder" CLASS=white><B>Search  Character</B></TD></TR><TR><TD  CLASS="darkBorder"><TABLE BORDER=0  CELLPADDING=1><TR><TD>Name:</TD><TD><INPUT  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></TABLE></TD></TR></TABLE></FORM>';
}
else
{
    if(check_name($name)) {
        $player = $ots->createObject('Player');
        $player->find($name);
        if($player->isLoaded()) {
            $account = $player->getAccount();
?>

<?PHP

$main_content .= '<h3>'; $main_content .= '<font  color="';$main_content .= ($player->isOnline()) ? 'green' :  'red';$main_content .= '"> 
    <b>'.$player->getName().'</b></font>';  $main_content .= '  <b>'.$vocation_name[$player->getWorld()][$player->getPromotion()][$player->getVocation()].'</b></h3>
    <br>
<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR  CLASS="vdarkBorder"><TD align="left" COLSPAN=2  CLASS=white><B>Character</B></TD><TD  align="left" COLSPAN=2  CLASS=white><B>Information</B></TD></TR>
<tbody>
<tr><td style="text-align: center;"  CLASS="lightBorder"><img  src="http://img709.imageshack.us/img709/7005/sexd.png"></td><td  CLASS="lightBorder">
<b>'; $main_content .= ($player->getSex() == 0) ? 'Female' :  'Male'; $main_content .= ' </b><br><font size="1"  color="#484848">Sex</font><br></td>
<td style="text-align: center;" CLASS="lightBorder"><img  src="http://127.0.0.1/trunk.r123/public/images/charview/homejf.png"></td>
<td width="33%"  CLASS="lightBorder"><b>'.$towns_list[$player->getWorld()][$player->getTownId()].'</b><br>
<font size="1" color="#484848">Residence</font></td>
            </tr><tr>
            <td style="text-align: center;" width="10%"  CLASS="darkBorder"><img   src="http://img214.imageshack.us/img214/1918/voc.png"></td>
          <td CLASS="darkBorder">';
              $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 = darkBorder; } else {  $bgcolor = lightBorder; } $number_of_rows++;
                $main_content .= ''.$rank_of_player->getName().' of  the <a  href="?subtopic=guilds&action=show&guild='.$guild_id.'">'.$guild_name.'</a>';
            }
            }
$main_content .='<br>
            <font size="1"  color="#484848">Guild</font></td>
            <td style="text-align: center;"  CLASS="darkBorder"><img  src="http://images2.wikia.nocookie.net/tibia/en/images/c/c8/Cuckoo_Clock.gif"></td>
            <td CLASS="darkBorder"><b>';
            if(is_int($number_of_rows / 2)) { $bgcolor = darkBorder; }  else { $bgcolor = lightBorder; } $number_of_rows++;
            $lastlogin = $player->getLastLogin();
            if(empty($lastlogin))
                $main_content .= 'Never logged in.';
            else
                $main_content .= ''.date("j F Y, g:i a", $lastlogin).'';
                $main_content .= '</b><br>
            <font size="1" color="#484848">Last  login</font></td>
            </tr>
            
        <tr><td style="text-align: center;" width="10%"  CLASS="lightBorder"><img   src="http://images2.wikia.nocookie.net/tibia/en/images/5/56/Winning_Lottery_Ticket.gif"></td>
        <td CLASS="lightBorder"><b>'; $main_content .=  ($account->isPremium()) ? '<b><font color="green">Premium  Account</font></b>' : '<b><font  color="red">Free Account</font></b>'; $main_content  .='</b><br></td>
           <td style="text-align: center;"  CLASS="lightBorder"><img  src="http://images3.wikia.nocookie.net/tibia/en/images/5/5a/Research_Notes.gif"></td>
                <td CLASS="lightBorder"><b>'.date("j F Y,  g:i a", $player->getCreated()).'</b><br>
             <font size="1"  color="#484848">Created</font></td>
        </tr>
        
        <tr><td style="text-align: center;" width="10%"  CLASS="darkBorder"><img  src="http://img9.imageshack.us/img9/166/worldvo.png"></td>
          <td CLASS="darkBorder">';
          $group = $player->getGroup();
            if ($group == 1){$group_name = 'Player';}
            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 = 1)
            {
              $main_content .= ' '.$group_name.' ';
            } 
            $main_content .= '<br><font size="1"  color="#484848">Game Position</font></td>
            <td style="text-align: center;" width="10%"  CLASS="darkBorder"><img  src="http://img16.imageshack.us/img16/6509/rangor.png"></td>
            <td  CLASS="darkBorder"><b>'.$player->getLevel().'</b><br>
            <font size="1"  color="#484848">Level</font><br>
    </td>
    <tr><td style="text-align: center;"  CLASS="lightBorder">';            
    $id = $player->getCustomField("id");
                        $listaddon =  array('128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','158','159','251','252','268','269','270','273','278','279','288','289','302','324','325');
                        $lookadd = array('0','1','2','3');
         foreach ($listaddon as $pid => $name)
                        foreach ($lookadd as $addo => $name) {
                        $addon1 = $SQL->query('SELECT * FROM players  WHERE id = '.$id.' AND looktype = '.$listaddon[$pid].' AND lookaddons =  '.$lookadd[$addo].';')->fetch();

                           if($addon1[looktype] == true ) {


                        $finaddon = $addon1[looktype] +  $addon1[lookaddons] * 300;
                        }
                        }
            $main_content .= '<center><img  src="http://otland.net/images/addons/'.$finaddon.'.gif"/></center>';   $main_content .= '</td><td CLASS="lightBorder">
<b>
Outfit
</b><br><font size="1"  color="#484848"></font><br></td>
<td style="text-align: center;" CLASS="lightBorder"><img  src="http://img12.imageshack.us/img12/6592/1988f.gif"></td>
<td width="33%"  CLASS="lightBorder"><b>'.$player->getCap().'</b><br>
<font size="1" color="#484848">Cap</font></td>
            </tr><tr>
            <td style="text-align: center;" width="10%"  CLASS="darkBorder"><img   src="http://img88.imageshack.us/img88/7540/1685e.gif"></td>
          <td  CLASS="darkBorder"><b>'.$player->getHealth().'</b>';

$main_content .='<br>
            <font size="1"  color="#484848">Health</font></td>
            <td style="text-align: center;"  CLASS="darkBorder"><img  src="http://img198.imageshack.us/img198/9263/1686.gif"></td>
            <td CLASS="darkBorder"><b>';

                $main_content .=  '<b>'.$player->getMana().'</b>';
                $main_content .= '</b><br>
            <font size="1"  color="#484848">Mana</font></td>
            </tr>
    </tr>
    </tbody>
</table>
';

$main_content .= '<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0  WIDTH=100%><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4  WIDTH=100%><TR CLASS="vdarkBorder" ></TR>';
            
            //modified status scripts by ballack13
            $main_content .= '<table width=100%><tr>';
             //equipment shower by ballack13
            $id = $player->getCustomField("id");
            $number_of_items = 1;
            $main_content .= '<td align=center><table with=100%  style="border: solid 1px #888888;"  CELLSPACING="1"><TR>';        
                        $list =  array('2','1','3','6','4','5','9','7','10','8');
                        foreach ($list as $pid => $name) {
                        $top = $SQL->query('SELECT * FROM  player_items WHERE player_id = '.$id.' AND pid =  '.$list[$pid].';')->fetch();
                           if($top[itemtype] == false) {
                           if($list[$pid] == '8') {
            $main_content .= '<td style="background-color:  '.$config['site']['darkborder'].'; text-align:  center;">Soul:<br/>'.$player->getSoul().'</td>';
            }
                if(is_int($number_of_items / 3)){
            $main_content .= '<TD style="background-color:  '.$config['site']['darkborder'].'; text-align: center;"><img  src="http://otland.net/images/items/'.$list[$pid].'.gif"/></TD></tr><tr>';
                } else {
            $main_content .= '<TD style="background-color:  '.$config['site']['darkborder'].'; text-align: center;"><img  src="http://otland.net/images/items/'.$list[$pid].'.gif"/></TD>';
            }
                $number_of_items++;
            }
            else
            {
                           if($list[$pid] == '8') {
            $main_content .= '<td style="background-color:  '.$config['site']['darkborder'].'; text-align:  center;">Soul:<br/>'.$player->getSoul().'</td>';
            }
                if(is_int($number_of_items / 3))
            $main_content .= '<TD style="background-color:  '.$config['site']['darkborder'].'; text-align: center;"><img  src="http://otland.net/images/items/'.$top[itemtype].'.gif"  width="45"/></TD></tr><tr>';
                else
            $main_content .= '<TD style="background-color:  '.$config['site']['darkborder'].'; text-align: center;"><img  src="http://otland.net/images/items/'.$top[itemtype].'.gif"  width="45"/></TD>';
                $number_of_items++;
            }
                           if($list[$pid] == '8') {
            $main_content .= '<td style="background-color:  '.$config['site']['darkborder'].'; text-align:  center;">Cap:<br/>'.$player->getCap().'</td>';
            }
            }
            $main_content .= '</tr></TABLE></td>';

            //Hp/Mana/Exp Status by ballack13
            $hp = ($player->getHealth() / $player->getHealthMax() *  100);
            $main_content .= '<td align=center ><table  width=100%><tr><td align=center><table CELLSPACING="1"  CELLPADDING="4"><tr><td BGCOLOR="#D4C0A1" align="left"  width="20%"><b>Player Health:</b></td>
                    <td BGCOLOR="#D4C0A1"  align="left">'.$player->getHealth().'/'.$player->getHealthMax().'<div  style="width: 100%; height: 3px; border: 1px solid #000;"><div  style="background: red; width: '.$hp.'%; height:  3px;"></td></tr>';
            if ($player->getManaMax() > 0) {
                $mana = ($player->getMana() /  $player->getManaMax() * 100);
                $main_content .= '<tr><td BGCOLOR="#F1E0C6"  align="left"><b>Player Mana:</b></td><td  BGCOLOR="#F1E0C6"  align="left">'.$player->getMana().'/'.$player->getManaMax().'<div  style="width: 100%; height: 3px; border: 1px solid #000;"><div  style="background: blue; width: '.$mana.'%; height:  3px;"></td>'; 
            } else {
            $main_content .= '<tr><td BGCOLOR="#F1E0C6"  align="left"><b>Player Mana:</b></td><td  BGCOLOR="#F1E0C6" align="left">0/0<div style="width: 100%; height:  3px; border: 1px solid #000;"><div style="background: blue;  width: 100%; height: 3px;"></td>'; }
            $main_content .= '</tr></table><tr>';
            $next = ($player->getLevel() + 1);
            $exp = ((50 / 3) * ($player->getLevel() *  $player->getLevel() * $player->getLevel()) - (100 *  ($player->getLevel() * $player->getLevel())) + ((850/3) *  $player->getLevel()) - 200);
            $expnext = ((50 / 3) * ($next * $next * $next) - (100 *  ($next * $next)) + ((850/3) * $next) - 200 -  $player->getExperience());
            $expresult = ($expnext / (($expnext  +  $player->getExperience()) - $exp) * 100);
            $main_content .= '<tr><table CELLSPACING="1"  CELLPADDING="4"><tr><td  BGCOLOR="'.$config['site']['lightborder'].'" align="left"  width="20%"><b>Player Level:</b></td><td  BGCOLOR="'.$config['site']['lightborder'].'"  align="left">'.$player->getLevel().'</td></tr>
                    <tr><td  BGCOLOR="'.$config['site']['darkborder'].'"  align="left"><b>Player Experience:</b></td><td  BGCOLOR="'.$config['site']['darkborder'].'"  align="left">'.$player->getExperience().'  EXP.</td></tr>
                    <tr><td  BGCOLOR="'.$config['site']['lightborder'].'" align="left"><b>To  Next Level:</b></td><td  BGCOLOR="'.$config['site']['lightborder'].'" align="left">You need  <b>'.$exp.' EXP</b> to Level  <b>'.$next.'</b>.<div title="99.320604545 %"  style="width: 100%; height: 3px; border: 1px solid #000;"><div  style="background: red; width: '.$expresult.'%; height:  3px;"></td></tr></table></td></tr></table></tr></TABLE></td>';
            if($config['site']['show_skills_info']) {
            //Skills Pics v2. Table borders optimized by Absolute Mango
            $main_content .= '<br/><table cellspacing="0"  cellpadding="0" border="0" width="200"  align="center"><caption><strong>Skills</strong></caption><tbody><tr>
            <td align="center"><a  href="?subtopic=highscores&list=experience"><img  src="http://otland.net/images/skills/level.png" style="border:  none;"/></a></td>
            <td align="center"><a  href="?subtopic=highscores&list=magic"><img  src="http://otland.net/images/skills/ml.png" style="border:  none;"/></a></td>
            <td align="center"><a  href="?subtopic=highscores&list=fist"><img  src="http://otland.net/images/skills/fist.png" style="border:  none;"/></a></td>
            <td align="center"><a  href="?subtopic=highscores&list=club"><img  src="http://otland.net/images/skills/club.png" style="border:  none;"/></a></td>
            <td align="center"><a  href="?subtopic=highscores&list=sword"><img  src="http://otland.net/images/skills/sword.png" style="border:  none;"/></a></td>
            <td align="center"><a  href="?subtopic=highscores&list=axe"><img  src="http://otland.net/images/skills/axe.png" style="border:  none;"/></a></td>
            <td align="center"><a  href="?subtopic=highscores&list=distance"><img  src="http://otland.net/images/skills/dist.png" style="border:  none;"/></a></td>
            <td align="center"><a  href="?subtopic=highscores&list=shield"><img  src="http://otland.net/images/skills/def.png" style="border:  none;"/></a></td>
            <td align="center"><a  href="?subtopic=highscores&list=fishing"><img  src="http://otland.net/images/skills/fish.png" style="border:  none;"/></a></td>
            </tr></tbody></table>
            <table cellspacing="0" cellpadding="0" border="1"  width="360" align="center"><tbody><tr><tr  bgcolor="'.$config['site']['darkborder'].'">
            <td align="center"  width="38"><strong>Level</strong></td>
            <td align="center"  width="38"><strong>ML</strong></td>
            <td align="center"  width="42"><strong>Fist</strong></td>
            <td align="center"  width="40"><strong>Club</strong></td>
            <td align="center"  width="38"><strong>Swrd</strong></td>
            <td align="center"  width="38"><strong>Axe</strong></td>
            <td align="center"  width="38"><strong>Dist</strong></td>
            <td align="center"  width="38"><strong>Shield</strong></td>
            <td align="center"  width="38"><strong>Fish</strong></td></font>
        </tr>
        <tr bgcolor="'.$config['site']['lightborder'].'">
            <td align="center"  width="38">'.$player->getLevel().'</td>
            <td align="center"  width="38">'.$player->getMagLevel().'</td>
            <td align="center"  width="38">'.$player->getSkill(0).'</td>
            <td align="center"  width="38">'.$player->getSkill(1).'</td>
            <td align="center"  width="38">'.$player->getSkill(2).'</td>
            <td align="center"  width="38">'.$player->getSkill(3).'</td>
            <td align="center"  width="38">'.$player->getSkill(4).'</td>
            <td align="center"  width="38">'.$player->getSkill(5).'</td>
            <td align="center"  width="38">'.$player->getSkill(6).'</td>
        </tr></tbody></table><div table  align="center">&nbsp;<br />&nbsp;</div>';
            //skill script end
            }
            //quest status by ballack13
            $id = $player->getCustomField("id");
            $number_of_quests = 0;
            $main_content .= '<TABLE BORDER=0 CELLSPACING=1  CELLPADDING=4 WIDTH=100%><TR  BGCOLOR='.$config['site']['vdarkborder'].'><TD align="left"  COLSPAN=2 CLASS=white><B>Quests</B></TD></TD  align="right"></TD></TR>';        
                        $quests = $config['site']['quests'];
                        foreach ($quests as $storage => $name) {
                if(is_int($number_of_quests / 2))
                    $bgcolor = $config['site']['darkborder'];
                else
                    $bgcolor = $config['site']['lightborder'];
                $number_of_quests++;
            $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD  WIDTH=95%>'.$storage.'</TD>';
                        $quest = $SQL->query('SELECT * FROM  player_storage WHERE player_id = '.$id.' AND `key` =  '.$quests[$storage].';')->fetch();
                           if($quest == false) {
            $main_content .= '<TD><img  src="http://otland.net/images/false.png"/></TD></TR>';
                        }
            else
            {
            $main_content .= '<TD><img  src="http://otland.net/images/true.png"/></TD></TR>';
            }
            }

            $main_content .=  '</TABLE></td></tr></table><br />';
            $deads = 0;
            
                        //frags list by Xampy 
             
            $frags_limit = 10; // 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().' ORDER BY `date`  DESC LIMIT 0,'.$frags_limit.';'); 
            if(count($player_frags)) 
            { 
                $frags = 0; 
                $frag_add_content .= '<TABLE BORDER=0 CELLSPACING=1  CELLPADDING=4 WIDTH=100%><br><TR  BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2  CLASS=white><B>Victims</B></TD></TR>'; 
                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\">".date("j M  Y, H:i", $frag['date'])."</td> 
                    <td>".(($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 >= 1) 
                $main_content .= $frag_add_content . '</TABLE>'; 
            } 
            // end of frags list by Xampy  

            //deaths list
            $player_deaths = $SQL->query('SELECT `id`, `date`,  `level` FROM `player_deaths` WHERE `player_id` = '.$player->getId().'  ORDER BY `date` DESC LIMIT 0,10;');
            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\">".date("j M Y,  H:i", $death['date'])."</td>
                <td>";
                $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)
                $main_content .= '<TABLE BORDER=0 CELLSPACING=1  CELLPADDING=4 WIDTH=100%><TR  BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2  CLASS=white><B>Deaths</B></TD></TR>' .  $dead_add_content . '</TABLE><br />';

            //end
            if(!$player->getHideChar()) {
                $main_content .= '<TABLE  BORDER=0><TR><TD></TD></TR></TABLE><TABLE  BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR  BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2  CLASS=white><B>Account  Information</B></TD></TR>';
                if($account->getRLName())
                {
                    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%>Real  name:</TD><TD>'.$account->getRLName().'</TD></TR>';
                }
                if($account->getLocation())
                {
                    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']['darkborder'].'><TD  WIDTH=20%>Location:</TD><TD>'.$account->getLocation().'</TD></TR>';
                }
                if(is_int($number_of_rows / 2)) { $bgcolor =  $config['site']['darkborder']; } else { $bgcolor =  $config['site']['lightborder']; } $number_of_rows++;
                if($account->getLastLogin())
                    $main_content .= '<TR  BGCOLOR='.$config['site']['lightborder'].'><TD WIDTH=20%>Last  login:</TD><TD>'.date("j F Y, g:i a",  $account->getLastLogin()).'</TD></TR>';
                else
                    $main_content .= '<TR  BGCOLOR='.$config['site']['lightborder'].'><TD WIDTH=20%>Last  login:</TD><TD>Never logged in.</TD></TR>';
                if($account->getCreated())
                {
                    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%>Created:</TD><TD>'.date("j F Y, g:i a",  $account->getCreated()).'</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>Account*Status:</TD><TD>';
                $main_content .= ($account->isPremium()) ?  '<b><font color="green">Premium  Account</font></b>' : '<b><font color="red">Free  Account</font></b>';
                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 .= '</TD></TR></TABLE>';
                $main_content .= '<br><TABLE  BORDER=0><TR><TD></TD></TR></TABLE><TABLE  BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR  BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=5  CLASS=white><B>Characters</B></TD></TR>
                <TR  BGCOLOR='.$config['site']['darkborder'].'><TD><B>Name</B></TD><TD><B>World</B></TD><TD><B>Level</B></TD><TD><b>Status</b></TD><TD><B>*</B></TD></TR>';
                $account_players = $account->getPlayersList();
                $account_players->orderBy('name');
                $player_number = 0;
                foreach($account_players as $player_list)
                {
                    if(!$player_list->getHideChar())
                    {
                        $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">Offline</font>';
                        else
                            $player_list_status = '<font  color="green">Online</font>';
                        $main_content .= '<TR  BGCOLOR="'.$bgcolor.'"><TD  WIDTH=52%><NOBR>'.$player_number.'.*'.$player_list->getName();
                        $main_content .= ($player_list->isDeleted()) ?  '<font color="red"> [DELETED]</font>' : '';
                        $main_content .= '</NOBR></TD><TD   WIDTH=15%>'.$config['site']['worlds'][$player_list->getWorld()].'</TD><TD  WIDTH=25%>'.$player_list->getLevel().'  '.$vocation_name[$player_list->getWorld()][$player_list->getPromotion()][$player_list->getVocation()].'</TD><TD   WIDTH="8%"><b>'.$player_list_status.'</b></TD><TD><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></TD><TD><IMG  SRC="'.$layout_name.'/images/general/blank.gif" WIDTH=10 HEIGHT=1  BORDER=0></TD></TR></TABLE>';
            }
            $main_content .= '<BR><BR><FORM  ACTION="?subtopic=characters" METHOD=post><TABLE WIDTH=100%  BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD  BGCOLOR="'.$config['site']['vdarkborder'].'"  CLASS=white><B>Search  Character</B></TD></TR><TR><TD  BGCOLOR="'.$config['site']['darkborder'].'"><TABLE BORDER=0  CELLPADDING=1><TR><TD>Name:</TD><TD><INPUT  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></TABLE></TD></TR></TABLE></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  ACTION="?subtopic=characters" METHOD=post><TABLE WIDTH=100%  BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD  BGCOLOR="'.$config['site']['vdarkborder'].'"  CLASS=white><B>Search  Character</B></TD></TR><TR><TD  BGCOLOR="'.$config['site']['darkborder'].'"><TABLE BORDER=0  CELLPADDING=1><TR><TD>Name:</TD><TD><INPUT  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></TABLE></TD></TR></TABLE></FORM>';
    }
}
?>
 
Last edited by a moderator:
2ltpl5h.jpg

PHP:
<?PHP
$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 ACTION="?subtopic=characters" METHOD=post><TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD CLASS="vdarkBorder" CLASS=white><B>Search Character</B></TD></TR><TR><TD CLASS="darkBorder"><TABLE BORDER=0 CELLPADDING=1><TR><TD>Name:</TD><TD><INPUT 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></TABLE></TD></TR></TABLE></FORM>';
}
else
{
	if(check_name($name)) {
		$player = $ots->createObject('Player');
		$player->find($name);
		if($player->isLoaded()) {
			$account = $player->getAccount();
?>

<?PHP

$main_content .= '<h3>'; $main_content .= '<font color="';$main_content .= ($player->isOnline()) ? 'green' : 'red';$main_content .= '"> 
	<b>'.$player->getName().'</b></font>'; $main_content .= ' <b>'.$vocation_name[$player->getWorld()][$player->getPromotion()][$player->getVocation()].'</b></h3>
	<br>
<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR CLASS="vdarkBorder"><TD align="left" COLSPAN=2 CLASS=white><B>Character</B></TD><TD align="left" COLSPAN=2 CLASS=white><B>Information</B></TD></TR>
<tbody>
<tr><td style="text-align: center;" CLASS="lightBorder"><img src="http://img709.imageshack.us/img709/7005/sexd.png"></td><td CLASS="lightBorder">
<b>'; $main_content .= ($player->getSex() == 0) ? 'Female' : 'Male'; $main_content .= ' </b><br><font size="1" color="#484848">Sex</font><br></td>
<td style="text-align: center;" CLASS="lightBorder"><img src="http://127.0.0.1/trunk.r123/public/images/charview/homejf.png"></td>
<td width="33%" CLASS="lightBorder"><b>'.$towns_list[$player->getWorld()][$player->getTownId()].'</b><br>
<font size="1" color="#484848">Residence</font></td>
            </tr><tr>
            <td style="text-align: center;" width="10%" CLASS="darkBorder"><img  src="http://img214.imageshack.us/img214/1918/voc.png"></td>
          <td CLASS="darkBorder">';
		  	$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 = darkBorder; } else { $bgcolor = lightBorder; } $number_of_rows++;
				$main_content .= ''.$rank_of_player->getName().' of the <a href="?subtopic=guilds&action=show&guild='.$guild_id.'">'.$guild_name.'</a>';
			}
			}
$main_content .='<br>
            <font size="1" color="#484848">Guild</font></td>
            <td style="text-align: center;" CLASS="darkBorder"><img src="http://images2.wikia.nocookie.net/tibia/en/images/c/c8/Cuckoo_Clock.gif"></td>
            <td CLASS="darkBorder"><b>';
			if(is_int($number_of_rows / 2)) { $bgcolor = darkBorder; } else { $bgcolor = lightBorder; } $number_of_rows++;
			$lastlogin = $player->getLastLogin();
			if(empty($lastlogin))
				$main_content .= 'Never logged in.';
			else
				$main_content .= ''.date("j F Y, g:i a", $lastlogin).'';
				$main_content .= '</b><br>
            <font size="1" color="#484848">Last login</font></td>
            </tr>
			
        <tr><td style="text-align: center;" width="10%" CLASS="lightBorder"><img  src="http://images2.wikia.nocookie.net/tibia/en/images/5/56/Winning_Lottery_Ticket.gif"></td>
        <td CLASS="lightBorder"><b>'; $main_content .= ($account->isPremium()) ? '<b><font color="green">Premium Account</font></b>' : '<b><font color="red">Free Account</font></b>'; $main_content .='</b><br></td>
           <td style="text-align: center;" CLASS="lightBorder"><img src="http://images3.wikia.nocookie.net/tibia/en/images/5/5a/Research_Notes.gif"></td>
				<td CLASS="lightBorder"><b>'.date("j F Y, g:i a", $player->getCreated()).'</b><br>
             <font size="1" color="#484848">Created</font></td>
        </tr>
		
        <tr><td style="text-align: center;" width="10%" CLASS="darkBorder"><img src="http://img9.imageshack.us/img9/166/worldvo.png"></td>
          <td CLASS="darkBorder">';
		  $group = $player->getGroup();
		    if ($group == 1){$group_name = 'Player';}
            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 = 1)
            {
              $main_content .= ' '.$group_name.' ';
            } 
			$main_content .= '<br><font size="1" color="#484848">Game Position</font></td>
            <td style="text-align: center;" width="10%" CLASS="darkBorder"><img src="http://img16.imageshack.us/img16/6509/rangor.png"></td>
            <td CLASS="darkBorder"><b>'.$player->getLevel().'</b><br>
            <font size="1" color="#484848">Level</font><br>
	</td>
	<tr><td style="text-align: center;" CLASS="lightBorder">';            
	$id = $player->getCustomField("id");
                        $listaddon = array('128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','158','159','251','252','268','269','270','273','278','279','288','289','302','324','325');
                        $lookadd = array('0','1','2','3');
         foreach ($listaddon as $pid => $name)
                        foreach ($lookadd as $addo => $name) {
                        $addon1 = $SQL->query('SELECT * FROM players WHERE id = '.$id.' AND looktype = '.$listaddon[$pid].' AND lookaddons = '.$lookadd[$addo].';')->fetch();

                           if($addon1[looktype] == true ) {


                        $finaddon = $addon1[looktype] + $addon1[lookaddons] * 300;
						}
						}
            $main_content .= '<center><img src="images/addons/'.$finaddon.'.gif"/></center>';  $main_content .= '</td><td CLASS="lightBorder">
<b>
Outfit
</b><br><font size="1" color="#484848"></font><br></td>
<td style="text-align: center;" CLASS="lightBorder"><img src="http://img12.imageshack.us/img12/6592/1988f.gif"></td>
<td width="33%" CLASS="lightBorder"><b>'.$player->getCap().'</b><br>
<font size="1" color="#484848">Cap</font></td>
            </tr><tr>
            <td style="text-align: center;" width="10%" CLASS="darkBorder"><img  src="http://img88.imageshack.us/img88/7540/1685e.gif"></td>
          <td CLASS="darkBorder"><b>'.$player->getHealth().'</b>';

$main_content .='<br>
            <font size="1" color="#484848">Health</font></td>
            <td style="text-align: center;" CLASS="darkBorder"><img src="http://img198.imageshack.us/img198/9263/1686.gif"></td>
            <td CLASS="darkBorder"><b>';

				$main_content .= '<b>'.$player->getMana().'</b>';
				$main_content .= '</b><br>
            <font size="1" color="#484848">Mana</font></td>
            </tr>
    </tr>
    </tbody>
</table>
';

$main_content .= '<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100%><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR CLASS="vdarkBorder" ></TR>';
			
			//modified status scripts by ballack13
			$main_content .= '<table width=100%><tr>';
             //equipment shower by ballack13
			$id = $player->getCustomField("id");
			$number_of_items = 1;
			$main_content .= '<td align=center><table with=100% style="border: solid 1px #888888;" CELLSPACING="1"><TR>';		
                        $list = array('2','1','3','6','4','5','9','7','10','8');
                        foreach ($list as $pid => $name) {
                        $top = $SQL->query('SELECT * FROM player_items WHERE player_id = '.$id.' AND pid = '.$list[$pid].';')->fetch();
                           if($top[itemtype] == false) {
                           if($list[$pid] == '8') {
			$main_content .= '<td style="background-color: '.$config['site']['darkborder'].'; text-align: center;">Soul:<br/>'.$player->getSoul().'</td>';
			}
				if(is_int($number_of_items / 3)){
			$main_content .= '<TD style="background-color: '.$config['site']['darkborder'].'; text-align: center;"><img src="images/items/'.$list[$pid].'.gif"/></TD></tr><tr>';
				} else {
			$main_content .= '<TD style="background-color: '.$config['site']['darkborder'].'; text-align: center;"><img src="images/items/'.$list[$pid].'.gif"/></TD>';
			}
				$number_of_items++;
			}
			else
			{
                           if($list[$pid] == '8') {
			$main_content .= '<td style="background-color: '.$config['site']['darkborder'].'; text-align: center;">Soul:<br/>'.$player->getSoul().'</td>';
			}
				if(is_int($number_of_items / 3))
			$main_content .= '<TD style="background-color: '.$config['site']['darkborder'].'; text-align: center;"><img src="images/items/'.$top[itemtype].'.gif" width="45"/></TD></tr><tr>';
				else
			$main_content .= '<TD style="background-color: '.$config['site']['darkborder'].'; text-align: center;"><img src="images/items/'.$top[itemtype].'.gif" width="45"/></TD>';
				$number_of_items++;
			}
                           if($list[$pid] == '8') {
			$main_content .= '<td style="background-color: '.$config['site']['darkborder'].'; text-align: center;">Cap:<br/>'.$player->getCap().'</td>';
			}
			}
			$main_content .= '</tr></TABLE></td>';

            //Hp/Mana/Exp Status by ballack13
			$hp = ($player->getHealth() / $player->getHealthMax() * 100);
			$main_content .= '<td align=center ><table width=100%><tr><td align=center><table CELLSPACING="1" CELLPADDING="4"><tr><td BGCOLOR="#D4C0A1" align="left" width="20%"><b>Player Health:</b></td>
					<td BGCOLOR="#D4C0A1" align="left">'.$player->getHealth().'/'.$player->getHealthMax().'<div style="width: 100%; height: 3px; border: 1px solid #000;"><div style="background: red; width: '.$hp.'%; height: 3px;"></td></tr>';
			if ($player->getManaMax() > 0) {
				$mana = ($player->getMana() / $player->getManaMax() * 100);
				$main_content .= '<tr><td BGCOLOR="#F1E0C6" align="left"><b>Player Mana:</b></td><td BGCOLOR="#F1E0C6" align="left">'.$player->getMana().'/'.$player->getManaMax().'<div style="width: 100%; height: 3px; border: 1px solid #000;"><div style="background: blue; width: '.$mana.'%; height: 3px;"></td>'; 
			} else {
			$main_content .= '<tr><td BGCOLOR="#F1E0C6" align="left"><b>Player Mana:</b></td><td BGCOLOR="#F1E0C6" align="left">0/0<div style="width: 100%; height: 3px; border: 1px solid #000;"><div style="background: blue; width: 100%; height: 3px;"></td>'; }
			$main_content .= '</tr></table><tr>';
			$next = ($player->getLevel() + 1);
			$exp = ((50 / 3) * ($player->getLevel() * $player->getLevel() * $player->getLevel()) - (100 * ($player->getLevel() * $player->getLevel())) + ((850/3) * $player->getLevel()) - 200);
			$expnext = ((50 / 3) * ($next * $next * $next) - (100 * ($next * $next)) + ((850/3) * $next) - 200 - $player->getExperience());
			$expresult = ($expnext / (($expnext  + $player->getExperience()) - $exp) * 100);
			$main_content .= '<tr><table CELLSPACING="1" CELLPADDING="4"><tr><td BGCOLOR="'.$config['site']['lightborder'].'" align="left" width="20%"><b>Player Level:</b></td><td BGCOLOR="'.$config['site']['lightborder'].'" align="left">'.$player->getLevel().'</td></tr>
					<tr><td BGCOLOR="'.$config['site']['darkborder'].'" align="left"><b>Player Experience:</b></td><td BGCOLOR="'.$config['site']['darkborder'].'" align="left">'.$player->getExperience().' EXP.</td></tr>
					<tr><td BGCOLOR="'.$config['site']['lightborder'].'" align="left"><b>To Next Level:</b></td><td BGCOLOR="'.$config['site']['lightborder'].'" align="left">You need <b>'.$exp.' EXP</b> to Level <b>'.$next.'</b>.<div title="99.320604545 %" style="width: 100%; height: 3px; border: 1px solid #000;"><div style="background: red; width: '.$expresult.'%; height: 3px;"></td></tr></table></td></tr></table></tr></TABLE></td>';
			if($config['site']['show_skills_info']) {
			//Skills Pics v2. Table borders optimized by Absolute Mango
			$main_content .= '<br/><table cellspacing="0" cellpadding="0" border="0" width="200" align="center"><caption><strong>Skills</strong></caption><tbody><tr>
            <td align="center"><a href="?subtopic=highscores&list=experience"><img src="images/skills/level.png" style="border: none;"/></a></td>
            <td align="center"><a href="?subtopic=highscores&list=magic"><img src="images/skills/ml.png" style="border: none;"/></a></td>
            <td align="center"><a href="?subtopic=highscores&list=fist"><img src="images/skills/fist.png" style="border: none;"/></a></td>
            <td align="center"><a href="?subtopic=highscores&list=club"><img src="images/skills/club.png" style="border: none;"/></a></td>
            <td align="center"><a href="?subtopic=highscores&list=sword"><img src="images/skills/sword.png" style="border: none;"/></a></td>
            <td align="center"><a href="?subtopic=highscores&list=axe"><img src="images/skills/axe.png" style="border: none;"/></a></td>
            <td align="center"><a href="?subtopic=highscores&list=distance"><img src="images/skills/dist.png" style="border: none;"/></a></td>
            <td align="center"><a href="?subtopic=highscores&list=shield"><img src="images/skills/def.png" style="border: none;"/></a></td>
            <td align="center"><a href="?subtopic=highscores&list=fishing"><img src="images/skills/fish.png" style="border: none;"/></a></td>
			</tr></tbody></table>
			<table cellspacing="0" cellpadding="0" border="1" width="360" align="center"><tbody><tr><tr bgcolor="'.$config['site']['darkborder'].'">
            <td align="center" width="38"><strong>Level</strong></td>
            <td align="center" width="38"><strong>ML</strong></td>
            <td align="center" width="42"><strong>Fist</strong></td>
            <td align="center" width="40"><strong>Club</strong></td>
            <td align="center" width="38"><strong>Swrd</strong></td>
            <td align="center" width="38"><strong>Axe</strong></td>
            <td align="center" width="38"><strong>Dist</strong></td>
            <td align="center" width="38"><strong>Shield</strong></td>
            <td align="center" width="38"><strong>Fish</strong></td></font>
        </tr>
        <tr bgcolor="'.$config['site']['lightborder'].'">
            <td align="center" width="38">'.$player->getLevel().'</td>
            <td align="center" width="38">'.$player->getMagLevel().'</td>
            <td align="center" width="38">'.$player->getSkill(0).'</td>
            <td align="center" width="38">'.$player->getSkill(1).'</td>
            <td align="center" width="38">'.$player->getSkill(2).'</td>
            <td align="center" width="38">'.$player->getSkill(3).'</td>
            <td align="center" width="38">'.$player->getSkill(4).'</td>
            <td align="center" width="38">'.$player->getSkill(5).'</td>
            <td align="center" width="38">'.$player->getSkill(6).'</td>
        </tr></tbody></table><div table align="center">&nbsp;<br />&nbsp;</div>';
			//skill script end
			}
			//quest status by ballack13
			$id = $player->getCustomField("id");
			$number_of_quests = 0;
			$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD align="left" COLSPAN=2 CLASS=white><B>Quests</B></TD></TD align="right"></TD></TR>';		
                        $quests = $config['site']['quests'];
                        foreach ($quests as $storage => $name) {
				if(is_int($number_of_quests / 2))
					$bgcolor = $config['site']['darkborder'];
				else
					$bgcolor = $config['site']['lightborder'];
				$number_of_quests++;
			$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD WIDTH=95%>'.$storage.'</TD>';
                        $quest = $SQL->query('SELECT * FROM player_storage WHERE player_id = '.$id.' AND `key` = '.$quests[$storage].';')->fetch();
                           if($quest == false) {
			$main_content .= '<TD><img src="images/false.png"/></TD></TR>';
                        }
			else
			{
			$main_content .= '<TD><img src="images/true.png"/></TD></TR>';
			}
			}

			$main_content .= '</TABLE></td></tr></table><br />';
			$deads = 0;
			
			            //frags list by Xampy 
             
            $frags_limit = 10; // 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().' ORDER BY `date` DESC LIMIT 0,'.$frags_limit.';'); 
            if(count($player_frags)) 
            { 
                $frags = 0; 
                $frag_add_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><br><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2 CLASS=white><B>Victims</B></TD></TR>'; 
                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\">".date("j M Y, H:i", $frag['date'])."</td> 
                    <td>".(($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 >= 1) 
                $main_content .= $frag_add_content . '</TABLE>'; 
            } 
            // end of frags list by Xampy  

			//deaths list
			$player_deaths = $SQL->query('SELECT `id`, `date`, `level` FROM `player_deaths` WHERE `player_id` = '.$player->getId().' ORDER BY `date` DESC LIMIT 0,10;');
			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\">".date("j M Y, H:i", $death['date'])."</td>
				<td>";
				$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)
				$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2 CLASS=white><B>Deaths</B></TD></TR>' . $dead_add_content . '</TABLE><br />';

			//end
			if(!$player->getHideChar()) {
				$main_content .= '<TABLE BORDER=0><TR><TD></TD></TR></TABLE><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2 CLASS=white><B>Account Information</B></TD></TR>';
				if($account->getRLName())
				{
					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%>Real name:</TD><TD>'.$account->getRLName().'</TD></TR>';
				}
				if($account->getLocation())
				{
					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']['darkborder'].'><TD WIDTH=20%>Location:</TD><TD>'.$account->getLocation().'</TD></TR>';
				}
				if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
				if($account->getLastLogin())
					$main_content .= '<TR BGCOLOR='.$config['site']['lightborder'].'><TD WIDTH=20%>Last login:</TD><TD>'.date("j F Y, g:i a", $account->getLastLogin()).'</TD></TR>';
				else
					$main_content .= '<TR BGCOLOR='.$config['site']['lightborder'].'><TD WIDTH=20%>Last login:</TD><TD>Never logged in.</TD></TR>';
				if($account->getCreated())
				{
					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%>Created:</TD><TD>'.date("j F Y, g:i a", $account->getCreated()).'</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>Account*Status:</TD><TD>';
				$main_content .= ($account->isPremium()) ? '<b><font color="green">Premium Account</font></b>' : '<b><font color="red">Free Account</font></b>';
				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 .= '</TD></TR></TABLE>';
				$main_content .= '<br><TABLE BORDER=0><TR><TD></TD></TR></TABLE><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=5 CLASS=white><B>Characters</B></TD></TR>
				<TR BGCOLOR='.$config['site']['darkborder'].'><TD><B>Name</B></TD><TD><B>World</B></TD><TD><B>Level</B></TD><TD><b>Status</b></TD><TD><B>*</B></TD></TR>';
				$account_players = $account->getPlayersList();
				$account_players->orderBy('name');
				$player_number = 0;
				foreach($account_players as $player_list)
				{
					if(!$player_list->getHideChar())
					{
						$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">Offline</font>';
						else
							$player_list_status = '<font color="green">Online</font>';
						$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD WIDTH=52%><NOBR>'.$player_number.'.*'.$player_list->getName();
						$main_content .= ($player_list->isDeleted()) ? '<font color="red"> [DELETED]</font>' : '';
						$main_content .= '</NOBR></TD><TD WIDTH=15%>'.$config['site']['worlds'][$player_list->getWorld()].'</TD><TD WIDTH=25%>'.$player_list->getLevel().' '.$vocation_name[$player_list->getWorld()][$player_list->getPromotion()][$player_list->getVocation()].'</TD><TD WIDTH="8%"><b>'.$player_list_status.'</b></TD><TD><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></TD><TD><IMG SRC="'.$layout_name.'/images/general/blank.gif" WIDTH=10 HEIGHT=1 BORDER=0></TD></TR></TABLE>';
			}
			$main_content .= '<BR><BR><FORM ACTION="?subtopic=characters" METHOD=post><TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>Search Character</B></TD></TR><TR><TD BGCOLOR="'.$config['site']['darkborder'].'"><TABLE BORDER=0 CELLPADDING=1><TR><TD>Name:</TD><TD><INPUT 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></TABLE></TD></TR></TABLE></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 ACTION="?subtopic=characters" METHOD=post><TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>Search Character</B></TD></TR><TR><TD BGCOLOR="'.$config['site']['darkborder'].'"><TABLE BORDER=0 CELLPADDING=1><TR><TD>Name:</TD><TD><INPUT 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></TABLE></TD></TR></TABLE></FORM>';
	}
}
?>
 
:( my pics. i will stop sharing so ppl stop getting my files without my authorization
119yypt.jpg
 
a request from who?
Did Diviinoo allowed you to publish them here?
 
"oki"
keep releasing then
 
2ltpl5h.jpg

PHP:
<?PHP
$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 ACTION="?subtopic=characters" METHOD=post><TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD CLASS="vdarkBorder" CLASS=white><B>Search Character</B></TD></TR><TR><TD CLASS="darkBorder"><TABLE BORDER=0 CELLPADDING=1><TR><TD>Name:</TD><TD><INPUT 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></TABLE></TD></TR></TABLE></FORM>';
}
else
{
	if(check_name($name)) {
		$player = $ots->createObject('Player');
		$player->find($name);
		if($player->isLoaded()) {
			$account = $player->getAccount();
?>

<?PHP

$main_content .= '<h3>'; $main_content .= '<font color="';$main_content .= ($player->isOnline()) ? 'green' : 'red';$main_content .= '"> 
	<b>'.$player->getName().'</b></font>'; $main_content .= ' <b>'.$vocation_name[$player->getWorld()][$player->getPromotion()][$player->getVocation()].'</b></h3>
	<br>
<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR CLASS="vdarkBorder"><TD align="left" COLSPAN=2 CLASS=white><B>Character</B></TD><TD align="left" COLSPAN=2 CLASS=white><B>Information</B></TD></TR>
<tbody>
<tr><td style="text-align: center;" CLASS="lightBorder"><img src="http://img709.imageshack.us/img709/7005/sexd.png"></td><td CLASS="lightBorder">
<b>'; $main_content .= ($player->getSex() == 0) ? 'Female' : 'Male'; $main_content .= ' </b><br><font size="1" color="#484848">Sex</font><br></td>
<td style="text-align: center;" CLASS="lightBorder"><img src="http://127.0.0.1/trunk.r123/public/images/charview/homejf.png"></td>
<td width="33%" CLASS="lightBorder"><b>'.$towns_list[$player->getWorld()][$player->getTownId()].'</b><br>
<font size="1" color="#484848">Residence</font></td>
            </tr><tr>
            <td style="text-align: center;" width="10%" CLASS="darkBorder"><img  src="http://img214.imageshack.us/img214/1918/voc.png"></td>
          <td CLASS="darkBorder">';
		  	$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 = darkBorder; } else { $bgcolor = lightBorder; } $number_of_rows++;
				$main_content .= ''.$rank_of_player->getName().' of the <a href="?subtopic=guilds&action=show&guild='.$guild_id.'">'.$guild_name.'</a>';
			}
			}
$main_content .='<br>
            <font size="1" color="#484848">Guild</font></td>
            <td style="text-align: center;" CLASS="darkBorder"><img src="http://images2.wikia.nocookie.net/tibia/en/images/c/c8/Cuckoo_Clock.gif"></td>
            <td CLASS="darkBorder"><b>';
			if(is_int($number_of_rows / 2)) { $bgcolor = darkBorder; } else { $bgcolor = lightBorder; } $number_of_rows++;
			$lastlogin = $player->getLastLogin();
			if(empty($lastlogin))
				$main_content .= 'Never logged in.';
			else
				$main_content .= ''.date("j F Y, g:i a", $lastlogin).'';
				$main_content .= '</b><br>
            <font size="1" color="#484848">Last login</font></td>
            </tr>
			
        <tr><td style="text-align: center;" width="10%" CLASS="lightBorder"><img  src="http://images2.wikia.nocookie.net/tibia/en/images/5/56/Winning_Lottery_Ticket.gif"></td>
        <td CLASS="lightBorder"><b>'; $main_content .= ($account->isPremium()) ? '<b><font color="green">Premium Account</font></b>' : '<b><font color="red">Free Account</font></b>'; $main_content .='</b><br></td>
           <td style="text-align: center;" CLASS="lightBorder"><img src="http://images3.wikia.nocookie.net/tibia/en/images/5/5a/Research_Notes.gif"></td>
				<td CLASS="lightBorder"><b>'.date("j F Y, g:i a", $player->getCreated()).'</b><br>
             <font size="1" color="#484848">Created</font></td>
        </tr>
		
        <tr><td style="text-align: center;" width="10%" CLASS="darkBorder"><img src="http://img9.imageshack.us/img9/166/worldvo.png"></td>
          <td CLASS="darkBorder">';
		  $group = $player->getGroup();
		    if ($group == 1){$group_name = 'Player';}
            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 = 1)
            {
              $main_content .= ' '.$group_name.' ';
            } 
			$main_content .= '<br><font size="1" color="#484848">Game Position</font></td>
            <td style="text-align: center;" width="10%" CLASS="darkBorder"><img src="http://img16.imageshack.us/img16/6509/rangor.png"></td>
            <td CLASS="darkBorder"><b>'.$player->getLevel().'</b><br>
            <font size="1" color="#484848">Level</font><br>
	</td>
	<tr><td style="text-align: center;" CLASS="lightBorder">';            
	$id = $player->getCustomField("id");
                        $listaddon = array('128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','158','159','251','252','268','269','270','273','278','279','288','289','302','324','325');
                        $lookadd = array('0','1','2','3');
         foreach ($listaddon as $pid => $name)
                        foreach ($lookadd as $addo => $name) {
                        $addon1 = $SQL->query('SELECT * FROM players WHERE id = '.$id.' AND looktype = '.$listaddon[$pid].' AND lookaddons = '.$lookadd[$addo].';')->fetch();

                           if($addon1[looktype] == true ) {


                        $finaddon = $addon1[looktype] + $addon1[lookaddons] * 300;
						}
						}
            $main_content .= '<center><img src="images/addons/'.$finaddon.'.gif"/></center>';  $main_content .= '</td><td CLASS="lightBorder">
<b>
Outfit
</b><br><font size="1" color="#484848"></font><br></td>
<td style="text-align: center;" CLASS="lightBorder"><img src="http://img12.imageshack.us/img12/6592/1988f.gif"></td>
<td width="33%" CLASS="lightBorder"><b>'.$player->getCap().'</b><br>
<font size="1" color="#484848">Cap</font></td>
            </tr><tr>
            <td style="text-align: center;" width="10%" CLASS="darkBorder"><img  src="http://img88.imageshack.us/img88/7540/1685e.gif"></td>
          <td CLASS="darkBorder"><b>'.$player->getHealth().'</b>';

$main_content .='<br>
            <font size="1" color="#484848">Health</font></td>
            <td style="text-align: center;" CLASS="darkBorder"><img src="http://img198.imageshack.us/img198/9263/1686.gif"></td>
            <td CLASS="darkBorder"><b>';

				$main_content .= '<b>'.$player->getMana().'</b>';
				$main_content .= '</b><br>
            <font size="1" color="#484848">Mana</font></td>
            </tr>
    </tr>
    </tbody>
</table>
';

$main_content .= '<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100%><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR CLASS="vdarkBorder" ></TR>';
			
			//modified status scripts by ballack13
			$main_content .= '<table width=100%><tr>';
             //equipment shower by ballack13
			$id = $player->getCustomField("id");
			$number_of_items = 1;
			$main_content .= '<td align=center><table with=100% style="border: solid 1px #888888;" CELLSPACING="1"><TR>';		
                        $list = array('2','1','3','6','4','5','9','7','10','8');
                        foreach ($list as $pid => $name) {
                        $top = $SQL->query('SELECT * FROM player_items WHERE player_id = '.$id.' AND pid = '.$list[$pid].';')->fetch();
                           if($top[itemtype] == false) {
                           if($list[$pid] == '8') {
			$main_content .= '<td style="background-color: '.$config['site']['darkborder'].'; text-align: center;">Soul:<br/>'.$player->getSoul().'</td>';
			}
				if(is_int($number_of_items / 3)){
			$main_content .= '<TD style="background-color: '.$config['site']['darkborder'].'; text-align: center;"><img src="images/items/'.$list[$pid].'.gif"/></TD></tr><tr>';
				} else {
			$main_content .= '<TD style="background-color: '.$config['site']['darkborder'].'; text-align: center;"><img src="images/items/'.$list[$pid].'.gif"/></TD>';
			}
				$number_of_items++;
			}
			else
			{
                           if($list[$pid] == '8') {
			$main_content .= '<td style="background-color: '.$config['site']['darkborder'].'; text-align: center;">Soul:<br/>'.$player->getSoul().'</td>';
			}
				if(is_int($number_of_items / 3))
			$main_content .= '<TD style="background-color: '.$config['site']['darkborder'].'; text-align: center;"><img src="images/items/'.$top[itemtype].'.gif" width="45"/></TD></tr><tr>';
				else
			$main_content .= '<TD style="background-color: '.$config['site']['darkborder'].'; text-align: center;"><img src="images/items/'.$top[itemtype].'.gif" width="45"/></TD>';
				$number_of_items++;
			}
                           if($list[$pid] == '8') {
			$main_content .= '<td style="background-color: '.$config['site']['darkborder'].'; text-align: center;">Cap:<br/>'.$player->getCap().'</td>';
			}
			}
			$main_content .= '</tr></TABLE></td>';

            //Hp/Mana/Exp Status by ballack13
			$hp = ($player->getHealth() / $player->getHealthMax() * 100);
			$main_content .= '<td align=center ><table width=100%><tr><td align=center><table CELLSPACING="1" CELLPADDING="4"><tr><td BGCOLOR="#D4C0A1" align="left" width="20%"><b>Player Health:</b></td>
					<td BGCOLOR="#D4C0A1" align="left">'.$player->getHealth().'/'.$player->getHealthMax().'<div style="width: 100%; height: 3px; border: 1px solid #000;"><div style="background: red; width: '.$hp.'%; height: 3px;"></td></tr>';
			if ($player->getManaMax() > 0) {
				$mana = ($player->getMana() / $player->getManaMax() * 100);
				$main_content .= '<tr><td BGCOLOR="#F1E0C6" align="left"><b>Player Mana:</b></td><td BGCOLOR="#F1E0C6" align="left">'.$player->getMana().'/'.$player->getManaMax().'<div style="width: 100%; height: 3px; border: 1px solid #000;"><div style="background: blue; width: '.$mana.'%; height: 3px;"></td>'; 
			} else {
			$main_content .= '<tr><td BGCOLOR="#F1E0C6" align="left"><b>Player Mana:</b></td><td BGCOLOR="#F1E0C6" align="left">0/0<div style="width: 100%; height: 3px; border: 1px solid #000;"><div style="background: blue; width: 100%; height: 3px;"></td>'; }
			$main_content .= '</tr></table><tr>';
			$next = ($player->getLevel() + 1);
			$exp = ((50 / 3) * ($player->getLevel() * $player->getLevel() * $player->getLevel()) - (100 * ($player->getLevel() * $player->getLevel())) + ((850/3) * $player->getLevel()) - 200);
			$expnext = ((50 / 3) * ($next * $next * $next) - (100 * ($next * $next)) + ((850/3) * $next) - 200 - $player->getExperience());
			$expresult = ($expnext / (($expnext  + $player->getExperience()) - $exp) * 100);
			$main_content .= '<tr><table CELLSPACING="1" CELLPADDING="4"><tr><td BGCOLOR="'.$config['site']['lightborder'].'" align="left" width="20%"><b>Player Level:</b></td><td BGCOLOR="'.$config['site']['lightborder'].'" align="left">'.$player->getLevel().'</td></tr>
					<tr><td BGCOLOR="'.$config['site']['darkborder'].'" align="left"><b>Player Experience:</b></td><td BGCOLOR="'.$config['site']['darkborder'].'" align="left">'.$player->getExperience().' EXP.</td></tr>
					<tr><td BGCOLOR="'.$config['site']['lightborder'].'" align="left"><b>To Next Level:</b></td><td BGCOLOR="'.$config['site']['lightborder'].'" align="left">You need <b>'.$exp.' EXP</b> to Level <b>'.$next.'</b>.<div title="99.320604545 %" style="width: 100%; height: 3px; border: 1px solid #000;"><div style="background: red; width: '.$expresult.'%; height: 3px;"></td></tr></table></td></tr></table></tr></TABLE></td>';
			if($config['site']['show_skills_info']) {
			//Skills Pics v2. Table borders optimized by Absolute Mango
			$main_content .= '<br/><table cellspacing="0" cellpadding="0" border="0" width="200" align="center"><caption><strong>Skills</strong></caption><tbody><tr>
            <td align="center"><a href="?subtopic=highscores&list=experience"><img src="images/skills/level.png" style="border: none;"/></a></td>
            <td align="center"><a href="?subtopic=highscores&list=magic"><img src="images/skills/ml.png" style="border: none;"/></a></td>
            <td align="center"><a href="?subtopic=highscores&list=fist"><img src="images/skills/fist.png" style="border: none;"/></a></td>
            <td align="center"><a href="?subtopic=highscores&list=club"><img src="images/skills/club.png" style="border: none;"/></a></td>
            <td align="center"><a href="?subtopic=highscores&list=sword"><img src="images/skills/sword.png" style="border: none;"/></a></td>
            <td align="center"><a href="?subtopic=highscores&list=axe"><img src="images/skills/axe.png" style="border: none;"/></a></td>
            <td align="center"><a href="?subtopic=highscores&list=distance"><img src="images/skills/dist.png" style="border: none;"/></a></td>
            <td align="center"><a href="?subtopic=highscores&list=shield"><img src="images/skills/def.png" style="border: none;"/></a></td>
            <td align="center"><a href="?subtopic=highscores&list=fishing"><img src="images/skills/fish.png" style="border: none;"/></a></td>
			</tr></tbody></table>
			<table cellspacing="0" cellpadding="0" border="1" width="360" align="center"><tbody><tr><tr bgcolor="'.$config['site']['darkborder'].'">
            <td align="center" width="38"><strong>Level</strong></td>
            <td align="center" width="38"><strong>ML</strong></td>
            <td align="center" width="42"><strong>Fist</strong></td>
            <td align="center" width="40"><strong>Club</strong></td>
            <td align="center" width="38"><strong>Swrd</strong></td>
            <td align="center" width="38"><strong>Axe</strong></td>
            <td align="center" width="38"><strong>Dist</strong></td>
            <td align="center" width="38"><strong>Shield</strong></td>
            <td align="center" width="38"><strong>Fish</strong></td></font>
        </tr>
        <tr bgcolor="'.$config['site']['lightborder'].'">
            <td align="center" width="38">'.$player->getLevel().'</td>
            <td align="center" width="38">'.$player->getMagLevel().'</td>
            <td align="center" width="38">'.$player->getSkill(0).'</td>
            <td align="center" width="38">'.$player->getSkill(1).'</td>
            <td align="center" width="38">'.$player->getSkill(2).'</td>
            <td align="center" width="38">'.$player->getSkill(3).'</td>
            <td align="center" width="38">'.$player->getSkill(4).'</td>
            <td align="center" width="38">'.$player->getSkill(5).'</td>
            <td align="center" width="38">'.$player->getSkill(6).'</td>
        </tr></tbody></table><div table align="center">&nbsp;<br />&nbsp;</div>';
			//skill script end
			}
			//quest status by ballack13
			$id = $player->getCustomField("id");
			$number_of_quests = 0;
			$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD align="left" COLSPAN=2 CLASS=white><B>Quests</B></TD></TD align="right"></TD></TR>';		
                        $quests = $config['site']['quests'];
                        foreach ($quests as $storage => $name) {
				if(is_int($number_of_quests / 2))
					$bgcolor = $config['site']['darkborder'];
				else
					$bgcolor = $config['site']['lightborder'];
				$number_of_quests++;
			$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD WIDTH=95%>'.$storage.'</TD>';
                        $quest = $SQL->query('SELECT * FROM player_storage WHERE player_id = '.$id.' AND `key` = '.$quests[$storage].';')->fetch();
                           if($quest == false) {
			$main_content .= '<TD><img src="images/false.png"/></TD></TR>';
                        }
			else
			{
			$main_content .= '<TD><img src="images/true.png"/></TD></TR>';
			}
			}

			$main_content .= '</TABLE></td></tr></table><br />';
			$deads = 0;
			
			            //frags list by Xampy 
             
            $frags_limit = 10; // 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().' ORDER BY `date` DESC LIMIT 0,'.$frags_limit.';'); 
            if(count($player_frags)) 
            { 
                $frags = 0; 
                $frag_add_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><br><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2 CLASS=white><B>Victims</B></TD></TR>'; 
                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\">".date("j M Y, H:i", $frag['date'])."</td> 
                    <td>".(($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 >= 1) 
                $main_content .= $frag_add_content . '</TABLE>'; 
            } 
            // end of frags list by Xampy  

			//deaths list
			$player_deaths = $SQL->query('SELECT `id`, `date`, `level` FROM `player_deaths` WHERE `player_id` = '.$player->getId().' ORDER BY `date` DESC LIMIT 0,10;');
			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\">".date("j M Y, H:i", $death['date'])."</td>
				<td>";
				$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)
				$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2 CLASS=white><B>Deaths</B></TD></TR>' . $dead_add_content . '</TABLE><br />';

			//end
			if(!$player->getHideChar()) {
				$main_content .= '<TABLE BORDER=0><TR><TD></TD></TR></TABLE><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2 CLASS=white><B>Account Information</B></TD></TR>';
				if($account->getRLName())
				{
					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%>Real name:</TD><TD>'.$account->getRLName().'</TD></TR>';
				}
				if($account->getLocation())
				{
					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']['darkborder'].'><TD WIDTH=20%>Location:</TD><TD>'.$account->getLocation().'</TD></TR>';
				}
				if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
				if($account->getLastLogin())
					$main_content .= '<TR BGCOLOR='.$config['site']['lightborder'].'><TD WIDTH=20%>Last login:</TD><TD>'.date("j F Y, g:i a", $account->getLastLogin()).'</TD></TR>';
				else
					$main_content .= '<TR BGCOLOR='.$config['site']['lightborder'].'><TD WIDTH=20%>Last login:</TD><TD>Never logged in.</TD></TR>';
				if($account->getCreated())
				{
					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%>Created:</TD><TD>'.date("j F Y, g:i a", $account->getCreated()).'</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>Account*Status:</TD><TD>';
				$main_content .= ($account->isPremium()) ? '<b><font color="green">Premium Account</font></b>' : '<b><font color="red">Free Account</font></b>';
				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 .= '</TD></TR></TABLE>';
				$main_content .= '<br><TABLE BORDER=0><TR><TD></TD></TR></TABLE><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=5 CLASS=white><B>Characters</B></TD></TR>
				<TR BGCOLOR='.$config['site']['darkborder'].'><TD><B>Name</B></TD><TD><B>World</B></TD><TD><B>Level</B></TD><TD><b>Status</b></TD><TD><B>*</B></TD></TR>';
				$account_players = $account->getPlayersList();
				$account_players->orderBy('name');
				$player_number = 0;
				foreach($account_players as $player_list)
				{
					if(!$player_list->getHideChar())
					{
						$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">Offline</font>';
						else
							$player_list_status = '<font color="green">Online</font>';
						$main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD WIDTH=52%><NOBR>'.$player_number.'.*'.$player_list->getName();
						$main_content .= ($player_list->isDeleted()) ? '<font color="red"> [DELETED]</font>' : '';
						$main_content .= '</NOBR></TD><TD WIDTH=15%>'.$config['site']['worlds'][$player_list->getWorld()].'</TD><TD WIDTH=25%>'.$player_list->getLevel().' '.$vocation_name[$player_list->getWorld()][$player_list->getPromotion()][$player_list->getVocation()].'</TD><TD WIDTH="8%"><b>'.$player_list_status.'</b></TD><TD><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></TD><TD><IMG SRC="'.$layout_name.'/images/general/blank.gif" WIDTH=10 HEIGHT=1 BORDER=0></TD></TR></TABLE>';
			}
			$main_content .= '<BR><BR><FORM ACTION="?subtopic=characters" METHOD=post><TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>Search Character</B></TD></TR><TR><TD BGCOLOR="'.$config['site']['darkborder'].'"><TABLE BORDER=0 CELLPADDING=1><TR><TD>Name:</TD><TD><INPUT 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></TABLE></TD></TR></TABLE></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 ACTION="?subtopic=characters" METHOD=post><TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>Search Character</B></TD></TR><TR><TD BGCOLOR="'.$config['site']['darkborder'].'"><TABLE BORDER=0 CELLPADDING=1><TR><TD>Name:</TD><TD><INPUT 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></TABLE></TD></TR></TABLE></FORM>';
	}
}
?>

Can you add it with the new items shower show items information

And reptioun

I get error when i tryed to make it !!
 
I have error :
Table 'forgottenserver.killers' doesn't exist'

how to fix it
plz !
 
Warning: Invalid argument supplied for foreach() in C:\nowy\xampp\htdocs\characters.php on line 217

HELP?
 
Back
Top