vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   vRewrite - SEOed URLs for vBulletin (https://vborg.vbsupport.ru/showthread.php?t=104484)

Immortal 01-04-2006 10:00 PM

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:

Code:

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

https://vborg.vbsupport.ru/external/2006/03/25.gif 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

Immortal 01-05-2006 01:16 AM

One of the many questions I've been getting is "I'd like to see this live".

I run it personally on my own public board - however I do try and tinker with the latest release on my live board before releasing it to y'all, so I have a few fixes that may not have been available at to the public yet. My board can be seen using it here and a good friend of mine is using a beta as well, and can be seen here.

Known Issues
Was posted here.

vRewrite Development
I posted this concerning vRewrite's development and future release.

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

EricaJoy 01-05-2006 01:21 AM

is this kinda like a free vbseo?

Immortal 01-05-2006 01:22 AM

Quote:

Originally Posted by princessfrozen
is this kinda like a free vbseo?

You could say that, yah. It is free and open-source (not encoded in any way). :)

TyleR 01-05-2006 01:22 AM

Quote:

Originally Posted by princessfrozen
is this kinda like a free vbseo?

Hardly.

Not going to hijack the thread, but it's nothing near the functionality of vBSEO..none-the-less, it looks promising for a free alternative.

derekivey 01-05-2006 01:31 AM

Nice hack Tyler :).

[high]* derekivey clicks install.[/high]

Immortal 01-05-2006 01:31 AM

Quote:

Originally Posted by TyleR
Hardly.

Not going to hijack the thread, but it's nothing near the functionality of vBSEO..none-the-less, it looks promising for a free alternative.

It is still in Beta. So, why not suggest a few features if you don't think it's got anywhere "near the functionality of vBSEO"? ;)

ConqSoft 01-05-2006 01:32 AM

Hasn't Dean C already released an SEO hack here?

Immortal 01-05-2006 01:34 AM

Quote:

Originally Posted by ConqSoft
Hasn't Dean C already released an SEO hack here?

Sure did. I used Dean's for awhile, and I wasn't too fond of it. It did the job of rewriting URLs but that's about all it did. It didn't rewrite majority of URLs. And it did not include the forum for threads (a huge plus for SEO). But, if it wasn't for Dean's I probably wouldn't of released it.

adb22791 01-05-2006 01:35 AM

Quote:

Originally Posted by ConqSoft
Hasn't Dean C already released an SEO hack here?

And your point is.... Dean C's is buggy, doesn't work very well, and if I recall is still a beta itself. There are two warning systems (probably more), yet nobody says anything. Therefore your post really has no merit to it.

Nice hack Tyler.
*Installed*

Daniel 01-05-2006 01:49 AM

Nicely done. Will be installing. :)

Reeve of shinra 01-05-2006 02:05 AM

Its good to see more hacks that the community will benifit from having. ^^

GamerJunk.net 01-05-2006 02:15 AM

I will only install this when you are able to change the member page to read the name of the member rather than the current member=uXXX

derekivey 01-05-2006 02:18 AM

Quote:

Originally Posted by RasMasta
I will only install this when you are able to change the member page to read the name of the member rather than the current member=uXXX

I think it does. Are you sure it's not?

Immortal 01-05-2006 02:19 AM

Quote:

Originally Posted by RasMasta
I will only install this when you are able to change the member page to read the name of the member rather than the current member=uXXX

It should be that way now.


Quote:

u-member-name-id.html
Is the member.php not rewritting for you?

o0oicebergo0o 01-05-2006 02:21 AM

Question

Quote:

Note: If you run your vB on a directory from a subdomain or root ex: http:///www.yoursite.com/forum or http://subdomain.site.com/forum you will need to open up the .htacess file and change Rewrite Base / to Rewrite Base /yourdir
Does that I have to change the file if my board sits at http://www.mysite.com/board
? Becuase I installed this (yes, followed all steps and I know I have mod rewrite) and it killed my board giving it mysql connection errors. Backsteped to remove the mod and it is okay just wondering.

