/** * Change language-specific stuff in the db for a user. Currently * changes the name of the 'assessmentfiles' folder in the user's * files area and the views and artefacts tagged for the profile * sideblock * * @param int $userid user id to set preference for * @param string $oldlang old language * @param string $newlang new language */ function change_language($userid, $oldlang, $newlang) { if (get_field('artefact_installed', 'active', 'name', 'file')) { safe_require('artefact', 'file'); ArtefactTypeFolder::change_language($userid, $oldlang, $newlang); } set_field_select('artefact_tag', 'tag', get_string_from_language($newlang, 'profile'), 'WHERE tag = ? AND artefact IN (SELECT id FROM {artefact} WHERE "owner" = ?)', array(get_string_from_language($oldlang, 'profile'), $userid)); set_field_select('view_tag', 'tag', get_string_from_language($newlang, 'profile'), 'WHERE tag = ? AND "view" IN (SELECT id FROM {view} WHERE "owner" = ?)', array(get_string_from_language($oldlang, 'profile'), $userid)); }