function createDownloadsArray($result)
{
global $CONFIG;
global $downloads_dir;
$downloads = array();
while ($data = mysql_fetch_array($result)) {
$id = $data['id'];
$category = $data['category'];
$type = $data['type'];
$ttitle = $data['title'];
$description = $data['description'];
$filename = $data['location'];
$numdownloads = $data['downloads'];
$clientsonly = $data['clientsonly'];
$filesize = @filesize($downloads_dir . $filename);
$filesize = formatFileSize($filesize);
$fileext = end(explode(".", $filename));
if ($fileext == "doc") {
$type = "doc";
}
if ($fileext == "gif" || $fileext == "jpg" || $fileext == "jpeg" || $fileext == "png") {
$type = "picture";
}
if ($fileext == "txt") {
$type = "txt";
}
if ($fileext == "zip") {
$type = "zip";
}
$type = "<img src=\"images/" . $type . ".png\" align=\"absmiddle\" alt=\"\" />";
$downloads[] = array("type" => $type, "title" => $ttitle, "urlfriendlytitle" => getModRewriteFriendlyString($ttitle), "description" => $description, "downloads" => $numdownloads, "filesize" => $filesize, "clientsonly" => $clientsonly, "link" => $CONFIG['SystemURL'] . ("/dl.php?type=d&id=" . $id));
}
return $downloads;
}
$categorycount = $data2[0];
$kbcats[$i]['numarticles'] = $categorycount;
++$i;
}
$smarty->assign("kbcats", $kbcats);
$result = select_query("tblknowledgebase", "tblknowledgebase.*", "parentid=0", "views", "DESC", "0,5");
while ($data = mysql_fetch_array($result)) {
$id = $data['id'];
$category = $data['category'];
$title = $data['title'];
$article = $data['article'];
$views = $data['views'];
$result2 = select_query("tblknowledgebasecats", "tblknowledgebasecats.hidden", array("articleid" => $id, "hidden" => "on"), "", "", "", "tblknowledgebaselinks ON tblknowledgebaselinks.categoryid=tblknowledgebasecats.id");
$data = mysql_fetch_array($result2);
if (!$data['hidden']) {
$result2 = select_query("tblknowledgebase", "", array("parentid" => $id, "language" => $_SESSION['Language']));
$data = mysql_fetch_array($result2);
if ($data['title']) {
$title = $data['title'];
}
if ($data['article']) {
$article = $data['article'];
}
$kbmostviews[] = array("id" => $id, "category" => $category, "title" => $title, "urlfriendlytitle" => getModRewriteFriendlyString($title), "article" => strip_tags($article), "views" => $views);
}
}
$smarty->assign("kbmostviews", $kbmostviews);
}
}
}
outputClientArea($templatefile);
}
$date = $data['date'];
$title = $data['title'];
$announcement = $data['announcement'];
$timestamp = strtotime($date);
$date = fromMySQLDate($date, true);
$result2 = select_query("tblannouncements", "", array("parentid" => $id, "language" => $_SESSION['Language']));
$data = mysql_fetch_array($result2);
if ($data['title']) {
$title = $data['title'];
}
if ($data['announcement']) {
$announcement = $data['announcement'];
}
$breadcrumbnav = "<a href=\"" . $CONFIG['SystemURL'] . "/index.php\">" . $_LANG['globalsystemname'] . "</a> > <a href=\"" . $CONFIG['SystemURL'] . "/announcements.php\">" . $_LANG['announcementstitle'] . "</a> > <a href=\"" . $CONFIG['SystemURL'] . "/";
$urlfriendlytitle = getModRewriteFriendlyString($title);
if ($CONFIG['SEOFriendlyUrls']) {
$breadcrumbnav .= "announcements/" . $id . "/" . $urlfriendlytitle . ".html";
} else {
$breadcrumbnav .= "announcements.php?id=" . $id;
}
$breadcrumbnav .= "\">" . $title . "</a>";
$smarty->assign("breadcrumbnav", $breadcrumbnav);
$smarty->assign("id", $id);
$smarty->assign("date", $date);
$smarty->assign("timestamp", $timestamp);
$smarty->assign("title", $title);
$smarty->assign("text", $announcement);
$smarty->assign("urlfriendlytitle", $urlfriendlytitle);
}
outputClientArea($templatefile);
$result = select_query("tblannouncements", "", array("published" => "on"), "date", "DESC", "0,3");
while ($data = mysql_fetch_array($result)) {
$id = $data['id'];
$date = $data['date'];
$title = $data['title'];
$announcement = $data['announcement'];
$result2 = select_query("tblannouncements", "", array("parentid" => $id, "language" => $_SESSION['Language']));
$data = mysql_fetch_array($result2);
if ($data['title']) {
$title = $data['title'];
}
if ($data['announcement']) {
$announcement = $data['announcement'];
}
$date = fromMySQLDate($date);
$announcements[] = array("id" => $id, "date" => $date, "title" => $title, "urlfriendlytitle" => getModRewriteFriendlyString($title), "text" => $announcement);
}
$smartyvalues['announcements'] = $announcements;
$smartyvalues['seofriendlyurls'] = $CONFIG['SEOFriendlyUrls'];
if ($CONFIG['AllowRegister']) {
$smartyvalues['registerdomainenabled'] = true;
}
if ($CONFIG['AllowTransfer']) {
$smartyvalues['transferdomainenabled'] = true;
}
if ($CONFIG['AllowOwnDomain']) {
$smartyvalues['owndomainenabled'] = true;
}
$captcha = clientAreaInitCaptcha();
$smartyvalues['captcha'] = $smartyvalues['capatacha'] = $captcha;
$smartyvalues['recaptchahtml'] = $smartyvalues['recapatchahtml'] = clientAreaReCaptchaHTML();
