[Release]Table Converter Open Source

[funhacker]

Hi guys,

Another application that is also open source. This one is a 'wip' as I've not had time to test out any other table -> data file structures yet. But it does work with cq_itemtype -> itemtype.dat. However you do need to make some modifications to your cq_itemtype table.

The application comes with a 'ItemtypeStructure.ini' file, which defines how the Itemtype is structured. This structure I made according to the best of my knowledge and added fields (although unused) that I believe to exist.

Before using this app you should make sure you cq_itemtype matches this:

Use Navicat and right click cq_itemtype and choose 'design table' make sure the fields are in the correct order too if you wish to use my structure file.

Primary Key = id
Allow Null = NONE
Decimals = 0 FOR ALL

Field Name	|Type		|Length	|Signed/Unsigned|Default Value
----------------+---------------+-------+---------------+-------------
id		|int		|4	|Unsigned	|0
name		|char		|16	|N/A		|Empty String
req_profession	|tinyint	|1	|Unsigned	|0
level		|tinyint	|1	|Unsigned	|0
req_level	|tinyint	|1	|Unsigned	|0
req_sex		|tinyint	|1	|Unsigned	|0
req_force	|smallint	|2	|Unsigned	|0
req_dex		|smallint	|2	|Unsigned	|0
req_health	|smallint	|2	|Unsigned	|0
req_soul	|smallint	|2	|Unsigned	|0
monopoly	|tinyint	|1	|Unsigned	|0
weight		|smallint	|2	|Unsigned	|0
price		|int		|4	|Unsigned	|0
id_action	|int		|4	|Unsigned	|0
attack_max	|smallint	|2	|Unsigned	|0
attack_min	|smallint	|2	|Unsigned	|0
defense		|smallint	|2	|Unsigned	|0
magic_atk_min	|smallint	|2	|Unsigned	|0
dodge		|smallint	|2	|Signed		|0
life		|smallint	|2	|Signed		|0
mana		|smallint	|2	|Signed		|0
amount		|smallint	|2	|Unsigned	|0
amount_limit	|smallint	|2	|Unsigned	|0
ident		|tinyint	|1	|Unsigned	|0
gem1		|tinyint	|1	|Unsigned	|0
gem2		|tinyint	|1	|Unsigned	|0
magic1		|tinyint	|1	|Unsigned	|0
magic2		|tinyint	|1	|Unsigned	|0
magic3		|tinyint	|1	|Unsigned	|0
magic_atk_max	|smallint	|2	|Unsigned	|0
magic_def	|smallint	|2	|Unsigned	|0
atk_range	|smallint	|2	|Unsigned	|0
atk_speed	|smallint	|2	|Unsigned	|0
hitrate		|int		|4	|Unsigned	|0
monster_type	|int		|4	|Unsigned	|0
target		|smallint	|2	|Unsigned	|0
able_mask	|tinyint	|1	|Unsigned	|0
exp_type	|tinyint	|1	|Unsigned	|0
emoney		|int		|4	|Unsigned	|0
official1	|smallint	|2	|Unsigned	|0
official2	|smallint	|2	|Unsigned	|0
official3	|smallint	|2	|Unsigned	|0
official4	|smallint	|2	|Unsigned	|0
official5	|smallint	|2	|Unsigned	|0
official6	|smallint	|2	|Unsigned	|0
official7	|smallint	|2	|Unsigned	|0
official8	|smallint	|2	|Unsigned	|0
official9	|smallint	|2	|Unsigned	|0
official10	|smallint	|2	|Unsigned	|0
official11	|smallint	|2	|Unsigned	|0
official12	|smallint	|2	|Unsigned	|0
soul_value	|int		|4	|Unsigned	|0
description	|char		|128	|N/A		|Empty String

How to create Itemtype.dat from new cq_itemtype
Open application
File -> New -> Binary File
Load Text file that has pasted data from your cq_itemtype
Load Structure file (ItemtypeStructure.ini) that was included in the application.rar
Input text that separates field values (%tab represents a tab character and is the default text)
Click 'Create Converted Binary File'
Choose name of the new file, then click save
File is now made

Note
ItemtypeStructure.ini applies to EO as of version approx 1100 (Latest Pserver version)
But in theory this application should be applicable for any other game/application.
I'm posting this thread in CO/EO/ZO sections to see if people that fully understand structures will create their own structure files and get back to me on any errors if encountered.
This source is fully open source, but also note that only and have permission to post any kind of copies of this application and/or source files.

Thanks,
funhacker

Attachments:




Important Update:
Please note I hadn't fully tested the table design I had placed. It screwed with the data when items are dropped in game.
So I've removed the 'luck' field, this also showed a minor flaw in the programming which is now fixed.
So please re-download the application.rar for the new .exe and the itemtypestructure.

[Alex06052]

Zero will now blossom :s Now that every can learn to do this on their own.......

But then again youll make a tool >.< (I ain't complaining though because it would be faster then me doing it like i am now to add all the ****)

But yes. Thanks for the good work >.< and can't wait to see what you make next.

[funhacker]

Originally Posted by Alex06052

Zero will now blossom :s Now that every can learn to do this on their own.......

But then again youll make a tool >.< (I ain't complaining though because it would be faster then me doing it like i am now to add all the ****)

But yes. Thanks for the good work >.< and can't wait to see what you make next.

To make good use of the tool however you or someone here will need to define a structure, as the structure provided with the app is only designed for EO compatability. However if you already know the structure it will only take a matter of minutes to set it up.


Important Update:
Please note I hadn't fully tested the table design I had placed. It screwed with the data when items are dropped in game.
So I've removed the 'luck' field, this also showed a minor flaw in the programming which is now fixed.
So please re-download the application.rar for the new .exe and the itemtypestructure.

[mama020153]

This would have been nice a long time ago good job funhacker.

[idlemonkey]

this has come in handy for a lot of things ...

[Bill Teach]

Thanks for posting this it helps alot

[idlemonkey]

more valuable than people know the newest things coming out on my server soon would not even be possible without this to push my stuff back to the client side files ... such a pain to edit by hand