[bananalive]

Originally Posted by Bluefin221

@BananaLive - I wonder if you could tell me if there is a query I could place for how many tournaments (total) and how many teams (total) there are within the tournament section, I'm creating a stat bar and would like it to show how many teams we have and how many tournaments are running (past and present) which will automatically update due to the proper queries being called.

$a = $vbulletin->db->query_first("SELECT COUNT(*) as count FROM ".TABLE_PREFIX."tmnt_tmnts");
$count_tournaments = $a['count'];

$b = $vbulletin->db->query_first("SELECT COUNT(*) as count FROM ".TABLE_PREFIX."tmnt_teams ");
$count_teams = $b['count'];