示例#1
0
// 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();
示例#2
0
$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");