Sort content module links in alphbetical order

pan · Involved Joined: Jul 25, 2006 Posts: 354

How do I get content to be sorted alphabetically?

ToolBox · Regular Joined: Mar 16, 2005 Posts: 74

one of monolithic stag-flation is content module.
In fact, to expand contents module is to flourish phpnuke sites.
but, only a few concern it, disappointedly.

Anyways, such sort is simply:

Try to follow:

Code:

#
# ------- [ OPEN ] -------
#

<nuke-root>/modules/Content/index.php

#
# ------ [ FIND ] ---------
#

$numrows2 = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_pages WHERE cid!='0' AND active='1'"));

# comments: in list_pages () function

#
# ------ [ INLINE, FIND ] --------
#

cid!='0' AND active='1'

#
# ------- [ AFTER, ADD ] --------
#

DESC ORDER BY `title`

Testing and fixing my handy codes are yours.
I have no localmachine to test, but that MODie codes are enough to sate your code hungry.

pan · Involved Joined: Jul 25, 2006 Posts: 354

That didn't work?

duck · Involved Joined: Jul 03, 2006 Posts: 267

look for the line near that that says $db->sql_fetchrow and make the change there.

jakec · Posted: Thu May 28, 2009 12:30 am

You might want to consider the Content Plus module, because I believe this has it included already along with some other nice features. If you are using RN is should be in the latest package as an addon, or alternatively it can be downloaded here:

Only registered users can see links on this board!
Get registered or login to the forums!

pan · Involved Joined: Jul 25, 2006 Posts: 354

duck wrote:

look for the line near that that says $db->sql_fetchrow and make the change there.

where am i supposed to insert it?

Can someone please make this clear for me?

