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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Posts

    • Hello everyone, we are one of the top gaming currency stores. We work exclusively with top projects. If you are interested in anything like Adena, Coins, Equip, write to us Discord - pchelacoin Telegram - https://t.me/ipchelacoin BOHPTS, KETRAWARS, EURO-PVP, L2REBORN, E-GLOBAL, LA2DREAM TOP PRICE !!!!!!!
    • L2Elixir – Patch 4 Is Live!   We’re working non-stop, day and night, to deliver the best possible quality and bring back what made L2Elixir special. This project is built with passion, not shortcuts — for the old-school players who remember, and the new ones who want to experience it properly. Thank you for being part of the journey. Together, we’re making L2Elixir great again ❤️ The legends never fade.    ⚙️ General Enabled Class Change service (same class type only) ALT + B → Services → Character Development Enabled Shift + Click on Treasure Chests Players can now identify real chests (Adena, scroll drops) and use Key / Unlock Event deaths now cancel only debuffs, All self buffs are preserved, fixes issues with Root and similar effects Bladedancer class can now log in even when Max Clients (2) is reached. Since an active Bladedancer is not available for every damage dealer and some players tried to abuse this via VPN or a second PC, this feature was added to keep things fair. protections applies, requires testing!    🎒 Items Crystallizing enchanted items now gives the correct increased crystal amount (retail-like behavior) Removed Agathion Seal Bracelet: Rudolph from Santa rewards (Gracia Final item) Added Dualsword Craft Stamp into Milestone Exchange list    🧙 Skills Fixed Banish Undead lethal chance Hot Springs Malaria and similar effects now level up faster while being attacked
    • thats new SEO level tricks you know nothing of noob - bottom line: exposed.
    • Warning: This guy is a big scammer, trying to sell everything, advertising for servers etc. That's his mail address evgesha.nrnr@gmail.com , stay away!   @Atom @Celestine
  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock