vb.org Archive
Page 27 of 44 « First 172526 27 282937 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vB3 Forumhome Stats Cache Serialize hack v2.2 (https://vborg.vbsupport.ru/showthread.php?t=61420)

Nj?rd Eriksson 04-07-2004 09:07 PM
Quote:
Originally Posted by Boofo
Give me a few. I haven't added it yet even on my board. I will do that shortly. ;)
I'd love to have other things added (this is not urgent and should enjoy no priority):

For example, I installed the Board Spent Time Hack:
https://vborg.vbsupport.ru/showthread.php?t=60488

Is there a way to add the total spent time on the board (all members), then the the member who spent the most time on the board with his time (and maybe even expressed as a percentage of the total spent time)?

Also, I force people to choose a gender at registration. Is it possible to display "x% male, y% female"?

They also have to add their ethnicity (via a drop-down menu) ... again, would it be possible to display percentages (x% A, y% B, z% C, &c.)

Average age of the members? (compiled from those who have a valid age set?)

The possibilities seem to be endless. :)

Boofo 04-07-2004 10:02 PM
Quote:
Originally Posted by BarBeQue
Boofo, any news on how to add the arcade stats to your hack?
Would love to have those added :D
Ok, for those of you who have John's Excellent vB3 Arcade hack installed, here's a treat!

This addon will add a line to your Forumhome Stats to Display the Most Played Game (with a link directly to that game), the highest scorer in that game (the Champion) and his score.

Here we go!

In index.php, find:

PHP Code:
    // <!-- TOP REPUTATION -->
    $toprep = $DB_site->query_first("
        SELECT userid, username, reputation
        FROM " . TABLE_PREFIX . "user
        ORDER BY reputation
        DESC LIMIT 1
        "); 
BELOW it add:

PHP Code:
    // <!-- TOP ARCADE GAME -->
    $mostactive = $DB_site->query_first("
            SELECT COUNT(*) as total, gamesessions.gamename, games.title, games.gameid, MAX(gamesessions.score) as score, user.username, user.userid
            FROM ".TABLE_PREFIX."gamesessions
            INNER JOIN " . TABLE_PREFIX . "games AS games ON(gamesessions.gamename = games.shortname)
            INNER JOIN " . TABLE_PREFIX . "user AS user ON(games.highscorerid = user.userid)
            WHERE gamesessions.valid=1
            GROUP BY gamesessions.gamename
            ORDER BY total
            DESC LIMIT 0,1
        "); 
Find:

PHP Code:
    $statscache['lastupdate'] = intval (TIMENOW); 
ABOVE it add:

PHP Code:
    $statscache['mostactivetotal'] = intval ($mostactive[total]);
    $statscache['mostactivegamen'] = $mostactive[gamename];
    $statscache['mostactivetitle'] = $mostactive[title];
    $statscache['mostactivegameid'] = intval ($mostactive[gameid]);
    $statscache['mostactivescore'] = intval ($mostactive[score]);
    $statscache['mostactiveun'] = $mostactive[username];
    $statscache['mostactiveid'] = intval ($mostactive[userid]); 
Find:

PHP Code:
    $statscache['topreprep'] = vb_number_format($statscache['topreprep']); 
BELOW it add:

PHP Code:
    $statscache['mostactivetotal'] = vb_number_format($statscache['mostactivetotal']);
    $statscache['mostactivescore'] = vb_number_format($statscache['mostactivescore']); 
Save and upload.

In the forumhome template, find:

HTML Code:
                                <if condition="$show['reputation']">
                                <tr>
                                        <td nowrap="nowrap"><span class="smallfont">Top Reputation: <a href="member.php?$session[sessionurl]u=$statscache[toprepid]">$statscache[toprepun]</a> (<b>$statscache[topreprep]</b> Reputation Points)</span></td>
                                </tr>
                                </if>
BELOW it add:

HTML Code:
                                <tr>
                                        <td nowrap="nowrap"><span class="smallfont">Most Active Arcade Game: <a href="$vboptions[bburl]/arcade.php?do=play&gameid=$statscache[mostactivegameid]">$statscache[mostactivetitle]</a> (<b>$statscache[mostactivetotal]</b> Total Plays -- Champion: <a href="member.php?$session[sessionurl]u=$statscache[mostactiveid]">$statscache[mostactiveun]</a> with <b>$statscache[mostactivescore]</b> Points)</span></td>
                                </tr>
Save the template.

NOTE: Don't forget to set the update time to 0 and refresh the page so the cache can get updated with the new stats. And don't forget to set it back to what you had it set at after updating the cache. ;)

You're done!
Enjoy!

Nj?rd Eriksson 04-08-2004 06:15 AM
Works great, Boofo. Thanks for this one. ;)

Nj?rd Eriksson 04-08-2004 06:51 AM
One suggestion: Would it also be possible to display how often the game has been played?

Boofo 04-08-2004 10:25 AM
I think we would have to go another query for that. And there are already more than I originally wanted with this hack. :(

EDIT: I think I can do it with this same query. Hold on and I will test it and be right back to let you know for sure. ;)

The post above has been updated to count the Total Game Plays now. To add this, just redo the code that you added to the forumhome template. ;)

djohn 04-08-2004 11:22 AM
Suggestion for the next version:
Options in ACP to turn on\off any stats line, that would rock!

Boofo 04-08-2004 11:26 AM
If there's a stat in there you don't need, just take the query for it out and the line in the templates for it out. Having an option to turn off a stat is still going to let the query still run for it. And if I added the ability to turn off the query, too, this hack would get bloated a lot worse than it already is. ;)

egn 04-09-2004 04:27 AM
Top Poster: l1quid (6 Posts = 66.67%)

There is only 6 posts, and I posted all 6 of them.. for somr reason it only shows me as posting in 2/3 of them

Boofo 04-09-2004 05:19 AM
Run your counters and see if that strightens it out. If that doesn't work, then take out the percentage code. I will be dropping that in the next update. The only one I can seem to get it working right for is me. ;)

BarBeQue 04-09-2004 08:24 AM
Actually, boofo....

The percentages don't all work on your own forums as well

See attachment

The top poster has 200 out of 2322, which is 8,61 % and not 6,85%
The other percentages are correct

I have the same problem, the top poster % is incorrect on my forum as well, while the others do work


All times are GMT. The time now is 03:35 AM.
Page 27 of 44 « First 172526 27 282937 Last »
Show 40 post(s) from this thread on one page

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.01543 seconds
  • Memory Usage 1,773KB
  • 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
  • (2)bbcode_html_printable
  • (6)bbcode_php_printable
  • (2)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