<?php
// TODO: Uncomment
include "access.php";
include_once "../includes/SystemConfiguration.class.php";
include "header.php";
global $systemConfiguration;
global $logger;
$errors = array();
$message = "";
$newsCategory = new NewsCategory();
if (isset($_POST['SBMT_REG'])) {
$logger->LogInfo("Form has been submitted.");
$newsCategory = NewsCategory::fetchFromParameters($_POST);
if (!$newsCategory->save()) {
$logger->LogError("Error saving news category.");
foreach ($newsCategory->errors as $error) {
$logger->LogError($error);
$errors[] = $error;
}
} else {
$message = "Values were updated successfully!";
}
} else {
if (isset($_REQUEST['id']) && is_numeric($_REQUEST['id'])) {
$logger->LogInfo("Page was called for edit of id: " . $_REQUEST['id']);
$id = intval($_REQUEST['id']);
$logger->LogDebug("Numeric id is: {$id}");
$newsCategory = NewsCategory::fetchFromDb($id);
if ($newsCategory == null) {
$logger->LogError("Invalid request. No news category with id: {$id} exists.");
public static function fetchFromDbAllUsed($languageCode = null)
{
global $logger;
NewsCategory::$staticErrors = array();
if ($languageCode == null) {
$defaultLanguage = Language::fetchDefaultLangauge();
$languageCode = $defaultLanguage->languageCode;
}
$newsCategories = array();
$sql = "SELECT DISTINCT nc.* FROM bsi_news_categories as nc INNER JOIN bsi_news_posts np ON nc.id = np.category_id ORDER BY nc.title_" . strtolower(trim($languageCode));
$query = mysql_query($sql);
if (!$query) {
$logger->LogError("Error: " . mysql_errno() . ". Error message: " . mysql_error());
$logger->LogError("SQL: {$sql}");
die("Error: " . mysql_errno() . ". Error message: " . mysql_error());
}
while ($row = mysql_fetch_assoc($query)) {
$newsCategory = NewsCategory::fetchFromParameters($row);
$newsCategories[] = $newsCategory;
}
return $newsCategories;
}
