<?php



require_once "maincore.php";

require_once THEMES."templates/header.php";







// Predefined variables, do not edit these values

$i = 0;



// Number of news displayed

$items_per_page = $settings['newsperpage'];



add_to_title(" - D1 Startseite");



if (!isset($_GET['readmore']) || !isnum($_GET['readmore'])) {

   $rows = dbcount(

      "(news_id)",

      DB_NEWS,

      groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().")

                              AND (news_end='0'||news_end>=".time().")

                              AND news_draft='0'"

   );

   if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }

   if ($rows) {

      $result = dbquery(

         "SELECT tn.*, tc.*, tu.user_id, tu.user_name, tu.user_status

         FROM ".DB_NEWS." tn

         LEFT JOIN ".DB_USERS." tu ON tn.news_name=tu.user_id

         LEFT JOIN ".DB_NEWS_CATS." tc ON tn.news_cat=tc.news_cat_id

         WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().")

            AND (news_end='0'||news_end>=".time().") AND news_draft='0'

         GROUP BY news_id

         ORDER BY news_sticky DESC, news_datestamp DESC LIMIT ".$_GET['rowstart'].",".$items_per_page

      );

      $numrows = dbrows($result);

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

         $i++;

         $comments = dbcount("(comment_id)", DB_COMMENTS." WHERE comment_type='N' AND comment_hidden='0' AND comment_item_id='".$data['news_id']."'");

         $news_cat_image = "";

         $news_subject = "<a name='news_".$data['news_id']."' id='news_".$data['news_id']."'></a>".stripslashes($data['news_subject']);

         $news_cat_image = "<a href='".($settings['news_image_link'] == 0 ? "news_cats.php?cat_id=".$data['news_cat']

                                                            : FUSION_SELF."?readmore=".$data['news_id'] )."'>";

         if ($data['news_image_t2'] && $settings['news_image_frontpage'] == 0) {

            $news_cat_image .= "<img src='".IMAGES_N_T.$data['news_image_t2']."' alt='".$data['news_subject']."' class='news-category' /></a>";

         } elseif ($data['news_cat_image']) {

            $news_cat_image .= "<img src='".get_image("nc_".$data['news_cat_name'])."' alt='".$data['news_cat_name']."' class='news-category' /></a>";

         } else {

            $news_cat_image = "";

         }

         $news_news = preg_replace("/<!?--\s*pagebreak\s*-->/i", "", ($data['news_breaks'] == "y" ? nl2br(stripslashes($data['news_news'])) : stripslashes($data['news_news'])));

         $news_info = array(

            "news_id" => $data['news_id'],

            "user_id" => $data['user_id'],

            "user_name" => $data['user_name'],

            "user_status" => $data['user_status'],

            "news_date" => $data['news_datestamp'],

            "cat_id" => $data['news_cat'],

            "cat_name" => $data['news_cat_name'],

            "cat_image" => $news_cat_image,

            "news_subject" => $data['news_subject'],

            "news_ext" => $data['news_extended'] ? "y" : "n",

            "news_reads" => $data['news_reads'],

            "news_comments" => $comments,

            "news_allow_comments" => $data['news_allow_comments'],

            "news_sticky" => $data['news_sticky']

         );



         echo "<!--news_prepost_".$i."-->\n";

         if ($_GET['rowstart'] >= $items_per_page) {

         render_news($news_subject, $news_news, $news_info);

         }

      }

      echo "<!--sub_news_idx-->\n";

      if ($_GET['rowstart'] >= $items_per_page) {

      if ($rows > $items_per_page) echo "<div align='center' style=';margin-top:5px;'>\n".makepagenav($_GET['rowstart'],$items_per_page,$rows,3)."\n</div><br>\n";

      }

   } else {

      //opentable($locale['global_077']);

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

      //closetable();

   }

} else {

   if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }

   $result = dbquery(

      "SELECT tn.*, tc.*, tu.user_id, tu.user_name, tu.user_status FROM ".DB_NEWS." tn

      LEFT JOIN ".DB_USERS." tu ON tn.news_name=tu.user_id

      LEFT JOIN ".DB_NEWS_CATS." tc ON tn.news_cat=tc.news_cat_id

      WHERE ".groupaccess('news_visibility')." AND news_id='".$_GET['readmore']."' AND news_draft='0'

      LIMIT 1"

   );

   if (dbrows($result)) {

      include INCLUDES."comments_include.php";

      include INCLUDES."ratings_include.php";

      $data = dbarray($result);

      if (!isset($_POST['post_comment']) && !isset($_POST['post_rating'])) {

         $result2 = dbquery("UPDATE ".DB_NEWS." SET news_reads=news_reads+1 WHERE news_id='".$_GET['readmore']."'");

         $data['news_reads']++;

      }

      $news_cat_image = "";

      $news_subject = $data['news_subject'];

      if ($data['news_image_t1'] && $settings['news_image_readmore'] == "0") {

         $img_size = @getimagesize(IMAGES_N.$data['news_image']);

         $news_cat_image = "<a href=\"javascript:;\" onclick=\"window.open('".IMAGES_N.$data['news_image']."','','scrollbars=yes,toolbar=no,status=no,resizable=yes,width=".($img_size[0]+20).",height=".($img_size[1]+20)."')\"><img src='".IMAGES_N_T.$data['news_image_t1']."' alt='".$data['news_subject']."' class='news-category' /></a>";

      } elseif ($data['news_cat_image']) {

         $news_cat_image = "<a href='news_cats.php?cat_id=".$data['news_cat']."'><img src='".get_image("nc_".$data['news_cat_name'])."' alt='".$data['news_cat_name']."' class='news-category' /></a>";

      }

      $news_news = preg_split("/<!?--\s*pagebreak\s*-->/i", $data['news_breaks'] == "y" ? nl2br(stripslashes($data['news_extended'] ? $data['news_extended'] : $data['news_news'])) : stripslashes($data['news_extended'] ? $data['news_extended'] : $data['news_news']));    

      $pagecount = count($news_news);

      $news_info = array(

         "news_id" => $data['news_id'],

         "user_id" => $data['user_id'],

         "user_name" => $data['user_name'],

         "user_status" => $data['user_status'],

         "news_date" => $data['news_datestamp'],

         "cat_id" => $data['news_cat'],

         "cat_name" => $data['news_cat_name'],

         "cat_image" => $news_cat_image,

         "news_subject" => $data['news_subject'],

         "news_ext" => "n",

         "news_reads" => $data['news_reads'],

         "news_comments" => dbcount("(comment_id)", DB_COMMENTS, "comment_type='N' AND comment_item_id='".$data['news_id']."' AND comment_hidden='0'"),

         "news_allow_comments" => $data['news_allow_comments'],

         "news_sticky" => $data['news_sticky']

      );

      add_to_title($locale['global_201'].$news_subject);

      echo "<!--news_pre_readmore-->";

      render_news($news_subject, $news_news[$_GET['rowstart']], $news_info);

      echo "<!--news_sub_readmore-->";

      if ($pagecount > 1) {

         echo "<div align='center' style='margin-top:5px;'>\n".makepagenav($_GET['rowstart'], 1, $pagecount, 3, FUSION_SELF."?readmore=".$_GET['readmore']."&amp;")."\n</div>\n";

      }

      if ($data['news_allow_comments']) { showcomments("N", DB_NEWS, "news_id", $_GET['readmore'], FUSION_SELF."?readmore=".$_GET['readmore']); }

      if ($data['news_allow_ratings']) { showratings("N", $_GET['readmore'], FUSION_SELF."?readmore=".$_GET['readmore']); }

   } else {

      redirect(FUSION_SELF);

   }

}











require_once THEMES."templates/footer.php";



?>