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();
?>
| Group ID | Premium | Free |
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);
?> | | |