".$locale['406']." | "; echo THEME_BULLET."".$locale['403']." | "; $result = dbquery("SELECT * FROM ".$db_prefix."news_cats ORDER BY news_cat_id"); if (dbrows($result)) { while ($data = dbarray($result)) { echo THEME_BULLET." ".$data['news_cat_name']." | "; } } else { echo "".$locale['407']."\n"; } closetable(); add_to_title($locale['global_200'].$locale['400']); if (isset($_GET['cat_id']) && isnum($_GET['cat_id'])) { $res = 0; $result = dbquery("SELECT * 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; set_title($data['news_cat_name']); opentable($data['news_cat_name']); echo "\n"; if ($_GET['cat_id'] != 0) { echo "\n"; echo "\n\n\n\n\n

\n"; } else { echo "

\n"; } $result2 = dbquery("SELECT * FROM ".DB_NEWS." tn LEFT JOIN ".DB_USERS." tu ON tn.news_name=tu.user_id 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 LIMIT $rowstart, $miktar"); while ($data2 = dbarray($result2)) { if ($data2['news_image']) { $news_image = ""; } else { $news_image = ""; } $news_cat_image = "

"; $unif = THEME_BULLET." ".$data2['news_subject']." \n"; $frog = $news_image.stripslashes($data2['news_news']); opentable($unif); echo $news_cat_image; echo $frog; echo"

".THEME_BULLET."".$locale['409']." ".THEME_BULLET." ".$locale['410']."".$locale['global_081']."".$data2['news_reads'].". ".$locale['411']."".$locale['global_082']."".showdate("forumdate",$data2['news_datestamp'])."

"; if (checkrights("N")) { echo "

\n"; }echo"

"; closetable(); echo"

"; } echo "

\n"; if ($rows>$miktar) { echo makepagenav($_GET['rowstart'],$miktar,$rows,3,FUSION_SELF."?cat_id=".$_GET['cat_id']."&"); } } } if (!$res) { redirect(FUSION_SELF); } } else { opentable($locale['400']); $res = 0; $result = dbquery("SELECT * FROM ".DB_NEWS_CATS." ORDER BY news_cat_id"); if (dbrows($result)) { echo "\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 "\n\n"; echo "\n\n"; } $res = 1; } $result = dbquery("SELECT * FROM ".DB_NEWS." tn LEFT JOIN ".DB_USERS." tu ON tn.news_name=tu.user_id 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 5"); if (dbrows($result)) { if ($res == 0) { echo "

\n"; echo "".$locale['401']." ".$data['news_cat_name']."
\n".$locale['402']." $rows

\n"; if ($rows) { $result2 = dbquery("SELECT * FROM ".DB_NEWS." tn LEFT JOIN ".DB_USERS." tu ON tn.news_name=tu.user_id 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 5"); while ($data2 = dbarray($result2)) { if ($data2['news_image']) { $news_image = ""; } else { $news_image = ""; } $news_cat_image = "

"; $unif = THEME_BULLET." ".$data2['news_subject']." \n"; $frog = $news_image.stripslashes($data2['news_news']); opentable($unif); echo $frog; echo"

";if (checkrights("N")) { echo "

\n"; } echo"

"; closetable(); echo"

"; } if ($rows > 5) { echo "

".THEME_BULLET." ".$locale['405']."

\n"; } echo"

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

\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 "\n\n\n\n"; } if ($res == 1) { echo "

".$locale['403']."
\n"; echo "".$locale['402']." $nrows

\n"; while ($data = dbarray($result)) { if ($data['news_image']) { $news_image = ""; } else { $news_image = ""; } $unif = THEME_BULLET." ".$data['news_subject']." \n"; $frog = $news_image; opentable($unif); echo $frog; echo"

".THEME_BULLET."".$locale['409']." ".$data['user_name']." ".THEME_BULLET." ".$locale['410']." ".$data['news_reads']."".$locale['411']." ".THEME_BULLET."".$locale['412'].":".showdate("forumdate",$data['news_datestamp'])."

";if (checkrights("N")) { echo "

\n"; } echo"

"; closetable(); echo"

"; } $res = 1; if ($nrows > 5) { echo "

".THEME_BULLET." ".$locale['405']."

\n"; } echo "

\n"; } else { echo "

\n".$locale['407']."

\n

\n"; } } echo "

"; closetable(); require_once THEMES."templates/footer.php"; ?>