vBulletin SEO Forums

SEO

vBulletin Search Engine Optimization

Buy vBSEO Now! HACKER SAFE certified sites prevent over 99.9% of hacker crime.
ne nw
New vBSEO Discount Level for Network Builders Meet vBSEO Team in New York (Nov. 3rd & 4th) vBSEO 3.2.0 GOLD Has Landed Success with vBSEO = 600ore Web Visitors + $1400 in a Day! Crawlability Inc. Files for SEO Technology Patent
se sw

two simple template mods for vBulletin SEO

This is a discussion on two simple template mods for vBulletin SEO within the Template Modifications forums, part of the vBulletin SEO Discussion category; For similar threads, set both to YES : AdminCP -> vBulletin Options -> Message Searching Options -> Automatic Similar Thread ...

Go Back   vBulletin SEO Forums > vBulletin SEO Discussion > Template Modifications

Enhancing 80 million pages.

Register FAQ Members List Social Groups Calendar Search Today's Posts Mark Forums Read

Reply

 

LinkBack Thread Tools
  #16  
Old 12-25-2005, 06:57 PM
Keith Cohen's Avatar
vBSEO Staff
vBSEO Total Customer SupportBig Board Administrator
 
Real Name: Keith Cohen
Join Date: Jul 2005
Location: Raleigh, NC USA
Posts: 6,264
Blog Entries: 1
Re: two simple template mods for vBulletin SEO

For similar threads, set both to YES:

AdminCP -> vBulletin Options -> Message Searching Options -> Automatic Similar Thread Search

AdminCP -> vBulletin Options -> Thread Display Options (showthread) -> Show Similar Threads
__________________
Keith Cohen / Crawlability Inc.
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.


My Personal Sites: My Blog | GPS Discussion Forum
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #17  
Old 12-25-2005, 07:09 PM
Senior Member
vBSEO Pre-Release Team
 
Real Name: Michael
Join Date: Oct 2005
Posts: 1,681
Blog Entries: 1
Re: two simple template mods for vBulletin SEO

Quote:
Originally Posted by ConqSoft
For similar threads, set both to YES:

AdminCP -> vBulletin Options -> Message Searching Options -> Automatic Similar Thread Search

AdminCP -> vBulletin Options -> Thread Display Options (showthread) -> Show Similar Threads
I have that done. Here is what I was referring to..
Quote:
Here's another:

Turn on the "similar threads" function. Good SEO and natural keyword inclusion is just one of the reasons to use it. You can also insert the thread title again here. Instead of the standard "Similar Threads" heading, just change it to: "Similar Threads for: title-of-thread".
I am trying to figure out how to get my thread title down there by "similar threads". I know it shouldnt be very difficult, but everywhere I try to insert it, I simply get the word "array" showing up.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #18  
Old 12-25-2005, 07:14 PM
Keith Cohen's Avatar
vBSEO Staff
vBSEO Total Customer SupportBig Board Administrator
 
Real Name: Keith Cohen
Join Date: Jul 2005
Location: Raleigh, NC USA
Posts: 6,264
Blog Entries: 1
Re: two simple template mods for vBulletin SEO

Edit template: showthread_similarthreads

Look for:
Code:
$vbphrase[similar_threads]
Replace with:
Code:
$vbphrase[similar_threads] for: $thread[title]
__________________
Keith Cohen / Crawlability Inc.
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.


My Personal Sites: My Blog | GPS Discussion Forum
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #19  
Old 12-25-2005, 07:42 PM
Senior Member
vBSEO Pre-Release Team
 
Real Name: Michael
Join Date: Oct 2005
Posts: 1,681
Blog Entries: 1
Re: two simple template mods for vBulletin SEO

many thanks. I was in the right area, but I was simply adding $thread.

Oh well, thats an improvement on my knowledge of this stuff from a few months ago. Before, I never would have been able to even find the right template.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #20  
Old 12-25-2005, 08:48 PM
Keith Cohen's Avatar
vBSEO Staff
vBSEO Total Customer SupportBig Board Administrator
 
Real Name: Keith Cohen
Join Date: Jul 2005
Location: Raleigh, NC USA
Posts: 6,264
Blog Entries: 1
Re: two simple template mods for vBulletin SEO

