/function.php

<?PHP
$charname = $_GET[charname];
 include_once "config.php";
$mysql_connection = mysql_connect($host,$user,$password);
$database = mysql_select_db($database,$mysql_connection);
?>

<?php
$SQL5=
"
SELECT account_id FROM `char` WHERE `name` LIKE '$charname';
";
$acc_res = mysql_query($SQL5);
$acc_id = mysql_fetch_row($acc_res);

//echo $acc_id[0];

$SQL6=
"
SELECT `sex` from `login` where account_id = '$acc_id[0]';
";
$sex = mysql_query($SQL6);
$sexcheck = mysql_fetch_row($sex);

//echo $sexcheck[0];

if ($sexcheck[0] == M) 
{
?>
<img src="images/male.png">
<?php
}
?>
<?php
if ($sexcheck[0] == F)
{
?>
<img src="images/female.png">
<?php
}
?>

<?php
$SQL3="
SELECT `char_id` FROM `char` WHERE `name` LIKE '$charname';
";
$charid = mysql_query($SQL3);
$char_row=mysql_fetch_assoc($charid);

$SQL=
"
SELECT `name`,`base_level`,`job_level`,`class`,`max_hp`,`max_sp`
FROM `char`
WHERE `name` LIKE '$charname';
";

$result = mysql_query($SQL);
while($row = mysql_fetch_object($result))
{
?> 

<table>
<tr>
<td>Name: <?php echo $charname; ?></td>
<tr>
<td>Class</TD>
<td>

<?php 
if ($row->class == 0) { echo "Novice";} 
elseif ($row->class == 1) { echo "Swordman";}
elseif ($row->class == 2) { echo "Mage";}
elseif ($row->class == 3) { echo "Archer";} 
elseif ($row->class == 4) { echo "Acolyte";} 
elseif ($row->class == 5) { echo "Merchant";} 
elseif ($row->class == 6) { echo "Thief";}  
elseif ($row->class == 7) { echo "Knight";} 
elseif ($row->class == 8) { echo "Priest";}  
elseif ($row->class == 9) { echo "Wizard";}  
elseif ($row->class == 10) { echo "Blacksmith";}  
elseif ($row->class == 11) { echo "Hunter";}  
elseif ($row->class == 12) { echo "Assasin";} 
elseif ($row->class == 13) { echo "Knight2";} 
elseif ($row->class == 14) { echo "Crusader";}  
elseif ($row->class == 15) { echo "Monk";}  
elseif ($row->class == 16) { echo "Sage";}  
elseif ($row->class == 17) { echo "Rouge";}  
elseif ($row->class == 18) { echo "Alchemist";}  
elseif ($row->class == 19) { echo "Bard";}  
elseif ($row->class == 20) { echo "Dancer";}  
elseif ($row->class == 21) { echo "Crusader";}  
elseif ($row->class == 23) { echo "Super Novice";} 
elseif ($row->class == 24) { echo "Gunslinger";}  
elseif ($row->class == 25) { echo "Ninja";}  
elseif ($row->class == 4001) { echo "High Novice";}  
elseif ($row->class == 4002) { echo "High Swordman";}  
elseif ($row->class == 4003) { echo "High Mage";}  
elseif ($row->class == 4004) { echo "High Archer";}  
elseif ($row->class == 4005) { echo "High Acolyte";} 
elseif ($row->class == 4006) { echo "High Merchant";} 
elseif ($row->class == 4007) { echo "High Thief";} 
elseif ($row->class == 4008) { echo "Lord Knight";} 
elseif ($row->class == 4009) { echo "High Priest";}  
elseif ($row->class == 4010) { echo "High Wizard";} 
elseif ($row->class == 4011) { echo "Whitesmith";} 
elseif ($row->class == 4012) { echo "Sniper";} 
elseif ($row->class == 4013) { echo "Assasin Cross";} 
elseif ($row->class == 4014) { echo "Lord Knight2";} 
elseif ($row->class == 4015) { echo "Paladin";}  
elseif ($row->class == 4016) { echo "Champion";}  
elseif ($row->class == 4017) { echo "Professor";}  
elseif ($row->class == 4018) { echo "Stalker";} 
elseif ($row->class == 4019) { echo "Creator";} 
elseif ($row->class == 4020) { echo "Clown";}  
elseif ($row->class == 4021) { echo "Gypsy";}  
elseif ($row->class == 4022) { echo "Paladin";} 
elseif ($row->class == 4023) { echo "Baby";}  
elseif ($row->class == 4024) { echo "Baby Swordman";}
elseif ($row->class == 4025) { echo "Baby Mage";}  
elseif ($row->class == 4026) { echo "Baby Archer";}  
elseif ($row->class == 4027) { echo "Baby Acolyte";}  
elseif ($row->class == 4028) { echo "Baby Merchant";} 
elseif ($row->class == 4029) { echo "Baby Thief";}  
elseif ($row->class == 4030) { echo "Baby Knight";}  
elseif ($row->class == 4031) { echo "Baby Priest";}  
elseif ($row->class == 4032) { echo "Baby Wizard";}  
elseif ($row->class == 4033) { echo "Baby Blacksmith";} 
elseif ($row->class == 4034) { echo "Baby Hunter";}  
elseif ($row->class == 4035) { echo "Baby Assasin";}  
elseif ($row->class == 4036) { echo "Baby Knight";}  
elseif ($row->class == 4037) { echo "Baby Crusader";} 
elseif ($row->class == 4038) { echo "Baby Monk";}  
elseif ($row->class == 4039) { echo "Baby Sage";}  
elseif ($row->class == 4040) { echo "Baby Rouge";}  
elseif ($row->class == 4041) { echo "Baby Alchemist";}  
elseif ($row->class == 4042) { echo "Baby Bard";}  
elseif ($row->class == 4043) { echo "Baby Dancer";}  
elseif ($row->class == 4044) { echo "Baby Crusade";} 
elseif ($row->class == 4045) { echo "Super Baby";}  
elseif ($row->class == 4046) { echo "Taekwon";}  
elseif ($row->class == 4047) { echo "Star Gladiator";}  
elseif ($row->class == 4048) { echo "Star Gladiator";}  
elseif ($row->class == 4049) { echo "Soul Linker";}  ?>
</TD>
</tr>
<tr>
<td>Base Level</td>
<td><?php echo $row->base_level; ?></td>
</tr>
<tr>
<td>Job Level</td>
<td><?php echo $row->job_level; ?></td>
</tr>
<tr>
<td>HP</td>
<td><?php echo $row->max_hp ?> </td>
</tr>
<tr>
<td>SP</td>
<td><?php echo $row->max_sp ?></td>
</tr>
</table>


 <?PHP
}
?>
<?PHP 
$sql_lowerhead = "SELECT `nameid` , `equip` , `name_japanese`
FROM `char` , `inventory` , `item_db`
WHERE `char`.`char_id` = `inventory`.`char_id`
AND `char`.`name` LIKE '$charname'
AND `inventory`.`equip` = '1'
AND `inventory`.`nameid` = `item_db`.`id`;";

