Board Optimization - United-Forum CSS Sprites - ludicrous speed - NOW!

tl;dr Makes your forum faster.

Want an easy one-click installation for this addon? . Vote for this jira-entry

Add on currently is in beta stage

When visiting a website, speed is a very important factor not only for users but crawlers as well. Long loading times are a nuisance since your time is basically wasted during the waiting period. Hence, we are trying everything we can in order to speed up our site. One great way to improve loading times is by the use of css sprites. Unfortunately these are not implemented by vBulletin.

We therefore decided to develop our own css-sprite add on for vBulletin boards and want to share this code with the worldwide vBulletin community.

Live demo

The add on is permanently running in our vBulletin board ( > 2.000.000 posts), take a look:
http://www.united-forum.de

The add on will be supported via this thread. If you have any questions, issues, improvements or feedback regarding this add on, please feel free to post a comment or write us a pm at any time. We are happy to discuss

vBulletin performance using css sprites

Our tests are based on version 0.7.0. We used the analytic tools firebug network utility and the googlelabs.com page speed site

on the client side the following parameter were used:
download speed: 5.7 MBit/s
ping: 31ms

css sprites - what are they?

The intention behind css sprites is the bundling of many small graphics into one large graphic in order to decrease the number of required http requests. This shortens the loading times of the given website. In addition, the the accumulated size of all small graphics is higher than the size of the sprite due to reasons of compression.
You can find further information in a great article by Chris Coyier.

What is the gain in using css sprites?

Aside from the technical implementation, the question on how much one actually does gain by using css sprites is of the most interest. Obviously they decrease loading times - but how important are small loading times and what is the impact on vBulletin overall loading times?

A short time ago, Jasper Aguila pointed out that speed is one crucial stickiness factor in his blog on vBulletin.com.

Originally Posted by Jasper Aguila vBulletin Support

The internet has unfortunately contributed to the exponential decrease in attention span for many individuals. That's why this decade is seeing a trend in emerging technologies emphasizing the importance of speed request. It's crucial for your content to be promptly distributed in a timely manner, else bounce rate will increase - making you lose returning visitors. It's also important to note that slow sites may be penalized by search engines.

With better browsers, more powerful processors, and improved technologies constantly releasing each year, it's becoming quite difficult to provide excuses for slow loading pages. Therefore, try optimizing your server for speed. Read up and learn optimization techniques at vBulletin.com's Server Configuration forum.

In addition, the google ranking is influenced by the site speed as well.

Google Webmaster Central Blog

Originally Posted by 09.04.2010 - Google Webmaster Central Blog

You may have heard that here at Google we're obsessed with speed, in our products and on the web. As part of that effort, today we're including a new signal in our search ranking algorithms: site speed. Site speed reflects how quickly a website responds to web requests.

vBseo Webmaster Mert G?k?eimam

CSS sprites is a huge bonus for big boards , any big board owner definately should use it.

Last but not least, not only the user's loading time is reduced, but also does the server load decrease as the server will have to handle a lot less of http requests. This clears available connections and cpu time.

Add on features

In the current released beta version 0.7.2, sprites are available for FORUMHOME and FORUMDISPLAY. Coming up next SHOWTHREAD.

Sprites are created style based for all forum styles and saved in a folder which you can set via the imgdir_sprite stylevar. You have one additional button in the ACP (CSS-Sprites -> Refresh) which automatically creates all sprites, the according css definitions and includes those css definitions in the vBulletin css rollup files.

Installation

First of all, if you didnt want to change the templates manually, install the Template Modification System (TMS). Now proceed with the installation:

