openside('TOP PK');
require_once("/var/www/vhosts/5ad15/httpdocs/stats/config.php");
 
	$sql = "SELECT char_name, pkkills FROM characters ORDER BY pkkills DESC LIMIT $top_limit";
	$query = mysql_query($sql);
 
	echo "<table align='center' style='border: 1px solid #aeaeae;'>";
	echo "<tr><td></td><td>Top PK</td></tr>";
	echo "<tr><td align='center'>Vieta</td><td align='center'>Nickas</td><td align='center'>PK</td></tr>";
 
	$i = 0;
	while($row = mysql_fetch_array($query))
	{
		$i++;
		$char_name = $row['char_name'];
		$top = $row['pkkills'];
 
		echo "<tr><td align='center'>$i</td><td align='center'>$char_name</td><td align='center'>$top</td></tr>";
	}
 
	echo "</table>";
closeside();

Table 'l2jdb.fusion6eRRJ_user_groups' doesn't existTable 'l2jdb.fusion6eRRJ_errors' doesn't existTable 'l2jdb.fusion6eRRJ_errors' doesn't exist
Table 'l2jdb.fusion6eRRJ_users' doesn't existTable 'l2jdb.fusion6eRRJ_errors' doesn't existTable 'l2jdb.fusion6eRRJ_errors' doesn't exist

<?php
 
/*
* host - vieta kur laikomas <span style="border-bottom: 1px dotted black;">mysql</span> serveris, dazniausiai buna localhost arba mysqlhost
* user - <span style="border-bottom: 1px dotted black;">mysql</span> vartotojas
* pass - <span style="border-bottom: 1px dotted black;">mysql</span> vartotojo slaptazodis
* db - <span style="border-bottom: 1px dotted black;">mysql</span> duomenu bazes pavadinimas (l2 serverio duomenu bazes).
*
* top_limit - nurodo kiek vieno ar kito top'o rezultatu parodyti lankytojams
* top_mode - nurodo koks topu modas naudojamas, 1 = topai keisis po kiekvieno puslapio perkrovimo, 2 = topai keisis paspaudus ant nuorodos, <span style="border-bottom: 1px dotted black;">javascript</span> pagalba (nepersikraunant visam puslapiui).
*/
 
/* nustatymu pradzia */
 
$host = "X";
$user = "X";
$pass = "X";
$db = "l2jdb";
 
$top_limit = 10;
$top_mode = 2;
 
/* nustatymu pabaiga */
 
/*
* toliau esancio kodo redaguoti nereikia
*/
 
function openConn($host, $user, $pass, $db)
{
	mysql_connect($host, $user, $pass);
	mysql_select_db($db);
}
 
openConn($host, $user, $pass, $db);
mysql_close($host, $user, $pass, $db)
 
?>

openside("TOP 10 PVP");
 
/*Informacija topo skaicius*/
$top = "15"; /*Skaicius kuris nurodo kiek rodytu zaideju tope*/
$pvppk = "pvpkills"; /*pvpkills rodys tope pvp skaiciu pkkills rodys pk skaiciu*/
/*Duomenu bazes prisijungimo duomenys*/
$hostas= 'Mysql Hostas'; /*PVZ.: localhost arba ip adresas PVZ.:[78.65.32.16] */
$user= 'Prisijungimo Vardas'; /*PVZ.: root */
$pass= 'Prisijungimo Slaptazodis';
$baze= 'Duomenu Baze'; /*PVZ.: l2jdb */
/*Stilius*/
function lentele($tops)
{
echo "<big>$tops</big>"; /*Cia tik pavizdys*/
}
function topas($vieta,$vardas,$score)
{
echo "[$vieta] -- $vardas -- $score <br> "; /*Cia tik pavizdys*/
}
 
/*Cia nelysk*/
$dbh=mysql_connect ($hostas,$user,$pass) or die ('Klaida: ' . mysql_error(). '');
mysql_select_db ("$baze",$dbh) or die('Negaliu prisijungti prie <span style="border-bottom: 1px dotted black;">MySql</span> , nes ' . mysql_error());
$sql = mysql_query("SELECT * FROM `characters` ORDER BY $pvppk DESC limit $top",$dbh);
$kiek = 0;
while($row = mysql_fetch_array($sql)) {
$kiek++;
lentele(topas($kiek, $row['char_name'], $row[$pvppk]));
 }
mysql_close($dbh);
closeside();
 

Access denied for user 'adasd'@'localhost' (using password: NO)Access denied for user 'adasd'@'localhost' (using password: NO)Access denied for user 'adasd'@'localhost' (using password: NO)Access denied for user 'adasd'@'localhost' (using password: NO)Access denied for user 'adasd'@'localhost' (using password: NO)Access denied for user 'adasd'@'localhost' (using password: NO)Access denied for user 'adasd'@'localhost' (using password: NO)