/** * Run the database seeds. * * @return void */ public function run() { DB::table('languages')->delete(); $languages = get_locales(); //Config::get('translatable.locales'); foreach ($languages as $language) { $language = ['code' => $language, 'name' => PunicLanguage::getName($language, $language)]; Language::create($language); } }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('countries')->delete(); $locales = Config::get('translatable.locales'); // $locales = get_locales(true); $countries = Territory::getCountries('en'); $producing = ['AL', 'AM', 'AR', 'AT', 'AU', 'AZ', 'BA', 'BE', 'BG', 'BO', 'BR', 'BY', 'CA', 'CH', 'CL', 'CN', 'CU', 'CY', 'CZ', 'DE', 'DZ', 'EE', 'EG', 'ES', 'ET', 'FR', 'GB', 'GE', 'GR', 'HR', 'HU', 'IL', 'IT', 'JO', 'JP', 'KG', 'KZ', 'LB', 'LI', 'LT', 'LU', 'LV', 'LY', 'MA', 'MD', 'ME', 'MG', 'MK', 'MT', 'MX', 'NZ', 'PA', 'PE', 'PT', 'PY', 'RE', 'RO', 'RS', 'RU', 'SI', 'SK', 'SY', 'TJ', 'TM', 'TN', 'TR', 'UA', 'US', 'UY', 'UZ', 'VN', 'ZA', 'ZW', 'CSHH', 'CSXX', 'SUHH', 'YUCS']; foreach ($countries as $code => $void) { $country = ['code' => $code, 'is_wine' => in_array($code, $producing)]; $nameEn = Territory::getName($code, 'en'); foreach ($locales as $key => $locale) { if (is_array($locale)) { $country[$key] = ['name' => Territory::getName($code, $key)]; foreach ($locale as $countryLocale) { $name = Territory::getName($code, $key . '-' . $countryLocale); if ($name != $country[$key]['name'] && $name != $nameEn) { $country[$key . '-' . $countryLocale] = ['name' => $name]; } } } else { $name = Territory::getName($code, $locale); if ($name != $nameEn) { $country[$locale] = ['name' => $name]; } } } $country = Country::create($country); $langs = Territory::getLanguages($code, 'of', true); $langs = array_map(function ($lang) { return str_replace('_', '-', $lang); }, $langs); $langs = array_diff($langs, get_locales(true)); foreach ($langs as $lang) { $name = Territory::getName($code, str_replace('-', '_', $lang)); $translation = $country->getNewTranslation($lang); $translation->name = $name; $translation->country_id = $country->id; $translation->save(); } } $countries = ['CSHH' => 'Czechoslovakia', 'CSXX' => 'Serbia and Montenegro', 'SUHH' => 'Soviet Union', 'YUCS' => 'Yugoslavia']; foreach ($countries as $code => $name) { $country = ['code' => $code, 'is_wine' => in_array($code, $producing), 'en' => ['name' => $name]]; $country = Country::create($country); } }
/** * Returns locale info by its code. * * It is a wrapper for {@link get_locales()} function and can be used to improve * readability of the code. * * @param string $locale * @return array|false Associative array of locale info or boolean false if the * locale is unknown. See {@link get_locales()} description for details of the * info array keys. */ function get_locale_info($locale) { $locales = get_locales(); return isset($locales[$locale]) ? $locales[$locale] : false; }
function set_locale($lang, $charset = '') { $supported = array('en_US' => array('ISO-8859-1'), 'fr_FR' => array('ISO-8859-1'), 'ko_KR' => array('EUC-KR', 'UHC')); if ($lang == 'auto') { # get broswer's settings $langs = get_locales(); $lang = $langs[0]; $charset = strtoupper($charset); # XXX $server_charset = ''; if (function_exists('nl_langinfo')) { $server_charset = nl_langinfo(CODESET); } if ($charset == 'UTF-8') { if ($charset != $server_charset) { $lang .= "." . $charset; } } else { if ($supported[$lang] && in_array($charset, $supported[$lang])) { return $lang . '.' . $charset; } else { return 'en_US'; // default } } } return $lang; }
require_once "./lib/defines.php"; require_once "./lib/module.access.php"; require_once "a2blib/Form.inc.php"; require_once "a2blib/Class.HelpElem.inc.php"; require_once "a2blib/Form/Class.SqlRefField.inc.php"; $menu_section = 'menu_config'; HelpElem::DoHelp(_("Mail templates are preset messages to be sent on alerts etc.")); $HD_Form = new FormHandler('cc_templatemail', _("Templates"), _("Template")); $HD_Form->checkRights(ACX_MISC); $HD_Form->init(); $PAGE_ELEMS[] =& $HD_Form; $PAGE_ELEMS[] = new AddNewButton($HD_Form); $HD_Form->model[] = new PKeyFieldEH(_("ID"), 'id'); $HD_Form->model[] = new TextFieldEH(_("Type"), 'mtype'); $HD_Form->model[] = new RefField(_("Lang"), 'lang', get_locales(true)); $HD_Form->model[] = dontList(new TextField(_("From Name"), 'fromname', _("Human name of sender"))); $HD_Form->model[] = new TextField(_("From"), 'fromemail', _("Email of sender")); $HD_Form->model[] = new TextField(_("Subject"), 'subject'); $HD_Form->model[] = dontList(new TextAreaField(_("Message"), 'message', _("The message, arguments are %-quoted"))); $HD_Form->model[] = dontList(new TextAreaField(_("Default args."), 'defargs', _("Default values for arguments, in URL parameter format."))); $HD_Form->model[] = new DelBtnField(); require_once "a2blib/Form/Class.ImportView.inc.php"; require_once "a2blib/Class.DynConf.inc.php"; $HD_Form->views['ask-import'] = new AskImportView(); $HD_Form->views['import-analyze'] = new ImportMailAView($HD_Form->views['ask-import']); // $HD_Form->views['import'] = new ImportView($HD_Form->views['ask-import']); //$HD_Form->views['ask-import']->common = array('idrp'); $HD_Form->views['ask-import']->csvmode = false; $HD_Form->views['ask-import']->mandatory = array('mtype', 'lang', 'fromemail', 'subject', 'message'); $HD_Form->views['ask-import']->optional = array('fromname', 'defargs');
/** * Performs all database updates needed for 2.1.0. * * @return boolean True if the updates have been applied successfully and * false otherwise. */ protected function update20100() { $db = $this->getDatabase(); if (!$db) { return false; } try { // Alter locale table. $db->query('ALTER TABLE {locale} ADD COLUMN name varchar(128) NOT NULL DEFAULT "" AFTER code'); $db->query('ALTER TABLE {locale} ADD COLUMN rtl tinyint NOT NULL DEFAULT 0'); $db->query('ALTER TABLE {locale} ADD COLUMN time_locale varchar(128) NOT NULL DEFAULT "en_US"'); $db->query('ALTER TABLE {locale} ADD COLUMN date_format text'); $db->query('ALTER TABLE {locale} ADD UNIQUE KEY code (code)'); // Create a table for available updates. $db->query('CREATE TABLE {availableupdate} ( ' . 'id INT NOT NULL auto_increment PRIMARY KEY, ' . 'target varchar(255) NOT NULL, ' . 'version varchar(255) NOT NULL, ' . 'url text, ' . 'description text, ' . 'UNIQUE KEY target (target) ' . ') charset utf8 ENGINE=InnoDb'); // Generate Unique ID of Mibew instance. $db->query('INSERT INTO {config} (vckey, vcvalue) VALUES (:key, :value)', array(':key' => '_instance_id', ':value' => Utils::generateInstanceId())); } catch (\Exception $e) { $this->errors[] = getlocal('Cannot update tables: {0}', $e->getMessage()); return false; } try { // Store configs for available locales in the database. $locales = $db->query('SELECT localeid as id, code from {locale}', null, array('return_rows' => Database::RETURN_ALL_ROWS)); $locales_info = get_locales(); foreach ($locales as $row) { $id = $row['id']; $code = $row['code']; $info = (isset($locales_info[$code]) ? $locales_info[$code] : array()) + array('name' => $code, 'rtl' => false, 'time_locale' => 'en_US', 'date_format' => array('full' => '%d %B %Y, %H:%M', 'date' => '%d %B %Y', 'time' => '%H:%M')); $db->query('UPDATE {locale} SET ' . 'name = :name, rtl = :rtl, time_locale = :time_locale, ' . 'date_format = :date_format ' . 'WHERE localeid = :id', array(':id' => $id, ':name' => $info['name'], ':rtl' => $info['rtl'] ? 1 : 0, ':time_locale' => $info['time_locale'], ':date_format' => serialize($info['date_format']))); } } catch (\Exception $e) { $this->errors[] = getlocal('Cannot update content: {0}', $e->getMessage()); return false; } return true; }
foreach ($_POST as $key => $value) { $parts = explode('_', $key); $operation = $parts[0]; $id = $parts[1]; $slug = $parts[2]; if ($parts[0] == 'update') { $value = $db->escape_string($value); $sql = $db->execute("UPDATE locale SET {$slug} = '{$value}' WHERE id = '{$id}'"); } } $slugs_string = ''; $slugs = $db->array_select("SELECT slug FROM slugs"); foreach ($slugs as $slug) { $slugs_string .= $slug['slug'] . ','; } $slugs_string = substr($slugs_string, 0, -1); $index = 0; while (!empty($_POST['insert_' . $index . '_us'])) { $values_string = ''; foreach ($slugs as $slug) { $values_string .= "'" . $_POST['insert_' . $index . '_' . $slug['slug']] . "',"; } $values_string = substr($values_string, 0, -1); $sql = "INSERT INTO locale ({$slugs_string}) VALUES ({$values_string})"; $db->execute($sql); $index++; } create_locales(); } echo $twig->render('add_locale.html', array('active_menu' => 'add_locale', 'msg' => $msg, 'title_part' => 'Adăugare traduceri', 'utils' => $utils, 'slugs' => get_locales()));