Script needed to accept paypal payments and auto registration.

[usalabs3]

I've been running a forum for about a year with free registration, now that my isp has risen their prices, I have to charge a small subscriprion fee, but I can't find a php script that would accept paypal payments for the forum registration, then on an acceptance from the paypal server, the users registration details get entered into the forums database as a registered user, automatically, the script must also keep a record (using a mysql database), of the users details of registration, such as, payment date, etc etc, also the script must be able to send a reminder of re-ocurring payments via email at a set number of days before the next payment is due, and if the payment has not been recieved after a set number of days, the script would disable that users account in the forum, but still keep the records in the forum's database (just incase of the user wanting to re-activate his/her account).

If there is such a script, could someone post the url?

 

[IDTstudios1]

try hotscripts.com and search for "paypal IPN

 

[litton1]

As far as I remember you can create a web page on the paypal site and the direct your customers to it with one of their paypal buttons on your site, this in turn takes them to your account but on the paypal site

Binary Intelligence, true or false?

 

[usalabs3]

As far as I remember you can create a web page on the paypal site and the direct your customers to it with one of their paypal buttons on your site, this in turn takes them to your account but on the paypal site

That isn't really what I'm after, I already have a paypal account, and can utilize a button, but doing that doesn't automatically add the user to the my forum database.

I'm looking for a fully automated php script that will ask the user to complete a registration form containing username, password, and email address to my forum, and upon successful acknowledment from paypal's IPN, the user is then emailed (assuming he/she used a legit email address) the login confirmation, and the details (taken from the registration form) is inserted into my forum's database, then it's upto the user to finish their profile after logging in to my forum. Also, that same script must be able to send email reminders of re-occuring payments on a set number of days, that same script must also be able to set the 'account disable' flag of a users account on my forum if payment has not been recieved after a set number of days. The script must also keep a record (using a mysql database) of the users details, when a user registered, when the payment was accepted/refused.

That's what I'm looking for, and I haven't found it yet, on hotscripts or any other site for php scripts.

It looks like it may be a challenge for php programmers.

 

[litton1]

i see, i have a script knocking about for that. I will have a root around and get back to you

Binary Intelligence, true or false?

 

[usalabs3]

i have a script knocking about for that. I will have a root around and get back to you

Thankx, I'll be looking forward to checking it out.

 

[litton1]

struggling to find it but if you search google with

php paypal ipn integration class

there are some classes under the GNU licence the first link at the top has a class

http://www.phpclasses.org/browse/package/2249.html

Binary Intelligence, true or false?

 

[usalabs3]

That link requires registration, but when I try to register, it tells me the email address is invalid, even though it's an email address I use all the time, and it works fine.

I'm having to shut down my forum until such times as I find a cheaper isp, or I find or someone writes the script I'm looking for.

Thanks for everyones help.

 

[litton1]

i had no probs with it?

<?php 
/******************************************************************************* 
*                      PHP Paypal IPN Integration Class 
******************************************************************************* 
*      Author:     Micah Carrick 
*      Email:      email@micahcarrick.com 
*      Website:    [URL unfurl="true"]http://www.micahcarrick.com[/URL] 
* 
*      File:       paypal.class.php 
*      Version:    1.00 
*      Copyright:  (c) 2005 - Micah Carrick 
*                  You are free to use, distribute, and modify this software 
*                  under the terms of the GNU General Public License.  See the 
*                  included license.txt file. 
*       
******************************************************************************* 
*  VERION HISTORY: 
*   
*      v1.0.0 [04.16.2005] - Initial Version 
* 
******************************************************************************* 
*  DESCRIPTION: 
* 
*      This file provides a neat and simple method to interface with paypal and 
*      The paypal Instant Payment Notification (IPN) interface.  This file is 
*      NOT intended to make the paypal integration "plug 'n' play". It still 
*      requires the developer (that should be you) to understand the paypal 
*      process and know the variables you want/need to pass to paypal to 
*      achieve what you want.   
* 
*      This class handles the submission of an order to paypal aswell as the 
*      processing an Instant Payment Notification. 
*   
*      This code is based on that of the php-toolkit from paypal.  I've taken 
*      the basic principals and put it in to a class so that it is a little 
*      easier--at least for me--to use.  The php-toolkit can be downloaded from 
*      [URL unfurl="true"]http://sourceforge.net/projects/paypal.[/URL] 
*       
*      To submit an order to paypal, have your order form POST to a file with: 
* 
*          $p = new paypal_class; 
*          $p->add_field('business', 'somebody@domain.com'); 
*          $p->add_field('first_name', $_POST['first_name']); 
*          ... (add all your fields in the same manor) 
*          $p->submit_paypal_post(); 
* 
*      To process an IPN, have your IPN processing file contain: 
* 
*          $p = new paypal_class; 
*          if ($p->validate_ipn()) { 
*          ... (IPN is verified.  Details are in the ipn_data() array) 
*          } 
* 
* 
*      In case you are new to paypal, here is some information to help you: 
* 
*      1. Download and read the Merchant User Manual and Integration Guide from 
*         [URL unfurl="true"]http://www.paypal.com/en_US/pdf/integration_guide.pdf.[/URL]  This gives 
*         you all the information you need including the fields you can pass to 
*         paypal (using add_field() with this class) aswell as all the fields 
*         that are returned in an IPN post (stored in the ipn_data() array in 
*         this class).  It also diagrams the entire transaction process. 
* 
*      2. Create a "sandbox" account for a buyer and a seller.  This is just 
*         a test account(s) that allow you to test your site from both the 
*         seller and buyer perspective.  The instructions for this is available 
*         at [URL unfurl="true"]https://developer.paypal.com/[/URL] as well as a great forum where you 
*         can ask all your paypal integration questions.  Make sure you follow 
*         all the directions in setting up a sandbox test environment, including 
*         the addition of fake bank accounts and credit cards. 
* 
******************************************************************************* 
*/ 

