Need some help with a simple cron script

[neverstop]

Hey guys,

i have a cron script that moves a thread from one forum to another, and updates the thread timestamp to the current time. The problem is that there is another timestamp for the actual post. Can someone help me modify the following code to update the timestamp on the post as well?

Thanks in advance

PHP Code:

$l = $vbulletin->db->query_first("
    SELECT threads.threadid
    FROM vb_thread AS threads
    WHERE threads.forumid=5
");
$vbulletin->db->query_write("
    UPDATE vb_thread 
    SET forumid=2, dateline=UNIX_TIMESTAMP()
    WHERE threadid=".$l['threadid']
); 


[briansol]

you also need to update the post table

[neverstop]

Originally Posted by briansol

you also need to update the post table

Yes I realize that, but I need help doing it heh. Im not much a programmer, I dont know how to update the post table in that query. Can anyone help a brother out?

Cheers

[Lynne]

Which post are you trying to update the date/time on? Just the first post? If so, you need to grab the "firstpostid" in your first query also (add threads.firstpostid to your select statement). Then you need to add a second write query to update the post table using the "firstpostid" as your "postid".

[neverstop]

Originally Posted by Lynne

Which post are you trying to update the date/time on? Just the first post? If so, you need to grab the "firstpostid" in your first query also (add threads.firstpostid to your select statement). Then you need to add a second write query to update the post table using the "firstpostid" as your "postid".

Thanks Lynne, I got it working thanks to your help.

Cheers

[Marco van Herwaarden]

You can not only change the date/time of the first post. Posts are ordered by timestamp, so if you change the postdate of the first post to a later date, it could become the last post instead of the first.