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> > '; } return $str; }
* @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;
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;