$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>";