home *** CD-ROM | disk | FTP | other *** search
<?php // $Id: locale.install,v 1.27 2008/01/10 14:35:24 goba Exp $ /** * Implementation of hook_install(). */ function locale_install() { // locales_source.source and locales_target.target are not used as binary // fields; non-MySQL database servers need to ensure the field type is text // and that LIKE produces a case-sensitive comparison. // Create tables. drupal_install_schema('locale'); db_query("INSERT INTO {languages} (language, name, native, direction, enabled, weight, javascript) VALUES ('en', 'English', 'English', '0', '1', '0', '')"); } /** * @defgroup updates-5.x-to-6.x Locale updates from 5.x to 6.x * @{ */ /** * {locales_meta} table became {languages}. */ function locale_update_6000() { $ret = array(); $schema['languages'] = array( 'fields' => array( 'language' => array( 'type' => 'varchar', 'length' => 12, 'not null' => TRUE, 'default' => '', ), 'name' => array( 'type' => 'varchar', 'length' => 64, 'not null' => TRUE, 'default' => '', ), 'native' => array( 'type' => 'varchar', 'length' => 64, 'not null' => TRUE, 'default' => '', ), 'direction' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), 'enabled' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), 'plurals' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), 'formula' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'domain' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'prefix' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', ), 'weight' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, ), 'javascript' => array( //Adds a column to store the filename of the JavaScript translation file. 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => '', ), ), 'primary key' => array('language'), 'indexes' => array( 'list' => array('weight', 'name'), ), ); db_create_table($ret, 'languages', $schema['languages']); // Save the languages $ret[] = update_sql("INSERT INTO {languages} (language, name, native, direction, enabled, plurals, formula, domain, prefix, weight) SELECT locale, name, name, 0, enabled, plurals, formula, '', locale, 0 FROM {locales_meta}"); // Save the language count in the variable table $count = db_result(db_query('SELECT COUNT(*) FROM {languages} WHERE enabled = 1')); variable_set('language_count', $count); // Save the default language in the variable table $default = db_fetch_object(db_query('SELECT * FROM {locales_meta} WHERE isdefault = 1')); variable_set('language_default', (object) array('language' => $default->locale, 'name' => $default->name, 'native' => '', 'direction' => 0, 'enabled' => 1, 'plurals' => $default->plurals, 'formula' => $default->formula, 'domain' => '', 'prefix' => $default->locale, 'weight' => 0)); $ret[] = update_sql("DROP TABLE {locales_meta}"); return $ret; } /** * Change locale column to language. The language column is added by * update_fix_d6_requirements() in update.php to avoid a large number * of error messages from update.php. All we need to do here is copy * locale to language and then drop locale. */ function locale_update_6001() { $ret = array(); $ret[] = update_sql('UPDATE {locales_target} SET language = locale'); db_drop_field($ret, 'locales_target', 'locale'); return $ret; } /** * Remove empty translations, we don't need these anymore. */ function locale_update_6002() { $ret = array(); $ret[] = update_sql("DELETE FROM {locales_target} WHERE translation = ''"); return $ret; } /** * Prune strings with no translations (will be automatically re-registered if still in use) */ function locale_update_6003() { $ret = array(); $ret[] = update_sql("DELETE FROM {locales_source} WHERE lid NOT IN (SELECT lid FROM {locales_target})"); return $ret; } /** * Fix remaining inconsistent indexes. */ function locale_update_6004() { $ret = array(); db_add_index($ret, 'locales_target', 'language', array('language')); switch ($GLOBALS['db_type']) { case 'pgsql': db_drop_index($ret, 'locales_source', 'source'); db_add_index($ret, 'locales_source', 'source', array(array('source', 30))); break; } return $ret; } /** * Change language setting variable of content types. * * Use language_content_type_<content_type> instead of language_<content_type> * so content types such as 'default', 'count' or 'negotiation' will not * interfere with language variables. */ function locale_update_6005() { foreach (node_get_types() as $type => $content_type) { // Default to NULL, so we can skip dealing with non-existent settings. $setting = variable_get('language_'. $type, NULL); if ($type == 'default' && is_numeric($setting)) { // language_default was overwritten with the content type setting, // so reset the default language and save the content type setting. variable_set('language_content_type_default', $setting); variable_del('language_default'); drupal_set_message('The default language setting has been reset to its default value. Check the '. l('language configuration page', 'admin/settings/language') .' to configure it correctly.'); } elseif ($type == 'negotiation') { // language_content_type_negotiation is an integer either if it is // the negotiation setting or the content type setting. // The language_negotiation setting is not reset, but // the user is alerted that this setting possibly was overwritten variable_set('language_content_type_negotiation', $setting); drupal_set_message('The language negotiation setting was possibly overwritten by a content type of the same name. Check the '. l('language configuration page', 'admin/settings/language/configure') .' and the '. l('<em>'. $content_type->name ."</em> content type's multilingual support settings", 'admin/content/types/negotiation', array('html' => TRUE)) .' to configure them correctly.'); } elseif (!is_null($setting)) { // Change the language setting variable for any other content type. // Do not worry about language_count, it will be updated below. variable_set('language_content_type_'. $type, $setting); variable_del('language_'. $type); } } // Update language count variable that might be overwritten. $count = db_result(db_query('SELECT COUNT(*) FROM {languages} WHERE enabled = 1')); variable_set('language_count', $count); return array(); } /** * @} End of "defgroup updates-5.x-to-6.x" */ /** * Implementation of hook_uninstall(). */ function locale_uninstall() { // Delete all JavaScript translation files $files = db_query('SELECT javascript FROM {languages}'); while ($file = db_fetch_object($files)) { if (!empty($file)) { file_delete(file_create_path($file->javascript)); } } // Remove tables. drupal_uninstall_schema('locale'); } /** * Implementation of hook_schema(). */ function locale_schema() { $schema['languages'] = array( 'description' => t('List of all available languages in the system.'), 'fields' => array( 'language' => array( 'type' => 'varchar', 'length' => 12, 'not null' => TRUE, 'default' => '', 'description' => t("Language code, e.g. 'de' or 'en-US'."), ), 'name' => array( 'type' => 'varchar', 'length' => 64, 'not null' => TRUE, 'default' => '', 'description' => t('Language name in English.'), ), 'native' => array( 'type' => 'varchar', 'length' => 64, 'not null' => TRUE, 'default' => '', 'description' => t('Native language name.'), ), 'direction' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => t('Direction of language (Left-to-Right = 0, Right-to-Left = 1).'), ), 'enabled' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => t('Enabled flag (1 = Enabled, 0 = Disabled).'), ), 'plurals' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => t('Number of plural indexes in this language.'), ), 'formula' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', 'description' => t('Plural formula in PHP code to evaluate to get plural indexes.'), ), 'domain' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', 'description' => t('Domain to use for this language.'), ), 'prefix' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '', 'description' => t('Path prefix to use for this language.'), ), 'weight' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => t('Weight, used in lists of languages.'), ), 'javascript' => array( 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => '', 'description' => t('Location of JavaScript translation file.'), ), ), 'primary key' => array('language'), 'indexes' => array( 'list' => array('weight', 'name'), ), ); $schema['locales_source'] = array( 'description' => t('List of English source strings.'), 'fields' => array( 'lid' => array( 'type' => 'serial', 'not null' => TRUE, 'description' => t('Unique identifier of this string.'), ), 'location' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => '', 'description' => t('Drupal path in case of online discovered translations or file path in case of imported strings.'), ), 'textgroup' => array( 'type' => 'varchar', 'length' => 255, 'not null' => TRUE, 'default' => 'default', 'description' => t('A module defined group of translations, see hook_locale().'), ), 'source' => array( 'type' => 'text', 'mysql_type' => 'blob', 'not null' => TRUE, 'description' => t('The original string in English.'), ), 'version' => array( 'type' => 'varchar', 'length' => 20, 'not null' => TRUE, 'default' => 'none', 'description' => t('Version of Drupal, where the string was last used (for locales optimization).'), ), ), 'primary key' => array('lid'), 'indexes' => array( 'source' => array(array('source', 30)), ), ); $schema['locales_target'] = array( 'description' => t('Stores translated versions of strings.'), 'fields' => array( 'lid' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => t('Source string ID. References {locales_source}.lid.'), ), 'translation' => array( 'type' => 'text', 'mysql_type' => 'blob', 'not null' => TRUE, 'description' => t('Translation string value in this language.'), ), 'language' => array( 'type' => 'varchar', 'length' => 12, 'not null' => TRUE, 'default' => '', 'description' => t('Language code. References {languages}.language.'), ), 'plid' => array( 'type' => 'int', 'not null' => TRUE, // This should be NULL for no referenced string, not zero. 'default' => 0, 'description' => t('Parent lid (lid of the previous string in the plural chain) in case of plural strings. References {locales_source}.lid.'), ), 'plural' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => t('Plural index number in case of plural strings.'), ), ), 'primary key' => array('language', 'lid', 'plural'), 'indexes' => array( 'lid' => array('lid'), 'plid' => array('plid'), 'plural' => array('plural'), ), ); return $schema; } 
