Re-Arrange Messages

Tizwit · Posted: Wed Nov 30, 2005 4:11 am

Is there any way to Re-Arrange the messages that you place in the Messages Administration?

Thanks

Raven · Posted: Wed Nov 30, 2005 5:50 am

Try changing start date. You can use the Messages Control Panel Change start date to today? or directly edit the start date via phpMyAdmin.

Oops. That is for Stories only Smile

. You will need to directly edit the date field via phpMyAdmin.

Tizwit · Posted: Wed Nov 30, 2005 2:46 pm

There is no start date on the Messages. I found one for the Stories but not the messages.

I did swap 2 dates that were located in the control panel but that had no effect on the order of messages.

Raven · Posted: Wed Nov 30, 2005 2:49 pm

Use phpMyAdmin and manually change the date field.

Tizwit · Posted: Wed Nov 30, 2005 3:06 pm

Raven wrote:

Use phpMyAdmin and manually change the date field.

yes I used the phpmyAdmin and no effect.

I swapped the 2nd and the 4th ones dates:

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

It might use the message ID (primary key)... You might try altering that...been a while since I looked at that code.

Tizwit · Posted: Wed Nov 30, 2005 6:42 pm

in the phpmyadmin? if so that was the first thing I try to change to get it reordered

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

OK, so in the mainfile, you'll see this:

Code:

$result2 = $db->sql_query("SELECT mid, content, date, who FROM ".$prefix."_public_messages WHERE mid > '$c_mid' ORDER BY date ASC LIMIT 1");

That means it's using the date - but in ASCENDING order. So, you can either change the ASC to DESC to get the most recent messages first or change the date accordingly in PHPMYADMIN or some other SQL utility.

Tizwit · Posted: Wed Nov 30, 2005 7:08 pm

I will look into this in the morning and see what it says. Thanx

off to work I go now