Download Tracker Modification

[PWolfrum]

Hello,

under vBulletin 3.0.x I have used a variation of the "Who Downloaded"-Mod from Rein Masamuri (https://vborg.vbsupport.ru/showthread.php?t=60500 ) for writing the Attachment-ID, User-ID and a timestamp to a database-table everytime a user downloads a file.
The modification was built into attachment.php.

Before the modification:


if ($vboptions['attachmentviewslive'])
{
// doing it as they happen
$DB_site->shutdown_query("
UPDATE " . TABLE_PREFIX . "attachment
SET counter = counter + 1
WHERE attachmentid = $attachmentid
");
}
else
{
// or doing it once an hour
$DB_site->shutdown_query("
I INSERT INTO " . TABLE_PREFIX . "attachmentviews (attachmentid)
VALUES ($attachmentid)
");
}


After the modification:

if ($vboptions['attachmentviewslive'])
{
// doing it as they happen
$DB_site->shutdown_query("
UPDATE " . TABLE_PREFIX . "attachment
SET counter = counter + 1
WHERE attachmentid = $attachmentid
");
}
else
{
// or doing it once an hour
$DB_site->shutdown_query("
INSERT INTO " . TABLE_PREFIX . "attachmentviews (attachmentid)
VALUES ($attachmentid)
");
}

//whois download attachment
$comma = ($bbuserinfo[downloads]) ? ',' : '';
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "dltrack (attachment_id, username) VALUES('$attachmentid','$bbuserinfo[userid]')");
//whois download attachment


As I tried to build this MOD in the attachment.php of vBulletin 3.5 (Gold), it seems to work in so far as there are no error-messages shown; but, there is also no data written to the database-table (according to my database-server logfile, there aren't any corresponding queries either).

I am now not sure, whether the MOD is now at a wrong place in the new attachment.php, or if the variable-handling of vBulletin 3.5 has changed so much, that it won't work at all.
In each case I would be very grateful for any advice that can be given in order to get this MOD working again.

Thank you very much in advance.

With best regards,
Patrique Wolfrum