Grid Statistics
0,
'total_regions' => 0,
'total_accounts' => 0,
'active_users' => 0,
'grid_users' => 0
];
$queries = [
'online_users' => "SELECT COUNT(*) FROM Presence",
'total_regions' => "SELECT COUNT(*) FROM regions",
'total_accounts' => "SELECT COUNT(*) FROM UserAccounts",
'active_users' => "SELECT COUNT(*) FROM GridUser WHERE Login > (UNIX_TIMESTAMP() - (30*86400))",
'grid_users' => "SELECT COUNT(*) FROM GridUser"
];
foreach ($queries as $key => $query) {
$result = mysqli_query($con, $query);
if ($result) {
$stats[$key] = mysqli_fetch_row($result)[0];
}
}
mysqli_close($con);
} catch (Exception $e) {
error_log("Database error in welcomesplashpage.php: " . $e->getMessage());
// Set default values if database fails
$stats = [
'online_users' => 'N/A',
'total_regions' => 'N/A',
'total_accounts' => 'N/A',
'active_users' => 'N/A',
'grid_users' => 'N/A'
];
}
?>
Recent Regions
0) {
while ($region = mysqli_fetch_assoc($result)) {
$region_url = "secondlife://" . str_replace(['http://', 'https://'], '', $region['serverURI']) . "/" . $region['regionName'] . "/" . ($region['locX'] * 256) . "/" . ($region['locY'] * 256) . "/25";
?>
No regions available at the moment.
';
}
mysqli_close($con);
}
} catch (Exception $e) {
echo '
Unable to load regions at this time.
';
error_log("Database error in regions list: " . $e->getMessage());
}
?>
