vb.org Archive - Statistics Modifications

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's Forum Statistics

Warning: This add-on is not good for big forums, it calculates all the info on the fly.

This will add a page with statistics to your forum.

Forum Statistics
- Newest Members
- Posts per day (last x days)
- Posts per month (last x months)
- Forum open since
- Average posts per day overall
- Average threads per day overall
- Average replies per thread overall
- Active members percentage
- Oldest thread

Top Posters
- last year
- this year
- last month
- this month
- last 24 hours
- last 7 days
- last 30
- overall

Threads
- most viewed
- most replied
- top rated
- most replied in the last X days (choose X in the options, default is 10).

Polls
- Most voted
- Latest polls

Users
- Top Thread Starters
- Top Reputation
- Top Referrers
- Top Posts Per Day Average
- Users with most attachments
- Most viewed/downloaded attachments
- Latest attachments

Thank You Hack
- Most Thanked Users
- Who Thanked Most
- Most Thanked Posts

Attachments Statistics
- Statistics for each attachment extension
- Most viewed/downloaded attachments for each extension
- Latest attachments for each extension
- Total attachments and downloads for each extension and overall
- Average downloads per attachment

Most Active Forums
- Last year
- This year
- Last month
- This month
- Last 30 days
- Last 7 days
- Last 24 hours
- Overall

Age Statistics
- Oldest/youngest members
- How many members on each age range

Custom Profile Fields Statistics
- Percentage of each option chosen by your members

Registration Statistics
- Daily registrations
- Monthly registrations

Statistics for each forum
Choose the forum you want to view statistics from. Only forums people have permission to see are shown.

Options in the Admin Control Panel
You can exclude forums/usergroups/users from the statistics, disable the attachments statistics page and set other options.

Administrators Only Option
You can set the statistics to be shown only to administrators.

Installation
You just need to import a product and upload a few files (statistics.php and statsmod/ folder). There are options in the Admin Control Panel, the modification is fully phrased and a few templates are added. An optional navbar template edit is needed to supply a link to statistics.php.

New Poll Bar Images
You have the option to use a new set of poll bar images that comes with this mod as your default poll bar images.

Please leave the url to your statistics.php in this thread for me to use as a live demo if you can.

Live Demos:
http://www.s10planet.com/forum/statistics.php
http://www.yaxleyvillage.com/statistics.php
http://jpicforum.info/statistics.php
http://www.vbulletin-ressources.com/...statistics.php
http://www.torreiravirtual.net/fairplay/statistics.php

It don't work:

Quote:

Invalid SQL:

SELECT userid, username, threads, usergroupid
FROM vb_user
WHERE threads > 0
ORDER BY threads DESC LIMIT 10;

MySQL Error : Unknown column 'threads' in 'field list'
Error Number : 1054

Thanks! However, a screenshot or demo link wouldn't hurt... ;)

I got this error:

Quote:

Invalid SQL:
SHOW COLUMNS FROM user LIKE 'post_thanks_thanked_times';

MySQL-Fehler : Table '1_historik-forum.user' doesn't exist
Fehler-Nr. : 1146
Datum : Thursday, March 1st 2007 @ 06:21:59 PM
Skript : http://www.historik-forum.org/forum/statistics.php
Referrer :
IP-Adresse : censored
Benutzername : censored
Klassenname : vB_Database

I don't think this was tested. The author was online when I posted first and there is no response. I assume he will respond to this thread but until then I will be passing on this mod.

Ok, please try again.

And let me know if any errors occur.

I've made a screen. Looks very nice!

Thanks Wulfnoth :)

If you got a live demo and can share please drop the link in this thread.

Nope...Reinstall didn't work

Quote:

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT userid, username, threads, usergroupid
FROM vb_user
WHERE threads > 0
ORDER BY threads DESC LIMIT 10;

I don't know why you don't have a threads field in the user table sorry. Thanks for trying the mod though.

No problemo but I will bet if I had that issue I won't be the only one. It does look sweet though from the screen capture in Wulfnoth's post.

I have two different setups of 3.6.4 both on different servers to include a test 3.6.4. It does that on all of them.

Thanks, maybe it's some other mod I have here that added that field. We'll see.

