Extension talk:Contribution Scores/LQT Archive 1

1.12.0
I upgraded my wiki to 1.12.0, and noticed that after the update, all contribution scores (score / pages / edits) show the same number. In 1.11.1 it showed an individual number for each field, now they're all the same.

Doesn't work on MW 1.8.4
I have installed this on 1.8.4 and get an empty SpecialPages page. Does anyone know why this is?
 * It's only been tested down to MW 1.9.3 and only intended for use above 1.10.0 - Not sure what changed from 1.8.4-1.9.3.

(fixed) This extension does not work on portgresql database.
The exception : A database error has occurred Query: SELECT user_id, user_name, COUNT(DISTINCT rev_page) AS page_count, COUNT(rev_id) AS rev_count, (COUNT(DISTINCT rev_page)+SQRT(COUNT(rev_id)-COUNT(DISTINCT rev_page))*2) AS wikiRank FROM mwuser userTable JOIN revision revTable ON (userTable.user_id=revTable.rev_user) WHERE rev_timestamp > '20070815000000' AND user_id NOT IN (SELECT ug_user FROM user_groups WHERE ug_group='bot') GROUP BY user_id, user_name ORDER BY wikiRank DESC LIMIT 50 Function: Error: 1 ERROR: invalid input syntax for type timestamp with time zone: "20070815000000"

Backtrace:


 * 1) 0 /var/www/html/wiki/includes/Database.php(761): DatabasePostgres->reportQueryError('ERROR: invalid...', 1, 'SELECT user_id,...', '', false)
 * 2) 1 /var/www/html/wiki/extensions/ContributionScores/ContributionScores_body.php(46): Database->query('SELECT user_id,...')
 * 3) 2 /var/www/html/wiki/extensions/ContributionScores/ContributionScores_body.php(98): ContributionScores->genContributionScoreTable(NULL, NULL, 7, 50)
 * 4) 3 /var/www/html/wiki/includes/SpecialPage.php(433): ContributionScores->execute(NULL)
 * 5) 4 /var/www/html/wiki/includes/Wiki.php(196): SpecialPage::executePath(Object(Title))
 * 6) 5 /var/www/html/wiki/includes/Wiki.php(45): MediaWiki->initializeSpecialCases(Object(Title), Object(OutputPage), Object(WebRequest))
 * 7) 6 /var/www/html/wiki/index.php(89): MediaWiki->initialize(Object(Title), Object(OutputPage), Object(User), Object(WebRequest))
 * 8) 7 {main}
 * Lookin' in to it. I'll switch from literal to use dbr->timestamp for compatibility.
 * Fixed in r25071.
 * Thank you for your support but now i have a new error :
 * But at the end of the error i have the stats

Notice: Undefined variable: sql in /var/www/html/wiki/extensions/ContributionScores/ContributionScores_body.php on line 97 Notice: Undefined property: stdClass::$wikiRank in /var/www/html/wiki/extensions/ContributionScores/ContributionScores_body.php on line 57
 * Fixed $sql/line 97 error in r25086 - do you still get the line 57 error for wikiRank? I also changed the grouping f/ the SQL statement, maybe Postgres doesn't like the way that I did it the first time...  (btw, thx for helping w/ this)
 * Ok the extension work perfectly with postgres. Thank you for your support

Spanish translation
How can I translate this extension in Spanish?

I was trying to edit ContributionScores.i18n.php, but I can't translate it

'es' => array( 				'contributionscores' => 'Puntuaciones por contribuir',				'contributionscores-info' => 	"Las puntuaciones son calculadas siguiendo:\n".												"*1 punto por cada página única editada\n".												"*Raíz cuadrada de (Ediciones totales efectuadas) - (Páginas totales únicas) x 2\n".												"Las puntuaciones son calculadas de esta manera considerando la diversidad sobre el volumen de edición.".												"Básicamente, esta puntuación mide fundamentalmente las páginas únicas editadas, considerando que un alto ".												"volumen de edición supone que es un artículo de mayor calidad.",				'contributionscores-top' => '(Top $1)',				'contributionscores-days' => 'Últimos $1 días',				'contributionscores-allrevisions' => 'Estadísticas globales'       ),

What's the problem? :(

EmuAGR 17:46, 2 September 2007 (UTC)
 * I would imagine you're testing by changing your User Preferences language - it was using wfMsgForContent (which is based on the site language), I just changed it in r25412 to use wfMsg - it should work as you expect now. Note, I added the above translation to the i18n file.  Thx for the translation.
 * Thanks for everything, but it doesn't work yet. You can see it at www.wikimanga.net/wiki/index.php?title=Especial:ContributionScores EmuAGR 19:45, 2 September 2007 (UTC)
 * Yeah, that doesn't look good at all. ;-)  I switched all the accented spanish characters over to the &*acute; HTML codes and it works great now.  Let me know if you're still having problems w/ the new i18n file - fixed in r25414.
 * My bad. I flipped my editor over to UTF-8.  Works fine now.  ;-)

Excellent Extension
I installed this on my 1.9 wiki and it worked like a charm! Great job! --Vaccano 21:37, 24 October 2007 (UTC)

Inclusion
If is that possible to be include in a template or something like that?. It could remplace de edicount extension. Or make a fusion of the two.--Add 18:28, 17 December 2007 (UTC)
 * Implemented the ability to include the page in r28646. See main article for instructions.  I believe editcount is a parser function extension - it doesn't have much in common with this extension.
 * Nice feature. I put it on betawiki:User:Siebrand. Would it be possible to strip the talk/contribs/block links from this somehow? In the way I am using it (and they way I assume more will use it, it is taking up more space that I would like to). Cheers! Siebrand 11:28, 19 December 2007 (UTC)
 * Sure. I'm also trying to optimize that query so it doesn't take 14 seconds to load the Special Page.  ;-)
 * notools and nosort options implemented in r28669. See main article for usage.  I also tried to optimize the SQL query - I got an 84% speed increase on a 32000 revision wiki.  I'm interested to see what it does to the 7.716 second load time on Betawiki f/ the Special Page.  Tim Laqua talk 15:51, 19 December 2007 (UTC)

Tested 1.11.1
Works on the latest, 1.11.1. Very easy to set up. Thanks a bunch, this was exactly what we were looking for. Link at http://www.arcandio.com/wiki/index.php5?title=Special:ContributionScores