2 /***********************************************************************/
4 /***********************************************************************/
5 /* Copyright (c) 2002-2010 */
6 /* Inclusive Design Institute */
9 /* This program is free software. You can redistribute it and/or */
10 /* modify it under the terms of the GNU General Public License */
11 /* as published by the Free Software Foundation. */
12 /***********************************************************************/
15 * Get the latest updates of this module
16 * @return list of news, [timestamp]=>
18 function announcements_news() {
19 global $db, $enrolled_courses, $system_courses;
22 if ($enrolled_courses == ''){
26 $sql = 'SELECT * FROM '.TABLE_PREFIX.'news WHERE course_id IN '.$enrolled_courses.' ORDER BY date DESC';
27 $result = mysql_query($sql, $db);
29 while($row = mysql_fetch_assoc($result)){
30 $news[] = array('time'=>$row['date'],
32 'alt'=>_AT('announcements'),
33 'course'=>$system_courses[$row['course_id']]['title'],
34 'thumb'=>'images/flag_blue.png',
35 'link'=>$row['body']);