php/ojd_changes.php

   1 <table>
   2 <?php
   3
   4 require("db.php");
   5 require("sgf.php");
   6
   7 mysql_connect(DB_HOST, DB_USER, DB_PASS);
   8 mysql_select_db(DB_NAME);
   9
  10
  11 function get_moves_path($tpos)
  12 {
  13         $tree_query = mysql_query("SELECT tn.parent AS parent, IFNULL(sgf.value, '?') AS coord FROM tree_node AS tn LEFT JOIN sgf_node AS sgf ON sgf.tnode = tn.version AND (sgf.code = 'B' OR sgf.code = 'W') WHERE tn.id = $tpos");
  14         $tnode = mysql_fetch_assoc($tree_query);
  15         if ($tnode['parent']) {
  16                 $str = get_moves_path($tnode['parent']) . ' ';
  17         } else {
  18                 $str = '';
  19         }
  20         $str .= sgfpos2coord($tnode['coord']);
  21         return $str;
  22 }
  23
  24
  25 $changes_query = mysql_query("SELECT tna.id AS version, tna.tree_pos AS tree_pos, tna.ctime AS ctime, tna.author AS author FROM tree_node_archive AS tna ORDER BY tna.id DESC LIMIT 100");
  26 while ($change = mysql_fetch_assoc($changes_query)) {
  27         echo "<tr><td>".$change['version']."</td><td>".$change['ctime']."</td><td>".$change['author']."</td><td>".get_moves_path($change['tree_pos'])."</td></tr>\n";
  28 }
  29
  30 ?>
  31 </table>