38 | | You may know that all actions in Dolphin have their date/time specifications, such as Spy events, Blog and Forum posts, Chat messages, etc. All these events are stored in a MySQL database which by default uses the server time zone for them. But your web server may be located in a different country, so it may be necessary to adjust Dolphin time according to your (admin) location.[[BR]] |
| 38 | You may know that all actions in Dolphin have their date/time specifications, such as Spy events, Blog and Forum posts, Chat messages, etc. All these events are stored in a MySQL database which by default uses the server time zone for them. But your web server may be located in a different country, so it may be necessary to adjust Dolphin time according to your (admin) location. |
| 39 | |
| 40 | You will also need to change the default time zone for PHP so it could correspond to MySQL time zone. So here's how you can do it:[[BR]][[BR]][[BR]] |
| 41 | |
| 42 | '''For PHP''' |
| 43 | |
| 44 | Edit the file {{{inc/header.inc.php}}}.[[BR]] |
| 45 | Input this line: |
| 46 | {{{ |
| 47 | date_default_timezone_set( timezone_identifier ); |
| 48 | }}} |
| 49 | after |
| 50 | {{{ |
| 51 | mb_regex_encoding('UTF-8'); |
| 52 | }}} |
| 53 | |
| 54 | There are a plenty of ''timezone_identifiers'', but to make it simple, I will show only those that use GMT offsets. |
| 55 | |
| 56 | It's strange but it's true that PHP uses these offsets in a different way: a negative offset becomes positive and on the contrary. |
| 57 | |
| 58 | For example, if you live in the ''US/Central'' time zone, your GMT offset is supposed to be "-6", but you need to specify '''"Etc/GMT+6"''' as the '''''timezone_identifier''''', and if you live in ''!Europe/Berlin'' timezone, your GMT offset is supposed to be "+1" but you need to specify '''"Etc/GMT-1"'''. Those who live in ''London'', should specify '''"Etc/GMT"''' ('''please mind the quotation marks'''). |
| 59 | |
| 60 | Those who live in time zones with fractional GMT offsets, will need to use their areas timezones in this format: '''"!Asia/Rangoon"''', '''"!Australia/Adelaide"''', etc. |
| 61 | |
| 62 | The list of supported time zones can be found [http://php.net/manual/en/timezones.php here].[[BR]][[BR]][[BR]] |
| 63 | |
| 64 | '''For MySQL''' |
| 65 | |