fix conflicts
authorleon <leon@roojs.com>
Fri, 27 Oct 2023 07:34:19 +0000 (15:34 +0800)
committerleon <leon@roojs.com>
Fri, 27 Oct 2023 07:34:19 +0000 (15:34 +0800)
1  2 
TimeZone.php

diff --cc TimeZone.php
@@@ -76,6 -76,10 +76,12 @@@ class Pman_Core_TimeZone extends Pma
                  *, TIME_FORMAT(TIMEDIFF(NOW(), CONVERT_TZ(NOW(), Name, 'UTC')), '%H:%i') as timeOffset
              FROM
                  mysql.time_zone_name
 -                NAME NOT LIKE 'Etc%'
+             WHERE
+                 Name LIKE '%/%'
+                 AND
++                LENGTH(Name) - LENGTH(REPLACE(Name, '/', '')) = 1
++                AND
++                Name NOT LIKE 'Etc%'
              ORDER BY
                  timeoffset DESC,
                  Name DESC