PaypalDonationExtension
From PeacockWiki
(Difference between revisions)
Revision as of 00:40, 7 April 2007 (edit) Trevorp (Talk | contribs) ← Previous diff |
Revision as of 01:47, 7 April 2007 (edit) Trevorp (Talk | contribs) (→Database) Next diff → |
||
Line 57: | Line 57: | ||
`payment_date` datetime NOT NULL default '0000-00-00 00:00:00', | `payment_date` datetime NOT NULL default '0000-00-00 00:00:00', | ||
`payment_gross` double NOT NULL default '0', | `payment_gross` double NOT NULL default '0', | ||
- | `payer_email` double NOT NULL default '0', | + | `payer_email` text NOT NULL, |
`mc_fee` double NOT NULL default '0', | `mc_fee` double NOT NULL default '0', | ||
`mc_gross` double NOT NULL default '0', | `mc_gross` double NOT NULL default '0', | ||
`country` text NOT NULL, | `country` text NOT NULL, | ||
PRIMARY KEY (`item_number`) | PRIMARY KEY (`item_number`) | ||
- | ) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;</pre> | + | ) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;</pre> |
==Usage== | ==Usage== |
Revision as of 01:47, 7 April 2007
PaypalDonationExtension is an extension for Mediawiki that provides users a form allowing them to make a payment via PayPal.
Contents |
Details
- Version 0.0
- Date 5 Apr 2007
- Tested on MediaWiki 1.7.1, PHP 5.1.6 (apache2handler), MySQL 5.0.24a-Debian_9ubuntu0.1-log
Features
- Allows users to complete a form allowing them to make a payment via PayPal.
- Provides other features through other extensions:
Design
+--------+ +------+ | PayPal | | List | +--------+ +------+ | / +------+ +-----+ +=====+ +-----+ +=====+ +-----+ | Wiki |---| PPE |----= API =---| FRE |---= API =---| Ind | +------+ +-----+ +=====+ +-----+ +=====+ +-----+ | | +----------+ +----------+ | Database | | Database | +----------+ +----------+
- PPE Paypal Donation Extension
- Facilitates paypal donations, and recording of transactions
- Provides an API to allow access to donation info
- List
- Public list of donors
- Private list of own contributions
- FRE Financial Reports Extension
- Allows treasurer to enter financial details
- Retrieves data from donations and provides (monthly) reports on financial status
- Provides an API to allow information to be used for status indicators, other reporting engnes etc.
- Ind Indicators/progress bars etc.
Database
CREATE TABLE `wiki`.`donations` ( `item_number` int(11) NOT NULL auto_increment, `user_id` text NOT NULL, `request_time` datetime NOT NULL default '0000-00-00 00:00:00', `firstname` text NOT NULL, `lastname` text NOT NULL, `address1` text NOT NULL, `address2` text NOT NULL, `city` text NOT NULL, `state` text NOT NULL, `zip` text NOT NULL, `email` text NOT NULL, `amount` double NOT NULL default '0', `comment` text NOT NULL, `anonymous` tinyint(1) NOT NULL default '0', `validated` tinyint(1) NOT NULL default '0', `ipn_results` longtext NOT NULL, `payment_date` datetime NOT NULL default '0000-00-00 00:00:00', `payment_gross` double NOT NULL default '0', `payer_email` text NOT NULL, `mc_fee` double NOT NULL default '0', `mc_gross` double NOT NULL default '0', `country` text NOT NULL, PRIMARY KEY (`item_number`) ) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
Usage
Example
see Special:Donate
This demo uses the PayPal sandbox. To sucessfully test the product you must register with a paypal developer account, and create a sandbox Business account with the email address tp@pt.com, as well as a personal account for testing.
Installation
copy files into place
Insert the following line into the end of 'LocalSettings.php' (before the '?>')
require("extensions/???.php");
To check to see if it is installed properly, visit your Version page, eg Special:Version.
You should see the following items:
- Extensions:
- Other:
- Paypal Donation Extension (version 0.0.1), Adds a special page allowing users to donate money to the wiki., by Trevor Ian Peacock
- Extension functions:
- paypalSetup
- Other:
Releases
Todo
- Interface to allow hiding of ads
- Donations in other currencies
RoadMap
0.2 No Date
- Interface to allow hiding of ads
- Donations in other currencies
History
0.1 9 April 2007
- Ability to make donations
- Recording of donors details, and receipt
- API to allow other extensions