[bridge2heyday]

Originally Posted by webmaster74

As the mod does NOT offer to affect all posts or a group of posts automatically and requires that you manually enter [LOCK] and [/LOCK] before and after content that you wish to hide till click in every single post, I am trying to find a way to concatenate the pagetext in post in order to add the LOCK tag to every FIRST post of every topic.

I would appreciate your help fixing this one line.

UPDATE post SET pagetext =CONCAT('[lock]', pagetext,'[/lock]') WHERE postid =(Select firstpostid from dbname_vb.thread) ;

But when I try the substatement,
SELECT post WHERE postid =(Select firstpostid from dbname_vb.thread)
I get :
#1242 - Subquery returns more than 1 row
it must look in the thread table, where there are thousands of rows...

Please help

This is strongly not recommended .. there is an update this week that will allow you to automatically lock all threads in selected forums .. but it will only lock threads .. not posts .. are you sure you want to lock posts ?