• 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] Equipment Shower

Kavvson

Kavvson

Gdy boli cie glowa wez
Joined
Jun 25, 2008
Messages
1,177
Reaction score
72
Location
Poland
Originally created by OtLand - View Profile: stefanhaan

At first i would like to redirect you to http://otland.net/f118/eqshower-script-non-aac-83736/ . Since i remade the script.

Now here comes the design part :) I guess it was a really awaiting script, guess what.. i also waited since someone publish it:) Now i want to show you it.

Installation/Modification

Try to find in your characters.php

PHP: 
//modified status scripts by ballack13
main_content .= '<table width=100%><tr>';
//equipment shower by ballack13
And delete from

PHP: 
//equipment shower by ballack13
Till ( but not this )

PHP: 
$main_content .= '</tr></TABLE></td>';
Now we have some space to create the new table with the tooltip.

And in the empty place paste

PHP: 
/// Begging of the EQ SHOWER modified by Kavvson //
//? Needed ?//
include 'eqshower.php';
include 'eq-class.php';
///? Style and JS part ?///
ECHO $getcss;
ECHO $getjs;
///? End Of Style and JS part ?///
/// Query + functions ///
$query=mysql_query('SELECT * FROM `player_items` WHERE player_id = '.$id.' AND `pid`<=10');
if($query){
    while ($result=mysql_fetch_array($query))
    {
        $item[$result['pid']]['img']="<img src='images/items/".$result['itemtype'].".gif' />";
        $item[$result['pid']]['id']=$result['itemtype'];
        $class[$result['pid']]="a0-".$result['pid'];
    }
    $EQShower=new EQShower;
    
    for($i=1;$i<=10;$i++)
    {
        $num_attr=0;
        unset($val);$val=array();
        
        $query=mysql_query("SELECT * FROM `s_items` INNER JOIN `s_attributes` ON s_items.id=s_attributes.item_id WHERE s_items.itemid=".$item[$i]['id']);
        if($query)$result=mysql_fetch_assoc($query);
        
        $val[0]=ucfirst($result['name']);
        $val[1]=$result['descr'];
        $val[2]=$result['armor'];
        $val[3]=$result['weight'];
        $val[4]=$result['containerSize'];
        $val[5]=$result['attack'];
        $val[6]=$result['speed'];
        $val[7]=$result['defense'];
        $val[8]=$result['elementFire'];
        $val[9]=$result['elementIce'];
        $val[10]=$result['elementEarth'];
        $val[11]=$result['elementEnergy'];
        $val[12]=$result['range'];
        $val[13]=$result['extraDef'];
        $val[14]=$result['skillShield'];
        $val[15]=$result['magicLevelPoints'];
        $val[16]=$result['absorbPercentall'];
        $val[17]=$result['charges'];
        $val[18]=$result['skillDist'];
        $val[19]=$result['absorbPercentFire'];
        $val[20]=$result['absorbPercentEarth'];
        $val[21]=$result['absorbPercentIce'];
        $val[22]=$result['absorbPercentEnergy'];
        $val[23]=$result['absorbPercentDeath'];
        $val[24]=$result['absorbPercentHoly'];
        $val[25]=$result['absorbPercentPhysical'];
        $val[26]=$result['skillAxe'];
        $val[27]=$result['skillClub'];
        $val[28]=$result['skillSword'];
        $val[29]=$result['duration'];
        $val[30]=$result['skillFist'];
        $val[31]=$result['absorbPercentManaDrain'];
        $val[32]=$result['absorbPercentLifeDrain'];
        $val[33]=$result['preventDrop'];
        $val[34]=$result['hitChance'];
        $val[35]=$result['shootType'];
        
        foreach($val as $attribute)
        {
            if(!empty($attribute))$num_attr++;
        }
        $tooltip[$i]=$EQShower->item_info($val,$num_attr);
        
        if(empty($item[$i])){
        $class[$i]="a".$i;
        $tooltip[$i]="<font class=\'attr\'>Nothing is equipped.</font>";
        }
    }
    
}
/// End of Query And Functions ///
$id = $player->getCustomField("id");
$main_content .= '<td align=center><table with=100% style="border: solid 1px #888888;" class="darkBorder" CELLSPACING="1"><TR class="darkBorder"> ';        

            $main_content .= '<div id="bg">
    <div class="col1">
        <div class="'.$class['2'].'" onmouseover="tooltip.show(\''.$tooltip[2].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['2']['img'].'   
        </div>
        <div class="'.$class['6'].'" onmouseover="tooltip.show(\''.$tooltip[6].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['6']['img'].'   
        </div>
        <div class="'.$class['9'].'" onmouseover="tooltip.show(\''.$tooltip[9].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['9']['img'].'   
        </div>
    </div>
    <div class="col2">
        <div class="'.$class['1'].'" onmouseover="tooltip.show(\''.$tooltip[1].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['1']['img'].'   
        </div>
        <div class="'.$class['4'].'" onmouseover="tooltip.show(\''.$tooltip[4].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['4']['img'].'   
        </div>
        <div class="'.$class['7'].'" onmouseover="tooltip.show(\''.$tooltip[7].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['7']['img'].'   
        </div>
        <div class="'.$class['8'].'" onmouseover="tooltip.show(\''.$tooltip[8].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['8']['img'].'   
        </div>
    </div>
    <div class="col3">
        <div class="'.$class['3'].'" onmouseover="tooltip.show(\''.$tooltip[3].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['3']['img'].'   
        </div>
        <div class="'.$class['5'].'" onmouseover="tooltip.show(\''.$tooltip[5].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['5']['img'].'   
        </div>
        <div class="'.$class['10'].'" onmouseover="tooltip.show(\''.$tooltip[10].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['10']['img'].'   
        </div>
    </div>
