Script Server Statistics (STATIC)

Roxas · le 14 mai 2020

I share for you these scripts (static) for those who doesnt know oop programming

Config

Hidden Content

Give reaction to this post to see the hidden content.

Script

Hidden Content

Give reaction to this post to see the hidden content.

Callout

Hidden Content

Give reaction to this post to see the hidden content.

CODE

$host = "192.168.0.100";
$user = "root";
$password = "pwd";
$conn = new mysqli($host, $user, $password);
$contador = 0;

function obtenerCuentas($nombre_tabla){
	global $conn, $contador;
	mysqli_select_db ($conn, $nombre_tabla);
		$result = mysqli_query($conn, "SELECT COUNT(*) FROM account");
		$extraido = mysqli_fetch_array($result);
		$contador=$extraido['0']; 
	return $contador;
}

function obtenerPlayers($nombre_tabla){
	global $conn, $contador;
	mysqli_select_db ($conn, $nombre_tabla);
		$result = mysqli_query($conn, "SELECT COUNT(*) FROM player");
		$extraido = mysqli_fetch_array($result);
		$contador=$extraido['0']; 
	return $contador;
}

function obtenerGremios($nombre_tabla){
	global $conn, $contador;
	mysqli_select_db ($conn, $nombre_tabla);
		$result = mysqli_query($conn, "SELECT COUNT(*) FROM guild");
		$extraido = mysqli_fetch_array($result);
		$contador=$extraido['0']; 
	return $contador;
}

function obtenerOfflineShop($nombre_tabla){
	global $conn, $contador;
	mysqli_select_db ($conn, $nombre_tabla);
		$result = mysqli_query($conn, "SELECT COUNT(*) FROM offline_shop_npc");
		$extraido = mysqli_fetch_array($result);
		$contador=$extraido['0']; 
	return $contador;
}

print obtenerCuentas("account");
print "<br>";
print obtenerPlayers("player");
print "<br>";
print obtenerGremios("player");
print "<br>";
print obtenerOfflineShop("player");