lewis1111 Posted March 28, 2006 Posted March 28, 2006 Does anyone know of a contribution that will help me send unique licence keys for downloadable products. I want to update the keys directly in SQL. Each time someone makes a downloadable order it would then send them an email with the relevant number of licences. It would then mark those keys so they do not get reused. It sounds simple when I write it but i'm not sure how to get checkout_process.php to work which products are downloadable, what their product ids are, and how many licences to include in the confirmation email. If anyone could help i'd be really grateful.
Guest Posted March 28, 2006 Posted March 28, 2006 not aware of a contribution but you could do few things to create this functionality. - Create a new column for the products_attributes_download table to be used for the serials. - Use a seed to generate the serial numbers so the no initial serial numbers are necessary. - For each download store the created number in the dbase so next time you can check the newly created number against the stored ones. If you combine your seed with the current time the odds of hitting the same number are minimum. - Finally append the serial to the email information send to the customer when the order is approved via the admin.
lewis1111 Posted March 29, 2006 Author Posted March 29, 2006 thanks for your suggestion... the only thing i didn't mention was that the product keys are provided by the software provider so i cannot make up my own as they won't work with the software.
Guest Posted March 29, 2006 Posted March 29, 2006 I see, I thought you were the vendor. Well then you get rid of the seed and insert the numbers into the dbase. And you add one extra column for the products_attributes_download table (plus the serial number one) to mark/check each serial that is published. So your sql query will check the serial number status and if nothing comes back from the dbase you could even put the item out of stock automatically.
JEWbacca Posted March 29, 2006 Posted March 29, 2006 You might want to take a look at this contribution -- http://www.oscommerce.com/community/contributions,3883 While it says that it should not be used for production, in the development thread a couple of people have posted about using it and it working well for them -- http://www.oscommerce.com/forums/index.php?showtopic=186485 Good Luck, Nate
lewis1111 Posted May 10, 2006 Author Posted May 10, 2006 In the end I wrote my own contribution, which I added to checkout_process.php - thanks for your help.
chirag11 Posted November 2, 2007 Posted November 2, 2007 lewis1111 - I am building a site where I will sell software with unique license keys. Sounds like what you have is similar if not exactly what I need. Did you load your contribution in the contrib section? Is not can you post the code I need to enable such functionality? Thanks In the end I wrote my own contribution, which I added to checkout_process.php - thanks for your help.
jherrer2 Posted July 9, 2008 Posted July 9, 2008 In the end I wrote my own contribution, which I added to checkout_process.php - thanks for your help. Is it possible to get this contribution?
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.