Extension talk:PayPal.php
Installation
To install the extension, just save the code into your extensions directory as usual and include it from your LocalSettings.php file. You should also create a file of the same name as the extension but with the .log file-extension instead of .php (e.g. PayPal.log) and make it writable by the web server to allow IPN responses or debugging information to be logged there.
To test IPN, see PayPal for how to set up a paypal test environment, and then enable the IPN functionality and create your forms as in the following LocalSettings.php example:
Creating a form
The following couple of lines of wikitext will render the two forms defined in LocalSettings above. The parameter supplied is the text which will be rendered along with the form (if the first characters of the text are a number followed by a space, then the number is treated as the number of the form which should be rendered). If IPN is enabled then this text should contain tokens $1, $2 and $3 which will be replaced respectively by total amount donated, total number of donations made and the current state of the transaction (if returning from paypal after purchase - empty otherwise).
<paypal>There have been $2 donations totalling $$1. $3</paypal> <paypal>2 There have been $2 donations totalling $$1. $3</paypal>
- The $$1 is just to put a dollar symbol before the total amount donated
IPN Database Table
The transactions are stored in a database table called templatePayPalIPN which is structured as follows:
+------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+---------------+------+-----+---------+-------+ | ipn_id | varchar(32) | NO | PRI | | | | ipn_date | tinytext | YES | | NULL | | | ipn_item | int(11) | NO | | | | | ipn_from | tinytext | YES | | NULL | | | ipn_amount | decimal(10,0) | YES | | NULL | | | ipn_status | tinytext | YES | | NULL | | +------------+---------------+------+-----+---------+-------+
Here is an example of the tables content after it has been populated with some paypal sandbox transactions made from the form examples shown above:
+-------------------+---------------------------+----------+-------------------------------+------------+------------+ | ipn_id | ipn_date | ipn_item | ipn_from | ipn_amount | ipn_status | +-------------------+---------------------------+----------+-------------------------------+------------+------------+ | 6C047440J05621040 | 15:11:38 Dec 12, 2007 PST | 1 | donations@organicdesign.co.nz | 22 | Completed | | 23M49673DB6083320 | 17:00:51 Dec 12, 2007 PST | 1 | donations@organicdesign.co.nz | 8 | Completed | | 18183268SP9363925 | 17:03:16 Dec 12, 2007 PST | 1 | donations@organicdesign.co.nz | 33 | Completed | | 7U934835WE0858113 | 17:06:54 Dec 12, 2007 PST | 1 | donations@organicdesign.co.nz | 21 | Completed | | 68W35106NH479463N | 17:16:52 Dec 12, 2007 PST | 1 | donations@organicdesign.co.nz | 12 | Completed | | 83A03941MM395870F | 17:19:33 Dec 12, 2007 PST | 1 | donations@organicdesign.co.nz | 22 | Completed | | 44384998LU7025730 | 17:22:12 Dec 12, 2007 PST | 1 | donations@organicdesign.co.nz | 22 | Pending | | 3Y781051NB0709135 | 17:37:27 Dec 12, 2007 PST | 2 | donations@organicdesign.co.nz | 44 | Completed | +-------------------+---------------------------+----------+-------------------------------+------------+------------+
AJAX Updater
After a transaction has been made from one of the forms, and the payer returns to the wiki after clicking the "return to merchant" link, the page will include a JS function to keep polling the server to check the status of the transaction that was just made. It will keep polling until the returned status is "Completed". The totals will not be updated until the transaction is completed - but note that the instant transactions are usually completed before the "return to merchant" link is clicked, but slower payments such as e-checks will remain in "pending" state for a few days.
