vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Statistics Modifications - vB Weekly Stats (https://vborg.vbsupport.ru/showthread.php?t=132061)

itsblack 04-22-2007 02:39 AM

Hi, I got these errors, anyone can help?
PHP Code:

Warningmysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 84

Warning
mysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 95

Warning
mysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 106

Warning
mysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 146

Warning
mysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 158

Warning
mysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 169

Warning
mysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 180

Warning
mysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 189

Warning
mysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 199

Warning
mysql_num_rows(): supplied argument is not a valid MySQL result resource in \weeklystats.php on line 208 

meanwhile there are also no results to display except "Most Viewed Thread" and "Most Replied To Thread".

z0diac 05-04-2007 01:40 PM

I've never upgraded a plugin/product before, just done fresh installs.

Do I need to remove the old one through the Product/Plugin menu in vB?
Or just re-install using the Product/Plug menu?
Or I just copy over the old script files with the new ones?

Sorry for the newbie question but I don't want to mess up my current config.

iorkara 05-04-2007 04:23 PM

Thank You This lookin awesome

z0diac 05-12-2007 12:04 PM

DOes anyone know how to do an upgrade??? I"ve never done one before. Do I re-install using the vB installer? Do I just copy over the files in the o/s ?? Do I uninstall and re-install?? Anyone???

Mrdby 05-12-2007 12:19 PM

Quote:

Originally Posted by z0diac (Post 1246167)
DOes anyone know how to do an upgrade??? I"ve never done one before. Do I re-install using the vB installer? Do I just copy over the files in the o/s ?? Do I uninstall and re-install?? Anyone???

this hack? just over write it.

Hornstar 05-31-2007 07:21 AM

This has come along nicely. finally installed it today. nice.

YabbaDabba 06-09-2007 11:25 PM

PROBLEMS

1 - Stats Table Title Bar

This Week: Current Week Stats - 5 Days Total
Last Week: Current Week Stats - 11 Days Total
2 Weeks Ago: Current Week Stats - 11 Days Total

:confused: Shouldn't it be something like:

This Week: Current Week - 5 Days Total
Last Week: Last Week - 7 Days Total
2 Weeks Ago: 2 Weeks Ago - 7 Days Total

I see the same issue on your own site. If a basic number is wrong, the confidence in the reported stats rapidly approaches zero.

2 - Bad Stats

I do not understand the numbers that are being reported at all.
We consistently have about 30K posts per week.

For example, in ACP > Statistics I see post counts for the last 3 weeks of:
Week 22 (June 2007) 27296 (partial)
Week 21 (June 2007) 28326
Week 20 (May 2007) 29352

However, your numbers for the same period are:
26835
25114
83889 (yeah, 83K. Is this a 3 week Cumulative Total?)

Similarly for threads, ACP reports:
Week 22 (June 2007) 1523
Week 21 (June 2007) 1516
Week 20 (May 2007) 1629

And your numbers are:
1442
1275
4417 (again, maybe a 3 week cumulative total?)

So there are really 2 issues here:
  1. Your numbers for "Two Weeks Ago" are just plain wrong
  2. Your numbers don't match vB reports

YabbaDabba 06-09-2007 11:28 PM

SUGGESTED CLEANUPS

1 - Stat Description Cleanup

Number of Threads This Week:
Number of Posts This Week:
Most Viewed Thread Created This Week:
Most Replied To Thread Created This Week:
Number of Registrations This Week:
Number of Bans This Week:
Number of Infractions This Week:
Number of User Promotions This Week:
Number of Active Users This Week: <== based on how I'm interpreting your query
Number of Attachments Uploaded This Week:
Number of Private Messages This Week:
Number of Poll Votes This Week:

Your descriptions and bolding are very inconsistent. The purpose of the report is to convey information, not confusion.


2 - Period
You use "Current Week" much too casually. Sometimes you mean last week, sometimes you mean this week.

It would be so much more useful if you actually spelled out the start/stop dates instead of saying "current week".

Weekly Stats - June 4 thru June 10
Weekly Stats - May 28 thru June 3

This should be done in BOTH the e-mail and the php display page.


3 - User Registrations Expansion Link

Need to add a mouseover effect so it doesn't look like a dead link.

Supporting a standard vB expand/contract graphic would help too.


4 - Phrase Lib Support

Desperately needed

YabbaDabba 06-09-2007 11:55 PM

SUGGESTED FEATURE

Let the admin define the reporting period in the admin control panel.
The current Monday thru Sunday period is not very standard.

thenewuser 06-20-2007 09:16 AM

Useful for marketing, thanks, installed!


All times are GMT. The time now is 04:39 PM.

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.01579 seconds
  • Memory Usage 1,750KB
  • 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
  • (1)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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