Legacy Search by download

[robertkaye]

I purchased a lifetime license in order to get the new Download log feature in 2.4.0.

I need a convenient way of searching for all users who have downloaded a specific download or file.

Reason: To contract everyone when I need to inform of a serious bug.

Thanks!

 

[Fillip H.]

We'll take it into consideration for future versions

 

[robertkaye]

Here's some SQL I currently use. Would be very nice to have his implemented

SELECT DISTINCT email, title, username, usertitle FROM vvdbtech_downloads_download
INNER JOIN vvdbtech_downloads_downloadlog ON vvdbtech_downloads_download.downloadid = vvdbtech_downloads_downloadlog.downloadid
INNER JOIN vvuser ON vvdbtech_downloads_downloadlog.userid = vvuser.userid
WHERE title = 'Name of the download''
ORDER BY vvdbtech_downloads_downloadlog.downloadlogid DESC
LIMIT 0, 1000


Specific file:

SELECT DISTINCT email, username, usertitle FROM vvdbtech_downloads_download
INNER JOIN vvdbtech_downloads_downloadlog ON vvdbtech_downloads_download.downloadid = vvdbtech_downloads_downloadlog.downloadid
INNER JOIN vvuser ON vvdbtech_downloads_downloadlog.userid = vvuser.userid
WHERE fileid = 1292
ORDER BY vvdbtech_downloads_downloadlog.downloadlogid DESC
LIMIT 0, 1000