/**
* Sets the timezone
*
* @param PcUser $user
*/
private static function setTimezone(PcUser $user)
{
$forumTablesPrefix = sfConfig::get('app_forum_tablePrefix');
$connection = Propel::getConnection();
$userId = $user->getForumId();
$timezone = PcTimezonePeer::retrieveByPk($user->getTimezoneId());
$timezone = $timezone->getOffset() / 60;
// in the forum the timezone is in hours, not in minutes
$query = sprintf("UPDATE " . $forumTablesPrefix . "users SET timezone=:timezone WHERE id=%d", (int) $userId);
$statement = $connection->prepare($query);
$statement->execute(array('timezone' => $timezone));
}
