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();