Related to this. Does anyone have any ideas on a query to update all post titles to be "RE: [thread title]" if they don't already have a title?

EDIT: Got it: two simple template mods for vBulletin SEO
__________________
Keith Cohen / Crawlability Inc.
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.


My Personal Sites: My Blog | GPS Discussion Forum

Last edited by Keith Cohen; 12-26-2005 at 11:48 PM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #21  
Old 12-26-2005, 10:03 PM
Senior Member
vBSEO Pre-Release Team
 
Real Name: Michael
Join Date: Oct 2005
Posts: 1,681
Blog Entries: 1
Re: two simple template mods for vBulletin SEO

Quote:
Originally Posted by ConqSoft
Related to this. Does anyone have any ideas on a query to update all post titles to be "RE: [thread title]" if they don't already have a title?
I would like to see that as well.

Also have another question. For threads with multiple pages, would it be beneficial to take the code that says "page 2,3,4,etc...."?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #22  
Old 12-26-2005, 11:13 PM
Keith Cohen's Avatar
vBSEO Staff
vBSEO Total Customer SupportBig Board Administrator
 
Real Name: Keith Cohen
Join Date: Jul 2005
Location: Raleigh, NC USA
Posts: 6,264
Blog Entries: 1
Re: two simple template mods for vBulletin SEO

Ok, I got it.

*** WARNING: USE AT YOUR OWN RISK. MAKE A BACKUP OF YOUR DATABASE FIRST. MAYBE TWO TO BE SAFE. NOT RESPONSIBLE. ***

This worked for me to update all the old post titles to "Re: [thread title]" if they were currently blank. If you have a lot of posts this can take a while to execute. I have about 365k posts and it took about 10 minutes.

The query:
Code:
UPDATE post SET post.title = concat("Re: ",(SELECT thread.title FROM thread WHERE thread.threadid = post.threadid)) WHERE post.title = ""
After thinking about this more, I think this may not work well for sites that use Threaded or Hybrid modes, since the post title will be set to "Re: [thread title]", when it may be in response to a specific post in the thread and that post may have a different title. I haven't investigated this; I'm just theorizing.

I ONLY use linear mode on my site anyway, so it doesn't affect me.
__________________
Keith Cohen / Crawlability Inc.
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.


My Personal Sites: My Blog | GPS Discussion Forum

Last edited by Keith Cohen; 12-27-2005 at 03:39 PM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #23  
Old 12-27-2005, 01:14 PM
Juan Muriente's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Juan Carlos Muriente
Join Date: Jun 2005
Location: Puerto Rico
Posts: 12,697
Blog Entries: 2
Re: two simple template mods for vBulletin SEO

Quote:
Originally Posted by ConqSoft
*** WARNING: USE AT YOUR OWN RISK. MAKE A BACKUP OF YOUR DATABASE FIRST. MAYBE TWO TO BE SAFE. NOT RESPONSIBLE. ***

This worked for me to update all the old post titles to "Re: [thread title]" if they were currently blank. If you have a lot of posts this can take a while to execute. I have about 365k posts and it took about 10 minutes.

The query:
Code:
UPDATE post SET post.title = concat("Re: ",(SELECT thread.title FROM thread WHERE thread.threadid = post.threadid)) WHERE post.title = ""
Great idea! I'll do this soon.
__________________
Juan Muriente / Crawlability Inc.
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #24  
Old 12-27-2005, 01:28 PM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,432
Blog Entries: 1
Re: two simple template mods for vBulletin SEO

Perhaps it is better to implement a template mod instead of changing the database content.

Edit postbit template
FIND:
Quote:
<if condition="$show['messageicon'] OR $post['title']">
<!-- icon and title -->
<div class="smallfont">
<if condition="$show['messageicon']"><img class="inlineimg" src="$post[iconpath]" alt="$post[icontitle]" border="0" /></if>
<if condition="$post['title']"><strong>$post[title]</strong></if>
</div>
<hr size="1" style="color:$stylevar[tborder_bgcolor]" />
<!-- / icon and title -->
</if>
REPLACE WITH:
Quote:
<!-- icon and title -->
<div class="smallfont">
<if condition="$show['messageicon']"><img class="inlineimg" src="$post[iconpath]" alt="$post[icontitle]" border="0" /></if>
<if condition="$post['title']"><strong>$post[title]</strong><else /><strong>Re: $thread[title]</strong></if>
</div>
<hr size="1" style="color:$stylevar[tborder_bgcolor]" />
<!-- / icon and title -->
__________________
Oleg Ignatiuk / Crawlability Inc.
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #25  
Old 12-27-2005, 01:33 PM
Keith Cohen's Avatar
vBSEO Staff
vBSEO Total Customer SupportBig Board Administrator
 
