mods/_standard/farchive/index_instructor.php

   1 <?php
   2 define('AT_INCLUDE_PATH', '../../../include/');
   3 require (AT_INCLUDE_PATH.'vitals.inc.php');
   4
   5
   6
   7 $sql = "SELECT forum_id, title FROM ".TABLE_PREFIX."forums";
   8 $result = mysql_query($sql) or die(mysql_error());
   9
  10 if (mysql_num_rows($result) == 0) {
  11     $msg->addInfo('NO_FORUMS');
  12     require (AT_INCLUDE_PATH.'header.inc.php');
  13     exit;
  14 }
  15
  16 require (AT_INCLUDE_PATH.'header.inc.php');
  17 ?>
  18
  19 <form name='forumExp' action='send_zip_archive.php' method='post'>
  20     <div class='input-form'>
  21         <div class='row'>
  22             <h3><?php echo _AT('farchive_select_forum'); ?></h3>
  23         </div>
  24         <div class='row'>
  25             <select name='selForum' id='selForum'>
  26
  27
  28                 <?php
  29
  30                 $course_id = $_SESSION['course_id'];
  31
  32                 // ---Get course forums for the specific course id
  33
  34                 $courseOptions = "";
  35                 $sql = "SELECT forum_id FROM ".TABLE_PREFIX."forums_courses WHERE course_id='".$course_id."'";
  36                 $result = mysql_query($sql) or die(mysql_error());
  37
  38                 while ($fid = mysql_fetch_row($result)) {
  39
  40                     $sql = "SELECT title FROM ".TABLE_PREFIX."forums WHERE forum_id='".$fid[0]."'";
  41                     $result2 = mysql_query($sql) or die(mysql_error());
  42
  43                     while ($row = mysql_fetch_row($result2)) {
  44                         $courseOptions .= "<option value='".$fid[0]."'>".$row[0]."</option>";
  45                     }
  46                 }
  47
  48                 if ($courseOptions != "") {
  49                     print "<optgroup label='Course Forums'>";
  50                     print $courseOptions;
  51                     print "</optgroup>";
  52                 }
  53
  54
  55                 // ---Get group forums for the specific course id
  56
  57                 $groupOptions = "";
  58
  59                 // get type_id(s) for this course
  60                 $sql = "SELECT type_id FROM ".TABLE_PREFIX."groups_types WHERE course_id='".$course_id."'";
  61                 $result = mysql_query($sql) or die(msyql_error());
  62
  63                 while ($type_id = mysql_fetch_row($result)) {
  64
  65                     // get group_id(s) for each type
  66                     $sql = "SELECT group_id, title FROM ".TABLE_PREFIX."groups WHERE type_id='".$type_id[0]."'";
  67                     $result2 = mysql_query($sql) or die(mysql_error());
  68
  69                     while ($group_id = mysql_fetch_row($result2)) {
  70
  71                         // get forum_id for each group
  72                         $sql = "SELECT forum_id FROM ".TABLE_PREFIX."forums_groups WHERE group_id='".$group_id[0]."'";
  73                         $result3 = mysql_query($sql) or die(mysql_error());
  74
  75                         while ($fid = mysql_fetch_row($result3)) {
  76
  77                             // get forum title for this fid
  78                             $sql = "SELECT title FROM ".TABLE_PREFIX."forums WHERE forum_id='".$fid[0]."'";
  79                             $result4 = mysql_query($sql) or die(mysql_error());
  80                             $row = mysql_fetch_row($result4);
  81
  82                             $groupOptions .= "<option value='".$fid[0]."'>".$group_id[1]."</option>";
  83                         }
  84                     }
  85                 }
  86
  87                 if ($groupOptions != "") {
  88                     print "<optgroup label='Group Forums'>";
  89                     print $groupOptions;
  90                     print "</optgroup>";
  91                 }
  92
  93                 ?>
  94
  95             </select>
  96         </div>
  97         <div class='row buttons'>
  98             <input type='hidden' name='forumID' id='forumID' />
  99             <input type='button' class='button input' id='btnExportFrm' name='btnExportFrm' value='<?php echo _AT('farchive_export'); ?>' onclick='submForm()' />
 100         </div>
 101     </div>
 102 </form>
 103
 104 <?php require (AT_INCLUDE_PATH.'footer.inc.php'); ?>
 105
 106 <script language='javascript' type='text/javascript'>
 107
 108 var selSize = document.getElementById('selForum');
 109 if (selSize.length+2 < 10) {
 110     selSize.size = selSize.length+2;
 111 } else {
 112     selSize.size = 10;
 113 }
 114
 115 function submForm() {
 116     var frm = document.getElementById('selForum');
 117     var id = frm.options[frm.selectedIndex].value;
 118     var title = frm.options[frm.selectedIndex].text;
 119     document.forms[0].action = 'mods/_standard/farchive/send_zip_archive.php?fid='+id+'&title='+title;
 120     document.forms[0].submit();
 121 }
 122 </script>
 123
 124