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