/**
* Return a message including its answers
*
* @param int $id Eindeutige Nummer der Nachricht
* @return array $message Eigenschaften der Nachricht
*/
function getMessage($id)
{
global $conn;
$id = (int) $id;
$messageStmt = $conn->prepare("SELECT * FROM messages WHERE ID = ? LIMIT 1");
$messageStmt->execute(array($id));
$message = $messageStmt->fetch();
$milesobj = new milestone();
if (!empty($message)) {
$repliesStmt = $conn->prepare("SELECT COUNT(*) FROM messages WHERE replyto = ?");
$repliesStmt->execute(array($id));
$replies = $repliesStmt->fetch();
$replies = $replies[0];
$user = new user();
$avatar = $user->getAvatar($message["user"]);
$userGender = $conn->query("SELECT gender FROM user WHERE ID = {$message['user']}")->fetch();
$gender = $userGender[0];
$message["gender"] = $gender;
$project = $conn->query("SELECT name FROM projekte WHERE ID = {$message['project']}")->fetch();
$message["pname"] = $project[0];
$posted = date(CL_DATEFORMAT . " - H:i", $message["posted"]);
$message["postdate"] = $posted;
$message["endstring"] = $posted;
$message["replies"] = $replies;
$message["avatar"] = $avatar;
$message["title"] = $message["title"];
$message["text"] = $message["text"];
$message["username"] = $message["username"];
$attached = $this->getAttachedFiles($message["ID"]);
$message["files"] = $attached;
if ($message["milestone"] > 0) {
$miles = $milesobj->getMilestone($message["milestone"]);
} else {
$miles = array();
}
$message["milestones"] = $miles;
return $message;
} else {
return false;
}
}
/**
* Return a message including its answers
*
* @param int $id Eindeutige Nummer der Nachricht
* @return array $message Eigenschaften der Nachricht
*/
function getMessage($id)
{
$id = (int) $id;
$sel = mysql_query("SELECT * FROM messages WHERE ID = {$id} LIMIT 1");
$message = mysql_fetch_array($sel, MYSQL_ASSOC);
$tagobj = new tags();
$milesobj = new milestone();
if (!empty($message)) {
$replies = mysql_query("SELECT COUNT(*) FROM messages WHERE replyto = {$id}");
$replies = mysql_fetch_row($replies);
$replies = $replies[0];
$user = new user();
$avatar = $user->getAvatar($message["user"]);
$sel = mysql_query("SELECT gender FROM user WHERE ID = {$message['user']}");
$ds = mysql_fetch_row($sel);
$gender = $ds[0];
$message["gender"] = $gender;
$project = mysql_query("SELECT name FROM projekte WHERE ID = {$message['project']}");
$project = mysql_fetch_row($project);
$project = $project[0];
$project["name"] = stripslashes($project["name"]);
$message["pname"] = $project;
$posted = date(CL_DATEFORMAT . " - H:i", $message["posted"]);
$message["postdate"] = $posted;
$message["endstring"] = $posted;
$message["replies"] = $replies;
$message["avatar"] = $avatar;
$message["title"] = stripslashes($message["title"]);
$message["text"] = stripslashes($message["text"]);
$message["username"] = stripslashes($message["username"]);
$message["tagsarr"] = $tagobj->splitTagStr($message["tags"]);
$message["tagnum"] = count($message["tagsarr"]);
$attached = $this->getAttachedFiles($message["ID"]);
$message["files"] = $attached;
if ($message["milestone"] > 0) {
$miles = $milesobj->getMilestone($message["milestone"]);
} else {
$miles = array();
}
$message["milestones"] = $miles;
return $message;
} else {
return false;
}
}
