[insert_php]

// set table prefix for the forums.
define(‘TABLE_PREFIX_1’, ”);
define(‘TABLE_PREFIX_2’, ‘cobalt_’);
define(‘TABLE_PREFIX_3’, ‘jeepmil_’);
define(‘TABLE_PREFIX_4’, ‘tahoeyuk_’);
define(‘TABLE_PREFIX_5’, ‘scionxd_’);
define(‘TABLE_PREFIX_6’, ‘gmt400_’);
define(‘TABLE_PREFIX_7’, ‘camaro_’);
define(‘TABLE_PREFIX_8’, ‘charger_’);
define(‘TABLE_PREFIX_9’, ‘rx7forum_’);
/*
localhost: the host where mysql is running.
root : mysql username.
s : mysql password.
*/
// GMFULLSIZE.
$conn = mysql_connect(‘localhost’, ‘gmfulls_gmfulls’, ‘gmfullsize’) or die(mysql_error());
mysql_select_db(“gmfulls_gmfullsize”) or die(mysql_error());

$totalUsersForum1 = mysql_query(”
SELECT COUNT(*) AS users
FROM ” . TABLE_PREFIX_1 . “user
“) or die(mysql_error());
$totalUsersForum1Count = mysql_fetch_array($totalUsersForum1) or die(mysql_error());
$firstForumUserCount = $totalUsersForum1Count[‘users’];

$totalThreadsForum1 = mysql_query(”
SELECT COUNT(*) AS threads
FROM ” . TABLE_PREFIX_1 . “thread
“) or die(mysql_error());
$totalThreadsForum1Count = mysql_fetch_array($totalThreadsForum1) or die(mysql_error());
$firstForumThreadCount = $totalThreadsForum1Count[‘threads’];

$totalPostsForum1 = mysql_query(”
SELECT COUNT(*) AS posts
FROM ” . TABLE_PREFIX_1 . “post
“) or die(mysql_error());
$totalPostsForum1Count = mysql_fetch_array($totalPostsForum1) or die(mysql_error());
$firstForumPostCount = $totalPostsForum1Count[‘posts’];

mysql_close($conn) or die(mysql_error());
// CHEVYCOBALT.
$conn = mysql_connect(‘localhost’, ‘cobalt_korny30’, ‘4stooges’) or die(mysql_error());
mysql_select_db(“cobalt_forumdata”) or die(mysql_error());

$totalUsersForum2 = mysql_query(”
SELECT COUNT(*) AS users
FROM ” . TABLE_PREFIX_2 . “user
“) or die(mysql_error());
$totalUsersForum2Count = mysql_fetch_array($totalUsersForum2) or die(mysql_error());
$secondForumUserCount = $totalUsersForum2Count[‘users’];

$totalThreadsForum2 = mysql_query(”
SELECT COUNT(*) AS threads
FROM ” . TABLE_PREFIX_2 . “thread
“) or die(mysql_error());
$totalThreadsForum2Count = mysql_fetch_array($totalThreadsForum2) or die(mysql_error());
$secondForumThreadCount = $totalThreadsForum2Count[‘threads’];

$totalPostsForum2 = mysql_query(”
SELECT COUNT(*) AS posts
FROM ” . TABLE_PREFIX_2 . “post
“) or die(mysql_error());
$totalPostsForum2Count = mysql_fetch_array($totalPostsForum2) or die(mysql_error());
$secondForumPostCount = $totalPostsForum2Count[‘posts’];

mysql_close($conn) or die(mysql_error());
// JEEPMILITIA.
$conn = mysql_connect(‘localhost’, ‘jeepmil_vbuser’, ‘4stooges’) or die(mysql_error());
mysql_select_db(“jeepmil_vbforum”) or die(mysql_error());

$totalUsersForum3 = mysql_query(”
SELECT COUNT(*) AS users
FROM ” . TABLE_PREFIX_3 . “user
“) or die(mysql_error());
$totalUsersForum3Count = mysql_fetch_array($totalUsersForum3) or die(mysql_error());
$thirdForumUserCount = $totalUsersForum3Count[‘users’];

$totalThreadsForum3 = mysql_query(”
SELECT COUNT(*) AS threads
FROM ” . TABLE_PREFIX_3 . “thread
“) or die(mysql_error());
$totalThreadsForum3Count = mysql_fetch_array($totalThreadsForum3) or die(mysql_error());
$thirdForumThreadCount = $totalThreadsForum3Count[‘threads’];

$totalPostsForum3 = mysql_query(”
SELECT COUNT(*) AS posts
FROM ” . TABLE_PREFIX_3 . “post
“) or die(mysql_error());
$totalPostsForum3Count = mysql_fetch_array($totalPostsForum3) or die(mysql_error());
$thirdForumPostCount = $totalPostsForum3Count[‘posts’];