</div>';

/// End of the EQ SHOWER modified by Kavvson //
Then download the .Rar with needed files.

Installing EQShower

Why? Because you need to add some database schemas.

The installation is simply:

type http://localhost/equip-installer.php

It will add the databases. Note that you need to have the items.xml file. Just drag all the files in the RAR to your main directory of account maker.

After the installation you can delete the following files (for safety since if you will refresh the equip-installer.php (site) if will fill the database ):

  • s_items.sql
  • s_attributes.sql
  • equip-installer.php

Styling:

You can change the directory to the files in your eqshower.php

PHP: 
$getcss= '<link rel="stylesheet" type="text/css" href="js/tooltip.css" />';
$getjs ='<script src=\'js/tooltip.js\'></script>';
Finishing:

To have it all working you should have:
  • The images with all items in http://otland.net/images/items (main folder not layout)
  • The css and js file in /js (main folder not layout - or you can change it look the steps up)

Got questions or found a bug? Ask here :) dont forget to rep.

Here is a fixed version
s3mqt0.jpg



I added also the Cap Status and the Soul Status.

Like before you should follow the steps to install it ( if you have the Schema you shouldnt install it )

I wrote also a fixed Characters.php and you are able to drag it to your folder and all will work.

To add the part manually follow the tutorial in the first post and paste this

