http://wiki.peacocktech.com/index.php?title=RatingExtension&action=history&feed=atomRatingExtension - Revision history2024-03-28T05:59:50ZRevision history for this page on the wikiMediaWiki 1.7.1http://wiki.peacocktech.com/index.php?title=RatingExtension&diff=4323&oldid=prevTrevorp: /* Usage */2006-11-12T05:31:36Z<p><span class="autocomment">Usage</span></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 05:31, 12 November 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 13:</strong></td>
<td colspan="2" align="left"><strong>Line 13:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Usage==</td><td> </td><td style="background: #eee; font-size: smaller;">==Usage==</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">Enabling the plugin will display star ratings above each page. 5 stars are displayed, which may be <span style="color: red; font-weight: bold;">cliked </span>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 <span style="color: red; font-weight: bold;">logon</span>, or by IP address) may have one vote on any revision of a page, and may change their vote at any time.</td><td>+</td><td style="background: #cfc; font-size: smaller;">Enabling the plugin will display star ratings above each page. 5 stars are displayed, which may be <span style="color: red; font-weight: bold;">clicked </span>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 <span style="color: red; font-weight: bold;">login</span>, or by IP address) may have one vote on any revision of a page, and may change their vote at any time.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">The extension also enables the use of three new wiki tags:</td><td> </td><td style="background: #eee; font-size: smaller;">The extension also enables the use of three new wiki tags:</td></tr>
<tr><td colspan="2" align="left"><strong>Line 27:</strong></td>
<td colspan="2" align="left"><strong>Line 27:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*sortby (ascending or descending) - sort in ascending or decending</td><td> </td><td style="background: #eee; font-size: smaller;">*sortby (ascending or descending) - sort in ascending or decending</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*displaycount (true or false) - show the number of ratings for each page. defaults false</td><td> </td><td style="background: #eee; font-size: smaller;">*displaycount (true or false) - show the number of ratings for each page. defaults false</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*displayrating (true or false) - show the rating for each page. <span style="color: red; font-weight: bold;">defaults </span>true</td><td>+</td><td style="background: #cfc; font-size: smaller;">*displayrating (true or false) - show the rating for each page. <span style="color: red; font-weight: bold;">Defaults </span>true</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*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.</td><td> </td><td style="background: #eee; font-size: smaller;">*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.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*limit - limits the maximum number of results. defaults to 10. 0 = unlimited</td><td> </td><td style="background: #eee; font-size: smaller;">*limit - limits the maximum number of results. defaults to 10. 0 = unlimited</td></tr>
</table>
Trevorphttp://wiki.peacocktech.com/index.php?title=RatingExtension&diff=4118&oldid=prevTrevorp: /* Details */2006-08-08T01:46:11Z<p><span class="autocomment">Details</span></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 01:46, 8 August 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Details==</td><td> </td><td style="background: #eee; font-size: smaller;">==Details==</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*Version 0.3</td><td>+</td><td style="background: #cfc; font-size: smaller;">*Version 0.3<span style="color: red; font-weight: bold;">.1</span></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*Date <span style="color: red; font-weight: bold;">2 </span>Aug 2006</td><td>+</td><td style="background: #cfc; font-size: smaller;">*Date <span style="color: red; font-weight: bold;">8 </span>Aug 2006</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Tested on MediaWiki 1.7.1, PHP 5.0.5 (apache2handler)</td><td> </td><td style="background: #eee; font-size: smaller;">*Tested on MediaWiki 1.7.1, PHP 5.0.5 (apache2handler)</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Tested on MediaWiki 1.6.6, PHP 5.0.5 (apache2handler) </td><td> </td><td style="background: #eee; font-size: smaller;">*Tested on MediaWiki 1.6.6, PHP 5.0.5 (apache2handler) </td></tr>
</table>
Trevorphttp://wiki.peacocktech.com/index.php?title=RatingExtension&diff=4117&oldid=prevTrevorp: /* History */2006-08-07T14:00:36Z<p><span class="autocomment">History</span></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 14:00, 7 August 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 107:</strong></td>
<td colspan="2" align="left"><strong>Line 107:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===History===</td><td> </td><td style="background: #eee; font-size: smaller;">===History===</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">====0.3.1 - Date 8 Aug 2006====</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">*Ratings list shows link rather than image for Image namespace articles</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">====0.3 - Date 2 Aug 2006====</td><td> </td><td style="background: #eee; font-size: smaller;">====0.3 - Date 2 Aug 2006====</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Add rating cache, to speed up &lt;ratings&gt; usage in large wikis.</td><td> </td><td style="background: #eee; font-size: smaller;">*Add rating cache, to speed up &lt;ratings&gt; usage in large wikis.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"></td><td colspan="2"> </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">====0.2 - Date 31 July 2006====</td><td> </td><td style="background: #eee; font-size: smaller;">====0.2 - Date 31 July 2006====</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Fix sql injection possibilities</td><td> </td><td style="background: #eee; font-size: smaller;">*Fix sql injection possibilities</td></tr>
</table>
Trevorphttp://wiki.peacocktech.com/index.php?title=RatingExtension&diff=4116&oldid=prevTrevorp: /* Verification */2006-08-07T13:59:40Z<p><span class="autocomment">Verification</span></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 13:59, 7 August 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 90:</strong></td>
<td colspan="2" align="left"><strong>Line 90:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Extensions:</td><td> </td><td style="background: #eee; font-size: smaller;">*Extensions:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">**Parser hooks:</td><td> </td><td style="background: #eee; font-size: smaller;">**Parser hooks:</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">***''[http://wiki.peacocktech.com/wiki/LyricExtension Rating Extension (version 0.3)]'', Adds rating mechanism, by [http://about.peacocktech.com/trevorp/ Trevor Peacock]</td><td>+</td><td style="background: #cfc; font-size: smaller;">***''[http://wiki.peacocktech.com/wiki/LyricExtension Rating Extension (version 0.3<span style="color: red; font-weight: bold;">.1</span>)]'', Adds rating mechanism, by [http://about.peacocktech.com/trevorp/ Trevor Peacock]</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">** Extension functions:</td><td> </td><td style="background: #eee; font-size: smaller;">** Extension functions:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">***RatingExtension </td><td> </td><td style="background: #eee; font-size: smaller;">***RatingExtension </td></tr>
</table>
Trevorphttp://wiki.peacocktech.com/index.php?title=RatingExtension&diff=4113&oldid=prevTrevorp: /* Details */2006-08-02T00:21:39Z<p><span class="autocomment">Details</span></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 00:21, 2 August 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Details==</td><td> </td><td style="background: #eee; font-size: smaller;">==Details==</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Version 0.3</td><td> </td><td style="background: #eee; font-size: smaller;">*Version 0.3</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*Date <span style="color: red; font-weight: bold;">1 </span>Aug 2006</td><td>+</td><td style="background: #cfc; font-size: smaller;">*Date <span style="color: red; font-weight: bold;">2 </span>Aug 2006</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Tested on MediaWiki 1.7.1, PHP 5.0.5 (apache2handler)</td><td> </td><td style="background: #eee; font-size: smaller;">*Tested on MediaWiki 1.7.1, PHP 5.0.5 (apache2handler)</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Tested on MediaWiki 1.6.6, PHP 5.0.5 (apache2handler) </td><td> </td><td style="background: #eee; font-size: smaller;">*Tested on MediaWiki 1.6.6, PHP 5.0.5 (apache2handler) </td></tr>
</table>
Trevorphttp://wiki.peacocktech.com/index.php?title=RatingExtension&diff=4111&oldid=prevTrevorp: /* 0.3 - Date 1 Aug 2006 */2006-08-02T00:20:18Z<p><span class="autocomment">0.3 - Date 1 Aug 2006</span></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 00:20, 2 August 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 107:</strong></td>
<td colspan="2" align="left"><strong>Line 107:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===History===</td><td> </td><td style="background: #eee; font-size: smaller;">===History===</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">====0.3 - Date <span style="color: red; font-weight: bold;">1 </span>Aug 2006====</td><td>+</td><td style="background: #cfc; font-size: smaller;">====0.3 - Date <span style="color: red; font-weight: bold;">2 </span>Aug 2006====</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Add rating cache, to speed up &lt;ratings&gt; usage in large wikis.</td><td> </td><td style="background: #eee; font-size: smaller;">*Add rating cache, to speed up &lt;ratings&gt; usage in large wikis.</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">====0.2 - Date 31 July 2006====</td><td> </td><td style="background: #eee; font-size: smaller;">====0.2 - Date 31 July 2006====</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Fix sql injection possibilities</td><td> </td><td style="background: #eee; font-size: smaller;">*Fix sql injection possibilities</td></tr>
</table>
Trevorphttp://wiki.peacocktech.com/index.php?title=RatingExtension&diff=4110&oldid=prevTrevorp: /* Usage */2006-08-02T00:18:52Z<p><span class="autocomment">Usage</span></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 00:18, 2 August 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 28:</strong></td>
<td colspan="2" align="left"><strong>Line 28:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*displaycount (true or false) - show the number of ratings for each page. defaults false</td><td> </td><td style="background: #eee; font-size: smaller;">*displaycount (true or false) - show the number of ratings for each page. defaults false</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*displayrating (true or false) - show the rating for each page. defaults true</td><td> </td><td style="background: #eee; font-size: smaller;">*displayrating (true or false) - show the rating for each page. defaults true</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*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.</td><td>+</td><td style="background: #cfc; font-size: smaller;">*pattern - indicates the text to be returned for each result. supports four parameters: $1 => page_name, $2 => page name, $3 => rating, $4 => count<span style="color: red; font-weight: bold;">, $5 => page revision id</span>. overrides displaycount and displayrating.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*limit - limits the maximum number of results. defaults to 10. 0 = unlimited</td><td> </td><td style="background: #eee; font-size: smaller;">*limit - limits the maximum number of results. defaults to 10. 0 = unlimited</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
</table>
Trevorphttp://wiki.peacocktech.com/index.php?title=RatingExtension&diff=4107&oldid=prevTrevorp at 02:20, 1 August 20062006-08-01T02:20:36Z<p></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 02:20, 1 August 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Details==</td><td> </td><td style="background: #eee; font-size: smaller;">==Details==</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*Version 0.<span style="color: red; font-weight: bold;">1</span></td><td>+</td><td style="background: #cfc; font-size: smaller;">*Version 0.<span style="color: red; font-weight: bold;">3</span></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*Date <span style="color: red; font-weight: bold;">30 July </span>2006</td><td>+</td><td style="background: #cfc; font-size: smaller;">*Date <span style="color: red; font-weight: bold;">1 Aug </span>2006</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Tested on MediaWiki 1.7.1, PHP 5.0.5 (apache2handler)</td><td> </td><td style="background: #eee; font-size: smaller;">*Tested on MediaWiki 1.7.1, PHP 5.0.5 (apache2handler)</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Tested on MediaWiki 1.6.6, PHP 5.0.5 (apache2handler) </td><td> </td><td style="background: #eee; font-size: smaller;">*Tested on MediaWiki 1.6.6, PHP 5.0.5 (apache2handler) </td></tr>
<tr><td colspan="2" align="left"><strong>Line 9:</strong></td>
<td colspan="2" align="left"><strong>Line 9:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*With too few ratings, rating will change color to draw attention to get ratings</td><td> </td><td style="background: #eee; font-size: smaller;">*With too few ratings, rating will change color to draw attention to get ratings</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*NoFollow support</td><td> </td><td style="background: #eee; font-size: smaller;">*NoFollow support</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*<span style="color: red; font-weight: bold;">rating tag</span></td><td>+</td><td style="background: #cfc; font-size: smaller;">*<span style="color: red; font-weight: bold;">Tags to allow insertion of ratings into a page, or a list of "top 5" ratings etc.</span></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"><span style="color: red; font-weight: bold;">*ratingcount tag</span></td><td>+</td><td style="background: #cfc; font-size: smaller;">*<span style="color: red; font-weight: bold;">Rating cache, to speed up &lt;</span>ratings<span style="color: red; font-weight: bold;">&gt; usage in large wikis.</span></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*ratings <span style="color: red; font-weight: bold;">tag</span></td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Usage==</td><td> </td><td style="background: #eee; font-size: smaller;">==Usage==</td></tr>
<tr><td colspan="2" align="left"><strong>Line 91:</strong></td>
<td colspan="2" align="left"><strong>Line 90:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Extensions:</td><td> </td><td style="background: #eee; font-size: smaller;">*Extensions:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">**Parser hooks:</td><td> </td><td style="background: #eee; font-size: smaller;">**Parser hooks:</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">***''[http://wiki.peacocktech.com/wiki/LyricExtension Rating Extension (version 0.<span style="color: red; font-weight: bold;">2</span>)]'', Adds rating mechanism, by [http://about.peacocktech.com/trevorp/ Trevor Peacock]</td><td>+</td><td style="background: #cfc; font-size: smaller;">***''[http://wiki.peacocktech.com/wiki/LyricExtension Rating Extension (version 0.<span style="color: red; font-weight: bold;">3</span>)]'', Adds rating mechanism, by [http://about.peacocktech.com/trevorp/ Trevor Peacock]</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">** Extension functions:</td><td> </td><td style="background: #eee; font-size: smaller;">** Extension functions:</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">***RatingExtension </td><td> </td><td style="background: #eee; font-size: smaller;">***RatingExtension </td></tr>
<tr><td colspan="2" align="left"><strong>Line 111:</strong></td>
<td colspan="2" align="left"><strong>Line 110:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Add rating cache, to speed up &lt;ratings&gt; usage in large wikis.</td><td> </td><td style="background: #eee; font-size: smaller;">*Add rating cache, to speed up &lt;ratings&gt; usage in large wikis.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">====0.2 - Date 31 July 2006====</td><td> </td><td style="background: #eee; font-size: smaller;">====0.2 - Date 31 July 2006====</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*Add ratings into search output</td><td colspan="2"> </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Fix sql injection possibilities</td><td> </td><td style="background: #eee; font-size: smaller;">*Fix sql injection possibilities</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Add tags to allow insertion of ratings into a page, or a list of "top 5" ratings etc.</td><td> </td><td style="background: #eee; font-size: smaller;">*Add tags to allow insertion of ratings into a page, or a list of "top 5" ratings etc.</td></tr>
</table>
Trevorphttp://wiki.peacocktech.com/index.php?title=RatingExtension&diff=4106&oldid=prevTrevorp: /* Releases */2006-08-01T02:18:00Z<p><span class="autocomment">Releases</span></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 02:18, 1 August 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 103:</strong></td>
<td colspan="2" align="left"><strong>Line 103:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Todo===</td><td> </td><td style="background: #eee; font-size: smaller;">===Todo===</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Add ratings into search output</td><td> </td><td style="background: #eee; font-size: smaller;">*Add ratings into search output</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*Add rating cache, to speed up &lt;ratings&gt; usage in large wikis.</td><td colspan="2"> </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===RoadMap===</td><td> </td><td style="background: #eee; font-size: smaller;">===RoadMap===</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">====0.4 No Date====</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">*Add ratings into search output</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">===History===</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">====0.3 - Date 1 Aug 2006====</td><td> </td><td style="background: #eee; font-size: smaller;">====0.3 - Date 1 Aug 2006====</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Add rating cache, to speed up &lt;ratings&gt; usage in large wikis.</td><td> </td><td style="background: #eee; font-size: smaller;">*Add rating cache, to speed up &lt;ratings&gt; usage in large wikis.</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"></td><td colspan="2"> </td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">===History===</td><td colspan="2"> </td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">====0.2 - Date 31 July 2006====</td><td> </td><td style="background: #eee; font-size: smaller;">====0.2 - Date 31 July 2006====</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*Add ratings into search output</td><td> </td><td style="background: #eee; font-size: smaller;">*Add ratings into search output</td></tr>
</table>
Trevorphttp://wiki.peacocktech.com/index.php?title=RatingExtension&diff=4102&oldid=prevTrevorp: /* Database */2006-07-31T14:46:52Z<p><span class="autocomment">Database</span></p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 14:46, 31 July 2006</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 66:</strong></td>
<td colspan="2" align="left"><strong>Line 66:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"><pre></td><td> </td><td style="background: #eee; font-size: smaller;"><pre></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">CREATE TABLE IF NOT EXISTS `ratings` (</td><td> </td><td style="background: #eee; font-size: smaller;">CREATE TABLE IF NOT EXISTS `ratings` (</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> `page_oldid` int unsigned NOT NULL <span style="color: red; font-weight: bold;">auto_increment</span>,</td><td>+</td><td style="background: #cfc; font-size: smaller;"> `page_oldid` int unsigned NOT NULL,</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"> `user_id` varchar(15) NOT NULL,</td><td> </td><td style="background: #eee; font-size: smaller;"> `user_id` varchar(15) NOT NULL,</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"> `page_rating` int unsigned NOT NULL,</td><td> </td><td style="background: #eee; font-size: smaller;"> `page_rating` int unsigned NOT NULL,</td></tr>
<tr><td colspan="2" align="left"><strong>Line 72:</strong></td>
<td colspan="2" align="left"><strong>Line 72:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;</td><td> </td><td style="background: #eee; font-size: smaller;">) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">CREATE IF NOT EXISTS <span style="color: red; font-weight: bold;">TABLE </span>`ratings_cache` (</td><td>+</td><td style="background: #cfc; font-size: smaller;">CREATE <span style="color: red; font-weight: bold;">TABLE </span>IF NOT EXISTS `ratings_cache` (</td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;"> `page_oldid` int unsigned NOT NULL <span style="color: red; font-weight: bold;">auto_increment</span>,</td><td>+</td><td style="background: #cfc; font-size: smaller;"> `page_oldid` int unsigned NOT NULL,</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"> `page_rating` float unsigned NOT NULL,</td><td> </td><td style="background: #eee; font-size: smaller;"> `page_rating` float unsigned NOT NULL,</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"> `page_rating_count` int unsigned NOT NULL,</td><td> </td><td style="background: #eee; font-size: smaller;"> `page_rating_count` int unsigned NOT NULL,</td></tr>
</table>
Trevorp