I have created a custom script using https://github.com/Contex/XenAPI/wiki/REST-API-Actions . I have also used custom script which will change values of threads and posts to custom timestamp.
1 . UPDATE xf_thread SET post_date = $postdate,last_post_date = $postdate WHERE thread_id = '$thread_id'
2. UPDATE xf_post SET post_date = $postdate WHERE thread_id = '$thread_id'
For Replies to Thread:
1. UPDATE xf_post SET post_date = $postdate WHERE post_id = '$post_id'
Now the problem is each thread is showing up on top of the list even though the posts post_date is of the past (sorting order is by last message). The threads and posts are updated with the past dates.
Also, the threads show up in new posts.
can any one guide me here ?