Extension talk:Contribution Scores

Jump to navigation Jump to search

About this board

Archive


87.48.23.112 (talkcontribs)

Would it be possible for a way to call 2 dates and get the score for between the 2 days

such as you would define 01012019 and 01022019 and it would show you the score for january

or define a start date and how many days ahead such as 01012019 as start date and then you an put in a days such as 31 and it would show all of january or you could do 14 and get the score for the first 14 days of january?

PhotographerTom (talkcontribs)

I agree.

Reply to "Feature request"
Usek2 (talkcontribs)

At the moment extension is used on nearly brand new Wiki with few articles.


Two articles have been created and edited with two different users however no score shows up.


Any ideas?

Camponez (talkcontribs)

I'm having the same problem with a brand new 1.33. After more than 100 edits, no scores at all.

Camponez (talkcontribs)
Camponez (talkcontribs)
Reply to "Does not show any results"

Critical: Does not work in 1.18

3
86.61.12.125 (talkcontribs)

With enabled $wgShowSQLErrors in LocalSettings.php:

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:


SELECT user_id, user_name, page_count, rev_count, page_count+SQRT(rev_count-page_count)*2 AS wiki_rank FROM user u JOIN ((SELECT rev_user, COUNT(DISTINCT rev_page) AS page_count, COUNT(rev_id) AS rev_count FROM revision WHERE rev_timestamp > '20120925235315' AND rev_user NOT IN (SELECT ipb_user FROM ipblocks WHERE ipb_user <> 0) AND rev_user NOT IN (SELECT ug_user FROM user_groups WHERE ug_group='bot') GROUP BY rev_user ORDER BY page_count DESC LIMIT 50) UNION (SELECT rev_user, COUNT(DISTINCT rev_page) AS page_count, COUNT(rev_id) AS rev_count FROM revision WHERE rev_timestamp > '20120925235315' AND rev_user NOT IN (SELECT ipb_user FROM ipblocks WHERE ipb_user <> 0) AND rev_user NOT IN (SELECT ug_user FROM user_groups WHERE ug_group='bot') GROUP BY rev_user ORDER BY rev_count DESC LIMIT 50)) s ON (user_id=rev_user) ORDER BY wiki_rank DESC LIMIT 50


from within function "". Database returned error "1: near "UNION": syntax error".

12.25.107.2 (talkcontribs)

I am getting the same thing in 1.24

A database query error has occurred. This may indicate a bug in the software.

  • Query:
    SELECT user_id, user_name, user_real_name, page_count, rev_count, page_count+SQRT(rev_count-page_count)*2 AS wiki_rank FROM user u JOIN ((SELECT rev_user, COUNT(DISTINCT rev_page) AS page_count, COUNT(rev_id) AS rev_count FROM revision WHERE rev_timestamp > '20151203135947' AND rev_user NOT IN (SELECT ipb_user FROM ipblocks WHERE ipb_user <> 0) AND rev_user NOT IN (SELECT ug_user FROM user_groups WHERE ug_group='bot') GROUP BY rev_user ORDER BY page_count DESC LIMIT 50) UNION (SELECT rev_user, COUNT(DISTINCT rev_page) AS page_count, COUNT(rev_id) AS rev_count FROM revision WHERE rev_timestamp > '20151203135947' AND rev_user NOT IN (SELECT ipb_user FROM ipblocks WHERE ipb_user <> 0) AND rev_user NOT IN (SELECT ug_user FROM user_groups WHERE ug_group='bot') GROUP BY rev_user ORDER BY rev_count DESC LIMIT 50)) s ON (user_id=rev_user) ORDER BY wiki_rank DESC LIMIT 50
  • Function: DatabaseBase::query
  • Error: 1 near "UNION": syntax error
2001:638:208:2301:E9CB:4927:E660:1F2C (talkcontribs)

For me the same in 1.32; do you maybe need a MySQL database instead of a SQLite database?

Reply to "Critical: Does not work in 1.18"

What does "unique pages edited" mean?

1
Sances tb (talkcontribs)

This phrase is mentioned at the first paragraph, The score is defined as (number of unique pages edited) + 2 * square root ((number of edits) - (number of unique pages edited)).--Sances tb (talk) 08:40, 11 June 2018 (UTC)

Reply to "What does "unique pages edited" mean?"
Stuartbman (talkcontribs)

Just in case anyone is looking for a way to hide columns when inserting the table into pages, this can be added into Common.css:

.contributionscores td:nth-child(2) {     display:none; } .contributionscores .header th:nth-child(2) {     display:none; }

Reply to "Hiding columns"
Berrygator (talkcontribs)

I want to be able to rank people by how many words they have contributed. People adding files and making small changes is distorting the rankings from showing the true Top Contributors on my Wiki. Is this possible?

Nemo bis (talkcontribs)

Would (approximate) characters be good enough?

192.91.75.30 (talkcontribs)

Yes, that would definitely be helpful!

Berrygator (talkcontribs)

That would work. Is there a way to do this? Thanks!

Fbstj (talkcontribs)

that would be so awesome

Reply to "Rank by Words Added"

change the way score is calculated

1
Rbirmann (talkcontribs)

Hi,

First of all, just wanted to say this extension is great.

We have installed it in our corporate wiki, as part of an internal program to motivate users to contribute to it. We would like, however, to give more points to users who create new articles as well as to differentiate longer, well thought, editions (such as a 5 paragraph long new section on an article) from shorter, quicker, less relevant changes (such as a one letter typo correction).

While thinking about this it came to me that maybe it is possible to allow users to create, on their LocalSettings.php a custom calculating function. I am no php expert myself, so please see the pseudo-code below:

on the extension itself:


efContributionScores_Render (...)
  
  for u in all_users do

    new_articles = countNewArticles(u)
    total_edits = countTotalEdits(u)
    unique_edits = countUniquePageEdits(u)
    other_data = countOtherRelevantData(u)
    (...)

    if function_exists "csCustomUserCalculation" then

      score[u] = csCustomUserCalculation (new_articles, total_edits, unique_edits, other_data)

    else

      score[u] = unique_edits + 2 * sqrt(total_edits - unique_edits)    // default behaviour
  
    end if

  end for

return score


Users would then be able to add a custom way of calculating scores to their LocalSettings, something like this (again in pseudo-code):


csCustomUserCalculation (new_articles, total_edits, unique_edits, ...)

    score = 10 * new_articles + total_edits

return score

Any thoughts???

Rbirmann (talk) 16:10, 22 January 2015 (UTC)

Reply to "change the way score is calculated"

Contribution score for a transcribing page.

1
208.116.10.33 (talkcontribs)

Is there a way to identify the contributions by users in all the transcribing pages? For that how to add the cscore to the page: template? I have no idea how to implement this.

Reply to "Contribution score for a transcribing page."

How to display the score after user page title.

2
Rob Kam (talkcontribs)

To give more prominence to this feature on a wiki. Is there a way to have the user's score appended to the name of their user page?

Rob Kam (talkcontribs)

This doesn't work but it would be something like, first add to LocalSettings.php:

$wgRestrictDisplayTitle = false;

Then on the user page add:

{{DISPLAYTITLE:{{BASEPAGENAME}}&nbsp;{{#cscore:{{BASEPAGENAME}}|score}}}}
Reply to "How to display the score after user page title."
79.228.75.218 (talkcontribs)

Wouldn't it be good to store queries in memcached?

Reply to "Memcached"