FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » Insert a message into a thread (Can we add a message to the middle of a thread?)
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Insert a message into a thread [message #169261 is a reply to message #169259] Sun, 15 September 2013 07:26 Go to previous messageGo to previous message
naudefj is currently offline  naudefj   
Messages: 3771
Registered: December 2004
Karma:
Senior Member
Administrator
Core Developer
This is an unusual request, but it should be quite easy to do if you update the DB directly.

Possible solution:
* Edit src/msg.php.t
* Change 'ORDER BY id' to 'ORDER BY post_stamp';
* Change 'ORDER BY m.id' to 'ORDER BY m.post_stamp';
* Go the the Theme Manager ACP and recompile your themes.

To change the date of a message:
* UPDATE fud30_msg set post_stamp = ... where id = ....

Date conversion:
SQL> SELECT post_stamp, FROM_UNIXTIME(post_stamp), UNIX_TIMESTAMP('2013-09-15 03:26:41') from fud30_msg where id = 169261;
1379230001	2013-09-15 03:26:41	1379230001

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: How to Delete ALL Unconfirmed Users?
Next Topic: Reset admin password from database
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 02:57:39 GMT 2024

Total time taken to generate the page: 0.05032 seconds