Archive for November 3rd, 2008

Looking for 100th quiz user

Monday, November 3rd, 2008

Got request from client to check if we can see who did the 100th quiz. Looked into the Moodle database and came up with the following queries: select distinct(userid),timemodified from prefix_quiz_grades where quiz = quizid order by timemodified limit 100; (you should first find the appropriate quizid of course) then use the userid ...

Moodlestats rollout

Monday, November 3rd, 2008

Rolled out first version of Moodlestats: 1. dumped database from dev machine and restored in production machine 2. copy / past codebase 3. edited config.php 4. edited httpd.conf 5. added stats_collect.php to crontab (first did inital run) (6. included authentication hack: included moodle isloggedin() call)