Ranks Script Help

09/18/2016 23:43 shaiyapvpserver#1

Hello friends
Is there a ready script ranks as the picture

How can I add the name of the union or association where it says

Thank you

[Only registered and activated users can see links. Click Here To Register...]

09/19/2016 17:32 [ADM]_Dephisio#2

In this database: PS_GameData
You have to looking for dbo.Guild if i'm not wrong
Tell me if it is the answer you expected :)

09/19/2016 19:18 shaiyapvpserver#3

$faction=0;
if((isset($_GET['class'])) && (!empty($_GET['class']))) {
// si la classe est choisie
$job=$_GET['class'];
if($job == 6) {
$job=0;
echo "<center><table border=\"1\" width=\"620\">";
echo "<tr><th colspan=\"4\"><center>Işık İttifakı - Cengaver İnfaz Listesi</th></tr>";
echo "<tr><th><center>Sıra</center></th><th><center>İsmi </center></th><th><center>Seviye</center></th><th><center>İnfaz</center></th><th><center>GUILD</center></th></tr>";
$selecteverything=$conn->prepare('SELECT TOP 30 c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
WHERE c.Del=0 AND d.Status=0 AND e.Country=:country AND c.Job=:job ORDER BY c.K1 DESC, c.K2 ASC, c.CharName ASC');
if($selecteverything == false) {
echo "Error in preparing the select query.<br />";
die(FormatErrors($conn->errorInfo()));
} else {
$selecteverything->bindParam(':country', $faction, PDO::PARAM_INT);
$selecteverything->bindParam(':job', $job, PDO::PARAM_INT);
if($selecteverything->execute() == false) {
echo "Error while executing query to select the ranked chars.<br />";
die(FormatErrors($selecteverything->errorInfo()));
} else {
$begin=1;
for ($i=1; $char=$selecteverything->fetch(PDO::FETCH_ASSOC); $i++) {
if($i >= $begin) {
echo "<tr><td style=\"color:white\" bgcolor=\"black\"><center>".$i."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['CharName']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['Level']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['K1']."</center></td><td style=\"color:white\" bgcolor=\"black\">Guild Name</center></td></tr>";
}
}
}
}
}

where code will be written
Thank you

09/19/2016 20:31 [ADM]_Dephisio#4

I don't understand what you're looking for,explain precisely pls

09/20/2016 01:37 [DEV]Arkham#5

Quote:

Originally Posted by shaiyapvpserver

Spoiler

$faction=0;
if((isset($_GET['class'])) && (!empty($_GET['class']))) {
// si la classe est choisie
$job=$_GET['class'];
if($job == 6) {
$job=0;
echo "<center><table border=\"1\" width=\"620\">";
echo "<tr><th colspan=\"4\"><center>Işık İttifakı - Cengaver İnfaz Listesi</th></tr>";
echo "<tr><th><center>Sıra</center></th><th><center>İsmi </center></th><th><center>Seviye</center></th><th><center>İnfaz</center></th><th><center>GUILD</center></th></tr>";
$selecteverything=$conn->prepare('SELECT TOP 30 c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
WHERE c.Del=0 AND d.Status=0 AND e.Country=:country AND c.Job=:job ORDER BY c.K1 DESC, c.K2 ASC, c.CharName ASC');
if($selecteverything == false) {
echo "Error in preparing the select query.<br />";
die(FormatErrors($conn->errorInfo()));
} else {
$selecteverything->bindParam(':country', $faction, PDO::PARAM_INT);
$selecteverything->bindParam(':job', $job, PDO::PARAM_INT);
if($selecteverything->execute() == false) {
echo "Error while executing query to select the ranked chars.<br />";
die(FormatErrors($selecteverything->errorInfo()));
} else {
$begin=1;
for ($i=1; $char=$selecteverything->fetch(PDO::FETCH_ASSOC); $i++) {
if($i >= $begin) {
echo "<tr><td style=\"color:white\" bgcolor=\"black\"><center>".$i."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['CharName']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['Level']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['K1']."</center></td><td style=\"color:white\" bgcolor=\"black\">Guild Name</center></td></tr>";
}
}
}
}
}

where code will be written
Thank you

Can you Send all scripts ?
Or try to use it

Spoiler

enter it on to $faction=0; and replace it

PHP Code:


			
echo "<tr><td style=\"color:white\" bgcolor=\"black\"><center>".$i."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['CharName']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['Level']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['K1']."</center></td><td style=\"color:white\" bgcolor=\"black\">Guild Name</center></td></tr>";

TO:

PHP Code:


			
echo "<tr><td style=\"color:white\" bgcolor=\"black\"><center>".$i."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['CharName']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['Level']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['K1']."</center></td><td style=\"color:white\" bgcolor=\"black\">".$guild."</center></td></tr>";

09/20/2016 14:23 shaiyapvpserver#6

Spoiler

All codes here i cant add guild thank u for helping

09/20/2016 20:50 [DEV]Arkham#7

Quote:

Originally Posted by shaiyapvpserver

Spoiler

<!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" />
<title>PvP</title>
<link rel="icon" href="./favicon.ico" type="image/x-icon">
<link href="./style.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" type="text/css" href="./contentslider.css" />
<script type="text/javascript" src="./contentslider.js">
</script>
</head>
<body>
<script language="javascript"
type="text/javascript"
src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js">

</script>

<script type="text/javascript" language="javascript">

$(function() {

$(this).bind("contextmenu", function(e) {

e.preventDefault();

});

});
</script>

<div class="templatemo_post">

<div class="post_body">
<?
$page=$_SERVER['PHP_SELF'];
$dbhost='127.0.0.1';
$dbuser='Shaiya';
$dbpass='Shaiya123';
$dbname='PS_UserData';
function FormatErrors($error){
// Display errors.
echo "Error information: <br/>";
echo "SQLSTATE: ".$error[0]."<br/>";
echo "Code: ".$error[1]."<br/>";
echo "Message: ".$error[2]."<br/><br/>";
}
try {
$conn= new PDO("mssql:Server=$dbhost;Database=$dbname", $dbuser, $dbpass);
}
catch (PDOException $e) {
die("Failed to connect to database.");
}
echo "<center><a href=\"".$page."?faction=2&class=6\"><img src=\"./ranking_images/Alliance-of-Light1.jpg\"></a>      <a href=\"".$page."?faction=1&class=6\"><img src=\"./ranking_images/Union-of-Fury1.jpg\"></a></center>";
if ((isset($_GET['faction'])) && (!empty($_GET['faction']))) {
$selecteverything=$conn->prepare('SELECT TOP 30 c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
WHERE c.Del=0 AND d.Status=0 AND e.Country=:country AND c.Job=:job ORDER BY c.K1, c.K2, c.CharName DESC');
if($selecteverything == false) {
echo "Error in preparing the select query.<br />";
die(FormatErrors($conn->errorInfo()));
} else {
if ($_GET['faction'] == 2) {
//light
echo "<center><a href=\"".$page."?faction=2&class=6\"><img src=\"./ranking_images/Fighter.jpg\"></a>    
<a href=\"".$page."?faction=2&class=1\"><img src=\"./ranking_images/Defender.jpg\"></a>    
<a href=\"".$page."?faction=2&class=2\"><img src=\"./ranking_images/Ranger.jpg\"></a>    
<a href=\"".$page."?faction=2&class=3\"><img src=\"./ranking_images/Archer.jpg\"></a>    
<a href=\"".$page."?faction=2&class=4\"><img src=\"./ranking_images/Mage.jpg\"></a>    
<a href=\"".$page."?faction=2&class=5\"><img src=\"./ranking_images/Priest.jpg\"></a>";
$faction=0;
if((isset($_GET['class'])) && (!empty($_GET['class']))) {
// si la classe est choisie
$job=$_GET['class'];
if($job == 6) {
$job=0;
echo "<center><table border=\"1\" width=\"620\">";
echo "<tr><th colspan=\"4\"><center>Işık İttifakı - Cengaver İnfaz Listesi</th></tr>";
echo "<tr><th><center>Sıra</center></th><th><center>İsmi </center></th><th><center>Seviye</center></th><th><center>İnfaz</center></th><th><center>GUILD</center></th></tr>";
$selecteverything=$conn->prepare('SELECT TOP 30 c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
WHERE c.Del=0 AND d.Status=0 AND e.Country=:country AND c.Job=:job ORDER BY c.K1 DESC, c.K2 ASC, c.CharName ASC');
if($selecteverything == false) {
echo "Error in preparing the select query.<br />";
die(FormatErrors($conn->errorInfo()));
} else {
$selecteverything->bindParam(':country', $faction, PDO::PARAM_INT);
$selecteverything->bindParam(':job', $job, PDO::PARAM_INT);
if($selecteverything->execute() == false) {
echo "Error while executing query to select the ranked chars.<br />";
die(FormatErrors($selecteverything->errorInfo()));
} else {
$begin=1;
for ($i=1; $char=$selecteverything->fetch(PDO::FETCH_ASSOC); $i++) {
if($i >= $begin) {
echo "<tr><td style=\"color:white\" bgcolor=\"black\"><center>".$i."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['CharName']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['Level']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['K1']."</center></td><td style=\"color:white\" bgcolor=\"black\">Guild Name</center></td></tr>";
}
}
}
}
} elseif ($job == 1) {
echo "<center><table border=\"1\" width=\"520\">";
echo "<tr><th colspan=\"4\"><center>Işık İttifakı - Muhafız İnfaz Listesi</th></tr>";
echo "<tr><th><center>Sıra</center></th><th><center>İsmi </center></th><th><center>Seviye</center></th><th><center>İnfaz</center></th></tr>";
$selecteverything=$conn->prepare('SELECT TOP 30 c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
WHERE c.Del=0 AND d.Status=0 AND e.Country=:country AND c.Job=:job ORDER BY c.K1 DESC, c.K2 ASC, c.CharName ASC');
if($selecteverything == false) {
echo "Error in preparing the select query.<br />";
die(FormatErrors($conn->errorInfo()));
} else {
$selecteverything->bindParam(':country', $faction, PDO::PARAM_INT);
$selecteverything->bindParam(':job', $job, PDO::PARAM_INT);
if($selecteverything->execute() == false) {
echo "Error while executing query to select the ranked chars.<br />";
die(FormatErrors($selecteverything->errorInfo()));
} else {
$begin=1;
for ($i=1; $char=$selecteverything->fetch(PDO::FETCH_ASSOC); $i++) {
if($i >= $begin) {
echo "<tr><td style=\"color:white\" bgcolor=\"black\"><center>".$i."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['CharName']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['Level']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['K1']."</center></td></tr>";
}
}
}
}
} elseif ($job == 2) {
echo "<center><table border=\"1\" width=\"520\">";
echo "<tr><th colspan=\"4\"><center>Işık İttifakı - Korucu İnfaz Listesi</th></tr>";
echo "<tr><th><center>Sıra</center></th><th><center>İsmi </center></th><th><center>Seviye</center></th><th><center>İnfaz</center></th></tr>";
$selecteverything=$conn->prepare('SELECT TOP 30 c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
WHERE c.Del=0 AND d.Status=0 AND e.Country=:country AND c.Job=:job ORDER BY c.K1 DESC, c.K2 ASC, c.CharName ASC');
if($selecteverything == false) {
echo "Error in preparing the select query.<br />";
die(FormatErrors($conn->errorInfo()));
} else {
$selecteverything->bindParam(':country', $faction, PDO::PARAM_INT);
$selecteverything->bindParam(':job', $job, PDO::PARAM_INT);
if($selecteverything->execute() == false) {
echo "Error while executing query to select the ranked chars.<br />";
die(FormatErrors($selecteverything->errorInfo()));
} else {
$begin=1;
for ($i=1; $char=$selecteverything->fetch(PDO::FETCH_ASSOC); $i++) {
if($i >= $begin) {
echo "<tr><td style=\"color:white\" bgcolor=\"black\"><center>".$i."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['CharName']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['Level']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['K1']."</center></td></tr>";
}
}
}
}
} elseif ($job == 3) {
echo "<center><table border=\"1\" width=\"520\">";
echo "<tr><th colspan=\"4\"><center>Işık İttifakı - Ok�u İnfaz Listesi</th></tr>";
echo "<tr><th><center>Sıra</center></th><th><center>İsmi </center></th><th><center>Seviye</center></th><th><center>İnfaz</center></th></tr>";
$selecteverything=$conn->prepare('SELECT TOP 30 c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
WHERE c.Del=0 AND d.Status=0 AND e.Country=:country AND c.Job=:job ORDER BY c.K1 DESC, c.K2 ASC, c.CharName ASC');
if($selecteverything == false) {
echo "Error in preparing the select query.<br />";
die(FormatErrors($conn->errorInfo()));
} else {
$selecteverything->bindParam(':country', $faction, PDO::PARAM_INT);
$selecteverything->bindParam(':job', $job, PDO::PARAM_INT);
if($selecteverything->execute() == false) {
echo "Error while executing query to select the ranked chars.<br />";
die(FormatErrors($selecteverything->errorInfo()));
} else {
$begin=1;
for ($i=1; $char=$selecteverything->fetch(PDO::FETCH_ASSOC); $i++) {
if($i >= $begin) {
echo "<tr><td style=\"color:white\" bgcolor=\"black\"><center>".$i."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['CharName']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['Level']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['K1']."</center></td></tr>";
}
}
}
}
} elseif ($job == 4) {
echo "<center><table border=\"1\" width=\"520\">";
echo "<tr><th colspan=\"4\"><center>Işık İttifakı - B�y�c� İnfaz Listesi</th></tr>";
echo "<tr><th><center>Sıra</center></th><th><center>İsmi </center></th><th><center>Seviye</center></th><th><center>İnfaz</center></th></tr>";
$selecteverything=$conn->prepare('SELECT TOP 30 c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
WHERE c.Del=0 AND d.Status=0 AND e.Country=:country AND c.Job=:job ORDER BY c.K1 DESC, c.K2 ASC, c.CharName ASC');
if($selecteverything == false) {
echo "Error in preparing the select query.<br />";
die(FormatErrors($conn->errorInfo()));
} else {
$selecteverything->bindParam(':country', $faction, PDO::PARAM_INT);
$selecteverything->bindParam(':job', $job, PDO::PARAM_INT);
if($selecteverything->execute() == false) {
echo "Error while executing query to select the ranked chars.<br />";
die(FormatErrors($selecteverything->errorInfo()));
} else {
$begin=1;
for ($i=1; $char=$selecteverything->fetch(PDO::FETCH_ASSOC); $i++) {
if($i >= $begin) {
echo "<tr><td style=\"color:white\" bgcolor=\"black\"><center>".$i."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['CharName']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['Level']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['K1']."</center></td></tr>";
}
}
}
}
} elseif ($job == 5) {
echo "<center><table border=\"1\" width=\"520\">";
echo "<tr><th colspan=\"4\"><center>Işık İttifakı - Rahip İnfaz Listesi</th></tr>";
echo "<tr><th><center>Sıra</center></th><th><center>İsmi </center></th><th><center>Seviye</center></th><th><center>İnfaz</center></th></tr>";
$selecteverything=$conn->prepare('SELECT TOP 30 c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
WHERE c.Del=0 AND d.Status=0 AND e.Country=:country AND c.Job=:job ORDER BY c.K1 DESC, c.K2 ASC, c.CharName ASC');
if($selecteverything == false) {
echo "Error in preparing the select query.<br />";
die(FormatErrors($conn->errorInfo()));
} else {
$selecteverything->bindParam(':country', $faction, PDO::PARAM_INT);
$selecteverything->bindParam(':job', $job, PDO::PARAM_INT);
if($selecteverything->execute() == false) {
echo "Error while executing query to select the ranked chars.<br />";
die(FormatErrors($selecteverything->errorInfo()));
} else {
$begin=1;
for ($i=1; $char=$selecteverything->fetch(PDO::FETCH_ASSOC); $i++) {
if($i >= $begin) {
echo "<tr><td style=\"color:white\" bgcolor=\"black\"><center>".$i."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['CharName']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['Level']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['K1']."</center></td></tr>";
}
}
}
}
} else {
// tentative injection
$job=0;
echo "<center><table border=\"1\" width=\"520\">";
echo "<tr><th colspan=\"4\"><center>Işık İttifakı - Cengaver İnfaz Listesi</th></tr>";
echo "<tr><th><center>Sıra</center></th><th><center>İsmi </center></th><th><center>Seviye</center></th><th><center>İnfaz</center></th></tr>";
$selecteverything=$conn->prepare('SELECT TOP 30 c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
WHERE c.Del=0 AND d.Status=0 AND e.Country=:country AND c.Job=:job ORDER BY c.K1 DESC, c.K2 ASC, c.CharName ASC');
if($selecteverything == false) {
echo "Error in preparing the select query.<br />";
die(FormatErrors($conn->errorInfo()));
} else {
$selecteverything->bindParam(':country', $faction, PDO::PARAM_INT);
$selecteverything->bindParam(':job', $job, PDO::PARAM_INT);
if($selecteverything->execute() == false) {
echo "Error while executing query to select the ranked chars.<br />";
die(FormatErrors($selecteverything->errorInfo()));
} else {
$begin=1;
for ($i=1; $char=$selecteverything->fetch(PDO::FETCH_ASSOC); $i++) {
if($i >= $begin) {
echo "<tr><td style=\"color:white\" bgcolor=\"black\"><center>".$i."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['CharName']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['Level']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['K1']."</center></td></tr>";
}
}
}
}
}
echo "</table></center>";
} else {
// tentative injection
$job=0;
echo "<center><table border=\"1\" width=\"520\">";
echo "<tr><th colspan=\"4\"><center>Işık İttifakı - Cengaver</th></tr>";
echo "<tr><th><center>Sıra</center></th><th><center>İsmi </center></th><th><center>Seviye</center></th><th><center>İnfaz</center></th></tr>";
$selecteverything=$conn->prepare('SELECT TOP 30 c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
WHERE c.Del=0 AND d.Status=0 AND e.Country=:country AND c.Job=:job ORDER BY c.K1 DESC, c.K2 ASC, c.CharName ASC');
if($selecteverything == false) {
echo "Error in preparing the select query.<br />";
die(FormatErrors($conn->errorInfo()));
} else {
$selecteverything->bindParam(':country', $faction, PDO::PARAM_INT);
$selecteverything->bindParam(':job', $job, PDO::PARAM_INT);
if($selecteverything->execute() == false) {
echo "Error while executing query to select the ranked chars.<br />";
die(FormatErrors($selecteverything->errorInfo()));
} else {
$begin=1;
for ($i=1; $char=$selecteverything->fetch(PDO::FETCH_ASSOC); $i++) {
if($i >= $begin) {
echo "<tr><td style=\"color:white\" bgcolor=\"black\"><center>".$i."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['CharName']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['Level']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['K1']."</center></td></tr>";
}
}
}
}
echo "</table></center>";
}

} elseif ($_GET['faction'] == 1) {
// dark
echo "<center><a href=\"".$page."?faction=1&class=6\"><img src=\"./ranking_images/Warrior.jpg\"></a>    
<a href=\"".$page."?faction=1&class=1\"><img src=\"./ranking_images/Guardian.jpg\"></a>    
<a href=\"".$page."?faction=1&class=2\"><img src=\"./ranking_images/Assassin.jpg\"></a>    
<a href=\"".$page."?faction=1&class=3\"><img src=\"./ranking_images/Hunter.jpg\"></a>    
<a href=\"".$page."?faction=1&class=4\"><img src=\"./ranking_images/Pagan.jpg\"></a>    
<a href=\"".$page."?faction=1&class=5\"><img src=\"./ranking_images/Oracle.jpg\"></a>";
$faction=1;
if((isset($_GET['class'])) && (!empty($_GET['class']))) {
// si la classe est choisie
$job=$_GET['class'];
if($job == 6) {
$job=0;
echo "<center><table border=\"1\" width=\"520\">";
echo "<tr><th colspan=\"4\"><center>�fke Kardeşliği - Savaş�ı İnfaz Listesi</th></tr>";
echo "<tr><th><center>Sıra</center></th><th><center>İsmi </center></th><th><center>Seviye</center></th><th><center>İnfaz</center></th></tr>";
$selecteverything=$conn->prepare('SELECT TOP 30 c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
WHERE c.Del=0 AND d.Status=0 AND e.Country=:country AND c.Job=:job ORDER BY c.K1 DESC, c.K2 ASC, c.CharName ASC');
if($selecteverything == false) {
echo "Error in preparing the select query.<br />";
die(FormatErrors($conn->errorInfo()));
} else {
$selecteverything->bindParam(':country', $faction, PDO::PARAM_INT);
$selecteverything->bindParam(':job', $job, PDO::PARAM_INT);
if($selecteverything->execute() == false) {
echo "Error while executing query to select the ranked chars.<br />";
die(FormatErrors($selecteverything->errorInfo()));
} else {
$begin=1;
for ($i=1; $char=$selecteverything->fetch(PDO::FETCH_ASSOC); $i++) {
if($i >= $begin) {
echo "<tr><td style=\"color:white\" bgcolor=\"black\"><center>".$i."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['CharName']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['Level']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['K1']."</center></td></tr>";
}
}
}
}
} elseif ($job == 1) {
echo "<center><table border=\"1\" width=\"520\">";
echo "<tr><th colspan=\"4\"><center>�fke Kardeşliği - N�bet�i İnfaz Listesi</th></tr>";
echo "<tr><th><center>Sıra</center></th><th><center>İsmi </center></th><th><center>Seviye</center></th><th><center>İnfaz</center></th></tr>";
$selecteverything=$conn->prepare('SELECT TOP 30 c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
WHERE c.Del=0 AND d.Status=0 AND e.Country=:country AND c.Job=:job ORDER BY c.K1 DESC, c.K2 ASC, c.CharName ASC');
if($selecteverything == false) {
echo "Error in preparing the select query.<br />";
die(FormatErrors($conn->errorInfo()));
} else {
$selecteverything->bindParam(':country', $faction, PDO::PARAM_INT);
$selecteverything->bindParam(':job', $job, PDO::PARAM_INT);
if($selecteverything->execute() == false) {
echo "Error while executing query to select the ranked chars.<br />";
die(FormatErrors($selecteverything->errorInfo()));
} else {
$begin=1;
for ($i=1; $char=$selecteverything->fetch(PDO::FETCH_ASSOC); $i++) {
if($i >= $begin) {
echo "<tr><td style=\"color:white\" bgcolor=\"black\"><center>".$i."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['CharName']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['Level']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['K1']."</center></td></tr>";
}
}
}
}
} elseif ($job == 2) {
echo "<center><table border=\"1\" width=\"520\">";
echo "<tr><th colspan=\"4\"><center>�fke Kardeşliği - Suikast�i İnfaz Listesi</th></tr>";
echo "<tr><th><center>Sıra</center></th><th><center>İsmi </center></th><th><center>Seviye</center></th><th><center>İnfaz</center></th></tr>";
$selecteverything=$conn->prepare('SELECT TOP 30 c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
WHERE c.Del=0 AND d.Status=0 AND e.Country=:country AND c.Job=:job ORDER BY c.K1 DESC, c.K2 ASC, c.CharName ASC');
if($selecteverything == false) {
echo "Error in preparing the select query.<br />";
die(FormatErrors($conn->errorInfo()));
} else {
$selecteverything->bindParam(':country', $faction, PDO::PARAM_INT);
$selecteverything->bindParam(':job', $job, PDO::PARAM_INT);
if($selecteverything->execute() == false) {
echo "Error while executing query to select the ranked chars.<br />";
die(FormatErrors($selecteverything->errorInfo()));
} else {
$begin=1;
for ($i=1; $char=$selecteverything->fetch(PDO::FETCH_ASSOC); $i++) {
if($i >= $begin) {
echo "<tr><td style=\"color:white\" bgcolor=\"black\"><center>".$i."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['CharName']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['Level']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['K1']."</center></td></tr>";
}
}
}
}
} elseif ($job == 3) {
echo "<center><table border=\"1\" width=\"520\">";
echo "<tr><th colspan=\"4\"><center>�fke Kardeşliği - Avcı İnfaz Listesi</th></tr>";
echo "<tr><th><center>Sıra</center></th><th><center>İsmi </center></th><th><center>Seviye</center></th><th><center>İnfaz</center></th></tr>";
$selecteverything=$conn->prepare('SELECT TOP 30 c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
WHERE c.Del=0 AND d.Status=0 AND e.Country=:country AND c.Job=:job ORDER BY c.K1 DESC, c.K2 ASC, c.CharName ASC');
if($selecteverything == false) {
echo "Error in preparing the select query.<br />";
die(FormatErrors($conn->errorInfo()));
} else {
$selecteverything->bindParam(':country', $faction, PDO::PARAM_INT);
$selecteverything->bindParam(':job', $job, PDO::PARAM_INT);
if($selecteverything->execute() == false) {
echo "Error while executing query to select the ranked chars.<br />";
die(FormatErrors($selecteverything->errorInfo()));
} else {
$begin=1;
for ($i=1; $char=$selecteverything->fetch(PDO::FETCH_ASSOC); $i++) {
if($i >= $begin) {
echo "<tr><td style=\"color:white\" bgcolor=\"black\"><center>".$i."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['CharName']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['Level']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['K1']."</center></td></tr>";
}
}
}
}
} elseif ($job == 4) {
echo "<center><table border=\"1\" width=\"520\">";
echo "<tr><th colspan=\"4\"><center>�fke Kardeşliği - Pagan İnfaz Listesi</th></tr>";
echo "<tr><th><center>Sıra</center></th><th><center>İsmi </center></th><th><center>Seviye</center></th><th><center>İnfaz</center></th></tr>";
$selecteverything=$conn->prepare('SELECT TOP 30 c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
WHERE c.Del=0 AND d.Status=0 AND e.Country=:country AND c.Job=:job ORDER BY c.K1 DESC, c.K2 ASC, c.CharName ASC');
if($selecteverything == false) {
echo "Error in preparing the select query.<br />";
die(FormatErrors($conn->errorInfo()));
} else {
$selecteverything->bindParam(':country', $faction, PDO::PARAM_INT);
$selecteverything->bindParam(':job', $job, PDO::PARAM_INT);
if($selecteverything->execute() == false) {
echo "Error while executing query to select the ranked chars.<br />";
die(FormatErrors($selecteverything->errorInfo()));
} else {
$begin=1;
for ($i=1; $char=$selecteverything->fetch(PDO::FETCH_ASSOC); $i++) {
if($i >= $begin) {
echo "<tr><td style=\"color:white\" bgcolor=\"black\"><center>".$i."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['CharName']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['Level']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['K1']."</center></td></tr>";
}
}
}
}
} elseif ($job == 5) {
echo "<center><table border=\"1\" width=\"520\">";
echo "<tr><th colspan=\"4\"><center>�fke Kardeşliği - Kahin İnfaz Listesi</th></tr>";
echo "<tr><th><center>Sıra</center></th><th><center>İsmi </center></th><th><center>Seviye</center></th><th><center>İnfaz</center></th></tr>";
$selecteverything=$conn->prepare('SELECT TOP 30 c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
WHERE c.Del=0 AND d.Status=0 AND e.Country=:country AND c.Job=:job ORDER BY c.K1 DESC, c.K2 ASC, c.CharName ASC');
if($selecteverything == false) {
echo "Error in preparing the select query.<br />";
die(FormatErrors($conn->errorInfo()));
} else {
$selecteverything->bindParam(':country', $faction, PDO::PARAM_INT);
$selecteverything->bindParam(':job', $job, PDO::PARAM_INT);
if($selecteverything->execute() == false) {
echo "Error while executing query to select the ranked chars.<br />";
die(FormatErrors($selecteverything->errorInfo()));
} else {
$begin=1;
for ($i=1; $char=$selecteverything->fetch(PDO::FETCH_ASSOC); $i++) {
if($i >= $begin) {
echo "<tr><td style=\"color:white\" bgcolor=\"black\"><center>".$i."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['CharName']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['Level']."</center></td><td style=\"color:white\" bgcolor=\"black\"><center>".$char['K1']."</center></td></tr>";
}
}
}
}
} else {
// tentative injection
$job=0;
echo "<center><table border=\"1\" width=\"520\">";
echo "<tr><td colspan=\"4\"><center>FURY --- WARRIOR</td></tr>";
echo "<tr><td><center>Sıra</center></td><td><center>İsmi </center></td><td><center>Seviye</center></td><td><center>İnfaz</center></td></tr>";
$selecteverything=$conn->prepare('SELECT TOP 30 c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
WHERE c.Del=0 AND d.Status=0 AND e.Country=:country AND c.Job=:job ORDER BY c.K1 DESC, c.K2 ASC, c.CharName ASC');
if($selecteverything == false) {
echo "Error in preparing the select query.<br />";
die(FormatErrors($conn->errorInfo()));
} else {
$selecteverything->bindParam(':country', $faction, PDO::PARAM_INT);
$selecteverything->bindParam(':job', $job, PDO::PARAM_INT);
if($selecteverything->execute() == false) {
echo "Error while executing query to select the ranked chars.<br />";
die(FormatErrors($selecteverything->errorInfo()));
} else {
$begin=1;
for ($i=1; $char=$selecteverything->fetch(PDO::FETCH_ASSOC); $i++) {
if($i >= $begin) {
echo "<tr><td><center>".$i."</center></td><td><center>".$char['CharName']."</center></td><td><center>".$char['Level']."</center></td><td><center>".$char['K1']."</center></td></tr>";
}
}
}
}
}
echo "</table></center>";
} else {
// tentative injection
$job=0;
echo "<center><table border=\"1\" width=\"520\">";
echo "<tr><td colspan=\"4\"><center>FURY --- WARRIOR</td></tr>";
echo "<tr><td><center>Sıra</center></td><td><center>İsmi </center></td><td><center>Seviye</center></td><td><center>İnfaz</center></td></tr>";
$selecteverything=$conn->prepare('SELECT TOP 30 c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
WHERE c.Del=0 AND d.Status=0 AND e.Country=:country AND c.Job=:job ORDER BY c.K1 DESC, c.K2 ASC, c.CharName ASC');
if($selecteverything == false) {
echo "Error in preparing the select query.<br />";
die(FormatErrors($conn->errorInfo()));
} else {
$selecteverything->bindParam(':country', $faction, PDO::PARAM_INT);
$selecteverything->bindParam(':job', $job, PDO::PARAM_INT);
if($selecteverything->execute() == false) {
echo "Error while executing query to select the ranked chars.<br />";
die(FormatErrors($selecteverything->errorInfo()));
} else {
$begin=1;
for ($i=1; $char=$selecteverything->fetch(PDO::FETCH_ASSOC); $i++) {
if($i >= $begin) {
echo "<tr><td><center>".$i."</center></td><td><center>".$char['CharName']."</center></td><td><center>".$char['Level']."</center></td><td><center>".$char['K1']."</center></td></tr>";
}
}
}
}
echo "</table></center>";
}
} else {
// tentative injection
echo "<center><a href=\"".$page."?faction=2&class=6\"><img src=\"./ranking_images/Fighter.jpg\"></a>    
<a href=\"".$page."?faction=2&class=1\"><img src=\"./ranking_images/Defender.jpg\"></a>    
<a href=\"".$page."?faction=2&class=2\"><img src=\"./ranking_images/Ranger.jpg\"></a>    
<a href=\"".$page."?faction=2&class=3\"><img src=\"./ranking_images/Archer.jpg\"></a>    
<a href=\"".$page."?faction=2&class=4\"><img src=\"./ranking_images/Mage.jpg\"></a>    
<a href=\"".$page."?faction=2&class=5\"><img src=\"./ranking_images/Priest.jpg\"></a>";
$faction=0;
$job=0;

}
}
}
?>
</div>
</div>
</div> 

</body>
</html>

<body oncontextmenu="return false" ondragstart="return false">

All codes here i cant add guild thank u for helping

Done!

Spoiler

Please test it before to use on your server ^_^