RatingExtension - Revision history

Trevorp: /* Usage */

2006-11-12T05:31:36Z

Usage

←Older revision		Revision as of 05:31, 12 November 2006
Line 13:		Line 13:

	==Usage==		==Usage==
-	Enabling the plugin will display star ratings above each page. 5 stars are displayed, which may be cliked by a user to indicate their opinion of the page. Stars are arranged left to right, with the first star having a value of 1, and the last a value of 5. Each user (identified by logon, or by IP address) may have one vote on any revision of a page, and may change their vote at any time.	+	Enabling the plugin will display star ratings above each page. 5 stars are displayed, which may be clicked by a user to indicate their opinion of the page. Stars are arranged left to right, with the first star having a value of 1, and the last a value of 5. Each user (identified by login, or by IP address) may have one vote on any revision of a page, and may change their vote at any time.

	The extension also enables the use of three new wiki tags:		The extension also enables the use of three new wiki tags:
Line 27:		Line 27:
	*sortby (ascending or descending) - sort in ascending or decending		*sortby (ascending or descending) - sort in ascending or decending
	*displaycount (true or false) - show the number of ratings for each page. defaults false		*displaycount (true or false) - show the number of ratings for each page. defaults false
-	*displayrating (true or false) - show the rating for each page. defaults true	+	*displayrating (true or false) - show the rating for each page. Defaults true
	*pattern - indicates the text to be returned for each result. supports four parameters: $1 => page_name, $2 => page name, $3 => rating, $4 => count, $5 => page revision id. overrides displaycount and displayrating.		*pattern - indicates the text to be returned for each result. supports four parameters: $1 => page_name, $2 => page name, $3 => rating, $4 => count, $5 => page revision id. overrides displaycount and displayrating.
	*limit - limits the maximum number of results. defaults to 10. 0 = unlimited		*limit - limits the maximum number of results. defaults to 10. 0 = unlimited

Trevorp: /* Details */

2006-08-08T01:46:11Z

Details

←Older revision		Revision as of 01:46, 8 August 2006
Line 1:		Line 1:
	==Details==		==Details==
-	*Version 0.3	+	*Version 0.3.1
-	*Date 2 Aug 2006	+	*Date 8 Aug 2006
	*Tested on MediaWiki 1.7.1, PHP 5.0.5 (apache2handler)		*Tested on MediaWiki 1.7.1, PHP 5.0.5 (apache2handler)
	*Tested on MediaWiki 1.6.6, PHP 5.0.5 (apache2handler)		*Tested on MediaWiki 1.6.6, PHP 5.0.5 (apache2handler)

Trevorp: /* History */

2006-08-07T14:00:36Z

History

←Older revision		Revision as of 14:00, 7 August 2006
Line 107:		Line 107:

	===History===		===History===
		+	====0.3.1 - Date 8 Aug 2006====
		+	*Ratings list shows link rather than image for Image namespace articles
	====0.3 - Date 2 Aug 2006====		====0.3 - Date 2 Aug 2006====
	*Add rating cache, to speed up <ratings> usage in large wikis.		*Add rating cache, to speed up <ratings> usage in large wikis.
-
	====0.2 - Date 31 July 2006====		====0.2 - Date 31 July 2006====
	*Fix sql injection possibilities		*Fix sql injection possibilities

Trevorp: /* Verification */

2006-08-07T13:59:40Z

Verification

←Older revision		Revision as of 13:59, 7 August 2006
Line 90:		Line 90:
	*Extensions:		*Extensions:
	**Parser hooks:		**Parser hooks:
