require_once "../maincore.php";

 

if (!checkRights("NC") || !defined("iAUTH") || $_GET['aid'] != iAUTH) { redirect("../index.php"); }

 

require_once THEMES."templates/admin_header.php";

include LOCALE.LOCALESET."admin/news-cats.php";

 

if (isset($_GET['status']) && !isset($message)) {

	if ($_GET['status'] == "sn") {

		$message = $locale['420'];

	} elseif ($_GET['status'] == "su") {

		$message = $locale['421'];

	} elseif ($_GET['status'] == "dn") {

		$message = $locale['422']."<br />\n<span class='small'>".$locale['423']."</span>";

	} elseif ($_GET['status'] == "dy") {

		$message = $locale['424'];

	}

	if ($message) {	echo "<div id='close-message'><div class='admin-message'>".$message."</div></div>\n"; }

}

 

if ((isset($_GET['action']) && $_GET['action'] == "delete") && (isset($_GET['cat_id']) && isnum($_GET['cat_id']))) {

	$result = dbcount("(news_cat_id)", DB_NEWS, "news_cat='".$_GET['cat_id']."'");

	if (!empty($result)) {

		redirect(FUSION_SELF.$aidlink."&status=dn");

	} else {

		$result = dbquery("DELETE FROM ".DB_NEWS_CATS." WHERE news_cat_id='".$_GET['cat_id']."'");

		redirect(FUSION_SELF.$aidlink."&status=dy");

	}

} elseif (isset($_POST['save_cat'])) {

	$cat_name = stripinput($_POST['cat_name']);

	$cat_image = stripinput($_POST['cat_image']);

	if ($cat_name && $cat_image) {

		if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_GET['cat_id']) && isnum($_GET['cat_id']))) {

			$result = dbquery("UPDATE ".DB_NEWS_CATS." SET news_cat_name='$cat_name', news_cat_image='$cat_image' WHERE news_cat_id='".$_GET['cat_id']."'");

			redirect(FUSION_SELF.$aidlink."&status=su");

		} else {

			$checkCat = dbcount("(news_cat_id)", DB_NEWS_CATS, "news_cat_name='".$cat_name."'");

			if ($checkCat == 0) {

				$result = dbquery("INSERT INTO ".DB_NEWS_CATS." (news_cat_name, news_cat_image) VALUES ('$cat_name', '$cat_image')");

				redirect(FUSION_SELF.$aidlink."&status=sn");

			} else {

				$error = 2;

				$formaction = FUSION_SELF.$aidlink;

				$openTable = $locale['401'];

			}

		}

	} else {

		$error = 1;

		$formaction = FUSION_SELF.$aidlink;

		$openTable = $locale['401'];

	}

} elseif ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_GET['cat_id']) && isnum($_GET['cat_id']))) {

	$result = dbquery("SELECT news_cat_id, news_cat_name, news_cat_image FROM ".DB_NEWS_CATS." WHERE news_cat_id='".$_GET['cat_id']."'");

	if (dbrows($result)) {

		$data = dbarray($result);

		$cat_name = $data['news_cat_name'];

		$cat_image = $data['news_cat_image'];

		$formaction = FUSION_SELF.$aidlink."&amp;action=edit&amp;cat_id=".$data['news_cat_id'];

		$openTable = $locale['400'];

	} else {

		redirect(FUSION_SELF.$aidlink);

	}

} else {

	$cat_name = "";

	$cat_image = "";

	$formaction = FUSION_SELF.$aidlink;

	$openTable = $locale['401'];

}

$image_files = makefilelist(IMAGES_NC, ".|..|index.php", true);

$image_list = makefileopts($image_files,$cat_image);

 

if (isset($error) && isnum($error)) {

	if ($error == 1) {

		$errorMessage = $locale['460'];

	} elseif ($error == 2) {

		$errorMessage = $locale['461'];

	}

	if ($errorMessage) { echo "<div id='close-message'><div class='admin-message'>".$errorMessage."</div></div>\n"; }

}

 

opentable($openTable);

echo "<form name='addcat' method='post' action='".$formaction."'>\n";

echo "<table cellpadding='0' cellspacing='0' width='400' class='center'>\n<tr>\n";

