Show Bid Request 2Checkout.com Payment and Product Download Integration Bid Request Id: 67094 Bookmark in my 'To Do' list Posted by: 1stepahead (6 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 0.00% Buyer Security Verifications: Good Approved on: Jun 6, 2003 4:06:11 AM EDT Bidding Closes: Jun 13, 2003 4:04:54 AM EDT Viewed (by coders): 210 times Deadline: 6/20/2003 TIME EXPIRED Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Very Small Business Project: under $100 (USD) Bidding Type: Open Auction Categories: Perl, PHP Enter chat room for this bid request (0 active users at Aug 21, 2003 4:39:42 AM EDT) Description: I own a company that sells website templates online. My current payment processor is 2checkout.com What I need it this: When someone clicks a “BUY NOW” button on my website, they are sent to 2checkout.com for processing. Once their credit card is processed they are redirected back to my website to a page that looks like this: http://www.mywebsecret.com/payment/sale.htm -This is where you come in. 2checkout.com has passback parameters that enable them to pass sales information from the payment gateway to my website…such as product number, first name, email, etc. I need a program that takes this sales information, stores it in a database so I am able to view purchases from an admin back office, and allows the person that just purchased the ability to download the zip file of the template. All the templates I sell are stored in zip files and all the files are located in a folder on my server. I need the program to start the download by a click of a button…please see the page: http://www.mywebsecret.com/payment/sale.htm to see what the link looks like. This link should only download the zip file of the template they purchased and no others. One of the passback parameters is merchant_product_id, so I can call the zip file the same thing as this product id (ex. merchant_product_id = 14, zip file = 14.zip) This should help in locating the zip file in the specified folder. Also, someone that knows the path to a zip file or the folder where the files are stored should NOT be able to download unless they came from 2checkout.com This helps protect me from people downloading my templates without purchasing. ***Note: I will continue the explanation in the deliverables section below! Deliverables: Obviously, I can not give you access to my payment processor, so someone that has experience with 2checkout.com would be ideal. If not, I can provide you with the passback parameters that are used and a small perl code that can be used to verify that the passback to my site was initiated by 2Checkout This program should be written in either PHP 4.X.X and higher or PERL and use MySQL for the database. To access the database, the login page should look like this: http://www.mywebsecret.com/payment/login.htm Once logged in, I should be able to view all the purchases made from my website on a page like this: http://www.mywebsecret.com/payment/view1.htm I should be able to click on the order number of a purchase and see a detailed purchase page like this: http://www.mywebsecret.com/payment/vieworder.htm On the view1.htm page above there is also a place for me to run a very simple report which shows me the Product Number and the Amount of times it has been purchased. See that page here: http://www.mywebsecret.com/payment/reports.htm That is all I can think of to prepare you for the project. Please feel free to ask me any questions or make any suggestions. 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. Platform: PHP 4.X.X or higher or Perl and MySQL Must be 100% finished and received by buyer on: Jun 20, 2003 EDT Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   This bid was accepted by the buyer! Reliable Penguin (6 ratings) in Charlotte, North Carolina United States Bid id: 718,162   $100 (USD) Jun 6, 2003 9:20:59 AM EDT  7.33 (Good)     Wow - great job laying out the specs for this project! I'm the coder that you need and here's why: 1. My PHP/MySQL skills are very strong. My company, Reliable Penguin, is a MySQL affiliate. I've been coding PHP for 5 years and using MySQL for 6 years. 2. We use 2checkout for payment processing on the reliablepenguin.com web site. After a customer completes the 2checkout forms they are directed back to our site and the sale data is captured to a database.  a. We can do testing with our own 2checkout setup without having access to yours. b. We've solved all the technical issues already so we just need to modify the code to fit your design. 3. For the download, I know a technique that will work very well in preventing unauthorized access. Basically when a sale is completed we copy the zip file to a temp directory created for that user and setup access controls that restrict the download so that that user can access the file. This way it doesn't matter if they know the URL. They can only download the file that they purchased and they can only do the download from the computer that made the purchase. 4. I'm new to Rent-A-Coder but I've been doing web development for over a decade. My first RAC project received a 10 rating. My second project will be completed over the weekend. I'm sure the buyer will be very satisfied. 5. I have immediate availability. The work can be completed within 48 hours of bid acceptance. 6. My bid may not be the lowest but I can give you the greatest value for your investment. I look forward to an opportunity to work with you. Thanks, Lee Blakely Senior Engineer Reliable Penguin            See 2 private reply(ies) to/from Reliable Penguin.