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.



  • Posts

    • Okay I respect that but why is your other account banned?   I don't think this happened just because you delayed somebodys work even in 2012
    • Do You understand the fact, I won't scam anyone? Can You grasp such idea?  Second of all, if a random restaurant on Google Maps has 599 positive reviews and few negative ones with 4,8* score, do You ask Google to block it's profile and burn the place down? No? Then why the fuck You are crying about my random delays? If someone can't get a CUSTOM DESIGN on time, I refund. I'm not 16  y.o. anymore. I don't make living out of this L2 bullshit. Never did. Since 2012 I've made shit tons of projects. How many delays did I have? 12? 15? Out of hundrets of projects. Calm Your tits please. If I would actually take 4k euro and NOT deliver and NOT refund - admins can ban me. So don't compare me to Simple. And just so You know, Celestine sent me customers, so it's not like I've worked with him on his account all the time. That's another thing You won't understand. I won't waste anymore time on You and any other cunt who never was my customer but is bitching just because he has nothing better to do in his life. You don't like my work? Hove along, I don't give a shit. 
    • So he's like unsimple you would say? Cherry picking who's getting scammed.   Deliver 5 projects, don't deliver/delay the other 2 projects. Of course he won't scam you because he know what's gonna happen after since he's dealing with the admin himself.
    • I've worked with Ave a lot lately on designs and other projects. He has always delivered as quickly as possible sometimes within a week, maybe two. Personally, I’m patient, so I’ve never had an issue with the wait. I’m not trying to defend him blindly, but I genuinely don’t believe he would mess someone over for €60 €100. Sometimes he's inactive, likely due to real life responsibilities, but I don't judge everyone has their own situations. I understand that some people are impatient and want their orders completed quickly, but considering the quality of his work, I have no problem waiting. Of course, people react differently to delays, and that’s fair. But in my experience, I can't call him a scammer he's always delivered what I ordered.
  • Topics

×
×
  • Create New...