Meal timings not working on current timing

sampoyigi

You can set your mysql default timezone using the

@@session.time_zone variable

How about using PHP's time instead so it matches the timezone set in admin? Something like?

		$current_time = $this->db->escape(mdate('%H:%i:%s', time()));
		$this->db->select('IF(start_time <= '. $current_time .', IF(end_time >= '. $current_time .', "1", "0"), "0") AS is_mealtime', FALSE);

jestintab

Hi,

I had problem I assigned meal timings to certain menu items, but it was not working.!

Finally with some troubleshoot I figured the problem. Timezone on mysql was '-05:00' and I want '+03:00'

mysql hosted on hostgator server, I tried to reset the timezone to my timzone but failed. So I changed the code to retrieve current time from mysql to my timezone using the below code.

	$this->db->select('IF(start_time <= time(convert_tz(now(),"-05:00","+03:00")), IF(end_time >= time(convert_tz(now(),"-05:00","+03:00")), "1", "0"), "0") AS is_mealtime', FALSE);

time(convert_tz(now(),"-05:00","+03:00")) used instead of current_time()

How I can set timezone without changing code? Any help will be appreciated.

The quick hard code for the issue is posted myself. But let me know by anyway i can improve the code

jestintab

thank youuuuuuuuuu!

hoithak

sampoyigi wrote You can set your mysql default timezone using the

@@session.time_zone variable

How about using PHP's time instead so it matches the timezone set in admin? Something like?

		$current_time = $this->db->escape(mdate('%H:%i:%s', time()));
		$this->db->select('IF(start_time <= '. $current_time .', IF(end_time >= '. $current_time .', "1", "0"), "0") AS is_mealtime', FALSE);

Where I can put this code? Thank you