Suggestion: Member's Active Area (MAA)

[Truality]

Hello everyone, I've thought several times about posting this but I was quite hesitant, and I finally got enough info on it today.

So this suggestion is about adding something to each member's profile 'statistics' page, which shows a percentage of their posts and in which section they make it. I've seen it in a forum I frequent and it's really cool, the best plus of it is-of course-that it lets you know which sections you or anybody else frequents the most and the least.

For example:

[FONT=Tahoma][B]Truality's Active Area[/B]

Community Questions and feedback: 22%[/FONT] [FONT=Tahoma]
Emulation: 18%
Art Gallery: 26%
Other Voting Polls: 20%
Other Chat: 14%[/FONT]

That's just a mere example with names and numbers, supposedly more forums could be added to show a 0%, meaning the member has no posts in that area.

The thing I was searching for all this time, though, was a code, and I finally found it somewhere in that forum. Here's the code and credits for it go to the member's name mentioned:

Spoiler:

[link]

Hi.
I've created a cron job with this code:

$_ACTIVEFORUMS = array(
        28 => "Forum name1",
        30 => "Forum name2",
        109 => "Forum name3",
        108 => "Forum name4",
        107 => "Forum name5",
        110 => "Forum name6",
        87 => "Forum name7",
        115 => "Forum name8",
        114 => "Forum name9",
        52 => "Forum name10",
        112 => "Forum name11",
        27 => "Forum name12",
        123 => "Forum name13"
        // ETC ETC ETC // 
);

// WE PUT THE FORUM ID AND THE ACTIVE AREA NAME

