user_details.php

   1 <?php
   2
   3 function need_help($user_id, $sched_id)
   4 {
   5         if(!isset($user_id)) { return -1; }
   6
   7         $sql = 'select help_me from sched_details where user_id = '.$user_id.' and sched_id = '.$sched_id;
   8         $result = mysql_query($sql);
   9
  10         if (!$result) { die("SQL ERROR"); }
  11
  12         $row = mysql_fetch_array($result);
  13
  14         return $row[0];
  15 }
  16
  17 function file_count($user_id, $sched_id)
  18 {
  19         if(!isset($user_id)) { return -1; }
  20         $sql = 'select count(*) from files where user_id = '.$user_id.' and sched_id = '.$sched_id;
  21         $result = mysql_query($sql);
  22
  23         if (!$result) { die("SQL ERROR"); }
  24
  25         $row = mysql_fetch_array($result);
  26
  27         return $row[0];
  28 }
  29
  30 function file_late($file_id)
  31 {
  32         $sql = 'select due_date - time_post as late from files, schedule where (files.sched_id = schedule.sched_id) and file_id ='.$file_id;
  33
  34         $result = mysql_query($sql);
  35
  36         if (!$result) { die("SQL ERROR: File Details For File Late"); }
  37
  38         $row = mysql_fetch_array($result);
  39
  40         if($row['late'] < 0) return true;
  41
  42         return false;
  43 }
  44
  45 function assignment_late($user_id, $sched_id)
  46 {
  47         if(!isset($user_id)) { return -1; }
  48         $sql = 'select late from sched_details where user_id = '.$user_id.' and sched_id = '.$sched_id;
  49         $result = mysql_query($sql);
  50
  51         if (!$result) { die("SQL ERROR"); }
  52
  53         $row = mysql_fetch_array($result);
  54
  55         return $row[0];
  56 }
  57
  58 ?>