Learn how to add paging to your nuke News module.

Hire Us!Download Video (2)Comments

I am sure you have seen websites that have the cool 1 2 3 4 5...Next Prev at the bottom of their news module. It's really easy to do and this tutorial will help you. This is simply using a tutorial found on google and applying it to nuke.

Files to edit:
modules/News/index.php(Some older versions of nuke use NukeNews instead of News)

Steps :
The first thing is to find where in the file to edit. We are looking for the main query that displays the news blocks on the front page. This is inside the function theindex and the line of codes look similar to the following.

$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 $storynum");

Above that code we place the first part of our paging codes. I have commented the codes so you know what it does.

if(!isset($start)) { // This variable is set to zero for the first page $start = 0; } $eu = ($start - 0); $this = $eu + $storynum; //Nuke already uses $storynum to calculate the number to show per page so we leave it as is. $back = $eu - $storynum; $next = $eu + $storynum; $num_rows = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_stories $qdb $querylang")); //Get the total amount of stories in the database.

We now need to apply our limits to the actual query. Find back the same main query as below and add the new limit.

Now we add the paging numbers at the bottom 1 2 3 4 Next Prev... At the bottom of the function theindex look for include("footer.php"); and above that place the following.

echo "<br><center>";//Center paging links $showeachside = 10; $eitherside = ($showeachside * $storynum); if($start+1 > $eitherside)print ("<a href='index.php'>[First]</a> .... "); $y =0; $pg=1; for($y=0;$y<$num_rows;$y+=$storynum) { $class=($y==$start)?"pageselected":""; if(($y > ($start - $eitherside)) && ($y < ($start + $eitherside))) { if($y <> $eu){ echo '<a class="'.$class.'" href="'.$thispage'.($y>0?("?start=").$y:"").'">'.$pg.'</a>'; } else{ echo '<b>'.$pg.'</b>'; } } $pg++; } if(($start+$eitherside)<$num_rows)print (" .... "); //Check if it is not the only one page then display the next link if($this < $num_rows) { echo "<a href='index.php?start=$next'>Next</a>";} //Check if its not the last page the displays the back button. if($back >=0) { echo "<a href='index.php?start=$back'>Prev</a>";//We use index.php as the start page } echo "</center>";

That's it! Save and upload, you are done!

Hire Us!Download Video (2)Comments

Related Tutorials

Learn how to add paging to your nuke News module.