Code:

}
function list_pages() {
global $prefix, $db, $sitename, $admin, $multilingual, $module_name, $admin_file;
include_once('header.php');
title($sitename . ': ' . _PAGESLIST);
OpenTable();
echo '' . _LISTOFCONTENT . ' ' . $sitename . ':';
$result = $db->sql_query('SELECT * FROM ' . $prefix . '_pages_categories');
$numrows = $db->sql_numrows($result);
$numrows2 = $db->sql_numrows($db->sql_query('SELECT * FROM ' . $prefix . '_pages WHERE cid!=\'0\' AND active=\'1\''));
if ($numrows > 0 AND $numrows2 > 0) {
 echo '' . _CONTENTCATEGORIES . ''
 . '<table border="1" align="center" width="95%">';
 while ($row = $db->sql_fetchrow($result)) {
 $cid = intval($row['cid']);
 $title = check_html($row['title'], 'nohtml');
 $description = check_html($row['description'], '');
 $numrows3 = $db->sql_numrows($db->sql_query('SELECT * FROM ' . $prefix . '_pages WHERE cid=\'' . $cid . '\''));
 if ($numrows3 > 0) {
 echo '<tr><td valign="top"> <a href="modules.php?name=' . $module_name . '&pa=list_pages_categories&cid=' . $cid . '">' . $title . '</a> </td><td align="left">' . $description . '</td></tr>';
 }
 }
 echo '</table>'
 . _NONCLASSCONT . '';

jestrella · Posted: Thu May 28, 2009 7:26 pm

Pan, installing Content Plus willp rovide you with many types of content sorting (by date, title and hits, ascending/descending) along with several other great features, as jakec said if you're using RavenNuke look for it in the addons folder otherwise download it from my site...

Only registered users can see links on this board!
Get registered or login to the forums!

see it in action at my site too...

Only registered users can see links on this board!
Get registered or login to the forums!

duck · Involved Joined: Jul 03, 2006 Posts: 267

pan wrote:

duck wrote:

look for the line near that that says $db->sql_fetchrow and make the change there.

where am i supposed to insert it?

Can someone please make this clear for me?

Code:

}
function list_pages() {
global $prefix, $db, $sitename, $admin, $multilingual, $module_name, $admin_file;
include_once('header.php');
title($sitename . ': ' . _PAGESLIST);
OpenTable();
echo '' . _LISTOFCONTENT . ' ' . $sitename . ':';
$result = $db->sql_query('SELECT * FROM ' . $prefix . '_pages_categories' DESC ORDER BY `title`);
$numrows = $db->sql_numrows($result);
$numrows2 = $db->sql_numrows($db->sql_query('SELECT * FROM ' . $prefix . '_pages WHERE cid!=\'0\' AND active=\'1\''));
if ($numrows > 0 AND $numrows2 > 0) {
 echo '' . _CONTENTCATEGORIES . ''
 . '<table border="1" align="center" width="95%">';
 while ($row = $db->sql_fetchrow($result)) {
 $cid = intval($row['cid']);
 $title = check_html($row['title'], 'nohtml');
 $description = check_html($row['description'], '');
 $numrows3 = $db->sql_numrows($db->sql_query('SELECT * FROM ' . $prefix . '_pages WHERE cid=\'' . $cid . '\''));
 if ($numrows3 > 0) {
 echo '<tr><td valign="top"> <a href="modules.php?name=' . $module_name . '&pa=list_pages_categories&cid=' . $cid . '">' . $title . '</a> </td><td align="left">' . $description . '</td></tr>';
 }
 }
 echo '</table>'
 . _NONCLASSCONT . '';

Look at the 6th Line inside the function that reads $result =

That's where you make the change.

But I agree using Content Plus would likely be a better choice

pan · Involved Joined: Jul 25, 2006 Posts: 354

i don't want content plus, i just wanted it sorted alphabetically

that still isn't working for me

jestrella · Posted: Thu May 28, 2009 10:32 pm

changing the orderby from sql statement to ORDER BY title ASC will do the trick...

pan · Involved Joined: Jul 25, 2006 Posts: 354

Not sure why but that didn't work either.

wtffff

This is my whole file:

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. */
/************************************************************************/
/* Additional security & Abstraction layer conversion */
/* 2003 chatserv */
/* http://www.nukefixes.com -- http://www.nukeresources.com */
/************************************************************************/
/************************************************************************/
/* Additional code clean-up, performance enhancements, and W3C and */
/* XHTML compliance fixes by Raven and Montego. */
/************************************************************************/
if (!defined('MODULE_FILE')) {
die('You can\'t access this file directly...');
}
require_once('mainfile.php');
$module_name = basename(dirname(__FILE__));
get_lang($module_name);
$pagetitle = '- ' . $module_name;
if (!isset($page)) {
$page = '';
}
if (!isset($pa)) {
$pa = '';
}
switch ($pa) {
case 'showpage':
 showpage($pid, $page);
 break;
case 'list_pages_categories':
 list_pages_categories($cid);
 break;
default:
 list_pages();
 break;
}
die();
// Only functions beyond this point
function showpage($pid, $page = 0) {
global $prefix, $db, $sitename, $admin, $module_name;
include_once('header.php');
OpenTable();
$pid = intval($pid);
$mypage = $db->sql_fetchrow($db->sql_query('SELECT * FROM ' . $prefix . '_pages WHERE pid=\'' . $pid . '\''));
$myactive = intval($mypage['active']);
$mytitle = check_html($mypage['title'], 'nohtml');
$mysubtitle = check_html($mypage['subtitle'], 'nohtml');
$mypage_header = check_html($mypage['page_header'], 'nocheck');
$mytext = check_html($mypage['text'], 'nocheck');
$mypage_footer = check_html($mypage['page_footer'], 'nocheck');
$mysignature = check_html($mypage['signature'], 'nocheck');
$mydate = $mypage['date'];
$mycounter = intval($mypage['counter']);
echo '<table border="0" cellspacing="0" cellpadding="10" width="100%"><tr><td>';
if (($myactive == 0) AND (!is_admin($admin))) {
 echo 'Sorry... This page doesn\'t exist.';
} else {
 //montego: number of reads should only be made once the entire content text has been read, right?!
 // $db->sql_query("UPDATE ".$prefix."_pages SET counter=counter+1 WHERE pid='$pid'");
 $date = explode(' ', $mydate);
 echo '' . $mytitle . ''
 . '' . $mysubtitle . '';
 $contentpages = explode('[--pagebreak--]', $mytext);
 $pageno = count($contentpages);
 if (empty($page) || $page < 1) $page = 1;
 if ($page > $pageno) $page = $pageno;
 $arrayelement = (int)$page;
 $arrayelement--;
 if ($pageno > 1) {
 echo '' . _PAGE . ': ' . $page . '/' . $pageno . '';
 }
 if ($page == 1) {
 echo '<div align="justify">' . nl2br($mypage_header) . '</div> ';
 }
 echo '<div align="justify">' . $contentpages[$arrayelement] . '</div> ';
 $next_page = '';
 if ($page < $pageno) {
 $next_pagenumber = $page+1;
 if ($page != 1) {
 $next_page.='- ';
 }
 $next_page.='<a href="modules.php?name=' . $module_name . '&pa=showpage&pid=' . $pid . '&page=' . $next_pagenumber . '">' . _NEXT . ' (' . $next_pagenumber . '/' . $pageno . ')</a> <a href="modules.php?name=' . $module_name . '&pa=showpage&pid=' . $pid . '&page=' . $next_pagenumber . '"><img src="images/right.gif" border="0" alt="' . _NEXT . '" title="' . _NEXT . '" /></a>';
 }
 if ($page == $pageno) {
 echo '<div align="justify">' . nl2br($mypage_footer) . '</div>';
 }
 if ($page <= 1) {
 $previous_page = '';
 } else {
 $previous_pagenumber = $page-1;
 $previous_page = '<a href="modules.php?name=' . $module_name . '&pa=showpage&pid=' . $pid . '&page=' . $previous_pagenumber . '"><img src="images/left.gif" border="0" alt="' . _PREVIOUS . '" title="' . _PREVIOUS . '" /></a> <a href="modules.php?name=' . $module_name . '&pa=showpage&pid=' . $pid . '&page=' . $previous_pagenumber . '">' . _PREVIOUS . ' (' . $previous_pagenumber . '/' . $pageno . ')</a>';
 }
 echo '' . $previous_page . ' ' . $next_page . '';
 if ($page == $pageno) {
 if (!is_admin($admin)) $db->sql_query('UPDATE ' . $prefix . '_pages SET counter=counter+1 WHERE pid=\'' . $pid . '\''); //Added here by montego - also admin should not boost the reads
 echo '' . nl2br($mysignature) . ''
 . '' . _COPYRIGHT . ' ' . $sitename . ' ' . _COPYRIGHT2 . ''
 . '' . _PUBLISHEDON . ': ' . $date[0] . ' (' . $mycounter . ' ' . _READS . ')'
 . '' . _GOBACK . '';
 }
}
echo '</td></tr></table>';
CloseTable();
include_once('footer.php');
}
function list_pages() {
global $prefix, $db, $sitename, $admin, $multilingual, $module_name, $admin_file;
include_once('header.php');
title($sitename . ': ' . _PAGESLIST);
OpenTable();
echo '' . _LISTOFCONTENT . ' ' . $sitename . ':';
$result = $db->sql_query('SELECT * FROM ' . $prefix . '_pages_categories');
$numrows = $db->sql_numrows($result);
$numrows2 = $db->sql_numrows($db->sql_query('SELECT * FROM ' . $prefix . '_pages WHERE cid!=\'0\' AND active=\'1\''));
if ($numrows > 0 AND $numrows2 > 0) {
 echo '' . _CONTENTCATEGORIES . ''
 . '<table border="1" align="center" width="95%">';
 while ($row = $db->sql_fetchrow($result)) {
 $cid = intval($row['cid']);
 $title = check_html($row['title'], 'nohtml');
 $description = check_html($row['description'], '');
 $numrows3 = $db->sql_numrows($db->sql_query('SELECT * FROM ' . $prefix . '_pages WHERE cid=\'' . $cid . '\''));
 if ($numrows3 > 0) {
 echo '<tr><td valign="top"> <a href="modules.php?name=' . $module_name . '&pa=list_pages_categories&cid=' . $cid . '">' . $title . '</a> </td><td align="left">' . $description . '</td></tr>';
 }
 }
 echo '</table>'
 . _NONCLASSCONT . '';
}
echo '';
$result4 = $db->sql_query('SELECT pid, title, subtitle, clanguage FROM ' . $prefix . '_pages WHERE active=\'1\' AND cid=\'0\' ORDER BY date');
while ($row4 = $db->sql_fetchrow($result4)) {
 $pid = intval($row4['pid']);
 $title = stripslashes(check_html($row4['title'], 'nohtml'));
 $subtitle = stripslashes(check_html($row4['subtitle'], 'nohtml'));
 $clanguage = $row4['clanguage'];
 if ($multilingual == 1) {
 $the_lang = '<img src="images/language/flag-' . $clanguage . '.png" hspace="3" border="0" height="10" width="20" alt="" />';
 } else {
 $the_lang = '';
 }
 if (!empty($subtitle)) {
 $subtitle = ' (' . $subtitle . ')';
 } else {
 $subtitle = '';
 }
 if (is_admin($admin)) {
 echo '<big>·</big> ' . $the_lang . ' <a href="modules.php?name=' . $module_name . '&pa=showpage&pid=' . $pid . '">' . $title . '</a> ' . $subtitle . ' [ <a href="' . $admin_file . '.php?op=content_edit&pid=' . $pid . '">' . _EDIT . '</a> | <a href="' . $admin_file . '.php?op=content_change_status&pid=' . $pid . '&active=1">' . _DEACTIVATE . '</a> | <a href="' . $admin_file . '.php?op=content_delete&pid=' . $pid . '">' . _DELETE . '</a> ] ';
 } else {
 echo '<big>·</big> ' . $the_lang . ' <a href="modules.php?name=' . $module_name . '&pa=showpage&pid=' . $pid . '">' . $title . '</a> ' . $subtitle . ' ';
 }
}
echo '';
if (is_admin($admin)) {
 $result5 = $db->sql_query('SELECT pid, cid, title, subtitle, clanguage FROM ' . $prefix . '_pages WHERE active=\'0\' ORDER BY date');
 echo '' . _YOURADMINLIST . '';
 while ($row5 = $db->sql_fetchrow($result5)) {
 $pid = intval($row5['pid']);
 $cid = intval($row5['cid']);
 $title = stripslashes(check_html($row5['title'], 'nohtml'));
 $subtitle = stripslashes(check_html($row5['subtitle'], 'nohtml'));
 $clanguage = $row5['clanguage'];
 if ($multilingual == 1) {
 $the_lang = '<img src="images/language/flag-' . $clanguage . '.png" hspace="3" border="0" height="10" width="20" alt="" />';
 } else {
 $the_lang = '';
 }
 if (!empty($subtitle)) {
 $subtitle = ' (' . $subtitle . ') ';
 } else {
 $subtitle = ' ';
 }
 echo '<big>·</big> ' . $the_lang . ' <a href="modules.php?name=' . $module_name . '&pa=showpage&pid=' . $pid . '">' . $title . '</a> ' . $subtitle . ' [ <a href="' . $admin_file . '.php?op=content_edit&pid=' . $pid . '">' . _EDIT . '</a> | <a href="' . $admin_file . '.php?op=content_change_status&pid=' . $pid . '&active=0">' . _ACTIVATE . '</a> | <a href="' . $admin_file . '.php?op=content_delete&pid=' . $pid . '">' . _DELETE . '</a> ] ';
 }
 echo '';
}
CloseTable();
include_once('footer.php');
}
function list_pages_categories($cid) {
global $prefix, $db, $sitename, $admin, $multilingual, $module_name, $admin_file;
include_once('header.php');
title($sitename . ': ' . _PAGESLIST);
OpenTable();
echo '' . _LISTOFCONTENT . ' ' . $sitename . ':';
$cid = intval($cid);
$result = $db->sql_query('SELECT pid, title, subtitle, clanguage FROM ' . $prefix . '_pages WHERE active=\'1\' AND cid=\'' . $cid . '\' ORDER BY `title` ASC');
echo '';
while ($row = $db->sql_fetchrow($result)) {
 $pid = intval($row['pid']);
 $title = check_html($row['title'], 'nohtml');
 $subtitle = check_html($row['subtitle'], 'nohtml');
 $clanguage = $row['clanguage'];
 if ($multilingual == 1) {
 $the_lang = '<img src="images/language/flag-' . $clanguage . '.png" hspace="3" border="0" height="10" width="20" alt="" />';
 } else {
 $the_lang = '';
 }
 if (!empty($subtitle)) {
 $subtitle = ' (' . $subtitle . ')';
 } else {
 $subtitle = '';
 }
 if (is_admin($admin)) {
 echo '<big>·</big> ' . $the_lang . ' <a href="modules.php?name=' . $module_name . '&pa=showpage&pid=' . $pid . '">' . $title . '</a> '
 . $subtitle . ' [ <a href="' . $admin_file . '.php?op=content_edit&pid=' . $pid . '">'
 . _EDIT . '</a> | <a href="' . $admin_file . '.php?op=content_change_status&pid=' . $pid . '&active=1">'
 . _DEACTIVATE . '</a> | <a href="' . $admin_file . '.php?op=content_delete&pid=' . $pid . '">'
 . _DELETE . '</a> ] ';
 } else {
 echo '<big>·</big> ' . $the_lang . ' <a href="modules.php?name=' . $module_name . '&pa=showpage&pid=' . $pid . '">' . $title . '</a> ' . $subtitle . ' ';
 }
}
echo '';
if (is_admin($admin)) {
 $result2 = $db->sql_query('SELECT pid, title, subtitle, clanguage FROM ' . $prefix . '_pages WHERE active=\'0\' AND cid=\'' . $cid . '\' ORDER BY date');
 echo '' . _YOURADMINLIST . '';
 while ($row2 = $db->sql_fetchrow($result2)) {
 $pid = intval($row2['pid']);
 $title = stripslashes(check_html($row2['title'], 'nohtml'));
 $subtitle = stripslashes(check_html($row2['subtitle'], 'nohtml'));
 $clanguage = $row2['clanguage'];
 if ($multilingual == 1) {
 $the_lang = '<img src="images/language/flag-' . $clanguage . '.png" hspace="3" border="0" height="10" width="20" alt="" />';
 } else {
 $the_lang = '';
 }
 if (!empty($subtitle)) {
 $subtitle = ' (' . $subtitle . ') ';
 } else {
 $subtitle = ' ';
 }
 echo '<big>·</big> ' . $the_lang . ' <a href="modules.php?name=' . $module_name . '&pa=showpage&pid=' . $pid . '">' . $title . '</a> '
 . $subtitle . ' [ <a href="' . $admin_file . '.php?op=content_edit&pid=' . $pid . '">'
 . _EDIT . '</a> | <a href="' . $admin_file . '.php?op=content_change_status&pid=' . $pid . '&active=0">'
 . _ACTIVATE . '</a> | <a href="' . $admin_file . '.php?op=content_delete&pid=' . $pid . '">'
 . _DELETE . '</a> ] ';
 }
 echo '';
}
echo '' . _GOBACK . '';
CloseTable();
include_once('footer.php');
}
?>

jakec · Posted: Fri May 29, 2009 12:12 am

bluerace wrote:

Pan, so sorry, I don't want to reply in here any longer for this issue. That's why I posted it in the site.

If we keep talking in here, then it will look like "personal forum."

bluerace, sorry what do you mean by this? Surely it makes sense to finish providing help here so it is easier for people to find it in the future?

pan · Involved Joined: Jul 25, 2006 Posts: 354

I've tried everything everyone has suggested but nothing has worked...

???

duck · Involved Joined: Jul 03, 2006 Posts: 267

Have you cleared your Cache after making the changes?

Raven · Posted: Fri May 29, 2009 6:31 am

bluerace wrote:

Pan, so sorry, I don't want to reply in here any longer for this issue. That's why I posted it in the site.

If we keep talking in here, then it will look like "personal forum."

Bluerace,

While we appreciate your willingness to help in our forums, when someone posts a question in these forums and the conversation is being dealt with in these forums then these forums are the proper place for all conversations unless the user decides to end it. Directing the conversation to a different site, especially when it is apparent that you just added it to your site based on this user's question in these forums, is not proper netiquette Wink

. I have removed your original posts. Hopefully this was just a mistake on your part and we need not have any other issues Smile

.

pan · Involved Joined: Jul 25, 2006 Posts: 354

duck wrote:

Have you cleared your Cache after making the changes?

yes, i did this with everything everyone has told me to try

Still it doesn't work. Now I can't try what bluerace said because raven deleted it!!!

jestrella · Posted: Fri May 29, 2009 8:33 pm

mmmmmmmmmmmmm, help to help you

the problem is that the content you got at your site is uncategorized

find this line withing list_pages function...

Code:

$result4 = $db->sql_query('SELECT pid, title, subtitle, clanguage FROM ' . $prefix . '_pages WHERE active=\'1\' AND cid=\'0\' ORDER BY date');

replace it with...

Code:

$result4 = $db->sql_query('SELECT pid, title, subtitle, clanguage FROM ' . $prefix . '_pages WHERE active=\'1\' AND cid=\'0\' ORDER BY title ASC');

pan · Involved Joined: Jul 25, 2006 Posts: 354

YAY!

THAT FIXED IT!!

Woo hoo thanks again everyone!

jakec · Posted: Sat May 30, 2009 1:30 am

Nice one jestrella.

RavensScripts

Raven · Posted: Sat May 30, 2009 7:15 am

Pan wrote:

Now I can't try what bluerace said because raven deleted it!!!

I had good reason. Apology accepted Wink