Quote:

Originally Posted by Dream (Post 1193501)

I don't know why you don't have a threads field in the user table sorry. Thanks for trying the mod though.

Doesn't work for me either on 3.6.4, exactly the same error.

Removing

Quote:

$list = array();
$results = $db->query_read("
SELECT userid, username, threads, usergroupid
FROM " . TABLE_PREFIX . "user
WHERE threads > 0
ORDER BY threads DESC LIMIT $howmany");
while ( $entry = $db->fetch_array($results) ) {
$list[] = $entry;
}

From statistics.php allows the module to work (apart from thread starters of course)

i cant get it working same how getin the same error like other friends

hep please

I updated the code, added a check for the existence of the field threads, if it doesn't exist it won't run the code and won't show that category. All should be working now.

Is there a way to add the top thanked and top thanker's?

It's already there :)

Updated again, the threads field was from another mod, I changed the query so it won't use that field anymore, and the category will show.

You got it that time. Nice clean install. Works great. ;)

We are post brothers now, with our souls linked for all eternity =:O

Problem. When you click any of the links they take you outside of the board to the root directory of the website...well in my case it does.

Post Bruddas! Cool! ;)

Fixed. In statistics.php find:

Quote:

function statistics_make_user_link($user) {
$name = fetch_musername($user);
return "<a href=\"$vboptions[bburl]./member.php?u=$user[userid]\">$name</a>";

Where it has /member.php you need to change it to ./member.php and the next two after..

You know what I mean?

Fixing now.

Can you still PM me your statistics.php address?

Cool...that means you knew what I meant....I was doing that quick because I had something going on. I was going to just paste the whole thing but didn't think that was a good idea.

Sorry, actually I don't think I understood. Your $vboptions[bburl] shouldn't end with a trailing slash, and it should be the address of your forum.

Okay...You have this:

Quote:

function statistics_make_user_link($user) {
$name = fetch_musername($user);
return "<a href=\"$vboptions[bburl]/member.php?u=$user[userid]\">$name</a>";
}

It needs to be this:

Quote:

function statistics_make_user_link($user) {
$name = fetch_musername($user);
return "<a href=\"$vboptions[bburl]./member.php?u=$user[userid]\">$name</a>";
}

Same thing with the function statistics_make_thread_link & the function statistics_make_post_link

Ok I got that, I didn't understand why its needed. Sorry but that would make

http://www.domain.com./member.php

Don't know what to tell ya but that is what it took to make it work on mine. Other wise if I clicked any link I got a 404 error. Let's say I was clicking a user link
(example) this is user anonymous and the link would be http://mysite.com/member.php?u=2 now after I did the edit that same link shows as http://mysite.com/forum/member.php?u=2 which then works.

No matter...I am calling it a day. That is what made it work for me so if anyone else has the same issue that will work for them. If not and the clean install works then that is the kewlest also ;)

On the General vBulletin Options, theres a forum URL option. Check if you have

http://mysite.com

or

http://mysite.com/forum

there, the latter would be the correct one.

i re installed it but still no seem to be workin anyways ill wait for anothervrsioon of this hack i guess

Quote:

Originally Posted by Dream (Post 1193702)

On the General vBulletin Options, theres a forum URL option. Check if you have

http://mysite.com

or

http://mysite.com/forum

there, the latter would be the correct one.

Nope. That isn't it. Mine is set correctly.

Aveon, what's happening?

Tom S, maybe time will tell us what is happening. Hey man click install! :P

If you have any ideas for new statistics let me know in this thread. They are fairly easy to add if the database query is simple.

Working fine now with the new updates ;)

Aveon, download again, now it should work.

Updated, added Top Posters this month, this year and on the last 7 days.

Let me know if you think its slow.

Quote:

Originally Posted by Dream (Post 1193633)

It's already there :)

I love you! :D

*installed*

Quote:

Originally Posted by Dream (Post 1194508)

Updated, added Top Posters this month, this year and on the last 7 days.

Let me know if you think its slow.

You updated again?

Nice...You should put rows 1, 3, and 4 on the same row though. It would tidy it up. It would for me anyway ;)

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01424 seconds Memory Usage 1,818KB 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 (11)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)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
Messages: