|
 | | |
| Autor | Správa |
|---|
JanoF
Správca fóra
Založený: 01.05.2005
Príspevky: 8736
Bydlisko: Bratislava
Vek: 27
 |  Zaslal: So 14.10.06 15:06 |   |
| kód: | ##############################################################
## 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} -- replace with --> {INBOX} ({TOTAL_INBOX})
# {SENTBOX} -- replace with --> {SENTBOX} ({TOTAL_SENTBOX})
# {OUTBOX} -- replace with --> {OUTBOX} ({TOTAL_OUTBOX})
# {SAVEBOX} -- replace with --> {SAVEBOX} ({TOTAL_SAVEBOX})
#
#
<table height="40" cellspacing="2" cellpadding="2" border="0">
<tr valign="middle">
<td>{INBOX_IMG}</td>
<td><span class="cattitle">{INBOX} </span></td>
<td>{SENTBOX_IMG}</td>
<td><span class="cattitle">{SENTBOX} </span></td>
<td>{OUTBOX_IMG}</td>
<td><span class="cattitle">{OUTBOX} </span></td>
<td>{SAVEBOX_IMG}</td>
<td><span class="cattitle">{SAVEBOX} </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} ({TOTAL_INBOX}) </span></td>
<td>{SENTBOX_IMG}</td>
<td><span class="cattitle">{SENTBOX} ({TOTAL_SENTBOX}) </span></td>
<td>{OUTBOX_IMG}</td>
<td><span class="cattitle">{OUTBOX} ({TOTAL_OUTBOX}) </span></td>
<td>{SAVEBOX_IMG}</td>
<td><span class="cattitle">{SAVEBOX} ({TOTAL_SAVEBOX}) </span></td>
</tr>
</table>
#
#-----[ SAVE ALL FILES/CLOSE ]------------------------------------------
#
# |
|
_________________
Skrinka: Nexus Morpho & Enermax UCTB12P | Zdroj: Enermax EMG800AWT 800W | Základná doska: Asus Rampage III Gene | Procesor: Intel Core i7 990X Extreme Edition 3.46 GHz & Scythe Susanoo SCSO-1000 | Pamäť: Kingston HyperX XMP 24 GB DDR3 1600 MHz | Grafická karta: Asus GeForce GT 440 1 GB DDR3 & Thermalright HR-03 | Pevný disk: Intel SSD 510 Series 250 GB & Hitachi Deskstar 5K4000 4000 GB | Optická mechanika: Plextor PX-820SA | Čítačka kariet: Akasa AK-ICR-11 | Klávesnica: Logitech G19 | Myš: Logitech G9x & Razer Kabuto | Monitor: 24" LCD Eizo FlexScan S2431WE | Reproduktory: Logitech Z-2300 | Operačný systém: Microsoft Windows 7 & FreeBSD 9 | Záložný zdroj: APC Back-UPS ES 700 | Spotreba: Idle - 200W / Burn - 400W | Mobil: Nokia N9 64 GB | |
       |
|
|
Nemôžete pridávať nové témy do tohto fóra.
Nemôžete odpovedať na témy v tomto fóre.
Nemôžete upravovať svoje príspevky v tomto fóre.
Nemôžete mazať svoje príspevky v tomto fóre.
Nemôžete hlasovať v tomto fóre.
|
| |