echo "<td width='130' class='tbl'>".$locale['430']."</td>\n";

echo "<td class='tbl'><input type='text' name='cat_name' value='".$cat_name."' class='textbox' style='width:200px;' /></td>\n";

echo "</tr>\n<tr>\n";

 

 

 

echo "<td width='130' class='tbl'>".$locale['431']."</td>\n";

echo "<td class='tbl'><select name='cat_image' class='textbox' style='width:200px;'>\n".$image_list."</select></td>\n";

echo "</tr>\n<tr>\n";

 

 

 

 

echo "<td align='center' colspan='2' class='tbl'><br />\n";

echo "<input type='submit' name='save_cat' value='".$locale['432']."' class='button' /></td>\n";

echo "</tr>\n</table>\n</form>\n";

closetable();

 

opentable($locale['402']);

$result = dbquery("SELECT news_cat_id, news_cat_name FROM ".DB_NEWS_CATS." ORDER BY news_cat_name");

$rows = dbrows($result);

if ($rows != 0) {

	$counter = 0; $columns = 4;

	echo "<table cellpadding='0' cellspacing='1' width='400' class='center'>\n<tr>\n";

	while ($data = dbarray($result)) {

		if ($counter != 0 && ($counter % $columns == 0)) echo "</tr>\n<tr>\n";

		echo "<td align='center' width='25%' class='tbl'><strong>".$data['news_cat_name']."</strong><br /><br />\n";

		echo "<img src='".get_image("nc_".$data['news_cat_name'])."' alt='".$data['news_cat_name']."' /><br /><br />\n";

		echo "<span class='small'><a href='".FUSION_SELF.$aidlink."&amp;action=edit&amp;cat_id=".$data['news_cat_id']."'>".$locale['433']."</a> -\n";

		echo "<a href='".FUSION_SELF.$aidlink."&amp;action=delete&amp;cat_id=".$data['news_cat_id']."' onclick=\"return confirm('".$locale['450']."');\">".$locale['434']."</a></span></td>\n";

		$counter++;

	}

	echo "</tr>\n</table>\n";

} else {

	echo "<div style='text-align:center'><br />\n".$locale['435']."<br /><br />\n</div>\n";

}

echo "<div style='text-align:center'><br />\n<a href='".ADMIN."images.php".$aidlink."&amp;ifolder=imagesnc'>".$locale['436']."</a><br /><br />\n</div>\n";

closetable();

 

require_once THEMES."templates/footer.php";

?>

require_once "maincore.php";

require_once THEMES."templates/header.php";

include LOCALE.LOCALESET."news_cats.php";

 

add_to_title($locale['global_200'].$locale['400']);

 

opentable($locale['400']);

