2 /****************************************************************/
\r
4 /****************************************************************/
\r
5 /* Copyright (c) 2002-2010 */
\r
6 /* Inclusive Design Institute */
\r
7 /* http://atutor.ca */
\r
9 /* This program is free software. You can redistribute it and/or*/
\r
10 /* modify it under the terms of the GNU General Public License */
\r
11 /* as published by the Free Software Foundation. */
\r
12 /****************************************************************/
\r
16 define('AT_INCLUDE_PATH', '../../../include/');
\r
17 require(AT_INCLUDE_PATH.'vitals.inc.php');
\r
18 authenticate(AT_PRIV_ANNOUNCEMENTS);
\r
20 if (isset($_GET['edit'], $_GET['aid'])) {
\r
21 header('Location: '.AT_BASE_HREF.'mods/_standard/announcements/edit_news.php?aid='.intval($_GET['aid']));
\r
23 } else if (isset($_GET['delete'], $_GET['aid'])) {
\r
24 header('Location: '.AT_BASE_HREF.'mods/_standard/announcements/delete_news.php?aid='.intval($_GET['aid']));
\r
26 } else if ((isset($_GET['edit']) || isset($_GET['delete']))) {
\r
27 $msg->addError('NO_ITEM_SELECTED');
\r
30 require(AT_INCLUDE_PATH.'header.inc.php');
\r
32 $orders = array('asc' => 'desc', 'desc' => 'asc');
\r
33 $cols = array('title' => 1, 'date' => 1);
\r
35 if (isset($_GET['asc'])) {
\r
37 $col = isset($cols[$_GET['asc']]) ? $_GET['asc'] : 'date';
\r
38 } else if (isset($_GET['desc'])) {
\r
40 $col = isset($cols[$_GET['desc']]) ? $_GET['desc'] : 'date';
\r
47 $sql = "SELECT news_id, title, date FROM ".TABLE_PREFIX."news WHERE course_id=$_SESSION[course_id] ORDER BY $col $order";
\r
48 $result = mysql_query($sql, $db);
\r
50 $savant->assign('result', $result);
\r
51 $savant->assign('col', $col);
\r
52 $savant->assign('order', $order);
\r
53 $savant->assign('orders', $orders);
\r
54 $savant->display('instructor/announcements/index.tmpl.php');
\r
55 require(AT_INCLUDE_PATH.'footer.inc.php'); ?>