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

[derekivey]

That one is fine, there are a few queries in the plugin. You should have what I posted...

[Immortal]

Thanks Derek....I'll update the plugin shortly. I was thinking of that, but since it was working just fine on my test board - I wasn't sure.

[ryuji]

outright removing the code fixed it... error and code below... :ermm:

Fatal error: Call to a member function on a non-object in /home/linkforc/public_html/forum/includes/functions.php(4320) : eval()'d code on line 139

PHP Code:

#------------------------------
# Replace Last Post User (Forum)
#------------------------------
$found = preg_match_all('#<a href="member\.php\?find=lastposter&amp;f=([0-9]+)"#i', $output, $matches);

if($found)
{
    // Build an array of ID's
    $ids = array();

    for($i = 0; $i < $found; $i++)
    {
        if(is_numeric($matches[1][$i]))
            $ids[] = $matches[1][$i];
    }
    $ids = implode(',', $ids);

    // Go through each
    $res = $vbulletin->db->query_read("SELECT lastposter, forumid FROM " . TABLE_PREFIX . "forum WHERE forumid IN($ids)");

    while($f = $vbulletin->db->fetch_array($res))
    {
        $lp = $f['lastposter'];

        $lpidinfo = $vbulletin->db->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE username='".$db->escape_string($lp)."'");
        $lp = urlize($lpidinfo['username']);
        $lpid = $lpidinfo['userid'];
        $fid = $f['forumid'];

        

        $output = str_replace("<a href=\"member.php?find=lastposter&amp;f=$fid\"", "<a href=\"u-$lp-$lpid.html\"", $output);
    }


}

#------------------------------
# Replace Last Post User (Thread)
#------------------------------
$found = preg_match_all('#<a href="member\.php\?find=lastposter&amp;t=([0-9]+)"#i', $output, $matches);

if($found)
{
    // Build an array of ID's
    $ids = array();

    for($i = 0; $i < $found; $i++)
    {
        if(is_numeric($matches[1][$i]))
            $ids[] = $matches[1][$i];
    }
    $ids = implode(',', $ids);

    // Go through each
    $res = $vbulletin->db->query_read("SELECT lastposter, threadid FROM " . TABLE_PREFIX . "thread WHERE threadid IN($ids)");

    while($f = $vbulletin->db->fetch_array($res))
    {
        $lp = $f['lastposter'];

        $lpidinfo = $vbulletin->db->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE username='".$db->escape_string($lp)."'");
        $lp = urlize($lpidinfo['username']);
        $lpid = $lpidinfo['userid'];
        $tid = $f['threadid'];

        

        $output = str_replace("<a href=\"member.php?find=lastposter&amp;t=$tid\"", "<a href=\"u-$lp-$lpid.html\"", $output);
    }


} 


[derekivey]

Wait, try making it this instead:

PHP Code:

$lpidinfo = $vbulletin->db->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE username='".$vbulletin->db->escape_string($lp)."'"); 


[ryuji]

that did the trick.. but view first unread's kinda broken

http://www.site.com/forum/#post1814

[Immortal]

It didn't do that before?

[ryuji]

it didnt work at all until now.. it seems to be somthing to do with the template edit i did to install it because it does it with it disabled but if i remove the template modifications its fine again ... will it cause any problems just to leave the template modifications out?

removing the SHOWTHREAD modification did the trick with the plugin disabled.. im about to try it with it enabled... is there somthing wrong with my template?

heh.. removing the template modification is bad lol... any ideas on fixing the link?

[Immortal]

I've seen issues where other mods take control of it ex:
title-of-thread-id.html0 I have no idea why it does that, so it may be a template modification or another hack that isn't working together right.

Edit...didn't see your edit. Is it possible for you to PM me a link so I can have a nosey around?

[ryuji]

pm sent

[ajnin]

ok, so i got to the point where the arguments about whos vb seo thingy was bigger... i mean better and i stopped reading so i dont know if what i am going to say was covered or not. my thanks goes out to anyone whom is attempting to better this community. both immortal and dean alike.

- %20 should never be in a url... period

- filenames should never be longer(at max) than 31 charcters. its a mac thing

- does this hack have any way to actually prevent duplicate content being spidered by the search enginges?

and yes from what i have read about this hack is that the queries need to be reduced. but knowing that comes from having seen a vbforum die at about 500 users on at one time using a 512 server. mysql is a memory sucking beast. the less times you call upon the evil the better... period. if i were to install this hack on the 10k unique a day forums that i considered in the first place, it would crash the box or jsut slow everything down to a snails pace. even with the 4 gigs of ram that are now in that server.

it seemed like the dean guy was trying to offer some advice, perhaps he should have done so via pm instead of being a jerk and jsut tellign everyone not to install. that wasnt right.

my two cents... i will be looking back into this from time to time, thanks again for the work, i bet version 5 will be awesome (and most likly paid )