vb.org Archive

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

hambil 04-11-2007 09:36 PM

Alright, another bug squashed. Thanks for the help everyone. It would seem that a bug in the install sql was being hidden for a number of reasons, but the latest zip should correct that. You *must* do a complete uninstall and reinstall, as it appears the install code does't run on an overwrite.

voteforbird 04-11-2007 09:37 PM

You need to completely uninstall and then reinstall. Oddly, I did this and nothing happened, but the next day it was working. Perhaps it has to aggregate stats?

Also, the stats are a bit odd in that it seems to be comparing day X of the month to X amount of days in previous month, but since X doesn't change from daytime to nighttime, the % (and the arrows) move up throughout the day. At 12:00 AM, the %'s jump down again.

hambil 04-11-2007 09:42 PM

Quote:

Originally Posted by voteforbird (Post 1225375)
You need to completely uninstall and then reinstall. Oddly, I did this and nothing happened, but the next day it was working. Perhaps it has to aggregate stats?

See above update.

Quote:

Also, the stats are a bit odd in that it seems to be comparing day X of the month to X amount of days in previous month, but since X doesn't change from daytime to nighttime, the % (and the arrows) move up throughout the day. At 12:00 AM, the %'s jump down again.
Yeah, that's an interesting issue. What I do is compare today against the average for today over the last x months. Of course as the day goes on the numbers will get better.

In order to compare literally minute to minute, I'd have to run the large 'avg' queries everytime I run the 'current' queries. However, that would make the stats more accurate. Perhaps I'll make that an options - it might be especially useful for people who are using a delay of several minutes or more anyway.

goblues 04-11-2007 10:55 PM

Had to update a usergroup to "activate" the mod but is working now. Thanks!

Deadly Assassin 04-12-2007 04:21 AM

In the Screeny, there are some green arrows, it doesnt show on mine?

I have left the board accessible :up:

hambil 04-12-2007 05:59 AM

That's because Firefox doesn't show red x's. Move the vbtrends gifs to your various skin image directories, and you're good to go.

tobias_t 04-12-2007 06:01 AM

Quote:

Originally Posted by hambil (Post 1225385)
Yeah, that's an interesting issue. What I do is compare today against the average for today over the last x months. Of course as the day goes on the numbers will get better.

Why don't you compare the previous, finished day instead of the present one? This should solve this problem.

hambil 04-12-2007 06:24 AM

Quote:

Originally Posted by tobias_t (Post 1225664)
Why don't you compare the previous, finished day instead of the present one? This should solve this problem.

The original inspiration for this hack was as a member motivator. I wanted my members to see the stats where down and post more and recruit more to get them up. In that light, I wanted it to change when they made a post or a thread or got someone to join. I wanted them to get positive feedback.

I still think that's a valuable thing and I want to keep the concept of quick positive feedback. However, I need to go think on this some.

tobias_t 04-12-2007 06:38 AM

Quote:

Originally Posted by hambil (Post 1225681)
The original inspiration for this hack was as a member motivator. I wanted my members to see the stats where down and post more and recruit more to get them up. In that light, I wanted it to change when they made a post or a thread or got someone to join. I wanted them to get positive feedback.

The idea of the mod is great, but I think there is much more value in it for admins and moderators than for members (which members care about the stats of a forum anyway?). So I would definitely suggest going for a readout that is probably less real-time but more valid overall.

Thanks for your efforts with this project!

hambil 04-12-2007 06:42 AM

Quote:

Originally Posted by tobias_t (Post 1225694)
(which members care about the stats of a forum anyway?)

You'd be surprised. On my boards they care very much. It's the same reason people like the store, and obsess over their time logged in or reputation or post count. Many people just love having things to play with as part of their community.

However, that said, since I've already added the delayed concept, tweaking it further makes perfect sense. This doesn't have to be an either/or thing.

tobias_t 04-12-2007 06:49 AM

Quote:

Originally Posted by hambil (Post 1225698)
However, that said, since I've already added the delayed concept, tweaking it further makes perfect sense. This doesn't have to be an either/or thing.

Sounds great. Frankly, I haven't come around to installing the new 2.0 version yet so I haven't looked at the current features, but...

what I think would be terrific: the option to set the stat to use either a single day, week or month as the accumulation timeframe; and also, having the option for different reference values that are being compared against, namely: previous day (week/month); same day (week/month) of the previous year, so you can filter out seasonal effects; as well as average day (week/month) starting from date x. Or maybe even having multiple reference values shown at once! Just a suggestion.

hambil 04-12-2007 07:00 AM

It is my dream to eventually have this hack support this software, for some really nice trending and display capabilities. I was working on this a while back, but abandon it when I got sick. Perhaps now it will resurface.

odie3 04-12-2007 11:09 AM

Most likely have to put the gifs in your ambience/image/misc/ directory

loonytune15 04-12-2007 12:55 PM

hambil, thanks for sending me the v1.2.6 of this hack.

