Translation for TQ App

02/23/2012 21:36 funhacker#1
People here won't know who I am, but I am developing a major editor suite for EO, which I also plan on making it compatible with most of TQ's games that use the file structure.
I am making this app capable of having every string value within the app down to the form's text value itself to be edited, this is mostly for the use of the app in other langauges like Chinese/Arabic/Spanish and so forth. I have no language skills other than English itself.

I'm also aware of automated software, but that's messy and rarely translates to something "readable".

Read the post about the translation [Only registered and activated users can see links. Click Here To Register...]
Read the post about the app itself [Only registered and activated users can see links. Click Here To Register...]
02/23/2012 21:46 2slam#2
what a great App !!
i can Help u in Arabic

as u know Tq uses C3es and DDS

i hope we could work together

My name is Eslam
An Editor for CO
but Items name in EO Differ from CO an ids also
02/23/2012 23:24 funhacker#3
Quote:
Originally Posted by 2slam View Post
what a great App !!
i can Help u in Arabic

as u know Tq uses C3es and DDS

i hope we could work together

My name is Eslam
An Editor for CO
but Items name in EO Differ from CO an ids also
I think you misunderstood,
I only need the app itself translated not files

For example you have the "File" button, it would have to be translated to other languages so when someone who doesn't read english uses it, selects their language it will display in that language instead.
02/24/2012 00:35 2slam#4
ah i got it
im in i know arabic as i'm Egyptian
02/24/2012 06:09 InfamousNoone#5
The smarter thing to do would be to create a tool that dumps TQ-database files (such as the table cq_itemtype) to the appropriate format used (i.e. itemtype.dat)

At the end of the day, if the edit stats in the itemtype file, they'll have to update it in their servers database as well. Making changes to both seems a bit redundant.
02/24/2012 07:56 funhacker#6
Quote:
Originally Posted by InfamousNoone View Post
The smarter thing to do would be to create a tool that dumps TQ-database files (such as the table cq_itemtype) to the appropriate format used (i.e. itemtype.dat)

At the end of the day, if the edit stats in the itemtype file, they'll have to update it in their servers database as well. Making changes to both seems a bit redundant.
My itemtype editors have always offered support for MySQL editting at the same time.

This one already has a system where you can define how the data file is made and how the mysql table is made to make it 100% compatible if you know what you're doing, otherwise you would have to rely on others releasing structure files for updates.
02/24/2012 08:54 -The-Shadow-#7
Quote:
Originally Posted by InfamousNoone View Post
The smarter thing to do would be to create a tool that dumps TQ-database files (such as the table cq_itemtype) to the appropriate format used (i.e. itemtype.dat)

At the end of the day, if the edit stats in the itemtype file, they'll have to update it in their servers database as well. Making changes to both seems a bit redundant.
Barging in from the zo section (sup), I agree, all the tools I made work as dat->-db and db->-dat, even for a game like co with much less data to manage than where I come from, I wouldn't want a form laid out window to manual edit all that content, for example say you want to add a new series of items, like oh say 25k items (something I was doing before I shut down the server I was working on), a manual tool that does manual edits would take decades (even 100 items would take a plenty good amount of time to do), where as db->-dat you can use many tricks to reduce the time it takes to get the job done (eg: sql loops to create batch items then do minor edits in sql where needed for adjustments for tiers/levels and such to get a large new data set created in minutes instead of weeks).

In short I agree, db->-dat and dat->-db for updates is the way to go for speed reasons.
02/24/2012 09:02 pro4never#8
Maybe I'm just tired and confused but wouldn't it make the most sense to operate based on database in a winform frontend and then simply have a button to "dump flatfile" to have it create the proper client side updates?

Database easier to modify, works beautifully with winform (can even use fancy sql system if you really wanted to such as nhibrinate) and then you just handle dumping to client as needed.
02/24/2012 11:34 funhacker#9
Just a few things to note, a database has a keyword within it, "Data". It only contains "data" nothing more, and since the database is purely for the server only, it will only contain what is needed by the server, which means no description/image files/models/etc

My app already automatically generates gear for you if required based on values you set.

So you can make 1 Piece of gear, then tell the app that it should create 9 more higher level gears with a formula increase on the stats you wish, it then creates those 9. It then will create ref/uni/eli/sup gear versions of each of these which again can contain simple math for increasing stats.
It could take all of about 20minutes to create a full set of gear for a few classes
02/26/2012 22:22 m7mdxlife#10
I got this list from your thread on EO section i think? hope i did the translation the right way, let me know if its not the right way please.

English



Arabic

02/27/2012 02:02 funhacker#11
Quote:
Originally Posted by m7mdxlife View Post
I got this list from your thread on EO section i think? hope i did the translation the right way, let me know if its not the right way please.

English



Arabic
Thankyou for this, I'll also be adding a link to each name that is thanked in my app, so if you wish you can advertise your own server/website or I can link to your profile in epvp.

As for a few things

Neck - Yes it's necklace, just been abbreviated to the "Neck" as you also have "Pendants"
Staves - A plural of "Staff", there are two kinds of "Staff" that I can think of in the english language, one is like a large walking stick that can be used as a weapon, think mosus and parting of the red sea (not religious btw).
Itemtype / xPictureBox1 - Itemtype is a name, so no it doesn't need translation, and xPictureBox1 is never displayed, it's just easier to get the graphics device using that so it's not even displayed in that form, and rarely do you ever see any text on a XNA Picture Box.

