$block5->rowsLimit = "10";
$block5->sorting("home_discussions", $sortingUser->sor_home_discussions[0], "topic.last_post DESC", $sortingFields = array(0 => "topic.subject", 1 => "mem.login", 2 => "topic.posts", 3 => "topic.last_post", 4 => "topic.status", 5 => "topic.project", 6 => "topic.published"));
if ($projectsFilter == "true") {
if ($comptListProjectsFilter != "0") {
$tmpquery = "{$searchTopics} AND topic.project IN({$filterResults}) ORDER BY {$block5->sortingValue}";
} else {
$validTopics = "false";
}
} else {
$tmpquery = "{$searchTopics} ORDER BY {$block5->sortingValue}";
}
$comptListTopics = "0";
if ($validTopics == "true") {
$block5->recordsTotal = compt($initrequest["topics"] . " " . $tmpquery);
$listTopics = new request();
$listTopics->openTopics($tmpquery, $block5->borne, $block5->rowsLimit);
$comptListTopics = count($listTopics->top_id);
// echo "$tmpquery<br>";
}
$block6 = new block();
$comptTopic = count($topicNote);
$block6->borne = $blockPage->returnBorne("6");
$block6->rowsLimit = "10";
if ($comptTopic != "0") {
$block6->sorting("notes", $sortingUser->sor_notes[0], "note.date DESC", $sortingFields = array(0 => "note.subject", 1 => "note.topic", 2 => "note.date", 3 => "mem.login", 4 => "note.published"));
} else {
$block6->sorting("notes", $sortingUser->sor_notes[0], "note.date DESC", $sortingFields = array(0 => "note.subject", 1 => "note.date", 2 => "mem.login", 3 => "note.published"));
}
if ($projectsFilter == "true") {
if ($comptListProjectsFilter != "0") {
$tmpquery = "{$searchNotes} AND note.project IN({$filterResults}) ORDER BY {$block6->sortingValue}";
<?php
#Application name: PhpCollab
#Status page: 0
$checkSession = "true";
include "../includes/library.php";
$tmpquery = "WHERE topic.id = '{$id}'";
$detailTopic = new request();
$detailTopic->openTopics($tmpquery);
if ($detailTopic->top_published[0] == "1" || $detailTopic->top_project[0] != $projectSession) {
headerFunction("index.php");
}
if ($action == "delete") {
$detailTopic->top_posts[0] = $detailTopic->top_posts[0] - 1;
$tmpquery = "DELETE FROM " . $tableCollab["posts"] . " WHERE id = '{$post}'";
connectSql("{$tmpquery}");
$tmpquery2 = "UPDATE " . $tableCollab["topics"] . " SET posts='" . $detailTopic->top_posts[0] . "' WHERE id = '{$id}'";
connectSql("{$tmpquery2}");
headerFunction("showallthreads.php?id={$id}&" . session_name() . "=" . session_id());
exit;
}
$bouton[5] = "over";
$titlePage = $strings["bulletin_board_topic"];
include "include_header.php";
$tmpquery = "WHERE pos.topic = '" . $detailTopic->top_id[0] . "' ORDER BY pos.created DESC";
$listPosts = new request();
$listPosts->openPosts($tmpquery);
$comptListPosts = count($listPosts->pos_id);
$idStatus = $detailTopic->top_status[0];
echo "<table cellspacing='0' width='90%' cellpadding='3'>\n<tr><th colspan='4'>" . $strings["information"] . ":</th></tr>\n<tr><th>" . $strings["subject"] . ":</th><td>" . $detailTopic->top_subject[0] . "</td><th>" . $strings["posts"] . ":</th><td>" . $detailTopic->top_posts[0] . "</td></tr>\n<tr><th>" . $strings["project"] . ":</th><td>" . $projectDetail->pro_name[0] . "</td><th>" . $strings["last_post"] . ":</th><td>" . createDate($detailTopic->top_last_post[0], $timezoneSession) . "</td></tr>\n<tr><th> </th><td> </td><th>" . $strings["retired"] . ":</th><td>{$statusTopicBis[$idStatus]}</td></tr>\n<tr><th>" . $strings["owner"] . ":</th><td colspan='3'><a href='mailto:" . $detailTopic->top_mem_email_work[0] . "'>" . $detailTopic->top_mem_login[0] . "</a></td></tr>\n<tr><td colspan='4'> </td></tr>\n<tr><th colspan='4'>" . $strings["discussion"] . ":</th></tr>";
if ($detailTopic->top_status[0] == "1") {
$tmpquery = 'WHERE tas.project IN(' . $id . ')';
$listTasks = new request();
$listTasks->openTasks($tmpquery);
$comptListTasks = count($listTasks->tas_id);
for ($i = 0; $i < $comptListTasks; $i++) {
if ($fileManagement == 'true') {
delDir('../files/' . $id . '/' . $listTasks->tas_id[$i]);
}
$tasks .= $listTasks->tas_id[$i];
if ($i != $comptListTasks - 1) {
$tasks .= ',';
}
}
$tmpquery = 'WHERE topic.project IN(' . $id . ')';
$listTopics = new request();
$listTopics->openTopics($tmpquery);
$comptListTopics = count($listTopics->top_id);
for ($i = 0; $i < $comptListTopics; $i++) {
$topics .= $listTopics->top_id[$i];
if ($i != $comptListTopics - 1) {
$topics .= ',';
}
}
connectSql($tmpquery1);
$tmpquery2 = 'DELETE FROM ' . $tableCollab['tasks'] . ' WHERE project IN(' . $id . ')';
connectSql($tmpquery2);
$tmpquery3 = 'DELETE FROM ' . $tableCollab['teams'] . ' WHERE project IN(' . $id . ')';
connectSql($tmpquery3);
$tmpquery4 = 'DELETE FROM ' . $tableCollab['topics'] . ' WHERE project IN(' . $id . ')';
connectSql($tmpquery4);
$tmpquery5 = 'DELETE FROM ' . $tableCollab['files'] . ' WHERE project IN(' . $id . ')';
