Piwik
Aus SchnallIchNet
Version vom 28. Januar 2013, 07:53 Uhr von Cbs (Diskussion | Beiträge)
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;