Suggestion: Member's Active Area (MAA)

KeepWalking said:

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

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

Code:

/**
* 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

Code:

$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

Code:

$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:

Code:

<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

Click to expand...