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

MrChuky · May 26, 2010

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>

Onix · May 26, 2010

awesome share and very good job, of course i will test it soon !

thanks for it ;)

disorder25 · May 27, 2010

Dude this is so nice I wanted the Hero code like this and now I got hero, pvp and pk all with the crests. Great Job.

It is working perfectly.

Thank you so much.

MrChuky · May 31, 2010

Fixed for IE, now prevents "broken images" if there is no clan.

(First post updated)

`RoSe^ · May 31, 2010

i test it soon =] Great Share keep up

MasterDisaster · May 31, 2010

Nice share mate.Any live preview?S:

disorder25 · May 31, 2010

Thank you for fixing and reshare it mate. Excellent job.

Spidey* · May 31, 2010

Oh wonderful script, i copy it right now!!

LeafaR · June 12, 2010

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);

%>

M4GNUM · September 6, 2010

On 6/12/2010 at 11:20 PM, LeafaR said:

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!

SoRa · September 6, 2010

I'm looking for some good PVP/PK script and this is awesome,ty for this great share man. :)

kuba90 · September 6, 2010

Hmm, the image decompression is a bit heavy isnt it ? That thing is run for every crest.

Magaiveris · September 27, 2010

I will test it =)

If really successful working big thanks to YOU ;)

repxl · October 10, 2010

how it will look when i no need the crest showing ?? becuase i have my web not on local machine so no crest view

Xpectrus · January 6, 2011

voy a probarlos en mi server, gracias

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

Recommended Posts

MrChuky

Onix

disorder25

MrChuky

`RoSe^

MasterDisaster

disorder25

Spidey*

LeafaR

M4GNUM

SoRa

kuba90

Magaiveris

repxl

Xpectrus

Join the conversation

Posts

Topics

Browse

Activity

Store