<?php if ($certificate->hasLastLog()) { ?> <div class="card"> <h3>Last log</h3> <pre><code><?php foreach (explode("\n", $certificate->getLastLog()) as $line) { if (preg_match('~ERROR:~', $line)) { echo '<strong>'; echo findLinks(er($line)); echo "</strong>\n"; } else { if (preg_match('~DEBUG:~', $line)) { echo '<span style="color: gray;">'; echo findLinks(er($line)); echo "</span>\n"; } else { echo er($line); echo "\n"; } } } ?> </code></pre> </div> <?php } ?> <div class="card">
function findLinks($titleurl, $depth, $maxDepth, $meetings) { #static $maxDepth = 4; print "titleurl" . $titleurl . "\n"; $dom = new simple_html_dom(); $html = scraperwiki::scrape($titleurl); $dom->load($html); print "depth" . $depth . "\n"; print "maxdepth" . $maxDepth . "\n"; if ($depth > 1) { $rows = $dom->find("div[id=data1] table tbody tr"); } else { $rows = $dom->find("div[id=data] table tbody tr"); } unset($rows[0]); if ($depth <= $maxDepth) { $count = 0; # $i=0; foreach ($rows as $row) { print "row" . "\n"; /* $check0 = $row->find("td a",0); print "check0" . $check0 . "\n"; $check1 = $row->find("td a",1); print "check1" . $check1 . "\n"; if ( (!empty($check0)) && (!empty($check1)) ) { print "both not empty" . "\n"; } if ( (empty($check0)) && (empty($check1)) ) { print "both empty" . "\n"; } if ( (!empty($check0)) && (!empty($check1)) ) { */ $uribase = "http://www.fingalcoco.ie/minutes/"; #print "row1" . $row ."\n"; #print "row2" . $rows[1] ."\n"; if ($depth > 2) { $titleurl = $row->find("td a", 1); } else { $titleurl = $row->find("td a", 0); } #$titleurl = $row->find("td a",0); #print "titleurl1" . $titleurl . "\n"; #$titleurl = $row->href; $title = strip_tags($titleurl); #print "title" . $title . "\n"; #print "titleurl2" . $titleurl . "\n"; $titleurl = $uribase . $titleurl->href; $titleurl = str_replace('../../minutes/', '', $titleurl); #$titleurl = $uribase . $titleurl; print "titleurl3" . $titleurl . "\n"; #year,comittee,meetingdate,minuteref,url if ($depth == 1) { $committee = ""; $year = $title; $meetingdate = ""; } elseif ($depth == 2) { $committee = $title; $year = $meetings["year"]; #print "year" . $meetings["year"]; $meetingdate = ""; } elseif ($depth == 3) { $committee = $meetings["committee"]; #print "3committee" . $meetings["committee"]; $year = $meetings["year"]; #print "3year" . $meetings["year"]; $meetingdate = $title; } elseif ($depth == 4) { $committee = $meetings["committee"]; #print "4committee" . $meetings["committee"]; $year = $meetings["year"]; #print "4year" . $meetings["year"]; $meetingdate = $meetings["meetingdate"]; #print "4meetingdate" . $meetings["meetingdate"]; } else { $committee = "committeeelse"; $year = "yearelse"; $meetingdate = "meetingdateelse"; } if ($depth == 4) { print "yes"; #$meetingdetails = get_meetingdetails($titleurl); $meetingdetails = get_extras($titleurl); print "meetingdetails" . print_r($meetingdetails) . "\n"; /* $councillors["$name"] = array( "name" => $meetingdetails["name"], "Url" => $meetingdetails["url"], "Reply" => $meetingdetails["reply"], "Question" => $meetingdetails["question"], "Cllrq" => $meetingdetails["cllrq"], "Qtype" => $meetingdetails["qtype"], #, #, "Response" => $meetingdetails["response"] #, #, ); #} $name = $councillors["name"]; $url = $councillors["url"]; $reply = $councillors["reply"]; $question = $councillors["question"]; $cllrq = $councillors["cllrq"]; $qtype = $councillors["qtype"]; $response = $councillors["response"]; */ $reply = $meetingdetails["reply"]; $question = $meetingdetails["question"]; $cllrq = $meetingdetails["cllrq"]; $qtype = $meetingdetails["qtype"]; $response = $meetingdetails["response"]; } else { $url = "urlelse"; $reply = "replyelse"; $question = "questionelse"; $cllrq = "cllrqelse"; $qtype = "qtypeelse"; $response = "responseelse"; } $meetings = array('depth' => $depth, 'year' => $year, 'committee' => $committee, 'meetingdate' => $meetingdate, 'title' => $title, 'titleurl' => $titleurl, 'name' => $name, 'reply' => $reply, 'question' => $question, 'cllrq' => $cllrq, 'qtype' => $qtype, 'response' => $response); scraperwiki::save(array('titleurl', 'title'), $meetings); #} findLinks($titleurl, $depth + 1, $maxDepth, $meetings); # } # $i++; # if($i==3) break; } } }
function findLinks($titleurl, $depth, $maxDepth, $meetings) { #static $maxDepth = 4; print "titleurl" . $titleurl . "\n"; $dom = new simple_html_dom(); $html = scraperwiki::scrape($titleurl); $dom->load($html); print "depth" . $depth . "\n"; print "maxdepth" . $maxDepth . "\n"; if ($depth > 1) { $rows = $dom->find("div[id=data1] table tbody tr"); } else { $rows = $dom->find("div[id=data] table tbody tr"); } unset($rows[0]); if ($depth <= $maxDepth) { $count = 0; # $i=0; foreach ($rows as $row) { print "row" . "\n"; /* $check0 = $row->find("td a",0); print "check0" . $check0 . "\n"; $check1 = $row->find("td a",1); print "check1" . $check1 . "\n"; if ( (!empty($check0)) && (!empty($check1)) ) { print "both not empty" . "\n"; } if ( (empty($check0)) && (empty($check1)) ) { print "both empty" . "\n"; } if ( (!empty($check0)) && (!empty($check1)) ) { */ $uribase = "http://www.fingalcoco.ie/minutes/"; #print "row1" . $row ."\n"; #print "row2" . $rows[1] ."\n"; if ($depth > 2) { $titleurl = $row->find("td a", 1); } else { $titleurl = $row->find("td a", 0); } #$titleurl = $row->find("td a",0); #print "titleurl1" . $titleurl . "\n"; #$titleurl = $row->href; $title = strip_tags($titleurl); $meetingdate = $row->find("td a", 0); $meetingdate = strip_tags($meetingdate); #print "title" . $title . "\n"; #print "titleurl2" . $titleurl . "\n"; $titleurl = $uribase . $titleurl->href; $titleurl = str_replace('../../minutes/', '', $titleurl); #$titleurl = $uribase . $titleurl; print "titleurl3" . $titleurl . "\n"; #year,comittee,meetingdate,minuteref,url if ($depth == 1) { $committee = ""; $year = $title; $meetingdate = ""; } elseif ($depth == 2) { $committee = $title; $year = $meetings["year"]; #print "year" . $meetings["year"]; $meetingdate = ""; } elseif ($depth == 3) { $committee = $meetings["committee"]; #print "3committee" . $meetings["committee"]; $year = $meetings["year"]; #print "3year" . $meetings["year"]; # $meetingdate = $meetings["meetingdate"]; } elseif ($depth == 4) { $committee = $meetings["committee"]; #print "3committee" . $meetings["committee"]; $year = $meetings["year"]; #print "3year" . $meetings["year"]; # $meetingdate = $meetings["meetingdate"]; } else { $committee = "committeeelse"; $year = "yearelse"; $meetingdate = "meetingdateelse"; } $meetings = array('depth' => $depth, 'year' => $year, 'committee' => $committee, 'meetingdate' => $meetingdate, 'title' => $title, 'titleurl' => $titleurl, 'name' => $name); scraperwiki::save(array('titleurl', 'title'), $meetings); #} findLinks($titleurl, $depth + 1, $maxDepth, $meetings); # } # $i++; # if($i==3) break; } } }
public function setNode($node, $force = FALSE, $action = "SaveNode") { global $system; global $ignoreValidationErrors; global $trackNodeContext; $execute = TRUE; $next = array(); $new = FALSE; $isDelta = FALSE; $deltaReport = array(); $reviewState = 0; if (isset($node["node"]["Node_id"]) && $node["node"]["Node_id"] !== FALSE && isset($node["node"]["Parent_id"]) && isset($node["node"]["Type"])) { if (isset($node["Errors"])) { unset($node["Errors"]); } $nodeId = $node["node"]["Node_id"]; $nodeType = $node["node"]["Type"]; $nodeType2 = $node["node"]["Type"]; $nodeParent = $node["node"]["Parent_id"]; if (isset($node["node"]["Review"])) { $nodeReview = $node["node"]["Review"]; } else { $nodeReview = 0; } if (isset($node["node"]["Review_member"])) { $nodeReviewMember = $node["node"]["Review_member"]; } else { $nodeReviewMember = 0; } $controlInfo = getNodeContext($nodeId, FALSE, TRUE); if (!$controlInfo) { $new = TRUE; } // print_r($controlInfo); if ($node["node"]["Node_id"] == 0) { $new = TRUE; $next = getNextFreeIds("mt_main", $system["Offset"], FALSE, 0); $node["node"]["Node_id"] = $next[0]; $nodeId = $next[0]; } if ($new) { $isDelta = TRUE; $controlInfo = array(); $controlInfo["node"] = array("Node_id" => $nodeId, "Parent_id" => $nodeParent, "Title" => "", "Image" => "", "Type" => $nodeType, "Protected" => 0, "Review" => 0, "Review_member" => 0, "Update" => 0); $controlInfo["data"] = array("Review" => 0, "Rights" => "", "Dependancies" => "", "Values" => array()); $controlInfo["rights"] = array(); $attributes = array(); $attributesKeys = array(); if (isset($system["Types"][$nodeType2]["__Fields__"])) { $typeAttributes = $system["Types"][$nodeType2]["__Fields__"]; } else { $typeAttributes = array(); } $attributesMultiLang = array(); $attributesNames = array(); $keys_typeAtt = array_keys($typeAttributes); for ($i = 0; $i < count($keys_typeAtt); $i++) { $cf = $typeAttributes[$keys_typeAtt[$i]]; $value = ""; $attributesKey = $cf["__Name__"]; $attributesKeys[] = $attributesKey; $attributesNames[$cf["__Name__"]] = ""; $attributes[$attributesKey] = $cf; if ($cf["Monolingual"] == 0) { $attributesMultiLang[$attributesKey] = ""; } echo $fieldId = $keys_typeAtt[$i]; $fieldType = $cf["BaseType"]; $fieldName = $cf["__Name__"]; $keys = array_keys($system["Languages"]); for ($j = 0; $j < count($keys); $j++) { $language = translateIds2old("Languages", $keys[$j]); if (!isset($node["data"]["Values"][$language][$attributesKey])) { $node["data"]["Values"][$language][$attributesKey] = ""; } else { $controlInfo["data"]["Values"][$language][$attributesKey] = ""; } } } } // print_r($controlInfo); if (!isset($controlInfo["rights"])) { $controlInfo["rights"] = array(); } if (!isset($node["node"]["Position"])) { $node["node"]["Position"] = 0; } if (!isset($node["node"]["Protected"])) { $node["node"]["Protected"] = 0; } if (!isset($node["node"]["Review"])) { $node["node"]["Review"] = 0; } if (!isset($node["node"]["Review_member"])) { $node["node"]["Review_member"] = 0; } if (!isset($node["node"]["Image"])) { $node["node"]["Image"] = $system["Types"][$nodeType2]["__Icon__"]; } $node["node"]["Update"] = date("YmdHis"); // #################### Workflow #################### if ($nodeReviewMember != 0 && $node["node"]["Review_member"] != $controlInfo["node"]["Review_member"]) { // echo "bad way to change RMember..."; $node["node"]["Review_member"] = $controlInfo["node"]["Review_member"]; } if ($nodeReviewMember != 0) { if (isset($node["node"]["NewReview_member"]) && isset($node["node"]["Review_Comment"])) { $member = getReviewMemberInfo($nodeReviewMember); $oldReviewMemberId = $node["node"]["Review_member"]; $reviewMemberId = $node["node"]["NewReview_member"]; if ($oldReviewMemberId != $reviewMemberId) { $node["node"]["Review_member"] = $reviewMemberId; if (isset($member["mt_review_levels_Change_Action"]) && trim($member["mt_review_levels_Change_Action"] != "")) { eval("?" . ">" . $member["mt_review_levels_Change_Action"]); } if (isset($member["mt_review_members_Change_Action"]) && trim($member["mt_review_members_Change_Action"] != "")) { eval("?" . ">" . $member["mt_review_members_Change_Action"]); } $actor = getNodeContext($_SESSION["User"]["User_id"]); $newState = getReviewMemberInfo($reviewMemberId); if ($newState["mt_review_members_User_id"] != 0) { $user = getNodeContext($newState["mt_review_members_User_id"]); } else { $user["node"] = array("Node_id" => 0, "Title" => "Open User Definition"); } $fileStream = date("YmdHis") . ";"; $fileStream .= $member["mt_review_levels_Name"] . ";"; $fileStream .= $actor["node"]["Node_id"] . ";"; $fileStream .= str_replace(";", ",", $actor["node"]["Title"]) . ";"; $fileStream .= $oldReviewMemberId . ";"; $fileStream .= $reviewMemberId . ";"; $fileStream .= $user["node"]["Node_id"] . ";"; $fileStream .= str_replace(";", ",", $user["node"]["Title"]) . ";"; $fileStream .= serialize($node["node"]["Review_Comment"]) . "\r\n"; $fileName = $system["systemFilePath"] . "log/" . $node["node"]["Node_id"] . "_review.log"; appendLogFile($fileName, $fileStream); } $nodeReviewMember = $reviewMemberId; } $member = getReviewMemberInfo($nodeReviewMember); if (isset($member["mt_review_levels_Position"]) && $member["mt_review_levels_Position"] > 10) { $reviewState = 1; } else { $reviewState = 0; } $node["node"]["Review"] = $reviewState; $node["data"]["Review"] = $reviewState; } // ################## Extra Code #################### if ($execute) { if ($new) { if (trim($system["Types"][$nodeType2]["Creation_Code"])) { eval("?" . ">" . $system["Types"][$nodeType2]["Creation_Code"]); } } else { if ($node["node"]["Parent_id"] == 3) { if (trim($system["Types"][$nodeType2]["Erase_Code"])) { eval("?" . ">" . $system["Types"][$nodeType2]["Erase_Code"]); } findLinks($node["node"]["Node_id"], $execute); } else { if (trim($system["Types"][$nodeType2]["Save_Code"])) { eval("?" . ">" . $system["Types"][$nodeType2]["Save_Code"]); } } } } // ################################################## $DBArray = array(); $DBArray["table"] = "mt_main"; $DBArray["master"]["mt_main_Node_id"] = $nodeId; $DBArray["master"]["mt_main_Review"] = $reviewState; $DBArray["data"]["mt_main_Parent_id"] = $nodeParent; $DBArray["data"]["mt_main_Title"] = $node["node"]["Title"]; $DBArray["data"]["mt_main_Image"] = $node["node"]["Image"]; $DBArray["data"]["mt_main_Type"] = $nodeType; $DBArray["data"]["mt_main_Position"] = $node["node"]["Position"]; $DBArray["data"]["mt_main_Protected"] = $node["node"]["Protected"]; $DBArray["data"]["mt_main_Review_member"] = $node["node"]["Review_member"]; $DBArray["data"]["mt_main_Update"] = $node["node"]["Update"]; $nodeQuery = generateSQL($DBArray); // ################################################## if (!isset($node["node"])) { $node["node"] = array(); } if (!isset($controlInfo["node"])) { $controlInfo["node"] = array(); } $diff = array_diff_assoc($controlInfo["node"], $node["node"]); if (isset($diff["Update"])) { unset($diff["Update"]); } if (count($diff)) { $deltaReport["node"] = $diff; } // ################################################## if (!isset($node["data"]) || !is_array($node["data"])) { $node["data"] = array(); } if (!isset($node["data"]["Review"])) { $node["data"]["Review"] = $reviewState; } if (!isset($node["data"]["Rights"])) { $node["data"]["Rights"] = array(); } if (!isset($node["data"]["Dependancies"])) { $node["data"]["Dependancies"] = ""; } if (!isset($node["data"]["Values"])) { $node["data"]["Values"] = array(); } if (!is_array($controlInfo["data"]["Rights"])) { $controlInfo["data"]["Rights"] = array(); } if (!is_array($node["data"]["Rights"])) { $node["data"]["Rights"] = array(); } if (!isset($controlInfo["rights"]) || !is_array($controlInfo["rights"])) { $controlInfo["rights"] = array(); } if (!isset($node["rights"]) || !is_array($node["rights"])) { $node["rights"] = array(); } $DeltaArray = array(); if (!isset($controlInfo["data"])) { $controlInfo["data"] = array(); } $diff = array_diff_assoc($controlInfo["data"], $node["data"]); if (count($diff)) { $deltaReport["data"] = $diff; $isDelta = TRUE; } $keys = array_keys($system["Languages"]); for ($i = 0; $i < count($keys); $i++) { $Lang_id = translateIds2old("Languages", $keys[$i]); $Delta = array(); if (isset($node["data"]["Values"][$Lang_id])) { // ["data"]["Values"][$Lang_id] if (!isset($controlInfo["data"]["Values"][$Lang_id])) { $controlInfo["data"]["Values"][$Lang_id] = array(); } $diff = array_diff_assoc($controlInfo["data"]["Values"][$Lang_id], $node["data"]["Values"][$Lang_id]); if (count($diff)) { $deltaReport["data"]["Values"][$Lang_id] = $diff; $isDelta = TRUE; } $Delta = array_merge($controlInfo["data"]["Values"][$Lang_id], $node["data"]["Values"][$Lang_id]); $DeltaArray[$Lang_id] = $Delta; } } $nodeInfo = $node; // echo "<pre>"; // print_r($system["Types"][$nodeType2]); // Workaround until complete change of rights $rightsData = FALSE; if (isset($node["rights"]) && is_array($node["rights"])) { $diff = array_diff_assoc($node["rights"], $controlInfo["rights"]); if (count($diff)) { if (isset($node["data"]["Rights"])) { $diff = array_diff_assoc($node["data"]["Rights"], $controlInfo["data"]["Rights"]); if (!count($diff)) { $node["data"]["Rights"] = $node["rights"]; } } } } if (isset($node["data"]["Rights"])) { $diff = array_diff_assoc($node["data"]["Rights"], $controlInfo["data"]["Rights"]); if (count($diff)) { $isDelta = TRUE; $right = array_merge($controlInfo["data"]["Rights"], $node["data"]["Rights"]); $empty = array(); if (version_compare(phpversion(), "5.0.1") >= 0) { $empty = array_keys($node["data"]["Rights"], "", TRUE); } else { $empty = array_keys($node["data"]["Rights"], ""); } for ($i = 0; $i < count($empty); $i++) { if (isset($node["data"]["Rights"][$empty[$i]])) { unset($node["data"]["Rights"][$empty[$i]]); } } $deltaReport["data"]["Rights"] = $node["data"]["Rights"]; } } if ($isDelta || $ignoreValidationErrors) { $attributes = array(); $attributesKeys = array(); $typeAttributes = array(); if (isset($system["Types"][$nodeType2]["__Fields__"])) { $typeAttributes = $system["Types"][$nodeType2]["__Fields__"]; } $attributesMultiLang = array(); $attributesNames = array(); $keys_typeAtt = array_keys($typeAttributes); for ($i = 0; $i < count($keys_typeAtt); $i++) { $cf = $typeAttributes[$keys_typeAtt[$i]]; $cf["Unique"] = $keys_typeAtt[$i]; $attributesKey = $cf["__Name__"]; $attributesKeys[] = $attributesKey; $attributesNames[$cf["__Name__"]] = ""; $attributes[$attributesKey] = $cf; if (isset($cf["Monolingual"]) && $cf["Monolingual"] == 0) { $attributesMultiLang[$attributesKey] = ""; } } $Data = array(); if (!isset($controlInfo["data"]) || !isset($controlInfo["data"]["Values"]) || !isset($controlInfo["data"]["Values"][1])) { $controlInfo["data"]["Values"][1] = array(); } if (!isset($DeltaArray[1])) { $DeltaArray[1] = array(); } $MainData = array_merge($attributesNames, $controlInfo["data"]["Values"][1], $DeltaArray[1]); $keys = array_keys($system["Languages"]); for ($j = 0; $j < count($keys); $j++) { $language = translateIds2old("Languages", $keys[$j]); for ($i = 0; $i < count($attributesKeys); $i++) { $cf = $attributes[$attributesKeys[$i]]; $value = FALSE; $nodeInfo = $node; $fieldId = $cf["Unique"]; $fieldId = $attributes[$attributesKeys[$i]]["Id"]; // ALTLAST $fieldName = $attributes[$attributesKeys[$i]]["__Name__"]; $fieldType = $attributes[$attributesKeys[$i]]["BaseType"]; if ($cf["Monolingual"] == 1) { $fieldLanguage = 1; } else { $fieldLanguage = $language; } if ($fieldLanguage == 1) { if ($fieldLanguage == $language) { $value = $MainData[$attributesKeys[$i]]; } } else { if (isset($DeltaArray[$language][$attributesKeys[$i]])) { $value = $DeltaArray[$language][$attributesKeys[$i]]; } } if ($value !== FALSE) { $Data[$language][$fieldId] = $value; } } } $DBArray = array(); $DBArray["table"] = "mt_data"; $DBArray["master"]["mt_data_Node_id"] = $node["node"]["Node_id"]; $DBArray["master"]["mt_data_Review"] = $reviewState; $DBArray["data"]["mt_data_Type"] = $nodeType; $DBArray["data"]["mt_data_Dependencies"] = " " . trim($node["data"]["Dependancies"]) . " "; if (count($node["data"]["Rights"])) { $DBArray["data"]["mt_data_Rights"] = serialize($node["data"]["Rights"]); } else { $DBArray["data"]["mt_data_Rights"] = ""; } if (count($Data)) { $DBArray["data"]["mt_data_Value"] = serialize($Data); } else { $DBArray["data"]["mt_data_Value"] = ""; } $dataQuery = generateSQL($DBArray); } // print_r($node); if ($node["node"]["Parent_id"] == 3 && isset($node["Errors"])) { unset($node["Errors"]); } // ################################################## if ((!isset($node["Errors"]) || $ignoreValidationErrors && isset($node["Errors"]) || $new || $force) && $reviewState != -1) { if ($execute) { if (isset($nodeQuery)) { mysql_query($nodeQuery, $system["dbCon"]); } if (isset($dataQuery)) { mysql_query($dataQuery, $system["dbCon"]); } // if(isset($rightQuery)) mysql_query($rightQuery,$system["dbCon"]); if ($trackNodeContext && count($deltaReport) && isset($_SESSION["User"]["User_id"]) && $_SESSION["User"]["User_id"]) { $u = getNodeContext($_SESSION["User"]["User_id"]); $fileStream = date("YmdHis") . ";" . str_replace(";", ",", $action) . ";"; $fileStream .= $u["node"]["Node_id"] . ";" . str_replace(";", ",", $u["node"]["Title"]) . ";"; $fileStream .= str_replace("\r", "\\r", str_replace("\n", "\\n", serialize($deltaReport))) . "\r\n"; $fileName = $system["systemFilePath"] . "log/" . $node["node"]["Node_id"] . ".txt"; appendLogFile($fileName, $fileStream); } // if(isset($system["Types"][$nodeType2]["Save_Code"]) && trim($system["Types"][$nodeType2]["Save_Code"])!="") { // $reason = FALSE; // eval("?".">".$system["Types"][$nodeType2]["Save_Code"]); // if($reason!==FALSE) $node["Errors"][$fieldName] = $reason; // } if ($reviewState === 0) { $dbQuery = "DELETE FROM mt_main WHERE mt_main_Node_id='" . $node["node"]["Node_id"] . "' AND mt_main_Review='1';"; mysql_query($dbQuery, $system["dbCon"]); $dbQuery = "DELETE FROM mt_data WHERE mt_data_Node_id='" . $node["node"]["Node_id"] . "' AND mt_data_Review='1';"; mysql_query($dbQuery, $system["dbCon"]); } } else { echo "<pre>"; print_r($deltaReport); echo "</pre>"; if (isset($nodeQuery)) { echo $nodeQuery . "<br/>"; } if (isset($dataQuery)) { echo $dataQuery . "<br/>"; } if ($reviewState === 0) { $dbQuery = "DELETE FROM mt_main WHERE mt_main_Node_id='" . $node["node"]["Node_id"] . "' AND mt_main_Review='1';"; echo $dbQuery . "<br/>"; $dbQuery = "DELETE FROM mt_data WHERE mt_data_Node_id='" . $node["node"]["Node_id"] . "' AND mt_data_Review='1';"; echo $dbQuery . "<br/>"; } } } // ################################################## } else { $node = FALSE; } // ################################################## // Workaround until complete change of rights // $node["rights"] = $node["data"]["Rights"]; unset($node["rights"]); // ################################################## return $node; }