*/ function forums_news() { require_once(AT_INCLUDE_PATH.'../mods/_standard/forums/lib/forums.inc.php'); global $db, $enrolled_courses, $system_courses; $news = array(); if ($enrolled_courses == ''){ return $news; } $sql = 'SELECT E.approved, E.last_cid, C.* FROM '.TABLE_PREFIX.'course_enrollment E, '.TABLE_PREFIX.'courses C WHERE E.member_id=1 AND E.course_id=C.course_id ORDER BY C.title'; $result = mysql_query($sql, $db); if ($result) { while($row = mysql_fetch_assoc($result)){ $all_forums = get_forums($row['course_id']); if (is_array($all_forums)){ foreach($all_forums as $forums){ if (is_array($forums)){ foreach ($forums as $forum_obj){ $forum_obj['course_id'] = $row['course_id']; $link_title = $forum_obj['title']; $news[] = array('time'=>$forum_obj['last_post'], 'object'=>$forum_obj, 'alt'=>_AT('forum'), 'thumb'=>'images/pin.png', 'course'=>$system_courses[$row['course_id']]['title'], 'link'=>' SUBLINK_TEXT_LEN ? ' title="'.AT_print($link_title, 'forums.title').'"' : '') .'>'. AT_print(validate_length($link_title, SUBLINK_TEXT_LEN, VALIDATE_LENGTH_FOR_DISPLAY), 'forums.title') .''); } } } } } } return $news; } ?>