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

$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]

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]

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.