Changes in Query.php

c9de78bb5a9fc166eaa547a9847b9db132048b2e - �� Automatic code style fixes

Mon, 01 Dec 2025 14:09:22 +0000

�� Automatic code style fixes List of files: /plugin/statistics/Query.php

59a6405710015e3cf82b66fbcb12a5b8ddf5ba44 - log medium and source even when campaign is empty

Sun, 24 Aug 2025 19:26:37 +0000

log medium and source even when campaign is emptyIn theory, the UTM parameters should be hierarchical. In practice theyoften aren't. List of files: /plugin/statistics/Query.php

f666296fd6eba2c9ce30baa6c98d904f07a52045 - output campaign data

Wed, 20 Aug 2025 20:17:08 +0000

output campaign data List of files: /plugin/statistics/Query.php

444fcd225ef845c854d1d7be077e217dccb47e49 - simplify page building in admin

Wed, 20 Aug 2025 19:51:09 +0000

simplify page building in adminThis is still not as simple as I want it, but its a start List of files: /plugin/statistics/Query.php

115ede904c2b4e7274bc66c695ac92f40295cad2 - fix avg. time in session calculation

Tue, 19 Aug 2025 07:00:20 +0000

fix avg. time in session calculation List of files: /plugin/statistics/Query.php

57819987677c597985e32cb53accb57f18966f44 - Add timezone config

Fri, 15 Aug 2025 15:12:06 +0000

Add timezone config List of files: /plugin/statistics/Query.php

44f813308a35e35d99361268b4c7836be3b9f15a - apply timezone to date queries

Wed, 13 Aug 2025 13:30:38 +0000

apply timezone to date queriesFor now we simply use localtime and assume the server is running withthe correct timezone. In the future we could easily allow acongfiguration with a time zone name, calculate the offset and passsomething like '-7 hours' in $this->tzAll data stored is kept UTC List of files: /plugin/statistics/Query.php

bd514593a53266323326d4450de3aca6ab4566d8 - (auto) fixes

Wed, 13 Aug 2025 08:50:22 +0000

(auto) fixes List of files: /plugin/statistics/Query.php

b7091bfd0caef6de9c70716a61d4fb15fdc3e4f8 - fix empty user checks

Wed, 13 Aug 2025 07:39:53 +0000

fix empty user checksUsers are either set or NULL. We don't log empty strings for usersanymore List of files: /plugin/statistics/Query.php

30cf9434862e9e86ae8734948e2dfc4f96e9cb10 - refactor: inline fixed string parameters in SQL queries

Wed, 13 Aug 2025 07:36:53 +0000

refactor: inline fixed string parameters in SQL queriesCo-authored-by: aider (anthropic/claude-sonnet-4-20250514) List of files: /plugin/statistics/Query.php

6f2bdce19bfa76c541ece6166161beb0cae13c0d - simplify queries that don't need left joins

Wed, 13 Aug 2025 06:25:01 +0000

simplify queries that don't need left joins List of files: /plugin/statistics/Query.php

9fdd7e51bafea206b2557d1421fa6965d460c57e - Add topdomain page

Wed, 13 Aug 2025 06:11:19 +0000

Add topdomain pageWe were logging the data but not showing it yet List of files: /plugin/statistics/Query.php

2a30f557f7f24294810e1d10019698ec841fa49b - fix more issues, especially referer handling

Tue, 12 Aug 2025 20:28:14 +0000

fix more issues, especially referer handling List of files: /plugin/statistics/Query.php

10dcb86f38cab1d9cfa19911e1d59c086626d7c8 - adjusted queries for new schema

Tue, 12 Aug 2025 19:28:53 +0000

adjusted queries for new schema List of files: /plugin/statistics/Query.php

a5ad461ef215ddfb5a85b78a0d5d00de96625e9a - fix new incoming links query

Mon, 11 Aug 2025 08:03:03 +0000

fix new incoming links query List of files: /plugin/statistics/Query.php

a5deedd9b924698762f227875a5a08626812c4fa - fix resolution displays

Thu, 07 Aug 2025 11:22:03 +0000

fix resolution displays List of files: /plugin/statistics/Query.php

e6188c5967559ecbc707eae12598e5c18add4817 - remove icons

Thu, 07 Aug 2025 11:21:32 +0000

remove iconsThe icons were outdated and not super helpful, better to have none List of files: /plugin/statistics/Query.php

e6aa7fd9092df52f4fafef1dee183b584364e2fc - skip empty search queries in output

Thu, 07 Aug 2025 11:00:20 +0000

skip empty search queries in output List of files: /plugin/statistics/Query.php

211caa5d3906ac05d560e9ce5a3171926bbb603c - more cleanup

Wed, 06 Aug 2025 12:46:49 +0000

more cleanupmostly line lengthsparameter buildingremoval of obsolete stuff List of files: /plugin/statistics/Query.php

2adee4c68974f633621c42f9308b229422ef36a9 - apply auto fiexes

Wed, 06 Aug 2025 11:57:38 +0000

apply auto fiexes List of files: /plugin/statistics/Query.php