Blog Documentation Book a Demo
Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Forum Statistics 0.3

VincentVincent
edited February 2007 in Vanilla 1.0 Help
http://lussumo.com/addons/?PostBackAction=AddOn&AddOnID=53
hey guys, i've updated the statistics version with a few extra features

Complete Reset
- This will reset your statistics file if it stuffs up

Multiple Statistics Capability
- Yes, now certain statistics like the largest posters can be ranked

Unique Guests Stat Fix
- Well... i wasn't grouping the data so you were getting a bloated number of guests...

I'm still trying to find some good, but mainly interesting statistics that i would be able to use, so if you have any ideas, please say.

Comments

  • WandererWanderer
    The control panel says:
    "A Complete Reset will NOT delete actual data!"

    But it seems to, all stats are reset to "0"
  • VincentVincent
    edited November 2006
    ok, it didn't reset the cache.... it's fixed now

    What the message means is that it doesn't delete anything from the database
  • ayamagucayamaguc
    Every so often I get this error at the very top of the discussion page: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/www/users/casual/forum/extensions/Statistics/default.php on line 99 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/www/users/casual/forum/extensions/Statistics/default.php on line 99 If I refresh once or twice it seems to go away. It might have to do with the newest user? B/c that doesn't seem to update. Any idea how I can resolve it? Or which stats to turn off as a first step?
  • TexTex
    Try setting the options.inc to 666 via chmod (http://lussumo.com/community/discussion/3860/forum-statistics-extension-error-message/#Item_2)
  • TexTex
    edited November 2006
    @ Vincent: I think whispered discussions and comments should be excluded from the statistics, as it confuses with the numbers, given by vanilla. The rest is great. Thanks!
  • VincentVincent
    ok, when i get the time for it i'll fix up a query ;)
  • TexTex
    Not sure about the ;) but many thanks in advance.
  • ayamagucayamaguc
    My options.inc is already 606 (no need). I used to get many more errors that went away when I gave the system the ability to write to that file. My problem appears to be with mysql_num_rows()...
  • ayamagucayamaguc
    I narrowed my problems down to Users and Newest Users. Disabling those appears to have made my errors go away...
  • AresAres
    edited December 2006
    VincentI'm still trying to find some good, but mainly interesting statistics that i would be able to use, so if you have any ideas, please say.
    - Most popular discussion(s), with direct discussionlink and number of comments;
    - Guests in the last 24 hours;
    - Most active user(s);
  • timberfordtimberford
    users listed by amount of topics created would be a good one
  • AresAres
    Another request:

    - Total of posted comments in the last 24 hours and last 7 days.
  • nolefannolefan
    average number of posts a day would be nice to have
  • SlashedZeroSlashedZero
    edited February 2007
    I'm using this extension since quite a while, and I've noticed something lacks compared to the Who's Online extension (which I use on the same forum) : it would be great to be able to click on the newest member's name to view her profile.
  • VincentVincent
    edited February 2007
    ok peoples, i've heard your comments :D

    if you have a forum that is at least semi active, would you be able to help me out by sending each of these queries to your database and letting me know if they work or not?

    Order By Most Active (soon to be improved)
    SELECT LUM_User.Name FROM `LUM_User` ORDER BY LUM_User.CountVisit DESC;

    Guests in the last 24 hours
    SELECT count(*) FROM `LUM_IpHistory` WHERE LUM_IpHistory.UserID = 0 AND LUM_IpHistory.DateLogged > (NOW() + 86400);

    The rest of the asked queries will probably need to have MySQL5 installed, so unless someone figures that out, i'll keep with what i've got at the moment and upgrade the extension to allow links...

    I'll also be fixing up the current statistics to exclude whispers
  • jimwjimw
    I tested the first query and it works fine. I don't have any records in the IpHistory table.
  • VincentVincent
    ok... the second will only be usable if the IPHistories extension is available...

    if anyone has any other queries that are available by default, dont hesitate to tell me
  • AresAres
    The first works, but the second one outputs '0' (while LUM_IpHistory is filled with data)
  • AresAres
    edited February 2007
    Guests in the last 24 hours
    SELECT count(*) FROM `LUM_IpHistory` WHERE LUM_IpHistory.UserID = 0 AND DATE_SUB(NOW(),INTERVAL 1 DAY) <= LUM_IpHistory.DateLogged;For registrated users use WHERE LUM_IpHistory.UserID > 0

    Number of posts in the last 24 hours:
    SELECT count(*) FROM `LUM_Comment` WHERE DATE_SUB(NOW(),INTERVAL 1 DAY) <= LUM_Comment.DateCreated;For the number of post in the last week use INTERVAL 7 DAY
  • VincentVincent
    sweet! i didn't know you could do that! i havent studied mysql for a while so that's probably the reason :P

    I'll put em in when i can but if you have any more don't be afraid cos i might think of something to make the next extension a bit more interesting.
This discussion has been closed.