/** * 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; } }