Immortal 01-05-2006 02:29 AM

Quote:

Originally Posted by o0oicebergo0o
Question

Does that I have to change the file if my board sits at http://www.mysite.com/board
Becuase I installed this (yes, followed all steps and I know I have mod rewrite) and it killed my board giving it mysql connection errors. Backsteped to remove the mod and it is okay just wondering.

Yes, but if you did it wrong or anything of the sort, you'll just get 404s when you click on any forum etc. You shouldn't be getting any type of MySQL errors, can you copy and paste the full error you got if you wouldn't mind?

o0oicebergo0o 01-05-2006 02:40 AM

Quote:

Database error in vBulletin :

mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/site/public_html/board/includes/class_core.php on line 273

MySQL Error :
Error Number :
Date : Wednesday, January 4th 2006 @ 10:05:33 PM
Script : http://www.mysite.com/board/forumdisplay.php
Referrer : http://www.mysite.com/board/index.php?
IP Address :
Username :
Classname : vb_database

Quote:

Database error in vBulletin 3.5.0:

Invalid SQL:

INSERT INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass)
VALUES
('059cfyfyt6r6gfhfg2184ce295a', 1550, '84.9.228.49', '6eb870060e006de590b61b847be82a5a', 1136433903, '/board/forumdisplay.php?f=36&page=3&order=desc', 0, 0, 0, 36, 0, 0, 0, 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)', 0);

MySQL Error : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Error Number : 2002
Date : Wednesday, January 4th 2006 @ 10:05:08 PM
Script : http://www.mysite.com/board/forumdis...e=3&order=desc
Referrer : http://www.mysite.com/board/forumdis...e=2&order=desc
IP Address :
Username : User 1
Classname : vb_database

Quote:

Database error in vBulletin 3.5.0:

Invalid SQL:

UPDATE session
SET lastactivity = 1136433907, inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = 'af513ec1f3b59e89ae5668ed2cfa6eb3';

MySQL Error : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Error Number : 2002
Date : Wednesday, January 4th 2006 @ 10:05:08 PM
Script : http://www.mysite.com/board/showthread.php
Referrer :
IP Address :
Username : User 2
Classname : vb_database
Just 3 out of 100 errors which were sent to me via email. I removed it within less then a minute so as you can see everytime someone attempted to access the board an error occured.

GamerJunk.net 01-05-2006 06:20 AM

all the links you put up I checked those sites and they don't have it with the member name. I have not installed this yet.

Do you have any working sites that are showing the member page with the member name rather than the id?

GamerJunk.net 01-05-2006 06:28 AM

Also your issue with the redirect, you didn't post the thread link so we could reply for you

Datacenter1.com 01-05-2006 09:38 AM

Is this hack work with non english (spanish) boards?

Thanks

Guillermo

Cole2026 01-05-2006 09:44 AM

Quote:

Originally Posted by o0oicebergo0o
Just 3 out of 100 errors which were sent to me via email. I removed it within less then a minute so as you can see everytime someone attempted to access the board an error occured.

That is most likely not a problem with this software, but some type of problem with your server directly. What version of MySql and PHP are you running?

michaelbenson 01-05-2006 10:12 AM

Interesting alternative would you mind listing all the URLs which this hack is currently planning to rewrite and in what format they will be in too? Would it be possible to rearrange the URL format so that information such as the threadid is moved to the back of the URL?

Wachtmeister 01-05-2006 10:14 AM

Quote:

Originally Posted by RasMasta
all the links you put up I checked those sites and they don't have it with the member name. I have not installed this yet.

Do you have any working sites that are showing the member page with the member name rather than the id?

http://www.hosting-talk.com/memberlist.php

Snake 01-05-2006 10:23 AM

I'll probably install this tonight but first I'll need a live demonstration of this hack, please.

croportal 01-05-2006 10:32 AM

is this better than DEAN C or??????

