<?php
$mysql_host ="logon.cruel-wow.com:3308";
$mysql_user ="root";
$mysql_pass = "ananiaswilk1";
$realm['db'][1] = "cruelwow_character";
$realm['db'][2] = "cruelwow_character2";
$realm[1]['name'] = "Campfire";
$realm[2]['name'] = "VanillaWoW";
$realm['realm'][1] = mysql_connect($mysql_host, $mysql_user, $mysql_pass) or die("Realm 1 MySQL: " . mysql_error());
$realm['realm'][2] = mysql_connect($mysql_host, $mysql_user, $mysql_pass) or die("Realm 2 MySQL: " . mysql_error());
$realms = new realms($realm['db'][1], $realm['realm'][1], $realm['db'][2], $realm['realm'][2]);
class realms{

	var $db1;
	var $id1;
	var $db2;
	var $id2;

	function __construct($db1, $link1, $db2, $link2) {


		$this->db1 = $db1;
		$this->id1 = $link1;
		$this->db2 = $db2;
		$this->id2 = $link2;



	}

	function status() {

		global $total, $realm;

		$realm1 = mysql_query("SELECT COUNT(*) AS total FROM ".$this->db1.".characters WHERE online='1'", $this->id1) or die('Error in query'.mysql_error());
		$realm1_q = mysql_fetch_assoc($realm1);
		$online[1] = $realm1_q['total'];

		$realm2 = mysql_query("SELECT COUNT(*) AS total FROM ".$this->db2.".characters WHERE online='1'", $this->id2) or die('Error in query'.mysql_error());
		$realm2_q = mysql_fetch_assoc($realm2);
		$online[2] = $realm2_q['total'];


		$total1 = $online[1] + $online[2];

		$count1 = $online[1] / $total;
		$count2 = $count1 * 100;

		$percent[1] = $count2;

		$count1_2 = $online[2] / $total;
		$count2_2 = $count1_2 * 100;

		$percent[2] = $count2_2;


		$online[4] = $online[1] + $online[2];
		$count1_4 = $online[4] / (2000);
		$count2_34= $count1_4 * 100;

		$percent[4] = $count2_34;

		$output = '<center>
                Patch: <b>3.3.5a</b>
            	<div id="realm_spacer"></div>
            	<!-- realm one -->
				<div class="realm_info">'.$realm[1]['name'].'</div>
                <div class="realmbar"><div class="realm_fill" style="width:'.$percent[1].'%;"></div></div>
                <div class="realm_info">'.$online[1] .' / '. $total . '</div>
                <div id="realm_spacer"></div>
                <!-- realm two -->
                <div class="realm_info">'.$realm[2]['name'].'</div>
                <div class="realmbar"><div class="realm_fill" style="width:'.$percent[2].'%;"></div></div>
            	<div class="realm_info">'.$online[2] .' / '. $total . '</div>
				<div id="realm_spacer"></div>


                <div class="realmbar"><div class="realm_fill" style="width:'.$percent[4].'%;"></div></div>
				<div class="realm_info">'.$online[4] .' / '. ($total *3) . '</div>
                <div class="realm_info">Total</div>
                <div id="realm_spacer"></div>

				<div id="realm_spacer"></div>
				<div id="realm_spacer"></div>
				<div id="realm_spacer"></div>
            	</center>';

		echo $output;



	}
	}
	$realms->status();
	?>