[Share] Current Heros website script - OFF

[GoDofAdeN]

List of heros of the current month

 

It looks like this:

 

 

<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>

 

to make working this script, you need this other script too => http://www.maxcheaters.com/forum/index.php?topic=64007.0

 

Credits - FidoW

[Dr.Metall]

.html or .php ?

[GoDofAdeN]

Its PhP ofc !

[CriticalError]

omg awesome share mate thanks a lot really very grateful!!!!

[*SlimShadow*^]

2 problems with the share..dont work dont understand in echo

[disorder25]

can you make a tutorial of how to get this and the other script to work, like do we have to add anything to one of the php files to call the other one. Please explain how we set this thing up, I downloaded both phps but they don't work. My server is l2j latest revision.

Thanks in advance.

[MaestroLuke]

here it is an l2off section mate :)

that's why the script doesn't work

in l2j section similar scripts exist

[daredevil911]

this is cool i will put in my site

[disorder25]

Oh sorry I didn't see the word OFF on the subject, but this is the coolest hero script I haven't seen and all the other ones i seen in here aren't as good as this. I wish I could find a script like this for L2j.

Can somebody post a similar script that will work with L2j.

Thanks for telling me.

[pintados]

great share man. it also looks very nice.

[Bruj4h]

Nice work and ty for sharing!!

[maxicroma]

good share thx :D

[zconll]

Thanks, i was looking for this script.

[Strength]

CONVERTED TO L2J ->

http://www.maxcheaters.com/forum/index.php?topic=99196

[The_Shaft]

thx Strength I will try it