MediaWiki/archive/extensions/Special/SiteSubscribe - Revision history

Woozle: Woozle moved page MediaWiki/Special/SiteSubscribe to MediaWiki/archive/extensions/Special/SiteSubscribe without leaving a redirect: obsolete, but may contain useful bits

2017-12-15T00:23:01Z

Woozle moved page MediaWiki/Special/SiteSubscribe to MediaWiki/archive/extensions/Special/SiteSubscribe without leaving a redirect: obsolete, but may contain useful bits

← Older revision	Revision as of 00:23, 15 December 2017
(No difference)

Woozle: extracted tables to a separate page; added link to new code page; some reorganization

2009-04-03T11:50:47Z

extracted tables to a separate page; added link to new code page; some reorganization

@@ Line 7: / Line 7: @@
 In the long run, it may make sense for these two functions (managing subscriptions and handling PayPal IPN) to be split into separate modules.
 ==Status==
-This extension is currently under development. Code will be posted here when it works.
+This extension is in alpha: some hand-coding will probably be needed in order to work with your installation, and steps necessary for configuration have not yet been documented.
 ===Functionality===
-* TO DO: record new subscriptions (sent via [[PayPal/IPN|IPN]])
+* TO DO: allow admins more fine-grained control of subscription expiration (change the date rather than just extend to today plus one year)
-** TO DO: function to create/extend subscriptions when IPN received
+* TO DO: show logs & related info for selected subscriber
 ===History===
 * '''2009-02-15''' ssub_post, ssub_post_line tables designed
-==Data Design==
+* '''2009-04-03''' working alpha code finally posted, but there are a lot of rough edges

Woozle: /* ssub_paymts */ +isTest field

2009-02-26T22:00:01Z

ssub_paymts: +isTest field

← Older revision		Revision as of 22:00, 26 February 2009
Line 29:		Line 29:
	* '''History''':		* '''History''':
	** '''2009-02-23''' Added IDS_Trx field		** '''2009-02-23''' Added IDS_Trx field
			** '''2009-02-26''' Added isTest field - same as ssub_post.isTest
	<section begin=sql /><mysql>CREATE TABLE `ssub_paymts` (		<section begin=sql /><mysql>CREATE TABLE `ssub_paymts` (
	ID INT NOT NULL AUTO_INCREMENT,		ID INT NOT NULL AUTO_INCREMENT,
	ID_User INT NOT NULL COMMENT "user.user_id of user making the payment",		ID_User INT NOT NULL COMMENT "user.user_id of user making the payment",
	WhenRecd DATETIME NOT NULL COMMENT "when the payment was received",		WhenRecd DATETIME NOT NULL COMMENT "when the payment was received",
	AmtRecd DECIMAL(9,2) NOT NULL COMMENT "dollar amount received",		AmtRecd DECIMAL(9,2) NOT NULL COMMENT "dollar amount received",
	IDS_Trx VARCHAR(63) NOT NULL COMMENT "transaction ID from processing service",		IDS_Trx VARCHAR(63) NOT NULL COMMENT "transaction ID from processing service",
			isTest BOOL DEFAULT NULL COMMENT "TRUE = test transaction (sandbox), not a real payment",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	)		)

Woozle: /* ssub_post */ +isTest field

2009-02-26T21:57:42Z

ssub_post: +isTest field

