<html>
<head>
<title>Heroes</title>
<style>
body {
margin: 0px;
padding: 0px;
background: #2E0601;
color: #ffffff;
font-family: tahoma, verdana;
font-size: 8pt;
}
td {
font-family: tahoma, verdana;
font-size: 8pt;
margin: 0;
color: #ffffff;
}
b {
font-weight: bold;
color: #84c3f8;
}
A {
color: #ffe155;
text-decoration: none;
}
A:link { color: #ffe155; }
A:visited { color:#e8a400; }
A:active { color: #ffff99; }
A:hover { color: #ffff99; text-decoration: underline; }
.tabletitle {
color: #FFFFFF;
background-color: #4B150E;
border-width: 2; border-style: solid;
border-color: #000000;
}
</style>
</head>
<body>
<center>
<table class='info'>
<tr class='info'><td align='center'><b>Current Heros</b></td></tr>
</table>
<?
$class_list=array(
0=>"Fighter",1=>"Warrior",2=>"Gladiator",3=>"Warlord",4=>"Knight",5=>"Paladin",6=>"Dark Avenger",7=>"Rogue",
8=>"Treasure Hunter",9=>"Hawkeye",10=>"Mage",11=>"Wizard",12=>"Sorcerer",13=>"Necromancer",14=>"Warlock",15=>"Cleric",
16=>"Bishop",17=>"Prophet",18=>"Elven Fighter",19=>"Elven Knight",20=>"Temple Knight",21=>"Swordsinger",22=>"Elven Scout",23=>"Plains Walker",
24=>"Silver Ranger",25=>"Elven Mage",26=>" Elven Wizard",27=>" Spellsinger",28=>"Elemental Summoner ",29=>"Oracle",
30=>"Elder",31=>"Dark Fighter",32=>"Palus Knightr",33=>"Shillien Knight",34=>"Bladedancer",35=>"Assasin",36=>"Abyss Walker",
37=>"Phantom Ranger",38=>"Dark Mage",39=>"Dark Wizard",40=>"Spellhowler",41=>"Phantom Summoner",42=>"Shillien Oracle",43=>"Shilien Elder",
44=>"Orc Fighter",45=>"Orc Raider",46=>"Destroyer",47=>"Orc Monk",48=>"Tyrant",49=>"Orc Mage",50=>"Orc Shaman",51=>"Overlord",
52=>"Warcryer",53=>"Dwarven Fighter",54=>"Scavenger",55=>"Bounty Hunter",56=>"Artisan", 57=> "Warsmith",
88=>"Duelist",89=>"Dreadnought",90=>"Phoenix Knight",91=>"Hell Knight",92=>"Sagittarius",93=>"Adventurer",94=>"Archmage",95=>"Soultaker",
96=>"Arcana Lord",97=>"Cardinal",98=>"Hierophant",99=>"Evas Templar",100=>"Sword Muse",101=>"Wind Rider",102=>"Moonlight Sentinel",
103=>"Mystic Muse",104=>"Elemental Master",105=>"Evas Saint",106=>"Shillien Templar",107=>"Spectral Dancer",108=>"Ghost Hunter",
109=>"Ghost Sentinel",110=>"Storm Screamer",111=>"Spectral Master",112=>"Shillien Saint",113=>"Titan",114=>"Grand Khavatari",
115=>"Dominator",116=>"Doomcryer",117=>"Fortune Seeker",118=>"Maestro",
123=>"Male Soldier",124=>"Female Soldier",125=>"Trooper",126=>"Warder",127=>"Berserker",
128=>"Male Soulbreaker",129=>"Female Soulbreaker",130=>"Arbalester",131=>"Doombringer",
132=>"Male Soulhound",133=>"Female Soulhound",134=>"Trickster",135=>"Inspector",136=>"Judicator"
);
// db config
$CONFIG['worlddbname'] = "lin2world"; // Database Name
$CONFIG['dbaddress'] = ""; // MSSQL IP
$CONFIG['dbuser'] = ""; // MSSQL User
$CONFIG['dbpass'] = ""; // MSSQL Password
// db connection!
$dbconnect = @mssql_connect ($CONFIG['dbaddress'], $CONFIG['dbuser'], $CONFIG['dbpass']);
@mssql_select_db ($CONFIG['worlddbname'], $dbconnect) or die (mysql_error());
function do_query($query) {
$arr = array();
$result = mssql_query($query) or die("Error SQL: ".mssql_get_last_message());
for ($x=0; $arr[$x] = mssql_fetch_assoc($result); $x++);
unset($arr[count($arr)-1]);
return $arr;
}
$query = "
USE lin2world
SELECT char_name,subjob0_class,pledge.name as 'pname',alliance.name as 'aname',pledge.crest_id as 'pcrest',alliance.crest_id as 'acrest',win_count,race
FROM user_data
LEFT JOIN pledge ON pledge.pledge_id = user_data.pledge_id
INNER JOIN user_nobless ON user_nobless.char_id = user_data.char_id
LEFT JOIN alliance ON alliance.id = pledge.alliance_id
WHERE hero_type > 0
AND win_count > 0
AND builder = 0
AND account_id > 0
ORDER BY subjob0_class
";
$heroes_actuales = do_query($query);
if (sizeof($heroes_actuales) == 0) echo "No heros found.";
else {
echo "
<table class='info'><tr bgcolor='333333' align='center'>\n
<tr bgcolor='333333' align='center'>
<td width='24%' align='left'><b>Name</b></td>
<td width='24%' align='left'><b>Class</b></td>
<td width='24%' align='left'><b>Pledge</b></td>
<td width='24%' align='left'><b>Alliance</b></td>
<td width='4%' align='left'><b>#</b></td>
</tr>
";
$i=0;
foreach($heroes_actuales as $hero) {
if (!($i%2)) echo "<tr bgcolor='000000' align='center'>";
else echo "<tr bgcolor='333333' align='center'>";
echo "
<td align='left'>".$hero['char_name']."</td>
<td align='left'>".$class_list[$hero['subjob0_class']]."</td>
<td align='left'>
";
if ($hero['pcrest'] != 0) echo "<img height='12' src='crest.php?id=".$hero['pcrest']."'> ";
echo $hero['pname']."</td><td align='left'>";
if ($hero['acrest'] != 0) echo "<img height='12' src='crest.php?id=".$hero['acrest']."'> ";
echo $hero['aname']."</td><td align='left'>".$hero['win_count']."</td></tr>";
$i++;
}
echo "</table>";
}
?>
<body>
</html>