detail_lib.php

   1 <?php
   2
   3 /*
   4         schedule details must have an inital record.
   5
   6         This checks for inital record and creates on if needed.
   7 */
   8 function detail_init($user_id, $sched_id)
   9 {
  10         if (!$user_id) { return; }
  11         if (!$sched_id) { return; }
  12
  13         $sql = 'select count(*) as count from sched_details where sched_id = '.$sched_id.' and user_id = '.$user_id;
  14
  15         //echo $sql;
  16
  17         $result = mysql_query($sql);
  18         if (!$result) { die("SQL ERROR: Count Schedule Details"); }
  19
  20         $row = mysql_fetch_array($result);
  21
  22         if($row['count'] == 0) {
  23
  24                 $sql = 'insert into sched_details values ("", '.$sched_id.', '.$user_id.', 1,1,0, NOW(),0)';
  25
  26                 //echo $sql;
  27                 $result = mysql_query($sql);
  28                 if (!$result) { die("SQL ERROR: Insert Sched Details"); }
  29         }
  30 }
  31
  32 /*
  33         val: status of message
  34
  35                 1 = has been viewed
  36                 0 = has not been viewed
  37
  38         to: message updated for faculty or for student
  39
  40                 fac = faculty
  41                 std = student
  42 */
  43 function detail_viewed_update($user_id, $sched_id, $val, $to)
  44 {
  45         detail_init($user_id, $sched_id);
  46
  47         if($to == "fac") {
  48                 $sql = 'update sched_details set fac_viewed = '.$val.' where sched_id = '.$sched_id.' and user_id = '.$user_id;
  49         } else if ($to == "std") {
  50                 $sql = 'update sched_details set user_viewed = '.$val.' where sched_id = '.$sched_id.' and user_id = '.$user_id;
  51         } else {
  52                 die("ERROR: Incorrect Value Sent to Detail Viewed Update");
  53         }
  54         //echo $sql;
  55
  56         $result = mysql_query($sql);
  57         if (!$result) { die("SQL ERROR: Viewed Update"); }
  58 }
  59
  60 /* toggles help me in the DB */
  61 function helpme_viewed_update($user_id, $sched_id, $val)
  62 {
  63         detail_init($user_id, $sched_id);
  64
  65         $sql = 'update sched_details set help_me = '.$val.' where sched_id = '.$sched_id.' and user_id = '.$user_id;
  66
  67         //echo $sql;
  68
  69         $result = mysql_query($sql);
  70         if (!$result) { die("SQL ERROR: Viewed Update"); }
  71 }
  72
  73
  74 function help_me_query($user_id, $sched_id)
  75 {
  76         detail_init($user_id, $sched_id);
  77         $sql = 'select help_me from sched_details where sched_id = '.$sched_id.' and user_id = '.$user_id;
  78
  79         $result = mysql_query($sql);
  80
  81         //echo $sql;
  82
  83         if (!$result) { die("SQL ERROR: Help Me Query"); }
  84
  85         $row = mysql_fetch_array($result);
  86
  87         return $row['help_me'];
  88 }
  89
  90 function detail_viewed_query($user_id, $sched_id, $val)
  91 {
  92         detail_init($user_id, $sched_id);
  93         $sql = 'select viewed from sched_details where sched_id = 29 and user_id = 15';
  94
  95         $result = mysql_query($sql);
  96         if (!$result) { die("SQL ERROR: Viewed Query"); }
  97
  98         $row = mysql_fetch_array($result);
  99
 100         return $row['viewed'];
 101 }
 102
 103 /*
 104         1 = needs help
 105         0 = does not need help
 106 */
 107 function detail_help_update($user_id, $sched_id, $val)
 108 {
 109         detail_init($user_id, $sched_id);
 110
 111 }
 112
 113 function detail_help_query($user_id, $sched_id, $val)
 114 {
 115         detail_init($user_id, $sched_id);
 116
 117 }
 118
 119 function detail_mark_late($user_id, $sched_id)
 120 {
 121         detail_init($user_id, $sched_id);
 122         $sql = 'update sched_details set late = 1 where sched_id = '.$sched_id.' and user_id = '.$user_id;
 123
 124         //echo $sql;
 125
 126         $result = mysql_query($sql);
 127         if (!$result) { die("SQL ERROR: Viewed Update"); }
 128 }
 129
 130 ?>