Skip to content

Instantly share code, notes, and snippets.

@ragingcomputer
ragingcomputer / MoodleUserPrivateBackupArea.sql
Created January 12, 2017 22:21
SQL query for Moodle to show space usage in User Private Backup Area by user
SELECT CONCAT(mu.firstname, ' ', mu.lastname, ' (', mu.email, ')' ) AS Teacher,
ROUND((SUM(mf.filesize)/1024)/1024, 2) AS Storage_Used_MB
FROM mdl_files AS mf
LEFT JOIN mdl_user AS mu ON mf.userid = mu.id
WHERE mf.component = 'user'
AND mf.filearea = 'backup'
AND NOT mf.filename = '.'
@ragingcomputer
ragingcomputer / README.md
Last active January 12, 2017 22:54
Aeon Labs Minimote in OpenHAB 1.8.3

The video https://www.youtube.com/watch?v=z0Dmdwt8gNE Is just a repetition of the directions on this post https://community.openhab.org/t/aeon-minimote-configuration-oh-1-8-2/9585/9

Quoting TheKorn from Apr '16

I'm going to write this up in stupid levels of detail, not because I think you're an idiot but for people who search and run across this thread. (Plus when it inevitably comes up in the future, I can link back here and say "do that". 😉 )

There are at least four variants of this remote, possibly more. They all seem to have identical hardware and report identically via zwave as far as device IDs go, and react the same way when you push the buttons despite them being labeled very differently. Version one has the buttons labeled 1,2,3,4. Version two has each button labeled with a square. (Very helpful, Aeon. /s) White/black versions of both exist, etc.

We need a common nomenclature for the buttons. I'm going to go with the original white remote's button numbering, since writing "hit the lower le