1 files changed, 95 insertions, 0 deletions
diff --git a/scripts/todos.php b/scripts/todos.php
new file mode 100644
index 0000000..99e991c
--- /dev/null
+++ b/scripts/todos.php
@@ -0,0 +1,95 @@
+<?php
+
+$mysql = new mysqli("localhost", "webserver", "empty", "buildmaster");
+if ($mysql->connect_error) {
+  die("Connection failed: " . $mysql->connect_error);
+}
+
+$result = $mysql -> query(
+  "SELECT DISTINCT " .
+  "`todos`.`id`," .
+  "`todos`.`file`," .
+  "`todos`.`line`," .
+  "`todos`.`description` " .
+  "FROM `todos`;"
+);
+
+if (isset($_GET["graph"])) {
+
+  if ($result -> num_rows > 0) {
+
+    while ($row = $result->fetch_assoc())
+      $knot_rows[$row["id"]] =
+        $row["file"]. " (line ".$row["line"]."):\\n".str_replace("\"","\\\"",$row["description"]);
+
+    unset($knots);
+    foreach ($knot_rows as $knot)
+      $knots=$knots . "\"" . $knot . "\";\n";
+
+  }
+
+  $result = $mysql -> query(
+    "SELECT DISTINCT " .
+    "`todo_links`.`dependent`," .
+    "`todo_links`.`depending_on` " .
+    "FROM `todo_links`;"
+  );
+
+  if ($result -> num_rows > 0) {
+    $count = 0;
+    while ($row = $result->fetch_assoc()) {
+      $link_rows[$count]["dependent"] =
+        $knot_rows[$row["dependent"]];
+      $link_rows[$count]["depending_on"] =
+        $knot_rows[$row["depending_on"]];
+      $count++;
+    }
+
+    unset($edges);
+    foreach ($link_rows as $link)
+      $edges=$edges . "\"" . $link["depending_on"] . "\" -> \"" . $link["dependent"] . "\";\n";
+  }
+
+  $knots = str_replace("\$","\\\$",$knots);
+  $edges = str_replace("\$","\\\$",$edges);
+
+  header ("Content-type: image/png");
+  passthru(
+    "dot -Tpng -o/dev/stdout /dev/stdin <<EOF\n" .
+    "digraph dependencies {\n" .
+    "rankdir=LR;\n" .
+    "fontname=dejavu;\n" .
+    $knots .
+    $edges .
+    "}\n" .
+    "EOF\n"
+  );
+
+} else { // isset($_GET["graph"])
+
+  if ($result -> num_rows > 0) {
+
+    print "<html>\n";
+    print "<head>\n";
+    print "<title>Todos in the build scripts</title>\n";
+    print "</head>\n";
+    print "<body>\n";
+
+    while ($row = $result->fetch_assoc()) {
+      print "<a href=\"#TODO" . $row["id"] . "\">TODO #" . $row["id"] . "</a>";
+      print " - ";
+      print "<a href=\"https://github.com/archlinux32/builder/blob/master/" . $row["file"] . "#L" . $row["line"] . "\">" . $row["file"] . "(line " . $row["line"] . ")</a>";
+      print ":<br>\n";
+      print str_replace("\\n","<br>\n",$row["description"]);
+      print "<br>\n";
+      print "<br>\n";
+    }
+
+    print "</body>\n";
+    print "</html>\n";
+
+  }
+
+}
+
+?>