I just trying to decode the value stored in log_visit.location_ip. I need to run a query from my database to compare the ip and id from the log_visit table. We pull the IP on our database and store that value and I need to find (through Piwiks awesome abilities) the more accurate referral_url and keywords used to get there. I was gonna run a query from the ip store at the time they viewed our site and the time the did so and run a comparison so I could find the referral_url/keywords. I tried inet_ntoa() and that bad boy gave me a whole bunch of 0.0.0.0. I have Piwik 1.5.1 and a little time on my hands…and a turkey sandwich to keep me company.
P.S. Varbinary? Really? Who does that… :S