Codezwiz >> Forums >> Codezwiz PHP Nuke Help >> News Page Number (want the new codezwiz version please)

I didn't forget about you. Will try to look into that tonight. Upload the file you changed but add _bak on the end of the filename so I can see your changes.

thanks Telli

umm I have backed up the hole folder so you can pretty much do and try whatever you want, have no fear

I aimed the username stright to the my_egallery folder. the file displayCategory.php is under the folder public.

heres a page with the current page numbers (ugly

) [ Register or login to view links on this board. ]

Ey Telli,

I tried your pagination mod for my News section, great idea

, but its not working out completely.

Javascript is loaded and 'pagination.php' uploaded to my includes/, and applied the changes to my index.php you posted on page 1.

It is working partially; numbers and drop-down are showing on the bottom-left side of the page but the links of the page nmbrs are wrong.

It looks like they miss the 'News' module name in the link.

I use php-Nuke 7.9 and already noticed that my index.php from the News module differs from the one on page 1, so not sure if the problem is there or in my pagination.php?

Attach the files you edited and I will take a look for you.

Ey Telli,

Thnx for your reply and sorry for the late response from my side

Pagination.php and javascript are unaltered, and my index.php looks as follows;

<?php

/************************************************************************/
/* PHP-NUKE: Web Portal System */
/* =========================== */
/* */
/* Copyright (c) 2005 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 (!defined('MODULE_FILE')) {
die ("You can't access this file directly...");
}

define('INDEX_FILE', true);
require_once("mainfile.php");
$module_name = basename(dirname(__FILE__));
get_lang($module_name);

#Test New Page Numbers - http://www.codezwiz.com/kbview-55-ipb-like-page-numbers-function.html
include('includes/pagination.php');
#END New Page Numbers

function theindex($new_topic="0") {
global $db, $storyhome, $topicname, $topicimage, $topictext, $datetime, $user, $cookie, $nukeurl, $prefix, $multilingual, $currentlang, $articlecomm, $sitename, $user_news, $userinfo, $s_sid;
if (is_user($user)) { getusrinfo($user); }
if ($multilingual == 1) {
   $querylang = "AND (alanguage='$currentlang' OR alanguage='')";
} else {
   $querylang = "";
}
include("header.php");
automated_news();
if (isset($new_topic)) {
$new_topic = intval($new_topic);
} else {
$new_topic = 0;
}
if (isset($userinfo['storynum']) AND $user_news == 1) {
$storynum = $userinfo['storynum'];
} else {
   $storynum = $storyhome;
}
if ($new_topic == 0) {
   $qdb = "WHERE (ihome='0' OR catid='0')";
   $home_msg = "";
} else {
   $qdb = "WHERE topic='$new_topic'";
   $result_a = $db->sql_query("SELECT topictext FROM ".$prefix."_topics WHERE topicid='$new_topic'");
   $row_a = $db->sql_fetchrow($result_a);
   $numrows_a = $db->sql_numrows($result_a);
   $topic_title = filter($row_a['topictext'], "nohtml");
   OpenTable();
   if ($numrows_a == 0) {
      echo "<center><font class=\"title\">$sitename</font><br><br>"._NOINFO4TOPIC."<br><br>[ <a href=\"modules.php?name=News\">"._GOTONEWSINDEX."</a> | <a href=\"modules.php?name=Topics\">"._SELECTNEWTOPIC."</a> ]</center>";
   } else {
      $db->sql_query("UPDATE ".$prefix."_topics SET counter=counter+1");
      echo "<center><font class=\"title\">$sitename: $topic_title</font><br><br>"
      ."<form action=\"modules.php?name=Search\" 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=\"modules.php?name=Topics\">"._SELECTNEWTOPIC."</a> ]</center>";
   }
   CloseTable();
   echo "<br>";
}

#Test New Page Numbers - http://www.codezwiz.com/kbview-55-ipb-like-page-numbers-function.html
$start = (isset($_POST['start']) ? intval($_POST['start']) : (isset($_GET['start']) ? intval($_GET['start']) : 0));
$perpage = '2';
list($num_pages) = $db->sql_fetchrow($db->sql_query("SELECT COUNT(*) FROM ".$prefix."_stories $qdb")); //$qdb is an added variable
#END New Page Numbers

$result = $db->sql_query("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 $start, $perpage"); //Added:LIMIT $start, $perpage
while ($row = $db->sql_fetchrow($result)) {
   $s_sid = intval($row['sid']);
   $catid = intval($row['catid']);
   $aid = filter($row['aid'], "nohtml");
   $title = filter($row['title'], "nohtml");
   $time = $row['time'];
   $hometext = filter($row['hometext']);
   $bodytext = filter($row['bodytext']);
   $comments = intval($row['comments']);
   $counter = intval($row['counter']);
   $topic = intval($row['topic']);
   $informant = filter($row['informant'], "nohtml");
   $notes = filter($row['notes']);
   $acomm = intval($row['acomm']);
   $score = intval($row['score']);
   $ratings = intval($row['ratings']);
   if ($catid > 0) {
      $row2 = $db->sql_fetchrow($db->sql_query("SELECT title FROM ".$prefix."_stories_cat WHERE catid='$catid'"));
      $cattitle = stripslashes(check_html($row2['title'], "nohtml"));
   }
   getTopics($s_sid);
   formatTimestamp($time);
   $subject = filter($subject, "nohtml");
   $introcount = strlen($hometext);
   $fullcount = strlen($bodytext);
   $totalcount = $introcount + $fullcount;
   $c_count = $comments;
   $r_options = "";
   if (isset($userinfo['umode'])) { $r_options .= "&mode=".$userinfo['umode']; }
   if (isset($userinfo['uorder'])) { $r_options .= "&order=".$userinfo['uorder']; }
   if (isset($userinfo['thold'])) { $r_options .= "&thold=".$userinfo['thold']; }
   $story_link = "<a href=\"modules.php?name=News&file=article&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>"; }
   }
   $sid = intval($s_sid);
   if ($catid != 0) {
      $row3 = $db->sql_fetchrow($db->sql_query("SELECT title FROM ".$prefix."_stories_cat WHERE catid='$catid'"));
      $title1 = filter($row3['title'], "nohtml");
      $title = "<a href=\"modules.php?name=News&file=categories&op=newindex&catid=$catid\"><font class=\"storycat\">$title1</font></a>: $title";
      $morelink .= " | <a href=\"modules.php?name=News&file=categories&op=newindex&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);
}

   #Test New Page Numbers - http://www.codezwiz.com/kbview-55-ipb-like-page-numbers-function.html
   $add_url = ($new_topic > 0) ? '&new_topic=' . $new_topic : ''; //is an added variable
   echo pagination('modules.php?name=' . $module_name . $add_url, $num_pages, $perpage, $start);
   #END New Page Numbers

include("footer.php");
}

function rate_article($sid, $score, $random_num="0", $gfx_check) {
global $prefix, $db, $ratecookie, $sitename, $r_options, $sitekey, $gfx_chk, $module_name;
$sid = intval($sid);
$score = intval($score);
$random_num = intval($random_num);
if (isset($random_num)) {
   $datekey = date("F j");
   $rcode = hexdec(md5($_SERVER['HTTP_USER_AGENT'] . $sitekey . $random_num . $datekey));
   $code = substr($rcode, 2, 3);
   if (extension_loaded("gd") AND $code != $gfx_check AND $gfx_chk != 0) {
      mt_srand ((double)microtime()*1000000);
      $maxran = 1000000;
      $random_num = mt_rand(0, $maxran);
      include("header.php");
      title("$sitename: "._ARTICLERATING."");
      OpenTable();
      $row = $db->sql_fetchrow($db->sql_query("SELECT title FROM ".$prefix."_stories WHERE sid='$sid'"));
      $row['title'] = filter($row['title'], "nohtml");
      echo "<center><a href=\"modules.php?name=$module_name&file=article&sid=$sid$r_options\"><b>".$row['title']."</b></a><br>"._ARTICLERATING.": <img src=\"images/articles/stars-$score.gif\" border=\"0\" alt=\"$score/5\" title=\"$score/5\"> ($score/5)<br><br>";
      echo ""._TOFINISHRATINGERROR."<br><br>";
      echo "<form action=\"modules.php?name=$module_name\" method=\"post\">";
      echo ""._SECURITYCODE.":<br><img src='?gfx=gfx_little&random_num=$random_num' border='1' alt='"._SECURITYCODE."' title='"._SECURITYCODE."'><br><br>\n";
      echo ""._TYPESECCODE.":<br><input type=\"text\" NAME=\"gfx_check\" SIZE=\"3\" MAXLENGTH=\"3\"><br>\n";
      echo "<input type=\"hidden\" name=\"random_num\" value=\"$random_num\"><br>\n";
      echo "<input type=\"hidden\" name=\"score\" value=\"$score\"><br>\n";
      echo "<input type=\"hidden\" name=\"sid\" value=\"$sid\">\n";
      echo "<input type=\"hidden\" name=\"op\" value=\"rate_article\">";
      echo "<input type=\"submit\" value=\""._CASTMYVOTE."\"></font></center></form>";
      CloseTable();
      include("footer.php");
      die();
   } else {
      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();
         }
         $ip = $_SERVER['REMOTE_ADDR'];
         $num = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_stories WHERE sid='$sid' AND rating_ip='$ip'"));
         if ($num != 0) {
            Header("Location: modules.php?name=News&op=rate_complete&sid=$sid&rated=1");
            die();
         }
         if (isset($ratecookie)) {
            $rcookie = base64_decode($ratecookie);
            $rcookie = addslashes($rcookie);
            $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");
            die();
         } else {
            $ip = $_SERVER['REMOTE_ADDR'];
            $result = $db->sql_query("update ".$prefix."_stories set score=score+$score, ratings=ratings+1, rating_ip='$ip' where sid='$sid'");
            $info = base64_encode("$rcookie$sid:");
            setcookie("ratecookie","$info",time()+86400);
            update_points(7);
            Header("Location: modules.php?name=News&op=rate_complete&sid=$sid&score=$score");
         }
      } else {
         include("header.php");
         title("$sitename: "._ARTICLERATING."");
         OpenTable();
         echo "<center>"._DIDNTRATE."<br><br>"
         .""._GOBACK."</center>";
         CloseTable();
         include("footer.php");
      }
   }
} else {
   mt_srand ((double)microtime()*1000000);
   $maxran = 1000000;
   $random_num = mt_rand(0, $maxran);
   if (extension_loaded("gd") AND $gfx_chk != 0 ) {
      include("header.php");
      title("$sitename: "._ARTICLERATING."");
      OpenTable();
      $row = $db->sql_fetchrow($db->sql_query("SELECT title FROM ".$prefix."_stories WHERE sid='$sid'"));
      echo "<center><a href=\"modules.php?name=$module_name&file=article&sid=$sid$r_options\"><b>".$row['title']."</b></a><br>"._ARTICLERATING.": <img src=\"images/articles/stars-$score.gif\" border=\"0\" alt=\"$score/5\" title=\"$score/5\"> ($score/5)<br><br>";
      echo ""._TOFINISHRATING."<br><br>";
      echo "<form action=\"modules.php?name=$module_name\" method=\"post\">";
      echo ""._SECURITYCODE.":<br><img src='?gfx=gfx_little&random_num=$random_num' border='1' alt='"._SECURITYCODE."' title='"._SECURITYCODE."'><br><br>\n";
      echo ""._TYPESECCODE.":<br><input type=\"text\" NAME=\"gfx_check\" SIZE=\"3\" MAXLENGTH=\"3\"><br>\n";
      echo "<input type=\"hidden\" name=\"random_num\" value=\"$random_num\"><br>\n";
      echo "<input type=\"hidden\" name=\"score\" value=\"$score\"><br>\n";
      echo "<input type=\"hidden\" name=\"sid\" value=\"$sid\">\n";
      echo "<input type=\"hidden\" name=\"op\" value=\"rate_article\">";
      echo "<input type=\"submit\" value=\""._CASTMYVOTE."\"></font></center></form>";
      CloseTable();
      include("footer.php");
   } else {
      $random_num = "$random_num";
      $gfx_check = "$code";
      Header("Location: modules.php?name=$module_name&op=rate_article&sid=$sid&score=$score&random_num=$random_num");
   }
}
}

function rate_complete($sid, $rated=0, $score) {
global $sitename, $user, $cookie, $module_name, $userinfo;
$sid = intval($sid);
$r_options = "";
if (is_user($user)) {
getusrinfo($user);
   if (isset($userinfo['umode'])) { $r_options .= "&mode=".$userinfo['umode']; }
   if (isset($userinfo['uorder'])) { $r_options .= "&order=".$userinfo['uorder']; }
   if (isset($userinfo['thold'])) { $r_options .= "&thold=".$userinfo['thold']; }
}
include("header.php");
title("$sitename: "._ARTICLERATING."");
OpenTable();
if ($rated == 0) {
   $row = $db->sql_fetchrow($db->sql_query("SELECT title FROM ".$prefix."_stories WHERE sid='$sid'"));
   $row['title'] = filter($row['title'], "nohtml");
   echo "<center><a href=\"modules.php?name=$module_name&file=article&sid=$sid$r_options\"><b>".$row['title']."</b></a><br>"._YOURATEDARTICLE.": <img src=\"images/articles/stars-$score.gif\" border=\"0\" alt=\"$score/5\" title=\"$score/5\"> ($score/5)<br><br>";
   echo "<center>"._THANKSVOTEARTICLE."<br><br>"
   ."[ <a href=\"modules.php?name=$module_name&file=article&sid=$sid$r_options\">"._BACKTOARTICLEPAGE."</a> ]</center>";
} elseif ($rated == 1) {
   echo "<center>"._ALREADYVOTEDARTICLE."<br><br>"
   ."[ <a href=\"modules.php?name=$module_name&file=article&sid=$sid$r_options\">"._BACKTOARTICLEPAGE."</a> ]</center>";
}
CloseTable();
include("footer.php");
}

if (!(isset($new_topic))) { $new_topic = 0; }
if (!(isset($op))) { $op = ""; }
if (!(isset($random_num))) { $random_num = ""; }
if (!(isset($gfx_check))) { $gfx_check = ""; }
if (!(isset($rated))) { $rated = 0; }
if (!(isset($score))) { $score = 0; }

switch ($op) {

default:
theindex($new_topic);
break;

case "rate_article":
rate_article($sid, $score, $random_num, $gfx_check);
break;

case "rate_complete":
rate_complete($sid, $rated, $score);
break;

}

?>

Change this line:

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

Doh

Was just about to post that it had something to do with;

echo pagination('modules.php?name=' . $module_name . $add_url, $num_pages, $perpage, $start);

Okay, its working perfectly now, very great

Originally posted by warren @ Tue Jul 15, 2008 4:16 am:

1 other question though;
Atm the pagination is active per topic from what i've seen. Atm I use several topics and categories, is it possible the pagination just runs through all articles regardless of their category or topic, at least on the homepage (index)?

Aah nevermind, thats not what i want.

I do wonder if its possible to display only 3 stories on the homepage and lets say 5 on all the other pages. Or does that require a lot of rework in the code?

From what i can see there's currently only 1 variable ($perpage) that controls the amount of articles per page, not sure if you could use an 'if else' statement for it and how that would work?

You can use an if statement and if your on the homepage change $perpage to 3 else change it to 5.

Originally posted by Telli @ Thu Jul 17, 2008 11:52 pm:

You can use an if statement and if your on the homepage change $perpage to 3 else change it to 5.

Hmm, is it possible to give an example?

PHP is not my strongest point, and after viewing countless of examples at other tutorial sites i wouldnt know how to refer to the index.php in such a statement.