1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Migration After Effects

Discussion in 'XenForo Development Discussions' started by Pavan, Mar 31, 2015.

  1. Pavan

    Pavan New Member

    Hi All,

    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.
    For Threads
    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 ?

Share This Page