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 ...

Dream 04-22-2007 12:45 AM

rjmjr69, if you only have one member with birthday in your forum, it will show him as youngest and oldest of your forum.

I'm gonna look into this problem in the foreach.

About your welcome box, I can take a look into your forum, but you will need to enable statistics for guests for me to view it. Do you have a link of the mod for me to take a look at it?

About disabling single statistics, I may do this in the future, but I'm not sure how, this mod has many statistics and making an option for each one in the Statistics options would make the options be too big.

edit: don't worry you are not being a pest :)

Dream 04-22-2007 12:53 AM

Quote:

Originally Posted by Slave (Post 1232616)
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?

I'm glad it seems to be working now, right? You just needed to revert your template and reupload the files.

The User Profile page will only show info if you have Custom Profile Fields, like "what do you like most: cats / dogs". It will show how many people chose what.

If you don't have any custom profile fields set in your board you are safe to disable the User Profile Page in the options.

joker2040 04-22-2007 12:55 AM

Installed! You can view my demo at http://www.s10planet.com/forum/statistics.php

Dream 04-22-2007 12:58 AM

Thanks joker, can I use that as a live demo? :)

Dream 04-22-2007 01:02 AM

Quote:

Originally Posted by NeRilkA (Post 1232665)
For me the page Profil works fine but the SQL error for birthday came back



I put the date in the right format but these errors came back too :

The statistiques for Last Year don't show up like Last Month, Post per Day and Post per month

Nerilka, how do you set up your vBulletin date formats? Did you try to set this mod's formats exactly the way you made your vBulletin date formats?

If you did and you can't make this work, I'll change this mod to force using of the date() format instead of the locale format. (like the version I made before that you used)

joker2040 04-22-2007 01:08 AM

Quote:

Originally Posted by Dream (Post 1233044)
Thanks joker, can I use that as a live demo? :)

Yes... Thanks again for this great mod!!!

Dream 04-22-2007 01:10 AM

Thank you :) looking good!

Dream 04-22-2007 01:15 AM

Quote:

Originally Posted by hurik (Post 1232728)
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 ...

Hurik, I'm sorry to hear that, you are the first owner of a bigger board that lets me know how this mod went.

This mod shows a lot of statistics, I wouldn't know how to cache them all.

I'm thinking of breaking the general statistics in pages, like Top Posters page, Thread Statistics page etc, I think that would help you to run this better. Let me know what you think and what pages with statistics you would like to see.

Oh and I understood you just fine ;)

Dream 04-22-2007 01:26 AM

Quote:

Originally Posted by henners (Post 1232562)
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!

Henners, sorry about that, as I said in my last post I'll do a version of this mod that doesn't show all statistics in one page, that should let you run this mod.

Dream 04-22-2007 07:07 AM

Updated, I broke all statistics into pages. This version should be easier on the server.

It's loading a lot faster now.

Nerilka, I think I fixed your problem with dates. Use this format for the options now.

lighter 04-22-2007 08:26 AM

When using the latest version, i view user profile but get

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

rjmjr69 04-22-2007 08:33 AM

My users are required to enter their birthdate to join so all have it.

Slave 04-22-2007 10:42 AM

Quote:

Originally Posted by Dream (Post 1233041)
I'm glad it seems to be working now, right? You just needed to revert your template and reupload the files.

The User Profile page will only show info if you have Custom Profile Fields, like "what do you like most: cats / dogs". It will show how many people chose what.

If you don't have any custom profile fields set in your board you are safe to disable the User Profile Page in the options.

Yes, working now :)

Thanks for the explanation of the user profiles bit, I won't need to use that as I have no custom stuff.

I've just updated to the latest version and all is well

www.yaxleyvillage.com/statistics.php

.. happy for you to use it as a demo if you'd like :)

NeRilkA 04-22-2007 04:06 PM

Everything works perfectly !! Thansk a lot Dream :)