i have seen that in this are members rewrite and get daily posts also, but in dean c are not

Snake 01-05-2006 10:41 AM

Why don't you install both hacks and find out yourself? In my opinion, it seems this hack is the best-free SEO product so far.

Yorixz 01-05-2006 10:41 AM

I'd like to see some board that has this installed already ;) I'm also wondering if theres a chance to see this hack becoming compatible with either one of the two xml sitemap generators, but I'm afraid that wont happen too soon.

Snake 01-05-2006 10:47 AM

Just tested and installed the hack on my test board and guess what? I'm facing a mySQL error... :disappointed:

Quote:

Database error in vBulletin 3.5.2:

Invalid SQL:
SELECT userid, username FROM user WHERE username='jmmoore721';

MySQL Error : Table 'mgforums_vb3.user' doesn't exist
Error Number : 1146
Date : Thursday, January 5th 2006 @ 12:45:19 PM
Script : xxx
Referrer : xxx
IP Address : xxx
Username : Aftermath
Classname : vb_database

Lizard King 01-05-2006 10:50 AM

Damn :) I was making myself ready to purchase vbseo and a new alternative just came out. I'll probably wait and see how this works and read the testimonials.

Let me have couple questions by the way ,

Is this working with Non-English boards ?
Is it possible to change rewrite from f-forumname-40.html to forumname/ or any other combination ?
Can we add custom rewrite rules for example , vbadvanced cmps , arcade , geek article and review system ?

If options like these can be turn on instead of purchasing vbseo i can make a good donation for this mod.

Snake 01-05-2006 11:15 AM

I doubt it.
Yes, that's possible by editing the .htaccess of your site.
I believe so, yeah. And I would like to know how do I do that?

Yorixz 01-05-2006 11:18 AM

Can't answer your other questions but "Is this working with Non-English boards ?" -> I bet so, wouldn't know what's different exept for the names of topics/forums? Or do you mean a non-english forum as Hebrew or so?

COBRAws 01-05-2006 12:31 PM

Hope this makes more progress, I dont like the idea of paying more than an owned license of vB to vbSEO and just for 1 year, plus having a text add on every page :S

Gonna install when it comes to final, or close to final.

cclaerhout 01-05-2006 12:37 PM

Can you explain us how to modify the .htaccess file when vB is not at the root.
For example : www.mysite.com/forum

An exemple will be great :)

Cole2026 01-05-2006 02:35 PM

Quote:

Originally Posted by Aftermath
Just tested and installed the hack on my test board and guess what? I'm facing a mySQL error... :disappointed:

Hmm, looks like Tyler forgot to add Table Prefixes. I'm at school right now, so can't do anything, but I'll alert him when I get home.

Datacenter1.com 01-05-2006 05:58 PM

Looks like is working without problems in my spanish board !!!

http://www.webhostingforo.com

Nice hack

Thank you

Snake 01-05-2006 06:13 PM

Quote:

Originally Posted by Cole2026
Hmm, looks like Tyler forgot to add Table Prefixes. I'm at school right now, so can't do anything, but I'll alert him when I get home.

Cool, I'll be waiting for you then.

Immortal 01-05-2006 06:14 PM

Quote:

Originally Posted by Datacenter1.com
Is this hack work with non english (spanish) boards?

It should, but it will strip out some of the non-English characters in the thread/forum titles. But I can't see why it would pose a problem. If someone wants to confirm it works with their board, that'd be fantastic.

For everyone who wants to see a live demo of vRewrite, I've updated my post here to reflect that. Hosting Talk is not ran by myself but a friend of mine - I'm not sure if he has upgraded since yesterday's beta - I'll check and ask.

Quote:

Originally Posted by Aftermath
Just tested and installed the hack on my test board and guess what? I'm facing a mySQL error...

Quote:

Originally Posted by Cole2026
Hmm, looks like Tyler forgot to add Table Prefixes. I'm at school right now, so can't do anything, but I'll alert him when I get home.

