Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: news_cats.php

Parašė gintulys· 2009 Lie. 9 00:07:40
#1

Naudoju štai toki news_cats.php failą, ir dabar jame visos naujienos viename puslapyje. Gal kas padarytu, kad butu viename puslapyje 10 naujienu.
Štai realiai galite pažėti čia: http://viskas.stilingi.lt/news_c...?cat_id=17

<?php
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2005 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit http://gnu.org
+----------------------------------------------------*/
require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";

if (!isset($readmore)) {
   $items_per_page = 10;
   if (isset($cat_id)) {
      $result = dbquery("SELECT * FROM ".$db_prefix."news_cats WHERE news_cat_id='$cat_id'");
      if (dbrows($result) || $cat_id == 0) {
         $data = dbarray($result);
         $rows = dbcount("(news_id)", "news", "news_cat='$cat_id' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")");
         $result = dbquery("SELECT * FROM ".$db_prefix."news WHERE news_cat='$cat_id' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") ORDER BY news_datestamp DESC");
         //opentable("News Items in " .$data['news_cat_name']. " Category");
         //closetable();
      }
   } else {
      $result = dbquery(
         "SELECT tn.*, user_id, user_name FROM ".$db_prefix."news tn
         LEFT JOIN ".$db_prefix."users tu ON tn.news_name=tu.user_id
         WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")
         ORDER BY news_datestamp DESC LIMIT $rowstart,$items_per_page"
      );
      $rows = dbcount("(news_id)", "news", groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")");
   }
   if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
   if ($rows != 0) {
      $i = 1;
      $numrows = dbrows($result);
      while ($data = dbarray($result)) {
         $news_cat_image = "";
         $news_subject = "<a name='news_".$data['news_id']."' id='news_".$data['news_id']."'></a>".stripslashes($data['news_subject']);
         if ($data['news_cat'] != 0) {
            $result2 = dbquery("SELECT * FROM ".$db_prefix."news_cats WHERE news_cat_id='".$data['news_cat']."'");
            if (dbrows($result2)) {
               $data2 = dbarray($result2);
               $news_cat_image = "<a href='news_cats.php?cat_id=".$data2['news_cat_id']."'><img src='".IMAGES_NC.$data2['news_cat_image']."' alt='".$data2['news_cat_name']."' align='left' style='border:0px;margin-right:5px'></a>";
            }
         }
         $news_news = stripslashes($data['news_news']);
         if ($data['news_breaks'] == "y") $news_news = nl2br($news_news);
         if ($news_cat_image != "") $news_news = $news_cat_image.$news_news;
         $news_info = array(
            "news_id" => $data['news_id'],
            "user_id" => $data['user_id'],
            "user_name" => $data['user_name'],
            "news_date" => $data['news_datestamp'],
            "news_ext" => $data['news_extended'] ? "y" : "n",
            "news_reads" => $data['news_reads'],
            "news_comments" => dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id='".$data['news_id']."'"),
            "news_allow_comments" => $data['news_allow_comments']
         );
         render_news($news_subject, $news_news, $news_info);
         if ($i != $numrows) { tablebreak(); } $i++;
      }
      if ($rows > $items_per_page) echo "<div align='center' style='margin-top:5px;'>\n".makePageNav($rowstart,$items_per_page,$rows,3)."\n</div>\n";
   } else {
      opentable($locale['046']);
      echo "<center><br>\n".$locale['047']."<br><br>\n</center>\n";
      closetable();
   }
} else {
   if (!isNum($readmore)) fallback(FUSION_SELF);
   include INCLUDES."comments_include.php";
   include INCLUDES."ratings_include.php";
   $result = dbquery(
      "SELECT tn.*, user_id, user_name FROM ".$db_prefix."news tn
      LEFT JOIN ".$db_prefix."users tu ON tn.news_name=tu.user_id
      WHERE news_id='$readmore'"
   );
   if (dbrows($result)!=0) {
      $data = dbarray($result);
      if (checkgroup($data['news_visibility'])) {
         $news_cat_image = "";
         if (!isset($_POST['post_comment']) && !isset($_POST['post_rating'])) {
             $result2 = dbquery("UPDATE ".$db_prefix."news SET news_reads=news_reads+1 WHERE news_id='$readmore'");
             $data['news_reads']++;
         }
         $news_subject = $data['news_subject'];
         if ($data['news_cat'] != 0) {
            $result2 = dbquery("SELECT * FROM ".$db_prefix."news_cats WHERE news_cat_id='".$data['news_cat']."'");
            if (dbrows($result2)) {
               $data2 = dbarray($result2);
               $news_cat_image = "<a href='news_cats.php?cat_id=".$data2['news_cat_id']."'><img src='".IMAGES_NC.$data2['news_cat_image']."' alt='".$data2['news_cat_name']."' align='left' style='border:0px;margin-right:5px'></a>";
            }
         }
         $news_news = stripslashes($data['news_extended'] ? $data['news_extended'] : $data['news_news']);
         if ($data['news_breaks'] == "y") { $news_news = nl2br($news_news); }
         if ($news_cat_image != "") $news_news = $news_cat_image.$news_news;
         $news_info = array(
            "news_id" => $data['news_id'],
            "user_id" => $data['user_id'],
            "user_name" => $data['user_name'],
            "news_date" => $data['news_datestamp'],
            "news_ext" => "n",
            "news_reads" => $data['news_reads'],
            "news_comments" => dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id='".$data['news_id']."'"),
            "news_allow_comments" => $data['news_allow_comments']
         );
         render_news($news_subject, $news_news, $news_info);
         if ($data['news_allow_comments']) showcomments("N","news","news_id",$readmore,FUSION_SELF."?readmore=$readmore");
         if ($data['news_allow_ratings']) showratings("N",$readmore,FUSION_SELF."?readmore=$readmore");
      } else {
         redirect(FUSION_SELF);
      }
   } else {
      redirect(FUSION_SELF);
   }
}

require_once "side_right.php";
require_once "footer.php";
?>



Redagavo gintulys· 2009 Lie. 13 04:07:50

Parašė Nepas· 2009 Lie. 9 00:07:47
#2

   $items_per_page = 10;



tai dešimt dbr ir turi rodyt :|

Parašė gintulys· 2009 Lie. 9 00:07:08
#3

bet nerodo :( Gal toliou kodui kazkas negerai?

Redagavo gintulys· 2009 Lie. 9 00:07:13

Parašė _Tomas· 2009 Lie. 13 03:07:23
#4

Gal neturi 10 naujienų?

Parašė gintulys· 2009 Lie. 13 03:07:34
#5

naujienų beveik 1000

Redagavo gintulys· 2009 Lie. 13 03:07:25