Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » FUDforum 3.0+ » read_stamp and post_stamp
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
read_stamp and post_stamp [message #167644] Sun, 19 August 2012 18:58 Go to next message
littleking is currently offline  littleking   United States
Messages: 187
Registered: January 2007
Karma: 2
Senior Member
add to buddy list
ignore all messages by this user
can you explain the format of these?

id to_list ouser_id duser_id pdest ip_addr host_name post_stamp read_stamp icon subject attach_cnt foff length ref_msg_id fldr pmsg_opt
8640 bossie255 712 712 898 1300394825 1300394825 Re: turkey mount 0 457 43 R8587 3 65

im trying to find the of fud26_pmsg where the read/post stamp is greater than 1 year ago and delete all of them
Re: read_stamp and post_stamp [message #167645 is a reply to message #167644] Mon, 20 August 2012 02:48 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3624
Registered: December 2004
Karma: 17
Senior Member
Core Developer
remove from buddy list
ignore all messages by this user
Not tested:

DELETE FROM fud30_pmsg WHERE post_stamp > now() - interval 1 year;
DELETE FROM fud30_pmsg WHERE read_stamp > now() - interval 1 year;
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: recent bots joining
Next Topic: forum width
Goto Forum:

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

Current Time: Sat Oct 21 01:06:06 EDT 2017

Total time taken to generate the page: 0.00674 seconds