Online.php

<!--
Created by Blackboy0
Part of '[RELEASE] PHP Scripts' on MMOwned, AC-Web, ArcEmu and WoW-V
Please LEAVE THESE CREDITS
-->

<?php
$host = "localhost";  //db host
$user = "iser";       // username
$pass = "pass";       // password
$logon = "auth";  // logon db

$conn = mysql_connect($host, $user, $pass) or die(mysql_error());
mysql_select_db($char_data, $conn) or die(mysql_error());

// Total Member Select
$sql = "SELECT SUM(online) FROM characters";
$sqlquery = mysql_query($sql) or die(mysql_error());
$memb = mysql_result($sqlquery,0,0);

// Alliance Total Member Select
$asql = "SELECT SUM(online) FROM characters WHERE race IN(1,3,4,7,11)";
$asqlquery = mysql_query($asql) or die(mysql_error());
$amemb = mysql_result($asqlquery,0,0);

// Horde Total Member Select
$hsql = "SELECT SUM(online) FROM characters WHERE race IN(2,5,6,8,10)";
$hsqlquery = mysql_query($hsql) or die(mysql_error());
$hmemb = mysql_result($hsqlquery,0,0);

echo "Total - ".$memb."<br />";
echo "Alliance - ".$amemb."<br />";
echo "Horde - ".$hmemb."<br />";

mysql_close($conn);
?>

<!-- RACE VALUES -->
<!--
Human - 1
Orc - 2
Dwarf - 3
Night Elf - 4
Undead - 5
Tauren - 6
Gnome - 7
Troll - 8
Blood Elf - 10
Draenei - 11
-->


index.html

<?php include("online.php"); ?>