nimsgone Posted May 7, 2007 Share Posted May 7, 2007 I have a problem with your contrib..after all changes , when i go to PIN LOADER I cannot see back the pin codes (after restock checked) , any idea ? thanks, nimsgone ok, i answered myself.. for some reason my 'field products_pin_used' format was tiny ... so the order_id wasn't there, i fixed it. Quote Link to comment Share on other sites More sharing options...
nduasi Posted October 10, 2007 Share Posted October 10, 2007 HELP! PLEASE! I've installed this system and it is working, but I can't seem to get the pin numbers after the order has gone through. I didn't receive the download page, it wasn't in my order confirmation and It wasn't on any screen after the order was processed. I just got thrown back to the main catalog page. Is anyone else having this same issue or am I doing something wrong. I have installed this module over 8 times in different servers even tried on my local pc 4 times. Just cant get it to work. PLEASE HELP, PLEASE. Quote Link to comment Share on other sites More sharing options...
spyke100 Posted November 9, 2007 Share Posted November 9, 2007 2 things. 1. I have noticed that under Admin -> Catalog -> Products Attributes, OSC asks for a filename, should i leave this blank or what should i enter? 2. The database table, products_pins does not get updated (ie. the "products_pin_used" column doesnt change from 0 to 1 after checkout_process.php) Any help/ suggestions will be greatly appreciated. Quote Link to comment Share on other sites More sharing options...
spider2 Posted November 15, 2007 Share Posted November 15, 2007 Hi Thanks for the module. But i have commpleted all the steps from the instructions but it is still not working. When i try to browse to pin_loader.php it gives me 500 internal server error. I have installed the new version from os site and them applied yur changes but pin_loader.php is not coming up. I can see the link in my admin (left column) but after clicking nothing works. Please let me know if i am missing anything. Thanks Need some community assistance with testing :) Download at: here. Contribution purpose: make osC suitable for "unique virtual" products selling - PINs, phonecards, etc. How to use: 0. Install. Don't forget to set "Download enabled" and "Check stock". 1. Go to Products Attributes. 2. Create new option "PIN" or smthng like that. 3. Create new option value "Instant delivery" or smthng like that. 4. Add this option/value to product you need and check "Is PIN code" checkbox. 5. Go to Catalog - PIN loader and click Upload. 6. Choose needed product and enter some codes into form field (separated by newlines, spaces, commas or semicolons) and click Update button. Little more explanations: "Update" button in "PIN loader" set products quantity for all products with "Is PIN" attribute according to number of records in products_pins table. "Minimum order status" in Configuration - Download is self explaining i hope. PINs will be showed to customer only if order status equal or greater that value of this option. If you use "instant payment" module - they will see PIN right on "Checkout success" page. Now important warning: ABSOLUTELY NOT FOR REAL USE! TESTING ONLY This mod was NOT passed thru nice testing. PIN codes = money, so you don't want customers get them for free, right? TO DO: 1. Images as PINs (phonecard scans for example). Some trick supposed, cuz they must be stored outside of htdocs. 2. PIN code in order confirmation e-mail. 3. You name it. Waiting for comments. Thanks. Quote Link to comment Share on other sites More sharing options...
ComproBoston Posted December 28, 2007 Share Posted December 28, 2007 Everything seems working but the download page does not appear on order completion. I noticed that Pin Number will be displayed on check-out screen for INSTANT PAYMENT MODULE. How can I test it in OFF LINE Payment Module to display the Pin # on Check Out process (Order Completion). I am trying to put Non Working PIN to test first. Anybody can help me? Quote Link to comment Share on other sites More sharing options...
Guest Posted December 31, 2007 Share Posted December 31, 2007 That's is it. Enjoy. Any questions, problems - post it. -------------------------------------------------------------------------------- I implemented your suggested changes in checkout_process.php, but email sent to customer still doesn't contain the pin code. The count of pin codes in admin page got deducted properly, but email doesn't have the pin code delivered to customer and there was no download page in the email. Any suggestion for troubleshooting? Thanks in advance. Quote Link to comment Share on other sites More sharing options...
Guest Posted January 1, 2008 Share Posted January 1, 2008 That's is it. Enjoy. Any questions, problems - post it. -------------------------------------------------------------------------------- I implemented your suggested changes in checkout_process.php, but email sent to customer still doesn't contain the pin code. The count of pin codes in admin page got deducted properly, but email doesn't have the pin code delivered to customer and there was no download page in the email. Any suggestion for troubleshooting? Thanks in advance. --------------------------------------------------------------------------------- OK, I found my problem! I missed the part that the product attribute & product attribute option need to be set up. Below are the steps if you need it: 1. Go to Products Attributes. 2. Create new option "PIN". 3. Create new option value called "Instant delivery". 4. Add this option/value to product you need and check "Is PIN code" checkbox. 5. Go to Catalog - PIN loader and click Upload. 6. Choose needed product and enter some codes into form field (separated by newlines, spaces, commas or semicolons) and click Update button. But first thing first, download the contribution from http://www.oscommerce.com/community/contributions,3883 and follow the instructions carefully. Thanks for the nice contribution. Suggestions: If the PIN Code Management can be more detail (in table) such as: PIN | Status (avail/sold) | delete (button) or something like that would be very nice. Quote Link to comment Share on other sites More sharing options...
kc8grq Posted February 19, 2008 Share Posted February 19, 2008 Im having some problems. Ive tried to follow this all step-by-step, but I'm getting errors. In my ADMIN panel, under Catalog, the link shows up as this: BOX_CATALOG_PIN_LOADER I also get this error to the right: PIN codes management 1146 - Table 'd60448873.products_pins' doesn't exist SELECT pp.products_id, p.products_quantity AS pcount, count(*) AS all_pin FROM products_pins pp, products p where pp.products_id = p.products_id GROUP BY pp.products_id [TEP STOP] Im not even sure where to start looking to find out where its bad. I dont modify my files, except for this PIN Number system. Quote Link to comment Share on other sites More sharing options...
nayabiya Posted April 1, 2008 Share Posted April 1, 2008 Im having some problems. Ive tried to follow this all step-by-step, but I'm getting errors. In my ADMIN panel, under Catalog, the link shows up as this: BOX_CATALOG_PIN_LOADER I also get this error to the right: PIN codes management 1146 - Table 'd60448873.products_pins' doesn't exist SELECT pp.products_id, p.products_quantity AS pcount, count(*) AS all_pin FROM products_pins pp, products p where pp.products_id = p.products_id GROUP BY pp.products_id [TEP STOP] Im not even sure where to start looking to find out where its bad. I dont modify my files, except for this PIN Number system. Any lack in solving the above problem? I'm a newbie, just joined the forum. I have followed the install instructions but when i click on pin_loader in admin area to upload pins i only get blank page-no error messages. I'm prepard to pay for expert assistance in getting over pin_loader hurdle. Sincerely apologise if i breach forum rules as i'm new and learning. thanking you in advance for your help nayabiya Quote Link to comment Share on other sites More sharing options...
Guest Posted May 28, 2008 Share Posted May 28, 2008 Hi, could be used for serial key in electronics download? Quote Link to comment Share on other sites More sharing options...
allright Posted September 1, 2008 Share Posted September 1, 2008 Hi, I've installed this module and it works fine, appreciate much for the novel design! One of my main concern is worrying about any hacker to attack my system and steal all my phonecard PINs. Are there any security measures recommended to prevent this potential danger happens? Please kindly advise, thank you. Best regards, allright Quote Link to comment Share on other sites More sharing options...
rickyfer Posted June 7, 2010 Share Posted June 7, 2010 (edited) I know this is a old mod, i have installed it and seems properly configured, now im getting this error on checkout_process.php 1146 - Table 'store_name.TABLE_PRODUCTS_PINS' doesn't exist SELECT products_pin_id, products_pin_code FROM TABLE_PRODUCTS_PINS WHERE products_id = '1192{1}1' AND products_pin_used='0' LIMIT 1 TEP_DB_ERRORR Does anyone know why. I am 100% sure the table is created Edited June 7, 2010 by rickyfer Quote Link to comment Share on other sites More sharing options...
marvix Posted August 9, 2010 Share Posted August 9, 2010 Any update regarding this module, is it safe to use it online ? Quote Link to comment Share on other sites More sharing options...
cg180659 Posted August 17, 2010 Share Posted August 17, 2010 i'd like to know the same thing tooo... my product_attributes.php page has gone haywire, and my customers don't recieve emails at all!! Quote SPACE FOR RENT! Link to comment Share on other sites More sharing options...
daniel_villalpando@hotmail Posted November 25, 2013 Share Posted November 25, 2013 Hello, Where i buy or is the full version of this addon ? As is itemm? I run in the oscommerce 2.3.1 the lite version. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.