#aaronpkthose timestamps are microseconds, so divide by 1000000 to get the unix timestamp
#aaronpkeverything after june 11 2016 was logged by both the file logs and the database, so I only imported the DB logs from before that. but that means the timestamps between the two logs differ by a fraction of a second
#aaronpkso I guess i'll delete all the filesystem logs and re-import from the database :/
#ZegnatHmm, but the DB logs had unicode problems that the filesystem didnβt have, right?
#aaronpkyes although I think something fixed those problems around that same time
#aaronpkalso I have a little cleanup script to un-break most of the encoding issues
#aaronpkit's just that most of Loqi's hooks are configured on the indieweb channels, since it doesn't make sense for Loqi to respond to certain things in other freenode channels
#aaronpkfor things like "who is", those are scoped to the indieweb channels to then use the indieweb lookup
#aaronpkfrom a DM, there's no way to know which context it's from
#aaronpkexcept this is tricky because those are also in the "name" of that post
#tantekutm_ is a commonly used prefix for URL query parameters used for tracking (like utm_medium utm_source utm_campaign) by various media and content publishing sites; it is considered good [[URL design]] to automatically drop them when publishing, sharing, or just linking to a URL that has them.
#Loqiok, I added "https://github.com/aaronpk/p3k-utils/blob/master/src/url.php#L29 - open source PHP function to strip tracking params from a URL" to the "See Also" section of /utm