Real Name: Keith Cohen
Join Date: Jul 2005
Location: Raleigh, NC USA
Posts: 6,264
Blog Entries: 1
Re: two simple template mods for vBulletin SEO

Wouldn't that also require additional edits to make it show on the Printable version and the Archive version?

Plus, I think the database method needs to be used to make Threaded and Hybrid modes look correct doesn't it? (Otherwise, wouldn't Jelsoft have used the same method, instead of using additional database space to store the post titles?)
__________________
Keith Cohen / Crawlability Inc.
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.


My Personal Sites: My Blog | GPS Discussion Forum
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #26  
Old 12-27-2005, 01:44 PM
Oleg Ignatiuk's Avatar
vBSEO Staff
vBSEO Total Customer SupportvBSEO Documenter
 
Real Name: Oleg Ignatiuk
Join Date: Jun 2005
Location: Belarus
Posts: 21,432
Blog Entries: 1
Re: two simple template mods for vBulletin SEO

Yes, sure - further template modifications will be required for this.

What I meant is that it will be harder to perforum "undo" or "modify" after the database modification.
__________________
Oleg Ignatiuk / Crawlability Inc.
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #27  
Old 12-27-2005, 03:29 PM
Senior Member
 
Real Name: FAA Zooman
Join Date: Dec 2005
Location: Cumbria, UK
Posts: 200
Re: two simple template mods for vBulletin SEO

Quote:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'hfuk.post' doesn't exist
OK it needs my database prefix in it but where?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #28  
Old 12-27-2005, 03:31 PM
Keith Cohen's Avatar
vBSEO Staff
vBSEO Total Customer SupportBig Board Administrator
 
Real Name: Keith Cohen
Join Date: Jul 2005
Location: Raleigh, NC USA
Posts: 6,264
Blog Entries: 1
Re: two simple template mods for vBulletin SEO

Replace [tableprefix] with your table prefix:
Code:
UPDATE [tableprefix]post SET [tableprefix]post.title = concat("Re: ",(SELECT [tableprefix]thread.title FROM [tableprefix]thread WHERE [tableprefix]thread.threadid = [tableprefix]post.threadid)) WHERE [tableprefix]post.title = ""
__________________
Keith Cohen / Crawlability Inc.
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.


My Personal Sites: My Blog | GPS Discussion Forum
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #29  
Old 12-27-2005, 03:39 PM
Keith Cohen's Avatar
vBSEO Staff
vBSEO Total Customer SupportBig Board Administrator
 
Real Name: Keith Cohen
Join Date: Jul 2005
Location: Raleigh, NC USA
Posts: 6,264
Blog Entries: 1
Re: two simple template mods for vBulletin SEO

Also, see my edit to my original query post regarding Threaded and Hybrid modes.
__________________
Keith Cohen / Crawlability Inc.
vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations

vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD

6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You.


My Personal Sites: My Blog | GPS Discussion Forum
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #30  
Old 12-27-2005, 03:44 PM
Senior Member
 
Real Name: FAA Zooman
Join Date: Dec 2005
Location: Cumbria, UK
Posts: 200
Re: two simple template mods for vBulletin SEO

As i to only use linear too I will retry
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
Who did the template *here*? Are there any other SIMPLE templates available? tza Template Modifications 20 05-28-2006 03:51 PM
SEO, usability and readability.... The unseperable cousins. rob Member Articles 2 11-20-2005 07:40 PM
the archives SEO acers General Discussion 11 07-29-2005 02:18 AM


All times are GMT -4. The time now is 11:31 AM.


Powered by vBulletin Version 3.8.0 Beta 3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.5 ©2008, Crawlability, Inc.