Universal Data Conversion

05/05/2012 23:46 funhacker#1
Hey guys, I know there's the whole UG now and all, but I'm hoping that perhaps you "knowledgeable" people will be willing to atleast part ways with some basic structures (even if in pseudo) and associated table/field names.

I ask this because I've hugely improved my [Only registered and activated users can see links. Click Here To Register...]. This handy app allows you to define some fields and a structure and then simply drag/drop a config file into the app and it will convert a MySQLTable into any structure that you could think of.

I've still got things to add to it as time goes, such as data types: Date/Time and Conversion types like: INI -> binary binary -> ini/MySQLTable

An example of its current power is I overloaded my "cq_goods" (table that defines what items are for sale and where in EO) with a fraction over 101k items (100k of which were Mall entries (452 bytes each in a file))
This converts from the table in 9 seconds, about 5 of which is spent executing the query for the mall to obtain all the information for the 100k+ items.
I just need an abundance of different structures to test it's uses out
I'm pretty certain there won't be a single (unencrypted/uncompressed) data structure it won't be able to convert to.
05/10/2012 18:47 funhacker#2
Just thought I'd let you guys know, that this app even does simple tables into ini files
Take this structure for example:
Code:
chararray@-1#[TypeID/n]|1,byte@32|1,chararray@-1#[Level/n]|1,byte@32|1,chararray@-1#[Life/n]|1,byte@32|1,chararray@-1#[MaximumPhysicalAttack/n]|1,byte@32|1,chararray@-1#[MinimumPhysicalAttack/n]|1,byte@32|1,chararray@-1#[PhysicalDefence/n]|1,byte@32|1,chararray@-1#[MaximumMagicalAttack/n]|1,byte@32|1,chararray@-1#[MinimumMagicalAttack/n]|1,byte@32|1,chararray@-1#[MagicalDefence/n]|1,byte@32|1,chararray@-1#[Dexterity/n]|1,byte@32|1,chararray@-1#[Dodge/n]|1,ushort@2573|1|[ItemCount/n]
Converts a table of the following:
Code:
+-----+--------+-------+------+------------+------------+---------+------------+------------+-----------+-----------+-------+
| id  | typeid | level | life | attack_max | attack_min | defense | mgcatk_max | mgcatk_min | magic_def | dexterity | dodge |
+-----+--------+-------+------+------------+------------+---------+------------+------------+-----------+-----------+-------+
To an ini file that looks like so:
Code:
typeid level life attack_max attack_min defense mgcatk_max mgcatk_min magic_def dexterity dodge
typeid level life attack_max attack_min defense mgcatk_max mgcatk_min magic_def dexterity dodge
typeid level life attack_max attack_min defense mgcatk_max mgcatk_min magic_def dexterity dodge
typeid level life attack_max attack_min defense mgcatk_max mgcatk_min magic_def dexterity dodge
typeid level life attack_max attack_min defense mgcatk_max mgcatk_min magic_def dexterity dodge
typeid level life attack_max attack_min defense mgcatk_max mgcatk_min magic_def dexterity dodge
typeid level life attack_max attack_min defense mgcatk_max mgcatk_min magic_def dexterity dodge
etc...