Accessibility of interface

[formerly known as hf]

Translation in Cantr is done almost at the last point of constructing a page
searching for translated text requires a lot more preprocessing as all searchable items will require translating before the search can begin.

Hmm... So translated text is held seperate to the main database? And processed after?
As a bar-stool programmer who knows sweet fa - could queries not be sent to the relevant section of the translated text db first, and then that be used to produce responses from the main db?

[Chris Johnson]

Slightly different - easier to illustrate with an example - I'll use projects as we do have a search function on them

The project name is stored in the database in english

Currently if you searched for a project the database just returns all who fit the search (and are in the same location)- the database itself does the search (and is optimised to do this type of thing) - All fine and efficient if you just have one language

If we internationalise searching we have to get all the projects from the database in that location , translate each one into that char's language (which involves several more database queries), then search the translations and show the matches. - quite a few extra steps and a lot more queries

Now objects and clothes are already available for translation - but a Polish speaker is probably not going to want to search for a "screwdriver" but a for a "śrubokręt" so the search query is going to have to run on the translated names not the original english ones


Now there are ways around this for generic items - we can cache translated names and we can search the translation tables instead of the object details tables but it's still further overheads - and not straight forward

[Sicofonte]

The project name is stored in the database in english
[...]
If we internationalise searching we have to get all the projects from the database in that location , translate each one into that char's language (which involves several more database queries), then search the translations and show the matches. - quite a few extra steps and a lot more queries

Now objects and clothes are already available for translation - but a Polish speaker is probably not going to want to search for a "screwdriver" but a for a "śrubokręt" so the search query is going to have to run on the translated names not the original english ones


Now there are ways around this for generic items - we can cache translated names and we can search the translation tables instead of the object details tables but it's still further overheads - and not straight forward

- get all the projects from the database in that location (1 query)
- translate each one into that char's language (1 query per each project name)
- then search the translations for matches with the player's query (1 query per each translation)
- and show the matches.


I'm not a DB specialist, but maybe this other way could be faster:

Assuming there is a table (PNTT) for the translations of project's names...

- query against the PNTT for the projects of which names in the char's language matches the search (1 query)
- get all the projects in that location that matches the english names obtained in the previous query (1 query per each project's name)
- and show the matches.

[marol]

It seems easy only when you don't know the details. Let's take one your point:

- translate each one into that char's language (1 query per each project name)

It would be:
For every project, take it's requirements list.
For each requirement determinte requirement type (raw, object, tool, time...).
For each requirement look up into translations table (26 thousand entries) to see if translation is available, otherwise look up again into translation table for english word.

And when you go deeper into the detail, more work will show up...

[in vitro...]

how about a "get all" button?

and how about a "get all resources, objects, notes, attack all and run in random direction" button?

You must have charracters in the same town as me...

I really doubt it. You'll have to have at least 1 char in polish zone, do you?

________________
speaking english kills me

[Phalynx]

Żaden. nie mam człowiek w polskiej strefie.

[in vitro...]

A ja nie mam "człowiek" w angielskiej strefie

_______________
polish is a barbaric latin

[Dozess]

for projects like smoking meet or drying dung, where person have to enter desired amount of end product, would be nice to have additional fields for raw recourses to be used, and automatic calculator that fills in other fields.

for example:
starting project drying dung gives two fields, one desired amount of dry dung, another field amount of fresh dung, which one want to use for the project. if one enters amount of fresh dung, amount of dry dung is calculated and displayed in field for dry dung. If one edits dry dung field, amount of fresh dung is recalculated and displayed accordingly.

I hope explanation was not very complicated.

[Phalynx]

It would save me some time trying to use the clunky windows calculator!

[in vitro...]

http://www.sendspace.com/file/qpy1ee
its a very userful tool made by NiKnight. Not yet translated so you must find a good dictionary or wait for EN version.

[Rusalka]

Oh, and an instruction how to launch it. Cause I can't...

[Sicofonte]

for projects like smoking meet or drying dung, where person have to enter desired amount of end product, would be nice to have additional fields for raw recourses to be used, and automatic calculator that fills in other fields.

for example:
starting project drying dung gives two fields, one desired amount of dry dung, another field amount of fresh dung, which one want to use for the project. if one enters amount of fresh dung, amount of dry dung is calculated and displayed in field for dry dung. If one edits dry dung field, amount of fresh dung is recalculated and displayed accordingly.

I hope explanation was not very complicated.

AGREED

[Elros]

Yeah same here. I just downloaded it, but it only has a few XML files and some plugins. There doesn't seem to be an executable file or anything. So I could use some help in running it also.

[Dozess]

http://www.sendspace.com/file/qpy1ee
its a very userful tool made by NiKnight. Not yet translated so you must find a good dictionary or wait for EN version.

What does this tool do? I can't open this site.

[Elros]

for projects like smoking meet or drying dung, where person have to enter desired amount of end product, would be nice to have additional fields for raw recourses to be used, and automatic calculator that fills in other fields.

for example:
starting project drying dung gives two fields, one desired amount of dry dung, another field amount of fresh dung, which one want to use for the project. if one enters amount of fresh dung, amount of dry dung is calculated and displayed in field for dry dung. If one edits dry dung field, amount of fresh dung is recalculated and displayed accordingly.

I hope explanation was not very complicated.

Yeah! i completely agree with this. I have that about it many times, because when trying to calculate the exact amount of something you need to make with resources you have I always have to pull out the calculator.

The only thing I could think of about this though is that sometimes it would yeild a half or part of a number or something, so you would just have to round it. e.g. You might end up with like 435.5 grams of iron if you are choosing how much ore you have instead of how much iron you make. But this shouldn't be hard to work around.