• upload the contents of the upload folder into your forum home directory.
• import the add on in the ACP
• upon installation a new stylevar imgdir_sprite will be created. Update this stylevar based on your file structure - default value is the vbulletin sprite directory. Make sure the folder is writable, else the sprites can't be saved!
• create the sprites via the ACP at CSS-Sprite using the Refresh option.
• If you have installed TMS, you are done now. This was an easy gained speed up, not? If you didnt installed TMS and didnt want to do it, proceed with the next point:
• in order to use the sprites, you then will have to edit some templates. The diffs (xou will find it in the do_not_upload folder show which parts you have to delete '<' and which parts to add '>' In addition, on top find the lines in which you will find the respective code.[/b]

[legija]

It just messed up everything, lol.
Uninstalled.

I'm probably too stupid to use it.

[ps2wiz]

Originally Posted by liamwli

I did that multiple times...

I had the same issue and this fixed it:

https://vborg.vbsupport.ru/showpost....&postcount=536

[Skyrider]

Originally Posted by MikaN

You can probably fix this manually.

Edit threadbit - template

It begins with:

<li class="threadbit {vb:raw thread.statusstring}<vb:if condition="$show['paperclip']">....

Add "sprite_statusicon_thread_30" (without quotes) in front of that threadbit string.. so that it looks like this:

<li class="sprite_statusicon_thread_30 threadbit {vb:raw thread.statusstring}<vb:if condition="$show['paperclip']">...

I'm afraid that doesn't work for me, the icons are still vanished/hidden.

[shershen08]

i get the following MySQL error on install:

Database error in vBulletin 4.1.12:

Invalid SQL:
		SELECT t1.templateeditid AS templateeditid_1, t1.varname ,
t1.templateeditid AS templateeditid_1, t1.styleid AS styleid_1 ,
t2.templateeditid AS templateeditid_2, t2.styleid AS styleid_2 
		FROM forumtemplateedit AS t1 
LEFT JOIN forumtemplateedit AS t1 ON (t1.varname=t1.varname AND t1.styleid=-2)
LEFT JOIN forumtemplateedit AS t2 ON (t1.varname=t2.varname AND t2.styleid=5)
		WHERE t1.styleid = -1;

MySQL Error   : Not unique table/alias: 't1'
Error Number  : 1066
Request Date  : Saturday, April 13th 2013 @ 09:13:14 PM
Classname     : vB_Database
MySQL Version : 5.5.27-log

how i can handle this?

[kylek]

Originally Posted by Fabikus

Double click read marker doesn't work with this mod on 4.1.12. Is possible to fix it?

Getting same issue. When United-Forum CSS Sprites is enabled the ability to double click icon to mark forum read does not work.

When disabled it works like it should.

Anyone know how to get it so the double click feature works with CSS Sprites?

[henrique araujo]

Database error in vBulletin 4.2.1:

Invalid SQL:

SELECT t1.templateeditid AS templateeditid_1, t1.varname ,
t1.templateeditid AS templateeditid_1, t1.styleid AS styleid_1 ,
t2.templateeditid AS templateeditid_2, t2.styleid AS styleid_2
FROM templateedit AS t1
LEFT JOIN templateedit AS t1 ON (t1.varname=t1.varname AND t1.styleid=-2)
LEFT JOIN templateedit AS t2 ON (t1.varname=t2.varname AND t2.styleid=2)
WHERE t1.styleid = -1;

MySQL Error : Not unique table/alias: 't1'
Error Number : 1066
Request Date : Thursday, May 2nd 2013 @ 05:43:45 PM
Error Date : Thursday, May 2nd 2013 @ 05:43:45 PM
Script : http://www.mobilemods.com.br/admincp...=productimport
Referrer : http://www.mobilemods.com.br/admincp...?do=productadd
IP Address : 198.***.**.**
Username : **************
Classname : vB_Database
MySQL Version : 5.5.23-55


--------------------


help me.

[fxdigi-cash]

Check this page for the fix!

https://vborg.vbsupport.ru/showthrea...images&page=37
Cheers,

Originally Posted by henrique araujo

Database error in vBulletin 4.2.1:

Invalid SQL:

SELECT t1.templateeditid AS templateeditid_1, t1.varname ,
t1.templateeditid AS templateeditid_1, t1.styleid AS styleid_1 ,
t2.templateeditid AS templateeditid_2, t2.styleid AS styleid_2
FROM templateedit AS t1
LEFT JOIN templateedit AS t1 ON (t1.varname=t1.varname AND t1.styleid=-2)
LEFT JOIN templateedit AS t2 ON (t1.varname=t2.varname AND t2.styleid=2)
WHERE t1.styleid = -1;

MySQL Error : Not unique table/alias: 't1'
Error Number : 1066
Request Date : Thursday, May 2nd 2013 @ 05:43:45 PM
Error Date : Thursday, May 2nd 2013 @ 05:43:45 PM
Script : http://www.mobilemods.com.br/admincp...=productimport
Referrer : http://www.mobilemods.com.br/admincp...?do=productadd
IP Address : 198.***.**.**
Username : **************
Classname : vB_Database
MySQL Version : 5.5.23-55


--------------------


help me.

[henrique araujo]

Originally Posted by fxdigi-cash

Check this page for the fix!

https://vborg.vbsupport.ru/showthrea...images&page=37
Cheers,

thanks my friend, now working.

[Spangle]

At first I thought this was really good, but I have hit a snag.

Since installing this and TMS I have lost the Forum Icons.

I'm using 4.2.1

Style: Breeze

I've disabled this MOD, and the TMS MOD but I still have no forum icons, help please.

EDIT
I uninstalled the TMS and the icons have re-appeared.

CSS MOD still disabled

[pokusek]

This doesn't work with TMS on 4.2, I am getting the same errors as posted above (https://vborg.vbsupport.ru/showpost....&postcount=616).

The link to the page 37 didn't help (I did not find anything useful), any ideas what should I do to fix it?