PHP: 
/// Beging of the EQ SHOWER modified by Kavvson //
//? Needed ?//
include 'eqshower.php';
include 'eq-class.php';
///? Style and JS part ?///
ECHO $getcss;
ECHO $getjs;
///? End Of Style and JS part ?///
/// Query + functions ///
$query=mysql_query('SELECT * FROM `player_items` WHERE player_id = '.$id.' AND `pid`<=10');
if($query){
    while ($result=mysql_fetch_array($query))
    {
        $item[$result['pid']]['img']="<img src='images/items/".$result['itemtype'].".gif' />";
        $item[$result['pid']]['id']=$result['itemtype'];
        $class[$result['pid']]="a0-".$result['pid'];
    }
    $EQShower=new EQShower;
    
    for($i=1;$i<=10;$i++)
    {
        $num_attr=0;
        unset($val);$val=array();
        
        $query=mysql_query("SELECT * FROM `s_items` INNER JOIN `s_attributes` ON s_items.id=s_attributes.item_id WHERE s_items.itemid=".$item[$i]['id']);
        if($query)$result=mysql_fetch_assoc($query);
        
        $val[0]=ucfirst($result['name']);
        $val[1]=$result['descr'];
        $val[2]=$result['armor'];
        $val[3]=$result['weight'];
        $val[4]=$result['containerSize'];
        $val[5]=$result['attack'];
        $val[6]=$result['speed'];
        $val[7]=$result['defense'];
        $val[8]=$result['elementFire'];
        $val[9]=$result['elementIce'];
        $val[10]=$result['elementEarth'];
        $val[11]=$result['elementEnergy'];
        $val[12]=$result['range'];
        $val[13]=$result['extraDef'];
        $val[14]=$result['skillShield'];
        $val[15]=$result['magicLevelPoints'];
        $val[16]=$result['absorbPercentall'];
        $val[17]=$result['charges'];
        $val[18]=$result['skillDist'];
        $val[19]=$result['absorbPercentFire'];
        $val[20]=$result['absorbPercentEarth'];
        $val[21]=$result['absorbPercentIce'];
        $val[22]=$result['absorbPercentEnergy'];
        $val[23]=$result['absorbPercentDeath'];
        $val[24]=$result['absorbPercentHoly'];
        $val[25]=$result['absorbPercentPhysical'];
        $val[26]=$result['skillAxe'];
        $val[27]=$result['skillClub'];
        $val[28]=$result['skillSword'];
        $val[29]=$result['duration'];
        $val[30]=$result['skillFist'];
        $val[31]=$result['absorbPercentManaDrain'];
        $val[32]=$result['absorbPercentLifeDrain'];
        $val[33]=$result['preventDrop'];
        $val[34]=$result['hitChance'];
        $val[35]=$result['shootType'];
        
        foreach($val as $attribute)
        {
            if(!empty($attribute))$num_attr++;
        }
        $tooltip[$i]=$EQShower->item_info($val,$num_attr);
        
        if(empty($item[$i])){
        $class[$i]="a".$i;
        $tooltip[$i]="<font class=\'attr\'>Nothing is equipped.</font>";
        }
    }
    
}
/// End of Query And Functions ///
$id = $player->getCustomField("id");
$main_content .= '<td align=center><table with=100%><TR class="darkBorder"> ';        

            $main_content .= '<div id="bg">
    <div class="col1">
        <div class="'.$class['2'].'" onmouseover="tooltip.show(\''.$tooltip[2].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['2']['img'].'   
        </div>
        <div class="'.$class['6'].'" onmouseover="tooltip.show(\''.$tooltip[6].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['6']['img'].'   
        </div>
        <div class="'.$class['9'].'" onmouseover="tooltip.show(\''.$tooltip[9].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['9']['img'].'   
        </div>
                <div class="soul"><div class="txts" onmouseover="tooltip.show(\'<center>Soul Points - '.$player->getSoul().'</center>\', 225)" onmouseout="tooltip.hide()" ><p style="padding-bottom:6px">'.$player->getSoul().'</p></div></div>   
    </div>
    <div class="col2">
        <div class="'.$class['1'].'" onmouseover="tooltip.show(\''.$tooltip[1].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['1']['img'].'   
        </div>
        <div class="'.$class['4'].'" onmouseover="tooltip.show(\''.$tooltip[4].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['4']['img'].'   
        </div>
        <div class="'.$class['7'].'" onmouseover="tooltip.show(\''.$tooltip[7].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['7']['img'].'   
        </div>
        <div class="'.$class['8'].'" onmouseover="tooltip.show(\''.$tooltip[8].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['8']['img'].'   
        </div>
    </div>
    <div class="col3">
        <div class="'.$class['3'].'" onmouseover="tooltip.show(\''.$tooltip[3].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['3']['img'].'   
        </div>
        <div class="'.$class['5'].'" onmouseover="tooltip.show(\''.$tooltip[5].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['5']['img'].'   
        </div>
        <div class="'.$class['10'].'" onmouseover="tooltip.show(\''.$tooltip[10].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['10']['img'].'   
        </div>
        <div class="cap"><div class="txtc" onmouseover="tooltip.show(\'<center>Capability - '.$player->getCap().'</center>\', 225)" onmouseout="tooltip.hide()" ><p style="padding-bottom:6px">'.$player->getCap().'</p></div></div> 
    </div>
