Shaman
Code:
<?php include("online.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$saman = mysql_query("SELECT COUNT(*) as count FROM player WHERE (job=3 or job=7) AND DATE_SUB(NOW(), INTERVAL 10 MINUTE) < last_play;");
$online_count = mysql_fetch_object($saman)->count;
echo "Online Shaman : $online_count"; ?>
Warrior
Code:
<?php include("online.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$savasci = mysql_query("SELECT COUNT(*) as count FROM player WHERE (job=0 or job=4) AND DATE_SUB(NOW(), INTERVAL 10 MINUTE) < last_play;");
$online_count = mysql_fetch_object($savasci)->count;
echo "Online Warrior : $online_count"; ?>
Ninja
Code:
<?php include("online.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$ninja = mysql_query("SELECT COUNT(*) as count FROM player WHERE (job=1 or job=5) AND DATE_SUB(NOW(), INTERVAL 10 MINUTE) < last_play;");
$online_count = mysql_fetch_object($ninja)->count;
echo "Online Ninja : $online_count"; ?>
Sura
Code:
<?php include("online.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$sura = mysql_query("SELECT COUNT(*) as count FROM player WHERE (job=2 or job=6) AND DATE_SUB(NOW(), INTERVAL 10 MINUTE) < last_play;");
$online_count = mysql_fetch_object($sura)->count;
echo "Online Sura : $online_count"; ?>
Lycan
Code:
<?php include("online.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$sura = mysql_query("SELECT COUNT(*) as count FROM player WHERE (job=8) AND DATE_SUB(NOW(), INTERVAL 10 MINUTE) < last_play;");
$online_count = mysql_fetch_object($sura)->count;
echo "Online Lycan : $online_count"; ?>
Online.php CODE
Code:
<?php
$dbhost = "ip"; // Serverinizin İP Adresi.
$dbuser = "root"; // Değiştirmeyin.
$dbpass = "dbpass"; // Navicat Şifreniz.
$mysql_db = "account";
mysql_select_db("player");
?>