Index: /trunk/www/dch/shiftinfo.php
===================================================================
--- /trunk/www/dch/shiftinfo.php (revision 15312)
+++ /trunk/www/dch/shiftinfo.php (revision 15312)
@@ -0,0 +1,45 @@
+
+
+
+
+ FACT Project
+
+
+
+
+
+
+
+Is FACT taking data?
+Who is on shift?
+(from FACT shift plan
+and FACT logbook)
+
+ Night: ".$date." (date of sunset)
";
+$query="SELECT u FROM calendar.data WHERE CONCAT(y, LPAD(m+1, 2, 0), LPAD(d,2,0))='".$date."' AND x=0 ";
+//echo $query;
+include ("db.php");
+$db_id = mysql_connect($host, $user, $pw);
+$result = mysql_query($query);
+echo " Contact Info:
\n \n";
+while ($row = mysql_fetch_row($result))
+{
+ //echo " ".$row[0]." ";
+ $query2="SELECT usertitle, fid8 FROM logbook.userfields LEFT JOIN logbook.users ON (uid=ufid) WHERE username='".$row[0]."'";
+ //echo $query2;
+ $result2 = mysql_query($query2);
+ while ($row2 = mysql_fetch_row($result2))
+ {
+ echo "- ".$row2[0].": ".$row2[1]."
\n";
+ }
+ mysql_free_result($result2);
+}
+echo "
\n";
+mysql_free_result($result);
+
+?>
+
+
+