Ranking block

Hello. I'd like to ask a question to the developer or anyone who understands how the block works internally. I'm using it as reference for developing my own block and I'd like to know why the modules completion is mirrored to another table?

Hi Willian,
I have a problem with this plugin, i don't know if this plugin works this way, I'm setting the Ranking block, but it doesn't assign points as I wish; in the ranking always adds the 2 default points to the left and the points of the forums, quiz and the activities adds to the right.
I really want to merge and sum these two values in one value.
My english isn't the best, i hope you can understand me.

Olá Willian. Meu caro, alguma previsão da atualização desta versão para o Moodle 2.7/2.8 + ? Gostaria de implementar no nosso ambiente, mas como temos a versão 2.7 e em preparação para a 2.8 seria interessante essa atualização! agradeço e sucesso!

Hi Willian,
Sorry to ear that, but in that case you may be interested in requesting adoption for this plugin:
https://moodle.org/mod/forum/discuss.php?d=260354

i'm sorry for the block ranking. I'm without time to fix the issues. But you are free to fix something and make a pull request. Help the soul of the open source.

Does anyone maintains this plugin? It seems to be abandoned. What a shame!

Using Moodle 2.7. Instaled block, activated. One user added to course. Course completion atcivated, Activities on the course (Quizzes, Scorm, links and documents), all of them must be marked as completed by user. Cron activated ("Processing cron function for ranking....... No new points to be computed") and block displays "No students to show".
¿Suggestions?

Hi,
This plugin looks great, but in my Moodle 2.5.5 over PostgreSQL doesn't work (version: 2014022400).
The plugin is installed normally, but when I try to add the block to a course I get a blank page and doesn't load that course page any more (I have to uninstall the plugin to do so).
Help will be appreciated.

Hi,
In my Moodle 2.5.2 the ranking block doesn't add points to completed activities that have grades, for example: hot potatoes quiz, quiz, scorm, etc. Ranking block version: 2014022400.
Best regards

Hi,
If you want to be able to add this block on a MS SQL Server powered Moodle, you need to make some little code changes in lib.php:
limit
1. On line 52-53, replace 'SELECT DISCTINCT' by 'SELECT DISTINCT TOP $limit'
and replace on line 64 'LIMIT ".$limit;' by '";'
2. On line 53, replace 'CONCAT(u.firstname, ' ', u.lastname)' by '(u.firstname + ' ' + u.lastname)'
3. On line 144, replace 'IFNULL' by 'ISNULL'
Some changes might still be needed by I haven't found any other problem yet (still testing the block).
Best!
Max

How to use the block ranking

Hey, Shane Edwards. Thanks for your reply.
I've solved this in the last version.

To clarify further, the PHP function EMPTY() in version before PHP 5.5 only allowed variables. As of PHP5.5 the function accepts other entries such as the return value of a function.

@Jehova and @Atul on line 47 of /block_ranking.php there is an attempt to test empty(trim($this->config->ranking_title)) which fails because the empty function expects a variable and will not use the return value of a function.
I changed the line to
if (isset($this->config->ranking_title) && !(trim($this->config->ranking_title)=='')) {
which works.
the same thing also happens on line 41 and line 42 and line 253 of /lib.php in the same folder.

Jehova Leal, Atul Kachhadiya and Richard Smyton. Thank you so much. I finally found the error and fix it. Please download the block again and test. More one time, Thank you! xD