vRewrite - SEOed URLs for vBulletin

About

vRewrite is an advance but simple system to rewrite vB's URLs. The rewrite system uses preg_match_all and str_replace to rewrite the URLs. It will rewrite any URLs that are dynamic ex: showthread.php?t= to /the-forum/title-of-the-forum-id.html. Why? SEs (Search Engines) rate results based on filename. Not only that, but most SEs give a "boost" to static URLs (what we do here) versus dynamic URLs. vRewrite accomplishes both of this, for all URLs that a search engine (or a guest) will see.

Installation

Please download vRewrite.zip and read install.html for more information on how to install it.

Requirements

vRewrite assumes that you are using Apache with the mod_rewrite module enabled, and running vBulletin 3.5.x. However, if you ask for support here on IIS' module or on vBulletin 3.0.x - I will be more then happy to assist you.

Contributions

I would like to thank Chroder and Cole for assisting me release vRewrite. I could not have released it if it wasn't for them.

I would like to thank the following people/boards for helping beta test vRewrite and making it a better product.

Gaming Ultimate, BP Gaming, NBS Designz Cyclez, Hosting-Talk and Forum University.

Copyright

I've spent many hours working and perfecting vRewrite. The only thing I ask you to do is if you use it, please keep the link back. If you wish to put it in your style instead, simply remove or comment out that line. However, if you use vRewrite you MUST link back. That is the only thing I ask.

Known Issues

There are no known issues with the latest release (1.0).

Support / Issues

If you have any problems or discover a bug please post here in this thread. I have also included my email in the install.html email for one-on-one support. The only thing I ask you is please do not post this email address publicly - it is my personal email.

Changelog

1.5 Release - vRewrite 1.5 has become stable, and all users under 1.5 RC3 and 1.0 need to upgrade. Support for 1.0 will no longer be offered, and you will be told simply to upgrade. Please continue to keep all bug and feature suggestions on the bug tracker at:

http://www.techhelpforum.com/vrewrite

1.1 Release - Several bug fixes, and a few new features. Details here.

03/26/06 - Updated the thread to reflect vRewrite 1.5 Beta links. vRewrite files has NOT changed.

03/11/06 - Updated the thread to take advantage of vB.org's new prefix feature. vRewrite itself has NOT changed.

1.0 Release (02/19/06) - I have released the much awaited 1.0. This is the first stable release of vRewrite. All users now should be safe installing vRewrite. For more information, and how to upgrade, please see here.

1.0 Preview (01/12/06) - I have released a preview version of 1.0. This is the final version before 1.0 is considered stable. I believe everything should work in this new preview, but one bug (see known issues). Please see here for more information and how to upgrade.

01/05/06 - Updated ZIP to include a fix for boards running a table prefix. You do not need to upgrade unless you previously had SQL errors. You can upgrade by importing the product and choose "Allow Overwrite".

Donations

Any donations are very much appreciated! I do this out of my free time and work many hours on it - all for free. Anything to help is always very welcomed

If you use vRewrite, please click Install. This helps you keep track of additional upgrades and shows to me that you care about vRewrite


You may not post vRewrite ZIP or any files contained in the ZIP on any website. You may not also post any support requests/give support on any website other then this one, without my permission. If you do so, you will get a DMCA for copyright infringement. I do not want this spread to pirated users. Please stop piracy and do not share the source outside of this thread and vB.org/com. Thanks.

Support will only be obtained at:
https://vborg.vbsupport.ru/forumdisplay.php?f=182

[newmomsforum]

great hack but my navigation is a little strange now.

Ie. My boards are located at http://sitename.com/forums

For my board navigation though everything works fine but

clicking on the first link takes me back to my site homepage and not my forums index.php

ie Boardname > Forum name > sub forum name

Clicking on the first Boardname link takes me to my sites home page at http://sitename.com and not my forum homepage at http://sitename.com/boards

Any ideas?