-	***''[http://wiki.peacocktech.com/wiki/LyricExtension Rating Extension (version 0.3)]'', Adds rating mechanism, by [http://about.peacocktech.com/trevorp/ Trevor Peacock]	+	***''[http://wiki.peacocktech.com/wiki/LyricExtension Rating Extension (version 0.3.1)]'', Adds rating mechanism, by [http://about.peacocktech.com/trevorp/ Trevor Peacock]
	** Extension functions:		** Extension functions:
	***RatingExtension		***RatingExtension

Trevorp: /* Details */

2006-08-02T00:21:39Z

Details

←Older revision		Revision as of 00:21, 2 August 2006
Line 1:		Line 1:
	==Details==		==Details==
	*Version 0.3		*Version 0.3
-	*Date 1 Aug 2006	+	*Date 2 Aug 2006
	*Tested on MediaWiki 1.7.1, PHP 5.0.5 (apache2handler)		*Tested on MediaWiki 1.7.1, PHP 5.0.5 (apache2handler)
	*Tested on MediaWiki 1.6.6, PHP 5.0.5 (apache2handler)		*Tested on MediaWiki 1.6.6, PHP 5.0.5 (apache2handler)

Trevorp: /* 0.3 - Date 1 Aug 2006 */

2006-08-02T00:20:18Z

0.3 - Date 1 Aug 2006

←Older revision		Revision as of 00:20, 2 August 2006
Line 107:		Line 107:

	===History===		===History===
-	====0.3 - Date 1 Aug 2006====	+	====0.3 - Date 2 Aug 2006====
	*Add rating cache, to speed up <ratings> usage in large wikis.		*Add rating cache, to speed up <ratings> usage in large wikis.
		+
	====0.2 - Date 31 July 2006====		====0.2 - Date 31 July 2006====
	*Fix sql injection possibilities		*Fix sql injection possibilities

Trevorp: /* Usage */

2006-08-02T00:18:52Z

Usage

←Older revision		Revision as of 00:18, 2 August 2006
Line 28:		Line 28:
	*displaycount (true or false) - show the number of ratings for each page. defaults false		*displaycount (true or false) - show the number of ratings for each page. defaults false
	*displayrating (true or false) - show the rating for each page. defaults true		*displayrating (true or false) - show the rating for each page. defaults true
-	*pattern - indicates the text to be returned for each result. supports four parameters: $1 => page_name, $2 => page name, $3 => rating, $4 => count. overrides displaycount and displayrating.	+	*pattern - indicates the text to be returned for each result. supports four parameters: $1 => page_name, $2 => page name, $3 => rating, $4 => count, $5 => page revision id. overrides displaycount and displayrating.
	*limit - limits the maximum number of results. defaults to 10. 0 = unlimited		*limit - limits the maximum number of results. defaults to 10. 0 = unlimited

Trevorp at 02:20, 1 August 2006

2006-08-01T02:20:36Z

←Older revision		Revision as of 02:20, 1 August 2006
Line 1:		Line 1:
	==Details==		==Details==
-	*Version 0.1	+	*Version 0.3
-	*Date 30 July 2006	+	*Date 1 Aug 2006
	*Tested on MediaWiki 1.7.1, PHP 5.0.5 (apache2handler)		*Tested on MediaWiki 1.7.1, PHP 5.0.5 (apache2handler)
	*Tested on MediaWiki 1.6.6, PHP 5.0.5 (apache2handler)		*Tested on MediaWiki 1.6.6, PHP 5.0.5 (apache2handler)
Line 9:		Line 9:
	*With too few ratings, rating will change color to draw attention to get ratings		*With too few ratings, rating will change color to draw attention to get ratings
	*NoFollow support		*NoFollow support
-	*rating tag	+	*Tags to allow insertion of ratings into a page, or a list of "top 5" ratings etc.
-	*ratingcount tag	+	*Rating cache, to speed up <ratings> usage in large wikis.
-	*ratings tag	+

	==Usage==		==Usage==
Line 91:		Line 90:
	*Extensions:		*Extensions:
	**Parser hooks:		**Parser hooks:
-	***''[http://wiki.peacocktech.com/wiki/LyricExtension Rating Extension (version 0.2)]'', Adds rating mechanism, by [http://about.peacocktech.com/trevorp/ Trevor Peacock]	+	***''[http://wiki.peacocktech.com/wiki/LyricExtension Rating Extension (version 0.3)]'', Adds rating mechanism, by [http://about.peacocktech.com/trevorp/ Trevor Peacock]
	** Extension functions:		** Extension functions:
	***RatingExtension		***RatingExtension
Line 111:		Line 110:
	*Add rating cache, to speed up <ratings> usage in large wikis.		*Add rating cache, to speed up <ratings> usage in large wikis.
	====0.2 - Date 31 July 2006====		====0.2 - Date 31 July 2006====
-	*Add ratings into search output
	*Fix sql injection possibilities		*Fix sql injection possibilities
	*Add tags to allow insertion of ratings into a page, or a list of "top 5" ratings etc.		*Add tags to allow insertion of ratings into a page, or a list of "top 5" ratings etc.

Trevorp: /* Releases */

2006-08-01T02:18:00Z

Releases

←Older revision		Revision as of 02:18, 1 August 2006
Line 103:		Line 103:
	===Todo===		===Todo===
	*Add ratings into search output		*Add ratings into search output
-	*Add rating cache, to speed up <ratings> usage in large wikis.
	===RoadMap===		===RoadMap===
		+	====0.4 No Date====
		+	*Add ratings into search output
		+
		+	===History===
	====0.3 - Date 1 Aug 2006====		====0.3 - Date 1 Aug 2006====
	*Add rating cache, to speed up <ratings> usage in large wikis.		*Add rating cache, to speed up <ratings> usage in large wikis.
-
-	===History===
	====0.2 - Date 31 July 2006====		====0.2 - Date 31 July 2006====
	*Add ratings into search output		*Add ratings into search output

Trevorp: /* Database */

2006-07-31T14:46:52Z

Database

←Older revision		Revision as of 14:46, 31 July 2006
Line 66:		Line 66:
	<pre>		<pre>
	CREATE TABLE IF NOT EXISTS `ratings` (		CREATE TABLE IF NOT EXISTS `ratings` (
-	`page_oldid` int unsigned NOT NULL auto_increment,	+	`page_oldid` int unsigned NOT NULL,
	`user_id` varchar(15) NOT NULL,		`user_id` varchar(15) NOT NULL,
	`page_rating` int unsigned NOT NULL,		`page_rating` int unsigned NOT NULL,
Line 72:		Line 72:
	) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;		) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-	CREATE IF NOT EXISTS TABLE `ratings_cache` (	+	CREATE TABLE IF NOT EXISTS `ratings_cache` (
-	`page_oldid` int unsigned NOT NULL auto_increment,	+	`page_oldid` int unsigned NOT NULL,
	`page_rating` float unsigned NOT NULL,		`page_rating` float unsigned NOT NULL,
	`page_rating_count` int unsigned NOT NULL,		`page_rating_count` int unsigned NOT NULL,