Post Titles

Hey!

When I first started my forum I had the automatic quote of post titles turned off, so only the first post had the bold black title matching the page title.

Soon I realised how to add H tags to these titles and turned them on so all the posts in a thread had the matching title, thus increasing keyword count and on page optimization.

Problem is all the posts done pre turning on have have not changed only new posts default to the new setting.

I have found the newer posts ranking much better than then older ones and need to know if there is any way to edit all the old threads, like a database query I can run.

Many Thanks.

Yikes. It does sound like you're going to need to custom SQL command or mini script. I don't know of anything available out there for this specific purpose.

Yeah I thought I would need either.

For any coders out there name your price and we can talk.

Thanks!

Hello,

you can autofill empty post titles with SQL query like:

Code:

update post p set p.title=(select t.title from thread t where t.threadid=p.threadid) WHERE p.title=''

Note: do not forget to backup your post db table before execution the query.

You Sir are a legend.

Thank you and merry christmas!

Ask and ye shall receive. Oleg rocks!

Ok, so I'm pushing it a bit now...

What if I change the thread title, what SQL query will rewrite all the old post titles to the new one.

Thanks muchly!

If you want to change ALL post titles (not only empty ones) to the thread title, you can remove "WHERE p.title=''" part from the SQL query posted above.

I just did this as well, thanks Oleg!

Thanks again!

I ran the sql query and it worked. The only problem is that it doesn't add the "Re: " in front of the titles. Is there an additional sql query I could run now that would add it?

You can include "Re:" in sql query as well:

Code:

update post p set p.title=concat('Re: ',(select t.title from thread t where t.threadid=p.threadid)) WHERE p.title=''

(same as above, that updates only empty titles)