Files
Testing/group_stats.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

74 lines
1.3 KiB
PHP

<?php
/* $Id: user_blog_entry.php 59 2009-02-13 03:25:54Z john $ */
if($_GET["password"]=="iuewfhfuh"){
$page = "general";
include "header.php";
$query=$database->database_query("SELECT * FROM se_groups WHERE group_id IN(6,
36,
55,
57,
67,
282,
435,
543,
740,
764,
803,
846,
994,
1014,
1041,
1049,
1112,
1238,
1248,
1275,
1279,
1305,
1327,
1392,
1409,
1465,
1488,
1490,
1548,
1579,
1618,
1707,
1713,
1720,
1755,
1778,
1997,
2080,
2137,
2372,
2384,
2389,
2394,
2454,
2468,
2486,
2495,
2602,
2821,
2872,
2889,
2979,
2981)") or die();
?><table style="width:400px;"><tr><td>Group ID</td><td>Premium</td><td>Free</td></tr><?php
while($row=$database->database_fetch_array($query))
{
$cnt1=$database->database_result($database->database_query("SELECT COUNT(*) as CNT FROM se_users, se_groupmembers WHERE groupmember_group_id=".$row["group_id"]." AND se_users.user_id=groupmember_user_id AND user_level_id=2"),0);
$cnt2=$database->database_result($database->database_query("SELECT COUNT(*) as CNT FROM se_users, se_groupmembers WHERE groupmember_group_id=".$row["group_id"]." AND se_users.user_id=groupmember_user_id AND user_level_id!=2"),0);
?><tr><td><?php
echo $row["group_id"];?></td><td><?php echo $cnt1;?></td><td><?php echo $cnt2;?></td></tr>
<?php
}
?></table><?php
}
exit;
?>