Changes between Version 4 and Version 5 of GenFAQ

Timestamp:

Feb 22, 2011, 8:46:06 PM (14 years ago)

Author:

IgorL

Comment:

--

GenFAQ

@@ -5 +5 @@
 ----
 
-    == '''''I need to transfer my site to another folder on my server. What do I need to do?''''' ==
+== '''''I need to transfer my site to another folder on my server. What do I need to do?''''' ==
 
-    1) First of all, you need to move the whole structure of the Dolphin installation directory to the folder you like. You can use the "move" command in your FTP client or use
+1) First of all, you need to move the whole structure of the Dolphin installation directory to the folder you like. You can use the "move" command in your FTP client or run this command
 
-   {{{
-   cd DOLPHIN_FOLDER
-   mv * DESTINATION_FOLDER
-   }}}
+{{{
+cd DOLPHIN_FOLDER
+mv * DESTINATION_FOLDER
+}}}
 
-   command in your SSH account, where ''DOLPHIN_FOLDER'' is the folder where Dolphin is installed and ''DESTINATION_FOLDER'' is the folder where it needs to be placed.
+in your SSH account, where ''DOLPHIN_FOLDER'' is the folder where Dolphin is installed and ''DESTINATION_FOLDER'' is the folder where it needs to be placed.
 
-   2) Then you need to edit the paths in the file '''inc/header.inc.php''': change the values of the following variables according to your current settings:
+2) Then you need to edit the paths in the file '''inc/header.inc.php''': change the values of the following variables according to your current settings:
                   
-    {{{$site['url']}}} and {{{$dir['root']}}}
+{{{$site['url']}}} and {{{$dir['root']}}}[[BR]][[BR]]
    
-   3) Then change the path to dolphin directory in your crons. You can do that in your host's control panel account (for example, CPanel or Plesk) or in your SSH client by running this command:
+3) Then change the path to dolphin directory in your crons. You can do that in your host's control panel account (for example, CPanel or Plesk) or in your SSH client by running this command:
    
-   {{{
-   crontab -e
-   }}}
+{{{
+crontab -e
+}}}
 
- 4) And the last step is to clean '''/cache/''' and '''/cache_public/''' folders.
+4) And the last step is to clean '''/cache/''' and '''/cache_public/''' folders.
 
 ----
+
+== '''''How can I change the server time in Dolphin?''''' ==
+
+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]]
+You will need to change the time zone offsets in 3 files: for Dolphin itself, for Orca and for Ray.
+
+Here are these files:[[BR]]
+''Note: the offset parameter should specify your time zone offset in comparison to GMT time, for example: +6:00, -7:30, etc.''[[BR]][[BR]]
+1) For Dolphin:[[BR]]
+edit {{{/inc/classes/BxDolDb.php}}}[[BR]]
+find the line:
+{{{
+mysql_query("SET sql_mode = ''", $this->link);
+}}}
+and put this line right after it:
+{{{
+mysql_query("SET @@local.time_zone='offset';", $this->link);
+}}}
+2) For Ray:[[BR]]
+edit {{{flash/modules/global/inc/db.inc.php}}}
+and put this line
+{{{
+mysql_query("SET @@local.time_zone='offset';", $this->rLink);
+}}}
+after
+{{{
+mysql_query("SET @@local.connect_timeout=9000;", $this->rLink);
+}}}
+3) For Orca:[[BR]]
+edit {{{modules/boonex/forum/classes/BxDb.php}}}
+and put this line
+{{{
+mysql_query("SET @@local.time_zone='offset';", $this->link);
+}}}
+after
+{{{
+mysql_query ("SET NAMES 'utf8'", $this->link);
+}}}
+
+Then you need to recompile Orca languages in {{{Admin Dashboard -> Modules -> Orca Forum -> Manage Forum}}} and also clear the site cache in {{{Admin Dashboard -> Quick Overview -> Clear Cache}}}
+
+This is it. Now the time on all pages and in all widgets should correspond to admin's local time.