Version: 2.1, by superjeff
Developer Last Online: May 2010
Category: Major Additions -
Version: 3.7.x
Rating:
Released: 03-20-2008
Last Update: 03-18-2009
Installs: 633
DB Changes Uses Plugins Auto-Templates
Code Changes Additional Files Translations
No support by the author.
TfSEO 2.1
TfSEO is a powerful and free url rewrite for the vBulletin system: it rewrite forum, thread and post urls.
For me it's very hard to explain well all the feature of this plugin, soo the best way is test it.
How much does it weight on the server?
I have tested on my home server:
TfSEO enabled, heavy:
Code:
[root@hserver ~]# ab -n 100 http://hserver/tfseo_1/main-forum-f2/dsadas-t4
This is ApacheBench, Version 2.0.40-dev <$Revision: 1.146 $> apache-2.0
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Copyright 2006 The Apache Software Foundation, http://www.apache.org/
Benchmarking hserver (be patient).....done
Server Software: Apache/2.2.3
Server Hostname: hserver
Server Port: 80
Document Path: /tfseo_1/main-forum-f2/dsadas-t4
Document Length: 33804 bytes
Concurrency Level: 1
Time taken for tests: 22.177687 seconds
Complete requests: 100
Failed requests: 0
Write errors: 0
Total transferred: 3420400 bytes
HTML transferred: 3380400 bytes
Requests per second: 4.51 [#/sec] (mean)
Time per request: 221.777 [ms] (mean)
Time per request: 221.777 [ms] (mean, across all concurrent requests)
Transfer rate: 150.60 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 0 0.0 0 0
Processing: 220 221 0.7 221 223
Waiting: 209 210 0.8 210 213
Total: 220 221 0.7 221 223
Percentage of the requests served within a certain time (ms)
50% 221
66% 221
75% 222
80% 222
90% 222
95% 222
98% 223
99% 223
100% 223 (longest request)
TfSEO disabled, standart vburl:
Code:
[root@hserver ~]# ab -n 100 http://hserver/tfseo_1/showthread.php?p=4#post4
This is ApacheBench, Version 2.0.40-dev <$Revision: 1.146 $> apache-2.0
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Copyright 2006 The Apache Software Foundation, http://www.apache.org/
Benchmarking hserver (be patient).....done
Server Software: Apache/2.2.3
Server Hostname: hserver
Server Port: 80
Document Path: /tfseo_1/showthread.php?p=4#post4
Document Length: 34010 bytes
Concurrency Level: 1
Time taken for tests: 21.870820 seconds
Complete requests: 100
Failed requests: 0
Write errors: 0
Total transferred: 3441000 bytes
HTML transferred: 3401000 bytes
Requests per second: 4.57 [#/sec] (mean)
Time per request: 218.708 [ms] (mean)
Time per request: 218.708 [ms] (mean, across all concurrent requests)
Transfer rate: 153.63 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 0 0.0 0 0
Processing: 216 218 0.9 218 220
Waiting: 205 207 0.9 208 209
Total: 216 218 0.9 218 220
WARNING: The median and mean for the waiting time are not within a normal deviat ion
These results are probably not that reliable.
Percentage of the requests served within a certain time (ms)
50% 218
66% 218
75% 219
80% 219
90% 219
95% 219
98% 220
99% 220
100% 220 (longest request)
Like you can see product takes about +10ms per request.
Note: vbulletin will have by default a rewrite system from version 4.0 (beta should coming next month, april). I relly suggest you to wait, and not use this product. If the vb's rewrite will be great, i will no more update this product.
Hello Superjeff,
I got a new bug here:
Can not read PMs when turn on the product (Got database error, and everything back to normal when turn it off)
The error notice info
Database error in vBulletin 3.7.0:
Quote:
Invalid SQL:
SELECT forum.tfseo_key
FROM forum AS forum
WHERE forumid =;
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 '' at line 3
Error Number : 1064
Request Date : Sunday, June 29th 2008 @ 08:41:36 AM
Error Date : Sunday, June 29th 2008 @ 08:41:37 AM
Script : http://sdnforum.com/forums/private.p...howpm&pmid=173
Referrer : http://sdnforum.com/forums/private.php
IP Address : 116.21.208.78
Username : Julian
Classname : vB_Database
MySQL Version : 4.1.22-standard
Fixed, i will include this in the next relase:
Go to the AdminCP > Plugin > Edit Plugin. Select "Generate post url" and replace all with:
PHP Code:
//Globals are uncached!
global $vbulletin;
//If is TfSEO enable and post is to rewrite
if ($vbulletin->options['tfseo_enable'] AND $vbulletin->options['tfseo_rewrite'] & $vbulletin->bf_misc_rewrite['post'] AND THIS_SCRIPT != 'private')
{
//Generate url
if ($vbulletin->options['tfseo_type'] == 1)
{
$tfseo['g'] = tfseo_url_post($thread['forumid'], $thread['threadid'], $post['postid']);
} else if ($vbulletin->options['tfseo_type'] == 2)
{
$tfseo['g'] = tfseo_url_post($thread['forumid'], $thread['title'], $thread['threadid'], $post['postid']);
} else if ($vbulletin->options['tfseo_type'] == 3)
{
//Get forum key
$tfseo_key_query = $vbulletin->db->query_read_slave("
SELECT forum.tfseo_key
FROM " . TABLE_PREFIX . "forum AS forum
WHERE forumid = $forum[forumid] ");
$forum[tfseo_key] = mysql_fetch_assoc($tfseo_key_query);
$forum[tfseo_key] = implode($forum[tfseo_key]);
$tfseo['g'] = tfseo_url_post($forum[tfseo_key], $thread['forumid'], $thread['title'], $thread['threadid'], $post['postid']);
}
}