class paypal_class { 
     
   var $last_error;                 // holds the last error encountered 
    
   var $ipn_log;                    // bool: log IPN results to text file? 
   var $ipn_log_file;               // filename of the IPN log 
   var $ipn_response;               // holds the IPN response from paypal    
   var $ipn_data = array();         // array contains the POST values for IPN 
    
   var $fields = array();           // array holds the fields to submit to paypal 

    
   function paypal_class() { 
        
      // initialization constructor.  Called when class is created. 
       
      $this->paypal_url = '[URL unfurl="true"]https://www.paypal.com/cgi-bin/webscr';[/URL] 
       
      $this->last_error = ''; 
       
      $this->ipn_log_file = 'ipn_log.txt'; 
      $this->ipn_log = true; 
      $this->ipn_response = ''; 
       
      // populate $fields array with a few default values.  See the paypal 
      // documentation for a list of fields and their data types. These defaul 
      // values can be overwritten by the calling script. 

      $this->add_field('rm','2');           // Return method = POST 
      $this->add_field('cmd','_xclick'); 
       
   } 
    
   function add_field($field, $value) { 
       
      // adds a key=>value pair to the fields array, which is what will be 
      // sent to paypal as POST variables.  If the value is already in the 
      // array, it will be overwritten. 
       
      $this->fields["$field"] = $value; 
   } 

   function submit_paypal_post() { 

      // this function actually generates an entire HTML page consisting of 
      // a form with hidden elements which is submitted to paypal via the 
      // BODY element's onLoad attribute.  We do this so that you can validate 
      // any POST vars from you custom form before submitting to paypal.  So 
      // basically, you'll have your own form which is submitted to your script 
      // to validate the data, which in turn calls this function to create 
      // another hidden form and submit to paypal. 

      // The user will briefly see a message on the screen that reads: 
      // "Please wait, your order is being processed..." and then immediately 
      // is redirected to paypal. 

      echo "<html>n"; 
      echo "<head><title>Processing Payment...</title></head>n"; 
      echo "<body onLoad="document.form.submit();">n"; 
      echo "<center><h3>Please wait, your order is being processed...</h3></center>n"; 
      echo "<form method="post" name="form" action="".$this->paypal_url."">n"; 

      foreach ($this->fields as $name => $value) { 
         echo "<input type="hidden" name="$name" value="$value">"; 
      } 

      echo "</form>n"; 
      echo "</body></html>n"; 
     
   } 
    
