[Help] With Inventory Script

splite

New Member
Joined
Nov 5, 2009
Messages
15
Reaction score
1
Hi i have taking out Dark Style Web the charter whois. And i want to make it standalone only as inventory info. As far as i got nothing went worng...! Only that when you point at item the options are showing as html codes. Here is screen and whois file

Screen : http://yfrog.com/5vinventoryoj

PHP:
<?php
include"config.php";
include"inc/sql.inc.php";
include"inc/lang-change.inc.php";
include "inc/website.inc.php";
include "inc/warehouse.inc.php";

$name = $_GET['name'];

$char_info = "select Vitality,Strength,Energy,Dexterity,LevelUpPoint,cLevel,Class,MapNumber,MapPosX,MapPosY,AccountID,ctlcode,money,Resets,PkCount,Class,reset_limit from Character WHERE Name='$name'";
$char_info = mssql_query($char_info);
$char_info = mssql_fetch_row($char_info);

$guild_info = "Select G_Name FROM GuildMember WHERE Name='$name'";
$guild_info = mssql_query($guild_info);
$guild = mssql_fetch_row($guild_info);
$guild=$guild[0];

$map_x= $char_info[8];
$map_y= $char_info[9];


$pointssum=CalculateStat($char_info[0])+CalculateStat($char_info[1])+CalculateStat($char_info[2])+CalculateStat($char_info[3])+$char_info[4];
$pointssum=number_format($pointssum);
$new_vit = number_format(CalculateStat($char_info[0]));
$new_str = number_format(CalculateStat($char_info[1]));
$new_eng = number_format(CalculateStat($char_info[2]));
$new_agi = number_format(CalculateStat($char_info[3]));
$levelup = ($char_info[4]);
$level = $char_info[5];
$mapx = $char_info[8];
$mapy = $char_info[9];
$acc = $char_info[10];
$code = $char_info[11];
$money = number_format($char_info[12]);
$pkcount = $char_info[13];
$resets = $char_info[14];



$pk_info = "select PkLevel,PkCount from Character WHERE Name='$name'";
$pk_info = mssql_query($pk_info);
$pk_info = mssql_fetch_row($pk_info);

$pkcount=$pk_info[1];
$pklevel=get_char_pklevel($pk_info[0]);
$map=get_map_name($char_info[7]);
$class1 = get_char_class($char_info[6]);

/////

$online_info="Select ConnectStat,ServerName,ConnectTM,DisConnectTM,IP from MEMB_STAT where memb___id='$char_info[10]'";
$online_info = mssql_query($online_info);
$online_info = mssql_fetch_row($online_info);

$condate = $online_info[2];
$discondate = $online_info[3];

