php/kjd_progressive.php

   1 <?php
   2
   3 require("db.php");
   4 require("json.php");
   5
   6 mysql_connect(DB_HOST, DB_USER, DB_PASS);
   7 mysql_select_db(DB_NAME);
   8
   9 $id = (int)$_REQUEST['id'];
  10 if (!$id) {
  11         $id = 1; // show first tree by default
  12 }
  13
  14 $tree_query = mysql_query("select * from kjd where parent = '$id'");
  15 $trees = array();
  16 if (!$tree_query) {
  17         echo "Error loading game data.";
  18 } else {
  19         while ($tree = mysql_fetch_array($tree_query, MYSQL_ASSOC)) {
  20                 $tree['nodes'] = unserialize($tree['nodes']);
  21                 $tree['trees'] = array();
  22                 $trees[] = $tree;
  23         }
  24         $json = new Services_JSON();
  25     echo $json->encode(array(
  26                 "id"    => $id,
  27                 "nodes" => array(),
  28                 "trees" => $trees,
  29         ));
  30 }
  31
  32 ?>