Anlatım: Aşağıda Belirttigim Kodları Önce Bir Metin Belgesi Açıyoruz Ve Yapıştırıyoruz Sonra Metin Belgesini index.php olarak kaydediyoruz ve İsmini değişiyoruz ve Siteye atıyoruz
Karakter Sayısı
HTML-Kodu:
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 "Charaktere : $charanzahl";
Kullanıcı Id Ve Hesap Sayısı
HTML-Kodu:
include("config.php");
mysql_connect($dbhost$dbuser$dbpass);
mysql_select_db("account");
$accs = "SELECT * from account";
$accsquery = mysql_query($accs);
$accszahl = mysql_num_rows($accsquery);
echo "Account : $accszahl";
İtem Sayısı
HTML-Kodu:
include("config.php");
mysql_connect($dbhost$dbuser$dbpass);
mysql_select_db("player");
$items = "SELECT * FROM item ";
$itemsquery = mysql_query($items);
$itemanzahl = mysql_num_rows($itemsquery);
echo "Items : $itemanzahl";
Lonca Sayısı
HTML-Kodu:
include("config.php");
mysql_connect($dbhost$dbuser$dbpass);
mysql_select_db("player");
$guilds ="SELECT * FROM guild";
$guildsquery = mysql_query($guilds);
$guildanzahl = mysql_num_rows ($guildsquery);
echo "Gilden : $guildanzahl";
Online Karakter Ve Oyuncular
HTML-Kodu:
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;");
$online_count = mysql_fetch_object($output)->count+1;
echo "Spieler Online : $online_count";
Sıralama (NOT:GMLER YAZILMAZ)
HTML-Kodu:
"; include('inc/config.php'); // Connect to DB mysql_select_db('player'); // Select DB 'player' $test = "SELECT * from player"; $testquery = mysql_query($test); $num2 = mysql_num_rows($testquery); if($_GET['max']) { $get = $_GET['max']; } else { $get = '0'; $max = $get + 20; $max2 = $get - 20; if($get > $num2) {
}
elseif($get >= 20 && $get < $num2) { } elseif ($num2 <= 20) { echo ""; } else { } echo " "; ?>
Sira |
Nick |
Level |
Exp |
Bayrak |
"; // Open table $i = 0; while($array = mysql_fetch_array($query)) { $i = $i + 1; echo " " . $i . " | " . $array["name"] . " | " . $array["level"] . " | " . $array["exp"] . " | "; $reich = "SELECT empire from player_index where id = " . $array[account_id] . ""; $query2 = mysql_query($reich); $array2 = mysql_fetch_array($query2); if($array2["empire"] == 1) { echo " | "; } elseif($array2["empire"] == 2) { echo " | "; } else { echo " | "; } } echo " "; // close table } ?>
Kayıt Ol
HTML-Kodu:
|