Language Convertor

[Lionel]

Now I know this one is going to be a long shot since there aren't many of us which are using other languages.

It would have been super duper nice to have a hack that looks into the DB for all phrases without translation, presents them to us in columns

vb_name | VbOriginal | New Language

Where we input our values for New Language

on submit, we insert the missing values in DB.

Where as New language(s) column(s) will be empty for us to do our translation.

Oh my God! What a break instead of having to do all the hacks one by one!

[Zero Tolerance]

I think really your asking for the near impossible:
looks into the DB for all phrases without translation

PHP cannot determine if a string is translated or not into a selected language, since it does not contain a pre-defined database of words for each language, a developer would practicaly have to develop a library of every single word for a language.

I suggest perhaps checking if the phrase is the 'default' one, from the english language? That would be a million times easier.

- Zero Tolerance

[Lionel]

I am not a coder but I just looked at table phrase. Seems to me there are languageid, varname and text. Different languages all have the same varname.

you could check varnames to see how many doubles (if you have two languages)

You could select * where text is null and languageid=xx, xx being the new languageid, and varname is one entry (means it has not been translated)

the results pulled could be:

phraseid(uneditable) | master language(uneditable) | English translation (editable box with value if any)| Target Language (editable box empty)

then you do the insert on submit into (phraseid ....text) values (phraseid ........ newvalues) where languageid=xx and varname=varname

or whatever. I hope someone gets the idea.

[Lionel]

Actually this thing that everyone is telling me is impossible to do is already a builtin vbulletin function. As per attached image, you can see at a glance with the checkmark what has been translated or not and use the convenient edit link next to it. :squareeyed: