Results 1 to 12 of 12

Post Titles

This is a discussion on Post Titles within the General Discussion forums, part of the vBulletin SEO Discussion category; Hey! When I first started my forum I had the automatic quote of post titles turned off, so only the ...

  1. #1
    Senior Member Array Dave Hybrid's Avatar
    Real Name
    Dave Hybrid
    Join Date
    Mar 2007
    Location
    UK
    Posts
    400
    Liked
    8 times

    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.

  2. #2
    Senior Member Array
    Real Name
    Joseph Ward
    Join Date
    Jun 2005
    Posts
    23,845
    Liked
    44 times
    Blog Entries
    9
    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.

  3. #3
    Senior Member Array Dave Hybrid's Avatar
    Real Name
    Dave Hybrid
    Join Date
    Mar 2007
    Location
    UK
    Posts
    400
    Liked
    8 times
    Yeah I thought I would need either.

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

    Thanks!

  4. #4
    vBSEO Staff Array Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,818
    Liked
    192 times
    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.
    Oleg Ignatiuk / Crawlability Inc.
    Security bulletin - Patch Level for all supported versions released

    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  5. #5
    Senior Member Array Dave Hybrid's Avatar
    Real Name
    Dave Hybrid
    Join Date
    Mar 2007
    Location
    UK
    Posts
    400
    Liked
    8 times
    You Sir are a legend.

    Thank you and merry christmas!

  6. #6
    Senior Member Array
    Real Name
    Joseph Ward
    Join Date
    Jun 2005
    Posts
    23,845
    Liked
    44 times
    Blog Entries
    9
    Ask and ye shall receive. Oleg rocks!

  7. #7
    Senior Member Array Dave Hybrid's Avatar
    Real Name
    Dave Hybrid
    Join Date
    Mar 2007
    Location
    UK
    Posts
    400
    Liked
    8 times
    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!

  8. #8
    vBSEO Staff Array Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,818
    Liked
    192 times
    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.
    Oleg Ignatiuk / Crawlability Inc.
    Security bulletin - Patch Level for all supported versions released

    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  9. #9
    Senior Member Array curriertech's Avatar
    Real Name
    Josh
    Join Date
    Feb 2006
    Location
    NH
    Posts
    106
    Liked
    0 times
    I just did this as well, thanks Oleg!
    Last edited by curriertech; 12-27-2007 at 04:31 PM.
    -Josh

  10. #10
    Senior Member Array Dave Hybrid's Avatar
    Real Name
    Dave Hybrid
    Join Date
    Mar 2007
    Location
    UK
    Posts
    400
    Liked
    8 times
    Thanks again!

  11. #11
    Junior Member Array
    Real Name
    kaggy
    Join Date
    Aug 2006
    Posts
    4
    Liked
    0 times
    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?

  12. #12
    vBSEO Staff Array Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,818
    Liked
    192 times
    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)
    Oleg Ignatiuk / Crawlability Inc.
    Security bulletin - Patch Level for all supported versions released

    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


Similar Threads

  1. [HOW-TO] Remove the Forum name in Post Titles
    By FireStorM in forum Template Modifications
    Replies: 57
    Last Post: 01-11-2012, 12:23 AM
  2. Forum titles not showing in post
    By optrex in forum Troubleshooting
    Replies: 3
    Last Post: 02-15-2007, 07:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •