Suggestions needed for pdf tracking mod

chris33 · 04-06-2005, 01:31 PM

I have a directory full of pdfs that are now indexed and searchable by PhpDig.

I am looking to add a feature whereby when the user clicks on a search result (and consequently downloads a pdf file) a record is kept that that specific file was downloaded.

Then I'll make a separate app (or add it to the PhpDig admin page) that can display stats for all the pdfs (how many times each one was downloaded)

I'm new to PhpDig so I though that I would ask if anyone had a suggestion as to best go about this.

One idea i had :

I can manually edit the database: change the spider.path field for a all the pdf's from "pdf/" to "download.php?file="

download.php would handle the hand-off, writing a row to the DB and sending the user the file.

Is this the way to go about his or is there a better way?

chris33 · 04-06-2005, 01:32 PM

I have a directory full of pdfs that are now indexed and searchable by PhpDig.

I am looking to add a feature whereby when the user clicks on a search result (and consequently downloads a pdf file) a record is kept that that specific file was downloaded.

Then I'll make a separate app (or add it to the PhpDig admin page) that can display stats for all the pdfs (how many times each one was downloaded)

I'm new to PhpDig so I though that I would ask if anyone had a suggestion as to best go about this.

One idea i had :

I can manually edit the database: change the spider.path field for a all the pdf's from "pdf/" to "download.php?file="

download.php would handle the hand-off, writing a row to the DB and sending the user the file.

Is this the way to go about his or is there a better way?

Charter · 04-06-2005, 01:58 PM

Why not just go to the admin panel, click the "Statistics" link and then click the "Last search clicks" link?

chris33 · 04-06-2005, 02:08 PM

Hi, Charter

Well I need to keep a total of how many times each pdf was downloaded. Later I will also need to tag the downloads to specific users and throttle how many they can download.

Charter · 04-06-2005, 03:51 PM

PhpDig doesn't keep track of specific users, but you can get totals by running the following query:

Code:

SELECT count(*),c_url FROM clicks GROUP BY c_url;

GunMuse · 04-22-2005, 02:20 PM

Use your server stats this is not a front side application issue. Awstats will tell you exactly how many downloaded the file. It should be on your server anyway.

04-06-2005, 01:31 PM	#1
chris33 Green Mole Join Date: Apr 2005 Posts: 5	Suggestions needed for pdf tracking mod I have a directory full of pdfs that are now indexed and searchable by PhpDig. I am looking to add a feature whereby when the user clicks on a search result (and consequently downloads a pdf file) a record is kept that that specific file was downloaded. Then I'll make a separate app (or add it to the PhpDig admin page) that can display stats for all the pdfs (how many times each one was downloaded) I'm new to PhpDig so I though that I would ask if anyone had a suggestion as to best go about this. One idea i had : I can manually edit the database: change the spider.path field for a all the pdf's from "pdf/" to "download.php?file=" download.php would handle the hand-off, writing a row to the DB and sending the user the file. Is this the way to go about his or is there a better way?

04-06-2005, 01:32 PM	#2
chris33 Green Mole Join Date: Apr 2005 Posts: 5	Suggestions needed for pdf tracking mod I have a directory full of pdfs that are now indexed and searchable by PhpDig. I am looking to add a feature whereby when the user clicks on a search result (and consequently downloads a pdf file) a record is kept that that specific file was downloaded. Then I'll make a separate app (or add it to the PhpDig admin page) that can display stats for all the pdfs (how many times each one was downloaded) I'm new to PhpDig so I though that I would ask if anyone had a suggestion as to best go about this. One idea i had : I can manually edit the database: change the spider.path field for a all the pdf's from "pdf/" to "download.php?file=" download.php would handle the hand-off, writing a row to the DB and sending the user the file. Is this the way to go about his or is there a better way?

04-06-2005, 01:58 PM	#3
Charter Head Mole Join Date: May 2003 Posts: 2,539	Why not just go to the admin panel, click the "Statistics" link and then click the "Last search clicks" link? __________________ Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.

04-06-2005, 03:51 PM	#5
Charter Head Mole Join Date: May 2003 Posts: 2,539	PhpDig doesn't keep track of specific users, but you can get totals by running the following query: Code: SELECT count(*),c_url FROM clicks GROUP BY c_url; __________________ Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.

04-22-2005, 02:20 PM	#6
GunMuse Green Mole Join Date: Feb 2005 Posts: 24	Use your server stats this is not a front side application issue. Awstats will tell you exactly how many downloaded the file. It should be on your server anyway. __________________ http://www.firebasesoftware.com http://www.gunmuse.com http://www.sharedfeed.com

04-06-2005, 02:08 PM	#4
chris33 Green Mole Join Date: Apr 2005 Posts: 5	Hi, Charter Well I need to keep a total of how many times each pdf was downloaded. Later I will also need to tag the downloads to specific users and throttle how many they can download.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
A few suggestions for a revamp	GunMuse	Feedback & News	1	08-08-2006 05:35 AM
suggestions?	mdrdlp	How-to Forum	3	09-10-2004 11:49 AM
I wrote a mod for indexing pdf without an external binary!!!	caco3	External Binaries	11	07-10-2004 01:08 PM
Some suggestions..	gunwalt	Mod Requests	0	11-06-2003 01:23 PM