commit 59ba3435708ad5277e7e2e7c0e20063f7d050548
author avm99963 <me@avm99963.com> Mon Sep 28 19:03:29 2020 +0200
committer avm99963 <me@avm99963.com> Mon Sep 28 19:03:29 2020 +0200
tree b05e5b19e7edd2ab47dc6f6b33960d343446a638
parent 282af722a37da7e4843bc6c68ca18b34cb57c8da

Canvi de date a timestamp a la taula classes

Ara les columnes 'begins' i 'ends' contindran enters en comptes de
dates, per solventar un problema existent amb la diferència de zones
horàries. Els enters seran UNIX timestamps.

Change-Id: I460b9b33447e21f05349107d68eb61bd36304780

inc/Classes.php

diff --git a/inc/Classes.php b/inc/Classes.php
index f0ebf90..b7e05a9 100644
--- a/inc/Classes.php
+++ b/inc/Classes.php
@@ -15,8 +15,8 @@
           ON s.id = u_s.subject_id
         ' : '').
         'WHERE
-          c.begins < NOW() AND
-          c.ends > NOW()'.($isSignedIn ? ' AND
+          c.begins < UNIX_TIMESTAMP() AND
+          c.ends > UNIX_TIMESTAMP()'.($isSignedIn ? ' AND
           (
             u_s.user_id = :user_id OR
             u_s.subject_id IS NULL