* 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);