Hope you manage to work the rest of the bugs out of v2 :D

AMG021 04-12-2007 03:51 PM

Dude i just update my hack now and now its not working ! Please help me!

hambil 04-12-2007 03:52 PM

Quote:

Originally Posted by AMG021 (Post 1225999)
Dude i just update my hack now and now its not working ! Please help me!

Can you be more specific?

AMG021 04-12-2007 03:59 PM

What do you mean. Prior to your update It was working. I just downloaded it now and its not working at all. Look at the attachment

BTW I tried uninstalling it and reinstalling it. But nothing worked :(

hambil 04-12-2007 04:11 PM

Quote:

Originally Posted by AMG021 (Post 1226007)
What do you mean. Prior to your update It was working. I just downloaded it now and its not working at all. Look at the attachment

BTW I tried uninstalling it and reinstalling it. But nothing worked :(

Did you try going into usergroups and setting the permission to see trends? Save the usergroup EVEN if it is already set to 'yes' for can view trends.

AMG021 04-12-2007 04:29 PM

Quote:

Originally Posted by hambil (Post 1226016)
Did you try going into usergroups and setting the permission to see trends? Save the usergroup EVEN if it is already set to 'yes' for can view trends.

Ok that helped me thanks!

voteforbird 04-12-2007 07:17 PM

Wait, it's only comparing the X day of the month? I would think it should compare X amount of days in this month to X amount of days in past months ..

hambil 04-12-2007 07:19 PM

Quote:

Originally Posted by voteforbird (Post 1226146)
Wait, it's only comparing the X day of the month? I would think it should compare X amount of days in this month to X amount of days in past months ..

Yes, that is what it does.

wolfe 04-12-2007 09:02 PM

hi m8 is it possible to have the positive / negative arrow for the members mine always says 100%

also how do set the newest members to display in the colour i have set for there group. thx :P

hambil 04-12-2007 09:40 PM

Quote:

Originally Posted by wolfe (Post 1226205)
hi m8 is it possible to have the positive / negative arrow for the members mine always says 100%

also how do set the newest members to display in the colour i have set for there group. thx :P

In most cases where I've seen 100% It's because the board is less than 2 months old and just doesn't have enough history to compare against. You can change the formula in the admincp if you'd like. By default it is round(($count / $avg) * 100). Change it to round(($count / $avg) * 100) - 100.

wolfe 04-12-2007 09:49 PM

Quote:

Originally Posted by hambil (Post 1226231)
In most cases where I've seen 100% It's because the board is less than 2 months old and just doesn't have enough history to compare against. You can change the formula in the admincp if you'd like. By default it is round(($count / $avg) * 100). Change it to round(($count / $avg) * 100) - 100.


m8 when i add

(($count / $avg) * 100) - 100 all the stas go to red DOWN

also what i ment was where it says active members is there anyway of putting an arrow.

also is it possible to make the stats stay at and under 100% i mean i got 115% posts theres no such percentage.

and my stats have just reset them selves ? whys that

Deadly Assassin 04-13-2007 02:54 AM

Quote:

Originally Posted by hambil (Post 1225661)
That's because Firefox doesn't show red x's. Move the vbtrends gifs to your various skin image directories, and you're good to go.

Fixed :up:

Great support, many thanks :D

hambil 04-13-2007 03:03 AM

Quote:

Originally Posted by wolfe (Post 1226237)
m8 when i add

(($count / $avg) * 100) - 100 all the stas go to red DOWN

The don't put in the -100, or turn on 'positive trends only' in the admincp options. Or come up with an entirely new formula. The numbers are what they are - I just report them.

Quote:

also what i ment was where it says active members is there anyway of putting an arrow.
Sure, you could edit the forumhome_vbtrends template. Of course, active members would never have a down arrow, it will always be between 0 and 100.

Quote:

also is it possible to make the stats stay at and under 100% i mean i got 115% posts theres no such percentage.
Sure there is. 100% of 10 is 10. %120 of 10 is 12.

Quote:

and my stats have just reset them selves ? whys that
It's a new day. The stats track your progress over the day as compared to the previous x number of months.

Terminatoronly 04-13-2007 10:54 AM

its not working for me it doesnt show anything can u plz tell me what to do????

hambil 04-13-2007 11:02 AM

Go into the usergroups and save them (even though you haven't made a change). There is some sort of odd permission bug happening.

Terminatoronly 04-13-2007 12:34 PM

Ok Its Working Now :)

djjeffa 04-15-2007 05:10 PM

Quote:

Originally Posted by hambil (Post 1226016)
Did you try going into usergroups and setting the permission to see trends? Save the usergroup EVEN if it is already set to 'yes' for can view trends.

I upgraded and dont see this option in user group
any ideal why?

hambil 04-15-2007 05:21 PM

Quote:

Originally Posted by djjeffa (Post 1228454)
I upgraded and dont see this option in user group
any ideal why?

Make sure you uploaded all the xml files. Other than that, it should work.

djjeffa 04-15-2007 05:52 PM

Quote:

Originally Posted by hambil (Post 1228467)
Make sure you uploaded all the xml files. Other than that, it should work.

thank you that was it

Devil Woman 04-15-2007 08:22 PM

HI there, I installed this a few weeks ago and since updating the other day I have had problems with it showing up, but yet it was showing up before I upgraded.

I have uninstalled and resinstalled it again tonight with no success any help is appreciated.

hambil 04-15-2007 08:25 PM

Quote:

Originally Posted by Devil Woman (Post 1228570)
HI there, I installed this a few weeks ago and since updating the other day I have had problems with it showing up, but yet it was showing up before I upgraded.

I have uninstalled and resinstalled it again tonight with no success any help is appreciated.

For some reason I haven't figured out yet, you need to open each usergroup and re-save them for the 'can view trends' setting to take effect for that group.

Devil Woman 04-15-2007 08:32 PM

Thanks alot, have done and it's sorted :)

Thanks again.

RedGTiVR6 04-16-2007 12:52 PM

I just tried to install this update and have run into an issue.

I uploaded the files and I've uploaded the .xml file allowing rewrite.

I then go into the usergroups to allow the various user groups to view, when on an administrator and I select yes to can view, then hit update, I get the following database error:

Code:

Database error in vBulletin 3.6.5:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Administrators',
        `description` = '',
        `usertitle` = 'Administrator',
        `opentag` = '',
        `closetag` = '',
        `passwordexpires` = '0',
        `passwordhistory` = '0',
        `vbtrends_permissions` = '1',
        `vbgmepermissions` = '31',
        `vbclassified` = '122879',
        `vbclassified_timeframe_limit` = '365',
        `vbimghost` = '3',
        `vbimghost_upslots` = '20',
        `vbimghost_files` = '500',
        `forumpermissions` = '1048575',
        `attachlimit` = '0',
        `pmquota` = '2000',
        `pmpermissions` = '7',
        `pmsendmax` = '5',
        `calendarpermissions` = '63',
        `wolpermissions` = '31',
        `adminpermissions` = '3',
        `genericpermissions` = '1038884799',
        `genericoptions` = '55',
        `profilepicmaxwidth` = '100',
        `profilepicmaxheight` = '100',
        `profilepicmaxsize` = '100000',
        `avatarmaxwidth` = '100',
        `avatarmaxheight` = '100',
        `avatarmaxsize` = '65536',
        `signaturepermissions` = '230911',
        `sigpicmaxwidth` = '500',
        `sigpicmaxheight` = '100',
        `sigpicmaxsize` = '20000',
        `sigmaxrawchars` = '0',
        `sigmaxchars` = '0',
        `sigmaxlines` = '0',
        `sigmaxsizebbcode` = '7',
        `sigmaximages` = '0',
        `akspam_permissions` = '0',
        `vbwikiroles` = '',
        `vbwikipermissions` = '524287'
WHERE usergroupid=6;

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

Seems that there is an issue with "vbtrends_permissions"...

Any help?

Also, do you have any special uninstall instructions? I'd like to be able to uninstall if possible for future.

EDIT: I had to completely uninstall the .xml then reinstall it to prevent this database error from occuring.

On another note, now the stats are all exagerated. Previously, our numbers were up 8%, 11%, etc.

Now it's showing a 90% increase, 88% increase, etc.

The change is just after the update...not after a few days...but rather just within a matter of a few minutes.

Mrdby 04-16-2007 12:57 PM

Will This Mess Up Cyb's Stats Hack?

hambil 04-16-2007 01:48 PM

Quote:

Originally Posted by RedGTiVR6 (Post 1228971)
On another note, now the stats are all exagerated. Previously, our numbers were up 8%, 11%, etc.

Now it's showing a 90% increase, 88% increase, etc.

The change is just after the update...not after a few days...but rather just within a matter of a few minutes.

That's because the new forumals are 100% based by default. It's an easy change. In the admincp change round(($current / $avg) * 100) to round(($current / $avg) * 100) - 100.

hambil 04-16-2007 01:49 PM

Quote:

Originally Posted by Mrdby (Post 1228972)
Will This Mess Up Cyb's Stats Hack?

I have no idea.

Daky 04-18-2007 02:01 PM

This is very nice script, i love it!

Thank you!

I would just like to ask you how to bold this:

Teme: 2,342, Ovaj mesec: 159 (99%)
Poruke: 72,221, Ovaj mesec: 6366 (102%)
Članovi: 4,971, Ovaj mesec: 274 (4%)

I would like all numbers to be bold, only numbers.

TO BE LIKE: Teme: 2,342, Ovaj mesec: 159 (99%)

teme = threads
poruke = posts

Thank you!


All times are GMT. The time now is 09:38 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.01586 seconds
  • Memory Usage 1,844KB
  • 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_code_printable
  • (24)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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