Note: You must be registered in order to post a reply. To register, click here. Registration is FREE! Before posting, make sure you have read this topic!
T O P I C R E V I E W
skwayb
Posted - 30 January 2007 : 14:35:48 Anybody have some code or an idea of how to track files downloaded from the Forum (i.e. File Library Mod, or any attachments to posts, etc.) and record it to the database.
I would like to be able to track who downloaded what file, when, from where (post, file library, etc.) and then be able to look at their profile (as the admin) and see what files they downloaded (filename, when, post (if it is an attachement), or if it came from the file library.) I tried coding this myself but made a total mess of it. I am a still learning and not a very good programmer.
Any help or examples of how to now when a file was downloaded would be appreciated. <
7 L A T E S T R E P L I E S (Newest First)
MaD2ko0l
Posted - 01 February 2007 : 13:26:57 something like this, you woudl ahve to modify it so it logs the user who downlaoded it
<%
GetIt = Request.QueryString("GET")
mySQL = "UPDATE tblFiles SET Hits = Hits + 1 WHERE Image='" & GetIt & "';"
Conn.Execute(mySQL)
Conn.Close
Response.redirect "Uploads/" & GetIt
%>
hope this helps<
skwayb
Posted - 01 February 2007 : 12:55:20 Thanks MaD2ko0l I found the mod. It looks like something I could modify to work as a download tracker.
Only question I have, how do you tell if a file has been downloaded or not?<
MaD2ko0l
Posted - 30 January 2007 : 17:18:09 i think it was called "Who Viewed This" by Kal Korp?? (Kal Corp/VASMOD) or somthing like that
but i think that there have been similar mods in the past that you coudl have a look for<
skwayb
Posted - 30 January 2007 : 16:22:53 Have a link to it? Is it the 'Who's On' MOD ? I have that one installed. Maybe it will point me in the right direction.<
MaD2ko0l
Posted - 30 January 2007 : 16:14:35 there is a mod called who viewed this or somthign liek that...basically what it does is when someone views a topic it gets logged who has read the topic...maybe you could modify they 2 mods to do what you want it to do.<
skwayb
Posted - 30 January 2007 : 16:10:04 I have the library mod installed but I don't see where it stores who downloaded what file. So I was looking to add that code so I can track who downloaded what file and when.<
AnonJr
Posted - 30 January 2007 : 14:54:55 I think there is still a File Library MOD up on www.snitzbitz.com ... but I don't remember what it does/doesn't do. If nothing else, it could be a good starting point.<