PageRenderTime 61ms CodeModel.GetById 29ms RepoModel.GetById 1ms app.codeStats 0ms

/admin/options.php

https://github.com/xmarcosx/enroll
PHP | 816 lines | 807 code | 0 blank | 9 comment | 32 complexity | 113cc203b986a38977ddf56c0d4d7384 MD5 | raw file
    

  1. <?php
    2. 

  2.   session_start();
    3. 

  3.   //Credentials aren't legit or user isn't an admin, kick back to login screen
    4. 

  4.   if (!isset($_SESSION['username']) || 
    5. 

  5.     $_SESSION['login']!=true || 
    6. 

  6.     $_SESSION['admin']!=true) {
    7. 

  7.       header("Location: ../login.html");
    8. 

  8.   }
    9. 

  9.   //Code to connect to database
    10. 

  10.   include_once 'settings.php';
    11. 

  11.   //Connects to MySQL and Selects Database
    12. 

  12.   $con = mysql_connect($host,$db_username,$db_password);
    13. 

  13.   if (!$con)
    14. 

  14.     die('Could not connect: ' . mysql_error());
    15. 

  15.   //Select DB
    16. 

  16.   mysql_select_db($db, $con);
    17. 

  17.   //Ghost usernames
    18. 

  18.   $ghost_usernames=array();
    19. 

  19.   $teacher_usernames=array();
    20. 

  20.   $get_ghost_usernames=mysql_query(
    21. 

  21.     "SELECT username,role FROM users WHERE role='teacher' OR role='student'") or die(mysql_error());
    22. 

  22.   while($row=mysql_fetch_array($get_ghost_usernames)){
    23. 

  23.     $ghost_usernames[]="\"" . $row['username'] . "\"";
    24. 

  24.     if(strcmp($row['role'], 'student')!=0){
    25. 

  25.       $teacher_usernames[]="\"" . $row['username'] . "\"";
    26. 

  26.     }
    27. 

  27.   }
    28. 

  28.   //Handle form updates
    29. 

  29.   $status=null;
    30. 

  30.   if($_SERVER['REQUEST_METHOD'] == "POST"){
    31. 

  31.     if(isset($_POST['gradyears'])){
    32. 

  32.       $post_freshman=mysql_real_escape_string($_POST['freshman']);
    33. 

  33.       $post_sophomore=mysql_real_escape_string($_POST['sophomore']);
    34. 

  34.       $post_junior=mysql_real_escape_string($_POST['junior']);
    35. 

  35.       $post_senior=mysql_real_escape_string($_POST['senior']);
    36. 

  36.       if(mysql_query("UPDATE settings 
    37. 

  37.                          SET freshman='$post_freshman',sophomore='$post_sophomore',
    38. 

  38.                          junior='$post_junior',senior='$post_senior'
    39. 

  39.                          WHERE id=1 LIMIT 1") or die(mysql_error()))
    40. 

  40.       {
    41. 

  41.         $status=1;
    42. 

  42.       }
    43. 

  43.       else{
    44. 

  44.         $status=0;
    45. 

  45.       }
    46. 

  46.     }
    47. 

  47.     elseif(isset($_POST['sem1times'])){
    48. 

  48.       $post_freshman=mysql_real_escape_string($_POST['freshman']);
    49. 

  49.       $post_sophomore=mysql_real_escape_string($_POST['sophomore']);
    50. 

  50.       $post_junior=mysql_real_escape_string($_POST['junior']);
    51. 

  51.       $post_senior=mysql_real_escape_string($_POST['senior']);
    52. 

  52.       $post_end=mysql_real_escape_string($_POST['end']);
    53. 

  53.       if(mysql_query("UPDATE settings 
    54. 

  54.                          SET col1_freshman_start='$post_freshman',col1_sophomore_start='$post_sophomore',
    55. 

  55.                          col1_junior_start='$post_junior',col1_senior_start='$post_senior',col1_end='$post_end'
    56. 

  56.                          WHERE id=1 LIMIT 1") or die(mysql_error()))
    57. 

  57.       {
    58. 

  58.         $status=1;
    59. 

  59.       }
    60. 

  60.       else{
    61. 

  61.         $status=0;
    62. 

  62.       }
    63. 

  63.     }
    64. 

  64.     elseif(isset($_POST['sem2times'])){
    65. 

  65.       $post_freshman=mysql_real_escape_string($_POST['freshman']);
    66. 

  66.       $post_sophomore=mysql_real_escape_string($_POST['sophomore']);
    67. 

  67.       $post_junior=mysql_real_escape_string($_POST['junior']);
    68. 

  68.       $post_senior=mysql_real_escape_string($_POST['senior']);
    69. 

  69.       $post_end=mysql_real_escape_string($_POST['end']);
    70. 

  70.       if(mysql_query("UPDATE settings 
    71. 

  71.                          SET col2_freshman_start='$post_freshman',col2_sophomore_start='$post_sophomore',
    72. 

  72.                          col2_junior_start='$post_junior',col2_senior_start='$post_senior',col2_end='$post_end'
    73. 

  73.                          WHERE id=1 LIMIT 1") or die(mysql_error()))
    74. 

  74.       {
    75. 

  75.         $status=1;
    76. 

  76.       }
    77. 

  77.       else{
    78. 

  78.         $status=0;
    79. 

  79.       }
    80. 

  80.     }
    81. 

  81.     elseif(isset($_POST['xytimes'])){
    82. 

  82.       $xy_num_days_open=mysql_real_escape_string($_POST['xy_num_days_open']);
    83. 

  83.       $xy_time_open=mysql_real_escape_string($_POST['xy_time_open']);
    84. 

  84.       $xy_num_days_close=mysql_real_escape_string($_POST['xy_num_days_close']);
    85. 

  85.       $xy_time_close=mysql_real_escape_string($_POST['xy_time_close']);
    86. 

  86.       if(mysql_query("UPDATE settings 
    87. 

  87.                          SET xy_num_days_open='$xy_num_days_open',xy_time_open='$xy_time_open',
    88. 

  88.                          xy_num_days_close='$xy_num_days_close',xy_time_close='$xy_time_close'
    89. 

  89.                          WHERE id=1 LIMIT 1") or die(mysql_error()))
    90. 

  90.       {
    91. 

  91.         $status=1;
    92. 

  92.       }
    93. 

  93.       else{
    94. 

  94.         $status=0;
    95. 

  95.       }
    96. 

  96.     }
    97. 

  97.     elseif(isset($_POST['add_schedule'])){
    98. 

  98.       $date=mysql_real_escape_string($_POST['date']);
    99. 

  99.       $colloquium=mysql_real_escape_string($_POST['colloquium']);
    100. 

  100.       if($colloquium!=1)
    101. 

  101.         $colloquium=0;
    102. 

  102.       $x=mysql_real_escape_string($_POST['x']);
    103. 

  103.       if($x!=1)
    104. 

  104.         $x=0;
    105. 

  105.       $y=mysql_real_escape_string($_POST['y']);
    106. 

  106.       if($y!=1)
    107. 

  107.         $y=0;
    108. 

  108.       if(mysql_query("INSERT INTO course_schedule(date,colloquium,x,y) 
    109. 

  109.                       VALUES('$date','$colloquium','$x','$y')") or die(mysql_error()))
    110. 

  110.       {
    111. 

  111.         $status=1;
    112. 

  112.       }
    113. 

  113.       else{
    114. 

  114.         $status=0;
    115. 

  115.       }
    116. 

  116.     }
    117. 

  117.     elseif(isset($_POST['update_schedule'])){
    118. 

  118.       $id=mysql_real_escape_string($_POST['id']);
    119. 

  119.       $date=mysql_real_escape_string($_POST['date']);
    120. 

  120.       $colloquium=mysql_real_escape_string($_POST['colloquium']);
    121. 

  121.       if($colloquium!=1)
    122. 

  122.         $colloquium=0;
    123. 

  123.       $x=mysql_real_escape_string($_POST['x']);
    124. 

  124.       if($x!=1)
    125. 

  125.         $x=0;
    126. 

  126.       $y=mysql_real_escape_string($_POST['y']);
    127. 

  127.       if($y!=1)
    128. 

  128.         $y=0;
    129. 

  129.       if(mysql_query("UPDATE course_schedule 
    130. 

  130.                       SET date='$date',colloquium='$colloquium',x='$x',y='$y'
    131. 

  131.                       WHERE id='$id' LIMIT 1") or die(mysql_error()))
    132. 

  132.       {
    133. 

  133.         $status=1;
    134. 

  134.       }
    135. 

  135.       else{
    136. 

  136.         $status=0;
    137. 

  137.       }
    138. 

  138.     }
    139. 

  139.     elseif(isset($_POST['quarter_button'])){
    140. 

  140.       $quarter1=mysql_real_escape_string($_POST['quarter1']);
    141. 

  141.       $quarter2=mysql_real_escape_string($_POST['quarter2']);
    142. 

  142.       $quarter3=mysql_real_escape_string($_POST['quarter3']);
    143. 

  143.       $quarter4=mysql_real_escape_string($_POST['quarter4']);
    144. 

  144.       if(mysql_query("UPDATE settings 
    145. 

  145.                       SET quarter_1_start='$quarter1',quarter_2_start='$quarter2',quarter_3_start='$quarter3',quarter_4_start='$quarter4'
    146. 

  146.                       WHERE id=1 LIMIT 1") or die(mysql_error()))
    147. 

  147.       {
    148. 

  148.         $status=1;
    149. 

  149.       }
    150. 

  150.       else{
    151. 

  151.         $status=0;
    152. 

  152.       }
    153. 

  153.     }
    154. 

  154.     elseif(isset($_POST['classrooms'])){
    155. 

  155.       $classrooms=mysql_real_escape_string($_POST['classrooms']);
    156. 

  156.       if(mysql_query("UPDATE settings 
    157. 

  157.                          SET rooms='$classrooms' WHERE id=1 LIMIT 1") or die(mysql_error()))
    158. 

  158.       {
    159. 

  159.         $status=1;
    160. 

  160.       }
    161. 

  161.       else{
    162. 

  162.         $status=0;
    163. 

  163.       }
    164. 

  164.     }
    165. 

  165.     elseif(isset($_POST['add_ghost_user'])){
    166. 

  166.       $username=mysql_real_escape_string($_POST['username']);
    167. 

  167.       $ghost_user=mysql_real_escape_string($_POST['ghost_user']);
    168. 

  168.       if(mysql_query("UPDATE users
    169. 

  169.                          SET ghost_user='$ghost_user' WHERE username='$username' LIMIT 1") or die(mysql_error()))
    170. 

  170.       {
    171. 

  171.         $status=1;
    172. 

  172.       }
    173. 

  173.       else{
    174. 

  174.         $status=0;
    175. 

  175.       }
    176. 

  176.     }
    177. 

  177.     elseif(isset($_POST['remove_ghost_user'])){
    178. 

  178.       $username=mysql_real_escape_string($_POST['username']);
    179. 

  179.       if(mysql_query("UPDATE users
    180. 

  180.                          SET ghost_user=NULL WHERE username='$username' LIMIT 1") or die(mysql_error()))
    181. 

  181.       {
    182. 

  182.         $status=1;
    183. 

  183.       }
    184. 

  184.       else{
    185. 

  185.         $status=0;
    186. 

  186.       }
    187. 

  187.     }
    188. 

  188.   }
    189. 

  189.   //Get Settings
    190. 

  190.   $get_settings_result=mysql_query(
    191. 

  191.     "SELECT * FROM settings LIMIT 1") or die(mysql_error());
    192. 

  192.   $get_settings_array=mysql_fetch_array($get_settings_result);
    193. 

  193.   $freshman=$get_settings_array['freshman'];
    194. 

  194.   $sophomore=$get_settings_array['sophomore'];
    195. 

  195.   $junior=$get_settings_array['junior'];
    196. 

  196.   $senior=$get_settings_array['senior'];
    197. 

  197.   //Get Course Schedule
    198. 

  198.   $get_course_schedule_result=mysql_query(
    199. 

  199.     "SELECT * FROM course_schedule") or die(mysql_error());
    200. 

  200.   //Get Ghost Users
    201. 

  201.   $get_ghost_users_result=mysql_query(
    202. 

  202.     "SELECT id,username,ghost_user FROM `users` WHERE ghost_user IS NOT NULL") or die(mysql_error());
    203. 

  203.   mysql_close();
    204. 

  204. ?>
    205. 

  205. <!DOCTYPE html>
    206. 

  206. <html lang='en'>
    207. 

  207.   <head>
    208. 

  208.     <meta charset='utf-8'>
    209. 

  209.     <title>Enroll: <?php echo $school_name; ?></title>
    210. 

  210.     <meta name='viewport' content='width=device-width, initial-scale=1.0'>
    211. 

  211.     <meta name='description' content="Flexible Scheduling for Today's Classroom">
    212. 

  212.     <meta name='author' content='Marcos Alcozer'>
    213. 

  213.     <meta name='keywords' content='Education, Scheduling'>
    214. 

  214.     <!-- CSS -->
    215. 

  215.     <style>
    216. 

  216.       body {
    217. 

  217.         padding-top: 60px; /* 60px to make the container go all the way to the bottom of the topbar */
    218. 

  218.       }
    219. 

  219.     </style>
    220. 

  220.     <link href="//netdna.bootstrapcdn.com/twitter-bootstrap/2.3.2/css/bootstrap-combined.min.css" rel="stylesheet">
    221. 

  221.     <link href="../css/bootstrap-datetimepicker.min.css" rel="stylesheet">
    222. 

  222.     <link href="../css/admin.css" rel="stylesheet">
    223. 

  223.     <!-- HTML5 shim, for IE6-8 support of HTML5 elements -->
    224. 

  224.     <!--[if lt IE 9]>
    225. 

  225.       <script src="../js/html5shiv.js"></script>
    226. 

  226.     <![endif]-->
    227. 

  227.   </head>
    228. 

  228. 

  229.   <body data-spy="scroll" data-target=".bs-docs-sidebar">
    230. 

  230.     <?php include_once("analyticstracking.php") ?>
    231. 

  231.     <div class="navbar navbar-inverse navbar-fixed-top">
    232. 

  232.       <div class="navbar-inner">
    233. 

  233.         <div class="container">
    234. 

  234.           <button type="button" class="btn btn-navbar" data-toggle="collapse" data-target=".nav-collapse">
    235. 

  235.             <span class="icon-bar"></span>
    236. 

  236.             <span class="icon-bar"></span>
    237. 

  237.             <span class="icon-bar"></span>
    238. 

  238.           </button>
    239. 

  239.           <a class="brand appname" href="#">Enroll<img src='../img/beta-icon.png' style="vertical-align:text-top;"/></a>
    240. 

  240.           <div class="nav-collapse collapse">
    241. 

  241.            <ul class="nav">
    242. 

  242.              <li><a href="index.php">Dashboard</a></li>
    243. 

  243.               <li class="dropdown">
    244. 

  244.                <a href="#" class="dropdown-toggle" data-toggle="dropdown">Approvals <b class="caret"></b></a>
    245. 

  245.                <ul class="dropdown-menu">
    246. 

  246.                  <li><a href='approvals_xy.php'>XY</a></li>
    247. 

  247.                    <li class="dropdown-submenu">
    248. 

  248.                        <a tabindex="-1" href="#">Colloquium</a>
    249. 

  249.                        <ul class="dropdown-menu">
    250. 

  250.                           <li><a href='approvals_col.php?semester=1'>Semester 1</a></li>
    251. 

  251.                           <li><a href='approvals_col.php?semester=2'>Semester 2</a></li>
    252. 

  252.                        </ul>
    253. 

  253.                    </li>
    254. 

  254.                </ul>
    255. 

  255.               </li>
    256. 

  256.               <li class="dropdown">
    257. 

  257.                <a href="#" class="dropdown-toggle" data-toggle="dropdown">Enrollments <b class="caret"></b></a>
    258. 

  258.                <ul class="dropdown-menu">
    259. 

  259.                  <li><a href='enroll_xy.php'>XY</a></li>
    260. 

  260.                    <li class="dropdown-submenu">
    261. 

  261.                        <a tabindex="-1" href="#">Colloquium</a>
    262. 

  262.                        <ul class="dropdown-menu">
    263. 

  263.                           <li><a href='enroll_col.php?semester=1'>Semester 1</a></li>
    264. 

  264.                           <li><a href='enroll_col.php?semester=2'>Semester 2</a></li>
    265. 

  265.                        </ul>
    266. 

  266.                    </li>
    267. 

  267.                </ul>
    268. 

  268.               </li>
    269. 

  269.               <li class="dropdown">
    270. 

  270.                <a href="#" class="dropdown-toggle" data-toggle="dropdown">Activity <b class="caret"></b></a>
    271. 

  271.                <ul class="dropdown-menu">
    272. 

  272.                  <li><a href='activity_xy.php'>XY</a></li>
    273. 

  273.                  <li><a href='activity_col.php'>Colloquium</a></li>
    274. 

  274.                </ul>
    275. 

  275.               </li>
    276. 

  276.                <?php if($_SESSION['teacher']){
    277. 

  277.                 echo "<li><a href='../teacher/agenda.php'>My Courses</a></li>";
    278. 

  278.                }?>
    279. 

  279.                <li class="active"><a href="options.php">Settings</a></li>
    280. 

  280.            </ul>
    281. 

  281.             <ul class="nav pull-right">
    282. 

  282.                 <li>
    283. 

  283.                 <form id="ghostuserform" class="navbar-form pull-right">
    284. 

  284.                   <input class="span2 search-query" name="username" type="text" 
    285. 

  285.                          data-provide="typeahead" autocomplete="off" placeholder="Login as..."
    286. 

  286.                          data-source='[<?php echo implode(',',$ghost_usernames); ?>]' />
    287. 

  287.                 </form>
    288. 

  288.               </li>
    289. 

  289.               <?php 
    290. 

  290.                 if(!isset($_SESSION['username']))
    291. 

  291.                   echo "<li class='login-button'><a href='../login.html' style='color:#FFFFFF'>Login</a></li>";
    292. 

  292.                 else
    293. 

  293.                   echo "<li class='login-button'><a href='../logout.php' style='color:#FFFFFF'>Logout</a></li>";
    294. 

  294.               ?>
    295. 

  295.             </ul>
    296. 

  296.           </div><!--/.nav-collapse -->
    297. 

  297.         </div>
    298. 

  298.       </div>
    299. 

  299.       <?php if(!$status && !is_null($status)) { ?>
    300. 

  300.       <div id="failed" class="alert alert-error text-center">
    301. 

  301.         <button type="button" class="close" data-dismiss="alert">&times;</button>
    302. 

  302.         Sorry, changes did not save.
    303. 

  303.       </div>
    304. 

  304.       <?php }else if($status && !is_null($status)) { ?>
    305. 

  305.       <div id="success" class="alert alert-info text-center">
    306. 

  306.         <button type="button" class="close" data-dismiss="alert">&times;</button>
    307. 

  307.         Changes saved successfully.
    308. 

  308.       </div>
    309. 

  309.       <?php } ?>
    310. 

  310.       <div id="status" class="alert alert-info text-center" style="display: none;">
    311. 

  311.         <button type="button" class="close" data-dismiss="alert">&times;</button>
    312. 

  312.         <span id="status_text"></span>
    313. 

  313.       </div>
    314. 

  314.     </div>
    315. 

  315.       <div class='container'>
    316. 

  316.         <div class="row">
    317. 

  317.           <div class="span2 bs-docs-sidebar hidden-phone hidden-tablet">
    318. 

  318.             <ul class="nav nav-list bs-docs-sidenav">
    319. 

  319.               <li><a href='#colloquiumstartend'><i class='icon-chevron-right'></i>Registration Start/End Times</a></li>
    320. 

  320.               <li><a href='#quarters'><i class='icon-chevron-right'></i>Quarter Start Dates</a></li>
    321. 

  321.               <li><a href='#schedule'><i class='icon-chevron-right'></i>Course Schedule</a></li>
    322. 

  322.               <li><a href='#classrooms'><i class='icon-chevron-right'></i>Available Classrooms</a></li>
    323. 

  323.               <li><a href='#graduation'><i class='icon-chevron-right'></i>Graduation Years</a></li>
    324. 

  324.               <li><a href='#ghost'><i class='icon-chevron-right'></i>Ghost Users</a></li>
    325. 

  325.               <li><a href='#sync'><i class='icon-chevron-right'></i>Sync Users</a></li>
    326. 

  326.             </ul>
    327. 

  327.         </div>
    328. 

  328.         <div class="span9 offset1">
    329. 

  329.           <section id="colloquiumstartend">
    330. 

  330.           <div class='page-header'>
    331. 

  331.             <h2>Colloquium Registration Start/End Times</h2>
    332. 

  332.           </div>
    333. 

  333.           <div class="row">
    334. 

  334.             <div class="span4">
    335. 

  335.               <h3>Semester 1</h3>
    336. 

  336.               <form class="form" action="#colloquiumstartend" method="post">
    337. 

  337.                 <div class="control-group">
    338. 

  338.                   <label class="control-label" for="inputCol1Freshman">Freshman Start Time</label>
    339. 

  339.                  <div class="input-append date controls datetimepicker">
    340. 

  340.                     <input data-format="yyyy-MM-dd hh:mm:ss" type="text" 
    341. 

  341.                            name="freshman" id="inputCol1Freshman" value="<?php echo $get_settings_array['col1_freshman_start']; ?>" required />
    342. 

  342.                     <span class="add-on">
    343. 

  343.                       <i data-time-icon="icon-time" data-date-icon="icon-calendar">
    344. 

  344.                       </i>
    345. 

  345.                     </span>
    346. 

  346.                   </div>
    347. 

  347.                 </div>
    348. 

  348.                 <div class="control-group">
    349. 

  349.                   <label class="control-label" for="inputCol1Sophomore">Sophomore Start Time</label>
    350. 

  350.                   <div class="input-append date controls datetimepicker">
    351. 

  351.                     <input data-format="yyyy-MM-dd hh:mm:ss" type="text" 
    352. 

  352.                            name="sophomore" id="inputCol1Sophomore" value="<?php echo $get_settings_array['col1_sophomore_start']; ?>" required />
    353. 

  353.                     <span class="add-on">
    354. 

  354.                       <i data-time-icon="icon-time" data-date-icon="icon-calendar">
    355. 

  355.                       </i>
    356. 

  356.                     </span>
    357. 

  357.                   </div>
    358. 

  358.                 </div>
    359. 

  359.                 <div class="control-group">
    360. 

  360.                   <label class="control-label" for="inputCol1Junior">Junior Start Time</label>
    361. 

  361.                   <div class="input-append date controls datetimepicker">
    362. 

  362.                     <input data-format="yyyy-MM-dd hh:mm:ss" type="text" 
    363. 

  363.                            name="junior" id="inputCol1Junior" value="<?php echo $get_settings_array['col1_junior_start']; ?>" required />
    364. 

  364.                     <span class="add-on">
    365. 

  365.                       <i data-time-icon="icon-time" data-date-icon="icon-calendar">
    366. 

  366.                       </i>
    367. 

  367.                     </span>
    368. 

  368.                   </div>
    369. 

  369.                 </div>
    370. 

  370.                 <div class="control-group">
    371. 

  371.                   <label class="control-label" for="inputCol1Senior">Senior Start Time</label>
    372. 

  372.                   <div class="input-append date controls datetimepicker">
    373. 

  373.                     <input data-format="yyyy-MM-dd hh:mm:ss" type="text" 
    374. 

  374.                            name="senior" id="inputCol1Senior" value="<?php echo $get_settings_array['col1_senior_start']; ?>" required />
    375. 

  375.                     <span class="add-on">
    376. 

  376.                       <i data-time-icon="icon-time" data-date-icon="icon-calendar">
    377. 

  377.                       </i>
    378. 

  378.                     </span>
    379. 

  379.                   </div>
    380. 

  380.                 </div>
    381. 

  381.                 <div class="control-group">
    382. 

  382.                   <label class="control-label" for="inputCol1EndTime">End Time</label>
    383. 

  383.                   <div class="input-append date controls datetimepicker">
    384. 

  384.                     <input data-format="yyyy-MM-dd hh:mm:ss" type="text" 
    385. 

  385.                            name="end" id="inputCol1EndTime" value="<?php echo $get_settings_array['col1_end']; ?>" required />
    386. 

  386.                     <span class="add-on">
    387. 

  387.                       <i data-time-icon="icon-time" data-date-icon="icon-calendar">
    388. 

  388.                       </i>
    389. 

  389.                     </span>
    390. 

  390.                   </div>
    391. 

  391.                 </div>
    392. 

  392.                 <div class="control-group">
    393. 

  393.                   <div class="controls">
    394. 

  394.                     <button type="submit" class="btn btn-primary" name="sem1times">Update</button>
    395. 

  395.                   </div>
    396. 

  396.                 </div>
    397. 

  397.               </form>
    398. 

  398.             </div>
    399. 

  399.             <div class="span5">
    400. 

  400.               <h3>Semester 2</h3>
    401. 

  401.               <form class="form" action="#colloquiumstartend" method="post">
    402. 

  402.                 <div class="control-group">
    403. 

  403.                   <label class="control-label" for="inputCol2Freshman">Freshman Start Time</label>
    404. 

  404.                  <div class="input-append date controls datetimepicker">
    405. 

  405.                     <input data-format="yyyy-MM-dd hh:mm:ss" type="text" 
    406. 

  406.                            name="freshman" id="inputCol2Freshman" value="<?php echo $get_settings_array['col2_freshman_start']; ?>" required />
    407. 

  407.                     <span class="add-on">
    408. 

  408.                       <i data-time-icon="icon-time" data-date-icon="icon-calendar">
    409. 

  409.                       </i>
    410. 

  410.                     </span>
    411. 

  411.                   </div>
    412. 

  412.                 </div>
    413. 

  413.                 <div class="control-group">
    414. 

  414.                   <label class="control-label" for="inputCol2Sophomore">Sophomore Start Time</label>
    415. 

  415.                   <div class="input-append date controls datetimepicker">
    416. 

  416.                     <input data-format="yyyy-MM-dd hh:mm:ss" type="text" 
    417. 

  417.                            name="sophomore" id="inputCol2Sophomore" value="<?php echo $get_settings_array['col2_sophomore_start']; ?>" required />
    418. 

  418.                     <span class="add-on">
    419. 

  419.                       <i data-time-icon="icon-time" data-date-icon="icon-calendar">
    420. 

  420.                       </i>
    421. 

  421.                     </span>
    422. 

  422.                   </div>
    423. 

  423.                 </div>
    424. 

  424.                 <div class="control-group">
    425. 

  425.                   <label class="control-label" for="inputCol2Junior">Junior Start Time</label>
    426. 

  426.                   <div class="input-append date controls datetimepicker">
    427. 

  427.                     <input data-format="yyyy-MM-dd hh:mm:ss" type="text" 
    428. 

  428.                            name="junior" id="inputCol2Junior" value="<?php echo $get_settings_array['col2_junior_start']; ?>" required />
    429. 

  429.                     <span class="add-on">
    430. 

  430.                       <i data-time-icon="icon-time" data-date-icon="icon-calendar">
    431. 

  431.                       </i>
    432. 

  432.                     </span>
    433. 

  433.                   </div>
    434. 

  434.                 </div>
    435. 

  435.                 <div class="control-group">
    436. 

  436.                   <label class="control-label" for="inputCol2Senior">Senior Start Time</label>
    437. 

  437.                   <div class="input-append date controls datetimepicker">
    438. 

  438.                     <input data-format="yyyy-MM-dd hh:mm:ss" type="text" 
    439. 

  439.                            name="senior" id="inputCol2Senior" value="<?php echo $get_settings_array['col2_senior_start']; ?>" required />
    440. 

  440.                     <span class="add-on">
    441. 

  441.                       <i data-time-icon="icon-time" data-date-icon="icon-calendar">
    442. 

  442.                       </i>
    443. 

  443.                     </span>
    444. 

  444.                   </div>
    445. 

  445.                 </div>
    446. 

  446.                 <div class="control-group">
    447. 

  447.                   <label class="control-label" for="inputCol2EndTime">End Time</label>
    448. 

  448.                   <div class="input-append date controls datetimepicker">
    449. 

  449.                     <input data-format="yyyy-MM-dd hh:mm:ss" type="text" 
    450. 

  450.                            name="end" id="inputCol2EndTime" value="<?php echo $get_settings_array['col2_end']; ?>" required />
    451. 

  451.                     <span class="add-on">
    452. 

  452.                       <i data-time-icon="icon-time" data-date-icon="icon-calendar">
    453. 

  453.                       </i>
    454. 

  454.                     </span>
    455. 

  455.                   </div>
    456. 

  456.                 </div>
    457. 

  457.                 <div class="control-group">
    458. 

  458.                   <div class="controls">
    459. 

  459.                     <button type="submit" class="btn btn-primary" name="sem2times">Update</button>
    460. 

  460.                   </div>
    461. 

  461.                 </div>
    462. 

  462.               </form>
    463. 

  463.             </div>
    464. 

  464.           </div>
    465. 

  465.         </section>
    466. 

  466.         <section id="xystartend">
    467. 

  467.           <div class='page-header'>
    468. 

  468.             <h2>XY Registration Start/End Times</h2>
    469. 

  469.           </div>
    470. 

  470.           <form class="form" action="#xystartend" method="post">
    471. 

  471.             XY registration will open 
    472. 

  472.             <input type="number" name="xy_num_days_open" class="input-mini" value=<?php echo $get_settings_array['xy_num_days_open']; ?> required /> 
    473. 

  473.             days prior at 
    474. 

  474.             <span class="input-append timepicker">
    475. 

  475.               <input data-format="hh:mm:ss" type="text" class="input-mini"
    476. 

  476.                      name="xy_time_open" value="<?php echo $get_settings_array['xy_time_open']; ?>" required />
    477. 

  477.               <span class="add-on">
    478. 

  478.                 <i data-time-icon="icon-time" data-date-icon="icon-calendar">
    479. 

  479.                 </i>
    480. 

  480.               </span> 
    481. 

  481.             </span>
    482. 

  482.             and will close 
    483. 

  483.             <input type="number" name="xy_num_days_close" class="input-mini" value=<?php echo $get_settings_array['xy_num_days_close']; ?> required /> 
    484. 

  484.             days prior at 
    485. 

  485.             <span class="input-append timepicker">
    486. 

  486.               <input data-format="hh:mm:ss" type="text" class="input-mini"
    487. 

  487.                      name="xy_time_close" value="<?php echo $get_settings_array['xy_time_close']; ?>" required />
    488. 

  488.               <span class="add-on">
    489. 

  489.                 <i data-time-icon="icon-time" data-date-icon="icon-calendar">
    490. 

  490.                 </i>
    491. 

  491.               </span> 
    492. 

  492.             </span>
    493. 

  493.             <div>
    494. 

  494.               <button type="submit" class="btn btn-primary" name="xytimes">Update</button>
    495. 

  495.             </div>
    496. 

  496.           </form>
    497. 

  497.         </section>
    498. 

  498.         <section id="quarters">
    499. 

  499.           <div class='page-header'>
    500. 

  500.             <h2>Quarter Start Dates</h2>
    501. 

  501.           </div>
    502. 

  502.           <form class="form" action="#quarters" method="post">
    503. 

  503.             <div class="control-group">
    504. 

  504.               <label class="control-label" for="inputQuarter1">1st Quarter Start Date</label>
    505. 

  505.              <div class="input-append date controls datepicker">
    506. 

  506.                 <input data-format="yyyy-MM-dd" type="text" 
    507. 

  507.                        name="quarter1" id="inputQuarter1" value="<?php echo $get_settings_array['quarter_1_start']; ?>" required />
    508. 

  508.                 <span class="add-on">
    509. 

  509.                   <i data-time-icon="icon-time" data-date-icon="icon-calendar">
    510. 

  510.                   </i>
    511. 

  511.                 </span>
    512. 

  512.               </div>
    513. 

  513.             </div>
    514. 

  514.             <div class="control-group">
    515. 

  515.               <label class="control-label" for="inputQuarter2">2nd Quarter Start Date</label>
    516. 

  516.              <div class="input-append date controls datepicker">
    517. 

  517.                 <input data-format="yyyy-MM-dd" type="text" 
    518. 

  518.                        name="quarter2" id="inputQuarter2" value="<?php echo $get_settings_array['quarter_2_start']; ?>" required />
    519. 

  519.                 <span class="add-on">
    520. 

  520.                   <i data-time-icon="icon-time" data-date-icon="icon-calendar">
    521. 

  521.                   </i>
    522. 

  522.                 </span>
    523. 

  523.               </div>
    524. 

  524.             </div>
    525. 

  525.             <div class="control-group">
    526. 

  526.               <label class="control-label" for="inputQuarter3">3rd Quarter Start Date</label>
    527. 

  527.              <div class="input-append date controls datepicker">
    528. 

  528.                 <input data-format="yyyy-MM-dd" type="text" 
    529. 

  529.                        name="quarter3" id="inputQuarter3" value="<?php echo $get_settings_array['quarter_3_start']; ?>" required />
    530. 

  530.                 <span class="add-on">
    531. 

  531.                   <i data-time-icon="icon-time" data-date-icon="icon-calendar">
    532. 

  532.                   </i>
    533. 

  533.                 </span>
    534. 

  534.               </div>
    535. 

  535.             </div>
    536. 

  536.             <div class="control-group">
    537. 

  537.               <label class="control-label" for="inputQuarter4">4th Quarter Start Date</label>
    538. 

  538.              <div class="input-append date controls datepicker">
    539. 

  539.                 <input data-format="yyyy-MM-dd" type="text" 
    540. 

  540.                        name="quarter4" id="inputQuarter4" value="<?php echo $get_settings_array['quarter_4_start']; ?>" required />
    541. 

  541.                 <span class="add-on">
    542. 

  542.                   <i data-time-icon="icon-time" data-date-icon="icon-calendar">
    543. 

  543.                   </i>
    544. 

  544.                 </span>
    545. 

  545.               </div>
    546. 

  546.             </div>
    547. 

  547.             <div class="control-group">
    548. 

  548.               <div class="controls">
    549. 

  549.                 <button type="submit" class="btn btn-primary" name="quarter_button">Update</button>
    550. 

  550.               </div>
    551. 

  551.             </div>
    552. 

  552.           </form>
    553. 

  553.         </section>
    554. 

  554.         <section id="schedule">
    555. 

  555.           <div class='page-header'>
    556. 

  556.             <h2>Course Schedule</h2>
    557. 

  557.           </div>
    558. 

  558.           <table class="table table-striped table-condensed table-hover">
    559. 

  559.             <thead>
    560. 

  560.               <tr>
    561. 

  561.                 <th>Date</th>
    562. 

  562.                 <th>Colloquium</th>
    563. 

  563.                 <th>X</th>
    564. 

  564.                 <th>Y</th>
    565. 

  565.                 <th></th>
    566. 

  566.               </tr>
    567. 

  567.             </thead>
    568. 

  568.             <tbody>
    569. 

  569.               <?php
    570. 

  570.                 while($row=mysql_fetch_array($get_course_schedule_result)){
    571. 

  571.               ?>
    572. 

  572.                 <tr>
    573. 

  573.                   <form class="form" action="#schedule" method="post">
    574. 

  574.                     <input name='id' type='hidden' value="<?php echo $row['id']; ?>" />
    575. 

  575.                     <td>
    576. 

  576.                       <div class="input-append date controls datepicker">
    577. 

  577.                         <input class="input-small" data-format="yyyy-MM-dd" type="text" name="date" value="<?php echo $row['date']; ?>" required />
    578. 

  578.                         <span class="add-on">
    579. 

  579.                           <i data-time-icon="icon-time" data-date-icon="icon-calendar"></i>
    580. 

  580.                         </span>
    581. 

  581.                       </div>
    582. 

  582.                     </td>
    583. 

  583.                     <td>
    584. 

  584.                       <label class='checkbox inline'>
    585. 

  585.                         <input type='checkbox' name='colloquium' value=1 <?php if($row['colloquium']){echo " checked";} ?> />
    586. 

  586.                       </label>
    587. 

  587.                     </td>
    588. 

  588.                     <td>
    589. 

  589.                       <label class='checkbox inline'>
    590. 

  590.                         <input type='checkbox' name='x' value=1 <?php if($row['x']){echo " checked";} ?> />
    591. 

  591.                       </label>
    592. 

  592.                     </td>
    593. 

  593.                     <td>
    594. 

  594.                       <label class='checkbox inline'>
    595. 

  595.                         <input type='checkbox' name='y' value=1 <?php if($row['y']){echo " checked";} ?> />
    596. 

  596.                       </label>
    597. 

  597.                     </td>
    598. 

  598.                     <td>
    599. 

  599.                       <button type="submit" class="btn" name="update_schedule">Update</button>
    600. 

  600.                     </td>
    601. 

  601.                   </form>
    602. 

  602.                 </tr>
    603. 

  603.               <?php
    604. 

  604.                 }
    605. 

  605.               ?>
    606. 

  606.               <tr>
    607. 

  607.                 <form class="form" action="#schedule" method="post">
    608. 

  608.                   <td>
    609. 

  609.                     <div class="input-append date controls datepicker">
    610. 

  610.                       <input class="input-small" data-format="yyyy-MM-dd" type="text" name="date" required />
    611. 

  611.                       <span class="add-on">
    612. 

  612.                         <i data-time-icon="icon-time" data-date-icon="icon-calendar"></i>
    613. 

  613.                       </span>
    614. 

  614.                     </div>
    615. 

  615.                   </td>
    616. 

  616.                   <td>
    617. 

  617.                     <label class='checkbox inline'>
    618. 

  618.                       <input type='checkbox' name='colloquium' value=1 />
    619. 

  619.                     </label>
    620. 

  620.                   </td>
    621. 

  621.                   <td>
    622. 

  622.                     <label class='checkbox inline'>
    623. 

  623.                       <input type='checkbox' name='x' value=1 />
    624. 

  624.                     </label>
    625. 

  625.                   </td>
    626. 

  626.                   <td>
    627. 

  627.                     <label class='checkbox inline'>
    628. 

  628.                       <input type='checkbox' name='y' value=1 />
    629. 

  629.                     </label>
    630. 

  630.                   </td>
    631. 

  631.                   <td>
    632. 

  632.                     <button type="submit" class="btn btn-primary" name="add_schedule">Add</button>
    633. 

  633.                   </td>
    634. 

  634.                 </form>
    635. 

  635.               </tr>
    636. 

  636.             </tbody>
    637. 

  637.           </table>
    638. 

  638.         </section>
    639. 

  639.         <section id="classrooms">
    640. 

  640.           <div class='page-header'>
    641. 

  641.             <h2>Available Classrooms</h2>
    642. 

  642.           </div>
    643. 

  643.           <form class="form" action="#classrooms" method="post">
    644. 

  644.             <div class="control-group">
    645. 

  645.               <label class="control-label" for="classroms">List of classrooms:</label>
    646. 

  646.               <div class="controls">
    647. 

  647.                 <textarea class="input-xxlarge" name="classrooms" id="classrooms" rows="5" required><?php echo $get_settings_array['rooms']; ?></textarea>
    648. 

  648.               </div>
    649. 

  649.             </div>
    650. 

  650.             <div class="control-group">
    651. 

  651.               <div class="controls">
    652. 

  652.                 <button name="classrooms_submit" type="submit" class="btn btn-primary">Update</button>
    653. 

  653.               </div>
    654. 

  654.             </div>
    655. 

  655.           </form>
    656. 

  656.        </section>
    657. 

  657.           <section id="graduation">
    658. 

  658.             <div class='page-header'>
    659. 

  659.               <h2>Graduation Years</h2>
    660. 

  660.             </div>
    661. 

  661.               <form class="form-horizontal" action="#graduation" method="post">
    662. 

  662.                 <div class="control-group">
    663. 

  663.                   <label class="control-label" for="inputFreshman">Freshman</label>
    664. 

  664.                   <div class="controls">
    665. 

  665.                     <input type="number" name="freshman" id="inputFreshman" value=<?php echo $freshman; ?> required />
    666. 

  666.                   </div>
    667. 

  667.                 </div>
    668. 

  668.                 <div class="control-group">
    669. 

  669.                   <label class="control-label" for="inputSophomore">Sophomore</label>
    670. 

  670.                   <div class="controls">
    671. 

  671.                     <input type="number" name="sophomore" id="inputSophomore" value=<?php echo $sophomore; ?> required />
    672. 

  672.                   </div>
    673. 

  673.                 </div>
    674. 

  674.                 <div class="control-group">
    675. 

  675.                   <label class="control-label" for="inputJunior">Junior</label>
    676. 

  676.                   <div class="controls">
    677. 

  677.                     <input type="number" name="junior" id="inputJunior" value=<?php echo $junior; ?> required />
    678. 

  678.                   </div>
    679. 

  679.                 </div>
    680. 

  680.                 <div class="control-group">
    681. 

  681.                   <label class="control-label" for="inputSenior">Senior</label>
    682. 

  682.                   <div class="controls">
    683. 

  683.                     <input type="number" name="senior" id="inputSenior" value=<?php echo $senior; ?> required />
    684. 

  684.                   </div>
    685. 

  685.                 </div>
    686. 

  686.                 <div class="control-group">
    687. 

  687.                   <div class="controls">
    688. 

  688.                     <button name="gradyears" type="submit" class="btn btn-primary">Update</button>
    689. 

  689.                   </div>
    690. 

  690.                 </div>
    691. 

  691.               </form>
    692. 

  692.           </section>
    693. 

  693.           <section id="ghost">
    694. 

  694.             <div class='page-header'>
    695. 

  695.               <h2>Ghost Users</h2>
    696. 

  696.             </div>
    697. 

  697.             <table class="table table-striped table-condensed table-hover">
    698. 

  698.               <thead>
    699. 

  699.                 <tr>
    700. 

  700.                   <th></th>
    701. 

  701.                   <th></th>
    702. 

  702.                   <th></th>
    703. 

  703.                   <th></th>
    704. 

  704.                 </tr>
    705. 

  705.               </thead>
    706. 

  706.               <tbody>
    707. 

  707.                 <?php
    708. 

  708.                   while($row=mysql_fetch_array($get_ghost_users_result)){
    709. 

  709.                 ?>
    710. 

  710.                   <tr>
    711. 

  711.                     <form class="form" action="#ghost" method="post">
    712. 

  712.                       <input name='id' type='hidden' value="<?php echo $row['id']; ?>" />
    713. 

  713.                       <td>
    714. 

  714.                           <input class="input-medium uneditable-input" name="username" type="text" value="<?php echo $row['username']; ?>" />
    715. 

  715.                       </td>
    716. 

  716.                       <td>
    717. 

  717.                         appears as
    718. 

  718.                       </td>
    719. 

  719.                       <td>
    720. 

  720.                         <input class="input-medium uneditable-input" name="ghost_user" type="text" value="<?php echo $row['ghost_user']; ?>" />
    721. 

  721.                       </td>
    722. 

  722.                       <td>
    723. 

  723.                         <button type="submit" class="btn" name="remove_ghost_user">Remove</button>
    724. 

  724.                       </td>
    725. 

  725.                     </form>
    726. 

  726.                   </tr>
    727. 

  727.                 <?php
    728. 

  728.                   }
    729. 

  729.                 ?>
    730. 

  730.                 <tr>
    731. 

  731.                   <form class="form" action="#ghost" method="post">
    732. 

  732.                     <td>
    733. 

  733.                       <input class="input-medium" name="username" type="text" 
    734. 

  734.                              data-provide="typeahead" autocomplete="off"
    735. 

  735.                              data-source='[<?php echo implode(',',$teacher_usernames); ?>]' />
    736. 

  736.                     </td>
    737. 

  737.                     <td>
    738. 

  738.                       appears as
    739. 

  739.                     </td>
    740. 

  740.                     <td>
    741. 

  741.                       <input class="input-medium" name="ghost_user" type="text" 
    742. 

  742.                              data-provide="typeahead" autocomplete="off"
    743. 

  743.                              data-source='[<?php echo implode(',',$teacher_usernames); ?>]' />
    744. 

  744.                     </td>
    745. 

  745.                     <td>
    746. 

  746.                       <button type="submit" class="btn btn-primary" name="add_ghost_user">Add</button>
    747. 

  747.                     </td>
    748. 

  748.                   </form>
    749. 

  749.                 </tr>
    750. 

  750.               </tbody>
    751. 

  751.             </table>
    752. 

  752.           </section>
    753. 

  753.           <section id="sync">
    754. 

  754.             <div class='page-header'>
    755. 

  755.               <h2>Sync Users</h2>
    756. 

  756.             </div>
    757. 

  757.             <form class="form-horizontal" action="#sync" id="sync_users_form" method="post">
    758. 

  758.               <div class="control-group">
    759. 

  759.                 <label class="control-label" for="inputUsername">Username</label>
    760. 

  760.                 <div class="controls">
    761. 

  761.                   <input type="text" name="username" id="inputUsername" value=<?php echo $_SESSION['username']; ?> required />
    762. 

  762.                 </div>
    763. 

  763.               </div>
    764. 

  764.               <div class="control-group">
    765. 

  765.                 <label class="control-label" for="inputPassword">Password</label>
    766. 

  766.                 <div class="controls">
    767. 

  767.                   <input type="password" name="password" id="inputPassword" required />
    768. 

  768.                 </div>
    769. 

  769.               </div>
    770. 

  770.               <div class="control-group">
    771. 

  771.                 <div class="controls">
    772. 

  772.                   <input type="submit" id="syncButton" class="btn btn-primary" value="Sync" />
    773. 

  773.                 </div>
    774. 

  774.               </div>
    775. 

  775.               <div class="control-group">
    776. 

  776.                 <div class="controls">
    777. 

  777.                   <div id="please_wait" style="display: none;">
    778. 

  778.                     <em>Working on it, please wait...</em>
    779. 

  779.                   </div>
    780. 

  780.               </div>
    781. 

  781.             </form>
    782. 

  782.           </section>
    783. 

  783.         </div>    
    784. 

  784.       </div>
    785. 

  785.     </div>
    786. 

  786.     <!-- JQUERY -->
    787. 

  787.     <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
    788. 

  788.     <!-- BOOTSTRAP -->
    789. 

  789.     <script src="//netdna.bootstrapcdn.com/twitter-bootstrap/2.3.2/js/bootstrap.min.js"></script>
    790. 

  790.     <!-- AJAX UPLOAD BY BRYAN GENTRY -->
    791. 

  791.     <!-- http://bryangentry.us/ajax-upload-with-javascript-and-php-upload-an-image-and-display-a-preview/ -->
    792. 

  792.     <script src="../js/ajaxupload.js"></script>
    793. 

  793.     <!-- BOOTSTRAP DATETIME PICKER -->
    794. 

  794.     <!-- http://tarruda.github.io/bootstrap-datetimepicker/ -->
    795. 

  795.     <script src="../js/bootstrap-datetimepicker.min.js"></script>
    796. 

  796.     <!-- FORM VALIDATION USING JQUERY -->
    797. 

  797.     <!-- http://alittlecode.com/jquery-form-validation-with-styles-from-twitter-bootstrap/ -->
    798. 

  798.     <!-- <script src="../js/jquery.validate.min.js"></script> -->
    799. 

  799.     <!-- <script src="../js/validate.js"></script> -->
    800. 

  800.     <!-- INHOUSE JAVASCRIPT -->
    801. 

  801.     <script src="../js/admin.js"></script>
    802. 

  802.     <script type="text/javascript">
    803. 

  803.       $(function() {
    804. 

  804.         $('.datetimepicker').datetimepicker({
    805. 

  805.           language: 'pt-BR'
    806. 

  806.         });
    807. 

  807.         $('.timepicker').datetimepicker({
    808. 

  808.           pickDate: false
    809. 

  809.         });
    810. 

  810.         $('.datepicker').datetimepicker({
    811. 

  811.           pickTime: false
    812. 

  812.         });
    813. 

  813.       });
    814. 

  814.     </script>
    815. 

  815.   </body>
    816. 

  816. </html>
    817. 

  817.