Generation of item text files

[Variant]

Not sure if this is exactly where it goes, sorry if it isn't, I'm new here! I just sorta assumed this is where it goes. I also tried searching for a topic of this nature before, with no luck, so hopefully I'm not reviving an already answered suggestion or something.

I've been playing RO for a while, and I'm a huge fan of the pre-renewal mechanics, but unfortunately, it looks like the days when Gravity was a fan of those mechanics are coming to an end...

As a result, all the latest data folder item files have renewal descriptions, leaving all the pre-renewal servers in the dust. And so here's my suggestion:

Since RMS has one of the, if not the single, most extensive pre-renewal databases out there, and since I assume the information is all stored in a database (of some kind), would it be possible to have an export of all those descriptions, names, ids, etc... so as to create a completely clean, and updated, set of client text files through the use of a simple program? (A program written in C that extracts text from one file and formats it in a way and saves it in another file, I can't imagine it'd be that hard to apply it to this case)

This could also be applied to Renewal files of course, since RMS also has a Renewal Item DB, but I ask this because it's becoming increasingly harder to find an updated set of client text files that aren't renewal...

[yC]

I think, without too much work you could checkout older revision from the clientside svn:

http://svn6.assembla.com/svn/ClientSide/Translation_Project/data/

As far as I can see the head revision haven't have much update done to the data folder for nearly a year (especially for item related).  Just install some kind of svn program such as tortoise svn.  That will allow you to see change log and "go back in time".

[Variant]

Ah, well I do understand that method, and that is actually what I've been doing, but the reason I posted here was because I figured since RMS is consistently updated with the pre-renewal stats of items AND kept up to date with newer items (even if the only thing they have is 'no description', the fact that they're actually recognized is pretty huge), it would be a really useful feature to have the ability to 'export' the db and convert it into a usable desctable/nametable/slotcount, etc...

Edit:

The latest one I could find in that SVN was revision 67 (latest with pre-renewal stats), anything around 70 was renewal, to put into perspective how hard it is to find an updated set of data text files without renewal data 

[yC]

Well as you said there the item description are all well into renewal.  I can't find any non-renewal item description that are up-to-date neither.  We simply can't have the best of both world (updated + non-renewal).  Some items are manually edited to give the pre-renewal description.  The rest of the item stats you can use those from the current eAthena item_db, trunk is non-renewal still.

I can't generate file for server client, because that turn around the "supply chain".  RMS rely on translation and update from open source projects.  They can't be replaced.

[Variant]

I see. Well, the suggestion was because RMS seems to have a compilation of all the pre-renewal data in one place.

My original plan was to just go through the RMS pre-renewal item DB sorted by Item ID (ascending) and compare descriptions (for equipment, at least, I'd probably crawl up and die if I had to go through everything). I could do item_db, but then redoing defense values for armor is uh... it'd basically be staring at numbers with commas. And then I just thought, hey wait, all this data must be stored in some form of DB (my assumption was immediately SQL), and so it's gotta be exportable, and then it'd just be a matter of writing a program to reformat that SQL table export into a client file generator.

Not trying to reverse the chain of course, I just figured it'd be like Gravity releases files -> Client translation projects -> RMS' pre-renewal database (-> DB export -> Program -> Generation of updated pre-renewal text files -> -> Profit!), the same would be true of the renewal database, giving RMS the added feature of generating updated client files usable by anyone for any type of server!

[Triper]

Download fRO[French Ragnarok Online aka the RO for Europe] and get their files. fRO is one of the few officials that isn't still on Renewal.

[Variant]

Is that so? Did not know that, that's pretty awesome. So I know French is the official language of the EU, but I can still hope to find english in there, right? (Downloading their client).

Though, it isn't that big a deal, Canada forcing me to learn French has finally paid off, in one of the most unlikely ways possible o_o.

But yeah, I still think it'd be pretty cool if RMS had that feature, just because it has items up to the current episode with pre-renewal stats, and is constantly updated/manually edited to keep up.

Edit:

Yeah, it looks like there is an english folder, hope it's more updated than the translation project at revision 67!

Edit2:

I think it's either equal to or less updated o_o. I'm testing it by seeing if it has item 1627 in pre-renewal stats (it doesn't).

However, I do believe this is updated to episode 13.1 with pre-renewal stats, which is pretty impressive. Thanks Triper, this is really useful!

OT:

Is sending zeny to people how you thank them on this forum?

[Triper]

Yeah, they support eng since EuRO closed. It isn't a super 6 language server where you change the language of everything on a npc but still is good as a pre-renewal source for something.

Don't forget that they have some modifications on some items only for fRO.