show basic version show extended version

Diese Tabelle zeigt die Anzahl der fehlenden Texte pro Sprache. Bitte helfen Sie mit bei der Vervollständigung. Gut für die Übersetzung sind Wikipedia oder Übersetzungstools wie Google Translate. Farblegende: 70% oder weniger ~ mehr als 70% ~ mehr als 99% The table shows the number of missing texts per language. Please help to complete the translations. A valuable resource for translations are sites like Wikipedia or translation tools like Google Translate. Color legend: 70% or less ~ more than 70% ~ more than 99%

Wenn der Originaltext einen Grossbuchstaben am Anfang verwendet bitte auch Ihre Übersetzung mit einem Grossbuchstaben starten (sofern die gewählte Sprache Grossbuchstaben beinhaltet). Die Länge Ihrer übersetzten Worte sollte nicht (viel) länger sein als der Originaltext! Wenn ein Originaltext einen Platzhalter '%s' beinhaltet, dann muss auch in Ihrer Übersetzung '%s' vorkommen. Der Platzhalter fügt dann automatisch fehlende Informationen ein, zum Beispiel den Namen einer Region. If the English text uses a capital letter at the beginning, please also use a capital letter at the start of your text (if your language has capital letters). The length of your translated words should not be (much) longer than the original text! When an original text includes a placeholder '%s' your translation also has to include '%s'. The placeholder automatically fills in missing information, for example a region name.

Do not show conflicts anymore.

"; echo var_dump($content_vars['languages']); echo ""; */ $countcategoriesinlanguage = "select categoryid from category where name_en is not null "; $countcategoriesinlanguage .= sprintf("and importance >= %u ", $limit); $countcategoriesinlanguage .= "and deleted = false"; $content_vars['countcategoriesinlanguage'] = query($countcategoriesinlanguage); $countdatatypesinlanguage = "select datatypeid from datatype where name_en is not null "; $countdatatypesinlanguage .= sprintf("and importance >= %u ", $limit); $countdatatypesinlanguage .= "and deleted = false"; $content_vars['countdatatypesinlanguage'] = query($countdatatypesinlanguage); $countwebtextsinlanguage = "select id from webtext where name_en is not null "; $countwebtextsinlanguage .= sprintf("and importance >= %u ", $limit); $countwebtextsinlanguage .= "and deleted = false"; $content_vars['countwebtextsinlanguage'] = query($countwebtextsinlanguage); $countdefabstractsinlanguage = "select id from definition where abstract is not null "; $countdefabstractsinlanguage .= sprintf("and importance >= %u ", $limit); $countdefabstractsinlanguage .= "and (type = 'standard' or type = 'compound') "; $countdefabstractsinlanguage .= "and deleted = false"; $content_vars['countdefabstractsinlanguage'] = query($countdefabstractsinlanguage); $countregiontypesinlanguage = "select id from regiontype where name_en is not null "; $countregiontypesinlanguage .= sprintf("and importance >= %u ", $limit); $content_vars['countregiontypesinlanguage'] = query($countregiontypesinlanguage); $countregionsinlanguage = "select id from region where name_en is not null "; $countregionsinlanguage .= sprintf("and importance >= %u ", $limit); $countregionsinlanguage .= "and deleted = false "; if($limit == "false" || $limit == ""){ $countregionsinlanguage .= sprintf("and population > %u ", $pop); } else { $countregionsinlanguage .= sprintf("and population > %u ", $pop); } $content_vars['countregionsinlanguage'] = query($countregionsinlanguage); if ($extendedversion){ // include abstracts from definitions $totaltexts = count($content_vars['countcategoriesinlanguage']) + count($content_vars['countdatatypesinlanguage']) + count($content_vars['countwebtextsinlanguage']) + count($content_vars['countdefabstractsinlanguage']) + count($content_vars['countregiontypesinlanguage']) + count($content_vars['countregionsinlanguage']); } else { $totaltexts = count($content_vars['countcategoriesinlanguage']) + count($content_vars['countdatatypesinlanguage']) + count($content_vars['countwebtextsinlanguage']) + count($content_vars['countregiontypesinlanguage']) + count($content_vars['countregionsinlanguage']); } ?> select name_en, count(name_en) as number from category where name_en is not null and deleted = false group by name_en order by number desc select categoryid from category where name_en like '#name_en#'

