[Share] Current Heros website script - OFF

GoDofAdeN · June 11, 2009

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 · June 12, 2009

.html or .php ?

GoDofAdeN · June 13, 2009

Its PhP ofc !

CriticalError · June 24, 2009

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

*SlimShadow*^ · July 29, 2009

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

disorder25 · August 30, 2009

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 · August 30, 2009

here it is an l2off section mate :)

that's why the script doesn't work

in l2j section similar scripts exist

daredevil911 · August 31, 2009

this is cool i will put in my site

disorder25 · September 2, 2009

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 · September 2, 2009

great share man. it also looks very nice.

Bruj4h · September 14, 2009

Nice work and ty for sharing!!

maxicroma · September 18, 2009

good share thx :D

zconll · September 19, 2009

Thanks, i was looking for this script.

Strength · November 3, 2009

CONVERTED TO L2J ->

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

The_Shaft · November 13, 2010

thx Strength I will try it

[Share] Current Heros website script - OFF

Recommended Posts

GoDofAdeN

Dr.Metall

GoDofAdeN

CriticalError

SlimShadow^

disorder25

MaestroLuke

daredevil911

disorder25

pintados

Bruj4h

maxicroma

zconll

Strength

The_Shaft

Create an account or sign in to comment

Create an account

Sign in

Posts

Topics

Browse

Activity

Store

Important Information