Interspire Product Knowledge Base

If you're running PHP 5.1 or higher, you can force PHP and MySQL to a different timezone. This feature is not available on earlier versions of PHP so you can only do it in this case.

Please make a backup of any file before modifying it in case you need to undo the changes. Also note that you will need to re-apply these customizations to any future version of IWP 4.x

In the following files:

/init.php
/admin/index.php

Add the following code on a new line immediately after the <?php tag at the start:

date_default_timezone_set('Australia/Sydney');

The Australia/Sydney string above may be customized to suit your needs. The full list of time zones supported by PHP can be found here:

http://php.net/manual/en/timezones.php

Then, in the file /lib/general.php locate the line below, at or near line 451:

if(GetConfigBoolean('SetNames')){

And add the following on a new line immediately before it:

$GLOBALS["AL_DB"]->Query("SET time_zone = '". date('P') ."'");

Your Website Publisher installation should now be operating under your desired time zone. Please note that there may be a period of up to 24 hours where the publishing / expire date / time of already saved articles does not function correctly, but this should clear up after this 24 hour period while the time zone adjustment takes effect.