Piwik

some hints on piwik (1.10.x at the moment)

Mysql

some tricks to work with the mysql...

location_ip decoding

decode location_ip values in DB to human readable (dottet-quad) notation.

mysql> SELECT inet_ntoa(conv(hex(location_ip), 16, 10)) AS IP from log_visit;