// Configure database $server = "localhost"; $db_user = "******"; $db_pass = "******"; $only_db = "********"; // Include required classes require_once "_inc/database.php"; require_once "_inc/class.tree.php"; // Create a new DB instance $db = new DB(); // Create a new tree instance $tree = new tree(array("structure" => array("id" => "id", "parent_id" => "parent_id", "position" => "position"))); $languages = array(); $db->query("SELECT * FROM languages"); while ($db->nextr()) { $languages[$db->f(0)] = array($db->f(1), $db->f(2)); } // SERVER SIDE PART if (isset($_REQUEST["server"])) { // Make sure nothing is cached header("Cache-Control: must-revalidate"); header("Cache-Control: post-check=0, pre-check=0", false); header("Pragma: no-cache"); header("Expires: " . gmdate("D, d M Y H:i:s", mktime(date("H") - 2, date("i"), date("s"), date("m"), date("d"), date("Y"))) . " GMT"); header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); switch ($_REQUEST["type"]) { case "list": $id = (int) str_replace("node_", "", $_REQUEST["id"]); $db->query("SELECT s.id, ( SELECT COUNT(*) FROM structure WHERE parent_id = s.id ) AS children, c.language, c.name FROM structure s LEFT JOIN content c ON c.id = s.id WHERE s.parent_id = " . $id . " ORDER BY position"); $data = array();
$db_user = "******"; $db_pass = "******"; $only_db = "********"; // Include required classes require_once("_inc/database.php"); require_once("_inc/class.tree.php"); // Create a new DB instance $db = new DB; // Create a new tree instance $tree = new tree( array( "structure" => array("id" => "id", "parent_id" => "parent_id", "position" => "position") ) ); $languages = array(); $db->query("SELECT * FROM languages"); while($db->nextr()) { $languages[$db->f(0)] = array($db->f(1),$db->f(2)); } // SERVER SIDE PART if(isset($_REQUEST["server"])) { // Make sure nothing is cached header("Cache-Control: must-revalidate"); header("Cache-Control: post-check=0, pre-check=0", false); header("Pragma: no-cache"); header("Expires: ".gmdate("D, d M Y H:i:s", mktime(date("H")-2, date("i"), date("s"), date("m"), date("d"), date("Y")))." GMT"); header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT"); switch($_REQUEST["type"]) { case "list": $id = (int)str_replace("node_","",$_REQUEST["id"]); $db->query("SELECT s.id, ( SELECT COUNT(*) FROM structure WHERE parent_id = s.id ) AS children, c.language, c.name FROM structure s LEFT JOIN content c ON c.id = s.id WHERE s.parent_id = ".$id." ORDER BY position");