FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum Development » FUDforum 3.0+ » read_stamp and post_stamp
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
read_stamp and post_stamp [message #167644] Sun, 19 August 2012 22:58 Go to next message
littleking is currently offline  littleking   United States
Messages: 187
Registered: January 2007
Karma: 2
Senior Member
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 74.164.227.106 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

Report message to a moderator

Re: read_stamp and post_stamp [message #167645 is a reply to message #167644] Mon, 20 August 2012 06:48 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Not tested:

DELETE FROM fud30_pmsg WHERE post_stamp > now() - interval 1 year;
DELETE FROM fud30_pmsg WHERE read_stamp > now() - interval 1 year;

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: recent bots joining
Next Topic: forum width
Goto Forum:
  

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

Current Time: Sat Apr 27 22:31:28 GMT 2024

Total time taken to generate the page: 0.02329 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software