L.A.M.P (Linux,Apache,MySql, PHP) Web project to Serve uniquely watermarked
files from a virtual database driven directory structure.
1) Serve branded PDF directly,
2) Serve multiple branded files that are packed into one zip
We are using quick on the fly character substitution before serving files.
Record and limit specific file serving to x times before cutting off.
Here is a proposed database and process to accomplish this:
MySQL Database
Table: FileLocation
Columns:
REFid (Integer sequential unique)
IDcode 8char
DirectoryName (Varchar)
FileName Varchar
RequestCount
Table: FileDetails
Columns
RefID
FileName (varchar)
CharOffset1 (integer)
CharOffset2 (integer)
Process
Location
Table: SpecificFiles (Only used for Process 2 below)
Columns
RefID
FileDetailsRefID
FileName
CharOffset1 (integer)
CharOffset2 (integer)
===
Storage of files in nonweb accessable dir
PROCESS
1) Web user request for pdf file: [PDF “Process”]
example: www.mysite.com/download/fj439923FekFe94/MyFile.pdf
Format: www.mysite.com/download/{DirectoryName}/{FileName}
System takes pdf file from storage, process “pdf”
Location non web directory.
modifies it by substituting IDcode at two predefined CharOffset1 (&..2)
locations.
If “requestcount” is less than 10,
Virtually serve the modified file using /{DirectoryName}/MyFile.pdf
“RequestCount” is incremented
2) Web user request for zip file: [ZIP “Process”
example: www.mysite.com/download/fj439923FekFe94/MyFile.zip
Format: www.mysite.com/download/{DirectoryName}/{FileName}
System looks at “process”, sees it as “ZIP” process
System takes each file in “Location” shown by the lookup
in the Specific Files table and does two CharOffset substitutions
with the “IDCode”
The resulting files are then zipped to “FileName” zip file.
If “requestcount” is less than 10,
then Virtually serve using {DirectoryName}/MyFile.zip
“RequestCount” is incremented
Temp files are deleted.
SAMPLE DATA
TABLE: FileLocation
REFid, IDcode, DirectoryName, FileName, RequestCount
10 , ABC123, Dkef48dsdflfy, MyPDF1.pdf, 0
11 , DEF3fa, Dkef48dsdflfy, MyZIP1.zip, 0
TABLE: FileDetails
RefID, FileName, CharOffset1, CharOffset2, Process, Location
1, MyPDF1.pdf, 12345678, 4636663, PDF, /web/tmp/
2, MyPDF2.pdf, 42345678, 8636663, PDF, /web/tmp/
3, MyZIP3.zip, 0, 0, ZIP, /web/tmp/
TABLE: SpecificFiles
RefID, FileDetailsID, FileName, CharOffset1, CharOffset2
7, 3 , file1.doc, 23424234, 1231233
8, 3 , file2.doc, 98424234, 3444333
9, 3 , file3.doc, 23424234, 6641253
We need this work complete as soon as possible.. “ASAP” How soon can you deliver?
