* See enum value of $_SESSION[$ssid]['lisha']['struct']['tb_libelles']['name'] table field 'object' for further information * In all case, we loaded common label text design by objet = 'global' ====================================================================*/ if (isset($type_screen)) { switch ($type_screen) { case 'bug': $objet = 'bug'; break; case 'user': $objet = 'user'; break; case 'tech': $objet = 'tech'; break; default: error_log_details("fatal", "Unknown type_soft : " . $type_screen . " >"); break; } } else { // if no type_soft define, then load only global label $objet = "global"; } //================================================================== // Read all text on a specific language //================================================================== $query = "SELECT\r\n\t\t\t\t`id` \t\tAS 'ID',\r\n\t\t\t\t`object`\tAS 'OB',\r\n\t\t\t\t`texte` \tAS 'TX',\r\n\t\t\t\t`corps` \tAS 'BO'\r\n\t\t\tFROM \r\n\t\t\t\t`" . __LISHA_TABLE_EXTRA_TEXT__ . "` \r\n\t\t\tWHERE 1 = 1\r\n\t\t\t\tAND `application_release` \t= '" . __LISHA_APPLICATION_RELEASE__ . "'\r\n\t\t\t\tAND `object` = '" . $objet . "'\r\n\t\t\t\tAND `id_lang` \t\t\t\t= '" . $_SESSION[$ssid]['lisha']['langue'] . "' \r\n\t\t\tORDER BY \r\n\t\t\t\t`texte`\r\n\t\t "; $result = $link->query($query); $w_libelle_common = ''; // Clear local variable while ($row = $result->fetch_array(MYSQLI_ASSOC)) { // Specific page text
$_GET["ssid"] = $_POST["ssid"]; } //================================================================== //================================================================== // Controle current page exists //================================================================== if (!isset($_SESSION[$ssid]['current_read_page'])) { error_log_details('fatal', 'you need a current page'); die; } //================================================================== //================================================================== // Get language in use //================================================================== if (!isset($_POST["language"])) { error_log_details('fatal', 'you need an language'); die; } $language = $_POST["language"]; //================================================================== $corps = str_replace("'", "''", $_POST["corps"]); $corps = str_replace("\\", "\\\\", $corps); //================================================================== // Local page already exists ? //================================================================== $query = "\n\t\t\t\tSELECT 1 AS 'output'\n\t\t\t\tFROM `" . $_SESSION[$ssid]['MT']['ikdoc']->tree_caption . "` `MTC`\n\t\t\t\tWHERE\n\t\t\t\t\t`MTC`.`application_release` = '" . __MAGICTREE_APPLICATION_RELEASE__ . "'\n\t\t\t\t\tAND `MTC`.`language` = '" . $language . "'\n\t\t\t\t\tAND `MTC`.`id` = " . $_SESSION[$ssid]['current_read_page'] . ";\n\t\t\t"; $result = $link->query($query); $row = $result->fetch_array(MYSQLI_ASSOC); //================================================================== if (!isset($row['output'])) { // First, recover title node in root language
* Application release * Page database connexion * Load configuration parameters in session ====================================================================*/ require '../includes/common/load_conf_session.php'; /*===================================================================*/ /**================================================================== * Recover language from URL or Database ====================================================================*/ require '../includes/common/language.php'; /*===================================================================*/ //================================================================== // Load bug ID number //================================================================== if (!isset($_GET["ID"])) { error_log_details('fatal', 'No bug ID define. You have to provide one'); } else { $page = $_GET["ID"]; } //================================================================== $query = "SELECT\n\t\t\t\t`details` AS 'details',\n\t\t\t\t`description` AS 'description',\n\t\t\t\t`solution` AS 'solution'\n\t\t\tFROM \n\t\t\t\t`" . __MAGICTREE_TABLE_EXTRA_TICK__ . "`\n\t\t\tWHERE 1 = 1\n\t\t\t\tAND `ID` = '" . $page . "'"; $result = $link_mt->query($query); $row = $result->fetch_array(MYSQLI_ASSOC); $texte = htmlentities($row["details"]); $description = $row["description"]; $solution = htmlentities($row["solution"]); /**================================================================== * HTML declare page interpretation directive ====================================================================*/ require '../includes/common/html_doctype.php'; /*===================================================================*/
require '../includes/common/db_connect.php'; /*===================================================================*/ //================================================================== // Load ssid identifier //================================================================== if (!isset($_POST["ssid"])) { error_log_details('fatal', 'No ssid define. ssid is mandatory !'); } else { $_GET["ssid"] = $_POST["ssid"]; } //================================================================== //================================================================== // Get Tree ID //================================================================== if (!isset($_POST["ID"])) { error_log_details('fatal', 'you have to define always an ID'); die; } $ID = $_POST["ID"]; //================================================================== $corps = str_replace("'", "''", $_POST["corps"]); $solution = str_replace("'", "''", $_POST["solution"]); // Build update query $query = "UPDATE\n\t\t\t\t`bugsreports`\n\t\t\tSET\n\t\t\t\t`details` = '" . $corps . "',\n\t\t\t\t`solution` = '" . $solution . "'\n\t\t\tWHERE 1 = 1\n\t\t\t\tAND `ID` = '" . $ID . "'"; // Send query to database $result = $link_mt->query($query); $num_rows = $link_mt->affected_rows; if ($num_rows == 0) { echo $_SESSION[$ssid]['page_text'][15]['LT']; } else { echo $_SESSION[$ssid]['page_text'][16]['LT'];
// Define edit mode for each tree in page if (!isset($_SESSION[$ssid]['lisha']['doc']['tree']['user'])) { $_SESSION[$ssid]['MT']['tree']['id']['ikdoc']["edit_mode"] = false; } else { if (!$_SESSION[$ssid]['lisha']['doc']['tree']['user']) { $_SESSION[$ssid]['MT']['tree']['id']['ikdoc']["edit_mode"] = false; } else { $_SESSION[$ssid]['MT']['tree']['id']['ikdoc']["edit_mode"] = true; } } //================================================================== // Get ID of page //================================================================== if (isset($_GET["id"])) { if (!is_numeric($_GET["id"])) { error_log_details('fatal', 'you need an numeric id'); die; } else { $id_page = $_GET["id"]; } } else { if (!isset($_SESSION[$ssid]['MT']['current_read_page'])) { // Default page $id_page = '1'; // You need at last node 1 define in your tree } else { $id_page = $_SESSION[$ssid]['MT']['current_read_page']; } } //================================================================== // Page language equal magic tree language
require 'header_ajax.php'; /*===================================================================*/ //================================================================== // mode : // B : Brother, C : Children //================================================================== if (!isset($_POST["mode"])) { error_log_details('fatal', 'you have to define a mode'); die; } $mode = $_POST["mode"]; //================================================================== //================================================================== // Get node source id //================================================================== if (!isset($_POST["source_id"])) { error_log_details('fatal', 'you need a source id'); die; } $id_source = $_POST["source_id"]; //================================================================== //================================================================== // Get node target id //================================================================== if (!isset($_POST["target_id"])) { error_log_details('fatal', 'you need a target id'); die; } $id_target = $_POST["target_id"]; //================================================================== $_SESSION[$ssid]['MT'][$tree_id]->move_node($mode, $id_source, $id_target);
<?php /**================================================================== * MagicTree configuration ( Need active php session and ssid definition ) ====================================================================*/ require 'header_ajax.php'; /*===================================================================*/ //================================================================== // Get ID item node //================================================================== if (!isset($_POST["IDitem"])) { error_log_details('fatal', 'you need an item ID'); die; } $id_item = $_POST["IDitem"]; //================================================================== //================================================================== // Action //================================================================== if (!isset($_POST["action"])) { error_log_details('fatal', 'you have to define action'); die; } $action = $_POST["action"]; //================================================================== $_SESSION[$ssid]['MT'][$tree_id]->iterative_mark_delete($action, $id_item);
require 'header_ajax.php'; /*===================================================================*/ //================================================================== // ID item //================================================================== if (!isset($_POST["IDitem"])) { error_log_details('fatal', 'you need an item ID'); die; } $id_item = $_POST["IDitem"]; //================================================================== //================================================================== // Action //================================================================== if (!isset($_POST["action"])) { error_log_details('fatal', 'action is mandatory'); die; } $action = $_POST["action"]; //================================================================== switch ($action) { case 0: // Remove item from expansion list if (isset($_SESSION[$ssid]['MT'][$tree_id]->listexpand[$id_item])) { unset($_SESSION[$ssid]['MT'][$tree_id]->listexpand[$id_item]); } break; case 1: // Add item from expansion list $_SESSION[$ssid]['MT'][$tree_id]->listexpand[$id_item] = true; break;
require 'header_ajax.php'; /*===================================================================*/ //================================================================== // Get update mode //================================================================== if (!isset($_POST["mode"])) { error_log_details('fatal', 'you need a mode'); die; } $mode = $_POST["mode"]; //================================================================== //================================================================== // Get ID item node //================================================================== if (!isset($_POST["IDitem"])) { error_log_details('fatal', 'you need an item ID'); die; } $id_item = $_POST["IDitem"]; //================================================================== $_SESSION[$ssid]['MT'][$tree_id]->update_node($mode, $id_item, $_POST["caption"]); //================================================================== // Manage BBCode entities if setup //================================================================== $final_title = htmlentities($_POST["caption"], ENT_QUOTES); $final_title = str_replace(' ', ' ', $final_title); if ($_SESSION[$ssid]['MT'][$tree_id]->use_bbcode) { $final_title = $_SESSION[$ssid]['MT'][$tree_id]->convertBBCodetoHTML($final_title); } $retour = array("RENDERING" => $final_title, "RAW" => htmlentities($_POST["caption"], ENT_QUOTES)); echo json_encode($retour);