Archive for November 14th, 2008

Moodle theme hack

Friday, November 14th, 2008

Hacked Moodle theme, instead of echoing $menu I now echo user_login_string(). Then the navigation is never shown and users are not able to access other topics 'via the backdoor'.

Reporting Moodle

Friday, November 14th, 2008

updated some reporting routines: created sql scripts in /path/to/transfermood/clientreport so I can run: [bash] mysql -u moodleuser -p moodle_help > course_month.sql | sed -e "s/\t/:/g" > output.txt [/bash] to list and sort files to creation time: [bash] ll -Rt --time-style=long-iso | grep -v ^d | grep - | awk '{print $6 ,  $8}' [/bash]

Create index on geoip table

Friday, November 14th, 2008

For report, created index on geoip table and geoip column in log file [sql] CREATE INDEX log_ip ON prefix_log (ip); CREATE INDEX geocoded_ip_ip ON geocoded_ip (ip); [/sql] First query halted the whole server, now query is done in 8 seconds