## Blocks: Exabis Library

block_exalib
Maintained by andreas riepl
The block can be accessed from within any course. The admin can add any kind of document using the "manage library" link of the block. New entries can be made with references to the source, links, file, content and author. Also categories can be defined with the link "manage categories". With the search box the library can be searched as a whole or within each category.
89 sites
8 fans
Current versions available: 3

The block can be accessed from within any course. The admin can add any kind of document using the "manage library" link of the block.
New entries can be made with references to the source, links, file, content and author. Also categories can be defined with the link "manage categories".
With the search box the library can be searched as a whole or within each category.

### Contributors

• Mon, Jan 12, 2015, 9:17 PM
• Wed, Jan 21, 2015, 7:46 AM
Andreas - Many thanks for sharing another plugin. Before we approve this, might you tidy up the version.php to avoid the following validation warnings:

Warning Maturity information ($plugin->maturity) not found in version.php Warning Release name ($plugin->release) not found in version.php

Also, have a look at https://docs.moodle.org/dev/Plugin_contribution_checklist#Meta-data regarding provding the source, tracker and documentation meta-data.

In addition, it looks like this may be restricted to MySQL databases at the moment is I received the following when testing under Postgres:

Debug info: ERROR: function ifnull(bigint, integer) does not exist
LINE 6: ORDER BY GREATEST(IFNULL(time_created,0),IFNULL(time_modif...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.

SELECT item.*
FROM mdl_exalib_item AS item
WHERE 1=1
GROUP BY item.id
ORDER BY GREATEST(IFNULL(time_created,0),IFNULL(time_modified,0)) DESC
LIMIT 20

[array (
)]
Stack trace:

line 443 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 244 of /lib/dml/pgsql_native_moodle_database.php: call to moodle_database->query_end()
line 764 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
line 174 of /blocks/exalib/index.php: call to pgsql_native_moodle_database->get_records_sql()
line 5 of /blocks/exalib/admin.php: call to require()

For now, I am going to mark this plugin as needing more work until we get these issues resolved. Thanks for your patience with the review and approval process. Peace - Anthony
• Tue, Mar 24, 2015, 8:00 AM
Hi There,

it looks like you are still missing some meta-data here as Anthony spotted previously (source/tracker/documentation links) as mentioned here:
https://docs.moodle.org/dev/Plugin_contribution_checklist#Meta-data

• Tue, Mar 24, 2015, 3:06 PM
Hello, and sorry, I thought I had put everything in there but it got lost, anyway - it is updated again, regards Andreas
• Tue, Mar 24, 2015, 5:07 PM
Hi Andreas,

Thanks for updating those links, I've had a quick look at the code and noticed a number of issues that I've reported to your github account that will need to be resolved before this can be approved - I didn't complete a full review or test your code but I'd encourage you to do your testing and development with PostGres instead of MySql as if it works on Postgres it is likely to work on the other databases that Moodle supports as well.
• Mon, Apr 13, 2015, 11:40 AM
Andreas - I do not believe we are able to approve this in Moodle plugins because of the license used in jquery.lightbox.css - http://creativecommons.org/licenses/by-nd/2.5/br/deed.en_US - does not allow derivative works to be shared. Might you be able to find an alternative? For now I am going to mark this as needing more work. Peace - Anthony
• Mon, May 4, 2015, 6:48 PM

Hi Andreas. Thanks for providing the updated version of your block. I gave it another round of review and spotted some issues that should be fixed before we approve the plugin here. From all the issues reported into your tracker, the #6 is an approval blocker for now as it is one of those things that are better to have correct since the day 0, rather than fix them later. But all the other issues I spotted today are quite important and should be addressed.

Thanks for your patience with the review and approval process.

• Wed, May 6, 2015, 11:32 PM

Thanks Andreas for the updated version. I am going to approve the plugin now. You are cleared to land, welcome to the Plugins directory!