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;

or to get the visitor_id on top:

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