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 - Dream's Forum Statistics (https://vborg.vbsupport.ru/showthread.php?t=140812)

Dream 04-20-2007 11:13 PM

No problem :) the active members problem is most likely a problem with vBTrends.

rjmjr69 04-20-2007 11:15 PM

Quote:

Originally Posted by Dream (Post 1232277)
NeRilkA: Try using the attached statistics.php file

rjmjr69: yeah :/ the front page is big and has a lot of statistics, I may be separating it into pages in a later version


Actually now that i think of it. I like having them only run on one page. As long as it does not add to any of the other areas I'm good with the way it is. Thank you works great

Dream 04-20-2007 11:18 PM

No problem :) glad you liked it

Dream 04-21-2007 05:48 AM

Updated, added user profile statistics, or custom profile field statistics.

Added total disk space and average filesize in attachments stats page.

Added option to show stats navigation on top.

To upgrade read upgrade.txt, there are new files.

If you have problems with dates showing something like "d-m" you need to change your day/month/time stats options using the format in this page

http://www.php.net/manual/en/function.strftime.php

rjmjr69 04-21-2007 06:43 AM

I love this addition its great. I do not mind the queries for they are only when you call for the stats so no biggie it does not slow the site down any. Anyway I've come across an error or bug.....

https://vborg.vbsupport.ru/external/2007/04/8.jpg

What can I do to get that to show correctly. He should be listed as the Youngest


Woops found another I enabled the Profiles option and I get this error at the top of the page and nothing is displayed.

Warning: Invalid argument supplied for foreach() in /statsmod/statistics_user_profile.php on line 9

I do not mean to be a pest with all these issues but best you know about them right?
Well when viewing any of the statistics pages the Welcome Box has an image icon but no image I can click the icon and set view image it refresh's the page and all is well. Normally it will say Good Afternoon Rjmjr69. Its a hack I have installed. But when viewing the statistics page it only has the icon and Afternoon no GOOD? If you need a link to the mod let me know. But its called GoodMoring/Afternoon/Evening images hack Also all the font colors in the shout box and usergroup colors are wrong until a refresh?
Thanks


Another request can you make it so certain categories wont appear? Like Last Year my site is not even 2 month's old yet so its empty there and its at the top. And could it be worked to allow custom placement of the box's/categories?

henners 04-21-2007 10:58 AM

When you run the .php for the first time, does it do some thinking first or does it work straight away?

The only reason I ask is that i've installed twice and on both occasions it seems something has gone crazy when I try and load the stats page, CPU loads hits 100%, apache crashes etc... This is probably an issue with our (dedicated) server, but I have no control over that, and each time this happens I get services restarted within a minute or so (so the forum stays up!) Should I be brave and let whatever is happening continue, or is this not normal ;)

Cheers, I don't have much time atm but I really like your mod!

Slave 04-21-2007 12:57 PM

Wonderful thanks for the update :)

One thing, I seem to have lost the dropdown menus?!

I reverted my STATISTICS template as I'd played with it to put the dropdown menu at the top. Since then they have disappeared. Any ideas?

http://www.yaxleyvillage.com/statistics.php

Slave 04-21-2007 01:01 PM

hmm .. I reuploaded the .php file and all is well .. ?!?

Just seen that the User Profile page is blank .. what is it meant to be showing?

NeRilkA 04-21-2007 02:52 PM

For me the page Profil works fine but the SQL error for birthday came back

Quote:

Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT SUM( Y - SUBSTRING(birthday, 7) ) / COUNT(*) AS average
FROM user
WHERE birthday != '' AND birthday_search NOT LIKE '0000-%';
MySQL Error : Unknown column 'Y' in 'field list'
Error Number : 1054
Date : Saturday, April 21st 2007 @ 05:50:13 PM
Script : http://www.vbulletin-ressources.com/...statistics.php
Referrer : http://www.vbulletin-ressources.com/...statistics.php
IP Address : 172.184.77.234
Username : NeRilkA
Classname : vB_Database
I put the date in the right format but these errors came back too :
Quote:

Warning: mktime() expects parameter 6 to be long, string given in /statistics.php on line 1184

Warning: mktime() expects parameter 6 to be long, string given in /statistics.php on line 1180

Warning: mktime() expects parameter 6 to be long, string given in /statistics.php on line 1176

Warning: mktime() expects parameter 4 to be long, string given in /statistics.php on line 1177

Warning: mktime() expects parameter 4 to be long, string given in /statistics.php on line 1167

Warning: mktime() expects parameter 4 to be long, string given in /statistics.php on line 1274

Warning: mktime() expects parameter 4 to be long, string given in /statistics.php on line 1512

Warning: mktime() expects parameter 6 to be long, string given in /statistics.php on line 1519
The statistiques for Last Year don't show up like Last Month, Post per Day and Post per month

hurik 04-21-2007 04:39 PM

hi,

very nice mod but i have a suggestion (i hope nobody has suggest this before, i was to lazy too read the whole thread! :) ):
i would make an cron job which calculate the whole stats every hour and save it somewhere in the database and when an user look at the stats it only load the result and this would HIGHLY reduce the server loads.

my board has 800 k post, 20 k user and when 500 user are in the boards it take:
"Page generated in 187.23493004 seconds (0.05% PHP - 99.95% MySQL) with 41 queries" and i have an server with:
CPU: Dual-Core AMD Prozessor - Opteron? 1218
RAM: 4 GB
HD: RAID1 2 x 400 GB

ant thats only when i look at the stats. when i would make it open for all it would kill my server ...

hurik

i hope every body understand my bad english ...


All times are GMT. The time now is 05:01 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.01421 seconds
  • Memory Usage 1,747KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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