vb.org Archive
Page 1 of 14 1 2311 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Forum Home Enhancements - vbTrends 1.1.2 - An Enhanced Statistics Box on Forum Home (https://vborg.vbsupport.ru/showthread.php?t=113390)

hambil 04-18-2006 10:00 PM
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 04-18-2006 10:32 PM
Am I missing a table?
HTML Code:
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 04-18-2006 10:36 PM
Quote:
Originally Posted by 1996 328ti
Am I missing a table?
HTML Code:
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 04-18-2006 10:40 PM
Same error here:

Quote:
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 04-18-2006 10:43 PM
Guess I'll wait for 1.0.1. :)
I do like the concept.

MThornback 04-18-2006 10:55 PM
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 04-18-2006 11:29 PM
Quote:
Originally Posted by hambil
Ummm.. what version of SQL server?
PHP 4.4.2
MySQL Version 4.0.25-standard

hambil 04-18-2006 11:32 PM
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 04-18-2006 11:36 PM
Well...hopefully we're turfing this host soon...cause believe me...its age is showing in more ways than 1 :p

I got the first install too :) go team :p


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 04-18-2006 11:46 PM
its a nice hack

but has a very bad issue
it consmes over 30 query :(

try to improve this hack by reduce database queries


All times are GMT. The time now is 07:52 AM.
Page 1 of 14 1 2311 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01268 seconds
  • Memory Usage 1,744KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_html_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete