3 This is the ATutor webcalendar module page. It allows an admin user
\r
4 to set or edit the URL for the webcalendar installation for ATutor, and
\r
5 it includes the launcher, which opens webcalendar in a new window
\r
8 define('AT_INCLUDE_PATH', '../../include/');
\r
9 require (AT_INCLUDE_PATH.'vitals.inc.php');
\r
11 if($_REQUEST['saved_webcalendar_url'] == 1){
\r
12 if($_REQUEST['webcalendar_url'] == ''){
\r
13 $msg->addError('WEBCALENDAR_URL_ADD_EMPTY');
\r
15 $webcalendar_url = addslashes(stripslashes($_REQUEST['webcalendar_url']));
\r
16 $sql = "INSERT INTO ".TABLE_PREFIX."config VALUES('webcalendar', '".$webcalendar_url."')";
\r
17 if(!$result = mysql_query($sql)){
\r
18 $msg->addError('WEBCALENDAR_URL_ADD_FAILED');
\r
20 $msg->addFeedback('WEBCALENDAR_URL_ADD_SAVED');
\r
25 if($_REQUEST['edited_webcalendar_url'] == 1){
\r
26 if($_REQUEST['webcalendar_url'] == ''){
\r
27 $msg->addError('WEBCALENDAR_URL_ADD_EMPTY');
\r
28 // $_POST['edit_webcalendar_url'] = 1;
\r
31 $webcalendar_url = addslashes(stripslashes($_REQUEST['webcalendar_url']));
\r
32 $sql = "UPDATE ".TABLE_PREFIX."config SET value='".$webcalendar_url."' WHERE name = 'webcalendar'";
\r
33 if(!$result = mysql_query($sql)){
\r
34 $msg->addError('WEBCALENDAR_URL_ADD_FAILED');
\r
36 $msg->addFeedback('WEBCALENDAR_URL_ADD_SAVED');
\r
41 if($_REQUEST['webcalendar_sync'] == 1){
\r
42 //populate the webcal_user table with ATutor members
\r
43 $sql = "SELECT * from ".TABLE_PREFIX."members";
\r
44 $result = mysql_query($sql,$db);
\r
45 if(!$result3 = mysql_query($sql)){
\r
46 $msg->addError('WEBCALENDAR_UPDATE_MEMBERS_FAILED');
\r
48 $msg->addFeedback('WEBCALENDAR_UPDATE_MEMBERS_SAVED');
\r
50 while ($row = mysql_fetch_array($result)){
\r
51 $sql2 = "REPLACE INTO webcal_user VALUES ('$row[1]','".md5($row[2])."','$row[6]','$row[5]','N','$row[3]')";
\r
52 $result1 = mysql_query($sql2, $db);
\r
56 $sql = "SELECT * from ".TABLE_PREFIX."admins";
\r
57 if(!$result3 = mysql_query($sql)){
\r
58 $msg->addError('WEBCALENDAR_UPDATE_ADMINS_FAILED');
\r
60 $msg->addFeedback('WEBCALENDAR_UPDATE_ADMINS_SAVED');
\r
62 while ($row = mysql_fetch_array($result3)){
\r
63 $sql3 = "REPLACE INTO webcal_user VALUES ('$row[0]','".md5($row[1])."','$row[2]','','Y','$row[3]')";
\r
64 $result4 = mysql_query($sql3, $db);
\r
67 //populate the webcal_group table with ATutor courses
\r
68 $sql5 = "SELECT * FROM ".TABLE_PREFIX."courses";
\r
69 $result5 = mysql_query($sql5,$db);
\r
70 while ($row = mysql_fetch_array($result5)){
\r
71 $sql2 = "REPLACE INTO webcal_group VALUES ('$row[0]','".$row[1]."','$row[6]','$row[5]')";
\r
72 $result1 = mysql_query($sql2, $db);
\r
74 if(!$result1 = mysql_query($sql)){
\r
75 $msg->addError('WEBCALENDAR_UPDATE_GROUPS_FAILED');
\r
77 $msg->addFeedback('WEBCALENDAR_UPDATE_GROUPS_SAVED');
\r
80 //populate webcal_group_users users enrolled courses (i.e. groups)
\r
82 $sql6 = "SELECT * FROM ".TABLE_PREFIX."course_enrollment WHERE approved='y'";
\r
83 $result6 = mysql_query($sql6,$db);
\r
84 while ($row = mysql_fetch_array($result6)){
\r
86 $sql8 = "SELECT login FROM ".TABLE_PREFIX."members WHERE member_id='$row[0]'";
\r
87 $result8 = mysql_query($sql8,$db);
\r
88 while($row1 = mysql_fetch_array($result8)){
\r
89 $at_login_name = $row1[0];
\r
91 $sql2 = "REPLACE INTO webcal_group_user VALUES ('$row[1]','$at_login_name')";
\r
92 if(!$result7 = mysql_query($sql2)){
\r
93 $msg->addError('WEBCALENDAR_UPDATE_GROUPMEMS_FAILED');
\r
95 $msg->addFeedback('WEBCALENDAR_UPDATE_GROUPMEMS_SAVED');
\r
103 //Check to see if the url to webcalendar exists in the db
\r
104 $sql = 'SELECT * from '.TABLE_PREFIX.'config WHERE name="webcalendar"';
\r
105 $result = mysql_query($sql, $db);
\r
107 while($row = mysql_fetch_array($result)){
\r
108 $webcalendar_url_db = $row[1];
\r
111 require (AT_INCLUDE_PATH.'header.inc.php');
\r
113 if($webcalendar_url_db == '' || $_POST['edit_webcalendar_url']){
\r
116 <div class="input-form">
\r
118 <p><?php echo _AT('webcalendar_add_url'); ?>
\r
120 <div class="row buttons">
\r
121 <form action="<?php $_SERVER['PHP_SELF']?>" method="post">
\r
123 <?php if($_POST['edit_webcalendar_url']){ ?>
\r
124 <input type="hidden" name="edited_webcalendar_url" value="1">
\r
126 <input type="hidden" name="saved_webcalendar_url" value="1">
\r
128 <?php if($_POST['edit_webcalendar_url']){ ?>
\r
129 <input type="text" name="webcalendar_url" value="<?php echo $webcalendar_url_db; ?>" size="80" length="150" />
\r
131 <input type="text" name="webcalendar_url" value="<?php echo $webcalendar_url; ?>" size="80" length="150" />
\r
134 <input type="submit" value="<?php echo _AT('webcalendar_save'); ?>" style="botton">
\r
142 <div class="input-form">
\r
144 <p><?php echo _AT('webcalendar_sync'); ?></p>
\r
145 <p> <strong><?php echo $webcalendar_sync; ?> </strong> </p>
\r
146 <div class="row buttons">
\r
147 <form action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
\r
148 <input type="hidden" name="webcalendar_sync" value="1">
\r
149 <input type="submit" value="<?php echo _AT('webcalendar_sync_button'); ?>" style="botton">
\r
154 <div class="input-form">
\r
156 <p><?php echo _AT('webcalendar_location'); ?></p>
\r
157 <p> <strong><?php echo $webcalendar_url_db; ?> </strong> </p>
\r
158 <div class="row buttons">
\r
159 <form action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
\r
160 <input type="hidden" name="edit_webcalendar_url" value="1">
\r
161 <input type="submit" value="<?php echo _AT('webcalendar_edit'); ?>" style="botton">
\r
168 <div class="input-form">
\r
180 require (AT_INCLUDE_PATH.'footer.inc.php'); ?>