Ravens PHP Scripts: Forums
 

 
  Forum Index  •  Forum FAQ  •  Search  •  Memberlist  •  Usergroups  •  Profile  •  Log in to check your private messages  •  Log in

Pagenumbers help please
 View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> phpnuke 7.4
Author Message
dobbelina
Hangin' Around



Joined: Jul 21, 2004
Posts: 47
PostPosted: Sat Jul 24, 2004 6:13 am Reply with quote
Hi !
I tried to apply the pagenumbers fix on my News module(I'm using v7.4+ patch files).
But it doesn't work right when i try to paste the code myself.
However when using the 2 files that came with the fix it works fine.
(index.php and categories.php).
(Page Numbers for PHP-Nuke 7.0 Alpha 2 )
If there's a newer one that works fine with v7.4 please tell me where to find it !
Could someone be so nice and tell me if these fix files are safe/patched or not.
And if not perhaps help me to patch these
Many thanks Dobbelina Very Happy
Here's the index.php

Code:
<?php





/************************************************************************/


/* PHP-NUKE: Web Portal System                                          */


/* ===========================                                          */


/*                                                                      */


/* Copyright (c) 2002 by Francisco Burzi                                */


/* http://phpnuke.org                                                   */


/*                                                                      */


/* This program is free software. You can redistribute it and/or modify */


/* it under the terms of the GNU General Public License as published by */


/* the Free Software Foundation; either version 2 of the License.       */


/************************************************************************/





if (!eregi("modules.php", $_SERVER['PHP_SELF'])) {


    die ("You can't access this file directly...");


}





$index = 1;


require_once("mainfile.php");


$module_name = basename(dirname(__FILE__));


get_lang($module_name);





function theindex($new_topic=0) {


   # Page Numbers added $pagenum


    global $db, $storyhome, $topicname, $topicimage, $topictext, $datetime, $user, $cookie, $nukeurl, $prefix, $multilingual, $currentlang, $articlecomm, $sitename, $user_news, $pagenum;


    if ($multilingual == 1) {


   $querylang = "AND (alanguage='$currentlang' OR alanguage='')";


    } else {


   $querylang = "";


    }


    include("header.php");


    automated_news();


    if (isset($cookie[3]) AND $user_news == 1) {


   $storynum = $cookie[3];


    } else {


   $storynum = $storyhome;


    }


    if ($new_topic == 0) {


   $qdb = "WHERE (ihome='0' OR catid='0')";


   $home_msg = "";


    } else {


   $qdb = "WHERE topic='$new_topic'";


   $sql_a = "SELECT topictext FROM ".$prefix."_topics WHERE topicid='$new_topic'";


   $result_a = $db->sql_query($sql_a);


   $row_a = $db->sql_fetchrow($result_a);   


   $numrows_a = $db->sql_numrows($result_a);


   $topic_title = $row_a[topictext];


   OpenTable();


   if ($numrows == 0) {


       echo "<center><font class=\"title\">$sitename</font><br><br>"._NOINFO4TOPIC."<br><br>[ <a href=\"news.html\">"._GOTONEWSINDEX."</a> | <a href=\"topics.html\">"._SELECTNEWTOPIC."</a> ]</center>";


   } else {


       echo "<center><font class=\"title\">$sitename: $topic_title</font><br><br>"


      ."<form action=\"search.html\" method=\"post\">"


      ."<input type=\"hidden\" name=\"topic\" value=\"$new_topic\">"


      .""._SEARCHONTOPIC.": <input type=\"name\" name=\"query\" size=\"30\"> ;; ;;"


      ."<input type=\"submit\" value=\""._SEARCH."\">"


      ."</form>"


      ."[ <a href=\"index.php\">"._GOTOHOME."</a> | <a href=\"topics.html\">"._SELECTNEWTOPIC."</a> ]</center>";


   }


   CloseTable();


   echo "<br>";


    }


   # START Page Numbers


    if ($pagenum == "") { $pagenum = 1 ; }


    $offset = ($pagenum-1) * $storynum ;


    $sql = "SELECT sid, catid, aid, title, time, hometext, bodytext, comments, counter, topic, informant, notes, acomm, score, ratings FROM ".$prefix."_stories $qdb $querylang ORDER BY sid DESC limit $offset, $storynum";


   # END Page Numbers





    $result = $db->sql_query($sql);


    while ($row = $db->sql_fetchrow($result)) {


   $s_sid = $row['sid'];


   $catid = $row[catid];


   $aid = $row[aid];


   $title = $row[title];


   $time = $row[time];


   $hometext = $row[hometext];


   $bodytext = $row[bodytext];


   $comments = $row[comments];


   $counter = $row[counter];


   $topic = $row[topic];


   $informant = $row[informant];


   $notes = $row[notes];


   $acomm = $row[acomm];


   $score = $row[score];


   $ratings = $row[ratings];


   if ($catid > 0) {


       $sql2 = "SELECT title FROM ".$prefix."_stories_cat WHERE catid='$catid'";


       $result2 = $db->sql_query($sql2);


       $row2 = $db->sql_fetchrow($result2);


       $cattitle = $row2[title];


   }


   getTopics($s_sid);


   formatTimestamp($time);


   $subject = stripslashes($subject);


   $hometext = stripslashes($hometext);


   $notes = stripslashes($notes);


   $introcount = strlen($hometext);


   $fullcount = strlen($bodytext);


   $totalcount = $introcount + $fullcount;


   $c_count = $comments;


   $r_options = "";


        if (isset($cookie[4])) { $r_options .= "&amp;mode=$cookie[4]"; }


        if (isset($cookie[5])) { $r_options .= "&amp;order=$cookie[5]"; }


        if (isset($cookie[6])) { $r_options .= "&amp;thold=$cookie[6]"; }


   if (is_user($user)) {


       $the_icons = " | <a href=\"modules.php?name=News&amp;file=print&amp;sid=$s_sid\"><img src=\"images/print.gif\" border=\"0\" alt=\""._PRINTER."\" title=\""._PRINTER."\" width=\"16\" height=\"11\"></a> ;; ;;<a href=\"modules.php?name=News&amp;file=friend&amp;op=FriendSend&amp;sid=$s_sid\"><img src=\"images/friend.gif\" border=\"0\" alt=\""._FRIEND."\" title=\""._FRIEND."\" width=\"16\" height=\"11\"></a>";


   } else {


       $the_icons = "";


   }


   $story_link = "<a href=\"modules.php?name=News&amp;file=article&amp;sid=$s_sid$r_options\">";


   $morelink = "(";


   if ($fullcount > 0 OR $c_count > 0 OR $articlecomm == 0 OR $acomm == 1) {


       $morelink .= "$story_link<b>"._READMORE."</b></a> | ";


   } else {


       $morelink .= "";


   }


   if ($fullcount > 0) { $morelink .= "$totalcount "._BYTESMORE." | "; }


   if ($articlecomm == 1 AND $acomm == 0) {


       if ($c_count == 0) { $morelink .= "$story_link"._COMMENTSQ."</a>"; } elseif ($c_count == 1) { $morelink .= "$story_link$c_count "._COMMENT."</a>"; } elseif ($c_count > 1) { $morelink .= "$story_link$c_count "._COMMENTS."</a>"; }


   }


   $morelink .= "$the_icons";


   $sid = $s_sid;


   if ($catid != 0) {


       $sql3 = "SELECT title FROM ".$prefix."_stories_cat WHERE catid='$catid'";


       $result3 = $db->sql_query($sql3);


       $row3 = $db->sql_fetchrow($result3);


       $title1 = $row3[title];


       $title = "$title";


       $morelink .= " | <a href=\"modules.php?name=News&amp;file=categories&amp;op=newindex&amp;catid=$catid\">$title1</a>";


   }


   if ($score != 0) {


       $rated = substr($score / $ratings, 0, 4);


   } else {


       $rated = 0;


   }


   $morelink .= " | "._SCORE." $rated";


   $morelink .= ")";


   $morelink = str_replace(" |  | ", " | ", $morelink);


   themeindex($aid, $informant, $datetime, $title, $counter, $topic, $hometext, $notes, $morelink, $topicname, $topicimage, $topictext);


    }


    # START Page Numbers





    # Uncomment this next line and change 100 to whatever for number of stories in news and topics for Page Numbers section


    #$limitpn = "limit 10"; # limit number of stories


   $sql_pn = "select * from ".$prefix."_stories $qdb $querylang $limitpn";


    $result_pn = $db->sql_query($sql_pn);


    $numstories = $db->sql_numrows($result_pn);


    $numpages = ceil($numstories / $storynum);


    #if ($numpages > 1 and $new_topic == 0) {


    if ($numpages > 1) {


        opentable();


        echo "<center>$numstories "._STORIES." ($numpages "._PAGES.", $storynum "._PERPAGE.")<br>" ;


        if ($pagenum > 1) {


            $prevpage = $pagenum - 1 ;


         $leftarrow = "images/left.gif" ;


            if(isset($new_topic)) {


                echo "<a href=\"modules.php?name=News&amp;new_topic=$new_topic&amp;pagenum=$prevpage\">";


                echo "<img src=\"$leftarrow\" align=\"absmiddle\" border=\"0\" hspace=\"10\"></a>";


            } else {


                echo "<a href=\"modules.php?name=News&amp;pagenum=$prevpage\">";


                echo "<img src=\"$leftarrow\" align=\"absmiddle\" border=\"0\" hspace=\"10\"></a>";


            }


        }


        echo "[ " ;


        for ($i=1; $i < $numpages+1; $i++) {


            if ($i == $pagenum) {


                echo "<b>$i</b>";


            } else {


                if(isset($new_topic)) {


                    echo "<a href=\"modules.php?name=News&amp;new_topic=$new_topic&amp;pagenum=$i\">$i</a>";


                } else {


                    echo "<a href=\"modules.php?name=News&amp;pagenum=$i\">$i</a>";


                }


            }


            if ($i < $numpages) { echo " | "; } else { echo " ]"; }


        }


        if ($pagenum < $numpages) {


            $nextpage = $pagenum + 1 ;


         $rightarrow = "images/right.gif" ;


            if(isset($new_topic)) {


                echo "<a href=\"modules.php?name=News&amp;new_topic=$new_topic&amp;pagenum=$nextpage\">";


                echo "<img src=\"$rightarrow\" align=\"absmiddle\" border=\"0\" hspace=\"10\"></a>";


            } else {


                echo "<a href=\"modules.php?name=News&amp;pagenum=$nextpage\">";


                echo "<img src=\"$rightarrow\" align=\"absmiddle\" border=\"0\" hspace=\"10\"></a>";


            }


        }


        echo "</center>" ;


        closetable();


    }


    # END Page Numbers in news and topics


    include("footer.php");


}





function rate_article($sid, $score) {


    global $prefix, $dbi, $ratecookie, $sitename, $r_options;


    $score = intval($score);


    if ($score) {


   if ($score > 5) { $score = 5; }


   if ($score < 1) { $score = 1; }


   if ($score != 1 AND $score != 2 AND $score != 3 AND $score != 4 AND $score != 5) {


       Header("Location: index.php");


       die();


   }


   if (isset($ratecookie)) {


       $rcookie = base64_decode($ratecookie);


       $r_cookie = explode(":", $rcookie);


   }


   for ($i=0; $i < sizeof($r_cookie); $i++) {


       if ($r_cookie[$i] == $sid) {


      $a = 1;


       }


   }


   if ($a == 1) {


       Header("Location: modules.php?name=News&op=rate_complete&sid=$sid&rated=1");


   } else {


       $result = sql_query("update ".$prefix."_stories set score=score+$score, ratings=ratings+1 where sid='$sid'", $dbi);


       $info = base64_encode("$rcookie$sid:");


       setcookie("ratecookie","$info",time()+3600);


       update_points(7);


       Header("Location: modules.php?name=News&op=rate_complete&sid=$sid$r_options");


   }


    } else {


   include("header.php");


   title("$sitename: "._ARTICLERATING."");


   OpenTable();


   echo "<center>"._DIDNTRATE."<br><br>"


       .""._GOBACK."</center>";


   CloseTable();


   include("footer.php");


    }


}





function rate_complete($sid, $rated=0) {


    global $sitename, $user, $cookie;


    $r_options = "";


    if (is_user($user)) {


   if (isset($cookie[4])) { $r_options .= "&amp;mode=$cookie[4]"; }


   if (isset($cookie[5])) { $r_options .= "&amp;order=$cookie[5]"; }


        if (isset($cookie[6])) { $r_options .= "&amp;thold=$cookie[6]"; }


    }


    include("header.php");


    title("$sitename: "._ARTICLERATING."");


    OpenTable();


    if ($rated == 0) {


   echo "<center>"._THANKSVOTEARTICLE."<br><br>"


       ."[ <a href=\"modules.php?name=News&amp;file=article&amp;sid=$sid$r_options\">"._BACKTOARTICLEPAGE."</a> ]</center>";


    } elseif ($rated == 1) {


   echo "<center>"._ALREADYVOTEDARTICLE."<br><br>"


       ."[ <a href=\"modules.php?name=News&amp;file=article&amp;sid=$sid$r_options\">"._BACKTOARTICLEPAGE."</a> ]</center>";


    }


    CloseTable();


    include("footer.php");


}





switch ($op) {





    default:


    theindex($new_topic);


    break;





    case "rate_article":


    rate_article($sid, $score);


    break;





    case "rate_complete":


    rate_complete($sid, $rated);


    break;





}





?>











?>

And here's the category.php:
Code:
<?php





/************************************************************************/


/* PHP-NUKE: Web Portal System                                          */


/* ===========================                                          */


/*                                                                      */


/* Copyright (c) 2002 by Francisco Burzi                                */


/* http://phpnuke.org                                                   */


/*                                                                      */


/* This program is free software. You can redistribute it and/or modify */


/* it under the terms of the GNU General Public License as published by */


/* the Free Software Foundation; either version 2 of the License.       */


/************************************************************************/





if (!eregi("modules.php", $_SERVER['PHP_SELF'])) {


    die ("You can't access this file directly...");


}





require_once("mainfile.php");


$module_name = basename(dirname(__FILE__));


get_lang($module_name);





$index = 1;


$categories = 1;


$cat = $catid;


automated_news();





function theindex($catid) {


   # Page Numbers added $pagenum


    global $storyhome, $httpref, $httprefmax, $topicname, $topicimage, $topictext, $datetime, $user, $cookie, $nukeurl, $prefix, $multilingual, $currentlang, $db, $articlecomm, $module_name, $pagenum;


    if ($multilingual == 1) {


       $querylang = "AND (alanguage='$currentlang' OR alanguage='')"; /* the OR is needed to display stories who are posted to ALL languages */


    } else {


       $querylang = "";


    }


    include("header.php");


    if (isset($cookie[3])) {


   $storynum = $cookie[3];


    } else {


   $storynum = $storyhome;


    }


    $db->sql_query("update ".$prefix."_stories_cat set counter=counter+1 where catid='$catid'");


   # START Page Numbers


    if ($pagenum == "") { $pagenum = 1 ; }


    $offset = ($pagenum-1) * $storynum ;


    $sql = "SELECT sid, aid, title, time, hometext, bodytext, comments, counter, topic, informant, notes, acomm, score, ratings FROM ".$prefix."_stories where catid='$catid' $querylang ORDER BY sid DESC limit $offset, $storynum";


   # END Page Numbers





    $result = $db->sql_query($sql);


    while ($row = $db->sql_fetchrow($result)){


   $s_sid = $row['sid'];


   $aid = $row[aid];


   $title = $row[title];


   $time = $row[time];


   $hometext = $row[hometext];


   $bodytext = $row[bodytext];


   $comments = $row[comments];


   $counter = $row[counter];


   $topic = $row[topic];


   $informant = $row[informant];


   $notes = $row[notes];


   $acomm = $row[acomm];


   $score = $row[score];


   $ratings = $row[ratings];


   getTopics($s_sid);


   formatTimestamp($time);


   $subject = stripslashes($subject);


   $hometext = stripslashes($hometext);


   $notes = stripslashes($notes);


   $introcount = strlen($hometext);


   $fullcount = strlen($bodytext);


   $totalcount = $introcount + $fullcount;


   $c_count = $comments;


   $r_options = "";


        if (isset($cookie[4])) { $r_options .= "&amp;mode=$cookie[4]"; }


        if (isset($cookie[5])) { $r_options .= "&amp;order=$cookie[5]"; }


        if (isset($cookie[6])) { $r_options .= "&amp;thold=$cookie[6]"; }


   if (is_user($user)) {


       $the_icons = " | <a href=\"modules.php?name=News&amp;file=print&amp;sid=$s_sid\"><img src=\"images/print.gif\" border=\"0\" alt=\""._PRINTER."\" title=\""._PRINTER."\" width=\"16\" height=\"11\"></a> ;; ;;<a href=\"modules.php?name=News&amp;file=friend&amp;op=FriendSend&amp;sid=$s_sid\"><img src=\"images/friend.gif\" border=\"0\" alt=\""._FRIEND."\" title=\""._FRIEND."\" width=\"16\" height=\"11\"></a>";


   } else {


       $the_icons = "";


   }


   $story_link = "<a href=\"modules.php?name=News&amp;file=article&amp;sid=$s_sid$r_options\">";


   $morelink = "(";


   if ($fullcount > 0 OR $c_count > 0 OR $articlecomm == 0 OR $acomm == 1) {


       $morelink .= "$story_link<b>"._READMORE."</b></a> | ";


   } else {


       $morelink .= "";


   }


   if ($fullcount > 0) { $morelink .= "$totalcount "._BYTESMORE." | "; }


   if ($articlecomm == 1 AND $acomm == 0) {


       if ($c_count == 0) { $morelink .= "$story_link"._COMMENTSQ."</a>"; } elseif ($c_count == 1) { $morelink .= "$story_link$c_count "._COMMENT."</a>"; } elseif ($c_count > 1) { $morelink .= "$story_link$c_count "._COMMENTS."</a>"; }


   }


   $morelink .= "$the_icons";


   if ($score != 0) {


       $rated = substr($score / $ratings, 0, 4);


   } else {


       $rated = 0;


   }


   $morelink .= " | "._SCORE." $rated";


   $morelink .= ")";


   $morelink = str_replace(" |  | ", " | ", $morelink);


   $sid = $s_sid;


   $sql2 = "select title from ".$prefix."_stories_cat where catid='$catid'";


   $result2 = $db->sql_query($sql2);


   $row2 = $db->sql_fetchrow($result2);


   $title1 = $row2[title];


   


   $title = "$title1: $title";


   themeindex($aid, $informant, $datetime, $title, $counter, $topic, $hometext, $notes, $morelink, $topicname, $topicimage, $topictext);


    }


    if ($httpref==1) {


   $referer = $_SERVER["HTTP_REFERER"];


   if ($referer=="" OR ereg("unknown", $referer) OR eregi($nukeurl,$referer)) {


   } else {


       $db->sql_query("insert into ".$prefix."_referer values (NULL, '$referer')");


   }


   $numrows = $db->sql_numrows($db->sql_query("select * from ".$prefix."_referer"));


   if($numrows==$httprefmax) {


           $db->sql_query("delete from ".$prefix."_referer");


   }


    }


    # START Page Numbers





    # Uncomment this next line and change 100 to whatever for number of stories in categories for Page Numbers section


    #$limitpn = "limit 10"; # limit number of stories in categories





    $numstories = $db->sql_numrows($db->sql_query("select * from ".$prefix."_stories where catid='$catid' $querylang $limitpn"));


    $numpages = ceil($numstories / $storynum);


    if ($numpages > 1) {


        opentable();


        echo "<center>$numstories "._STORIES." ($numpages "._PAGES.", $storynum "._PERPAGE.")<br>" ;


        if ($pagenum > 1) {


            $prevpage = $pagenum - 1 ;


         $leftarrow = "images/left.gif" ;


            echo "<a href=\"modules.php?name=News&amp;file=categories&amp;op=newindex&amp;catid=$catid&amp;pagenum=$prevpage\">";


            echo "<img src=\"$leftarrow\" align=\"absmiddle\" border=\"0\" hspace=\"10\"></a>";


        }


        echo "[ " ;


        for ($i=1; $i < $numpages+1; $i++) {


            if ($i == $pagenum) {


                echo "<b>$i</b>";


            } else {


                echo "<a href=\"modules.php?name=News&amp;file=categories&amp;op=newindex&amp;catid=$catid&amp;pagenum=$i\">$i</a>";


            }


            if ($i < $numpages) { echo " | "; } else { echo " ]"; }


        }


        if ($pagenum < $numpages) {


            $nextpage = $pagenum + 1 ;


         $rightarrow = "images/right.gif" ;


            echo "<a href=\"modules.php?name=News&amp;file=categories&amp;op=newindex&amp;catid=$catid&amp;pagenum=$nextpage\">";


            echo "<img src=\"$rightarrow\" align=\"absmiddle\" border=\"0\" hspace=\"10\"></a>";


        }


        echo "</center>" ;


        closetable();


    }


    # END Page Numbers in categories


    include("footer.php");


}





switch ($op) {





    case "newindex":


   if ($catid == 0 OR $catid == "") {


       Header("Location: modules.php?name=$module_name");


   }


   theindex($catid);


    break;





    default:


    Header("Location: modules.php?name=$module_name");





}





?>

This goes into language/lang-english.php:
Code:
define("_STORIES","Stories");


define("_PAGES","Pages");


define("_PERPAGE","Per Page");
 
View user's profile Send private message
sixonetonoffun
Spouse Contemplates Divorce



Joined: Jan 02, 2003
Posts: 2496
PostPosted: Sun Jul 25, 2004 4:24 pm Reply with quote
If you can't work it out try NSN News Universal http://www.nukescripts.net/ it gives a few more user friendly options then the standard module like 2 column news ect...

_________________
[b][size=5]openSUSE 11.4-x86 | Linux 2.6.37.1-1.2desktop i686 | KDE: 4.6.41>=4.7 | XFCE 4.8 | AMD Athlon(tm) XP 3000+ | MSI K7N2 Delta-L | 3GB Black Diamond DDR
| GeForce 6200@433Mhz 512MB | Xorg 1.9.3 | NVIDIA 270.30[/size:2b8 
View user's profile Send private message
dobbelina
PostPosted: Mon Jul 26, 2004 3:35 am Reply with quote
Thanks, i'll check it out !
Actually this pagenumber fix that i'm using now is working fine, i'm just not sure
how safe it is ?(don't wanna be hacked)
Dobbelina Smile
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> phpnuke 7.4


 Jump to:   




View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©