Jump to content
--> Place your ad text here <--
Get Free Banners - Giveaway MaxCheaters.com
We're Rebuilding – Join Our Staff Team

[SHARE] Hero status Script L2J

Strength
 Share

Recommended Posts

Meikis Newbie

Meikis

Posted
Posted

if (!($i%2)){ echo "<tr bgcolor='000000' align='center'>"};

 

I'm curious, how do you get the crests from the server?

 

I think its like in HTML cause crests are saving in your server folder or just make ftp share for this folder and use data from clandata table to get it in yur web.

  • 3 weeks later...
  • 2 weeks later...
  • 2 months later...
disorder25 Newbie

disorder25

Posted
Posted

Anybody fix this script yet. I have been looking for this for a long time but this one doesn't work. Something is wrong and the query from the script doesn't get anything from database and also no crests. Crest.php doesn't work idem.

Please if anybody have this working share it.

Thank you very much.

  • 1 month later...
MrChuky Newbie

MrChuky

Posted
Posted

Hi!

 

I think that this is the solution for "Warning: Invalid argument supplied for foreach()" error:

 

In heroes.php

 

FIND

 

 foreach($heroes_actuales as $hero) {

 

REPLACE FOR

 

 while ($hero = mysql_fetch_assoc($query))

  {

 

 

 

Complete fixed script:

 

<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 Heroes</b></td></tr>
   </table>
<?PHP
$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
$db_user = "USER"; //your sql username goes here
$db_pass = "PASS"; //your sql password goes here
$db_name = "l2jdb";    //your database name goes here
$db_serv = "localhost"; //the address of the database goes here
// db connection!
$db = mysql_connect ( $db_serv, $db_user, $db_pass ) or die ("Coudn't connect to [$db_serv]");
mysql_select_db ( $db_name );
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 = mysql_query("SELECT char_name,olympiad_nobles.class_id as 'class_id',clan_name as 'pname', ally_name as 'aname', clan_data.crest_id as 'pcrest',ally_crest_id as 'acrest',competitions_won as 'win_count'
FROM characters
LEFT JOIN clan_data ON clan_data.clan_Id = characters.clanId
INNER JOIN olympiad_nobles ON olympiad_nobles.charId = characters.charId
WHERE competitions_won > 0
ORDER BY class_id
");
$heroes_actuales = mysql_query($query);
if (sizeof($heroes_actuales) == 0) echo "No heroes 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>Clan</b></td>
 <td width='24%' align='left'><b>Alliance</b></td>
 <td width='4%' align='left'><b>Wins</b></td>
 </tr>
 ";
 $i=0;
 
 while ($hero = mysql_fetch_assoc($query))
  {
   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['class_id']]."</td>
   <td align='left'>
   ";
   if ($hero['pcrest'] != 0) echo "<img height='12' src='crest.php?clan_crest=".$hero['pcrest']."'> ";
   echo $hero['pname']."</td><td align='left'>";
   if ($hero['acrest'] != 0) echo "<img height='12' src='crest.php?ally_crest=".$hero['acrest']."'> ";
   echo $hero['aname']."</td><td align='left'>".$hero['win_count']."</td></tr>";
   $i++;
 }
 echo "</table>";
}
?>
 <body>
</html>

  • 2 weeks later...
EvE Newbie

EvE

Posted
Posted 

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\heroes.php on line 100

Please a mod close this topic.

disorder25 Newbie

disorder25

Posted
Posted

Now we need to fix the crest script. I have been looking to fix this for such a long time. Thank you very much for fixing the script. Please now try to make the crest.php to work with the code.

 

This one I found it say it is for L2j but is missing the connection and database section and  the query.

 

<?

if(!empty($_GET['clan_crest'])){
$name = 'Crest';
$crest = $_GET['clan_crest'];
}
else if(!empty($_GET['ally_crest'])){
$name = 'AllyCrest';
$crest = $_GET['ally_crest'];
}
else
die('No Crest!');

$file = fopen('ftp://localhost/'.$name.'_'.$crest.'.bmp', 'r'); //fopen($filename,'rb');
$dds = fread($file,4);
if ($dds!=='DDS ') die("Error: no hay imagen DDS");

//DDS header

$hdrSize = readInt($file);
$hdrFlags = readInt($file);
$imgHeight = readInt($file)-4;
$imgWidth = readInt($file);
$imgPitch = readShort($file);

//DXT1 header

fseek($file, 84);
$dxt1 = fread($file,4);
if ($dxt1!=='DXT1') die("Error: no es formato DX1");

//here we go

fseek($file, 128);
header ("Content-type: image/png");
$img=imagecreatetruecolor($imgWidth,$imgHeight); 
for ($y=-1; $y<$imgHeight/4; $y++)
{
 for ($x=0; $x<$imgWidth/4; $x++)
 {
   $color0_16 = readShort($file);
   $color1_16 = readShort($file);
   $r0 = ($color0_16 >> 11) << 3;
   $g0 = (($color0_16 >> 5) & 63) << 2;
   $b0 = ($color0_16 & 31) << 3;
   $r1 = ($color1_16 >> 11) << 3;
   $g1 = (($color1_16 >> 5) & 63) << 2;
   $b1 = ($color1_16 & 31) << 3;
   $color0_32 = imagecolorallocate($img,$r0,$g0,$b0);
   $color1_32 = imagecolorallocate($img,$r1,$g1,$b1);
   $color01_32 = imagecolorallocate($img,$r0/2+$r1/2,$g0/2+$g1/2,$b0/2+$b1/2);
   $black = imagecolorallocate($img,0,0,0);
   $data = readInt($file);
   for ($yy=0;$yy<4;$yy++)
   {
     for ($xx=0;$xx<4;$xx++)
     {
       $bb = $data & 3;
       $data = $data >> 2;
       switch ($bb)
       {
         case 0: $c = $color0_32; break;
         case 1: $c = $color1_32; break;
         case 2: $c = $color01_32; break;
         default: $c = $black; break;
       }
       imagesetpixel($img,$x*4+$xx,$y*4+$yy,$c);
     }
   }
 }
}

imagepng($img);


## Functions needed

function readInt($file)
{
 $b4 = ord(fgetc($file));
 $b3 = ord(fgetc($file));
 $b2 = ord(fgetc($file));
 $b1 = ord(fgetc($file));
 return ($b1<<24)|($b2<<16)|($b3<<8)|$b4;
}

function readShort($file)
{
$b2 = ord(fgetc($file));
 $b1 = ord(fgetc($file));
 return ($b1<<8)|$b2;
}
?>  

 

And here is the original but it is for L2OFF and need to be converted.

 

<?

$id = antiinjection($_GET['id']);
if(!$id) die("Error: No ID");

// db config
$CONFIG['worlddbname'] = "lin2world";           // Database Name
$CONFIG['dbaddress'] = "localhost";        // 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);

$query = "SELECT bitmap FROM Pledge_Crest WHERE crest_id = '$id'";
$result = mssql_query($query);
$clan_crest = mssql_fetch_array($result);
$rnd_file = tmpfile();
fwrite($rnd_file, $clan_crest['bitmap']);
fseek($rnd_file, 0);

$file = &$rnd_file; //fopen($filename,'rb');
$dds = fread($file,4);

if ($dds!=='DDS ') die("Error: no hay imagen DDS");

//DDS header
$hdrSize = readInt($file);
$hdrFlags = readInt($file);
$imgHeight = readInt($file)-4;
$imgWidth = readInt($file);
$imgPitch = readShort($file);

//DXT1 header

fseek($file, 84);

$dxt1 = fread($file,4);

if ($dxt1!=='DXT1') die("Error: no es formato DX1");

//here we go
fseek($file, 128);

header ("Content-type: image/png");
$img=imagecreatetruecolor($imgWidth,$imgHeight);

for ($y=-1; $y<$imgHeight/4; $y++)
{
  for ($x=0; $x<$imgWidth/4; $x++)
  {
    $color0_16 = readShort($file);
    $color1_16 = readShort($file);
    $r0 = ($color0_16 >> 11) << 3;
    $g0 = (($color0_16 >> 5) & 63) << 2;
    $b0 = ($color0_16 & 31) << 3;
    $r1 = ($color1_16 >> 11) << 3;
    $g1 = (($color1_16 >> 5) & 63) << 2;
    $b1 = ($color1_16 & 31) << 3;
    $color0_32 = imagecolorallocate($img,$r0,$g0,$b0);
    $color1_32 = imagecolorallocate($img,$r1,$g1,$b1);
    $color01_32 = imagecolorallocate($img,$r0/2+$r1/2,$g0/2+$g1/2,$b0/2+$b1/2);
    $black = imagecolorallocate($img,0,0,0);
    $data = readInt($file);
    for ($yy=0;$yy<4;$yy++)
    {
      for ($xx=0;$xx<4;$xx++)
      {
        $bb = $data & 3;
        $data = $data >> 2;
        switch ($bb)
        {
          case 0: $c = $color0_32; break;
          case 1: $c = $color1_32; break;
          case 2: $c = $color01_32; break;
          default: $c = $black; break;
        }
        imagesetpixel($img,$x*4+$xx,$y*4+$yy,$c);
      }
    }
  }
}

imagepng($img);




## Functions needed

function readInt($file)
{
  $b4 = ord(fgetc($file));
  $b3 = ord(fgetc($file));
  $b2 = ord(fgetc($file));
  $b1 = ord(fgetc($file));
  return ($b1<<24)|($b2<<16)|($b3<<Cool|$b4;
}

function readShort($file)
{
  $b2 = ord(fgetc($file));
  $b1 = ord(fgetc($file));
  return ($b1<<Cool|$b2;
}

?>

 

If anybody can convert it or do what it need to be done to make it work on L2j.

Thank you very much.

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.

×
 Share
Go to topic listing


  • Posts

    • Maxtor
      We're Rebuilding MaxCheaters – Join Our Staff Team

      By Maxtor · Posted

      A New Chapter Begins We're Rebuilding – Join Our Staff Team After many years of activity, growth, and challenges, it’s finally time for our community to restructure and move forward. We’re ready to turn a new page and evolve into something greater — but we can’t do it without the help of passionate and committed people. That’s why we’re now opening up staff applications for those who want to actively shape the future of our community. If you have the motivation, time, and patience to contribute to something meaningful, this is your chance to step in and make a real impact. What We're Looking For We’re building a fresh and dedicated team of individuals who are ready to support and grow this project. Open roles include: Moderators – to keep the forum clean, safe, and organized Gaming Moderators – to help manage gaming boards (e.g., Lineage, GTA FiveM) Content Creators – to post updates, guides, and articles Community Managers – to engage users and drive activity Technical Staff – for development, backend, and server work We’re not focusing only on Lineage anymore. Our vision is expanding to new areas — including GTA FiveM and other multiplayer games you might have expertise in. If you have a good idea, a server plan, or something new to suggest — we’re open to it. Now’s the time to bring it forward. Requirements We’re looking for individuals who have: A history of activity on the forum (preferred) Available time to contribute consistently A sense of teamwork and responsibility A genuine interest in gaming and community building If you're interested, just send a private message to me or Celestine. (or just reply here) Tell us a few things about yourself and how you’d like to contribute. Let’s bring this community back to life. Let’s rebuild something great — together.   M M G A 
    • protoftw
      Graphic/Html Designs - Protojah

      By protoftw · Posted

      L2 GLORY - BANNERS      
    • `Sanctus
      Valid Servers?

      By `Sanctus · Posted

      lucera2
    • Lineage2.Network
      [L2Java] Lineage2Network x30 - Start 2025.05.09

      By Lineage2.Network · Posted

      Lineage2Network - Interlude Reimagined   Embark on a revitalized journey through the classic Interlude era with Lineage2.Network. Our server is meticulously crafted by veteran players to deliver a seamless and engaging experience, blending the nostalgia of the Chaotic Chronicle with modern enhancements.     Server details   Chronicle: Interlude + Classic Rates: EXP x30 | Adena x10 | Drop x10 | Spoil x10     Server features   Daily Missions - complete special tasks for daily rewards Attendance Rewards - get rewards for online time Custom Events - TVT, DM, CTF NPC buffer duration - 2 hours   Mana Potions - restores 1000 MP, 10s cooldown Ring of Core additional stats: +1 STR Earring of Orfen additional stats: +1 INT Shadow Earring of Zaken - 7 days Shadow Ring of Queen Ant - 7 days   Max buff count - 24 (20 + 4 with Divine Inspiration) Noblesse, Heroic Valor, Flames of Invincibility and Celestial Shield don't take buff slot Reworked Cancel, Mage and Warrior Banes – removed buffs reappear after 30s Block Buffs - block all incoming buffs except from self/party Sweeper Festival added to Spoiler class   Subclass – retail or purchasable Noblesse – retail or purchasable up to Barakiel; collect 8 fragments for full staff 1st & 2nd class free, 3rd needs 700 Halisha Marks or is purchasable New Olympiad System: new stadiums with NPC buffer,  1 week period.     Key dates     Beta Launch: April 14, 2025 Official Launch: May 9, 2025     Check out full server details in our website And visit our discord   Join us and be part of community where classic gameplay meets innovative updates. Whether you're a solo adventurer or part of a formidable clan, Lineage2.Network offers a dynamic and balanced environment for all.  
    • Goddardd
      WTS/WTB L2REBORN

      By Goddardd · Posted

      Good day. Our game currency store is looking for suppliers of adena and items on a project such as L2REBORN x10. We also sell Epic jewelry and various items on this project L2REBORN x10. There are items and adena on L2REBORN x1. For all questions, write to us in discord - goddardshop

  • Topics

×
×
  • Create New...