Translation status

= %u ", $limit); $countcategoriesinlanguage .= "and deleted = false"; $content_vars['countcategoriesinlanguage'] = query($countcategoriesinlanguage); $countdatatypesinlanguage = "select datatypeid from datatype "; $countdatatypesinlanguage .= sprintf("where name_%s ", $language['isocode']); $countdatatypesinlanguage .= sprintf("is %s null ", $nullcode); $countdatatypesinlanguage .= sprintf("and importance >= %u ", $limit); $countdatatypesinlanguage .= "and deleted = false"; $content_vars['countdatatypesinlanguage'] = query($countdatatypesinlanguage); $countwebtextsinlanguage = "select id from webtext "; $countwebtextsinlanguage .= sprintf("where name_%s ", $language['isocode']); $countwebtextsinlanguage .= sprintf("is %s null ", $nullcode); $countwebtextsinlanguage .= sprintf("and importance >= %u ", $limit); $countwebtextsinlanguage .= "and deleted = false"; $content_vars['countwebtextsinlanguage'] = query($countwebtextsinlanguage); if ($language['isocode'] == "en") { $mylangstring = ""; } else { $mylangstring = "_" . $language['isocode']; } $countdefabstractsinlanguage = "select id from definition "; $countdefabstractsinlanguage .= sprintf("where abstract%s ", $mylangstring); $countdefabstractsinlanguage .= sprintf("is %s null ", $nullcode); $countdefabstractsinlanguage .= sprintf("and importance >= %u ", $limit); $countdefabstractsinlanguage .= "and (type = 'standard' or type = 'compound') "; $countdefabstractsinlanguage .= "and deleted = false"; $content_vars['countdefabstractsinlanguage'] = query($countdefabstractsinlanguage); $countregiontypesinlanguage = "select id from regiontype "; $countregiontypesinlanguage .= sprintf("where name_%s ", $language['isocode']); $countregiontypesinlanguage .= sprintf("is %s null ", $nullcode); $countwebtextsinlanguage .= sprintf("and importance >= %u ", $limit); $content_vars['countregiontypesinlanguage'] = query($countregiontypesinlanguage); $countregionsinlanguage = "select id from region "; $countregionsinlanguage .= sprintf("where name_%s ", $language['isocode']); $countregionsinlanguage .= sprintf("is %s null ", $nullcode); $countwebtextsinlanguage .= "and deleted = false "; $countregionsinlanguage .= sprintf("and importance >= %u ", $limit); if($limit == "false" || $limit == ""){ $countregionsinlanguage .= sprintf("and population > %u ", $pop); } else { $countregionsinlanguage .= sprintf("and population > %u ", $pop); } $content_vars['countregionsinlanguage'] = query($countregionsinlanguage); ?> 0) :?> = 50){ $boldtext = "font-weight:bold;"; $boldtextclass = "activerow "; } else { $boldtext = ""; $boldtextclass = " "; } if($percentvalue <= 70){ $color = "red"; } else { if($percentvalue >= 99){ $color = "green"; } else { $color = "orange"; } } ?>

	Category	Data type	Webtext	Abstracts	Region type	Regions	Total ()	Conflicts
:							100%	#listlen(listofduplicatecategories)#

	Category	Data type	Webtext	Abstracts	Region type	Regions	Total ()	Conflicts
()	= 0) :?>	= 0) :?>	= 0) :?>	= 0) :?>	= 0) :?>	= 0) :?>	0) :?> %