two simple template mods for vBulletin SEO

Keith Cohen · #16 12-25-2005, 06:57 PM

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

Mike · #17 12-25-2005, 07:09 PM

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.

Keith Cohen · #18 12-25-2005, 07:14 PM

Edit template: showthread_similarthreads

Look for:

Code:

$vbphrase[similar_threads]

Replace with:

Code:

$vbphrase[similar_threads] for: $thread[title]

Mike · #19 12-25-2005, 07:42 PM

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.

Keith Cohen · #20 12-25-2005, 08:48 PM

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

Mike · #21 12-26-2005, 10:03 PM

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...."?

Keith Cohen · #22 12-26-2005, 11:13 PM

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.

Juan Muriente · #23 12-27-2005, 01:14 PM

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.

Oleg Ignatiuk · #24 12-27-2005, 01:28 PM

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']">

<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]" />

</if>

REPLACE WITH:

Quote:

<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]" />

Keith Cohen · #25 12-27-2005, 01:33 PM

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?)

Oleg Ignatiuk · #26 12-27-2005, 01:44 PM

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.

Ashley · #27 12-27-2005, 03:29 PM

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?

Keith Cohen · #28 12-27-2005, 03:31 PM

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 · #29 12-27-2005, 03:39 PM

Also, see my edit to my original query post regarding Threaded and Hybrid modes.

Ashley · #30 12-27-2005, 03:44 PM

As i to only use linear too I will retry

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