Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff
Author Message
Tizwit
Involved
Involved


Joined: Aug 29, 2004
Posts: 324
Location: New Mexico

PostPosted: Wed Nov 30, 2005 4:11 am Reply with quote

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

Thanks

_________________
Brian Only registered users can see links on this board! Get registered or login!
Helping the Children in the NM Children's Hospital 
View user's profile Send private message Visit poster's website
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17077

PostPosted: Wed Nov 30, 2005 5:50 am Reply with quote

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.


Last edited by Raven on Wed Nov 30, 2005 2:50 pm; edited 1 time in total 
View user's profile Send private message
Tizwit
PostPosted: Wed Nov 30, 2005 2:46 pm Reply with quote

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
PostPosted: Wed Nov 30, 2005 2:49 pm Reply with quote

Use phpMyAdmin and manually change the date field.
 
Tizwit
PostPosted: Wed Nov 30, 2005 3:06 pm Reply with quote

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:

Image
 
kguske
Site Admin


Joined: Jun 04, 2004
Posts: 6383

PostPosted: Wed Nov 30, 2005 6:35 pm Reply with quote

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

_________________
I google, therefore I exist...
Only registered users can see links on this board! Get registered or login!
 
View user's profile Send private message
Tizwit
PostPosted: Wed Nov 30, 2005 6:42 pm Reply with quote

in the phpmyadmin? if so that was the first thing I try to change to get it reordered
 
kguske
PostPosted: Wed Nov 30, 2005 6:51 pm Reply with quote

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
PostPosted: Wed Nov 30, 2005 7:08 pm Reply with quote

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

off to work I go now
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©