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)