I do have more I'll be posting again this is appreciated, and more so by those that don't understand english too well will appreciate this too.

I'll also be adding this to my post in EO section, but thought you may like it here

Note that "Item Min Icon" may need to be translated to the equivalent "Inventory Icon" and Map Item Icon "Map Icon / Dropped Item Icon"

Code:
[FormStats]
ExitButtonText=Cancel
SaveButtonText=Save Changes
FormStatsText=FormStats
ItemMinIconGroupBoxText=Item Min Icon
MainGroupBoxText=Main
MapItemIconGroupBoxText=Map Item Icon
IDLabelText=ID:
NameLabelText=Name:
DataTabPageText=Data
VisualsTabPageText=Data
ItemMinIconXNAPictureBoxText=Item Min Icon
MapItemIconXNAPictureBoxText=Map Item Icon

[FormNewFile]
CreateButtonText=Create
ExitButtonText=Cancel
SaveFileButtonText=....
FormNewFileText=FormNewFile
NameLabelText=Name:
SaveFileSaveFileDialogFilter=All Files|*.*

[FormGearStats]
IDLabelText=ID:
NameLabelText=Name:
ReqProfLabelText=Profession:
LevelLabelText=Level:
ReqLevelLabelText=Level:
ReqSexLabelText=Sex:
ReqForceLabelText=Force:
ReqDexterityLabelText=Dexterity:
ReqHealthLabelText=Health:
ReqSoulLabelText=Soul:
MonopolyLabelText=Monopoly:
GoldPriceLabelText=Gold:
MinPAtkLabelText=Min P-Atk:
MaxPAtkLabelText=Max P-Atk:
PDefLabelText=P-Def:
MinMAtkLabelText=Min M-Atk:
MaxMAtkLabelText=Max M-Atk:
MDefLabelText=M-Def:
DodgeLabelText=Dodge:
LifeLabelText=Life:
ManaLabelText=Mana:
DurabilityLabelText=Durability:
IdentifiedLabelText=Identified:
GemOneLabelText=Gem One:
GemTwoLabelText=Gem Two:
MagicOneLabelText=Magic One:
MagicTwoLabelText=Magic Two:
MagicThreeLabelText=Magic Three:
AttackRangeLabelText=Attack Range:
AttackSpeedLabelText=Attack Speed:
HitrateLabelText=Hitrate:
EPCostLabelText=EP:
SoulLabelText=Soul:
RequiredGroupBoxText=Required
StatsGroupBoxText=Stats
CostGroupBoxText=Cost
MiscGroupBoxText=Misc.
ReqProfComboBoxItemCount=4
ReqProfComboBoxItem0=None
ReqProfComboBoxItem1=Mage
ReqProfComboBoxItem2=Warrior
ReqProfComboBoxItem3=Paladin
ReqSexComboBoxItemCount=3
ReqSexComboBoxItem0=None
ReqSexComboBoxItem1=Male
ReqSexComboBoxItem2=Female
IdentifiedComboBoxItemCount=2
IdentifiedComboBoxItem0=Yes
IdentifiedComboBoxItem1=No
SaveButtonText=Save Changes
ExitButtonText=Cancel
FormGearStatsText=FormGearStats

---------------
Edit - Added a pic for you to see the arabic in action, is this readable for you?
Edit2 - Removed attachment forgot about the resizing...

[Only registered and activated users can see links. Click Here To Register...]
02/27/2012 14:17 m7mdxlife#12
Quote:
Originally Posted by funhacker View Post

[Only registered and activated users can see links. Click Here To Register...]
No need to put any links mate, its all good :)

As for Staves, the translation is " عصا " which means something like stick or wand. some arabic words got two or more equivalent in English, and this happened to be one of em :P


Arabic


P.S: Everything is translated to the " official " Arabic language, each Arabic country got its own Arabic accent, the official Arabic language is more convenient.
03/02/2012 09:17 funhacker#13
Updated the language file.

Located at this post: [Only registered and activated users can see links. Click Here To Register...]

Or this link: [Only registered and activated users can see links. Click Here To Register...]
03/06/2012 17:08 funhacker#14
Quote:
Originally Posted by -The-Shadow- View Post
Barging in from the zo section (sup), I agree, all the tools I made work as dat->-db and db->-dat, even for a game like co with much less data to manage than where I come from, I wouldn't want a form laid out window to manual edit all that content, for example say you want to add a new series of items, like oh say 25k items (something I was doing before I shut down the server I was working on), a manual tool that does manual edits would take decades (even 100 items would take a plenty good amount of time to do), where as db->-dat you can use many tricks to reduce the time it takes to get the job done (eg: sql loops to create batch items then do minor edits in sql where needed for adjustments for tiers/levels and such to get a large new data set created in minutes instead of weeks).

In short I agree, db->-dat and dat->-db for updates is the way to go for speed reasons.
Although I thought I had coded this kind of function in originally it turned out I had a minor error in code that made it in compatible with my existing form system, so I had to re-do it, however it looks a lot neater now though
I've recorded an example and uploaded to the acme site to show you and others how editing multiple items just takes seconds.

First video I show editing the names of all the selected items to match, please note my list box does not update on a timer or in realtime according to data changes, purely by methods calling it, or by focus change between forms.

Second video I show editing the Gold/EP Cost and Description of all the selected items to match.

Final note, I do not show my ref/unique/elite/super gears as they are automatically generated. So not am I only editing 5 items in the second video I'm actually editing 25 items all with different Gold costs.

[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]