$uti_id = $row[2];
$uti_data_keys = array_keys($uti_data);
for ($j = 0; $j < count($uti_data_keys); $j++) {
if (in_array($uti_data_keys[$j], $SpecialFields)) {
$complex = getNodeContext($uti_data[$uti_data_keys[$j]]);
$uti_data[$uti_data_keys[$j]] = $complex["node"]["Title"];
}
}
}
if ($row[4] != $faci_id) {
$faci_data = getNodeContent($row[4]);
$faci_id = $row[4];
$faci_data_keys = array_keys($faci_data);
for ($j = 0; $j < count($faci_data_keys); $j++) {
if (in_array($faci_data_keys[$j], $SpecialFields)) {
$complex = getNodeContext($faci_data[$faci_data_keys[$j]]);
$faci_data[$faci_data_keys[$j]] = $complex["node"]["Title"];
}
}
}
if ($row[6] != $user_id) {
$user_data = getNodeContent($row[6]);
$user_id = $row[6];
}
$newStream = array_merge($stream, $uti_data, $faci_data, $user_data);
echo implode(";", $data[$i]);
echo ";" . implode(";", $newStream);
echo "";
echo "\r\n";
}
break;
case "mt_tools_run":
if ($type) {
$name = $system["Types"][$type]["__Name__"];
$Type_Dependancies = " " . trim($system["Types"][$type]["__Filters__"]) . " ";
$FileName = $name . "_" . date("YmdHis") . ".csv";
$allMaintreeData = getMaintreeData();
$DepLeafArray = array();
$AllDepArray = array();
$AllDepArray[$DependancyMainNodeId] = array("mt_main_Node_id" => $DependancyMainNodeId, "mt_main_Title" => "Main");
$DBQuery = "SELECT * FROM mt_main WHERE (mt_main_Type=10256 OR mt_main_Type=10257 OR mt_main_Type=10258) AND mt_main_Parent_id>'4' ORDER BY mt_main_Parent_id,mt_main_Position;";
$DBResult = $system["dbConEx"]->query($DBQuery);
if ($DBResult) {
foreach ($DBResult as $DBContent) {
if (strpos($Type_Dependancies, " " . $DBContent["mt_main_Node_id"] . " ") !== FALSE) {
if ($DBContent["mt_main_Type"] == 48) {
$NC = getNodeContext($DBContent["mt_main_Node_id"]);
$NC_Type = $NC["data"]["Values"][1]["Type"];
if ($NC_Type) {
$DBQuery2 = "SELECT * FROM mt_main WHERE mt_main_Type='" . $NC_Type . "' AND mt_main_Parent_id>'4' ORDER BY mt_main_Parent_id,mt_main_Position;";
$DBResult2 = $system["dbConEx"]->query($DBQuery2);
if ($DBResult2) {
foreach ($DBResult2 as $DBContent2) {
// print_r($DBContent2);
$DBContent2["mt_main_Parent_id"] = $DBContent["mt_main_Parent_id"];
$AllDepArray[$DBContent2["mt_main_Node_id"]] = $DBContent2;
$DepParent_List[] = $DBContent2["mt_main_Parent_id"];
}
}
}
} else {
$AllDepArray[$DBContent["mt_main_Node_id"]] = $DBContent;
}
}
$slaveIds = array();
if ($system["Applications"][$type]["Slave_Type"] != 0) {
$dbQuery = "SELECT * FROM mt_main WHERE mt_main_Type=" . $system["Applications"][$type]["Slave_Type"] . " AND mt_main_Parent_id>4 ORDER BY mt_main_Parent_id,mt_main_Position;";
$dbResult = $system["dbConEx"]->query($dbQuery);
if ($dbResult) {
foreach ($dbResult as $dbContent) {
if (in_array($dbContent["mt_main_Node_id"], $usedSlaveKeys)) {
$slaveIds[$dbContent["mt_main_Node_id"]] = array($dbContent["mt_main_Parent_id"], $dbContent["mt_main_Title"]);
}
}
}
} else {
for ($i = 0; $i < count($usedSlaveKeys); $i++) {
$node = getNodeContext($usedSlaveKeys[$i]);
$slaveIds[$usedSlaveKeys[$i]] = array($node["node"]["Parent_id"], $node["node"]["Title"]);
}
}
$allMaintreeData = getMaintreeData();
$Parent_id_Old = 0;
$Text = "";
$slaveKeys = array_keys($slaveIds);
$slaveTitles = array();
$slaveBreadcrumbs = array();
for ($i = 0; $i < count($slaveKeys); $i++) {
$slaveTitles[] = $slaveIds[$slaveKeys[$i]][1];
$Parent_id = $slaveIds[$slaveKeys[$i]][0];
if ($Parent_id != $Parent_id_Old) {
$Text = "";
$Breadcrumb = getBreadcrumb($Parent_id);
}
$selectedNewsletter = 0;
if (isset($_POST["selectedNewsletter"]) && isset($newsletter[$_POST["selectedNewsletter"]])) {
$selectedNewsletter = $_POST["selectedNewsletter"];
}
$users = array();
if ($selectedNewsletter) {
$dbQuery = "SELECT * FROM mt_data WHERE mt_data_Rights LIKE '% " . $selectedNewsletter . "_%';";
$dbResult = $system["dbConEx"]->query($dbQuery);
if ($dbResult) {
foreach ($dbResult as $dbContent) {
$users[] = $dbContent["mt_data_Node_id"];
}
}
// ##################################################
$node = getNodeContext($selectedNewsletter);
$subject = $node["data"]["Values"]["1"]["Subject"];
$banner = "images/" . $node["data"]["Values"]["1"]["Banner"];
$group = $node["data"]["Values"]["1"]["Group"];
// ##################################################
$mailContent = "";
$mailContent .= "<div style=\"width:773px;background:#FFFFFF;color:#000000;\">\r\n";
$mailContent .= "<div style=\"position:absolute;left:44px;\"><img src=\"" . $system["baseUrl"] . "themes/" . $system["theme"] . "/logo.png\" alt=\"\"/></div>\r\n";
$mailContent .= "<div style=\"background-color:#949eaa;margin:0px;\">\r\n";
$mailContent .= "<div style=\"width:350px;height:90px;background-color:#afb4be;float:left;border-right:solid 2px #FFFFFF;\"></div>\r\n";
$mailContent .= "<div style=\"height:90px;width:420px;overflow:hidden;\">";
if (file_exists($system["contentPath"] . $banner)) {
$mailContent .= "<img src=\"" . $system["contentUrl"] . $banner . "\" alt=\"\"/>";
}
$mailContent .= "</div>\r\n";
$mailContent .= "<div style=\"border-top:solid 1px #FFFFFF;background:#d0d3da;height:24px;font-family:Arial;font-size:11px;line-height:24px;padding-left:44px;\">" . $group . "</div>\r\n";
public function getNodeContent($id, $lang = FALSE, $force = false)
{
global $system;
if (!$lang) {
$lang = $_SESSION["User"]["Language_id"];
}
if (!isset($lang)) {
$lang = 1;
}
$attributes = array();
$nodeInfo = getNodeContext($id, $force);
if (isset($nodeInfo["data"]["Values"][$lang])) {
$attributes = $nodeInfo["data"]["Values"][$lang];
}
return $attributes;
}
$dataOriginalSize = count(explode(" ", trim($transferData)));
echo $dataOriginalSize . " Entries<br/><br/>";
echo "<button type=\"button\" onclick=\"changeContent('mt_tools_run');\">Go</button>";
echo "<button type=\"button\" onclick=\"toggleView('transferView');\">Show Data</button><br/>";
} else {
$dataOriginalSize = 0;
echo "<button type=\"button\" onclick=\"changeContent('mt_tools');\">Reload</button>";
}
break;
case "mt_tools_run":
$data = explode(" ", $transferData);
$progress = 100 * (1 - count($data) / $dataOriginalSize);
do {
$item = array_shift($data);
//########## ##########
getNodeContext($item, TRUE);
//########## ##########
} while (count($data) && $loop-- > 1);
if ($progress > 100) {
$progress = 100;
}
echo number_format($progress) . "% of " . $dataOriginalSize . "<br/>";
$transferData = " " . implode(" ", $data) . " ";
$actionMsg[] = "changeContent('mt_tools_run');";
break;
case "mt_tools_finished":
echo "<button type=\"button\" onclick=\"changeContent('mt_tools');\">Back</button>";
break;
}
echo "<input name=\"dataOriginalSize\" type=\"hidden\" value=\"" . $dataOriginalSize . "\"/>";
echo "<div id=\"transferView\" style=\"display:none;\">";