</div>';

/// End of the EQ SHOWER modified by Kavvson //
But dont forget to drag all the files which are in the rar
 

Attachments

  • EqShower.rar
    29 KB · Views: 410 · VirusTotal
  • EQShower With Characters.rar
    91.9 KB · Views: 449 · VirusTotal
  • EQShower-without Characters.rar
    86.1 KB · Views: 211 · VirusTotal
Last edited by a moderator:
For me not work? Error with query and more.
But mine one work
PHP: 
//-- start of status items..
           $main_content .= '<table width=100%><tr><td align=center WIDTH=20>';
include 'eqshower.php';
        $id = $player->getCustomField("id");
	$items = $SQL->query("SELECT `itemtype`, `pid` FROM `player_items` WHERE `player_id`= ".$id." AND `pid` <= 10;")->fetchAll();

	foreach($items as $result)
	{
		$item[$result['pid']]['img'] = "<img src='images/items/{$result['itemtype']}.gif' alt='{$result['itemtype']}' />";
		$item[$result['pid']]['id'] = $result['itemtype'];
		$class[$result['pid']] = "a0-{$result['pid']}";
	}
    $EQShower=new EQShower;
    
    for($i=1;$i<=10;$i++)
    {
        $num_attr=0;
        unset($val);$val=array();
        mysql_connect("localhost", "user", "password")or die("cannot connect");        
        $query=mysql_query("SELECT * FROM `s_items` INNER JOIN `s_attributes` ON s_items.id=s_attributes.item_id WHERE s_items.itemid=".$item[$i]['id']);
        if($query)$result=mysql_fetch_assoc($query);
        
        $val[0]=ucfirst($result['name']);
        $val[1]=$result['descr'];
        $val[2]=$result['armor'];
        $val[3]=$result['weight'];
        $val[4]=$result['containerSize'];
        $val[5]=$result['attack'];
        $val[6]=$result['speed'];
        $val[13]=$result['extraDef'];
        $val[7]=$result['defense'];
        $val[8]=$result['elementFire'];
        $val[9]=$result['elementIce'];
        $val[10]=$result['elementEarth'];
        $val[11]=$result['elementEnergy'];
        $val[12]=$result['range'];
        $val[14]=$result['skillShield'];
        $val[15]=$result['magicLevelPoints'];
        $val[16]=$result['absorbPercentall'];
        $val[17]=$result['charges'];
        $val[18]=$result['skillDist'];
        $val[19]=$result['absorbPercentFire'];
        $val[20]=$result['absorbPercentEarth'];
        $val[21]=$result['absorbPercentIce'];
        $val[22]=$result['absorbPercentEnergy'];
        $val[23]=$result['absorbPercentDeath'];
        $val[24]=$result['absorbPercentHoly'];
        $val[25]=$result['absorbPercentPhysical'];
        $val[26]=$result['skillAxe'];
        $val[27]=$result['skillClub'];
        $val[28]=$result['skillSword'];
        $val[29]=$result['duration'];
        $val[30]=$result['skillFist'];
        $val[31]=$result['absorbPercentManaDrain'];
        $val[32]=$result['absorbPercentLifeDrain'];
        $val[33]=$result['preventDrop'];
        $val[34]=$result['hitChance'];
        $val[35]=$result['shootType'];
        
        foreach($val as $attribute)
        {
            if(!empty($attribute))$num_attr++;
        }
        
        $tooltip[$i]=$EQShower->item_info($val,$num_attr);
        
        if(empty($item[$i])){
        $class[$i]="a".$i;
        $tooltip[$i]="<font class=\'attr\'>Empty item slot.</font>";
        }
    }
