PM Count

##############################################################
## MOD Title: count pm
## MOD Author: emrag < emrah987@hotmail.com > (Emrah Türkmen)  www.canver.net
## MOD Description: this hack will show how many messages are there in
##          inbox, outbox, sentbox and savebox.
##
##
##      ---------------------------------------------------------
##      -                     -
##      -    INBOX       OUTBOX       SENTBOX       SAVEBOX   -
##      -                     -
##      ---------- change to ------------------------------------
##      -                     -
##      -    INBOX (3)   OUTBOX (1)   SENTBOX (0)   SAVEBOX (5) -
##      -                     -
##      ---------------------------------------------------------
##
##
## MOD Version: 1.0.1
##
## Installation Level: easy
## Installation Time : ~3 minutes
## Files to Edit: privmsg.php   
##        templates/subSilver/privmsgs_body.tpl
##
## Included Files: n/a
##############################################################
##
## Author Notes: -
##
##############################################################
##
## MOD History: ??.??.2004 - 1.0.0
##      - First release
##
##      10.01.2005 - 1.0.1
##      - cleaned extra codes
##
##############################################################
##
## Before Adding This Hack To Your Forum, You Should Back Up All Files Related To This Hack 
##
##############################################################
#
#-----[ OPEN ]------------------------------------------
#

privmsg.php

#
#----[ FIND ]------------------------------------------
#

$sql .= $limit_msg_time . " ORDER BY pm.privmsgs_date DESC LIMIT $start, " . $board_config['topics_per_page'];
$sql_all_tot = $sql_tot;
$sql_tot .= $limit_msg_time_total;

#
#-----[ AFTER, ADD ]------------------------------------------
#

//
// count pm by emrag
//
$total_inbox = '';
$total_sentbox = '';
$total_outbox = '';
$total_savebox = '';

for ($i = 1; $i < 5; $i++)
{

$sql1 = sql_.$i;
$sql2 = sql_.$i;

$tot = tot_.$i;

$$sql1 = "SELECT COUNT(privmsgs_id) AS $tot
   FROM " . PRIVMSGS_TABLE . " ";

// inbox (1)
      $sql_1 .= "WHERE privmsgs_to_userid = " . $userdata['user_id'] . "
         AND ( privmsgs_type =  " . PRIVMSGS_NEW_MAIL . "
            OR privmsgs_type = " . PRIVMSGS_READ_MAIL . "
            OR privmsgs_type = " . PRIVMSGS_UNREAD_MAIL . " )";

// sentbox (2)
      $sql_2 .= "WHERE privmsgs_from_userid = " . $userdata['user_id'] . "
         AND privmsgs_type =  " . PRIVMSGS_SENT_MAIL;

// outbox (3)
      $sql_3 .= "WHERE privmsgs_from_userid = " . $userdata['user_id'] . "
         AND ( privmsgs_type =  " . PRIVMSGS_NEW_MAIL . "
            OR privmsgs_type = " . PRIVMSGS_UNREAD_MAIL . " )";

// savebox (4)
      $sql_4 .= "WHERE ( ( privmsgs_to_userid = " . $userdata['user_id'] . "
            AND privmsgs_type = " . PRIVMSGS_SAVED_IN_MAIL . " )
         OR ( privmsgs_from_userid = " . $userdata['user_id'] . "
            AND privmsgs_type = " . PRIVMSGS_SAVED_OUT_MAIL . ") )";

if ( !($result1 = $db->sql_query($$sql2)) )
{
   message_die(GENERAL_ERROR, 'Could not query forum PM information', '', __LINE__, __FILE__, $sql_tot_pm_savebox);
}

while ($row1 = $db->sql_fetchrow($result1))
{
$total_inbox .= $row1['tot_1'];
$total_sentbox .= $row1['tot_2'];
$total_outbox .= $row1['tot_3'];
$total_savebox .= $row1['tot_4'];
}

}
//
// count pm by emrag
//

#
#----[ FIND ]------------------------------------------
#

   'POST_PM_IMG' => $post_pm_img,
   'POST_PM' => $post_pm,

#
#-----[ BEFORE, ADD ]------------------------------------------
#

   'TOTAL_INBOX' => $total_inbox,
   'TOTAL_SENTBOX' => $total_sentbox,
   'TOTAL_OUTBOX' => $total_outbox,
   'TOTAL_SAVEBOX' => $total_savebox,

#
#-----[ OPEN ]------------------------------------------
#

privmsgs_body.tpl

#
#----[ FIND ]------------------------------------------
#
# if your theme isn't subsilver you will not find below part
# so find these 4 parts and replace
#
# {INBOX} &nbsp;    -- replace with -->  {INBOX} &nbsp;({TOTAL_INBOX})&nbsp;
# {SENTBOX} &nbsp;  -- replace with -->  {SENTBOX} &nbsp;({TOTAL_SENTBOX})&nbsp;
# {OUTBOX} &nbsp;   -- replace with -->  {OUTBOX} &nbsp;({TOTAL_OUTBOX})&nbsp;
# {SAVEBOX} &nbsp;  -- replace with -->  {SAVEBOX} &nbsp;({TOTAL_SAVEBOX})&nbsp;
#
#

     <table height="40" cellspacing="2" cellpadding="2" border="0">
      <tr valign="middle">
        <td>{INBOX_IMG}</td>
        <td><span class="cattitle">{INBOX} &nbsp;</span></td>
        <td>{SENTBOX_IMG}</td>
        <td><span class="cattitle">{SENTBOX} &nbsp;</span></td>
        <td>{OUTBOX_IMG}</td>
        <td><span class="cattitle">{OUTBOX} &nbsp;</span></td>
        <td>{SAVEBOX_IMG}</td>
        <td><span class="cattitle">{SAVEBOX} &nbsp;</span></td>
      </tr>
     </table>

#
#----[ REPLACE WITH ]------------------------------------------
#

     <table height="40" cellspacing="2" cellpadding="2" border="0">
      <tr valign="middle">
        <td>{INBOX_IMG}</td>
        <td><span class="cattitle">{INBOX} &nbsp;({TOTAL_INBOX})&nbsp;</span></td>
        <td>{SENTBOX_IMG}</td>
        <td><span class="cattitle">{SENTBOX} &nbsp;({TOTAL_SENTBOX})&nbsp;</span></td>
        <td>{OUTBOX_IMG}</td>
        <td><span class="cattitle">{OUTBOX} &nbsp;({TOTAL_OUTBOX})&nbsp;</span></td>
        <td>{SAVEBOX_IMG}</td>
        <td><span class="cattitle">{SAVEBOX} &nbsp;({TOTAL_SAVEBOX})&nbsp;</span></td>
      </tr>
     </table>

#
#-----[ SAVE ALL FILES/CLOSE ]------------------------------------------
#
#