Custom field date => sort threads by this date ?

[cakissimo]

(10-24-2014 03:51 PM)ZiNgA BuRgA Wrote:  Unfortunately you'd need a custom script to go through all the threads and check the date and consider what to do with it.
If moderators are setting the time, you might be able to use the delayed moderation feature.

Thank you, i do a daily php cronjob, it work well but....
(thread is automatically moved if dateline is exceeded and goes to trashbin forum)

...but the moved thread is blank (firstpost only..the firstpost contain only custom xthread fields), i can i fix this please ?
When a edit this blank post i see my xthread fields..so xthread data are not loose, just invisible...need to complete this query, i have forget a thing....

This is my query (i use classic mysql query, this php file is not join to mybb pages):

PHP Code:

1 2 3 4 5 6

UPDATE threads LEFT JOIN threadfields_data ON threads.tid=threadfields_data.tid SET threads.fid='61' WHERE threads.fid='8' AND testdate < UNIX_TIMESTAMP()";

---