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:

PHP Code:

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:

PHP Code:

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