Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Zero
You last visited: Today at 15:33

  • Please register to post and access all features, it's quick, easy and FREE!


[Release]Table Converter Open Source

Reply
 
Old   #1
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,704
[Release]Table Converter Open Source

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.

Code:
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.



funhacker is offline  
Thanks
3 Users
Old 04/04/2012, 15:34   #2
 
elite*gold: 0
Join Date: Feb 2009
Posts: 275
Received Thanks: 40
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.


Alex06052 is offline  
Old 04/04/2012, 20:40   #3
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,704
Quote:
Originally Posted by Alex06052 View Post
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.
funhacker is offline  
Old 04/05/2012, 04:17   #4
 
elite*gold: 0
Join Date: May 2008
Posts: 659
Received Thanks: 361
This would have been nice a long time ago good job funhacker.


mama020153 is offline  
Old 07/23/2013, 05:38   #5
 
elite*gold: 540
Join Date: May 2009
Posts: 1,548
Received Thanks: 569
this has come in handy for a lot of things ...
idlemonkey is offline  
Old 07/24/2013, 06:38   #6
 
elite*gold: 0
Join Date: May 2013
Posts: 11
Received Thanks: 2
Thanks for posting this it helps alot
Bill Teach is offline  
Old 08/17/2013, 13:51   #7
 
elite*gold: 540
Join Date: May 2009
Posts: 1,548
Received Thanks: 569
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


idlemonkey is offline  
Reply



« Server APPs | easy server start no applications »

Similar Threads
[Release]Table Convertor Open Source
01/23/2014 - EO PServer Guides & Releases - 25 Replies
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...
[Release] [E-SRO] Pet Filter [Open source]
06/02/2013 - SRO PServer Guides & Releases - 140 Replies
Hello. Today I want to release my esro pet filter. Screen: http://i53.tinypic.com/21cuq8g.jpg Known Bugs: - Not working with quests (in progress) - Doesn't detect when inv full (N/A)
[Release] DBC Converter Source
12/13/2012 - CO2 Exploits, Hacks & Tools - 21 Replies
Right, the majority of this works, however i decided in the end that it would just be best to dump the source of the project here and people can make changes and modify it as they need to. To start off you will need some .dbc files to decode to .txt files, and then you can convert them back again. Make sure you update the Count at the top of the file if you make changes, and ensure that the layout is correct, if something is placed in the wrong place or missing, then it wont work, this is...
[RELEASE] [OPEN SOURCE] CE 5.5 Pointer to AutoIt Source-Code
02/13/2011 - AutoIt - 6 Replies
Habe heute erst gemerkt, dass es hier eine AutoIt Sektion gibt xD also poste ich mal mein Programm mit rein. Funktionsweise: 1. in CE Rechtsklick auf den Pointer und auf "Copy" klicken 2. in meinem Programm auf "Code generieren" klicken 3. In euer Scite gehen und einfügen Hier ist der Source Code vom Programm:
[Release]O3D Converter Source + How to
06/16/2010 - Flyff Hacks, Bots, Cheats, Exploits & Macros - 4 Replies
Was man braucht Python 2.6 Pyglet wxPython PyOpenGl Edit Rocket Download Links unten



All times are GMT +1. The time now is 15:33.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.