Archive for the ‘BrnDmp’ Category
Thursday, November 6th, 2008
Developing Moodle usage statistics report for client.
Created some SQL queries and dummy report.
Structure will be as follows:
stats_collect.php -> script which collects stats from the Moodle database and updates the moodlestats database. This script should be run by a cron job like every week.
stats_display.php -> script to display the stats from ...
Posted in BrnDmp | No Comments »
Tuesday, November 4th, 2008
copy/paste from the Moodle forums:
There are some good papers around on tuning PostgreSQL, and Moodle's case does not seem to be different to the general case.
The first thing to recognise is that if you really need to worry about tuning you should be using a separate machine for the database ...
Posted in BrnDmp | No Comments »
Tuesday, November 4th, 2008
Based on earlier attempts, I did a migration of a Moodle database from mysql2postgresql:
1. install 'clean' postgresql database exactly like mysql database (copy codebase and do upgrade)
2. dump mysql, data only with full insert:
[bash]
mysqldump --skip-opt --single-transaction -u moodleuser -p -c -t db > db.20081104.sql
[/bash]
3. converting pg_dump to mysqldump by removing ...
Posted in BrnDmp | No Comments »
Tuesday, November 4th, 2008
If you want to search and replace with sed and immediately save to the file, use the -i option like this:
sed -i s/pattern1/pattern2/g filename
then pattern1 is replaced by pattern2 and replaced in the filename. If you're not sure first run the command without -i to check the output.
Posted in BrnDmp | No Comments »
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 ...
Posted in BrnDmp | No Comments »
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)
Posted in BrnDmp | No Comments »
Friday, October 31st, 2008
If you make your own courseformat or plugin and you add a lang folder to that, make sure you always include the en_utf8 packs with all the strings. That is the source file from which Moodle determines the strings to be edited in the Moodle langauge editing setting.
Posted in BrnDmp | No Comments »
Friday, October 31st, 2008
Protocol for WJ point upgrade:
Upgrade as usual
do a normal upgrae as we do for other Moodle point upgrades
Make sure all the customisations are still working
1. hide email address for everyone: line 116 in user/editlib.php should be 0 not 2
2. show / hide ip addresses in log: commnet line 321 in ...
Posted in BrnDmp | No Comments »
Friday, October 31st, 2008
upgraded Moodle of client to 1.9.3 to see if I can fix a bug. If custom profile fields are required you do not have to fill them in in the signup form.
Bug should be fixed in 1.9.3, moreover you should add Choose... as the first option.
Posted in BrnDmp | No Comments »
Wednesday, October 29th, 2008
Problems with setting default maildisplay to hidden. I changed it in editlib.php of user but when a users signs up via the normal signup form, the value is not given so the database default is used.
Changed database default value to 0 and now everything should be fine. That is quite ...
Posted in BrnDmp | No Comments »
