BrnDmp

Custom reporting Moodle 2

Continued from this post Custom reporting Moodle.

So from the previous post I got all the data I want from the standard Moodle log table. All I need is a mapping between ip-address and country / city / latlon . To geocode the ip-addresses I use the API from hostip, on the same site there is an example php script with a geocode function that uses caching.

• created mapping table in the database
• wrote php script to connect to the database and update the table with the geocoded ip addresses