static function set_field_value_hikashop($field, $value, $user_id) { $db = JFactory::getDBO(); switch ($field) { case 'address_country': $value = JoomdleHelperMappings::get_hikashop_country_from_moodle($value); break; default: break; } $db = JFactory::getDBO(); $query = "SELECT user_id " . ' FROM #__hikashop_user' . " WHERE user_cms_id = " . $db->Quote($user_id); $db->setQuery($query); $hikashop_user_id = $db->loadResult(); $query = ' UPDATE #__hikashop_address' . ' SET ' . $field . '=' . $db->Quote($value) . " WHERE address_user_id = " . $db->Quote($hikashop_user_id); $db->setQuery($query); $db->query(); return true; }