function equipt($char)
{
$inventory= mssql_fetch_array(mssql_query("SELECT * FROM Character WHERE Name='$char'"));
mssql_query("declare @it varbinary(1920); set @it=(SELECT [Inventory] FROM [Character] WHERE [Name]='$char'); print @it");
$items = substr(substr(mssql_get_last_message(),2),0,384);
if($inventory['Class'] == 48) $invimage = 'images/inventorymg.jpg';
else $invimage = 'images/inventory.jpg';
$output = "<br />
<table width='298' height='315' border='0' cellpadding='7' cellspacing='0' bordercolor='#FFFFFF' background='$invimage' align='center'>
<tr>
<td height='71' colspan='7'>
</td>
</tr>
<tr>";
//Imp
{
$output .= "<td width='6' rowspan='5'> </td>";
$item = substr($items,8*32,32);
if(!iteminfo($item))
{
$output .= "<td width='51' height='70'></td>";
}
else
{
$output .= "<td width='51' height='70' style='".iteminfo($item)."</td>";
}
$output .= "<td width='22'> </td>";
}
//Helm
{
$item = substr($items,2*32,32);
if(!iteminfo($item))
{
$output .= "<td style=''></td>";
}
else
{
$output .= "<td style='".iteminfo($item)."</td>";
}
}
//Wings
{
$item = substr($items,7*32,32);
if(!iteminfo($item))
{
$output .= "<td colspan='2' style=''></td>";
}
else
{
$output .= "<td colspan='2' style='".iteminfo($item)."</td>";
}
$output .= "<td width='7' rowspan='5'> </td></tr>";
}
//Left Hand
{
$output .= "<tr>";
$item = substr($items,0*32,32);
if(!iteminfo($item))
{
$output .= "<td rowspan='2' style=''></td>";
}
else
{
$output .= "<td rowspan='2' style='".iteminfo($item)."</td>";
}
}
//Pendant
{
$item = substr($items,9*32,32);
if(!iteminfo($item))
{
$output .= "<td height='35' style=''></td>";
}
else
{
$output .= "<td height='35' style='".iteminfo($item)."</td>";
}
}
//Armor
{
$item = substr($items,3*32,32);
if(!iteminfo($item))
{
$output .= "<td rowspan='2' style=''></td>";
}
else
{
$output .= "<td rowspan='2' style='".iteminfo($item)."</td>";
}
$output .= "<td rowspan='2'> </td>";
}
//Shield
{
$item = substr($items,1*32,32);
if(!iteminfo($item))
{
$output .= "<td rowspan='2' style=''></td>";
}
else
{
$output .= "<td rowspan='2' style='".iteminfo($item)."</td>";
}
$output .= "</tr><tr><td height='70'> </td></tr><tr>";
}
//Gloves
{
$item = substr($items,5*32,32);
if(!iteminfo($item))
{
$output .= "<td rowspan='2' style=''></td>";
}
else
{
$output .= "<td rowspan='2' style='".iteminfo($item)."</td>";
}
}
//Left Ring
{
$item = substr($items,10*32,32);
if(!iteminfo($item))
{
$output .= "<td style='height: 30px;'></td>";
}
else
{
$output .= "<td style='height: 30px;".iteminfo($item)."</td>";
}
}
//Pants
{
$item = substr($items,4*32,32);
if(!iteminfo($item))
{
$output .= "<td rowspan='2' style=''></td>";
}
else
{
$output .= "<td rowspan='2' style='".iteminfo($item)."</td>";
}
}
//Right Ring
{
$item = substr($items,11*32,32);
if(!iteminfo($item))
{
$output .= "<td style='height: 30px;'></td>";
}
else
{
$output .= "<td style='height: 30px;".iteminfo($item)."</td>";
}
}
//Boots
{
$item = substr($items,6*32,32);
if(!iteminfo($item))
{
$output .= "<td width='51' rowspan='2' style=''></td>";
}
else
{
$output .= "<td width='51' rowspan='2' style='".iteminfo($item)."</td>";
}
}
$output .= "</tr>
<tr>
<td height='32'>
</td>
<td width='19'>
</td>
</tr>
<tr>
<td colspan='7' height='7'>
</td>
</tr>
</table><br />";
return $output;
}