$result_lowerhead = mysql_query($sql_lowerhead);
$row_lowerhead = mysql_fetch_row($result_lowerhead);

//echo $row_lowerhead[0];
//echo $row_lowerhead[1];
//echo $row_lowerhead[2];

$sql_middlehead = "SELECT `nameid` , `equip` , `name_japanese`
FROM `char` , `inventory` , `item_db`
WHERE `char`.`char_id` = `inventory`.`char_id`
AND `char`.`name` LIKE '$charname'
AND `inventory`.`equip` = '512'
AND `inventory`.`nameid` = `item_db`.`id`;";

$result_middlehead = mysql_query($sql_middlehead);
$row_middlehead = mysql_fetch_row($result_middlehead);

//echo $row_middlhead[0];
//echo $row_middlhead[1];
//echo $row_middlhead[2];

$sql_upperhead = "SELECT `nameid` , `equip` , `name_japanese`
FROM `char` , `inventory` , `item_db`
WHERE `char`.`char_id` = `inventory`.`char_id`
AND `char`.`name` LIKE '$charname'
AND `inventory`.`equip` = '265'
AND `inventory`.`nameid` = `item_db`.`id`;";

$result_upperhead = mysql_query($sql_upperhead);
$row_upperhead = mysql_fetch_row($result_upperhead);

//echo $row_upperhead [0];
//echo $row_upperhead [1];
//echo $row_upperhead [2];

$sql_armor = "SELECT `nameid` , `equip` , `name_japanese`
FROM `char` , `inventory` , `item_db`
WHERE `char`.`char_id` = `inventory`.`char_id`
AND `char`.`name` LIKE '$charname'
AND `inventory`.`equip` = '16'
AND `inventory`.`nameid` = `item_db`.`id`;";

$result_armor = mysql_query($sql_armor);
$row_armor = mysql_fetch_row($result_armor);

