projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
combined
(merge:
20a8a42
5256e5a
)
fix conflicts
author
leon
<leon@roojs.com>
Fri, 27 Oct 2023 07:34:19 +0000
(15:34 +0800)
committer
leon
<leon@roojs.com>
Fri, 27 Oct 2023 07:34:19 +0000
(15:34 +0800)
1
2
TimeZone.php
patch
|
diff1
|
diff2
|
blob
|
history
diff --cc
TimeZone.php
index
f0e5fc1
,
e69d856
..
78f5a9a
---
1
/
TimeZone.php
---
2
/
TimeZone.php
+++ b/
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