mods/_standard/faq/module_news.php

   1 <?php
   2 /***********************************************************************/
   3 /* ATutor                                                                                                                          */
   4 /***********************************************************************/
   5 /* Copyright (c) 2002-2010                                             */
   6 /* Inclusive Design Institute                                          */
   7 /* http://atutor.ca                                                                                                        */
   8 /*                                                                                                                                         */
   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 /***********************************************************************/
  13 // $Id$
  14 /*
  15  * Get the latest updates of this module
  16  * @return list of news, [timestamp]=>
  17  */
  18 function faq_news() {
  19     global $db, $enrolled_courses, $system_courses;
  20     $news = array();
  21
  22     if ($enrolled_courses == ''){
  23         return $news;
  24     }
  25
  26     $sql = "SELECT * FROM ".TABLE_PREFIX."faq_topics T INNER JOIN ".TABLE_PREFIX."faq_entries E ON T.topic_id = E.topic_id WHERE T.course_id IN $enrolled_courses ORDER BY E.revised_date DESC";
  27     $result = mysql_query($sql, $db);
  28     if($result){
  29         while($row = mysql_fetch_assoc($result)){
  30             $news[] = array('time'=>$row['revised_date'],
  31             'alt'=>_AT('faq'),'object'=>$row,
  32             'course'=>$system_courses[$row['course_id']]['title'],
  33             'thumb'=>'images/home-faq_sm.png',
  34             'link'=>'<a href="bounce.php?course='.$row['course_id'].'&p='.urlencode('mods/_standard/faq/index.php#'.$row['entry_id']).'"'.
  35             (strlen($row['question']) > SUBLINK_TEXT_LEN ? ' title="'.AT_print($row['question'], 'faqs.question').'"' : '') .'>'.
  36             AT_print(validate_length($row['question'], SUBLINK_TEXT_LEN, VALIDATE_LENGTH_FOR_DISPLAY), 'faqs.question') .'</a>');
  37         }
  38     }
  39     return $news;
  40 }
  41
  42 ?>