<?php

	mysql_selectdb ($chardb) OR DIE($error);
	// Выбираем кол-во персонажей по рассам
	$query = mysql_query("SELECT `race`,count(*) FROM characters GROUP BY `race`") OR DIE($error[3]);
	while($row = mysql_fetch_array($query)) {
		$race[] = $row;
	}
	// Выбираем кол-во персонажей по классам за альянс
	$query = mysql_query("SELECT `class`,count(*) FROM characters where `race` in (1,3,4,7,11) GROUP BY `class`") OR DIE($error[3]);
	while($row = mysql_fetch_array($query)) {
		$aclass[] = $row;
	}
	//  Выбираем кол-во персонажей по классам за орду
	$query = mysql_query("SELECT `class`,count(*) FROM characters where `race` in (2,5,6,8,10) GROUP BY `class`") OR DIE($error[3]);
	while($row = mysql_fetch_array($query)) {
		$hclass[] = $row;
	}

	$human		= $race[0][1];
	$dwarv		= $race[2][1];
	$night		= $race[3][1];
	$gnome		= $race[6][1];
	$draenei	= $race[9][1];
	$orc			= $race[1][1];
	$undead		= $race[4][1];
	$tauren		= $race[5][1];
	$troll		= $race[7][1];
	$blood		= $race[8][1];
	
	$druids_a			= $aclass[9][1];
	$druids_h			= $hclass[9][1];
	$hunters_a		= $aclass[2][1]
	$hunters_h		= $hclass[2][1]
	$mage_a				= $aclass[2][1];
	$mage_h				= $hclass[2][1];
	$palladins_a	= $aclass[1][1];
	$palladins_h	= $hclass[1][1];
	$priests_a		= $aclass[4][1];
	$priests_h		= $hclass[4][1];
	$rogues_a			= $aclass[3][1];
	$rogues_h			= $hclass[3][1];
	$shamans_a		= $aclass[6][1];
	$shamans_h		= $hclass[6][1];
	$warlocks_a		= $aclass[7][1];
	$warlocks_h		= $hclass[7][1];
	$warriors_a		= $aclass[0][1];
	$warriors_h		= $hclass[0][1];
	$dk_a					= $aclass[5][1];
	$dk_h					= $hclass[5][1];


?>