//echo $row_armor[0];
//echo $row_armor[1];
//echo $row_armor[2];

$sql_lhand = "SELECT `nameid` , `equip` , `name_japanese`
FROM `char` , `inventory` , `item_db`
WHERE `char`.`char_id` = `inventory`.`char_id`
AND `char`.`name` LIKE '$charname'
AND `inventory`.`equip` = '2'
AND `inventory`.`nameid` = `item_db`.`id`;";

$result_lhand = mysql_query($sql_lhand);
$row_lhand = mysql_fetch_row($result_lhand);

//echo $row_lhand[0];
//echo $row_lhand[1];
//echo $row_lhand[2];

$sql_rhand = "SELECT `nameid` , `equip` , `name_japanese`
FROM `char` , `inventory` , `item_db`
WHERE `char`.`char_id` = `inventory`.`char_id`
AND `char`.`name` LIKE '$charname'
AND `inventory`.`equip` = '32'
AND `inventory`.`nameid` = `item_db`.`id`;";

$result_rhand = mysql_query($sql_rhand);
$row_rhand = mysql_fetch_row($result_rhand);

///echo $row_rhand[0];
///echo $row_rhand[1];
///echo $row_rhand[2];

$sql_2hand = "SELECT `nameid` , `equip` , `name_japanese`
FROM `char` , `inventory` , `item_db`
WHERE `char`.`char_id` = `inventory`.`char_id`
AND `char`.`name` LIKE '$charname'
AND `inventory`.`equip` = '34'
AND `inventory`.`nameid` = `item_db`.`id`;";

$result_2hand = mysql_query($sql_2hand);
$row_2hand = mysql_fetch_row($result_2hand);

//echo $row_2hand[0];
//echo $row_2hand[1];
//echo $row_2hand[2];

$sql_robe = "SELECT `nameid` , `equip` , `name_japanese`
FROM `char` , `inventory` , `item_db`
WHERE `char`.`char_id` = `inventory`.`char_id`
AND `char`.`name` LIKE '$charname'
AND `inventory`.`equip` = '4'
AND `inventory`.`nameid` = `item_db`.`id`;";

$result_robe = mysql_query($sql_robe);
$row_robe = mysql_fetch_row($result_robe);

//echo $row_robe[0];
//echo $row_robe[1];
//echo $row_robe[2];

$sql_foot = "SELECT `nameid` , `equip` , `name_japanese`
FROM `char` , `inventory` , `item_db`
WHERE `char`.`char_id` = `inventory`.`char_id`
AND `char`.`name` LIKE '$charname'
AND `inventory`.`equip` = '64'
AND `inventory`.`nameid` = `item_db`.`id`;";

$result_foot = mysql_query($sql_foot);
$row_foot = mysql_fetch_row($result_foot);

//echo $row_foot[0];
//echo $row_foot[1];
//echo $row_foot[2];

$sql_access = "SELECT `nameid` , `equip` , `name_japanese`
FROM `char` , `inventory` , `item_db`
WHERE `char`.`char_id` = `inventory`.`char_id`
AND `char`.`name` LIKE '$charname'
AND `inventory`.`equip` = '8'
AND `inventory`.`nameid` = `item_db`.`id`;";

$result_access = mysql_query($sql_access);
$row_access = mysql_fetch_row($result_access);

//echo $row_access[0];
//echo $row_access[1];
//echo $row_access[2];

$sql_access_2 = "SELECT `nameid` , `equip` , `name_japanese`
FROM `char` , `inventory` , `item_db`
WHERE `char`.`char_id` = `inventory`.`char_id`
AND `char`.`name` LIKE '$charname'
AND `inventory`.`equip` = '128'
AND `inventory`.`nameid` = `item_db`.`id`;";

$result_access_2 = mysql_query($sql_access_2);
$row_access_2 = mysql_fetch_row($result_access_2);

//echo $row_access_2[0];
//echo $row_access_2[1];
//echo $row_access_2[2];

$sql_vergleich= "SELECT `nameid` , `equip` , `name_japanese`
FROM `char` , `inventory` , `item_db`
WHERE `char`.`char_id` = `inventory`.`char_id`
AND `char`.`name` LIKE '$charname'
AND `inventory`.`equip` = '666'
AND `inventory`.`nameid` = `item_db`.`id`;";

$result_vergleich = mysql_query($sql_vergleich);
$row_vergleich = mysql_fetch_row($result_vergleich);


?>