Jump to content
MaxCheaters Official Group on X
MaxCheaters Official Group on Discord
--> Place your ad text here <--

[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
×
×
  • Create New...