-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Sheryl --
...and then Sheryl Canter said... % % I have a big problem to solve on my site, and I'm not sure how to approach % it. I'm selling software that's distributed as trialware (will be--haven't Best of luck! :-) % launched yet). Users will be able to unlock the time-limited versions with a % license. I want to send the license to the user after her payment has been % received, but here's the rub: I'm not handling the payments myself. I'm No problem. How would you have handled it if you had anyway? :-) % using 2Checkout.com and possibly PayPal. 2Checkout will send me a confirming % email message when an order has been completed, but I don't want to have to % manually generate and mail out licenses. Right. % % There's been mention here about email somehow being redirected into a MySQL % database. I'm not sure how that works. Is there any way that I can somehow % redirect the 2Checkout.com notifications to my database and act on the event % of receiving this email? I don't know how else the process could possibly be % automated. Rather than trying to feed email directly to a script, just have your MDA deliver to a program. That program will be some script that catches and parses the email, sees what user just paid (and anything else it needs to capture), and then makes the call to the database so that your script does whatever you need to do to generate the license and update the DB and so on -- and then it should probably send the email to the user, too! % % Any ideas would be greatly appreciated. HTH & HAND % % - Sheryl mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+bPKfGb7uCXufRwARAuC3AJ93DfAZp8HpElJ4Epr/I+IDjeomQwCgoR6H AzOjj6NYF+Ni2S1cRgwbw0w= =ZgOQ -----END PGP SIGNATURE----- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
