>> Site Map >> Forums >> PHP-Nuke Common Problems & Solutions

Forum module - topics in forum:

PHP-Nuke Common Problems & Solutions - Look Here First For Your Problems And Get Their Solutions. See also <a href="http://phpnuke-uk.net/modules.php?name=PHP-Nuke_HOWTO&page=common-installation-problems.html">this</a> section of the phpnuke howto.

Messages appearing in wrong order

---- The Error

Your messages appear in reverse order when activated from Admin / Messages. Oldest appearing at the top and you want the order to be newest at top.

---- The Reason

This is not an error but design.

---- The Solution

This solution is as provided by BlueLion - Many Thanks

If you want to have the newest on top change as follows:

Open your mainfile.php in root/ and find:

Code: :

function message_box() {
global $bgcolor1, $bgcolor2, $user, $admin, $cookie, $textcolor2, $prefix, $multilingual, $currentlang, $db;
if ($multilingual == 1) {
$querylang = "AND (mlanguage='$currentlang' OR mlanguage='')";
} else {
$querylang = "";
}
$result = $db->sql_query("SELECT mid, title, content, date, expire, view FROM ".$prefix."_message WHERE active='1' $querylang");

and change to:

Code: :

Now the newest message is on top.
If you want this the same in your admin panel open messages.php in root/admin/modules/ :
Find this function:

Code: :

function messages() {
below this function find the line:

Code: :

$result = $db->sql_query("SELECT mid, title, content, date, expire, active, view, mlanguage from " . $prefix . "_message");
change to:

Code: :

$result = $db->sql_query("SELECT mid, title, content, date, expire, active, view, mlanguage from " . $prefix . "_message ORDER BY mid DESC");

---- Still Not Working
If you have found out all these details and are sure they are correct and you are still having problems please post up your specific problem in the Installation Forum and we will try to help

Forum module - topics in forum:

Search from web