Changeset 13687 for trunk/FACT++/www/shift/calendar.php

Timestamp:

05/13/12 11:30:56 (12 years ago)

Author:

tbretz

Message:

Implemented a mark for an attached comment, display comment in tooltip.

File:

• trunk/FACT++/www/shift/calendar.php (modified) (2 diffs)

trunk/FACT++/www/shift/calendar.php

@@ -81 +81 @@
 if (isset($_GET['comment']))
 {
-    if (!isset($_GET['d']))
-        return;
-
-    $d = $_GET['d'];
-
-    $query = "SELECT c FROM Comments WHERE y=".$y." AND m=".$m." AND d=".$d;
+    $query = "SELECT d, c FROM Comments WHERE y=".$y." AND m=".$m;
+    if (isset($_GET['d']))
+        $query .= " AND d=".$_GET['d'];
 
     $result = mysql_query($query);
@@ -92 +89 @@
         return header('HTTP/1.0 500 '.mysql_error());
 
-    $row = mysql_fetch_array($result, MYSQL_NUM);
+    if (isset($_GET['d']))
+    {
+        $row = mysql_fetch_array($result, MYSQL_NUM);
+        print($row[1]);
+        return;
+    }
 
-    print($row[0]);
+    while ($row = mysql_fetch_array($result, MYSQL_NUM))
+    {
+        printf("%04d%02d%s", strlen($row[1]), $row[0], $row[1]);
+    }
 
     return;