XF 2.0 [How to SQL?]Update every threads' first post in node=x with a string

[sbj]

Hey,
I want to save a lot of time.

There is node x. In node x there are 1000+ threads.
I want to update all first posts by inserting a one-liner at the end of the first post. How can I do it?

It is tiresome to update all first posts manually with copy/paste over and over again. Any help is appreciated.

Thanks

 

[S Thomas]

I'd go with a template modification instead.
https://xenforo.com/community/threa...ents-for-xenforo-2.136639/page-5#post-1236378
https://xenforo.com/community/resources/conditional-statements-for-xenforo-2.5795/
#15
You'd need to check for the node id aswell.

 

[sbj]

Wait, with template modifications I can insert messages into posts?

Or are you suggestion I should display that on the templates, but in real it is not saved in the post?

I needed it to be saved in the post.

Any chance doing this without writing a php script and doing it a SQL Update?

 

[S Thomas]

Or are you suggestion I should display that on the templates, but in real it is not saved in the post?

Yea, this.

Saving in the database should be something like this:

UPDATE xf_post SET message = CONCAT(message, "your additional message")
WHERE post_id IN
(
    SELECT first_post_id FROM xf_thread
    WHERE node_id = X
)

Haven't tested it so try it on your dev server first.

 

[sbj]

XF should pay you for helping so many people in so many cases. Thanks. Works (on testserver).