Board Optimization - headStatz

[hr]value[/hr]

. . . . . . . . Brought to you by

. . . http://www.Scriptasy.com

[hr]value[/hr]

Installation Time: < 5 mins
Product: 1
Files: 1
VB Version: 3.6.X


Description:
I wanted to display the current amount of guests and users online without adding any stressful queries. So basically this mod provides the following variables you can use globally in templates:

$hsz[guests] - shows the current count of guests online
$hsz[gphrase] - is the word guest or guests deturmined by how many guests are online
$hsz[members] - shows the current count of members online
$hsz[mphrase] - is the word member or members deturmined by how many members are online
$hsz[total] - is the total amount of guests and members online
$hsz[totalthreads] - total forum threads
$hsz[totalposts] - total forum posts
$hsz[totalmembers] - total forum members

This does add one query to every page, buts its a harmless query. If you would like to remove the query you can make the following file edit:

FILE: /includes/class_core.php
FIND:

PHP Code:

var $defaultitems = array( 


ADD UNDER:

PHP Code:

        'headstatz', 


now the mod will add zero queries.

Installation Instructions:

1. Install Product
2. Make your own template edits

If you like then [Mark As Installed]

[Nordinho]

I know this is an old plugin, however I do have a use for it...

Anyways, it works fine on 3.82 except for messing up the blog page. With the plugin enabled the main blog page gives the error below

<!--
Database error in vBulletin 3.8.2:

Invalid SQL:

		
			SELECT COUNT(*) AS total,
			FROM_UNIXTIME(dateline - , '%c-%e-%Y') AS period
			FROM blog AS blog
			LEFT JOIN blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)
			WHERE options_guest &amp; 1 AND ~blog.options &amp; 8 AND state IN('visible') AND dateline &gt;= 1237676400 AND dateline &lt; 1240177194
			GROUP BY period;

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 ' '%c-%e-%Y') AS period
			FROM blog AS blog
			LEFT JOIN blog_user AS blog_user ' at line 2
Error Number  : 1064

Anybody an idea??

[Nordinho]

Bumperdibump

edit

Applying the 'save a query' patch solved my problems!