← Older revision		Revision as of 21:57, 26 February 2009
Line 54:		Line 54:
	** '''2009-02-15''' Created		** '''2009-02-15''' Created
	** '''2009-02-22''' WhenRepl, isOkay fields		** '''2009-02-22''' WhenRepl, isOkay fields
			** '''2009-02-26''' isTest field
	* '''Fields''':		* '''Fields''':
	** '''ConfText''' should be status text from PayPal - "VERIFIED" or "INVALID" - unless WhenRepl is NULL, in which case it is the http error message		** '''ConfText''' should be status text from PayPal - "VERIFIED" or "INVALID" - unless WhenRepl is NULL, in which case it is the http error message
			** '''isTest''' flags whether the post was from a [[PayPal Sandbox]] transaction (TRUE) or a regular transaction (FALSE), as determined by the test_ipn field in the POST data
	<section begin=sql /><mysql>CREATE TABLE `ssub_post` (		<section begin=sql /><mysql>CREATE TABLE `ssub_post` (
	ID INT NOT NULL AUTO_INCREMENT,		ID INT NOT NULL AUTO_INCREMENT,
Line 62:		Line 64:
	WhenConf DATETIME DEFAULT NULL COMMENT "when a confirmation was sent back, if any",		WhenConf DATETIME DEFAULT NULL COMMENT "when a confirmation was sent back, if any",
	WhenRepl DATETIME DEFAULT NULL COMMENT "when a reply to the confirmation was received, if any",		WhenRepl DATETIME DEFAULT NULL COMMENT "when a reply to the confirmation was received, if any",
	isOkay BOOL DEFAULT ~~FALSE~~ COMMENT "FALSE = reply was not received",		isOkay BOOL DEFAULT NULL COMMENT "FALSE = reply was not received",
			isTest BOOL DEFAULT NULL COMMENT "TRUE = sandbox transaction, for testing",
	ConfText VARCHAR(255) DEFAULT NULL COMMENT "contents retrieved by the confirmation",		ConfText VARCHAR(255) DEFAULT NULL COMMENT "contents retrieved by the confirmation",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)

Woozle: MediaWiki/SpecialSiteSubscribe moved to MediaWiki/Special/SiteSubscribe: So we can have an index page for specialpages hosted here

2009-02-24T00:56:05Z

MediaWiki/SpecialSiteSubscribe moved to MediaWiki/Special/SiteSubscribe: So we can have an index page for specialpages hosted here

← Older revision	Revision as of 00:56, 24 February 2009
(No difference)

Woozle: /* ssub_paymts */ +IDS_Trx; more documentation

2009-02-23T12:29:57Z

ssub_paymts: +IDS_Trx; more documentation

← Older revision		Revision as of 12:29, 23 February 2009
Line 23:		Line 23:
	==Data Design==		==Data Design==
	===ssub_paymts===		===ssub_paymts===
	Log of payments received		* '''Purpose''': Log of payments received
			* '''Fields''':
			** '''IDS_Trx''': transaction ID assigned by processing service
			*** i.e. at present, txn_id from PayPal
			* '''History''':
			** '''2009-02-23''' Added IDS_Trx field
	<section begin=sql /><mysql>CREATE TABLE `ssub_paymts` (		<section begin=sql /><mysql>CREATE TABLE `ssub_paymts` (
	ID INT NOT NULL AUTO_INCREMENT,		ID INT NOT NULL AUTO_INCREMENT,
Line 29:		Line 34:
	WhenRecd DATETIME NOT NULL COMMENT "when the payment was received",		WhenRecd DATETIME NOT NULL COMMENT "when the payment was received",
	AmtRecd DECIMAL(9,2) NOT NULL COMMENT "dollar amount received",		AmtRecd DECIMAL(9,2) NOT NULL COMMENT "dollar amount received",
			IDS_Trx VARCHAR(63) NOT NULL COMMENT "transaction ID from processing service",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />

	===ssub_subscrs===		===ssub_subscrs===
	Subscription status		Subscription status

Woozle: /* ssub_post */

2009-02-23T02:16:13Z

ssub_post

← Older revision		Revision as of 02:16, 23 February 2009
Line 46:		Line 46:
	* '''History''':		* '''History''':
	** '''2009-02-15''' Created		** '''2009-02-15''' Created
			** '''2009-02-22''' WhenRepl, isOkay fields
	* '''Fields''':		* '''Fields''':
	** '''~~RespCont~~''' should be status text from PayPal - "VERIFIED" or "INVALID"		** '''ConfText''' should be status text from PayPal - "VERIFIED" or "INVALID" - unless WhenRepl is NULL, in which case it is the http error message
	<section begin=sql /><mysql>CREATE TABLE `ssub_post` (		<section begin=sql /><mysql>CREATE TABLE `ssub_post` (
	ID INT NOT NULL AUTO_INCREMENT,		ID INT NOT NULL AUTO_INCREMENT,
Line 53:		Line 54:
	WhenRecd DATETIME NOT NULL COMMENT "when the POST was received",		WhenRecd DATETIME NOT NULL COMMENT "when the POST was received",
	WhenConf DATETIME DEFAULT NULL COMMENT "when a confirmation was sent back, if any",		WhenConf DATETIME DEFAULT NULL COMMENT "when a confirmation was sent back, if any",
			WhenRepl DATETIME DEFAULT NULL COMMENT "when a reply to the confirmation was received, if any",
			isOkay BOOL DEFAULT FALSE COMMENT "FALSE = reply was not received",
	ConfText VARCHAR(255) DEFAULT NULL COMMENT "contents retrieved by the confirmation",		ConfText VARCHAR(255) DEFAULT NULL COMMENT "contents retrieved by the confirmation",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)

Woozle: /* ssub_post */ a couple of punctuation fixes

2009-02-22T21:05:36Z

ssub_post: a couple of punctuation fixes

← Older revision		Revision as of 21:05, 22 February 2009
Line 50:		Line 50:
	<section begin=sql /><mysql>CREATE TABLE `ssub_post` (		<section begin=sql /><mysql>CREATE TABLE `ssub_post` (
	ID INT NOT NULL AUTO_INCREMENT,		ID INT NOT NULL AUTO_INCREMENT,
	RmtAddr VARCHAR(15) NOT NULL COMMENT "IP address of POST sender";		RmtAddr VARCHAR(15) NOT NULL COMMENT "IP address of POST sender",
	WhenRecd DATETIME NOT NULL COMMENT "when the POST was received",		WhenRecd DATETIME NOT NULL COMMENT "when the POST was received",
	WhenConf DATETIME DEFAULT NULL COMMENT "when a confirmation was sent back, if any",		WhenConf DATETIME DEFAULT NULL COMMENT "when a confirmation was sent back, if any",
	ConfText VARCHAR(255) DEFAULT NULL COMMENT "contents retrieved by the confirmation".		ConfText VARCHAR(255) DEFAULT NULL COMMENT "contents retrieved by the confirmation",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	)		)

Woozle: /* ssub_post */ changed some field names; added ConfText

2009-02-15T15:30:09Z

ssub_post: changed some field names; added ConfText

← Older revision		Revision as of 15:30, 15 February 2009
Line 46:		Line 46:
	* '''History''':		* '''History''':
	** '''2009-02-15''' Created		** '''2009-02-15''' Created
			* '''Fields''':
			** '''RespCont''' should be status text from PayPal - "VERIFIED" or "INVALID"
	<section begin=sql /><mysql>CREATE TABLE `ssub_post` (		<section begin=sql /><mysql>CREATE TABLE `ssub_post` (
	ID INT NOT NULL AUTO_INCREMENT,		ID INT NOT NULL AUTO_INCREMENT,
	~~WhenRecd DATETIME NOT NULL COMMENT "when the payment was received",~~
	~~WhenResp DATETIME DEFAULT NULL COMMENT "when a confirmation POST was sent back, if any",~~
	RmtAddr VARCHAR(15) NOT NULL COMMENT "IP address of POST sender";		RmtAddr VARCHAR(15) NOT NULL COMMENT "IP address of POST sender";
			WhenRecd DATETIME NOT NULL COMMENT "when the POST was received",
			WhenConf DATETIME DEFAULT NULL COMMENT "when a confirmation was sent back, if any",
			ConfText VARCHAR(255) DEFAULT NULL COMMENT "contents retrieved by the confirmation".
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />

	===ssub_post_line===		===ssub_post_line===
	* '''Purpose''': Data received via POST - child of ssub_post		* '''Purpose''': Data received via POST - child of ssub_post

Woozle: ssub_post, ssub_post_line

2009-02-15T14:57:17Z

ssub_post, ssub_post_line

← Older revision		Revision as of 14:57, 15 February 2009
Line 9:		Line 9:
	==Status==		==Status==
	This extension is currently under development. Code will be posted here when it works.		This extension is currently under development. Code will be posted here when it works.
	==Functionality==		===Functionality===
	* TO DO: record new subscriptions (sent via [[PayPal/IPN\|IPN]])		* TO DO: record new subscriptions (sent via [[PayPal/IPN\|IPN]])
	** TO DO: function to create/extend subscriptions when IPN received		** TO DO: function to create/extend subscriptions when IPN received
Line 16:		Line 16:
	** TO DO: detect when user's account has expired		** TO DO: detect when user's account has expired
	** TO DO: remove user from "subscribers" group on expiration		** TO DO: remove user from "subscribers" group on expiration
	** ~~TO DO:~~ display subscription status for admins		** display subscription status for admins
	** ~~TO DO:~~ allow admins to modify subscription status (change expiration, add new subscription)		** allow admins to modify subscription status (change expiration, add new subscription)
	===~~also to do~~===		*** currently, subscriptions can only be extended to now plus one year; TO DO: subscription deletion (soon)
	* ~~table to record subscription info~~		===History===
			* '''2009-02-15''' ssub_post, ssub_post_line tables designed
	==Data Design==		==Data Design==
	===ssub_paymts===		===ssub_paymts===
Line 38:		Line 39:
	WhenExp DATETIME NOT NULL COMMENT "when the subscription expires",		WhenExp DATETIME NOT NULL COMMENT "when the subscription expires",
	PRIMARY KEY(`ID_User`)		PRIMARY KEY(`ID_User`)
			)
			ENGINE = MYISAM;</mysql>
			<section end=sql />
			===ssub_post===
			* '''Purpose''': Http POSTs received by this extension -- partly for debugging, and partly as a fallback in case of technical problems or data loss
			* '''History''':
			** '''2009-02-15''' Created
			<section begin=sql /><mysql>CREATE TABLE `ssub_post` (
			ID INT NOT NULL AUTO_INCREMENT,
			WhenRecd DATETIME NOT NULL COMMENT "when the payment was received",
			WhenResp DATETIME DEFAULT NULL COMMENT "when a confirmation POST was sent back, if any",
			RmtAddr VARCHAR(15) NOT NULL COMMENT "IP address of POST sender";
			PRIMARY KEY(`ID`)
			)
			ENGINE = MYISAM;</mysql>
			<section end=sql />
			===ssub_post_line===
			* '''Purpose''': Data received via POST - child of ssub_post
			* '''History''':
			** '''2009-02-15''' Created
			<section begin=sql /><mysql>CREATE TABLE `ssub_post_line` (
			ID_Post INT NOT NULL COMMENT "ssub_post.ID",
			DataKey VARCHAR(255) NOT NULL COMMENT "name of data item",
			DataVal VARCHAR(255) NOT NULL COMMENT "value of data item",
			PRIMARY KEY(`ID_Post`,`DataKey`)
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />