Files
Testing/group_stats.php

74 lines
1.3 KiB
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?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;
?>