<?
require_once("/var/www/inc/conf.inc");

function getFirstArticle_(&$ArticleId, &$SectionId, $lang='pl')
{
	if($lang == 'pl')
		$sql="select id from artykul_dzial order by priorytet desc limit 1";
	else
		$sql="select a.id from artykul_dzial a, artykul_dzial_lang b where b.id_section=a.id and b.lang='$lang' order by priorytet desc limit 1";
	$res=mysql_query($sql);
	$row=mysql_fetch_array($res);
	$SectionId=$row["id"];

	if($lang == 'pl')
		$sql="select id from artykul where id_section='$SectionId' order by priorytet desc limit 1";
	else
		$sql="select b.id_article as id from artykul a, artykul_lang b where a.id_section='$SectionId' and b.id_article=a.id and b.lang='$lang' order by priorytet desc limit 1";
	$res=mysql_query($sql);
	$row=mysql_fetch_array($res);
	$ArticleId=$row["id"];
}

function getLang_($aid)
{
	$sql="select lang from artykul_lang where id_article='$aid'";
	$res=mysql_query($sql);
	while($row=mysql_fetch_array($res)){
		$lang[]=$row["lang"];
	}
	return $lang;
}

function getCounter(){
	//$plik=fopen('licznik.txt',"r");
	//$licznik=fgets($plik, 100);
	//$licznik++;

	$sql="select stan from licznik where nazwa='ustka'";
	$res=mysql_query($sql);
	$row=mysql_fetch_array($res);
	$licznik=$row['stan']+1;
	return $licznik;
}

$l=$_GET['l'];
if($l)$lang=$l;
else
	$lang='pl';
if($lang != 'pl')$s->assign("LANG", $lang);

if(!$sid)
	$aid=$section;
else
	$aid=$sid;
if(!$section)getFirstArticle_($id, $section, $lang);

$SectionName=getSectionName($section, $lang);
$s->assign("SECTION", $section);
$s->assign("SUBSECTION", $sid);
if($id){
	$s->assign("LANGS", getLang_($id));
	$s->assign("ID", $id);
	showArticle(0, 0, $id, $ArticleTitle, $ArticleText, $ArticleAtName, $ArticleAtFile, $ArticleAtSize, $ArticleMore, $lang, $czyTytul);
	$s->assign("ARTICLE_TITLE", $ArticleTitle);
	$s->assign("ARTICLE_TEXT", $ArticleText);
	$s->assign("ARTICLE_ATNAME", $ArticleAtName);
	$s->assign("ARTICLE_ATFILE", $ArticleAtFile);
	$s->assign("ARTICLE_ATSIZE", $ArticleAtSize);
	$s->assign("ARTICLE_CZYTYTUL", $czyTytul);
}

getArticleTreeMenu($section, $SectionTreeId, $SectionTreeName, $SectionTreeSpace, $lang);
$s->assign("ARTICLE_TREEID", $SectionTreeId);
$s->assign("ARTICLE_TREENAME", $SectionTreeName);
$s->assign("ARTICLE_TREESPACE", $SectionTreeSpace);

getArticleMenu($aid, $MenuArticleId, $MenuArticleTitle, $lang);
$s->assign("ARTICLE_MENUID", $MenuArticleId);
$s->assign("ARTICLE_MENUTITLE", $MenuArticleTitle);
if($MenuArticleId){
	$s->assign("LANGS", getLang_($MenuArticleId[0]));
	if(count($MenuArticleId) == 1){
		showArticle(0, 0, $MenuArticleId[0], $ArticleFTitle, $ArticleFText, $ArticleFAtName, $ArticleFAtFile, $ArticleFAtSize, $ArticleFMore, $lang, $czyTytul);
		$s->assign("ARTICLE_SINGLE", true);
		$s->assign("ARTICLE_MENUATNAME", $ArticleFAtName);
		$s->assign("ARTICLE_MENUATFILE", $ArticleFAtFile);
		$s->assign("ARTICLE_MENUATSIZE", $ArticleFAtSize);
		$s->assign("ARTICLE_CZYTYTUL", $czyTytul);
	} else {
		showArticle(1, 500, $MenuArticleId[0], $ArticleFTitle, $ArticleFText, $ArticleFAtName, $ArticleFAtFile, $ArticleFAtSize, $ArticleFMore, $lang, $czyTytul);
	}
	$s->assign("ARTICLE_MENUTEXT", $ArticleFText);
	$s->assign("ARTICLE_MENUMORE", $ArticleFMore);
	$s->assign("ARTICLE_CZYTYTUL", $czyTytul);
}

$nav[]="Strona główna";
$nav_url[]="index.html";

$nav[]=$SectionName;
$nav_url[]="ustka.html?section=$section";
if($sid){
	$SubSectionName=getSectionName($sid, $lang);
	$nav[]=$SubSectionName;
	$nav_url[]="ustka.html?section=$section&sid=$sid";
	$s->assign("SECTION_NAME", $SubSectionName);
} else {
	$s->assign("SECTION_NAME", $SectionName);
}

if($id){
	$nav[]=$ArticleTitle;
	$nav_url[]="ustka.html?id=$id";
}

$navbar=getNavbar($nav, $nav_url, "nav_dot.gif");
$s->assign("NAVBAR", $navbar);

$s->assign("COUNTER", getCounter());

require("/var/www/inc/kalendarz.inc");
require("/var/www/inc/box_weather.inc");
require("/var/www/inc/box_poll.inc");

$s->assign("URL", 'http://'.$SERVER_NAME.$REQUEST_URI);

$s->display("ustka.tpl");