PaypalDonationExtension

From PeacockWiki

(Difference between revisions)

Revision as of 13:31, 6 April 2007

LyricExtension is an extension for Mediawiki that provides features facilitating the notation of song lyrics in the wiki.

1 Details
- 1.1 Features
- 1.2 Design
  - 1.2.1 Database
2 Usage
- 2.1 Example
3 Installation
4 Releases
5 Source Code

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.
Allows visitors to view a list of donors.

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
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` double NOT NULL default '0',
  `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=17 DEFAULT CHARSET=latin1;

Usage

Example

see Special:Donate

see Special:Donors

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:
  - LyricExtension and paypalSetup

Releases

Todo

Interface to allow hiding of ads
Donations in other currencies

Full Todo

RoadMap

0.2 No Date

Interface to allow hiding of ads
Donations in other currencies

Full RoadMap

History

0.1 9 April 2007

Ability to make donations
Recording of donors details, and receipt
API to allow other extensions

Full History

Source Code

Retrieved from "http://wiki.peacocktech.com/wiki/PaypalDonationExtension"