Log visitor local time

Created on 29 July 2023, over 1 year ago
Updated 22 May 2024, 7 months ago

Problem/Motivation

People behave differently during different times of the day. The javascript tracker already collects the visitor's local time.

Steps to reproduce

Proposed resolution

Add a new column to the visitors' table to log the visitor's local time (not a timestamp, no date).

Remaining tasks

  1. Add column
  2. Update tracker service to log local time

User interface changes

API changes

visitor_localtime: the number of seconds since midnight locally

Data model changes

New column

+-----------------------------+-----------------------+------+-----+---------+----------------+
| Field                       | Type                  | Null | Key | Default | Extra          |
+-----------------------------+-----------------------+------+-----+---------+----------------+
| visitor_localtime           | mediumint             | YES  |     | NULL    |                |
+-----------------------------+-----------------------+------+-----+---------+----------------+
📌 Task
Status

Fixed

Version

2.0

Component

Code

Created by

🇺🇸United States bluegeek9

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024