removed mods directory from the ATutor codebase
[atutor.git] / mods / assignment_dropbox / sublinks.php
diff --git a/mods/assignment_dropbox/sublinks.php b/mods/assignment_dropbox/sublinks.php
deleted file mode 100644 (file)
index 93f0351..0000000
+++ /dev/null
@@ -1,62 +0,0 @@
-<?php
-
-if (!defined('AT_INCLUDE_PATH')) { exit; }
-
-/*****
-* Free form PHP can appear here to retreive current information
-* from the module, or a text description of the module where there is
-* not current information
-*****/
-
-global $db;
-
-$link_limit = 2;               // Number of links to be displayed on "detail view" box
-
-$groups_list = implode(',',$_SESSION['groups']);
-
-$sql = '';
-if (authenticate(AT_PRIV_ASSIGNMENTS, AT_PRIV_RETURN)) { // instructor
-       $file_storage_assignments = array();
-       $sql = "SELECT * FROM ".TABLE_PREFIX."assignments WHERE course_id=$_SESSION[course_id] ORDER BY date_due DESC";
-} else { // students
-       if ($groups_list <> '') {
-               $sql = "(SELECT a.title, date_due
-                  FROM ".TABLE_PREFIX."groups_types gt, ".TABLE_PREFIX."groups g, ".TABLE_PREFIX."assignments a
-                 WHERE g.group_id in (".$groups_list.")
-                   AND g.group_id in (SELECT group_id FROM ".TABLE_PREFIX."file_storage_groups)
-                   AND g.type_id = gt.type_id
-                   AND gt.course_id = $_SESSION[course_id]
-                   AND gt.type_id = a.assign_to
-                   AND (a.date_cutoff=0 OR UNIX_TIMESTAMP(a.date_cutoff) > ".time()."))
-               UNION
-               ";
-       }
-       $sql .= "(SELECT title, date_due
-                  FROM ".TABLE_PREFIX."assignments 
-                 WHERE assign_to=0 
-                   AND course_id=$_SESSION[course_id] 
-                   AND (date_cutoff=0 OR UNIX_TIMESTAMP(date_cutoff) > ".time()."))
-               ORDER BY date_due DESC";
-}
-$sql .= " LIMIT $link_limit";
-$result = mysql_query($sql, $db);
-
-if (mysql_num_rows($result) > 0) {
-       while ($row = mysql_fetch_assoc($result)) {
-               /****
-               * SUBLINK_TEXT_LEN, VALIDATE_LENGTH_FOR_DISPLAY are defined in include/lib/constance.lib.inc
-               * SUBLINK_TEXT_LEN determins the maxium length of the string to be displayed on "detail view" box.
-               *****/
-               $title = $row['title'] . ' ('._AT("due_date").': '.$row['date_due'].')';
-               $list[] = '<a href="'.AT_BASE_HREF.'mods/assignment_dropbox/index.php">'. 
-                         $title .'</a>';
-//             $list[] = '<a href="mods/assignment_dropbox/index.php"'.
-//                       (strlen($row['value']) > SUBLINK_TEXT_LEN ? ' title="'.$row['value'].'"' : '') .'>'. 
-//                       validate_length($row['value'], SUBLINK_TEXT_LEN, VALIDATE_LENGTH_FOR_DISPLAY) .'</a>';
-       }
-       return $list;   
-} else {
-       return 0;
-}
-
-?>
\ No newline at end of file