function getCatTitle($cat_id, $indice = 0)
{
    global $db, $controller;
    $cat = $db->fetchRow("SELECT id, name, parent, public FROM " . TABLE_PREFIX . "knowledgebase_category WHERE id=" . $db->real_escape_string($cat_id));
    $str = '';
    if ($cat['parent'] != 0) {
        $str = getCatTitle($cat['parent']);
    }
    if ($indice == 1) {
        $str .= $cat['name'];
    } else {
        $str .= '<a href="' . getUrl($controller, $cat['id'], array(strtourl($cat['name']))) . '">' . htmlspecialchars($cat['name']) . '</a> &gt; ';
    }
    return $str;
}
Esempio n. 2
0
 * @since 1.0.0
 */
if ($controller == 'home') {
    include INCLUDES . 'helpdesk.inc.php';
}
$template_vars = array();
if ($action == '404notfound') {
    $template_name = '404.html';
} else {
    if ($settings['homepage'] == 'knowledgebase' && $settings['knowledgebase'] == 'yes') {
        $filename = CONTROLLERS . 'knowledgebase_controller.php';
        include $filename;
    } elseif ($settings['homepage'] == 'news' && $settings['news'] == 'yes') {
        $q = $db->query("SELECT * FROM " . TABLE_PREFIX . "news WHERE public=1 ORDER BY date DESC LIMIT 5");
        while ($r = $db->fetch_array($q)) {
            $r['url'] = getUrl('news', $r['id'], array(strtourl($r['title'])));
            $news[] = $r;
        }
        $template_vars['news'] = $news;
        $template_name = 'home_news.html';
    } else {
        $homepage = $db->fetchRow("SELECT * FROM " . TABLE_PREFIX . "pages WHERE id='home'");
        $template_vars['homepage'] = $homepage;
        $template_name = 'home.html';
    }
}
$template_vars['error_msg'] = $error_msg;
$template = $twig->loadTemplate($template_name);
echo $template->render($template_vars);
$db->close();
exit;
Esempio n. 3
0
        header('location: ' . getUrl($controller));
        exit;
    } else {
        $news['url'] = getUrl($controller, $news['id'], array(strtourl($news['title'])));
        $template = $twig->loadTemplate('news_article.html');
        $template_vars = array('news' => $news);
        echo $template->render($template_vars);
        $db->close();
        exit;
    }
}
if ($action == 'page') {
    $page = !is_numeric($params[0]) || $params[0] < 0 ? 1 : $params[0];
} else {
    $page = 1;
}
$max_results = $settings['news_page'];
$count = $db->fetchOne("SELECT COUNT(*) AS NUM FROM " . TABLE_PREFIX . "news WHERE public=1");
$total_pages = ceil($count / $max_results);
$page = $page > $total_pages ? $total_pages : $page;
$from = $max_results * $page - $max_results;
$q = $db->query("SELECT * FROM " . TABLE_PREFIX . "news WHERE public=1 ORDER BY date DESC LIMIT {$from}, {$max_results}");
while ($r = $db->fetch_array($q)) {
    $r['url'] = getUrl($controller, $r['id'], array(strtourl($r['title'])));
    $news[] = $r;
}
$template = $twig->loadTemplate('news.html');
$template_vars = array('news' => $news, 'total_pages' => $total_pages, 'page' => $page);
echo $template->render($template_vars);
$db->close();
exit;