- Joined
- Dec 29, 2004
- Messages
- 49
- Reaction score
- 0
Hello php coders i need a little help with my nuke site .If u know in nuke sites are a little mod like news page numbers bet the lates version of it is only for nuke 7.0, my nuke is 7.8 and i need litle help. start here this is the instructions.
Code:
###############################################################################
# #
# Page Numbers for PHP-Nuke 7.0 Alpha 2 #
# #
# Copyright (c) 3/2003 by Scott Rubin ([email protected]) #
# http://www.ierealtor.com - phpnuke id: scottr #
# #
# Page Numbers at the bottom of the News/Topics/Categories pages. #
# Auto install contains exploit fix in rate_article function too. (Mar 22, 03)#
# #
###############################################################################
Version 1.0 - October 16, 2003
This release slightly different for PHP-Nuke 7.0
===============================================================================
Example, what you'll see when you are on the first News page of 117 stories
with 'Stories Number in Home' in Admin/Preferences set to 10:
117 Stories (12 Pages, 10 Per Page)
[ 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 ] ->
- - - - - - - - -- -- --
================================================================================
Installation Instructions:
Page Numbers can be installed by overwriting
html/modules/News/index.php # News Stories and Topics
html/modules/News/categories.php # Categories
OR
by making 6 changes described below (3 in each file)
and copying the contents of pagenum-yourlang.txt to inside
html/modules/News/language/lang-yourlang.php
where yourlang is your language like english
(send me more language files)
===============================================================================
Page Numbers for Stories and Topics
-----------------------------------
You can simply overwrite html/modules/News/index.php with index.php provided
OR if you've already changed the file then make these 3 changes:
1. near line 25:
add $pagenum to end of global statement in function theindex()
2. near line 63:
replace this line:
$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 $storynum";
with these lines:
# 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
3. near line 222:
add these lines before the include("footer.php") statement at end of function theindex()
#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 100"; # 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&new_topic=$new_topic&pagenum=$prevpage\">";
echo "<img src=\"$leftarrow\" align=\"absmiddle\" border=\"0\" hspace=\"10\"></a>";
** else {
echo "<a href=\"modules.php?name=News&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&new_topic=$new_topic&pagenum=$i\">$i</a>";
** else {
echo "<a href=\"modules.php?name=News&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&new_topic=$new_topic&pagenum=$nextpage\">";
echo "<img src=\"$rightarrow\" align=\"absmiddle\" border=\"0\" hspace=\"10\"></a>";
** else {
echo "<a href=\"modules.php?name=News&pagenum=$nextpage\">";
echo "<img src=\"$rightarrow\" align=\"absmiddle\" border=\"0\" hspace=\"10\"></a>";
**
**
echo "</center>";
closetable();
**
#END Page Numbers in news and topics
===============================================================================
Page Numbers for Categories
---------------------------
You can simply overwrite html/modules/News/categories.php with categories.php provided
OR if you've changed the file then make these 3 changes:
1. near line 29:
add $pagenum to end of global statement in function theindex()
2. near line 42:
Change this line:
$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 $storynum";
To these lines:
# 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
3. near line 139:
add these lines before the include("footer.php") statement at end of function theindex()
#START Page Numbers
# Uncomment this next line and change 100 to whatever for number of stories in categories for Page Numbers section
#$limitpn = "limit 100"; # 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&file=categories&op=newindex&catid=$catid&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&file=categories&op=newindex&catid=$catid&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&file=categories&op=newindex&catid=$catid&pagenum=$nextpage\">";
echo "<img src=\"$rightarrow\" align=\"absmiddle\" border=\"0\" hspace=\"10\"></a>";
**
echo "</center>";
closetable();
**
#END Page Numbers in categories
===============================================================================
file list:
Page_Numbers/Page_Numbers.txt
Page_Numbers/index.php
Page_Numbers/categories.php
Page_Numbers/language/pagenum-english.txt
Page_Numbers/language/pagenum-norwegian.txt
Page_Numbers/language/pagenum-spanish.txt
Page_Numbers/language/pagenum-turkish.txt
Page_Numbers/language/pagenum-polish.txt
Page_Numbers/language/pagenum-french.txt
Page_Numbers/language/pagenum-german.txt
Page_Numbers/language/pagenum-dutch.txt
![[N]asser](/data/avatars/l/70/70944.jpg?1680380205){kind=avatar}