Thanks in advance

Claire

[Immortal]

Upgrade to 1.5

[newmomsforum]

I thought this was the latest release?

[Immortal]

It's the latest stable version which is attached. You'll have to search the thread to find the link to the beta

[VTXCafe.com]

Originally Posted by VTXCafe.com

Worked like a charm with v 1.5, thanks...waiting to see what happens now.

Nevermind.

It worked great till yesterday and I started getting database errors, when the index page was being accessed we would get the following database errors:

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT username, userid, threadid
FROM post
WHERE threadid IN (672,765,,826,824,28,764,819,653,807)
AND visible = 1
ORDER BY dateline DESC;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '826,824,28,764,819,653,807)
AND visible = 1
ORDER BY dateline DESC' at line 3
Error Number : 1064
Date : Saturday, April 8th 2006 @ 03:42:30 PM
Script : http://www.vtxcafe.com/forum.php
Referrer : http://www.vtxcafe.com/arcade.php
IP Address :
Username :
Classname : vb_database

As soon as I disabled the script the forum worked fine again. I'll go submit this to the bug tracker.

[Immortal]

Hello Everyone,

I have been noticing a lot of forums that have removed links or made them inactive, in vRewrite. I would like to remind everyone that this is a violation of the license agreement and it will not go unnoticed. If you are one who has done this, I highly suggest you add it back how it originally was.

We will begin to start taking action momentarily if we see a forum that does not have the link(s).

Note: If you have donated $20 and took all the necessary steps to remove all copyrights, then you are allowed to remove the copyright(s). But not many have done this, and none of the forums which I was referring to.

[Immortal]

VTXCafe.com: I'll have him take a look at it for ya.

[Bhuwan]

Originally Posted by VTXCafe.com

Nevermind.

It worked great till yesterday and I started getting database errors, when the index page was being accessed we would get the following database errors:


<B>

Database error in vBulletin 3.5.4:

</B>

Invalid SQL:

SELECT username, userid, threadid
FROM post
WHERE threadid IN (672,765,,826,824,28,764,819,653,807)
AND visible = 1
ORDER BY dateline DESC;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '826,824,28,764,819,653,807)
AND visible = 1
ORDER BY dateline DESC' at line 3
Error Number : 1064
Date : Saturday, April 8th 2006 @ 03:42:30 PM
Script : http://www.vtxcafe.com/forum.php
Referrer : http://www.vtxcafe.com/arcade.php
IP Address :
Username :
Classname : vb_database

As soon as I disabled the script the forum worked fine again. I'll go submit this to the bug tracker.

I am looking @ the XML file and their is no such code that has "ORDER BY DATELINE" in it...my guess is you've got an old XML file....

This is the real file you want, latest and greatest RC3..

https://vborg.vbsupport.ru/showpost....&postcount=924

[Darkwolf]

Hmmm. I need some help. My "Go to Last post" doesn't seems to be working for me...

[Frapegliko]

there is a bug with /showthread.php?goto=lastpost&t=201 Urls they doesnt anymore exist..

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT postid AS postid, post.dateline, t.title as threadtitle, f.title as forumtitle, f.forumid as forumid
FROM vb_post AS post JOIN vb_thread AS t ON(t.threadid=post.threadid) JOIN vb_forum as f ON(f.forumid=t.forumid)
WHERE post.threadid = 201 AND post.visible = 1 AND
postid = (
SELECT MAX(t2.postid) AS postid
FROM vb_post AS t2
WHERE t2.threadid = 201 AND t2.visible = 1
)
LIMIT 1;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT MAX(t2.postid) AS postid
FROM vb_post AS t2

Error Number : 1064
Date : Sunday, April 9th 2006 @ 09:41:01 AM
Script : http://www.domain.com/showthread.php...lastpost&t=201
Referrer :
IP Address : xx.xx.xx.xx
Username : unregistered
Classname : vb_database