   function validate_ipn() { 

      // parse the paypal URL 
      $url_parsed=parse_url($this->paypal_url);         

      // generate the post string from the _POST vars aswell as load the 
      // _POST vars into an arry so we can play with them from the calling 
      // script. 
      $post_string = '';     
      foreach ($_POST as $field=>$value) { 
         $this->ipn_data["$field"] = $value; 
         $post_string .= $field.'='.urlencode($value).'&'; 
      } 
      $post_string.="cmd=_notify-validate"; // append ipn command 

      // open the connection to paypal 
      $fp = fsockopen($url_parsed[host],"80",$err_num,$err_str,30); 
      if(!$fp) { 
           
         // could not open the connection.  If loggin is on, the error message 
         // will be in the log. 
         $this->last_error = "fsockopen error no. $errnum: $errstr"; 
         $this->log_ipn_results(false);        
         return false; 
          
      } else { 

         // Post the data back to paypal 
         fputs($fp, "POST $url_parsed[path] HTTP/1.1rn"); 
         fputs($fp, "Host: $url_parsed[host]rn"); 
         fputs($fp, "Content-type: application/x-[URL unfurl="true"]www-form-urlencodedrn");[/URL] 
         fputs($fp, "Content-length: ".strlen($post_string)."rn"); 
         fputs($fp, "Connection: closernrn"); 
         fputs($fp, $post_string . "rnrn"); 

         // loop through the response from the server and append to variable 
         while(!feof($fp)) { 
            $this->ipn_response .= fgets($fp, 1024); 
         } 

         fclose($fp); // close connection 

      } 
       
      if (eregi("VERIFIED",$this->ipn_response)) { 
   
         // Valid IPN transaction. 
         $this->log_ipn_results(true); 
         return true;        
          
      } else { 
   
         // Invalid IPN transaction.  Check the log for details. 
         $this->last_error = 'IPN Validation Failed.'; 
         $this->log_ipn_results(false);    
         return false; 
          
      } 
       
   } 
    
   function log_ipn_results($success) { 
        
      if (!$this->ipn_log) return;  // is logging turned off? 
       
      // Timestamp 
      $text = '['.date('m/d/Y g:i A').'] - '; 
       
      // Success or failure being logged? 
      if ($success) $text .= "SUCCESS!n"; 
      else $text .= 'FAIL: '.$this->last_error."n"; 
       
      // Log the POST variables 
      $text .= "IPN POST Vars from Paypal:n"; 
      foreach ($this->ipn_data as $key=>$value) { 
         $text .= "$key=$value, "; 
      } 

      // Log the response from the paypal server 
      $text .= "nIPN Response from Paypal Server:n ".$this->ipn_response; 
       
      // Write to log 
      $fp=fopen($this->ipn_log_file,'a'); 
      fwrite($fp, $text . "nn"); 

      fclose($fp);  // close file 
   } 

   function dump_fields() { 

      // Used for debugging, this function will output all the field/value pairs 
      // that are currently defined in the instance of the class using the 
      // add_field() function. 
       
      echo "<h3>paypal_class->dump_fields() Output:</h3>"; 
      echo "<table width="95%" border="1" cellpadding="2" cellspacing="0"> 
            <tr> 
               <td bgcolor="black"><b><font color="white">Field Name</font></b></td> 
               <td bgcolor="black"><b><font color="white">Value</font></b></td> 
            </tr>"; 
       
      ksort($this->fields); 
      foreach ($this->fields as $key => $value) { 
         echo "<tr><td>$key</td><td>".urldecode($value)."&nbsp;</td></tr>"; 
      } 

      echo "</table><br>"; 
   } 
}

Binary Intelligence, true or false?

 

[usalabs3]

ok, that settles the IPN part, but I still need a registration script that will call the IPN script when the user has completed the registration, (after checking for email validation), then process the return from the IPN script and upon successfull acceptence from Paypal's IPN system, the registration script would add the users details (from the registration script) to my phpBB database in the correct order, (username, password, name, and email address), and add the users details along with the date of payment recieved to a seperate table in a different database, then set the 'account active' flag of the phpBB database to 'active', which would automatically create the account for that user, then all the user has to do, is login, then change their profile as needed, then, a system service would monitor the 'payment recieved date' and 'paid' fields, and compare it to the system date, and if the 'paid' field is 'N' and if over a set number of days, the service would read each of the 'users email' fields, and send them a reminder that payment is due, and when payment is recieved, the 'paid' flag is set and date of payment recieved is entered in the 'payment recieved date' field in a database, but, if payment is not recieved by a set number of days, the service would set the 'account active' flag of that particular user, to 'disable', thus preventing that user from logging in until payment has been recieved.

 

[litton1]

i am sorry but tek-tips is not a code writing service, there are many examples of database queries and tutorials on php on the net. If you get stuck then please come back and post your error and someone will help you to solve that problem.

Binary Intelligence, true or false?

 

[BitFuzzy]

litton1 is quite correct, I don't think tek-tips was ever intended to provide coding services.

However I'm sure if you offered a little green, you'd get some takers

Google can be your friend, introduce yourself.

alternatly you could take a look at

http://www.rentacoder.com