Ultima modifica da un moderatore:
Ok Benissimo passiamo subito al sodo (ho poco tempo e non ho voglia di stare a scrivere righe e righe che non centrano niente)
File Config per far funzionare gli script:
Account Totali:
Gilde:
Nomi Gm Online:
Quanti Gm Online:
Numero PG Online
PG Totali:
Cordiali Saluti,
MrShake.
File Config per far funzionare gli script:
Codice:
[/B]<?php
$dbhost = "localhost"; //Ip Tuo server
$dbuser = "root";
$dbpass = "pssw"; //Password
$mysql_db = "account";
?> [B]Account Totali:
Codice:
<?php
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("account");
$acc = "SELECT * from account";
$accquery = mysql_query($acc);
$accon = mysql_num_rows($accquery);
echo "Account : $accon";
?>
Codice:
<?php
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$gilde ="SELECT * FROM guild";
$gildequery = mysql_query($gilde);
$gildeon = mysql_num_rows ($gildequery);
echo "Gilde Totali : $gildeon";
?>Nomi Gm Online:
Codice:
<?php
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$result = mysql_query("SELECT * FROM player WHERE name LIKE '[%]%' AND DATE_SUB(NOW(), INTERVAL 30 MINUTE) < last_play;");
while ($row = mysql_fetch_object($result)) {
echo "$row->name <br>";
}
mysql_free_result($result);
?>Quanti Gm Online:
Codice:
<?php
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$exe = mysql_query("SELECT COUNT(*) as count FROM player WHERE name like '[%]%' AND DATE_SUB(NOW(), INTERVAL 30 MINUTE) < last_play;");
$teamon = mysql_fetch_object($exe)->count;
echo "Momentaneamente ci sono $teamon membri dello staff online.."
?>Numero PG Online
Codice:
<?php
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$output = mysql_query("SELECT COUNT(*) as count FROM player WHERE DATE_SUB(NOW(), INTERVAL 5 MINUTE) < last_play;");
$utenti_on = mysql_fetch_object($output)->count+1;
echo "Utenti Online : $utenti_on";
?>PG Totali:
Codice:
<?php
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$chars = "SELECT * from player";
$charsquery = mysql_query($chars);
$charszahl = mysql_num_rows($charsquery);
echo "PG Totali : $charanzahl";
?>MrShake.
D Mi piacciono i lavori su script per i siti 