$id = $player->getCustomField("id");
$main_content .= '<td align=center><table with=100% style="border: solid 1px #888888;" class="darkBorder" CELLSPACING="1"><TR class="darkBorder"> ';        

            $main_content .= '<div id="bg">
    <div class="col1">
        <div class="'.$class['2'].'" onmouseover="tooltip.show(\''.$tooltip[2].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['2']['img'].'   
        </div>
        <div class="'.$class['6'].'" onmouseover="tooltip.show(\''.$tooltip[6].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['6']['img'].'   
        </div>
        <div class="'.$class['9'].'" onmouseover="tooltip.show(\''.$tooltip[9].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['9']['img'].'   
        </div>
    </div>
    <div class="col2">
        <div class="'.$class['1'].'" onmouseover="tooltip.show(\''.$tooltip[1].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['1']['img'].'   
        </div>
        <div class="'.$class['4'].'" onmouseover="tooltip.show(\''.$tooltip[4].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['4']['img'].'   
        </div>
        <div class="'.$class['7'].'" onmouseover="tooltip.show(\''.$tooltip[7].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['7']['img'].'   
        </div>
        <div class="'.$class['8'].'" onmouseover="tooltip.show(\''.$tooltip[8].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['8']['img'].'   
        </div>
    </div>
    <div class="col3">
        <div class="'.$class['3'].'" onmouseover="tooltip.show(\''.$tooltip[3].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['3']['img'].'   
        </div>
        <div class="'.$class['5'].'" onmouseover="tooltip.show(\''.$tooltip[5].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['5']['img'].'   
        </div>
        <div class="'.$class['10'].'" onmouseover="tooltip.show(\''.$tooltip[10].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['10']['img'].'   
        </div>
    </div>
</div>';                  
$main_content .= '</TABLE></td>';
but not show all informations:
error2a.jpg

any ideas?
nvm fixed...
 
Last edited:
yes all with steps from first post..
but maybe I has spoiled something but nvm thanks for
PHP: 
            $main_content .= '<div id="bg">
    <div class="col1">
        <div class="'.$class['2'].'" onmouseover="tooltip.show(\''.$tooltip[2].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['2']['img'].'   
        </div>
        <div class="'.$class['6'].'" onmouseover="tooltip.show(\''.$tooltip[6].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['6']['img'].'   
        </div>
        <div class="'.$class['9'].'" onmouseover="tooltip.show(\''.$tooltip[9].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['9']['img'].'   
        </div>
    </div>
    <div class="col2">
        <div class="'.$class['1'].'" onmouseover="tooltip.show(\''.$tooltip[1].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['1']['img'].'   
        </div>
        <div class="'.$class['4'].'" onmouseover="tooltip.show(\''.$tooltip[4].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['4']['img'].'   
        </div>
        <div class="'.$class['7'].'" onmouseover="tooltip.show(\''.$tooltip[7].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['7']['img'].'   
        </div>
        <div class="'.$class['8'].'" onmouseover="tooltip.show(\''.$tooltip[8].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['8']['img'].'   
        </div>
    </div>
    <div class="col3">
        <div class="'.$class['3'].'" onmouseover="tooltip.show(\''.$tooltip[3].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['3']['img'].'   
        </div>
        <div class="'.$class['5'].'" onmouseover="tooltip.show(\''.$tooltip[5].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['5']['img'].'   
        </div>
        <div class="'.$class['10'].'" onmouseover="tooltip.show(\''.$tooltip[10].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['10']['img'].'   
        </div>
    </div>
</div>';
this is it what I needed rep+++
(ofc I reped also Stefan for great js and ideas!)
 
Powered by Soulreaper, SoulAAC dev.
Items.xml -> MySQL Database Parser V1.0
Be sure to use a cleaned up items.xml else ur database becomes a mess.


Warning: include(connect.php) [function.include]: failed to open stream: No such file or directory in D:\Others\xampp\htdocs\server\equip-installer.php on line 76