$sqll= mssql_query("declare @connect_tm nvarchar(20); 
 set @connect_tm = (select [ConnectTM] from [MEMB_STAT] where memb___id='$char_info[10]');
 print @connect_tm;");
$condate=mssql_get_last_message();

$sqll= mssql_query("declare @connect_tm nvarchar(20); 
 set @connect_tm = (select [DisConnectTM] from [MEMB_STAT] where memb___id='$char_info[10]');
 print @connect_tm;");
$discondate=mssql_get_last_message();

$status=$online_info[0];
$serv=$online_info[1];

//
if ($status == '1'){

$get_gameidc="Select GameIDC from AccountCharacter where Id='$char_info[10]'";
$get_gameidc = mssql_query($get_gameidc);
$get_gameidc = mssql_fetch_row($get_gameidc);


}
//

if ($get_gameidc[0]=="$name"){$status='1';
}
else{$status='0';
}

if ($serv == $ServerName['1']){$serv='1';
}
if ($serv == $ServerName['2']){$serv='2';
}
if ($serv == $ServerName['3']){$serv='3';
}
if ($serv == $ServerName['4']){$serv='4';
}
if ($serv == $ServerName['5']){$serv='5';
}
if ($serv == $ServerName['vip']){$serv='VIP';
}




if ($status == '0'){$status="<font color=red><B>Offline ($serv)</B></font>";
}

if ($status == '1'){$status="<font color=green><B>Online ($serv)</B></font>";
}
/////

$condate="$condate ($serv)";
$discondate="$discondate ($serv)";

$spec_status=$code;

if ($code=='24' OR $code == '8'){
$status="hidden";
$condate="hidden (x)";
$discondate="hidden (x)";
$map='hidden';
$map_x='';
$map_y='';

}
$sqll= mssql_query("declare @items varbinary(1728); 
	set @items = (select [Inventory] from [Character] where [Name]='$name');
	print @items;");
$sqll=mssql_get_last_message();

$sqll	= substr($sqll,2);

$i = -1;
while($i<11) {
$i++;

$item_code_check = $i*20;
$item[$i] = substr ($sqll, $item_code_check, 20);
$db_item_info[$i] = ItemInfo($item[$i]);
}
?>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="keywords" content="mu, muonline, dark, game, mmorpg, rpg, online, best, server, ">
<!-- base href="" -->
<link href="<?php print $template_dir;?>style.css" rel="StyleSheet">
<script type="text/javascript" src="<?php print $template_dir;?>main.js"></script>
<script type="text/javascript" src="<?php print $template_dir;?>overlib.js"></script>
<script type="text/javascript" src="<?php print $template_dir;?>flash_content.js"></script>
<script charset="utf-8" id="<?php print $template_dir;?>injection_graph_func" src="injection_graph_func.js"></script>
<script type="text/javascript" src="<?php print $template_dir;?>js/jquery-1.js"></script>
<script type="text/javascript" src="<?php print $template_dir;?>js/jquery_002.js"></script>
<script type="text/javascript" src="<?php print $template_dir;?>js/jquery.js"></script>
<script type="text/javascript" src="<?php print $template_dir;?>js/jquery_003.js"></script>
<script type="text/javascript" src="<?php print $template_dir;?>js/m.js"></script>
</head>
<script type="text/javascript">
$(function() { $("*[title]").Tooltip({ track:true, delay:0, showURL:false }); });

/* Lang vars */
var lang_btclose = '<?php print phrase_lang_btclose;?>';
var lang_btoriginal = '<?php print phrase_lang_btoriginal;?>';
var lang_btresort = '<?php print phrase_lang_btresort;?>';
var lang_btclear = '<?php print phrase_lang_btclear;?>';
</script>
<div class="ap-norm"><?php print phrase_whois_char;?>: <?php print $name;?></div>
<table border="0" cellspacing="1" cellpadding="0" width="100%" align="center">
<tr><td rowspan="18" align="left" width="440">
<table border="0" cellspacing="3" cellpadding="0" class="charitems">
<tr align="middle">
<td width="100" height="105"><?php if($db_item_info[8]['whois_image']){?><a class="tt" ><?php print $db_item_info[8]['whois_image'];?></a><?}else print"&nbsp;";?></td>
<td width="45" style="background-color:#feedd5;"></td>
<td width="115"><?php if($db_item_info[2]['whois_image']){?><a class="tt"><?php print $db_item_info[2]['whois_image'];?></a><?}else print"&nbsp;";?></td>
<td width="145" colspan="2"><?php if($db_item_info[7]['whois_image']){?><a class="tt"><?php print $db_item_info[7]['whois_image'];?></a><?}else print"&nbsp;";?></td></tr>
<tr align="middle">
<td width="100" height="145" rowspan="2">
<?php if($db_item_info[0]['whois_image']){?><a class="tt" ><?php print $db_item_info[0]['whois_image'];?></a><?}else print"&nbsp;";?>
</td><td width="45" height="45"><?php if($db_item_info[9]['whois_image']){?><a class="tt"><?php print $db_item_info[9]['whois_image'];?></a><?}else print"&nbsp;";?></td>
<td width="115" rowspan="2"><?php if($db_item_info[3]['whois_image']){?><a class="tt"><?php print $db_item_info[3]['whois_image'];?></a><?}else print"&nbsp;";?></td>
<td width="45" rowspan="2" style="background-color:#feedd5;"></td>
<td width="100" rowspan="2"><?php if($db_item_info[1]['whois_image']){?><a class="tt"><?php print $db_item_info[1]['whois_image'];?></a><?}else print"&nbsp;";?>
</td></tr>
<tr><td width="45" height="100" style="background-color:#feedd5;"></td></tr>
<tr align="middle"><td width="100" height="100" rowspan="2"><?php if($db_item_info[5]['whois_image']){?><a class="tt"><?php print $db_item_info[5]['whois_image'];?></a><?}else print"&nbsp;";?></td>
<td width="45" height="45"><?php if($db_item_info[10]['whois_image']){?><a class="tt"><?php print $db_item_info[10]['whois_image'];?></a><?}else print"&nbsp;";?></td><td width="115" rowspan="2"><?php if($db_item_info[4]['whois_image']){?><a class="tt"><?php print $db_item_info[4]['whois_image'];?></a><?}else print"&nbsp;";?></td>
<td width="45" height="45"><?php if($db_item_info[11]['whois_image']){?><a class="tt"><?php print $db_item_info[11]['whois_image'];?></a><?}else print"&nbsp;";?></td><td width="100" rowspan="2"><?php if($db_item_info[6]['whois_image']){?><a class="tt"><?php print $db_item_info[6]['whois_image'];?></a><?}else print"&nbsp;";?></td>
</tr>
<td style="background-color: #feedd5;" width="45" height="55"></td>
<td style="background-color: #feedd5;" width="45" height="55"></td>
</tr></tbody></table>
	</td>
	<tr bgcolor="#fbdaab">
	<td><b><?php print phrase_whois_char_char;?></b></td>
	<td><?php echo $name;?></td>
</tr>
<tr>

<td><b><?php print phrase_whois_char_class;?></b></td>
<td><?php echo $class1;?></td>
</tr>
<tr bgcolor="#fbdaab">
<td><b><?php print phrase_whois_char_level;?></b></td>
<td><?php echo $level;?></td>
</tr>
<tr>
<td><b><?php print phrase_whois_char_resets;?></b></td>

<td><?php echo "$char_info[13]/$char_info[16]";?></td>
</tr>
<tr bgcolor="#fbdaab">
<td><b><?php print phrase_whois_char_pklevel;?></b></td>
<td><?php echo "$pklevel ($pkcount)";?></td>
</tr>
<tr>
<td><b><?php print phrase_whois_char_location;?></b></td>
<td><?php echo"$map ($map_x x $map_y)";?></td>

</tr>
<tr bgcolor="#fbdaab">
<td><b><?php print phrase_whois_char_str;?></b></td>
<td><?php echo $new_str; ?></td>
</tr>
<tr>
<td><b><?php print phrase_whois_char_agi;?></b></td>
<td><?php echo $new_agi; ?></td>
</tr>

<tr bgcolor="#fbdaab">
<td><b><?php print phrase_whois_char_vit;?></b></td>
<td><?php echo $new_vit; ?></td>
</tr>
<tr>
<td><b><?php print phrase_whois_char_ene;?></b></td>
<td><?php echo $new_eng; ?></td>
</tr>
<tr bgcolor="#fbdaab">

<td><b><?php print phrase_whois_char_levelup;?></b></td>
<td><?php echo $levelup; ?></td>
</tr>
<tr>
<td><b><?php print phrase_whois_char_pointsum;?></b></td>
<td><?php echo $pointssum; ?></td>
</tr>
<tr bgcolor="#fbdaab">
<td><b><?php print phrase_whois_char_guild;?></b></td>

<td><?php if ($guild != NULL){
echo "<A href=\"?pg=guild&name=$guild\">$guild</A>";
}
else echo"n/a";
	  ?></td>
</tr>
<tr>
<td><b><?php print phrase_whois_char_status;?></b></td>
<td><?php print $status;?></td>
</tr>
<tr bgcolor="#fbdaab">
<td><b><?php print phrase_whois_char_last_connect;?></b></td>
<td><?php echo $condate;?></td>

</tr>
<tr>
<td><b><?php print phrase_whois_char_last_disconnect;?></b></td>
<td><?php echo $discondate;?></td>
</tr>
</table>

<br />
<br />

<div align="center">
	<input type="button" class="button-gray" onclick="window.location='?pg=whois-acc&nick=<?php print $name;?>';" value="<?php print phrase_whois_char_whois_acc;?>" />

	<img src="img/spacer" width="5" height="1">
	<input type="button" class="button-gray" onclick="$('#tbwindow_whois_char').remove();" value="<?php print phrase_whois_char_close;?>" />
</div>

<script type="text/javascript">$(function() { $(".tt").Tooltip({ track: true, delay: 0, showURL: false }); });</script>

If someone could tell me whats wrong..? And also i tryed to add style files to folder.
(heidy)