Archive for November 14th, 2008
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'.
Posted in BrnDmp | No Comments »
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]
Posted in BrnDmp | No Comments »
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
Posted in Uncategorized | No Comments »