$comment = convertData($comment);
//insert into organizations and redirect to new client organization detail (last id)
$tmpquery1 = "INSERT INTO " . $tableCollab["newsdeskcomments"] . "(name,post_id,comment) VALUES ('{$name}','{$postid}' , '" . addslashes($comment) . "')";
connectSql("{$tmpquery1}");
$tmpquery = $tableCollab["newsdeskcomments"];
last_id($tmpquery);
$num = $lastId[0];
unset($lastId);
headerFunction("../newsdesk/viewnews.php?id={$postid}&msg=add&" . session_name() . "=" . session_id());
}
}
}
include '../themes/' . THEME . '/header.php';
$tmpquery2 = "WHERE news.id = '{$postid}'";
$newsDetail = new request();
$newsDetail->openNewsDesk($tmpquery2);
$blockPage = new block();
$blockPage->openBreadcrumbs();
$blockPage->itemBreadcrumbs($blockPage->buildLink("../newsdesk/listnews.php?", $strings["newsdesk"], in));
$blockPage->itemBreadcrumbs($blockPage->buildLink("../newsdesk/viewnews.php?id={$postid}", $newsDetail->news_title[0], in));
if ($id == "") {
$blockPage->itemBreadcrumbs($strings["add_newsdesk_comment"]);
} elseif ($action == "remove") {
$blockPage->itemBreadcrumbs($commentAuthor->mem_name[0]);
$blockPage->itemBreadcrumbs($strings["del_newsdesk_comment"]);
} else {
$blockPage->itemBreadcrumbs($commentAuthor->mem_name[0]);
$blockPage->itemBreadcrumbs($strings["edit_newsdesk_comment"]);
}
$blockPage->closeBreadcrumbs();
if ($msg != "") {
$ckeckedrss = '';
}
} else {
$ckeckedrss = 'checked';
}
$block1->contentRow($strings["newsdesk_rss"], "<input size='32' value='1' name='rss' type='checkbox' {$ckeckedrss}>");
// end
$block1->contentRow($strings[""], "<input type='submit' name='submit' value='" . $strings["save"] . "'> <input type='button' name='cancel' value='" . $strings["cancel"] . "' onClick='history.back();'>");
$block1->closeContent();
$block1->closeForm();
} else {
//remove
$block1->form = "saP";
$block1->openForm("../newsdesk/editnews.php?action=delete&id={$id}&" . session_name() . "=" . session_id());
$block1->heading($strings["del_newsdesk"]);
$block1->openContent();
$block1->contentTitle($strings["delete_following"]);
$id = str_replace("**", ",", $id);
$tmpquery = "WHERE news.id IN({$id}) ORDER BY news.pdate";
$listNews = new request();
$listNews->openNewsDesk($tmpquery);
$comptListNews = count($listNews->news_id);
for ($i = 0; $i < $comptListNews; $i++) {
$block1->contentRow("#" . $listNews->news_id[$i], $listNews->news_title[$i]);
}
$block1->contentRow("", "<input type='submit' name='delete' value='" . $strings["delete"] . "'> <input type='button' name='cancel' value='" . $strings["cancel"] . "' onClick='history.back();'>");
$block1->closeContent();
$block1->closeForm();
$block1->note($strings["delete_news_note"]);
}
include '../themes/' . THEME . '/footer.php';
$block1->openPaletteIcon();
if ($profilSession == "0" || $profilSession == "1" || $profilSession == "5") {
$block1->paletteIcon(0, "add", $strings["add_newsdesk"]);
$block1->paletteIcon(1, "remove", $strings["del_newsdesk"]);
$block1->paletteIcon(2, "edit", $strings["edit_newsdesk"]);
}
$block1->paletteIcon(3, "info", $strings["view_newsdesk"]);
$block1->closePaletteIcon();
$block1->borne = $blockPage->returnBorne("1");
$block1->rowsLimit = "40";
$block1->sorting("newsdesk", $sortingUser->sor_newsdesk[0], "news.pdate DESC", $sortingFields = array(0 => "news.title", 1 => "news.pdate"));
$block1->openContent();
$tmpquery = "WHERE news.id != '0' ORDER BY {$block1->sortingValue} ";
$block1->recordsTotal = compt($initrequest["newsdeskposts"] . " " . $tmpquery);
$listPosts = new request();
$listPosts->openNewsDesk($tmpquery, $block1->borne, $block1->rowsLimit);
$comptPosts = count($listPosts->news_id);
if ($comptPosts != "0") {
$block1->openResults();
$block1->labels($labels = array(0 => $strings["topic"], 1 => $strings["date"], 2 => $strings["author"], 3 => $strings["newsdesk_related"]), "true");
for ($i = 0; $i < $comptPosts; $i++) {
// take the news author
$tmpquery_user = "******" . $listPosts->news_author[$i] . "' ";
$newsAuthor = new request();
$newsAuthor->openMembers($tmpquery_user);
// take the name of the related article
if ($listPosts->news_related[$i] != 'g') {
$tmpquery = "WHERE pro.id = '" . $listPosts->news_related[$i] . "'";
$projectDetail = new request();
$projectDetail->openProjects($tmpquery);
$article_related = "<a href='../projects/viewproject.php?id=" . $projectDetail->pro_id[0] . "' title='" . $projectDetail->pro_name[0] . "'>" . $projectDetail->pro_name[0] . "</a>";