mysql_close($conn) or die(mysql_error());

// TAHOEYUKON.
$conn = mysql_connect(‘localhost’, ‘tahoeyuk_korny30’, ‘4stooges’) or die(mysql_error());
mysql_select_db(“tahoeyuk_forumdata”) or die(mysql_error());

$totalUsersForum4 = mysql_query(”
SELECT COUNT(*) AS users
FROM ” . TABLE_PREFIX_4 . “user
“) or die(mysql_error());
$totalUsersForum4Count = mysql_fetch_array($totalUsersForum4) or die(mysql_error());
$fourthForumUserCount = $totalUsersForum4Count[‘users’];

$totalThreadsForum4 = mysql_query(”
SELECT COUNT(*) AS threads
FROM ” . TABLE_PREFIX_4 . “thread
“) or die(mysql_error());
$totalThreadsForum4Count = mysql_fetch_array($totalThreadsForum4) or die(mysql_error());
$fourthForumThreadCount = $totalThreadsForum4Count[‘threads’];

$totalPostsForum4 = mysql_query(”
SELECT COUNT(*) AS posts
FROM ” . TABLE_PREFIX_4 . “post
“) or die(mysql_error());
$totalPostsForum4Count = mysql_fetch_array($totalPostsForum4) or die(mysql_error());
$fourthForumPostCount = $totalPostsForum4Count[‘posts’];

mysql_close($conn) or die(mysql_error());

// SCIONXD.
$conn = mysql_connect(‘localhost’, ‘scionxd_korny’, ‘4stooges’) or die(mysql_error());
mysql_select_db(“scionxd_forumdata”) or die(mysql_error());

$totalUsersForum5 = mysql_query(”
SELECT COUNT(*) AS users
FROM ” . TABLE_PREFIX_5 . “user
“) or die(mysql_error());
$totalUsersForum5Count = mysql_fetch_array($totalUsersForum5) or die(mysql_error());
$fifthForumUserCount = $totalUsersForum5Count[‘users’];

$totalThreadsForum5 = mysql_query(”
SELECT COUNT(*) AS threads
FROM ” . TABLE_PREFIX_5 . “thread
“) or die(mysql_error());
$totalThreadsForum5Count = mysql_fetch_array($totalThreadsForum5) or die(mysql_error());
$fifthForumThreadCount = $totalThreadsForum5Count[‘threads’];

$totalPostsForum5 = mysql_query(”
SELECT COUNT(*) AS posts
FROM ” . TABLE_PREFIX_5 . “post
“) or die(mysql_error());
$totalPostsForum5Count = mysql_fetch_array($totalPostsForum5) or die(mysql_error());
$fifthForumPostCount = $totalPostsForum5Count[‘posts’];

mysql_close($conn) or die(mysql_error());

// GMT499.
$conn = mysql_connect(‘localhost’, ‘gmt400_gmtuser’, ‘stooges’) or die(mysql_error());
mysql_select_db(“gmt400_gmtdb”) or die(mysql_error());

$totalUsersForum6 = mysql_query(”
SELECT COUNT(*) AS users
FROM ” . TABLE_PREFIX_6 . “user
“) or die(mysql_error());
$totalUsersForum6Count = mysql_fetch_array($totalUsersForum6) or die(mysql_error());
$sixthForumUserCount = $totalUsersForum6Count[‘users’];

$totalThreadsForum6 = mysql_query(”
SELECT COUNT(*) AS threads
FROM ” . TABLE_PREFIX_6 . “thread
“) or die(mysql_error());
$totalThreadsForum6Count = mysql_fetch_array($totalThreadsForum6) or die(mysql_error());
$sixthForumThreadCount = $totalThreadsForum6Count[‘threads’];

$totalPostsForum6 = mysql_query(”
SELECT COUNT(*) AS posts
FROM ” . TABLE_PREFIX_6 . “post
“) or die(mysql_error());
$totalPostsForum6Count = mysql_fetch_array($totalPostsForum6) or die(mysql_error());
$sixthForumPostCount = $totalPostsForum6Count[‘posts’];

mysql_close($conn) or die(mysql_error());

// CAMARO.
$conn = mysql_connect(‘localhost’, ‘camaro_korny’, ‘stooges’) or die(mysql_error());
mysql_select_db(“camaro_traxdata”) or die(mysql_error());

$totalUsersForum7 = mysql_query(”
SELECT COUNT(*) AS users
FROM ” . TABLE_PREFIX_7 . “user
“) or die(mysql_error());
$totalUsersForum7Count = mysql_fetch_array($totalUsersForum7) or die(mysql_error());
$seventhForumUserCount = $totalUsersForum7Count[‘users’];

$totalThreadsForum7 = mysql_query(”
SELECT COUNT(*) AS threads
FROM ” . TABLE_PREFIX_7 . “thread
“) or die(mysql_error());
$totalThreadsForum7Count = mysql_fetch_array($totalThreadsForum7) or die(mysql_error());
$seventhForumThreadCount = $totalThreadsForum7Count[‘threads’];

$totalPostsForum7 = mysql_query(”
SELECT COUNT(*) AS posts
FROM ” . TABLE_PREFIX_7 . “post
“) or die(mysql_error());
$totalPostsForum7Count = mysql_fetch_array($totalPostsForum7) or die(mysql_error());
$seventhForumPostCount = $totalPostsForum7Count[‘posts’];

mysql_close($conn) or die(mysql_error());

// CHARGER.
$conn = mysql_connect(‘localhost’, ‘charger_vbuser’, ‘4stooges’) or die(mysql_error());
mysql_select_db(“charger_forumdata”) or die(mysql_error());

$totalUsersForum8 = mysql_query(”
SELECT COUNT(*) AS users
FROM ” . TABLE_PREFIX_8 . “user
“) or die(mysql_error());
$totalUsersForum8Count = mysql_fetch_array($totalUsersForum8) or die(mysql_error());
$eighthForumUserCount = $totalUsersForum8Count[‘users’];

$totalThreadsForum8 = mysql_query(”
SELECT COUNT(*) AS threads
FROM ” . TABLE_PREFIX_8 . “thread
“) or die(mysql_error());
$totalThreadsForum8Count = mysql_fetch_array($totalThreadsForum8) or die(mysql_error());
$eighthForumThreadCount = $totalThreadsForum8Count[‘threads’];

$totalPostsForum8 = mysql_query(”
SELECT COUNT(*) AS posts
FROM ” . TABLE_PREFIX_8 . “post
“) or die(mysql_error());
$totalPostsForum8Count = mysql_fetch_array($totalPostsForum8) or die(mysql_error());
$eighthForumPostCount = $totalPostsForum8Count[‘posts’];

mysql_close($conn) or die(mysql_error());

// RX7.
$conn = mysql_connect(‘localhost’, ‘rx7forum_korny’, ‘4stooges’) or die(mysql_error());
mysql_select_db(“rx7forum_forumdata”) or die(mysql_error());

$totalUsersForum9 = mysql_query(”
SELECT COUNT(*) AS users
FROM ” . TABLE_PREFIX_9 . “user
“) or die(mysql_error());
$totalUsersForum9Count = mysql_fetch_array($totalUsersForum9) or die(mysql_error());
$ninthForumUserCount = $totalUsersForum9Count[‘users’];

$totalThreadsForum9 = mysql_query(”
SELECT COUNT(*) AS threads
FROM ” . TABLE_PREFIX_9 . “thread
“) or die(mysql_error());
$totalThreadsForum9Count = mysql_fetch_array($totalThreadsForum9) or die(mysql_error());
$ninthForumThreadCount = $totalThreadsForum9Count[‘threads’];

$totalPostsForum9 = mysql_query(”
SELECT COUNT(*) AS posts
FROM ” . TABLE_PREFIX_9 . “post
“) or die(mysql_error());
$totalPostsForum9Count = mysql_fetch_array($totalPostsForum9) or die(mysql_error());
$ninthForumPostCount = $totalPostsForum9Count[‘posts’];

mysql_close($conn) or die(mysql_error());
// total user count:
$totalUsersCount = $firstForumUserCount + $secondForumUserCount + $thirdForumUserCount + $fourthForumUserCount + $fifthForumUserCount + $sixthForumUserCount + $seventhForumUserCount + $eighthForumUserCount + $ninthForumUserCount;
$totalThreadsCount = $firstForumThreadCount + $secondForumThreadCount + $thirdForumThreadCount + $fourthForumThreadCount + $fifthForumThreadCount + $sixthForumThreadCount + $seventhForumThreadCount + $eighthForumThreadCount + $ninthForumThreadCount;
$totalPostsCount = $firstForumPostCount + $secondForumPostCount + $thirdForumPostCount + $fourthForumPostCount + $fifthhForumPostCount + $sixthForumPostCount + $seventhForumPostCount + $eighthForumPostCount + $ninthForumPostCount;

$Members = number_format ($totalUsersCount);
$Topics = number_format ($totalThreadsCount);
$Discussions = number_format ($totalPostsCount);

echo ”

Total Members: $Members

Total Discussions: $Topics

Total Posts: $Discussions
“;
[/insert_php]