74 lines
1.3 KiB
PHP
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;
|
|
?>
|