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.
 * Are you using version 1.7.1 of the extension? I just tested on the SVN trunk (1.13alpha) and it's working fine.  Tim Laqua talk 17:06, 26 March 2008 (UTC)
 * This works fine for me with 1.12.0. Thanks :) Patheticcockroach 08:17, 11 April 2008 (UTC)

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
 * Note - example link above is now dead. Wiki appears to no longer exist. Tim Laqua talk 15:12, 27 March 2008 (UTC)

Possible Enhancement?
I echo the sentiments above. Easy to set up and provides useful data. Thanks. We have only recently set up our wiki and wish to gauge its use. Whilst user contributions are very useful we also wish to establish the total number of views per user in a summary report such as this. None of the other available extensions seem to provide quite what is needed. Would it be possible to add a column with this information? --Phil 09:50, 3 April 2008 (UTC)
 * No, per-user view activity isn't recorded anywhere. You could take the total number of views and get an 'average' - but you couldn't determine 'who' had more views.  An extension could be created to maintain that data.  Feel free to post it in Extension Requests. Tim Laqua talk 02:27, 4 April 2008 (UTC)

ignore blocked users
There's an option  to ignore bots, but is it possible to ignore blocked users? I want to have Contribution Scores table with only active users. gr Jerone 09:36, 17 April 2008 (UTC)
 * Implemented in v1.9, r33496. Use $wgContribScoreIgnoreBlockedUsers = true; Tim Laqua talk 17:37, 17 April 2008 (UTC)
 * Thank you ||Jerone 20:49, 17 April 2008 (UTC)

User Score as Variable?
Could you tell how to make the score of a user a Variable for Extension:Variables? I want to crete a user template the gives out the score of a user or at last the number of edits. Thanks! --Subfader 20:18, 14 May 2008 (UTC)
 * Hmm... I have write a static function to give you that info - So you want it to throw the score of the currently logged in user? Or you want like a parser function?  A parser function would allow you to display the score for a given user (which I assume is what you would want to do on a user page template). Tim Laqua talk 22:00, 14 May 2008 (UTC)
 * Yep as parser function would be ace for the user on whose page the parser is included (via template), not the logged in user (he can check his on his user page :). Would be good to make 3 parser funcs score, changes, pages. Btw: If this parser works I won't need Extension:EditCount which has Inconsistances in the total edit# compared to yours (which I simply assume is the correct one). --Subfader 09:00, 15 May 2008 (UTC)
 * k, I'll try to find some time over the weekend to throw those together. Tim Laqua talk 10:40, 15 May 2008 (UTC)
 * Biggup! ;) --Subfader
 * Implemented in r34903, v1.10 - all #cscore metrics are based on *all* revisions. I also added in $wgContribScoreDisableCache so you can have the metrics display realtime.  Just set it to true Tim Laqua talk 02:03, 16 May 2008 (UTC)
 * Awesome! Smooth like a baby. Thanks for the fast coding :) --Subfader 07:19, 16 May 2008 (UTC)

Examples
You can add my site as example if you like.
 * Inclusion/Transclusion with disabled $title in _body.php
 * #cscore Parser Function used as "user stats" --Subfader 09:44, 16 May 2008 (UTC)

Edits vs "Changes"
I just noticed that my number of total changes is higher than the number of total edits on Special:Preferences. What causes it? Does edits exclude actions "changes" considers? Will take it off Special:Preferences anyway. --Subfader 15:25, 21 May 2008 (UTC)
 * Well - "edits" is from user.user_editcount - it's a counter that get incremented every time a user edits a page. "changes" is a count of the revisions in the database that belong to a particular user ID.  Which is more accurate?  Dunno.  I'd say "changes" is the real number.  I would imagine there are reasons that user_editcount wouldn't be incremented (I'm not real familiar with when/why that counter gets incremented/decremented).  One is a counter, the other is a result of a query - that's why I never called it an edit count - it's either "revisions" or "changes" from my perspective.  Tim Laqua talk 10:27, 23 May 2008 (UTC)

MySQL 4.0.24 Compability
After installation it keeps showing error "1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT rev_user, COUNT(DISTINCT rev_ (localhost)". I'm using ContributionScores-MW1.12-r31252 with MySQL 4.0.24. Any ideas would be great since I didn't find anything in the MySQL documentation. Cheers, --Till Kraemer 22:22, 2 August 2008 (UTC)

Time Period Enhancement
This is a brilliant extension ( I can't thank you enough ). I'd love the option to have a drop down list of months with the year (ie. Jan 2008, Feb 2008, etc) to pull historical reporting on contribution scores...Is that really easy of much harder then I think? Doug 38.117.240.100 23:34, 7 August 2008 (UTC)


 * OK...I just figured out a way to do it ( sorry for complaining ) but it's so dumb thing with SQL involving this: (PS this involves altering the file ContributionScores_body.php and the code is found around line 49)

if ( $days > 0 && $days < 200601 ) { $date = time - (60*60*24*$days); $dateString = $dbr->timestamp($date); $sqlWhere .= " {$nextPrefix} rev_timestamp > '$dateString'"; $nextPrefix = "AND"; }

if ( $days == 200801 ) { $sqlWhere .= " {$nextPrefix} rev_timestamp"; $sqlWhere .= " BETWEEN '20080101000000' AND '20080131235959'"; $nextPrefix = "AND"; }
 * PREFACE:This is a horrible way to do it (since I don't really know SQL)


 * If the user types in:


 * Instead of getting the intended 200,801 days go, they will get all user contributions between the timestamps of 01/01/2008 00:00:00 to 01/31/2008 11:59:59 (essentially all of Jan 2008).  Why? the SQL statement “BETWEEN '20080101000000' AND '20080131235959'” will only look for activity during that time period...I'm in the process of making it so the extension will throw in the correct title of "January 2008" instead of defaulting to the day count of 200,801 (since it will look cooler)...If anyone wants to pick up the ball and do it the right way, be my guest (but I hope this helps out)!—Sanbitter 01:25, 8 August 2008 (UTC)