if (isset($_GET['cat_id']) && isnum($_GET['cat_id'])) {

	$res = 0;

	$result = dbquery("SELECT news_cat_name FROM ".DB_NEWS_CATS." WHERE news_cat_id='".$_GET['cat_id']."'");

	if (dbrows($result) || $_GET['cat_id'] == 0) {

		$data = dbarray($result);

		$rows = dbcount("(news_id)", DB_NEWS, "news_cat='".$_GET['cat_id']."' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0'");

		if ($rows) {

			$res = 1;

			echo "<!--pre_news_cat--><table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";

			if ($_GET['cat_id'] != 0) {

				echo "<tr>\n<td width='150' class='tbl1' style='vertical-align:top'><!--news_cat_image--><img src='".get_image("nc_".$data['news_cat_name'])."' alt='".$data['news_cat_name']."' /><br /><br />\n";

				echo "<strong>".$locale['401']."</strong> ".$data['news_cat_name']."<br />\n<strong>".$locale['402']."</strong> $rows</td>\n";   

				echo "<td class='tbl1' style='vertical-align:top'>\n";

 

 

 

 

 

 

 

 

 

 

 

 

 

			} else {

				echo "<tr>\n<td width='150' class='tbl1' style='vertical-align:top'>".$locale['403']."<br />\n";

				echo "<strong>".$locale['401']."</strong> $rows</td>\n<td class='tbl1' style='vertical-align:top'><!--news_cat_news-->\n";

 

 

 

}

			$result2 = dbquery("SELECT news_id, news_subject FROM ".DB_NEWS." WHERE news_cat='".$_GET['cat_id']."' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0' ORDER BY news_datestamp DESC");

			while ($data2 = dbarray($result2)) {

				echo THEME_BULLET." <a href='news.php?readmore=".$data2['news_id']."'>".$data2['news_subject']."</a><br />\n";

			}

 

 

 

 

 

 

 

 

			echo "</td>\n</tr>\n<tr>\n<td colspan='2' class='tbl1' style='text-align:center'>".THEME_BULLET." <a href='".FUSION_SELF."'>".$locale['406']."</a>";

			echo "</td>\n</tr>\n</table><!--sub_news_cat-->\n";

		}

	}

 

 

 

 

 

 

 

 

	if (!$res) { redirect(FUSION_SELF); }

} else {

	$res = 0;

	$result = dbquery("SELECT news_cat_id, news_cat_name FROM ".DB_NEWS_CATS." ORDER BY news_cat_id");

	if (dbrows($result)) {

		echo "<!--pre_news_cat_idx--><table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n";

		while ($data = dbarray($result)) {

			$rows = dbcount("(news_id)", DB_NEWS, "news_cat='".$data['news_cat_id']."' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0'");

                        echo "<tr>\n<td width='150' class='tbl1' style='vertical-align:top'><!--news_cat_image--><img src='".get_image("nc_".$data['news_cat_name'])."' alt='".$data['news_cat_name']."' /><br /><br />\n";

 

echo "<strong>".$locale['401']."</strong> ".$data['news_cat_name']."<br />\n<strong>".$locale['402']."</strong>  $rows</td>\n";

 

 

 

 

 

 

 

 

 

			echo "<td class='tbl1' style='vertical-align:top'><!--news_cat_news-->\n";

			if ($rows) {

				$result2 = dbquery("SELECT news_id, news_subject FROM ".DB_NEWS." WHERE news_cat='".$data['news_cat_id']."' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0' ORDER BY news_datestamp DESC LIMIT 10");

				while ($data2 = dbarray($result2)) {

					echo THEME_BULLET." <a href='news.php?readmore=".$data2['news_id']."'>".$data2['news_subject']."</a><br />\n";

				}

 

if ($rows > 10) { echo "<div style='text-align:right'>".THEME_BULLET." <a href='".FUSION_SELF."?cat_id=".$data['news_cat_id']."'>".$locale['405']."</a></div>\n"; }

 

 

 

 

 

 

 

 

 

 

 

 

 

 

} else {

				echo THEME_BULLET." ".$locale['404']."\n";

			}

			echo "</td>\n</tr>\n";

 

 

 

 

 

 

 

 

 

 

 

		}

		$res = 1;

	}

	$result = dbquery("SELECT * FROM ".DB_NEWS." WHERE news_cat='0' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0' ORDER BY news_datestamp DESC LIMIT 10");

	if (dbrows($result)) {

		if ($res == 0) { echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n"; }

		$nrows = dbcount("(news_id)", DB_NEWS, "news_cat='0' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") AND news_draft='0'");

		echo "<tr>\n<td width='150' class='tbl1' style='vertical-align:top'>".$locale['403']."<br />\n";

		echo "<strong>".$locale['402']."</strong> $nrows</td>\n<td class='tbl1' style='vertical-align:top'>\n";

		while ($data = dbarray($result)) {

			echo THEME_BULLET." <a href='news.php?readmore=".$data['news_id']."'>".$data['news_subject']."</a><br />\n";

 

 

 

 

 

}

		$res = 1;

		if ($nrows > 10) { echo "<div style='text-align:right'>".THEME_BULLET." <a href='".FUSION_SELF."?cat_id=0'>".$locale['405']."</a></div>\n"; }

		echo "</td>\n</tr>\n";

 

 

 

 

 

 

 

	}

	if ($res == 1) {

		echo "</table><!--sub_news_cat_idx-->\n";

	} else {

		echo "<div style='text-align:center'><br />\n".$locale['407']."<br /><br />\n</div>\n";

	}

}

closetable();

 

require_once THEMES."templates/footer.php";

?>