mods/adobe_connect/lib/lib.php

   1 <?php
   2
   3
   4     function getAdobeConnectConfig() {
   5
   6         global $db;
   7
   8         $str = 'adobe_connect_adminuser,adobe_connect_adminpass,adobe_connect_folderid,adobe_connect_host,adobe_connect_port';
   9
  10         $configsql = "SELECT name, value
  11                       FROM ".TABLE_PREFIX."config
  12                       WHERE name LIKE 'adobe_connect_%'
  13                       ORDER BY name ASC";
  14         $config = mysql_query($configsql, $db);
  15
  16         while ($cfg = @mysql_fetch_assoc($config)) {
  17
  18             if (strstr($str, $cfg['name']) != false) {
  19                 $name = $cfg["name"];
  20                 $value = $cfg["value"];
  21                 $data->$name = $value;
  22             }
  23         }
  24
  25         if (empty($data)) {
  26             return false;
  27         }
  28
  29         return $data;
  30     }
  31
  32
  33     function getMemberData() {
  34
  35         global $db;
  36
  37         $memberid = $_SESSION['member_id'];
  38
  39         $membersql = "SELECT member_id, login, first_name, second_name, last_name
  40                       FROM ".TABLE_PREFIX."members
  41                       WHERE member_id = '$memberid'";
  42         $members = mysql_query($membersql, $db);
  43
  44         while ($member = @mysql_fetch_assoc($members)) {
  45             $memberdata->member_id = $member["member_id"];
  46             $memberdata->login = $member["login"];
  47             $memberdata->first_name = $member["first_name"];
  48             $memberdata->second_name = $member["second_name"];
  49             $memberdata->last_name = $member["last_name"];
  50         }
  51
  52         if (empty($memberdata)) {
  53             return false;
  54         }
  55
  56         return $memberdata;
  57     }
  58
  59
  60     function getMemberCourseAssign() {
  61
  62         global $db;
  63
  64         $memberid = $_SESSION['member_id'];
  65         $courseid = $_SESSION['course_id'];
  66
  67         $assignsql = "SELECT privileges, role
  68                       FROM ".TABLE_PREFIX."course_enrollment
  69                       WHERE member_id = '$memberid' AND course_id = '$courseid' AND approved = 'y'
  70                       ORDER BY role ASC";
  71         $assigns = mysql_query($assignsql, $db);
  72
  73         while ($assign = @mysql_fetch_assoc($assigns)) {
  74             if ($assign['role'] == 'Instructor') {
  75                 $assigndata->role = strtolower($assign['role']);
  76             } else {
  77                 $assigndata->role = 'student';
  78             }
  79             $assigndata->privileges = $assign['privileges'];
  80         }
  81
  82         if (empty($assigndata)) {
  83             return false;
  84         }
  85
  86         return $assigndata;
  87     }
  88
  89
  90 ?>