Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing

[Share] New PvP/PK Top list script (PHP) with clan&ally crests

MrChuky
 Share

Recommended Posts

MrChuky Newbie

MrChuky

Posted
Posted

Hi!

 

This is two scripts thats I use in my web for some time.

 

Now I want to share with all you  ::)

 

 

It shows something like:

1   PlayerName  (ClanCrest)ClanName  (AllyCrest)AllyName  PvP or PK Number

2   PlayerName  (ClanCrest)ClanName  (AllyCrest)AllyName  PvP or PK Number

...

 

 

First this is the crest.php

 

(If you get any error with this file, please, consult this post: http://www.maxcheaters.com/forum/index.php?topic=99196.msg1072861#msg1072861)

 

<?


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('/home/admin/gameserver/data/crests/'.$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;

}


?>

 

This is the connection.php file:

 

<?php
$db_user = "USER";
$db_pass = "PASS";
$db_name = "l2jdb";
$db_serv = "localhost";
$db_port = "3306";
$res = mysql_connect ( $db_serv, $db_user, $db_pass, $db_port ) or die ("Coudn't connect to [$db_serv]");
mysql_select_db ( $db_name );
?>

 

Pkkills.php

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<style type="text/css">
<!--
body,td,th {
color: #CCCCCC;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
body {
background-color: #000000;
}
-->
</style>
</head>
<body>
<table style="border: 1px solid; border-color: #444444; background-color:#222222;" align="center" width="100%">
  <tr>
    <th class='Stil7' colspan="5">Top 100 PK</th>
  </tr>
  <tr>
    <th width="5%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Rank </th>
    <th width="35%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Name </th>
    <th width="19%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Clan </th>
    <th width="19%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Ally </th>
    <th width="20%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> PK's </th>
  </tr>

  <?php 
require("Connection.php");
$activity = mysql_query("SELECT char_name,pkkills,clan_name as 'pname', ally_name as 'aname', clanid, clan_data.crest_id as 'pcrest', ally_crest_id as 'acrest' FROM characters LEFT JOIN clan_data ON clan_data.clan_Id = characters.clanId Where ((pkkills >=1) AND (accesslevel = 0)) ORDER BY pkkills DESC, char_name ASC limit 100");
$i = 1;

while($row = mysql_fetch_array($activity))

{
	if (!($i%2)) echo "<tr bgcolor='#000000' align='center'>";
	else
	echo "<tr bgcolor='#161616' align='center'>";
	echo "<td>"."<center>".$i."</center>"."</td>";
	echo "<td>"."<center>".$row['char_name']."</center>"."</td>";
	echo "<td align='left'>";
	    if ($row['pcrest'] != 0) echo "<img src='crest.php?clan_crest=".$row['pcrest']."'/> ".$row['pname']."";
	echo "</td>";
	echo "<td align='left'>";
	    if ($row['acrest'] != 0) echo "<img src='crest.php?ally_crest=".$row['acrest']."'/> ".$row['aname']."";
	echo "</td>";
	echo "<td>"."<center>".$row['pkkills']."</center>"."</td>";
	$i++;
}
?>
</table>
</body>
</html>

 

PvPKills.php

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<style type="text/css">
<!--
body,td,th {
color: #CCCCCC;
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
body {
background-color: #000000;
}
-->
</style>
<body>
<table style="border: 1px solid; border-color: #444444; background-color:#222222;" align="center" width="100%">
  <tr>
    <th class='Stil7' colspan="5">Top 100 PvP</th>
  </tr>
  <tr>
    <th width="5%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Rank </th>
    <th width="35%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Nombre </th>
    <th width="19%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Clan</th>
    <th width="19%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> Ally</th>
    <th width="20%" style="border: 1px solid; border-color: #444444; background-color:#222222;"> PvP's </th>
  </tr>
  <?php 
require("Connection.php");
$activity = mysql_query("SELECT char_name,pvpkills,clan_name as 'pname', ally_name as 'aname', clan_data.crest_id as 'pcrest', ally_crest_id as 'acrest' FROM characters LEFT JOIN clan_data ON clan_data.clan_Id = characters.clanId Where ((pvpkills >=1) AND (accesslevel = 0)) ORDER BY pvpkills DESC, char_name ASC limit 100");
$i = 1;
while($row = mysql_fetch_array($activity))
{
	    if (!($i%2)) echo "<tr bgcolor='#000000' align='center'>";
else
echo "<tr bgcolor='#161616' align='center'>";
	echo "<td>"."<center>".$i."</center>"."</td>";
	echo "<td>"."<center>".$row['char_name']."</center>"."</td>";
	echo "<td align='left'>";
	    if ($row['pcrest'] != 0) echo "<img src='crest.php?clan_crest=".$row['pcrest']."'/> ".$row['pname']."";
	echo "</td>";
	echo "<td align='left'>";
	    if ($row['acrest'] != 0) echo "<img src='crest.php?ally_crest=".$row['acrest']."'/> ".$row['aname']."";
	echo "</td>";
	echo "<td>"."<center>".$row['pvpkills']."</center>"."</td>";
	$i++;
}
?>
</table>
</body>
</html>

  • 2 weeks later...
LeafaR Newbie

LeafaR

Posted
Posted

I made the JSP one ;)

 

<%@ page import="java.awt.*" %>
<%@ page import="java.awt.image.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="javax.imageio.*" %>
<%!

public int readInt(RandomAccessFile ra)
throws IOException
{
int b4 = (int) ra.read();
int b3 = (int) ra.read();
int b2 = (int) ra.read();
int b1 = (int) ra.read();
return (b1 << 24) | (b2 << 16) | (b3 << 8) | b4;
}

public int readShort(RandomAccessFile ra)
throws IOException
{
int b2 = (int) ra.read();
int b1 = (int) ra.read();
return ((b1 << 8) | b2);
}

%>

<%
File file = new File("Crest_268619650.bmp");
//File file = new File("Crest_268607245.bmp");
RandomAccessFile ra = new RandomAccessFile(file, "r");
byte[] content = new byte[4];
ra.read(content, 0, 4);

String ddsSTR = new String(content);
if (ddsSTR.intern() != "DDS ")
{
out.print("Error, NO DDS");
return;
}

readInt(ra); //int size = readInt(ra);
readInt(ra); //int flags = readInt(ra);
int height = readInt(ra) - 4;
int width = readInt(ra);
readShort(ra); //int extra = readShort(ra);

ra.seek(84);

int dxt1 = ra.read(content, 0, 4);
String dxt1STR = new String(content);
if (dxt1STR.intern() != "DXT1")
{
out.print("Error, NO DXT1");
return;
}

ra.seek(128);

response.setContentType("image/png");
BufferedImage buffer = new BufferedImage(width, height, BufferedImage.TYPE_INT_RGB);
for (int y = -1; y < (height / 4); y++)
{
for (int x = 0; x < (width / 4); x++)
{
	int color0_16 = readShort(ra);
	int color1_16 = readShort(ra);
	int r0 = (color0_16 >> 11) << 3;
	int g0 = ((color0_16 >> 5) & 63) << 2;
	int b0 = (color0_16 & 31) << 3;
	int r1 = (color1_16 >> 11) << 3;
	int g1 = ((color1_16 >> 5) & 63) << 2;
	int b1 = (color1_16 & 31) << 3;
	int color0_32 = new Color(r0, g0, b0).getRGB();
	int color1_32 = new Color(r1, g1, b1).getRGB();
	int color2_32 = new Color((r0 / 2) + (r1 / 2), (g0 / 2) + (g1 / 2), (b0 / 2) + (b1 / 2)).getRGB();
	int black = new Color(0, 0, 0).getRGB();
	int data = readInt(ra);

	for (int yy = 0; yy < 4; yy++)
	{
		for (int xx = 0; xx < 4; xx++)
		{
			int bb = data & 3;
			data = data >> 2;
			int color = 0;
			switch(bb)
			{
				case 0:
					color = color0_32;
					break;
				case 1:
					color = color1_32;
					break;
				case 2:
					color = color2_32;
					break;
				default:
					color = black;
					break;
			}
			int locX = x * 4 + xx;
			int locY = y * 4 + yy;
			buffer.setRGB(Math.abs(locX), Math.abs(locY), color);
		}
	}
}
}

OutputStream os = response.getOutputStream();
ImageIO.write(buffer, "png", os);

%>

  • 2 months later...
M4GNUM Newbie

M4GNUM

Posted
Posted

I made the JSP one ;)

 

<%@ page import="java.awt.*" %>
<%@ page import="java.awt.image.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="javax.imageio.*" %>
<%!

public int readInt(RandomAccessFile ra)
throws IOException
{
int b4 = (int) ra.read();
int b3 = (int) ra.read();
int b2 = (int) ra.read();
int b1 = (int) ra.read();
return (b1 << 24) | (b2 << 16) | (b3 << 8) | b4;
}

public int readShort(RandomAccessFile ra)
throws IOException
{
int b2 = (int) ra.read();
int b1 = (int) ra.read();
return ((b1 << 8) | b2);
}

%>

<%
File file = new File("Crest_268619650.bmp");
//File file = new File("Crest_268607245.bmp");
RandomAccessFile ra = new RandomAccessFile(file, "r");
byte[] content = new byte[4];
ra.read(content, 0, 4);

String ddsSTR = new String(content);
if (ddsSTR.intern() != "DDS ")
{
out.print("Error, NO DDS");
return;
}

readInt(ra); //int size = readInt(ra);
readInt(ra); //int flags = readInt(ra);
int height = readInt(ra) - 4;
int width = readInt(ra);
readShort(ra); //int extra = readShort(ra);

ra.seek(84);

int dxt1 = ra.read(content, 0, 4);
String dxt1STR = new String(content);
if (dxt1STR.intern() != "DXT1")
{
out.print("Error, NO DXT1");
return;
}

ra.seek(128);

response.setContentType("image/png");
BufferedImage buffer = new BufferedImage(width, height, BufferedImage.TYPE_INT_RGB);
for (int y = -1; y < (height / 4); y++)
{
for (int x = 0; x < (width / 4); x++)
{
	int color0_16 = readShort(ra);
	int color1_16 = readShort(ra);
	int r0 = (color0_16 >> 11) << 3;
	int g0 = ((color0_16 >> 5) & 63) << 2;
	int b0 = (color0_16 & 31) << 3;
	int r1 = (color1_16 >> 11) << 3;
	int g1 = ((color1_16 >> 5) & 63) << 2;
	int b1 = (color1_16 & 31) << 3;
	int color0_32 = new Color(r0, g0, b0).getRGB();
	int color1_32 = new Color(r1, g1, b1).getRGB();
	int color2_32 = new Color((r0 / 2) + (r1 / 2), (g0 / 2) + (g1 / 2), (b0 / 2) + (b1 / 2)).getRGB();
	int black = new Color(0, 0, 0).getRGB();
	int data = readInt(ra);

	for (int yy = 0; yy < 4; yy++)
	{
		for (int xx = 0; xx < 4; xx++)
		{
			int bb = data & 3;
			data = data >> 2;
			int color = 0;
			switch(bb)
			{
				case 0:
					color = color0_32;
					break;
				case 1:
					color = color1_32;
					break;
				case 2:
					color = color2_32;
					break;
				default:
					color = black;
					break;
			}
			int locX = x * 4 + xx;
			int locY = y * 4 + yy;
			buffer.setRGB(Math.abs(locX), Math.abs(locY), color);
		}
	}
}
}

OutputStream os = response.getOutputStream();
ImageIO.write(buffer, "png", os);

%>

for what is this?

 

And, mrchucky can you put a class info from characteres and make a file for heroes too?

 

thx guy!

  • 3 weeks later...
  • 2 weeks later...
  • 2 months later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing


  • Posts

    • rlfem123
      What is a CMS and why there is no good one on the market?

      By rlfem123 · Posted

      We all know the CMS platforms that make us wonder every day why nothing truly new comes to the market. The answer seems simple: monopoly. And yes, to some extent that's true. But most people don't stop to think why they became monopolies in the first place.   It's largely a legacy trend that started back when PHP was supposed to "change the world." Well, here we are - and it didn't. PHP is increasingly becoming a technology many of us want to move away from rather than integrate into modern projects.   This is the 21st century. JavaScript powers the internet. With JavaScript, we can build the frontend, the backend, modules, run parallel processing with Workers, integrate seamlessly with cloud providers, and scale without friction. It has the largest open-source community in the world. The ecosystem is massive. What has been missing, however, is a truly powerful CMS written entirely in JavaScript.   The good news? I’ve been working on such a project for years, and I believe the time is coming to move into a beta testing phase. If anyone is interested in joining the testing phase and providing feedback, I would be happy to connect. I would also genuinely love to hear your opinion about a product like this.   Imagine a CMS with: A built-in builder Ready-to-use plugins A JavaScript-first architecture Designed primarily for online services   Because most CMS platforms today focus heavily on becoming eCommerce systems for selling physical products, and in doing so, they lose sight of a huge audience. There are countless people who want to build: Paid online services Digital or hand-crafted product platforms Gaming websites Coffee shop websites Subscription-based platforms And many other service-oriented projects What do you think about a CMS built specifically for the service economy rather than traditional eCommerce?
    • GX-Ext
      🔥 L2Ext Custom Interlude VANG – 2026 Release

      By GX-Ext · Posted

      You keep talking a lot but you still haven't proven anything... why don't you show the community that this extender doesn't work? Why don't you show them all the bugs? hahaha Your silence and lack of evidence prove that you're a liar trying to make a quick buck selling what I publish for free.   Why do you want a domain? You say this extender crashes? Well, prove it, so everyone can see if you're right. Or if you simply want to convince people not to use this extender for free, why do you want to sell it?
    • VPSLab
      — VPSLAB — Fast & Private RDP/VPS | 100% Instant Setup

      By VPSLab · Posted

      Active & Taking Orders!
    • L2Gold.eu
      🔥 L2Ext Custom Interlude VANG – 2026 Release

      By L2Gold.eu · Posted

      Send me your server domain. As far as i know, you don’t have any money where are you going to get 1k from? 🙂 Even if they ban you, you will just come back with 4–5 accounts like always. You are still the same idiot. What was that server with the crash L2Galaxy or something like that?  
    • Litch
      FUCK ACTIVE ANTI CHEAT

      By Litch · Posted

      Adrenaline Premium and other private bots continue to function normally. XD

  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..