$Q = $db->sql_query("
select post.threadid, thread.forumid as forumid, userid, postid FROM post LEFT JOIN thread ON thread.threadid = post.threadid
WHERE post.visible = 1 AND post.infraction = 0
");
$TOTAL = array();
while ($row = $db->sql_fetchrow($Q))
{
        $TOTAL[$row['userid']]++;
        if ($_ACTIVEFORUMS[$row['forumid']]) $ACTIVE[$row['userid']][$_ACTIVEFORUMS[$row['forumid']]]++;
}

$RESULT = array();
foreach ($ACTIVE as $i => $v)
{
        if (!empty($v))
                foreach ($v as $j => $k)
                        $RESULT[$i][$j] = round(100*$k/$TOTAL[$i]);
}


foreach ($RESULT as $i => $v) $db->sql_query("REPLACE INTO `activearea` VALUES ($i, '".serialize($v)."')");

/*
THE ACTIVE AREA TABLE
CREATE TABLE `activearea` (
  `userid` int(11) NOT NULL auto_increment,
  `stats` text,
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=816210 DEFAULT CHARSET=latin1
*/

After that i created a new class in includes/class_profileblock.php

/**
* Profile Block for Mini Statistics
*
* @package vBulletin
*/
class vB_ProfileBlock_MiniStats extends vB_ProfileBlock
{
    /**
    * The name of the template to be used for the block
    *
    * @var string
    */
    var $template_name = 'memberinfo_block_ministats';

    /**
    * Variables to automatically prepare
    *
    * @var array
    */
    var $auto_prepare = array();
    function prepare_output($id = '', $options = array())
    {
        $USERID = $this->profile->userinfo['userid'];
        $RESULT = $this->registry->db->query_read_slave("SELECT * FROM activearea WHERE userid = $USERID");
        $DATA = $this->registry->db->fetch_array($RESULT);
        $DATA = unserialize(trim($DATA['stats']));

        $this->block_data['activearea'] = '';
        $total = 0;

        $ACTIVEAREAS = array(
            "DotA Chat","Game Strategy","Advanced Mechanics","DotA Replays","Suggestions","DotA Media","DotA Tools & AI","DotA Chinese",
            "Competitive Scene","Member Service","Random Chat"
        );

        foreach ($ACTIVEAREAS as $v)
        {
            if (!$DATA[$v]) $this->block_data['activearea'] .= $v.': 0%<br />';
            else
            {
                $this->block_data['activearea'] .= $v.": {$DATA[$v]}%<br />";
                $total += $DATA[$v];
            }
        }
        $this->block_data['activearea'] .= "Others: ".(100-$total)."%";

    }
}

After that in member.php you must add the new class in array

$globaltemplates = array(.....
    'memberinfo_block_infractions',
    'memberinfo_block_ministats',
    'memberinfo_block_profilefield',
    'memberinfo_block_visitormessaging'
....);

And in array $blocklist where you store the order of the blocks

$blocklist = array(
    'stats_mini' => array(
        'class' => 'MiniStats',
        'title' => $vbphrase['mini_statistics'],
    ),
    'friends_mini' => array(
        'class' => 'Friends',
        'title' => $vbphrase['friends'],
    ),
........);

And to show it you find template memberinfo_block_ministats and add:

<dt class="shade">Members Active area<dt>
<dd>$block_data[activearea]</dd>

Anyway, i dont know if this helps to much, this of course can be achieved using hooks and plugins

I don't know if it can't be implemented here but that's all I got.

So that's about it. I really want to know what you think about it. Let's see how this goes, shall we?

 

[Oryx]

Wow, you definitely put a lot of research into this. The only argument I can see against this (outside of the usual "we don't need anything let's not change a thing" people) is if it can't be implemented here. I'd really like to hear from the people that would implement it to see if it's possible, but I think it's a pretty awesome idea and I would use this really often.

 

[Sydian]

That's pretty nifty, actually. But you'd all be mad that 90% of my posts are invisible to y'all. :'( jk But I think this is a cool feature. I'd like to see it implemented if it's possible!

 

[Nick]

Oh I love this idea, and you put so much thought into for me to really even contemplate saying no.

I'd be really interested to know where most of my activity (in numbers) goes to. What about forums that aren't accessible to everyone, though?

 

[Truality]

What about forums that aren't accessible to everyone, though?

I think you can manipulate the forums included with the variables, and just add an 'Other' for those not supposed to be viewed. Or not include them at all and let 'em guess where the rest of the posts go to. xD

 

[Vrai]

I think this is pretty neat. Not necessary, but definitely neat. Can we do it? 8)

 

[Taemin]

Well for those of us who post in hidden areas the most, the names for them could still be shown. Names are no huge deal, and its not like people would be able to click and visit them. XD;

Love this idea though, I've always wanted PC to have something of the sort. 8D

 

[Alley Cat]

I like this idea a lot, and the work is already done, it just omes down to it geting approved and put in pace. I don't see a way for this information to be super practical, but I don't really care, it's just for fun.

 

[Zelda]

Wow, I'm surprised something like this hasn't been thought of before. o_o It's a really good idea though, wish I had even thought of it myself.

Hopefully the H-Staff decide to approve of this!

 

[Xyrin]

Yes I LOVE this idea, it would be pretty awesome to see where all my posts are. Hopefully this will be implemented quickly.

 

[Chikara]

Aaaaaha, I like this a lot :D

Honestly, I don't think I'll be using it much, but it'll be interesting to check out. Now, will this count all posts we've ever made, or will it just be what posts we do after the thing gets added, if it gets added? Hopefully the first one ):

 

[marcc5m]

So everybody likes this idea?
Well...I DON'T OMG IT SUX IT SUX SOOOOOOO BAD!!!!!
Jk, it seems pretty neat actually :)

 

[Legobricks]

Provided I can opt-out/hide it, I'm fine with this.

 

[vaporeon7]

I think this is a great idea. I think it would be really interesting to see what I post in the most, as well as a few others ;) I can't see a reason why not, unless it isn't possible.

 

[countryemo]

Let me make sure it's okay with HQ before I add it, but thanks for providing the code. C: I like it.

I say we can take this as a yes. No?

This is really neat idea, surprised it hasn't been done, haha. And we got the code already so even better! Cant wait, more to stalk! erm..

 

[Nick]

This is going to be added. It got majority.

 

[Zet]

I know this is probably late but.... correct me if I'm wrong but wouldn't this feature search for all your posts just to get the results? So wouldn't that strain the server a bit?

 

[Squirrel]

Hmm, pretty cool idea... But wouldn't it take up a lot of space? :s

 

[Eliminator Jr.]

I know this is probably late but.... correct me if I'm wrong but wouldn't this feature search for all your posts just to get the results? So wouldn't that strain the server a bit?

I'm not an expert on computers by any means, but perhaps this won't place much stress on the server because unlike name-changing, all this code does is gather information and statistics from posts, not implement changes to all those posts.

 

[Melody]

My only beef with this idea would be if we were unable to hide this from our profile or make it private. Please make sure that we have some level of control over it's view ability. I don't like being tracked for public spectacle.