Forum Home Enhancements - vbTrends 1.1.2 - An Enhanced Statistics Box on Forum Home

Keywords: Statistics, New members, joins, trends, Forum Home, threads, posts

Description:
Enhances the "YourBBS" Statistics box on the forum home to show trends of posts, threads and new users vs. the overall history of the board. Also allows you to display more than one "newest member".

Version 1.1.2:

1. Added admincp menu to reset cached counters.
2. Fixed a couple of divide by zero errors that occurred when your board had no history (was less than a month old).
3. Fixed so templates are now cached.

Version 1.1.1:

1. Fixed calculation of statistics - should definately be correct now

Version 1.1.0:

1. Fully phrased.
2. Uses templates now so look and feel can be customized
3. Fixed bug so output is valid xhtml 1.0.

Version 1.0.0:

1. Turn on/off in admincp
2. Offers the option to auto replace in templates, or to manually edit templates.
3. Allows more than one 'newest user' to be display.
4. Shows trends for posts, threads and new users - this month vs. the boards average.

Install

1. Download the vbTrends_1.0.0.zip.
2. Unzip and follow instructions in install.html.

[steven s]

Am I missing a table?

Database error in vBulletin 3.5.4:

Invalid SQL:

			SELECT AVG(MonthlyPostCount) AS 'PostCountAvg' 
			FROM 
			(
				SELECT count(*) AS 'MonthlyPostCount' 
				FROM post 
				WHERE dateline < UNIX_TIMESTAMP(NOW()) - DAYOFMONTH(NOW()) * 86400
				GROUP BY YEAR(FROM_UNIXTIME(dateline)), MONTH(FROM_UNIXTIME(dateline))
			)
			AS posts;

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 'SELECT count(*) AS 'MonthlyPostCount' 
				FROM post 
				WHE
Error Number : 1064

[hambil]

Originally Posted by 1996 328ti

Am I missing a table?

Database error in vBulletin 3.5.4:

Invalid SQL:

            SELECT AVG(MonthlyPostCount) AS 'PostCountAvg' 
            FROM 
            (
                SELECT count(*) AS 'MonthlyPostCount' 
                FROM post 
                WHERE dateline < UNIX_TIMESTAMP(NOW()) - DAYOFMONTH(NOW()) * 86400
                GROUP BY YEAR(FROM_UNIXTIME(dateline)), MONTH(FROM_UNIXTIME(dateline))
            )
            AS posts;

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 'SELECT count(*) AS 'MonthlyPostCount' 
                FROM post 
                WHE
Error Number : 1064

Ummm.. what version of SQL server?

[MThornback]

Same error here:

Invalid SQL:

SELECT AVG(MonthlyPostCount) AS 'PostCountAvg'
FROM
(
SELECT count(*) AS 'MonthlyPostCount'
FROM vb3_post
WHERE dateline < UNIX_TIMESTAMP(NOW()) - DAYOFMONTH(NOW()) * 86400
GROUP BY YEAR(FROM_UNIXTIME(dateline)), MONTH(FROM_UNIXTIME(dateline))
)
AS posts;

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 'SELECT count(*) AS 'MonthlyPostCount'
FROM vb3_post

Error Number : 1064

SQL VEr #: 4.0.16

[steven s]

Guess I'll wait for 1.0.1.
I do like the concept.

[MThornback]

I fixed it up so that there is an error on line 60...thats as far as I can get it fixed so far....i'll keep picking...and see if I can help

[steven s]

Originally Posted by hambil

Ummm.. what version of SQL server?

PHP 4.4.2
MySQL Version 4.0.25-standard

[hambil]

Subqueries aren't supported until version 4.1.
I'll see what I can do, but dudes you're MySQL is really showing it's age.

[MThornback]

Well...hopefully we're turfing this host soon...cause believe me...its age is showing in more ways than 1

I got the first install too go team


Edit:
Fatal error: Call to a member function on a non-object in /forum/index.php(485) : eval()'d code on line 60

thats where I am....

[Omranic]

its a nice hack

but has a very bad issue
it consmes over 30 query

try to improve this hack by reduce database queries