online player character statics php code?

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");
?>