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

    • titu08
      [L2J] L2 ROOSTERS ARGENTINA

      By titu08 · Posted

      📜 • Mass PVP – Craft – Progressive Server (ITEMS, ARMOR, WEAPONS, ETC) 🕹️ • Chronicles: Lineage 2 - Interlude (C6) 🛠️ • Retail status 🕒 • Server Time: GMT -3 🏙️ • Main Town: Giran ✨ • Teleportation for all Towns, Gk Global 🛡️ • NPC BUFFER - GMSHOP B-GRADE - DONATION SHOP - AUCTION MANAGER 🐉 • Epic Bosses: Chaotic Zones 🔁 • Protection respawn: 15 seconds ⏰ • Restart Server: 05:00 AM Today 💸 • RTM allowed between players (ask Staff if in doubt) 📊 SERVER RATES: • EXP: x8 • SP: x10 • Adena: x3 • Seal Stone: x3 • Drop: x3 • Spoil: x5 • Raid EXP/SP/Drop: x3 • Premium Rates: x2 🌐 Website: https://www.l2roosters.com 💬 Discord: https://discord.gg/cUyYXrfy 🔥 Join us now and forge your legacy at Roosters Gaming!
    • Kenthor
      Help me please 🥺

      By Kenthor · Posted

      Hello, lovely people, how are you? I just finished compiling the L2jFrozen project Rev: 1132 (very old). I don't mind it being too old, since the project is for me and my children. (LAN/Offline) it's not meant to be put online. I want to learn and give my children more comfort when playing. And for my part, I also experiment with the game. My problem is that I don't know much about the subject. I was able to make some basic configurations to my liking and that of my children, but it never compiles or anything like that... I would really need help from you, the community... I simply want to remove all subclass restrictions, remove the restriction on "Overlord, Warsmith, and Dark Elf subclasses with White Elves and vice versa." Thank you very much in advance! Greetings, community.
    • Noveria
      [L2PTS] Elmorelab

      By Noveria · Posted

      Warriors, prepare for a new era! We are pleased to announce that on July 12, with the morning restart, Airin will be updated to Chronicle 4: Scions of Destiny. - Open Beta Testing (OBT) will begin on July 9. Everyone will be able to test the update in advance, including class mechanics, quests, and new content. - The Clan Hall Auction will take place on July 13. We’ve also prepared a traditional bonus start - details will be shared in the coming days. The full list of changes is available in the official patch notes. Thank you for your support and participation in the project. See you in Chronicle 4! The game client download will be available soon.
    • tomlondon12
      ✅ Mass DM Panel | Instagram, Twitter, Telegram and Discord!

      By tomlondon12 · Posted

      We are taking new orders. Kindly DM us on Telegram!
    • 4Unknow
      L2JDev Rev 12 Source + Pack Free UPDATE NEW VERSION

      By 4Unknow · Posted

      This site offline.

  • 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