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

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

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
Thanks to vBET 4.9.99 enjoy automatic translations