Jump to content

Recommended Posts

Posted

List of heros of the current month

 

It looks like this:

 

currentheros.png

 

<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

  • 2 weeks later...
  • 1 month later...
  • 1 month later...
Posted

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.

Posted

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.

  • 2 weeks later...
  • 1 month later...
  • 1 year later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...