Thanks for letting me know. I did indeed forget to add it, sorry. I'll try and release an update very shortly to fix this issue.

Quote:

Originally Posted by Lizard King
Is it possible to change rewrite from f-forumname-40.html to forumname/ or any other combination ?

Not currently, but I do hope to add it very soon.

Quote:

Originally Posted by Lizard King
Can we add custom rewrite rules for example , vbadvanced cmps , arcade , geek article and review system ?

You can do it yourself - I'll try and release a tutorial and intergrate some extra features to help make it easier in the next release (1.0). But, if you want to try and make it easier on yourself, you can always contact the author and ask to release an addon compatible with vRewrite. I'll try and get the tutorial up soon for y'all :)

Quote:

Originally Posted by COBRAws
Hope this makes more progress, I dont like the idea of paying more than an owned license of vB to vbSEO and just for 1 year, plus having a text add on every page :S

Gonna install when it comes to final, or close to final.

I will do my best to help you and others. I'm doing this all for free and with a day job it can be tricky. But I'm hoping that shouldn't cause any issues.

Quote:

Originally Posted by cclaerhout
Can you explain us how to modify the .htaccess file when vB is not at the root.
For example : www.mysite.com/forum

An exemple will be great

Using /forum as an example, your .htaccess file should read:

Code:

RewriteEngine On
RewriteBase /forum
RewriteRule ^f-(.*)-(.*).html forumdisplay.php?f=$2 [L]
RewriteRule ^u-(.*)-(.*).html member.php?u=$2 [L]
RewriteRule ^(.*)-(.*)-newpost.html showthread.php?goto=newpost&t=$2 [L]
RewriteRule ^(.*)/t-(.*)-(.*)-page-(.*).html showthread.php?t=$3&page=$4 [L]
RewriteRule ^(.*)/t-(.*)-(.*).html showthread.php?t=$3 [L]
RewriteRule ^markread.html forumdisplay.php?do=markread [L]
RewriteRule ^(.*)/p-(.*)-(.*).html#(.*) showthread.php?p=$3#post$4 [L]
RewriteRule ^print-(.*)-(.*).html printthread.php?t=$2 [L]
RewriteRule ^sendtofriend-(.*)-(.*).html sendmessage.php?do=sendtofriend&t=$2 [L]
RewriteRule ^search-(.*).html search.php?do=$1 [L]
RewriteRule ^(.*)-(.*)/newthread.php newthread.php?do=newthread&f=$2[L]
RewriteRule ^(.*)/newpostnoquote-(.*).php newreply.php?do=newreply&noquote=1&p=$2[L]
RewriteRule ^(.*)/newpost-(.*).php newreply.php?do=newreply&p=$2[L]
RewriteRule ^p-(.*).html showpost.php?p=$1&postcount=$1 [L]

Thanks everyone for their feedback so far. I'm hoping to make vRewrite much of a success :)

Snake 01-05-2006 06:40 PM

Quote:

Originally Posted by Immortal
Thanks for letting me know. I did indeed forget to add it, sorry. I'll try and release an update very shortly to fix this issue.

Alright, I'm waiting for you. I can't wait to get this hack working on my forums. :devious:

Also can you add the rewrite URLs for member profiles too?

(ie: https://vborg.vbsupport.ru/member.php?u=80490 changes to https://vborg.vbsupport.ru/member/aftermath.html)

That would be sweet!

Immortal 01-05-2006 06:45 PM

Quote:

Originally Posted by Aftermath
Alright, I'm waiting for you. I can't wait to get this hack working on my forums. :devious:

Also can you add the rewrite URLs for member profiles too?

(ie: https://vborg.vbsupport.ru/member.php?u=80490 changes to https://vborg.vbsupport.ru/member/aftermath.html)

That would be sweet!

Should already do that now :)

Ex: http://www.hosting-talk.com/u-test-user-6.html


All times are GMT. The time now is 06:17 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.06605 seconds
  • Memory Usage 1,873KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (27)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete