Description: This mod display number of filesize and number of upload/download in postbit.
New queries: 4
File Mod: 3
Template mod: 3
Installation Time: 4-5 mins
##-----------------------------------------
Run Queries: (in AdminCP or phpMyAdmin)
ALTER TABLE `user` ADD `uploadno` SMALLINT( 4 ) DEFAULT '0' NOT NULL ,
ADD `uploadtotal` INT( 15 ) DEFAULT '0' NOT NULL ,
ADD `downloadno` SMALLINT( 4 ) DEFAULT '0' NOT NULL ,
ADD `downloadtotal` INT( 15 ) DEFAULT '0' NOT NULL
##-----------------------------------------
File Modifications
1. Open, includes/functions_showthread.php (1 change)
FIND:
// format posts number
$post['posts'] = vb_number_format($post['posts']);
BELOW, ADD:
// show user upload/download stats by tnguy3n
$getuserstats = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "user WHERE userid = $post[userid]");
while ($userstats = $DB_site->fetch_array($getuserstats)) {
$numupload = $userstats['uploadno'];
$uploadtotal = $userstats['uploadtotal'];
$numdownload = $userstats['downloadno'];
$totaltotal = $userstats['downloadtotal'];
}
// end userstats
2. Open attachment.php (1 change)
FIND:
else
{
// or doing it once an hour
$DB_site->shutdown_query("
INSERT INTO " . TABLE_PREFIX . "attachmentviews (attachmentid)
VALUES ($attachmentinfo[attachmentid])
");
}
BELOW, ADD:
// update user download stats by tnguy3n
$filesize = $attachmentinfo['filesize']/1024;
$DB_site->shutdown_query("
UPDATE " . TABLE_PREFIX . "user
SET downloadno = downloadno + 1
WHERE userid = $bbuserinfo[userid]
");
$DB_site->shutdown_query("
UPDATE " . TABLE_PREFIX . "user
SET downloadtotal = downloadtotal + $filesize
WHERE userid = $bbuserinfo[userid]
");
3. Open newattachment.php (1 change)
FIND:
eval('$attachments .= "' . fetch_template('newattachmentbit') . '";');
BELOW, ADD:
// update user upload stats by tnguy3n
$filesize = intval($attach['filesize']);
$DB_site->shutdown_query("
UPDATE " . TABLE_PREFIX . "user
SET uploadno = uploadno + $attachcount
WHERE userid = $bbuserinfo[userid]
");
$DB_site->shutdown_query("
UPDATE " . TABLE_PREFIX . "user
SET uploadtotal = uploadtotal + $filesize
WHERE userid = $bbuserinfo[userid]
");
##---------------------------------
Template modification:
Open postbit(_legacy): (1 change)
FIND:
$vbphrase[posts]: $post[posts]
BELOW, ADD:
<br />File Upload: $numupload<br />
Total Upload: $uploadtotal KB<br />
File Download: $numdownload<br />
Total Download: $totaltotal KB<br />
<!---------- All done! ---------->
Демо приказало долго жить, у себя не ставил т.к. ещё не решил многих траблов с тем что уже поставил
Upload/Download & Total Upload/Download stats
