Dynamic timestamps in posts

Code: Select all

-new Date().getTimezoneOffset()

Code: Select all

Intl.DateTimeFormat().resolvedOptions().timeZone

Code: Select all

		// Feb 2023 / 1.41 - Get user's current offset from UTC and store as template conditional in frontend

		// Query the current user by ID and fetch user_timezone fields
		$sqlage = "SELECT user_timezone FROM phpbb_users WHERE user_id='" . $user->data['user_id'] . "'";

		// No cache here in case people are switching settings around
		$resultage = $db->sql_query($sqlage);

		// With row returned...
		while($rowo = $db->sql_fetchrow($resultage)) {

			// Store value as variable
			$user_tz_raw = $rowo['user_timezone'];

			// Conditionals to derive number and operator from database strings

			// UTC -5
			if ($user_tz_raw = 'Pacific/Easter' || 
				$user_tz_raw = 'America/Atikokan' || 
				$user_tz_raw = 'America/Bogota' || 
				$user_tz_raw = 'America/Cancun' || 
				$user_tz_raw = 'America/Cayman' || 
				$user_tz_raw = 'America/Detroit' || 
				$user_tz_raw = 'America/Eirunepe' || 
				$user_tz_raw = 'America/Grand Turk' || 
				$user_tz_raw = 'America/Guayaquil' || 
				$user_tz_raw = 'America/Havana' || 
				$user_tz_raw = 'America/Indiana/Indianapolis' || 
				$user_tz_raw = 'America/Indiana/Marengo' || 
				$user_tz_raw = 'America/Indiana/Petersburg' || 
				$user_tz_raw = 'America/Indiana/Vevay' || 
				$user_tz_raw = 'America/Indiana/Vincennes' || 
				$user_tz_raw = 'America/Indiana/Winamac' || 
				$user_tz_raw = 'America/Iqaluit' || 
				$user_tz_raw = 'America/Jamaica' || 
				$user_tz_raw = 'America/Kentucky/Louisville' || 
				$user_tz_raw = 'America/Kentucky/Monticello' || 
				$user_tz_raw = 'America/Lima' || 
				$user_tz_raw = 'America/Nassau' || 
				$user_tz_raw = 'America/New York' || 
				$user_tz_raw = 'America/Nipigon' || 
				$user_tz_raw = 'America/Panama' || 
				$user_tz_raw = 'America/Pangnirtung' || 
				$user_tz_raw = 'America/Port-au-Prince' || 
				$user_tz_raw = 'America/Rio Branco' || 
				$user_tz_raw = 'America/Thunder Bay' || 
				$user_tz_raw = 'America/Toronto'
			) {

				// Offset from UTC time
				$user_tz = '5';

				// Operator required to go from UTC time to Local time
				$user_tz_op = '-';

			}

			// Assign the value as a template variable so we can pass it to Javascript solution for determining local time

			$template->assign_block_vars('zulutimezone',array(
				'USER_TIMEZONE' => $user_tz,
				'USER_TIMEZONE_OPERATOR' => $user_tz_op
			));

	     }

Code: Select all

<script>
  
  // Let's try and convert a UTC date/time string (expressed in ISO 8601 standard format) into a Local date/time string, by providing it with the offset and operator:

  // This is the JS function that does the conversion, we'll call it in a moment...
  function convertToLocalTime(utcDateTime, offset) {
    let date = new Date(utcDateTime);
    date.setHours(date.getHours() + offset);
    return date.toLocaleString();
  }

  $(document).ready(function() {

    // This will eventually point to (each) instance of BBcode it detects through a class selector
    // The date and time of the walk will have to be expressed in ISO 8601 standard format like this example:
    let utcDateTime = "2023-04-10T02:00:00";

    // This grabs the current viewing user's offset from UTC (the offset number and the offset operator)
    let user_tz_operator = $('.z-user-tz-operator').text();
    let user_tz = $('.z-user-tz').text();

    // We have to parse the string as a number for the Date object to accept it during the calculation:
    let num_tz = parseInt(user_tz);

    // And we have to do the same as well for the operator, since both will be combined in the 'offset' constant:
    let offset = (user_tz_operator === '-') ? -num_tz : num_tz;

    // Run the conversion through the function...
    let localDateTime = convertToLocalTime(utcDateTime, offset);

    // Populate the (appropriate, probably using .closest() and .find()) date/time BBcode area with a local datetime string: 
    $(".local-date-time").text(localDateTime);
  });

</script>