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 jokerz

1.5.1 - Bugs:

htaccess: RewriteRule ^search-(.*).html$ search.php?do=$1 [L]
The requested URL /search-getnew.html/ was not found on this server.
* How do I fix that?

http://www.xxxx.com/members-introduc...title-178.html#post1377 = is it normal to have #post0000? (it's vb default url)

Online.php: Unknown Location things you know, you haven't fix?

incorrect htaccess file
try this

htaccess: RewriteRule ^search-(.*).html/$ search.php?do=$1 [L]

[Bhuwan]

Originally Posted by dazh

I have installed the new version but on some links its missing the url of the website and just putting the .html end

Probably becuase it isnt compatible with other hacks -- i'll fix that if I know exactly which do not work.

[dazh]

It was workinig before I installed the latest version, What info would you need

Thanks

[Bhuwan]

Originally Posted by dazh

It was workinig before I installed the latest version, What info would you need


Thanks

If it is a hack problme, please tell me which hack it is

[funinthesun]

I've just installed the updated version and got this error when I switch vRewrite on

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 (5522,5521,5519,271,5516,5520,4745,5518,5517,337,5497,4735,5514,5478,5515)
				AND t.visible = 1;

MySQL Error  : You have an error in your SQL syntax near 'ON (u.username=t.lastposter)
			WHERE t.threadid IN (5522,5521,5519,271,5516,55' at line 3

[Bhuwan]

Originally Posted by funinthesun

I've just installed the updated version and got this error when I switch vRewrite on

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 (5522,5521,5519,271,5516,5520,4745,5518,5517,337,5497,4735,5514,5478,5515)
                AND t.visible = 1;
 
MySQL Error  : You have an error in your SQL syntax near 'ON (u.username=t.lastposter)
            WHERE t.threadid IN (5522,5521,5519,271,5516,55' at line 3

What version of MYSQL do you have?

[HuangA]

Downloaded it just now, tried to check to see if it fixed the problem about order threads by thread starter and what not, still seems to fail.

Example:
http://www.wiigamingtalk.com/f-off-t...edition-6.html
Try to arrange threads by Thread Starter or Rating, it gives 404

.htaccess (generated by the generator which was downloaded 2 mins ago as well):

RewriteEngine On  	 
RewriteRule ^(.*)/(styleid=(.*))$ showthread.php?&%{QUERY_STRING} [L] 	 
RewriteRule ^(.*)/(showthread\.php)$ showthread.php?&%{QUERY_STRING} [L] 	 
RewriteRule ^(.*)/t-([A-Za-z0-9\-]+)-([0-9]+)-new.html showthread.php?t=$3&goto=newpost&%{QUERY_STRING} [L] 	 
RewriteRule ^(.*)/t-([A-Za-z0-9\-]+)-([0-9]+)-last.html showthread.php?t=$3&goto=lastpost&%{QUERY_STRING} [L] 	 
RewriteRule ^(.*)/t-([A-Za-z0-9\-]+)-([0-9]+)-print.html printthread.php?t=$3&is_vrewrite=yes&%{QUERY_STRING} [L] 	 
RewriteRule ^(.*)/t-([A-Za-z0-9\-]+)-([0-9]+)-post(.*).html showthread.php?p=$4&%{QUERY_STRING} [L] 	 
RewriteRule ^p-([A-Za-z0-9\-]+)-post([0-9]+)/postcount([0-9]+).html showpost.php?p=$2&postcount=$3&is_vrewrite=yes&%{QUERY_STRING} [L] 	 
RewriteRule ^(.*)/t-([A-Za-z0-9\-]+)-([0-9]+)/page([0-9]+).html showthread.php?t=$3&page=$4&is_vrewrite=yes&%{QUERY_STRING} [L] 	 
RewriteRule ^(.*)/t-([A-Za-z0-9\-]+)-([0-9]+).html/(.*)$ showthread.php?t=$3&%{QUERY_STRING}&is_vrewrite=yes [L] 	 
RewriteRule ^(.*)/t-([A-Za-z0-9\-]+)-([0-9]+).html showthread.php?t=$3&is_vrewrite=yes&%{QUERY_STRING} [L] 	 
RewriteRule ^members/([A-Za-z0-9\-]+)-([0-9]+).html member.php?u=$2&is_vrewrite=yes&%{QUERY_STRING} [L] 	 
RewriteRule ^f-([A-Za-z0-9\-]+)-([0-9]+)/page([0-9]+).html(.*)$ forumdisplay.php?f=$2&&page=$3%{QUERY_STRING}&is_vrewrite=yes [L] 	 
RewriteRule ^f-([A-Za-z0-9\-]+)-([0-9]+).html$ forumdisplay.php?f=$2&%{QUERY_STRING}&is_vrewrite=yes [L] 	 
RewriteRule ^search-([A-Za-z0-9\-]+).html/$ search.php?do=$1 [L] 	 
# vRewrite version 1.5 STABLE 	 
# Created by vRewrite htaccess generator v1.0

Another thing, I incorporated the copyright to the vb's default copyright msg, but now the system seem to be auto appending. Is there a way to surpress it from coming up twice?

[Bhuwan]

Originally Posted by HuangA

Downloaded it just now, tried to check to see if it fixed the problem about order threads by thread starter and what not, still seems to fail.

Example:
http://www.wiigamingtalk.com/f-off-t...edition-6.html
Try to arrange threads by Thread Starter or Rating, it gives 404

.htaccess (generated by the generator which was downloaded 2 mins ago as well):

RewriteEngine On       
RewriteRule ^(.*)/(styleid=(.*))$ showthread.php?&%{QUERY_STRING} [L]      
RewriteRule ^(.*)/(showthread\.php)$ showthread.php?&%{QUERY_STRING} [L]      
RewriteRule ^(.*)/t-([A-Za-z0-9\-]+)-([0-9]+)-new.html showthread.php?t=$3&goto=newpost&%{QUERY_STRING} [L]      
RewriteRule ^(.*)/t-([A-Za-z0-9\-]+)-([0-9]+)-last.html showthread.php?t=$3&goto=lastpost&%{QUERY_STRING} [L]      
RewriteRule ^(.*)/t-([A-Za-z0-9\-]+)-([0-9]+)-print.html printthread.php?t=$3&is_vrewrite=yes&%{QUERY_STRING} [L]      
RewriteRule ^(.*)/t-([A-Za-z0-9\-]+)-([0-9]+)-post(.*).html showthread.php?p=$4&%{QUERY_STRING} [L]      
RewriteRule ^p-([A-Za-z0-9\-]+)-post([0-9]+)/postcount([0-9]+).html showpost.php?p=$2&postcount=$3&is_vrewrite=yes&%{QUERY_STRING} [L]      
RewriteRule ^(.*)/t-([A-Za-z0-9\-]+)-([0-9]+)/page([0-9]+).html showthread.php?t=$3&page=$4&is_vrewrite=yes&%{QUERY_STRING} [L]      
RewriteRule ^(.*)/t-([A-Za-z0-9\-]+)-([0-9]+).html/(.*)$ showthread.php?t=$3&%{QUERY_STRING}&is_vrewrite=yes [L]      
RewriteRule ^(.*)/t-([A-Za-z0-9\-]+)-([0-9]+).html showthread.php?t=$3&is_vrewrite=yes&%{QUERY_STRING} [L]      
RewriteRule ^members/([A-Za-z0-9\-]+)-([0-9]+).html member.php?u=$2&is_vrewrite=yes&%{QUERY_STRING} [L]      
RewriteRule ^f-([A-Za-z0-9\-]+)-([0-9]+)/page([0-9]+).html(.*)$ forumdisplay.php?f=$2&&page=$3%{QUERY_STRING}&is_vrewrite=yes [L]      
RewriteRule ^f-([A-Za-z0-9\-]+)-([0-9]+).html$ forumdisplay.php?f=$2&%{QUERY_STRING}&is_vrewrite=yes [L]      
RewriteRule ^search-([A-Za-z0-9\-]+).html/$ search.php?do=$1 [L]      
# vRewrite version 1.5 STABLE      
# Created by vRewrite htaccess generator v1.0

Another thing, I incorporated the copyright to the vb's default copyright msg, but now the system seem to be auto appending. Is there a way to surpress it from coming up twice?

add the following to your htaccess

RewriteRule ^f-([A-Za-z0-9\-]+)-([0-9]+).html/$ forumdisplay.php?f=$2&%{QUERY_STRING}&is_vrewrite=yes [L]

I am not sure what you mean by the copyright info you've given?

[girish.r]

I did try out 1.5.1 but I am still have the problem with WIO and quick reply (and edit post). Is there some thing I need to do after doing the upgrade? I also have the problem with the 'Total members that have visited the forum today' located at the bottom of http://www.abcphp.com/ . Some members name does not link up correctly. Any idea whats happening?

[Bhuwan]

Originally Posted by girish.r

I did try out 1.5.1 but I am still have the problem with WIO and quick reply (and edit post). Is there some thing I need to do after doing the upgrade? I also have the problem with the 'Total members that have visited the forum today' located at the bottom of http://www.abcphp.com/ . Some members name does not link up correctly. Any idea whats happening?

Opera browser?