<html>
<?php
$mysql_access = mysql_connect("hostname", "username", "password");
mysql_select_db("databasename", $mysql_access);
if(!$mysql_access) {
echo "can't connect to db<br>\r\n";
}
else {
$username = $_GET['username'];
$query = "SELECT user_id FROM users WHERE username='$username'";
$result = mysql_query($query);
if(!$result) {
echo "no username matched<br>\r\n";
}
elseif($username!=NULL) {
$row = mysql_fetch_assoc($result);
$userid = $row['user_id'];
$query = "SELECT data_value FROM save_data WHERE user_id=$userid and data_name='Game_Actors/@data[1]/Game_Actor";
$query1 = $query . "'";
$rezultat = mysql_query($query1);
if(!$rezultat) {
echo "This username ($username) does not exist.<br>\r\n";
echo "Please, try to search for another username.<br>\r\n";
}
else {
$query1 = $query . "/@skills'";
$rezultskills = mysql_query($query1);
if(!rezultskills) {
echo "no skill matched<br>";
}
$query1 = $query . "/@states'";
$rezultstates = mysql_query($query1);
if(!$rezultstates) {
echo "no state matched<br>";
}
$row = mysql_fetch_assoc($rezultat);
$stat = explode(",", trim($row['data_value']," []"));
$row = mysql_fetch_assoc($rezultskills);
$skills = explode(",", trim($row['data_value']," []"));
$row = mysql_fetch_assoc($rezultstates);
$states = explode(",", trim($row['data_value']," []"));
echo "<table align='center' cellpadding=2 cellspacing=1 border=1 width='60%'>\r\n";
echo "<colgroup span=3 align='center' width='50%'>\r\n";
echo "<tr><th colspan=2 bgcolor='#01A8FF'>Viewing User $username</th></tr>\r\n";
$arrcol1 = Array("id","username","sprite","hue","class","weapon","armor 1","armor 2","armor 3","armor 4","level","exp","skills","hp","sp","states","maxhp_pls","maxsp_plus","str_plus","dex_plus","agi_plus","int_plus");
$classes = Array("None","Fighter","Lancer","Warrior","Thief","Hunter","Gunner","Cleric","Mage");
$armors = Array("None","Bronze Shield","Iron Shield","Steel Shield","Mythirl Shield","Bronze Helm","Iron Helm","Steel Helm","Mythirl Helm","Cotton Hat","Felt Hat","Magic Hat","Saint Hat","Bronze Armor","Iron Armor","Steel Armor","Mythirl Armor","Bronze Plate","Iron Plate","Steel Plate","Mythirl Plate","Cotton Robe","Felt Robe","Magic Robe","Saint Robe","Ring of Strenght","Ring of Dextality","Ring of Agility","Ring of Intelligence","Rin of Fire","Ring of Ice","Ring of Thunder","Ring of Water");
$weapons = Array("None","Bronze Sword","Iron Sword","Steel Sword","Mythirl Sword","Bronze Spear","Iron Spear","Steel Spear","Mythril Spear","Bronze Axe","Iron Axe","Steel Axe","Mythirl Axe","Bronze Knife","Iron Knife","Steel Knife","Mythirl Knife","Bronze Bow","Iron Bow","Steel Bow","Mythirl Bow","Bronze Gun","Iron Gun","Steel Gun","Mythirl Gun","Bronze Mace","Iron Mace","Steel Mace","Mythirl Mace","Bronze Rod","Iron Rod","Steel Rod","Mythirl Rod" );
$statesi = Array("None","Knockout","Stun","Venom","Dazzle","Mute","Confuse","Sleep","Paralyse","Weaken","Clumsy","Delay","Feeble","Sharp","Barrier","Resist","Blink");
$skillsi = Array("None","Heal","Greater Heal","Mass Heal","Remedy","Greater Remedy","Raise","Fire","Greater Fire","Mass Fire","Ice","Greater Ice","Mass Ice","Thunder","Greater Thunder","Mass Thunder","Water","Greater Water","Mass Water","Earth","Greater Earth","Mass Earth","Wind","Greater Wind","Mass Wind","Light","Greater Light","Mass Light","Darkness","Greater Darkness","Mass Darkness","Burst","Radiate","Venom","Mass Venom","Dazzle","Mass Dazzle","Mute","Mass Mute","Confuse","Mass Confuse","Sleep","Mass Sleep","Paralyze","Mass Paralyze","Weaken","Mass Weaken","Clumsy","Mass Clumsy","Delay","Mass Delay","Feeble","Mass Feeble","Sharp","Barrier","Resist","Blink","Cross Cut","Feint Attack","Hurricane","Spiral Blade","Leg Sweep","Beast Slayer","Thunder Pierce","Screw Thrust","Power Break","Mind Break","Aqua Buster","Rolling Axe","Poison Edge","Eagle Claw","Illusion","Deadly Dance","Bird Killer","Mute Arrow","Paralyze Arrow","Sidewinder","Silver Bullet","Burinig Shot","Frost Shot","Crescent Force" );
$i = 0;
foreach($stat as $key => $value) {
if(in_array($key, array(0,1,3,12,15))) continue;
$i++;
$bgcolor = ($i % 2) ? "01C0FF" : "01A8FF";
$col1 = $arrcol1["$key"];
if ($i > 17) { break; }
switch($key) {
case 2: $col2 = "<table border=0 cellpadding=0 width=37><tr height=50><td background='sprites/" . trim($value, '"') . ".png'> </td></tr></table>"; break;
case 4: $col2 = $classes[$value]; break;
case 5: $col2 = $weapons[$value]; break;
case 6:
case 7:
case 8:
case 9: $col2 = $armors[$value]; break;
default: $col2 = $value;
}
echo "<tr bgcolor='#$bgcolor'><td>$col1</td><td>$col2</td></tr>\r\n";
}
if(!$skills[0]) $skills[0] = 0;
foreach($skills as $key => $value) {
$i++;
$bgcolor = ($i % 2) ? "01C0FF" : "01A8FF";
$aux = "<tr bgcolor='#$bgcolor'>";
if($key==0) $aux .= "<td rowspan=" . count($skills) . ">Skills</td>";
$aux .= "<td>$skillsi[$value]</td></tr>\r\n";
echo $aux;
}
if(!$states[0]) $states[0] = 0;
foreach($states as $key => $value) {
$i++;
$bgcolor = ($i % 2) ? "01C0FF" : "01A8FF";
$aux = "<tr bgcolor='#$bgcolor'>";
if($key==0) $aux .= "<td rowspan=" . count($states) . ">States</td>";
$aux .= "<td>$statesi[$value]</td></tr>\r\n";
echo $aux;
}
echo "</table>\r\n";
echo "<p align='center'>Search for another user</p>\r\n";
}
}
}
echo "<div align='center'>\r\n";
echo "<form method='GET' action='search.php'>\r\n";
echo "<input type='text' name='username' size=30>\r\n";
echo "<input type='submit' value='send'>\r\n";
echo "</form>\r\n";
echo "</div>\r\n";
?></div>
</body>
</html>