Warning: include() [function.include]: Failed opening 'connect.php' for inclusion (include_path='.;D:\Others\xampp\php\PEAR') in D:\Others\xampp\htdocs\server\equip-installer.php on line 76
Error: Neccesary tables not found.
Attempting to create neccesary tables

Executed 16/18query's succesfully.
Attempted to create neccesary tables.

Powered by Soulreaper, SoulAAC dev.
Parsing took 0.706575 seconds.
 
Or find line 76 and delete include('connect.php');

AF! xD i forgot to delete it
 
I think this rar will work :)

maybe a mod could put this rar? or he cant ^^ since i cant edit
 

Attachments

there is no items show up at all


My Characters.php
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 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>';
}
else
{
        if(check_name($name)) {
                $player = $ots->createObject('Player');
                $player->find($name);
                if($player->isLoaded()) {
                        $account = $player->getAccount();
                        $main_content .= '<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100%><TR><TD><IMG SRC="'.$layout_name.'/images/general/blank.gif" WIDTH=10 HEIGHT=1 BORDER=0></TD><TD><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2 CLASS=white><B>Character Information</B></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 WIDTH=20%>Name:</TD><TD><font color="';
                        $main_content .= ($player->isOnline()) ? 'green' : 'red';
                        $main_content .= '"><b>'.$player->getName().'</b></font>';
                        if($player->isDeleted())
                                $main_content .= '<font color="red"> [DELETED]</font>';
                        if($player->isNameLocked())
                                $main_content .= '<font color="red"> [NAMELOCK]</font>';
                        $main_content .= '</TD></TR>';
                        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>Proposition:</TD><TD>'.$player->getOldName().'</TD></TR>';
                                else
                                        $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>Old name:</TD><TD>'.$player->getOldName().'</TD></TR>';
                        }
                                    // BEGIN Position Showing *** Fixed by jerryb1988 from otfans.net
            $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 != 1)
            {

                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>Position:</TD><TD>'.$group_name.'</TD></TR>';
            }
            // END Position Showing
                        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($config['site']['show_marriage_info'])
                        {
                                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>Marital status:</TD><TD>';
                                $marriage = new OTS_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>';
                        }
                        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>'.$vocation_name[$player->getWorld()][$player->getPromotion()][$player->getVocation()].'</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>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>Residence:</TD><TD>'.$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>Balance:</TD><TD>'.$player->getBalance().' Gold Coins.</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>Guild Membership:</TD><TD>'.$rank_of_player->getName().' of the <a href="?subtopic=guilds&action=show&guild='.$guild_id.'">'.$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>Last login:</TD><TD>Never logged in.</TD></TR>';
                        else
                                $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>Last login:</TD><TD>'.date("j F Y, g:i a", $lastlogin).'</TD></TR>';
                                if(is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
                        if($config['site']['show_creationdate'] && $player->getCreated())
                        {
                                $main_content .= '<TR BGCOLOR="'.$bgcolor.'"><TD>Created:</TD><TD>'.date("j F Y, g:i a", $player->getCreated()).'</TD></TR>';
                        }
                        if($config['site']['show_vip_status'])
                        {
                         $id = $player->getCustomField("id");
                                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=10%>Vip Status:</TD>';
                         $vip = $SQL->query('SELECT * FROM player_storage WHERE player_id = '.$id.' AND `key` = '.$config['site']['show_vip_storage'].';')->fetch();
                           if($vip == false) {
                            $main_content .= '<TD><span class="red"><B>NOT VIP</B></TD></TR>';
                            }
                            else
                             {
                          $main_content .= '<TD><span class="green"><B>VIP</B></TD></TR>';
                          }
                        $comment = parseubb($player->getComment());
                        $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>Comment:</TD><TD>'.$comment.'</TD></TR>';
                        }
                        }

                        //Outfit shower by Pening edited by loleslav
                        //Show or hide by Zakius
                        if($config['site']['show_outfit'] and $player->getCustomField( 'show_outfit' ) == 1) {
            $id = $player->getCustomField("id");
            $main_content .= '<TD BGCOLOR="'.$config['site']['darkborder'].'">Outfit:';
                        $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 .= '<TD with=50% style="background-color: '.$config['site']['darkborder'].'"><center><img src="images/addons/'.$finaddon.'.gif"/></center></TD></TD>';
                                        }
                                }
                        }
                        $main_content .= '</td>';
                        //end   Outfit shower by Pening edited by loleslav
                        if($config['site']['show_signature']) {
                        // Signature by makr0mango.
function randomSignature( $folder ) {
    $files = scandir ( "./$folder/" );
    $signature = array();

    foreach ( $files as $file ):
        if ( substr ( strtolower ( $file ) , -4 ) == ".png" )
            $signature[] = $file;
    endforeach;

    return rand(0,count($signature)-1);
}
                        $random = randomSignature("signatures");
                        $main_content .= '<br><tr></tr><tr></tr><tr></tr><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2 CLASS=white><B>Signature</B></TD></TR>';
                        $main_content .= "<TR BGCOLOR=".$config['site']['darkborder']."><TD WIDTH=20%>Forum Link:</TD><TD><input type='text' size='75' onclick='this.select();' value='[url=\"http://" . $_SERVER['HTTP_HOST'] . "\"][IMG]http://" . $_SERVER['HTTP_HOST'] . "/signature.php?character=" .$player->getName(). "&image=" . $random . "[/IMG][/url]' /></TD></TR>";
                        $main_content .= "<TR BGCOLOR=".$config['site']['lightborder']."><TD WIDTH=20%>Direct Link:</TD><TD><input type='text' size='75' onclick='this.select();' value='http://" . $_SERVER['HTTP_HOST'] . "/signature.php?character=" .$player->getName(). "&image=" . $random . "' /></TD></TR>";
                        $main_content .= "<TR BGCOLOR=".$config['site']['darkborder']."><TD COLSPAN='2' style='text-align: center;'><img src='signature.php?character=" .$player->getName(). "&image=" . $random . "' /></TD></TR>";
                        $main_content .= '</TD></TR></TABLE>';
                        // Signature by makr0mango.
                        }
                        //modified status scripts by ballack13
                        $main_content .= '<table width=100%><tr>';
