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

[Bhuwan]

Originally Posted by Danecookie

Yes, i am using that version which is attatched in this thread. And that quick reply and qucik edit problem is occuring on Opera web browser. Also on firefox.

And that logout problem is comming on IE only.

Logout problem I haven't been able to reproduce, so you'll ahv eto help me do so (step-by-step)

I believe the firefox & opera issues should be resolved in 1.5.1 (quick reply in particualar)

[Bhuwan]

Originally Posted by Adyum

I'm using the latest version and having a problem with double sub forums.

Go to my home page ( http://www.lostgurus.com/forums ) and try and click on the new post in either Season 2 or Characters, it will return with a wrong url.

Any fix for this? I wanna use this but this would mess up my forum.

I went to your site and went to the characters forum ( http://www.lostgurus.com/forums/f-characters-29/ ) and then clicked on Today's posts and the URL wasn't rewritten, so I couldnt see the issue

[Bhuwan]

Originally Posted by Adyum

I'm using the latest version and having a problem with double sub forums.

Go to my home page ( http://www.lostgurus.com/forums ) and try and click on the new post in either Season 2 or Characters, it will return with a wrong url.

Any fix for this? I wanna use this but this would mess up my forum.

Oops -- I see it now -- this is an issue that has been solved in 1.5.1 -- a n option is to copy the rewrite for "new" (in your .htaccess) and name it "newpost"

[Adyum]

Not only that but if you go to the index page and click the last post for Characters from there you will get an error message too.

[Bhuwan]

Originally Posted by Adyum

Not only that but if you go to the index page and click the last post for Characters from there you will get an error message too.

Yourt missing an htaccess entry...

[Adyum]

Could you post the .htaccess it is suppost to be becuase I just downloaded it and thats what was in it.

[Bhuwan]

Originally Posted by Adyum

Could you post the .htaccess it is suppost to be becuase I just downloaded it and thats what was in it.

add the following:

RewriteRule ^(.*)/t-(.*)-([0-9]+)-newpost.html showthread.php?t=$3&goto=newpost&%{QUERY_STRING} [L]

[funinthesun]

I've just installed this and when I switch vRewrite on I get this error

Database error in vBulletin 3.5.3:

Invalid SQL:

			SELECT t.lastposter AS username, u.userid, t.threadid
			FROM thread AS t JOIN user AS u ON (u.username=t.lastposter)
			WHERE t.threadid IN (5476,2059,1341,5487,3926,5491,3643,5497,5489,5488,5298,5498,5343,5486,5310,5465)
				AND t.visible = 1;

MySQL Error  : You have an error in your SQL syntax near 'ON (u.username=t.lastposter)
			WHERE t.threadid IN (5476,2059,1341,5487,3926,5' at line 3
Error Number : 1064

Any ideas why?

[Bhuwan]

Originally Posted by funinthesun

I've just installed this and when I switch vRewrite on I get this error

Database error in vBulletin 3.5.3:
 
Invalid SQL:
 
            SELECT t.lastposter AS username, u.userid, t.threadid
            FROM thread AS t JOIN user AS u ON (u.username=t.lastposter)
            WHERE t.threadid IN (5476,2059,1341,5487,3926,5491,3643,5497,5489,5488,5298,5498,5343,5486,5310,5465)
                AND t.visible = 1;
 
MySQL Error  : You have an error in your SQL syntax near 'ON (u.username=t.lastposter)
            WHERE t.threadid IN (5476,2059,1341,5487,3926,5' at line 3
Error Number : 1064

Any ideas why?

Which mysql version are you running?

[Danecookie]

Originally Posted by Bhuwan

Logout problem I haven't been able to reproduce, so you'll ahv eto help me do so (step-by-step)

I believe the firefox & opera issues should be resolved in 1.5.1 (quick reply in particualar)

but i dont know, i am just using the correct version and still having that problem. Can we talk at msn bhuwan?