PDA

View Full Version : Solved how do I - Initial user language selection for all existing users



dacho
01-11-10, 18:01
Is there a query to choose for all existing users of their language?

vBET
01-11-10, 18:10
User default language is stored in table user in column vbet_def_lang. So you can check it just by query to user table. For example this will tell you popularity of languages (not tested):


SELECT vbet_def_lang, count(*)
FROM user
GROUP BY vbet_def_lang

AfrikaansAlbanianArabicBelarusianBulgarianCatalanChineseCroatianCzechDanishDutchEnglishEstonianFilipinoFinnishFrenchGalicianGermanGreekHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKoreanLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTaiwaneseThaiTurkishUkrainianVietnameseWelshYiddish
Translations delivered by vB Enterprise Translator 4.10.1