What's new

PHP [KONKURS][MODERN]Liczba graczy online

Status
Not open for further replies.

Kuzirashi

ASP.NET MVC, JS-SPA, PHP, NODE
Joined
Jul 24, 2010
Messages
772
Reaction score
157
Skrypt mo?na wykorzysta? np. do od?wie?ania statusu co ile? czasu, je?eli po??czy si? go z ajaxem. Tutaj kod, kt?ry najlepiej wklei? w /system/. Tworzymy nowy plik .php i wklejamy:
PHP:
<?php
/*	KUZIRASHI'S ONLINE PLAYERS	*
 *	------------------- CONFIG	*
 */
require '../config.php';
/*	 END OF CONFIG	*
 *	- - CONNECTION	*
 *	- - - -  CLASS 	*
 */
class Connection {
	public function connect ($host, $user, $pass, $db) {
		if(!$this->connection = new mysqli($host, $user, $pass)) {
			throw new Exception('Nie uda?o si? po??czy?.');
		}
		if (!$this->connection->select_db($db)) {
			throw new Exception('Nie uda?o si? wybra? bazy ' . $db);
		}
	}
	
	public function ammount ($q) {
		if (!$this->result = $this->connection->query($q)) {
			throw new Exception('Zapytanie nie powiod?o si?. Pow?d: ' . $this->connection->error);
		} else {
			if (!$this->numer = $this->result->num_rows) {
				throw new Exception('Nie uda?o si? policzy? wierszy.');
			} else {
				$this->result->close();
				return $this->numer;
			}
		}
	}
	
	function close () {
		if (!$this->connection->close()) {
			throw new Exception('Nie uda?o si? zamkn??.');
		}
	}
}
/*	END OF CONNECTION CLASS	*
 *	BEGIN OF USER INTERFACE	*
 */
$connection = new Connection;
try {
	$connection->connect($config['database']['host'], $config['database']['login'], $config['database']['password'], $config['database']['database']);
	// QUERY
	$result = $connection->ammount('SELECT `id` FROM  `players` WHERE `online` = 1');
	// OUTPUT RESULT
	echo $result;
	// CLOSE CONNECTION
	$connection->close();
} catch (Exception $e) {
	// ECHO OUT ERRORS IF ANY
	echo 'B??dy: ',  $e->getMessage(), "\n";
}
/*	- END OF USER INTERFACE	*
 *	- - - - - END OF SCRIPT	*
 *  - - - - -  BY KUZIRASHI	*
 *  - - - - - - GG: 4760316	*
 * - - KUZIRASHI@INTERIA.PL	*
 */
?>

Reput mile widziany.

Zabraniam kopiowania zawarto?ci na inne fora/serwisy.

Notka moderatorska:
+10pkt do konkursu!
 

oskaradamos

Advanced User
Joined
Nov 24, 2009
Messages
190
Reaction score
3
Odp: [KONKURS][MODERN]Liczba graczy online

A jak go po??czy? w?a?nie z ajaxem aby ustali? co ile ? Na moim ACC jest to bardzo wolne i denerwuj?ce...
 
Status
Not open for further replies.
Top