Code Website Scripts Top 50 Pvp And Top 50 Pk.

[GODLike™]

Hello dear members, here is one more iseful share.
Do you want, your top pvp/pk players visible to your website?
Here we go:

TOP-PK CODE:
 

<table width="250px;">
<?php
	$connection = mysql_connect("SERVER IP", "MYSQL USER", "MYSQL PASSWORD") or die("Connection isn't available!");
	mysql_select_db("MYSQL DB", $connection) or die("Database isn't available!");
	
	
	$q = mysql_query("SELECT * FROM characters WHERE pkkills > 0 AND accesslevel = 0 ORDER BY pkkills DESC LIMIT 50");
	$i = 1;
	if ($q) {
		while ($char = mysql_fetch_array($q))
		{
			echo "<tr>";
			echo "<td style='width:11px;color:#000;'>" . $i . ".</td>";
			echo "<td style='width:20px;color:#000;'>" . $char['char_name'] . "</td>";
			echo "<td style='width:20px;text-align:right;padding-left:22px;color:#000;'>" . $char['pkkills'] . "</td>";
			echo "</tr>";
			$i++;
		}
	}
?>

TOP-PVP CODE:

<table width="250px;">
<?php
	$connection = mysql_connect("SERVER IP", "MYSQL USER", "MYSQL PASSWORD") or die("Connection isn't available!");
	mysql_select_db("MYSQL DATABASE", $connection) or die("Database isn't available!");
	
	
	$q = mysql_query("SELECT * FROM characters WHERE pvpkills > 0 AND accesslevel = 0 ORDER BY pvpkills DESC LIMIT 50");
	$i = 1;
	if ($q) {
		while ($char = mysql_fetch_array($q))
		{
			echo "<tr>";
			echo "<td style='width:11px;color:#000;'>" . $i . ".</td>";
			echo "<td style='width:20px;color:#000;'>" . $char['char_name'] . "</td>";
			echo "<td style='width:20px;text-align:right;padding-left:22px;color:#000;'>" . $char['pvpkills'] . "</td>";
			echo "</tr>";
			$i++;
		}
	}
?>

Credits: GODLike.

-See you on Next SHARE!

[Destorion]

This one is usefull to use it to my own Upcoming server's website. Thanks a lot bud!

[GODLike™]

This one is usefull to use it to my own Upcoming server's website. Thanks a lot bud!

No proble, i can code any script for your website! :)

[Tessa]

Why not mysqli instead of mysql?

[Nightw0lf]

you can use SELECT name,pvp instead of SELECT *

Edited February 10, 2015 by Nightw0lf

[Lioy]

Why not mysqli instead of mysql?

true.. who uses mysql_connect nowdays? 

Or even better , PDO.

[SweeTs]

you can use SELECT name,pvp instead of SELECT *

I guess he even should do like that, since * takes all info.

[Nightw0lf]

btw to escape injections I would recommend to use prepared statements just to be sure.

[FirefoxAurora]

Hello dear members, here is one more iseful share.

Do you want, your top pvp/pk players visible to your website?

Here we go:

 

TOP-PK CODE:

 

<table width="250px;">
<?php
	$connection = mysql_connect("SERVER IP", "MYSQL USER", "MYSQL PASSWORD") or die("Connection isn't available!");
	mysql_select_db("MYSQL DB", $connection) or die("Database isn't available!");
	
	
	$q = mysql_query("SELECT * FROM characters WHERE pkkills > 0 AND accesslevel = 0 ORDER BY pkkills DESC LIMIT 50");
	$i = 1;
	if ($q) {
		while ($char = mysql_fetch_array($q))
		{
			echo "<tr>";
			echo "<td style='width:11px;color:#000;'>" . $i . ".</td>";
			echo "<td style='width:20px;color:#000;'>" . $char['char_name'] . "</td>";
			echo "<td style='width:20px;text-align:right;padding-left:22px;color:#000;'>" . $char['pkkills'] . "</td>";
			echo "</tr>";
			$i++;
		}
	}
?>

TOP-PVP CODE:

<table width="250px;">
<?php
	$connection = mysql_connect("SERVER IP", "MYSQL USER", "MYSQL PASSWORD") or die("Connection isn't available!");
	mysql_select_db("MYSQL DATABASE", $connection) or die("Database isn't available!");
	
	
	$q = mysql_query("SELECT * FROM characters WHERE pvpkills > 0 AND accesslevel = 0 ORDER BY pvpkills DESC LIMIT 50");
	$i = 1;
	if ($q) {
		while ($char = mysql_fetch_array($q))
		{
			echo "<tr>";
			echo "<td style='width:11px;color:#000;'>" . $i . ".</td>";
			echo "<td style='width:20px;color:#000;'>" . $char['char_name'] . "</td>";
			echo "<td style='width:20px;text-align:right;padding-left:22px;color:#000;'>" . $char['pvpkills'] . "</td>";
			echo "</tr>";
			$i++;
		}
	}
?>

Credits: GODLike.

 

-See you on Next SHARE!

Put proper credits....

[Snoopi]

if($q) is useless there