';
} else {
/*
Show list of waiting news items
*/
$sql="SELECT * FROM news_bytes WHERE is_approved <> 4 AND group_id='$group_id'";
$result=db_query($sql);
$rows=db_numrows($result);
$group =& group_get_object($group_id);
if ($rows < 1) {
echo '
';
} else {
/*
Show list of waiting news items
*/
$old_date = time()-60*60*24*30;
$sql_pending= "
SELECT groups.group_id,id,post_date,summary,
group_name,unix_group_name
FROM news_bytes,groups
WHERE is_approved=0
AND news_bytes.group_id=groups.group_id
AND post_date > '$old_date'
AND groups.is_public=1
AND groups.status='A'
ORDER BY post_date
";
$old_date = time()-(60*60*24*7);
$sql_rejected = "
SELECT groups.group_id,id,post_date,summary,
group_name,unix_group_name
FROM news_bytes,groups
WHERE is_approved=2
AND news_bytes.group_id=groups.group_id
AND post_date > '$old_date'
ORDER BY post_date
";
$sql_approved = "
SELECT groups.group_id,id,post_date,summary,
group_name,unix_group_name
FROM news_bytes,groups
WHERE is_approved=1
AND news_bytes.group_id=groups.group_id
AND post_date > '$old_date'
ORDER BY post_date
";
show_news_approve_form(
$sql_pending,
$sql_rejected,
$sql_approved
);
}
news_footer(array());
} else {
exit_error($Language->getText('general','permdenied'),$Language->getText('news_admin','permdenied',$GLOBALS['sys_name']));
}
?>