Dream 04-22-2007 08:36 PM

Quote:

Originally Posted by rjmjr69 (Post 1233232)
My users are required to enter their birthdate to join so all have it.

If people choose to hide age it won't show in youngest/oldest, but they will show in age groups.

Dream 04-23-2007 07:16 AM

Updated, version 3.0

Fixed foreach bug.

Fixed bug with Posts Per Day.

Fixed bug that was showing active members stats when active members are disabled.

Darat 04-23-2007 07:23 AM

Really nice addition, thanks for making it available. I'm like hurik e.g. a fairly large active board so I'm only letting admins use this.

henners 04-23-2007 08:05 AM

Quote:

Originally Posted by Dream (Post 1233199)
Updated, I broke all statistics into pages. This version should be easier on the server.

It's loading a lot faster now.

Nerilka, I think I fixed your problem with dates. Use this format for the options now.

woo, it's still a bit slow here but so so glad it works :)

Opus4 04-24-2007 05:50 AM

I like the fact that the stats are now broken down into separate pages.

Now that this has been done... it might be worth considering consolidating a few of the pages. For example: the thread starters and posts per day items on the Users page could go with the Top Posters page, while the Attachments stats on the Users page seems like a good fit for the Attachments page. Those are the only ones I thought about, though. :)

Dream 04-26-2007 09:58 AM

I'm finishing adding Registration Statistics to this :)

Note how my registrations went up after adding the Welcome Headers mod

Dream 04-26-2007 02:46 PM

Updated, version 3.1

Added Registration Statistics :)

Let me know what you think of it.

PoetJA-1975 04-26-2007 10:20 PM

Excellent - Works wonderfully http://jpicforum.info/statistics.php
Thanx for the sharing ;)

Jacquii.

Slave 04-27-2007 04:03 AM

Quote:

Originally Posted by Dream (Post 1235864)
Updated, version 3.1

Added Registration Statistics :)

Let me know what you think of it.

Super :)

Update now installed .. thanks

Dream 04-28-2007 05:15 AM

Quote:

Originally Posted by Opus4 (Post 1234484)
I like the fact that the stats are now broken down into separate pages.

Now that this has been done... it might be worth considering consolidating a few of the pages. For example: the thread starters and posts per day items on the Users page could go with the Top Posters page, while the Attachments stats on the Users page seems like a good fit for the Attachments page. Those are the only ones I thought about, though. :)

That's interesting, although I have to think about the style, how would they look with the tables stretching all the way to the right, would look weird. Also some people could be interested in disabling only the Top Posters info.

NeRilkA 04-28-2007 12:15 PM

it's great !!! everything works fine !! thanks a lot Dream :)

Dream 04-28-2007 12:50 PM

You are welcome :)

I fixed the active members problem, did you see it?

NeRilkA 04-28-2007 04:20 PM

Yes i saw ;) thanks !

http://www.vbulletin-ressources.com/...statistics.php

Dream 04-28-2007 04:24 PM

ok cool

Can I use that link as a live demo?

ps: I liked your old avatar better :P j/k

ps2: I saw you didn't translate some phrases, some phrases begin with dreamstatistics_, hope that helps (my mistake)

NeRilkA 04-28-2007 04:35 PM

Yes of course you can !! :)

about my old avatar, thanks ;) but I received a mp from an admin saying to me that it "was not suitable for vbulletin.org." :p so I obeyed

NeRilkA 04-28-2007 09:31 PM

Quote:

Originally Posted by Dream (Post 1237133)
ps2: I saw you didn't translate some phrases, some phrases begin with dreamstatistics_, hope that helps (my mistake)

Thanks but i'm sorry i can't see where i forgot some phrases ?

here is the french translation by the way ;)


All times are GMT. The time now is 07:43 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.01431 seconds
  • Memory Usage 1,841KB
  • 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
  • (14)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
  • (40)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