WordPress, Shopify ir PHPFusion programuotojų bendruomenė

Parašė gakse· 2009 Lie. 22 00:07:54

Sveiki kas gali perdaryti sita faila is v6 i v7 cia news_cats.php cia klaida kaskokia su db nu musql ar kaip ten kas gali sudeti viska tuos mysql ir tuos maincore.php virsui kur ant v7 buna nu kad tiktu sitas ant versijos 7 ir daugeu nieko nekeist va kodas

<?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";

include LOCALE.LOCALESET."news_cats.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";

?>

Busiu labai dekingas kas perdarys i v7 php fusion versija.

Redagavo gakse· 2009 Lie. 22 09:07:27

Parašė And2s· 2009 Lie. 22 14:07:25

<?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 THEMES."templates/header.php";

include LOCALE.LOCALESET."news_cats.php";

global $db_prefix;

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 THEMES."templates/footer.php";

?>