[Free-Project]RDB with INI

03/08/2013 15:09 gr4ph0s#1

Hello everybody i'm working a project for made easy the conversion between RDB and SQL file.

For that I will use a INI file like that it will be easy to update if the structure of RDB is updated.

My project is already started here => [Only registered and activated users can see links. Click Here To Register...]
The main functions for read/write will be made in C++ and used in Autoit.
The main core will be made in autoit POO.

For the moment just the INI class is finnished and I have to made the main function in C++ but the base is finnished ^^

V1 will be able to do RDB => SQL
V2 will be able to do SQL => RDB
V3 will be able to edit in real-time the file

PS: don't spam me I will not answered, I do this project just for fun so don't say you are slow....

03/08/2013 15:57 M>M#2

thanks dude for the project

really nice idea :D

03/08/2013 16:02 Xijezu#3

Quote:

Originally Posted by gr4ph0s

For that I will use a INI file like that it will be easy to update if the structure of RDB is updated.

I was planning to do something similar some weeks ago, but remember that not everybody knows how to get the structure when it gets changed. ;)

03/08/2013 16:09 gr4ph0s#4

Quote:

Originally Posted by Xijezu

I was planning to do something similar some weeks ago, but remember that not everybody knows how to get the structure when it gets changed. ;)

Hahaha you are moderator now... I hope you will be more active than other moderator ;)

For that I think I can does it very easy moreover to convert .pdb to .h is not hard...

03/09/2013 13:16 glandu2#5

Nice idea, better than using binaries, ini is easy to modify.

How you will manage the case of SkillJpResource in database ? sql generated files will be compatible with rappelz database out of the box ?
There is also the case of SkillTree rdb which has not the same layout as others (don't remember if it's this file, but there is at least a file with it's line count equal to group of line instead of just one line), how it's case will be managed ?

The way I managed these case is to add a special field indicating how this file should be converted. Using a better solution was too much coding for just 2 files for me, but it's a bit ugly.

I see the init will have:

Code:

[1LOOP]
ID=INT64
TEXT=STR[258]

The way the data will be proceed will be like that ? :
for each field in 1LOOP which is a structure do
for each field in 2LOOP which is a structure do
for each field in 3LOOP which is a structure do
....

?

I would have managed this way the special case:

Code:

[root]
sbustruct=STRUCT(aname)

[aname]
field1=INT64
field2=...
...

having root as a STRUCT and each structure containing these fields:

Code:

elements_count_in_struct=INT32
contents as described in [aname]

and the full rdb file would be:

Code:

timestamp=CHAR[128]
content=STRUCTURE(root)

A good idea would be the possibility to add modifiers, for example to indicate that a field should not be in the database, or is a bit that is concatened in a group of 8 bits.

The advantage of doing this (the use of a text file as a rdb describer file and not using hard coded things) is the fact that you don't have to recompile the binary after each change in rdb structures, and you don't need to add a bunch of code when gala create a new rdb file. just enough to describe the new file.

Also Gr4ph0s, i saw that you separated the version string with 0s after this string, but I think it's not needed, it can be seen as a whole string of 128 bytes which is zero-terminated (many zeroes, but it does not matter :) )

03/10/2013 17:48 gr4ph0s#6

Thanks a lot glandu2 for all of their idea.

Use syntaxe like that is more easy for manage loop and some special RDB like SkillJpResource or SkillTree

Code:

 
[header]
version=byte[4]

[Main]
id=int
!Not_present_in_DB = int // Symbol ! for say is not present in DB
1stloop=[Loop]

[Loop]
text=char[128]
union=int[myUnion]

[myUnion]
useless_bit=byte[4]
is_deva=byte[1]
is_asura=byte[1]

Where header will be read before the main part.

Ans yes 0 is not problem in char but is just an exemple of ini is not a real one ^^

03/11/2013 11:19 Skamorzo#7

How can I help you?

Ska...

03/15/2013 19:39 gr4ph0s#8

Quote:

Originally Posted by Skamorzo

How can I help you?

Ska...

Sorry for the late I was not here this week and I will be in Poland the next week so I will rework on the project in 1 week ^^

If you want you can add my skype(send me a pm) for speak or any others things ;)