Ranks Script Help

[shaiyapvpserver]

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

[[ADM]_Dephisio]

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

[shaiyapvpserver]

$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

[[ADM]_Dephisio]

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

[[DEV]Arkham]

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

$select=$conn->prepare("SELECT [GuildID] FROM [PS_GameData].[dbo].[GuildChars] WHERE [CharID] = '".$char['CharID']."' AND [Del] = 0");
$select->execute();
$guild_row = $select->fetch();
$get_guild = $con->prepare("SELECT GuildName FROM PS_GameData.dbo.Guilds WHERE GuildID = " . $guild_row["GuildID"] . " AND Del = 0");
$get_guild->execute();
$guild_name_row = $get_guild->fetch();
if ($guild_name_row) $guild = $guild_name_row[0];

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


[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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=1\"><img src=\"./ranking_images/Defender.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=2\"><img src=\"./ranking_images/Ranger.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=3\"><img src=\"./ranking_images/Archer.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=4\"><img src=\"./ranking_images/Mage.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<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>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=1&class=1\"><img src=\"./ranking_images/Guardian.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=1&class=2\"><img src=\"./ranking_images/Assassin.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=1&class=3\"><img src=\"./ranking_images/Hunter.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=1&class=4\"><img src=\"./ranking_images/Pagan.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<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>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=1\"><img src=\"./ranking_images/Defender.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=2\"><img src=\"./ranking_images/Ranger.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=3\"><img src=\"./ranking_images/Archer.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=4\"><img src=\"./ranking_images/Mage.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=5\"><img src=\"./ranking_images/Priest.jpg\"></a>";
$faction=0;
$job=0;

}
}
}
?>
</div>
</div>
</div> <!-- end of content left -->


</body>
</html>

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

All codes here i cant add guild thank u for helping

[[DEV]Arkham]

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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=1\"><img src=\"./ranking_images/Defender.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=2\"><img src=\"./ranking_images/Ranger.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=3\"><img src=\"./ranking_images/Archer.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=4\"><img src=\"./ranking_images/Mage.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<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>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=1&class=1\"><img src=\"./ranking_images/Guardian.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=1&class=2\"><img src=\"./ranking_images/Assassin.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=1&class=3\"><img src=\"./ranking_images/Hunter.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=1&class=4\"><img src=\"./ranking_images/Pagan.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<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>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=1\"><img src=\"./ranking_images/Defender.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=2\"><img src=\"./ranking_images/Ranger.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=3\"><img src=\"./ranking_images/Archer.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=4\"><img src=\"./ranking_images/Mage.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=5\"><img src=\"./ranking_images/Priest.jpg\"></a>";
$faction=0;
$job=0;

}
}
}
?>
</div>
</div>
</div> <!-- end of content left -->


</body>
</html>

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

All codes here i cant add guild thank u for helping

Done!

 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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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.CharID, c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country, g.GuildName, a.GuildID
FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
LEFT JOIN PS_GameData.dbo.GuildChars AS a ON c.CharID=a.CharID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
LEFT JOIN PS_GameData.dbo.Guilds AS g ON g.GuildID=a.GuildID
WHERE c.Del=0 AND d.Status=0 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>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=1\"><img src=\"./ranking_images/Defender.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=2\"><img src=\"./ranking_images/Ranger.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=3\"><img src=\"./ranking_images/Archer.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=4\"><img src=\"./ranking_images/Mage.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<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.CharID, c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country, g.GuildName, a.GuildID FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
LEFT JOIN PS_GameData.dbo.GuildChars AS a ON c.CharID=a.CharID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
LEFT JOIN PS_GameData.dbo.Guilds AS g ON g.GuildID=a.GuildID
WHERE c.Del=0 AND d.Status=0 e.Country=:country AND c.Job=:job ORDER BY c.K1, c.K2, 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\">".$char['GuildName']"</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.CharID, c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country, g.GuildName, a.GuildID FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
LEFT JOIN PS_GameData.dbo.GuildChars AS a ON c.CharID=a.CharID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
LEFT JOIN PS_GameData.dbo.Guilds AS g ON g.GuildID=a.GuildID
WHERE c.Del=0 AND d.Status=0 e.Country=:country AND c.Job=:job ORDER BY c.K1, c.K2, 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\">".$char['GuildName']"</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.CharID, c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country, g.GuildName, a.GuildID FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
LEFT JOIN PS_GameData.dbo.GuildChars AS a ON c.CharID=a.CharID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
LEFT JOIN PS_GameData.dbo.Guilds AS g ON g.GuildID=a.GuildID
WHERE c.Del=0 AND d.Status=0 e.Country=:country AND c.Job=:job ORDER BY c.K1, c.K2, 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\">".$char['GuildName']"</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.CharID, c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country, g.GuildName, a.GuildID FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
LEFT JOIN PS_GameData.dbo.GuildChars AS a ON c.CharID=a.CharID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
LEFT JOIN PS_GameData.dbo.Guilds AS g ON g.GuildID=a.GuildID
WHERE c.Del=0 AND d.Status=0 e.Country=:country AND c.Job=:job ORDER BY c.K1, c.K2, 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\">".$char['GuildName']"</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.CharID, c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country, g.GuildName, a.GuildID FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
LEFT JOIN PS_GameData.dbo.GuildChars AS a ON c.CharID=a.CharID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
LEFT JOIN PS_GameData.dbo.Guilds AS g ON g.GuildID=a.GuildID
WHERE c.Del=0 AND d.Status=0 e.Country=:country AND c.Job=:job ORDER BY c.K1, c.K2, 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\">".$char['GuildName']"</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.CharID, c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country, g.GuildName, a.GuildID FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
LEFT JOIN PS_GameData.dbo.GuildChars AS a ON c.CharID=a.CharID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
LEFT JOIN PS_GameData.dbo.Guilds AS g ON g.GuildID=a.GuildID
WHERE c.Del=0 AND d.Status=0 e.Country=:country AND c.Job=:job ORDER BY c.K1, c.K2, 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\">".$char['GuildName']"</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.CharID, c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country, g.GuildName, a.GuildID FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
LEFT JOIN PS_GameData.dbo.GuildChars AS a ON c.CharID=a.CharID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
LEFT JOIN PS_GameData.dbo.Guilds AS g ON g.GuildID=a.GuildID
WHERE c.Del=0 AND d.Status=0 e.Country=:country AND c.Job=:job ORDER BY c.K1, c.K2, 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\">".$char['GuildName']"</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.CharID, c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country, g.GuildName, a.GuildID FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
LEFT JOIN PS_GameData.dbo.GuildChars AS a ON c.CharID=a.CharID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
LEFT JOIN PS_GameData.dbo.Guilds AS g ON g.GuildID=a.GuildID
WHERE c.Del=0 AND d.Status=0 e.Country=:country AND c.Job=:job ORDER BY c.K1, c.K2, 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\">".$char['GuildName']"</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>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=1&class=1\"><img src=\"./ranking_images/Guardian.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=1&class=2\"><img src=\"./ranking_images/Assassin.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=1&class=3\"><img src=\"./ranking_images/Hunter.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=1&class=4\"><img src=\"./ranking_images/Pagan.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<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.CharID, c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country, g.GuildName, a.GuildID FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
LEFT JOIN PS_GameData.dbo.GuildChars AS a ON c.CharID=a.CharID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
LEFT JOIN PS_GameData.dbo.Guilds AS g ON g.GuildID=a.GuildID
WHERE c.Del=0 AND d.Status=0 e.Country=:country AND c.Job=:job ORDER BY c.K1, c.K2, 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\">".$char['GuildName']"</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.CharID, c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country, g.GuildName, a.GuildID FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
LEFT JOIN PS_GameData.dbo.GuildChars AS a ON c.CharID=a.CharID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
LEFT JOIN PS_GameData.dbo.Guilds AS g ON g.GuildID=a.GuildID
WHERE c.Del=0 AND d.Status=0 e.Country=:country AND c.Job=:job ORDER BY c.K1, c.K2, 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\">".$char['GuildName']"</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.CharID, c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country, g.GuildName, a.GuildID FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
LEFT JOIN PS_GameData.dbo.GuildChars AS a ON c.CharID=a.CharID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
LEFT JOIN PS_GameData.dbo.Guilds AS g ON g.GuildID=a.GuildID
WHERE c.Del=0 AND d.Status=0 e.Country=:country AND c.Job=:job ORDER BY c.K1, c.K2, 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\">".$char['GuildName']"</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.CharID, c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country, g.GuildName, a.GuildID FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
LEFT JOIN PS_GameData.dbo.GuildChars AS a ON c.CharID=a.CharID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
LEFT JOIN PS_GameData.dbo.Guilds AS g ON g.GuildID=a.GuildID
WHERE c.Del=0 AND d.Status=0 e.Country=:country AND c.Job=:job ORDER BY c.K1, c.K2, 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\">".$char['GuildName']"</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.CharID, c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country, g.GuildName, a.GuildID FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
LEFT JOIN PS_GameData.dbo.GuildChars AS a ON c.CharID=a.CharID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
LEFT JOIN PS_GameData.dbo.Guilds AS g ON g.GuildID=a.GuildID
WHERE c.Del=0 AND d.Status=0 e.Country=:country AND c.Job=:job ORDER BY c.K1, c.K2, 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\">".$char['GuildName']"</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.CharID, c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country, g.GuildName, a.GuildID FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
LEFT JOIN PS_GameData.dbo.GuildChars AS a ON c.CharID=a.CharID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
LEFT JOIN PS_GameData.dbo.Guilds AS g ON g.GuildID=a.GuildID
WHERE c.Del=0 AND d.Status=0 e.Country=:country AND c.Job=:job ORDER BY c.K1, c.K2, 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\">".$char['GuildName']"</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.CharID, c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country, g.GuildName, a.GuildID FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
LEFT JOIN PS_GameData.dbo.GuildChars AS a ON c.CharID=a.CharID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
LEFT JOIN PS_GameData.dbo.Guilds AS g ON g.GuildID=a.GuildID
WHERE c.Del=0 AND d.Status=0 e.Country=:country AND c.Job=:job ORDER BY c.K1, c.K2, 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><td><center>".$char['GuildName']."</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.CharID, c.CharName, c.K1, c.Del, c.UserUID, c.Level, d.Status, e.Country, g.GuildName, a.GuildID FROM PS_GameData.dbo.Chars AS c
JOIN PS_UserData.dbo.Users_Master AS d ON c.UserUID=d.UserUID
LEFT JOIN PS_GameData.dbo.GuildChars AS a ON c.CharID=a.CharID
JOIN PS_GameData.dbo.UserMaxGrow AS e ON c.UserUID=e.UserUID
LEFT JOIN PS_GameData.dbo.Guilds AS g ON g.GuildID=a.GuildID
WHERE c.Del=0 AND d.Status=0 e.Country=:country AND c.Job=:job ORDER BY c.K1, c.K2, 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><td><center>".$char['GuildName']."</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>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=1\"><img src=\"./ranking_images/Defender.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=2\"><img src=\"./ranking_images/Ranger.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=3\"><img src=\"./ranking_images/Archer.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=4\"><img src=\"./ranking_images/Mage.jpg\"></a>&nbsp;&nbsp;&nbsp;&nbsp;
<a href=\"".$page."?faction=2&class=5\"><img src=\"./ranking_images/Priest.jpg\"></a>";
$faction=0;
$job=0;

}
}
}
?>
</div>
</div>
</div> <!-- end of content left -->


</body>
</html>

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

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