require_once "../../include/session.php";
require_once "include/fields.php";
foreach ($phpbms->modules as $module => $moduleinfo) {
if ($module != "base" && file_exists("../" . $module . "/adminsettings.php")) {
include "modules/" . $module . "/adminsettings.php";
}
}
require_once "modules/base/include/adminsettings_include.php";
$settings = new settings($db);
if (!hasRights("Admin")) {
goURL(APP_PATH . "noaccess.php");
}
if (isset($_POST["command"])) {
$statusmessage = $settings->processForm($_POST);
}
$therecord = $settings->getSettings();
$pageTitle = "Configuration";
$phpbms->cssIncludes[] = "pages/base/adminsettings.css";
$phpbms->jsIncludes[] = "modules/base/javascript/adminsettings.js";
foreach ($phpbms->modules as $module => $moduleinfo) {
if ($module != "base" && file_exists("../" . $module . "/javascript/adminsettings.js")) {
$phpbms->jsIncludes[] = "modules/" . $module . "/javascript/adminsettings.js";
}
}
//Form Elements
//==============================================================
$theform = new phpbmsForm();
$theform->enctype = "multiform/form-data";
$theinput = new inputField("application_name", $therecord["application_name"], "application name", true);
$theform->addField($theinput);
$theinput = new inputField("application_uuid", $therecord["application_uuid"], "application uuid", false, NULL, 40);
/**
* Return a file
*
* @param string $id File ID
* @return array $file File details
*/
function getFile($id)
{
global $conn;
$id = (int) $id;
// Get the file from the database
$file = $conn->query("SELECT * FROM files WHERE ID={$id}")->fetch();
if (!empty($file)) {
// Determine if there is a MIME-type icon corresponding to the file's MIME-type. If not, set 'none'
$file['type'] = str_replace("/", "-", $file["type"]);
// Get settings (needed to add a different MIME-type icon per theme for each file)
$set = new settings();
$settings = $set->getSettings();
// Construct the path to the MIME-type icon
$myfile = "./templates/" . $settings["template"] . "/theme/" . $settings["theme"] . "/images/files/" . $file['type'] . ".png";
if (!file_exists($myfile)) {
$file['type'] = "none";
}
// Determine if it is an image or text file or some other kind of file (required for lightbox)
if (stristr($file['type'], "image")) {
$file['imgfile'] = 1;
} elseif (stristr($file['type'], "text")) {
$file['imgfile'] = 0;
} else {
$file['imgfile'] = 0;
}
// Strip slashes from title, desc and tags
$file["title"] = stripslashes($file["title"]);
$file["desc"] = stripslashes($file["desc"]);
$file["size"] = filesize(realpath($file["datei"])) / 1024;
$file["size"] = round($file["size"]);
$file["addedstr"] = date(CL_DATEFORMAT, $file["added"]);
// Attach data about the user who uploaded the file
$userobj = new user();
$file["userdata"] = $userobj->getProfile($file["user"]);
return $file;
} else {
return false;
}
}
function searchFiles($query, $project = 0)
{
global $conn;
$project = (int) $project;
if ($project > 0) {
$sel = $conn->prepare("SELECT `ID`,`name`,`desc`,`type`,`datei`,`title`,`project` FROM `files` WHERE `name` LIKE ? OR `desc` LIKE ? OR `title` LIKE ? HAVING project = ?");
$sel->execute(array("%{$query}%", "%{$query}%", "%{$query}%", $project));
} else {
$sel = $conn->prepare("SELECT `ID`,`name`,`desc`,`type`,`datei`,`title`,`project` FROM `files` WHERE `name` LIKE ? OR `desc` LIKE ? OR `title` LIKE ?");
$sel->execute(array("%{$query}%", "%{$query}%", "%{$query}%"));
}
$files = array();
while ($result = $sel->fetch()) {
if (!empty($result)) {
$project = $conn->query("SELECT name FROM projekte WHERE ID = {$result['project']}")->fetch();
$project = $project[0];
$result["pname"] = $project;
$result["ftype"] = str_replace("/", "-", $result["type"]);
$set = new settings();
$settings = $set->getSettings();
$myfile = CL_ROOT . "/templates/" . $settings["template"] . "/images/symbols/files/" . $result["ftype"] . ".png";
if (stristr($result["type"], "image")) {
$result["imgfile"] = 1;
} elseif (stristr($result['type'], "text")) {
$result["imgfile"] = 2;
} else {
$result["imgfile"] = 0;
}
if (!file_exists($myfile)) {
$result["ftype"] = "none";
}
$result["title"] = stripslashes($result["title"]);
$result["desc"] = stripslashes($result["desc"]);
// $result["tags"] = stripslashes($result["tags"]);
$result["type"] = "file";
$result[3] = "file";
$result["icon"] = "files.png";
array_push($files, $result);
}
}
if (!empty($files)) {
return $files;
} else {
return array();
}
}
/**
* 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;
}
}
}
array_push($languages_fin, $fin);
}
$msgcount = getArrayVal($_GET, "msg");
$peoplecount = getArrayVal($_GET, "peop");
$procount = getArrayVal($_GET, "pro");
$taskcount = getArrayVal($_GET, "tsk");
$template->assign("msgcount", $msgcount);
$template->assign("peoplecount", $peoplecount);
$template->assign("procount", $procount);
$template->assign("taskcount", $taskcount);
$template->assign("languages_fin", $languages_fin);
$title = $langfile["systemadministration"];
$template->assign("title", $title);
$template->assign("classes", $classes);
$sets = $theset->getSettings();
$templates = $theset->getTemplates();
$themes = $theset->getThemes($settings["template"]);
$template->assign("themes", $themes);
$template->assign("settings", $sets);
$timezones = DateTimeZone::listIdentifiers();
$template->assign("timezones", $timezones);
$template->assign("templates", $templates);
$template->display("editsettings.tpl");
} elseif ($action == "editsets") {
$theme = getArrayVal($_POST, "theme");
if ($theset->editSettings($name, $subtitle, $locale, $timezone, $dateformat, $templ, $theme, $rssuser, $rsspass)) {
$handle = opendir($template->compile_dir);
while (false !== ($file = readdir($handle))) {
if ($file != "." and $file != "..") {
unlink(CL_ROOT . "/" . $template->compile_dir . "/" . $file);
/**
* Get files attached to a message
*
* @param int $msg ID of the message
* @return array $files Attached files
*/
private function getAttachedFiles($msg)
{
global $conn;
$msg = (int) $msg;
$files = array();
$sel = $conn->prepare("SELECT file FROM files_attached WHERE message = ?");
$sel->execute(array($msg));
while ($file = $sel->fetch()) {
$sel2 = $conn->query("SELECT * FROM files WHERE ID = {$file['0']}");
$thisfile = $sel2->fetch();
$thisfile["type"] = str_replace("/", "-", $thisfile["type"]);
//get systemSettings
$settingsObj = new settings();
$settings = $settingsObj->getSettings();
// Construct the path to the MIME-type icon
$myfile = "./templates/" . $settings["template"] . "/theme/" . $settings["theme"] . "/images/files/" . $thisfile['type'] . ".png";
if (!file_exists($myfile)) {
$thisfile['type'] = "none";
}
// Determine if it is an image or text file or some other kind of file (required for lightbox)
if (stristr($thisfile['type'], "image")) {
$thisfile['imgfile'] = 1;
} elseif (stristr($thisfile['type'], "text")) {
$thisfile['imgfile'] = 2;
} else {
$thisfile['imgfile'] = 0;
}
array_push($files, $thisfile);
}
if (!empty($files)) {
return $files;
} else {
return false;
}
}
private function getAttachedFiles($msg)
{
$msg = (int) $msg;
$files = array();
$sel = mysql_query("SELECT file FROM files_attached WHERE message = {$msg}");
while ($file = mysql_fetch_row($sel)) {
$sel2 = mysql_query("SELECT * FROM files WHERE ID = {$file['0']}");
$thisfile = mysql_fetch_array($sel2);
$thisfile["type"] = str_replace("/", "-", $thisfile["type"]);
if (isset($thisfile["desc"])) {
$thisfile["desc"] = stripslashes($thisfile["desc"]);
}
if (isset($thisfile["tags"])) {
$thisfile["tags"] = stripslashes($thisfile["tags"]);
}
if (isset($thisfile["title"])) {
$thisfile["title"] = stripslashes($thisfile["title"]);
}
$set = new settings();
$settings = $set->getSettings();
$myfile = "./templates/" . $settings["template"] . "/images/files/" . $thisfile["type"] . ".png";
if (stristr($thisfile["type"], "image")) {
$thisfile["imgfile"] = 1;
} elseif (stristr($thisfile["type"], "text")) {
$thisfile["imgfile"] = 2;
} else {
$thisfile["imgfile"] = 0;
}
if (!file_exists($myfile)) {
$thisfile["type"] = "none";
}
array_push($files, $thisfile);
}
if (!empty($files)) {
return $files;
} else {
return false;
}
}
private function getFiles($query, $project = 0)
{
$query = mysql_real_escape_string($query);
$project = (int) $project;
if ($project > 0) {
$sel = mysql_query("SELECT `ID`,`name`,`desc`,`type`,`datei`,`title`,`project`,`tags` FROM `files` WHERE `tags` LIKE '%{$query}%' HAVING project = {$project}");
} else {
$sel = mysql_query("SELECT `ID`,`name`,`desc`,`type`,`datei`,`title`,`project`,`tags` FROM `files` WHERE `tags` LIKE '%{$query}%'");
}
$files = array();
while ($result = mysql_fetch_array($sel)) {
if (!empty($result)) {
$project = mysql_query("SELECT name FROM projekte WHERE ID = {$result['project']}");
$project = mysql_fetch_row($project);
$project = $project[0];
$result["pname"] = $project;
$result["ftype"] = str_replace("/", "-", $result["type"]);
$set = new settings();
$settings = $set->getSettings();
$myfile = CL_ROOT . "/templates/" . $settings["template"] . "/images/symbols/files/" . $result["ftype"] . ".png";
if (stristr($result["type"], "image")) {
$result["imgfile"] = 1;
} elseif (stristr($result['type'], "text")) {
$result["imgfile"] = 2;
} else {
$result["imgfile"] = 0;
}
if (!file_exists($myfile)) {
$result["ftype"] = "none";
}
$result["title"] = stripslashes($result["title"]);
$result["desc"] = stripslashes($result["desc"]);
$result["tags"] = stripslashes($result["tags"]);
$thetags = $this->splitTagStr($result["tags"]);
$result["tagsarr"] = $thetags;
$result["tagnum"] = count($result["tagsarr"]);
$result["type"] = "file";
$result[3] = "file";
$result["icon"] = "files.png";
array_push($files, $result);
}
}
if (!empty($files)) {
return $files;
} else {
return array();
}
}
