/**
* Return a file
*
* @param string $id File ID
* @return array $file File details
*/
function getFile($id)
{
$id = (int) $id;
// get the file from MySQL
$sel = mysql_query("SELECT * FROM files WHERE ID={$id}");
$file = mysql_fetch_array($sel);
if (!empty($file)) {
// determine if there is an mimetype icon corresponding to the files mimetype. If not set 'none'
$file['type'] = str_replace("/", "-", $file["type"]);
$set = new settings();
$settings = $set->getSettings();
$myfile = "./templates/" . $settings["template"] . "/images/files/" . $file['type'] . ".png";
if (!file_exists($myfile)) {
$file['type'] = "none";
}
// determine if its an image or textfile or some other file. this is needed for lightboxes
if (stristr($file['type'], "image")) {
$file['imgfile'] = 1;
} elseif (stristr($file['type'], "text")) {
$file['imgfile'] = 2;
} else {
$file['imgfile'] = 0;
}
// split the tags string into an array, and also count how many tags the file has
$tagobj = new tags();
$thetags = $tagobj->splitTagStr($file["tags"]);
$file["tagsarr"] = $thetags;
$file["tagnum"] = count($file["tagsarr"]);
// strip slashes from titles , desc and tags
$file["title"] = stripslashes($file["title"]);
$file["desc"] = stripslashes($file["desc"]);
$file["tags"] = stripslashes($file["tags"]);
$file["size"] = filesize(realpath($file["datei"])) / 1024;
$file["size"] = round($file["size"]);
$file["addedstr"] = date("d.m.y", $file["added"]);
$userobj = new user();
$file["userdata"] = $userobj->getProfile($file["user"]);
return $file;
} else {
return false;
}
}
/**
* Get a user profile
*
* @param int $id User ID
* @return array $profile Profile
*/
function getProfile($id)
{
global $conn;
$id = (int) $id;
$sel = $conn->query("SELECT * FROM user WHERE ID = {$id}");
$profile = $sel->fetch();
if (!empty($profile)) {
$profile["name"] = stripslashes($profile["name"]);
if (isset($profile["company"])) {
$profile["company"] = stripslashes($profile["company"]);
}
if (isset($profile["adress"])) {
$profile["adress"] = stripslashes($profile["adress"]);
}
if (isset($profile["adress2"])) {
$profile["adress2"] = stripslashes($profile["adress2"]);
}
if (isset($profile["state"])) {
$profile["state"] = stripslashes($profile["state"]);
}
if (isset($profile["country"])) {
$profile["country"] = stripslashes($profile["country"]);
}
$tagsobj = new tags();
$profile["tagsarr"] = $tagsobj->splitTagStr($profile["tags"]);
$rolesobj = (object) new roles();
$profile["role"] = $rolesobj->getUserRole($profile["ID"]);
return $profile;
} 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;
}
}
