I have an existing PHP script that takes a _GET variable (an md5 hash), compares it with the mySQL database and finds the font .ttf file. It then creates a .zip file on the fly with the font file enclosed (it doesnt store the zip anywhere on my server).
Everything above is already complete.
Basically, I need it to get the author id from the font row, find the author from the author table based on that id, pull the "description" column from the author's row, and create a [url removed, login to view] file on the fly with that data and enclose it along with the font in the zip.
So the script should function like...
1. [Already Complete and Working]
a) User clicks on "Download AnimeAce"
[url removed, login to view]
b) Script takes the hash and matches it with the font row, $row[fontpath] is fonts/a/[url removed, login to view], add that to the zip.
2. [This is what you will add]
a) $row[aid] is 67
b) 67 matches with "BlamBot" on the author table
c) $row[description] on BlamBot is "Please visit our website at blambot dot com"
d) Script adds [url removed, login to view] to the zip with the contents "Please visit our website at blambot dot com".
Easy enough? I've attached the script for reference.