i use this php script from CMS
and +9 items not showing only +0 items :S
pic :
Code:
$id = (int)$_GET['id'];{
echo '<b>Equipment:</b><br>';
echo '<style type="text/css">
#equipment {
background:url("./images/inventory/equipment.png");
width:156px;
height:188px;
}
#tooltip_item {
width:212px;
position:absolute;
}
#item_middle {
background:url("./images/inventory/tooltip_item.png") repeat-y right center;
font-family:Tahoma, Geneva, sans-serif;
text-shadow:0 1px 0px #000;
line-height:22px;
font-size:12px;
color:#fff;
text-align:center;
}
#item_middle font {
text-shadow:0 1px 0px #000;
}
.item_top {
background:url("./images/inventory/tooltip_item.png") no-repeat left top;
height:10px;
width:212px;
}
.item_bottom {
background:url("./images/inventory/tooltip_item.png") no-repeat left bottom;
height:10px;
width:212px;
}
#eq_0 {
position:absolute;
margin-left:43px;
margin-top:39px;
}
#eq_1 {
position:absolute;
margin-left:42px;
margin-top:4px;
}
#eq_2 {
position:absolute;
margin-left:43px;
margin-top:148px;
}
#eq_3 {
position:absolute;
margin-top:70px;
margin-left:77px;
}
#eq_4 {
position:absolute;
margin-top:6px;
margin-left:6px;
}
#eq_5 {
position:absolute;
margin-top:88px;
margin-left:117px;
}
#eq_6 {
position:absolute;
margin-left:118px;
margin-top:55px;
}
#eq_7 {
position:absolute;
margin-left:5px;
margin-top:117px;
}
#eq_8 {
position:absolute;
margin-top:117px;
margin-left:80px;
}
#eq_9 {
position:absolute;
margin-top:4px;
margin-left:118px;
}
#eq_10 {
position:absolute;
margin-top:39px;
margin-left:78px;
}
</style>';
$seleq = mysql_query("SELECT item.pos,item.count,item_proto.locale_name,item_proto.limitvalue0,item_proto.antiflag,item_proto.type,item_proto.applyvalue0,item_proto.applytype0,item_proto.applyvalue1,item_proto.applytype1,item_proto.applyvalue2,item_proto.applytype2,item_proto.value1,item_proto.value2,item_proto.value3,item_proto.value4,item_proto.value5,item.vnum,player.gold,item.attrtype0,item.attrvalue0,item.attrtype1,item.attrvalue1,item.attrtype2,item.attrvalue2,item.attrtype3,item.attrvalue3,item.attrtype4,item.attrvalue4,item.attrtype5,item.attrvalue5,item.attrtype6,item.attrvalue6
FROM item
LEFT JOIN item_proto ON item_proto.vnum = item.vnum
LEFT JOIN player ON player.id = item.owner_id
WHERE item.owner_id = '".$user->player_id."' AND item.window = 'EQUIPMENT' ORDER BY item.pos ASC") or die(mysql_error());
if(mysql_num_rows($seleq)>0) {
echo '<div id="equipment">';
while($eq = mysql_fetch_object($seleq)) {
if(preg_match('/\+/',$eq->gb2312name)) {
$plusnull = substr($eq->vnum,9,strlen($eq->vnum) - 9).'9';
}
else {
$plusnull = $eq->vnum;
}
$images = './images/items/';
if(strlen($plusnull)==2) {
$src = $images.'000'.$plusnull.'.png';
}
elseif(strlen($plusnull)==3) {
$src = $images.'00'.$plusnull.'.png';
}
elseif(strlen($plusnull)==4) {
$src = $images.'0'.$plusnull.'.png';
}
elseif(strlen($plusnull)==5) {
$src = $images.$plusnull.'.png';
}
if(!file_exists($src)) {
$src = $images.'27995.png';
}
echo '<div id="eq_'.$eq->pos.'" class="tooltip" title="'.item_title($eq).'"><img src="'.$src.'"></div>';
}
echo '</div>';
}
else {
echo 'No Items';
}
}
}
else {
echo 'Dieser Spieler existiert nicht.';
}
}
else {
echo '';
}
?>
