Mini Mods - Users posts

This small mod will tell you some small stats about where a member is posting : in which forums and what it represents against his total number of messages (see screenshot below. sorry it's a french screenshot ).
It respects your forums ordering and groups them by category, with a total by category.

Php code to place in the "modcp" dir, filename "usermess.php" :

PHP Code:

<?php
// ######################## usermess.php ###########################
//
// Quick stats for member's number of messages.
//
// Auteur : Bec ? Fuel
// Date   : December, 10 2006
// Version : 1.2

// ######################## SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
@set_time_limit(0);
 
// #################### PRE-CACHE TEMPLATES AND DATA ######################
$phrasegroups = array('style','cpuser','user','forum','search');
$specialtemplates = array('products');

// ########################## REQUIRE BACK-END ############################
require_once('./global.php');
require_once(DIR . '/includes/functions.php');

$phrase_percentage = "Par rapport au total";

print_cp_header($vbphrase['user_manager']);
print_form_header('usermess','usermess',false,true);
print_table_header($vbphrase['search_users']);
print_input_row($vbphrase['username'],'membre',$membre,true);
print_submit_row($vbphrase['find']);  

if ($_REQUEST['do'] == 'usermess')
  {
    $membre = $vbulletin->input->clean_gpc('p', 'membre', TYPE_STR);
    $result = $db->query_read("SELECT userid, username FROM ". TABLE_PREFIX ."user WHERE username='".$membre."'");
    if (!$db->num_rows($result) > 0)
      {
        define('CP_REDIRECT', 'usermess.php');
        print_stop_message('no_users_matched_your_query');
      }
    else
      {
        print_table_footer();
        print_form_header('usermess','usermess',false,true);
        $r = $db->fetch_array($result);
        $userid = $r['userid'];
        print_table_break();
        print_table_header($vbphrase['posts_made_by'].' '.$r['username'].' (id:'.$userid.')',4);
        $total = array();
        $tabparent = array();
        $totalstr = array();
        $result = $db->query_read ("SELECT parentlist,title_clean,forumid FROM ". TABLE_PREFIX ."forum WHERE parentid=-1 ORDER BY forumid");
        while ($r = $db->fetch_array($result))
          {
            $tabparent[] = '%,'.$r['parentlist'];
            $totalstr[] = $r['title_clean'];
          }
        $totalgen = 0;
        $result = $db->query_read ("SELECT COUNT(postid) AS nbmess FROM ". TABLE_PREFIX ."post WHERE visible=1 AND userid=".$userid." GROUP BY userid");
        $r = $db->fetch_array($result);
        $totalcalc = $r['nbmess'] ? $r['nbmess'] : 1;
        
        $forums = array();
        foreach ($vbulletin->forumcache AS $forumid => $forum)
          {
            $forums["$forum[forumid]"] = construct_depth_mark($forum['depth']-1, '- - ') . ' ' . $forum['title'];
          }
        $tab2 = array();
        foreach ($vbulletin->forumcache AS $key => $forum)
          {
            if ($forum['parentid'] == -1) { $tab2[] = $forum['title']; }
          }
        $i = 0;
        foreach ($vbulletin->forumcache AS $key => $forum)
          {
            if ($forum['parentid'] == -1)
              {
                if ($i > 0) { print_cells_row(array('',$vbphrase['category']." : <q>".$tab2[$i-1]."</q>".$last,vb_number_format($total[$i-1],0,false,',',' ')."</span>",vb_number_format($total[$i-1]/$totalcalc*100,2,false,',',' ')." %"),true);  }
                print_table_break();
                $totalgen += $total[$i-1];
                $i++;
                $total[$i] = 0;
                print_cells_row(array($vbphrase['forum'],'',$vbphrase['messages'],$phrase_percentage),1);
              }
            else
              {
                $result = $db->query_read ("SELECT ". TABLE_PREFIX ."forum.parentid,". TABLE_PREFIX ."forum.title, COUNT(". TABLE_PREFIX ."post.postid) AS nbmess
                                    FROM ". TABLE_PREFIX ."post
                                    LEFT JOIN ". TABLE_PREFIX ."thread ON (". TABLE_PREFIX ."post.threadid=". TABLE_PREFIX ."thread.threadid)
                                    LEFT JOIN ". TABLE_PREFIX ."forum ON (". TABLE_PREFIX ."forum.forumid=". TABLE_PREFIX ."thread.forumid)
                                    WHERE ". TABLE_PREFIX ."post.visible=1 and userid=".$userid." AND ". TABLE_PREFIX ."forum.forumid=".$forum['forumid']."
                                    GROUP BY ". TABLE_PREFIX ."thread.forumid");
                $r = $db->fetch_array($result);
                if ($r['parentid'] == -1) {  $last = $forum['title']; }
                $total[$i-1] += $r['nbmess'];         

                $cell = array();
                $cell[] = construct_depth_mark($forum['depth']-1, '- - ') . $forum[title];
                $cell[] = '';
                $cell[] = vb_number_format($r['nbmess'],0,false,',',' ');
                $cell[] = vb_number_format($r['nbmess']/$totalcalc*100,2,false,',',' ')." %";

                print_cells_row($cell,false,false,0,'top',false,true);
              }
          }
        print_cells_row(array('',$vbphrase['category']." : <q>".$tab2[$i-1]."</q>",vb_number_format($total[$i-1],0,false,',',' '),vb_number_format($total[$i-1]/$totalcalc*100,2,false,',',' ')." %"),true);
        print_table_break();
        $totalgen += $total[$i-1];
        print_table_header($vbphrase['total_posts'].' : '.vb_number_format($totalgen,0,false,',',' '),4);     
        
        print_cp_footer();
      }
  }
?>

Module to create using "mod_index_navigation" hook (choose a name you like for this module) :

PHP Code:

construct_nav_spacer();
construct_nav_option('Number of messages', 'usermess.php?');
construct_nav_group('Menu title'); 


I hope you will enjoy this. It's not a great mod, but I think it can be useful or at least handy, though.

Last changes :
v1.2

• Forum list correctly ordered to reflect layout order
• Now showing forum with no messages
• Added new variable for a non-translated text

v1.1

• Replace some hardcoded string with vbphrases
• Correct division by 0 for forums with no posts
• Added cosmetics to display categories headers & footers

[Barakat]

Great , some one put a few wonderful php code the other bring it back with more nice ideas and the 3rd from some place on this planet collect and correct it to be a wonder full hack .
Thanks a lot guys ¤¥installed¥¤

[SaN-DeeP]

very good addon thanks for posting, trying out right now

[hurik]

Originally Posted by becafuel

In fact, I am actually ordering by forumid, which is not the real display order (except on my forum, hence the confusion )
I am working on it but it will take a little longer to code because it's not only a matter of query...

he, you can look in the admincp/forum.php in the line 359, where the "if ($_REQUEST['do'] == 'modify')" stuff is. with this you can see how the vb do the ordering. (sorry my english ...)

[becafuel]

That's what I was planning to do I'm not willing to re-invent the wheel each time...

[ragtek]

hehe
but nice method for the menu
that i don't know until i see it here

[yingzhou]

But. Can you place the code into one xml product? I dont know how to modified PHP.

[yingzhou]

I dont know how to install it?

where to place this code?

Module to create using "mod_index_navigation" hook (choose a name you like for this module) :

PHP Code:
construct_nav_spacer();
construct_nav_option('Number of messages', 'usermess.php?');
construct_nav_group('Menu title');

I hope you will enjoy this. It's not a great mod, but I think it can be useful or at least handy, though.

[becafuel]

In the admin cp, plugin system, add new plugin. You then choose a title for this plugin (the name that you like, it's on your own) and choose mod_index_navigation as hook. Then you place the code in the "Plugin PHP Code" section.
Do not forget to activate the plugin by checking the radio button under this text area

Really, it's simple to do. Easier than .xml file, at least for such a small add-on. XML files are good for bigger projects or admin-only tools, I think.

I'm still currently working on the two last points, but the end of the year is hard for me and my work I do not have much time for this.

[ragtek]

one question

why the menucode is:
construct_nav_spacer();
construct_nav_option('Number of messages', 'usermess.php?');
construct_nav_group('Menu title');

1. the links
2. the "menu"
or doesnt it matter?

[yingzhou]

Originally Posted by Mike-D

becafuel: You know what? Right now I got an idea...

Do you know the hack Top Posters In Month X from Cybernetec? I got the idea to integrate your code with this one. What do you think? Is that possible? I'm goin to start tomorrow to try it. Would you please so kind to help me? Whenever you have time of course. No need to rush -Mike

I like it! Sound very interest. Will wait to try your mod. Thank becafuel, I did it. But can I place the menu into ACP? No need to show it in the ModCP.