dblink,"SELECT Count(*) as Total FROM ".TB_PREFIX."users WHERE tribe = 1"), MYSQLI_ASSOC); $tribe2 = mysqli_fetch_array(mysqli_query($database->dblink,"SELECT Count(*) as Total FROM ".TB_PREFIX."users WHERE tribe = 2"), MYSQLI_ASSOC); $tribe3 = mysqli_fetch_array(mysqli_query($database->dblink,"SELECT Count(*) as Total FROM ".TB_PREFIX."users WHERE tribe = 3"), MYSQLI_ASSOC); $tribes = [$tribe1['Total'], $tribe2['Total'], $tribe3['Total']]; $users = mysqli_fetch_array(mysqli_query($database->dblink,"SELECT Count(*) as Total FROM " . TB_PREFIX . "users WHERE tribe > 0 AND tribe < 4"), MYSQLI_ASSOC); $users = $users['Total']; ?>

World Stats
Total Villages	Total Population
dblink,"SELECT * FROM ".TB_PREFIX."vdata"); $num_rows2 = mysqli_num_rows($result2); echo $num_rows2; ?>	dblink,"SELECT SUM(pop) AS sumofpop FROM ".TB_PREFIX."vdata"); $getpop = mysqli_fetch_assoc($pop); echo $getpop['sumofpop']; ?>

Players
Registered players
Active players	dblink,"SELECT * FROM ".TB_PREFIX."users WHERE timestamp > ".(time() - (3600*24))." AND tribe!=0 AND tribe!=4 AND tribe!=5")); echo $active; ?>
Players online	dblink,"SELECT Count(*) as Total FROM ".TB_PREFIX."users WHERE timestamp > ".(time() - (60*10))." AND tribe!=0 AND tribe!=4 AND tribe!=5"); if (!empty($online)) { echo mysqli_fetch_assoc($online)['Total']; } else { echo 0; } ?>

Tribes
Tribe	Registered	Percent
Romans		0) ? ($percents[0] = round(100 * ($tribes[0] / $users), 2))."%" : '---'; ?>
Teutons		0) ? ($percents[1] = round(100 * ($tribes[1] / $users), 2))."%" : "---"; ?>
Gauls		0) ? (100-$percents[0]-$percents[1])."%" : '---'; ?>

Total Gold
	Total
Gold

Troops
	Total		Total		Total
	dblink,"SELECT SUM(u1) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u11) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u21) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>
	dblink,"SELECT SUM(u2) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u12) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u22) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>
	dblink,"SELECT SUM(u3) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u13) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u23) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>
	dblink,"SELECT SUM(u4) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u14) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u24) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>
	dblink,"SELECT SUM(u5) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u15) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u25) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>
	dblink,"SELECT SUM(u6) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u16) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u26) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>
	dblink,"SELECT SUM(u7) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u17) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u27) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>
	dblink,"SELECT SUM(u8) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u18) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u28) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>
	dblink,"SELECT SUM(u9) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u19) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u29) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>
	dblink,"SELECT SUM(u10) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u20) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>		dblink,"SELECT SUM(u30) AS sumofrats FROM ".TB_PREFIX."units"); $getorat = mysqli_fetch_assoc($orat); echo $getorat['sumofrats']; ?>

Miscellaneous
Attacks	Casualties	Date
getAttackByDate(time()); ?>	getAttackCasualties(time()); ?>
getAttackByDate(time()-(86400*1)); ?>	getAttackCasualties(time()-(86400*1)); ?>
getAttackByDate(time()-(86400*2)); ?>	getAttackCasualties(time()-(86400*2)); ?>
getAttackByDate(time()-(86400*3)); ?>	getAttackCasualties(time()-(86400*3)); ?>
getAttackByDate(time()-(86400*4)); ?>	getAttackCasualties(time()-(86400*4)); ?>
getAttackByDate(time()-(86400*5)); ?>	getAttackCasualties(time()-(86400*5)); ?>
getAttackByDate(time()-(86400*6)); ?>	getAttackCasualties(time()-(86400*6)); ?>