/// Begging of the EQ SHOWER modified by Kavvson //
//? Needed ?//
include 'eqshower.php';
include 'eq-class.php';
///? Style and JS part ?///
ECHO $getcss;
ECHO $getjs;
///? End Of Style and JS part ?///
/// Query + functions ///
$query=mysql_query('SELECT * FROM `player_items` WHERE player_id = '.$id.' AND `pid`<=10');
if($query){
    while ($result=mysql_fetch_array($query))
    {
        $item[$result['pid']]['img']="<img src='images/items/".$result['itemtype'].".gif' />";
        $item[$result['pid']]['id']=$result['itemtype'];
        $class[$result['pid']]="a0-".$result['pid'];
    }
    $EQShower=new EQShower;
    
    for($i=1;$i<=10;$i++)
    {
        $num_attr=0;
        unset($val);$val=array();
        
        $query=mysql_query("SELECT * FROM `s_items` INNER JOIN `s_attributes` ON s_items.id=s_attributes.item_id WHERE s_items.itemid=".$item[$i]['id']);
        if($query)$result=mysql_fetch_assoc($query);
        
        $val[0]=ucfirst($result['name']);
        $val[1]=$result['descr'];
        $val[2]=$result['armor'];
        $val[3]=$result['weight'];
        $val[4]=$result['containerSize'];
        $val[5]=$result['attack'];
        $val[6]=$result['speed'];
        $val[7]=$result['defense'];
        $val[8]=$result['elementFire'];
        $val[9]=$result['elementIce'];
        $val[10]=$result['elementEarth'];
        $val[11]=$result['elementEnergy'];
        $val[12]=$result['range'];
        $val[13]=$result['extraDef'];
        $val[14]=$result['skillShield'];
        $val[15]=$result['magicLevelPoints'];
        $val[16]=$result['absorbPercentall'];
        $val[17]=$result['charges'];
        $val[18]=$result['skillDist'];
        $val[19]=$result['absorbPercentFire'];
        $val[20]=$result['absorbPercentEarth'];
        $val[21]=$result['absorbPercentIce'];
        $val[22]=$result['absorbPercentEnergy'];
        $val[23]=$result['absorbPercentDeath'];
        $val[24]=$result['absorbPercentHoly'];
        $val[25]=$result['absorbPercentPhysical'];
        $val[26]=$result['skillAxe'];
        $val[27]=$result['skillClub'];
        $val[28]=$result['skillSword'];
        $val[29]=$result['duration'];
        $val[30]=$result['skillFist'];
        $val[31]=$result['absorbPercentManaDrain'];
        $val[32]=$result['absorbPercentLifeDrain'];
        $val[33]=$result['preventDrop'];
        $val[34]=$result['hitChance'];
        $val[35]=$result['shootType'];
        
        foreach($val as $attribute)
        {
            if(!empty($attribute))$num_attr++;
        }
        $tooltip[$i]=$EQShower->item_info($val,$num_attr);
        
        if(empty($item[$i])){
        $class[$i]="a".$i;
        $tooltip[$i]="<font class=\'attr\'>Nothing is equipped.</font>";
        }
    }
    
}
/// End of Query And Functions ///
$id = $player->getCustomField("id");
$main_content .= '<td align=center><table with=100% style="border: solid 1px #888888;" class="darkBorder" CELLSPACING="1"><TR class="darkBorder"> ';        

            $main_content .= '<div id="bg">
    <div class="col1">
        <div class="'.$class['2'].'" onmouseover="tooltip.show(\''.$tooltip[2].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['2']['img'].'   
        </div>
        <div class="'.$class['6'].'" onmouseover="tooltip.show(\''.$tooltip[6].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['6']['img'].'   
        </div>
        <div class="'.$class['9'].'" onmouseover="tooltip.show(\''.$tooltip[9].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['9']['img'].'   
        </div>
    </div>
    <div class="col2">
        <div class="'.$class['1'].'" onmouseover="tooltip.show(\''.$tooltip[1].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['1']['img'].'   
        </div>
        <div class="'.$class['4'].'" onmouseover="tooltip.show(\''.$tooltip[4].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['4']['img'].'   
        </div>
        <div class="'.$class['7'].'" onmouseover="tooltip.show(\''.$tooltip[7].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['7']['img'].'   
        </div>
        <div class="'.$class['8'].'" onmouseover="tooltip.show(\''.$tooltip[8].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['8']['img'].'   
        </div>
    </div>
    <div class="col3">
        <div class="'.$class['3'].'" onmouseover="tooltip.show(\''.$tooltip[3].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['3']['img'].'   
        </div>
        <div class="'.$class['5'].'" onmouseover="tooltip.show(\''.$tooltip[5].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['5']['img'].'   
        </div>
        <div class="'.$class['10'].'" onmouseover="tooltip.show(\''.$tooltip[10].'\', 225)" onmouseout="tooltip.hide()">  
            '.$item['10']['img'].'   
        </div>
    </div>
</div>';

/// End of the EQ SHOWER modified by Kavvson //  
$main_content .= '</tr></TABLE></td>';  
                        if ($player->getCustomField( 'show_bars' ) == 1) {
            //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'] and $player->getCustomField( 'show_skills' ) == 1) {
                        //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
                        if ($player->getCustomField( 'show_quests' ) == 1) {
                        $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;

                        //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>';
        }
}
?>
 
Succesfully inserted 1137 rows.
And failed to insert 0 rows:

Powered by Soulreaper, SoulAAC dev.
Parsing took 4.018618 seconds.
 

Similar threads

V
  • Question
AAC reset system geisor
Replies
0
Views
290
vitorelias1
V
Back
Top