<?  
require_once ('config.php');  
mysql_connect ("$dbip:$dbport","$dblogin","$dbpass");  
?>

<?
        
  mysql_selectdb ($rdb);       
  $acc = mysql_query ("select count(*) from account");       
  $acc = mysql_result ($acc,0);       
  mysql_selectdb ("$cdb");       
  $char = mysql_query ("select count(*) from characters");       
  $char = mysql_result ($char,0);       
  $alliance = mysql_query ("select count(*) from characters where race in (1,3,4,7,11)");       
  $alliance = mysql_result ($alliance,0);       
  $horde = mysql_query ("select count(*) from characters where race in (2,5,6,8,10)");       
  $horde = mysql_result ($horde,0);       
  $guild = mysql_query ("select count(*) from guild");       
  $guild = mysql_result ($guild,0);

/* Расы */

   /* Орда */

  $orc = mysql_query ("select count(*) from characters where race in (2)");       
  $orc = mysql_result ($orc, 0);

  $bloodelf = mysql_query ("select count(*) from characters where race in (10)");       
  $bloodelf = mysql_result ($bloodelf, 0);

  $tauren = mysql_query ("select count(*) from characters where race in (6)");       
  $tauren = mysql_result ($tauren, 0);

  $undead = mysql_query ("select count(*) from characters where race in (5)");       
  $undead = mysql_result ($undead, 0);

  $troll = mysql_query ("select count(*) from characters where race in (8)");       
  $troll = mysql_result ($troll, 0);

   /* Альянс */

  $human = mysql_query ("select count(*) from characters where race in (1)");       
  $human = mysql_result ($human, 0);

  $nightelf = mysql_query ("select count(*) from characters where race in (4)");       
  $nightelf = mysql_result ($nightelf, 0);

  $gnome = mysql_query ("select count(*) from characters where race in (7)");       
  $gnome = mysql_result ($gnome, 0);

  $dwarf = mysql_query ("select count(*) from characters where race in (3)");       
  $dwarf = mysql_result ($dwarf, 0);

  $dreney = mysql_query ("select count(*) from characters where race in (11)");       
  $dreney = mysql_result ($dreney, 0);

/* Классы (Альянс) */

  $awarrior = mysql_query ("select count(*) from characters where class in (1) and race in (1,4,7,11)");
  $awarrior = mysql_result ($awarrior, 0);

  $apaladin = mysql_query ("select count(*) from characters where class in (2) and race in (1,3,11)");
  $apaladin = mysql_result ($apaladin, 0);

  $ahunter = mysql_query ("select count(*) from characters where class in (3) and race in (3,4,11)");       
  $ahunter = mysql_result ($ahunter, 0);

  $arogue = mysql_query ("select count(*) from characters where class in (4) and race in (1,4,7)");       
  $arogue = mysql_result ($arogue, 0);

  $apriest = mysql_query ("select count(*) from characters where class in (5) and race in (1,3,4,11)");       
  $apriest = mysql_result ($apriest, 0);

  $adk = mysql_query ("select count(*) from characters where class in (6) and race in (1,3,4,7,11)");       
  $adk = mysql_result ($adk, 0);

  $ashaman = mysql_query ("select count(*) from characters where class in (7) and race in (11)");       
  $ashaman = mysql_result ($ashaman, 0);

  $amage = mysql_query ("select count(*) from characters where class in (8) and race in (1,7,11)");       
  $amage = mysql_result ($amage, 0);

  $awarlock = mysql_query ("select count(*) from characters where class in (9) and race in (1,7)");
  $awarlock = mysql_result ($awarlock, 0);

  $adruid = mysql_query ("select count(*) from characters where class in (11) and race in (4)");
  $adruid = mysql_result ($adruid, 0);

/* Классы (Орда) */

  $hwarrior = mysql_query ("select count(*) from characters where class in (1) and race in (2,5,6,8)");
  $hwarrior = mysql_result ($hwarrior, 0);

  $hpaladin = mysql_query ("select count(*) from characters where class in (2) and race in (10)");
  $hpaladin = mysql_result ($hpaladin, 0);

  $hhunter = mysql_query ("select count(*) from characters where class in (3) and race in (2,6,8,10)");       
  $hhunter = mysql_result ($hhunter, 0);

  $hrogue = mysql_query ("select count(*) from characters where class in (4) and race in (2,5,8,10)");       
  $hrogue = mysql_result ($hrogue, 0);

  $hpriest = mysql_query ("select count(*) from characters where class in (5) and race in (5,8,10)");       
  $hpriest = mysql_result ($hpriest, 0);

  $hdk = mysql_query ("select count(*) from characters where class in (6) and race in (2,5,6,8,10)");       
  $hdk = mysql_result ($hdk, 0);

  $hshaman = mysql_query ("select count(*) from characters where class in (7) and race in (2,6,8)");       
  $hshaman = mysql_result ($hshaman, 0);

  $hmage = mysql_query ("select count(*) from characters where class in (8) and race in (5,8,10)");       
  $hmage = mysql_result ($hmage, 0);

  $hwarlock = mysql_query ("select count(*) from characters where class in (9) and race in (2,5,10)");
  $hwarlock = mysql_result ($hwarlock, 0);

  $hdruid = mysql_query ("select count(*) from characters where class in (11) and race in (6)");
  $hdruid = mysql_result ($hdruid, 0);

?>