mods/calendar/admin_cal.php

   1 <?php\r
   2 /*\r
   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
   6 \r
   7 */\r
   8 define('AT_INCLUDE_PATH', '../../include/');\r
   9 require (AT_INCLUDE_PATH.'vitals.inc.php');\r
  10 \r
  11 if($_REQUEST['saved_webcalendar_url'] == 1){\r
  12         if($_REQUEST['webcalendar_url'] == ''){\r
  13                         $msg->addError('WEBCALENDAR_URL_ADD_EMPTY');\r
  14         }else{\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
  19                 }else{\r
  20                         $msg->addFeedback('WEBCALENDAR_URL_ADD_SAVED');\r
  21                 }\r
  22         }\r
  23 }\r
  24 \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
  29                         \r
  30         }else{\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
  35                 }else{\r
  36                         $msg->addFeedback('WEBCALENDAR_URL_ADD_SAVED');\r
  37                 }\r
  38         }\r
  39 }\r
  40 \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
  47         }else{\r
  48                 $msg->addFeedback('WEBCALENDAR_UPDATE_MEMBERS_SAVED');\r
  49         }\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
  53         }\r
  54 \r
  55 \r
  56         $sql = "SELECT * from ".TABLE_PREFIX."admins";\r
  57         if(!$result3 = mysql_query($sql)){\r
  58                 $msg->addError('WEBCALENDAR_UPDATE_ADMINS_FAILED');\r
  59         }else{\r
  60                 $msg->addFeedback('WEBCALENDAR_UPDATE_ADMINS_SAVED');\r
  61         }\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
  65         }\r
  66 \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
  73         }\r
  74         if(!$result1 = mysql_query($sql)){\r
  75                 $msg->addError('WEBCALENDAR_UPDATE_GROUPS_FAILED');\r
  76         }else{\r
  77                 $msg->addFeedback('WEBCALENDAR_UPDATE_GROUPS_SAVED');\r
  78         }\r
  79 \r
  80         //populate webcal_group_users users enrolled courses (i.e. groups) \r
  81 \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
  85 \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
  90                 }\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
  94                 }else{\r
  95                         $msg->addFeedback('WEBCALENDAR_UPDATE_GROUPMEMS_SAVED');\r
  96                 }\r
  97         }\r
  98 \r
  99 \r
 100 }\r
 101 \r
 102 //////////\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
 106 \r
 107 while($row = mysql_fetch_array($result)){\r
 108         $webcalendar_url_db = $row[1];\r
 109 }\r
 110 \r
 111 require (AT_INCLUDE_PATH.'header.inc.php');\r
 112 \r
 113 if($webcalendar_url_db == '' || $_POST['edit_webcalendar_url']){ \r
 114 \r
 115 ?>\r
 116                 <div class="input-form">\r
 117                 <div class="row">\r
 118                         <p><?php echo _AT('webcalendar_add_url'); ?>\r
 119                 </p>\r
 120                         <div class="row buttons">\r
 121                         <form action="<?php $_SERVER['PHP_SELF']?>" method="post">\r
 122 \r
 123                         <?php if($_POST['edit_webcalendar_url']){ ?>\r
 124                                 <input type="hidden" name="edited_webcalendar_url" value="1">\r
 125                         <?php }else{ ?>\r
 126                                 <input type="hidden" name="saved_webcalendar_url" value="1">\r
 127                         <?php } ?>\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
 130                                 <?php }else{ ?>\r
 131                                 <input type="text" name="webcalendar_url" value="<?php echo $webcalendar_url; ?>" size="80" length="150" />\r
 132                         \r
 133                         <?php } ?>      \r
 134                         <input type="submit" value="<?php echo _AT('webcalendar_save'); ?>" style="botton">\r
 135                         </form>\r
 136                         </div>\r
 137                 </div>\r
 138                 </div>\r
 139 \r
 140 <?php }else{?>\r
 141 \r
 142                 <div class="input-form">\r
 143                 <div class="row">\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
 150                         </form>\r
 151                         </div>\r
 152                 </div>\r
 153                 </div>\r
 154                 <div class="input-form">\r
 155                 <div class="row">\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
 162                         </form>\r
 163                         </div>\r
 164                 </div>\r
 165                 </div>\r
 166 \r
 167 \r
 168                 <div class="input-form">\r
 169                 <div class="row">\r
 170 \r
 171 \r
 172 \r
 173 \r
 174 <?php } \r
 175 \r
 176 ?>\r
 177 \r
 178 <?php \r
 179 \r
 180  require (AT_INCLUDE_PATH.'footer.inc.php'); ?>