function findSidebarOrphans($id)
{
global $connection;
$request = "SELECT * FROM page_descriptors WHERE id='{$id}'";
$result = $connection->query($request);
$line = $result->fetch_assoc();
$json_decoded = json_decode($line["descriptor"]);
$container = $line["container"];
$page = $line["page"];
if (isset($json_decoded->sidebar_elements)) {
foreach ($json_decoded->sidebar_elements as $element) {
isOrphan($element->dbid, $page, $container);
}
}
}
function sortByThread($array)
{
$data = array();
$data["Count"] = $array["Count"];
for ($i = 0; $i < $array["Count"]; $i++) {
if ($array[$i]['Id_answered'] == "" || isOrphan($array[$i]['Id_answered'], $array)) {
$data[] = array_merge($array[$i], array('Thread_status' => 0));
$childs = getChildsThread($array[$i]['Id'], $array, 0);
if (isset($childs) && is_array($childs) && count($childs)) {
$data = array_merge($data, $childs);
}
}
}
return $data;
}
