Register for your free account! | Forgot your password?

You last visited: Today at 21:57

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


[Release]Table Convertor Open Source

Reply
 
Old   #1
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,707
[Release]Table Convertor 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

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.
Attached Files
File Type: rar TableConvertor-04-04-2012.rar (73.1 KB, 131 views)
File Type: rar Application.rar (20.3 KB, 173 views)
File Type: rar TableConverter-05-04-2012.rar (71.5 KB, 216 views)



funhacker is offline  
Thanks
17 Users
Old 04/04/2012, 15:03   #2
 
elite*gold: 0
Join Date: Mar 2011
Posts: 142
Received Thanks: 76
Nice realease dude btw why your itemtypeeditor application when im using it and after item reach 5000 description become .com ? can you explain about that?


zombaxcrop is offline  
Old 04/04/2012, 15:29   #3
 
elite*gold: 0
Join Date: Dec 2010
Posts: 70
Received Thanks: 8
Nice Release !! Thanks .. Going tu push thaT THANKS Button
grey97 is offline  
Old 04/04/2012, 17:51   #4
 
elite*gold: 0
Join Date: Nov 2008
Posts: 111
Received Thanks: 58
"Load Text file that has pasted data from your cq_itemtype"
I Don't understeand it..


corey88 is offline  
Old 04/04/2012, 19:24   #5
 
elite*gold: 0
Join Date: Oct 2007
Posts: 680
Received Thanks: 816
Well done, im impressed
cruey is offline  
Old 04/04/2012, 20:36   #6
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,707
Quote:
Originally Posted by zombaxcrop View Post
Nice realease dude btw why your itemtypeeditor application when im using it and after item reach 5000 description become .com ? can you explain about that?
That's part of the application.
This one however is 100% add free and open source

Quote:
Originally Posted by corey88 View Post
"Load Text file that has pasted data from your cq_itemtype"
I Don't understeand it..
You just have to select all the fields in your cq_itemtype and copy them, then make a text file and paste all the copied data into it.
This is the text file that you will load.



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
1 User
Old 04/05/2012, 00:47   #7
 
elite*gold: 0
Join Date: Dec 2009
Posts: 211
Received Thanks: 11
Well Done. Its much easier If Itemtype.dat convert to cq_itemtype. because Need time to make new description.
linja12 is offline  
Old 04/05/2012, 01:41   #8
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,707
Quote:
Originally Posted by linja12 View Post
Well Done. Its much easier If Itemtype.dat convert to cq_itemtype. because Need time to make new description.
I'll work on a little app that will extract all the descriptions for you and create a sql file

Edit: please note the thread:
funhacker is offline  
Old 04/06/2012, 17:18   #9
 
elite*gold: 0
Join Date: Dec 2009
Posts: 211
Received Thanks: 11
FUnhacker. This Aplication not work for me. Im Already setting it right. can help?
linja12 is offline  
Old 04/07/2012, 01:58   #10
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,707
Quote:
Originally Posted by linja12 View Post
FUnhacker. This Aplication not work for me. Im Already setting it right. can help?
Care to elaborate?
funhacker is offline  
Old 04/07/2012, 02:21   #11
 
elite*gold: 0
Join Date: Oct 2009
Posts: 1,208
Received Thanks: 924
Not sure about them, but I know I get a null exception error after it runs for a few seconds. I am pretty sure I modified the table correctly, but It could be me too.

edit
The error I get is

Code:
See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
   at cq_itemtypeToItemtypeDat.Itemtype.GetBytes(Field field)
   at cq_itemtypeToItemtypeDat.Itemtype.SaveDatFile(String fileName)
   at cq_itemtypeToItemtypeDat.FormBinaryFile.btnCreate_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.235 (RTMGDR.030319-2300)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
cq_itemtypeToItemtypeDat
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Users/MentalGaming/Desktop/EoStuff/TableConverter/cq_itemtypeToItemtypeDat/bin/Release/app/cq_itemtypeToItemtypeDat.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.235 built by: RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.232 built by: RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Configuration
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Data.InputOutput
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Users/MentalGaming/Desktop/EoStuff/TableConverter/cq_itemtypeToItemtypeDat/bin/Release/app/Data.InputOutput.DLL
----------------------------------------
System.Core
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
Eurion is offline  
Thanks
1 User
Old 04/07/2012, 13:14   #12
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,707
Quote:
Originally Posted by Eurion View Post
Not sure about them, but I know I get a null exception error after it runs for a few seconds. I am pretty sure I modified the table correctly, but It could be me too.

edit
The error I get is

Code:
See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
   at cq_itemtypeToItemtypeDat.Itemtype.GetBytes(Field field)
   at cq_itemtypeToItemtypeDat.Itemtype.SaveDatFile(String fileName)
   at cq_itemtypeToItemtypeDat.FormBinaryFile.btnCreate_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.235 (RTMGDR.030319-2300)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
cq_itemtypeToItemtypeDat
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Users/MentalGaming/Desktop/EoStuff/TableConverter/cq_itemtypeToItemtypeDat/bin/Release/app/cq_itemtypeToItemtypeDat.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.235 built by: RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.232 built by: RTMGDR
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Configuration
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Data.InputOutput
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Users/MentalGaming/Desktop/EoStuff/TableConverter/cq_itemtypeToItemtypeDat/bin/Release/app/Data.InputOutput.DLL
----------------------------------------
System.Core
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
This could possibly occur when there is no description at all
funhacker is offline  
Old 04/07/2012, 13:27   #13
 
elite*gold: 0
Join Date: Oct 2009
Posts: 1,208
Received Thanks: 924
Never thought of that, I will test it out when I get up and let you know

Edit
After re-doing the entire table, making sure there were no blank entries at all, checking the .txt file to make sure there were no blank lines, and getting rid of all Chinese from the files. I am still getting the null exception error.

I opened the itemtype.dat that it did create and it seems to be hanging at around entry 1889. So I checked that line and the ones previous to it and after it, they all seem alright. Any more ideas you can think of funhacker?
Eurion is offline  
Old 04/08/2012, 10:43   #14
 
elite*gold: 20
Join Date: Sep 2007
Posts: 1,767
Received Thanks: 1,707
Quote:
Originally Posted by Eurion View Post
Never thought of that, I will test it out when I get up and let you know

Edit
After re-doing the entire table, making sure there were no blank entries at all, checking the .txt file to make sure there were no blank lines, and getting rid of all Chinese from the files. I am still getting the null exception error.

I opened the itemtype.dat that it did create and it seems to be hanging at around entry 1889. So I checked that line and the ones previous to it and after it, they all seem alright. Any more ideas you can think of funhacker?
Did you sent format types correctly in your table?
If a field has invalid values it will most likely null the field..
When I'm feeling better I will make some changes to avoid this occurring, sorry..
funhacker is offline  
Old 04/08/2012, 13:03   #15
 
elite*gold: 0
Join Date: Oct 2009
Posts: 1,208
Received Thanks: 924
Quote:
Originally Posted by funhacker View Post
Did you sent format types correctly in your table?
If a field has invalid values it will most likely null the field..
When I'm feeling better I will make some changes to avoid this occurring, sorry..
Yes I did, I made a copy of the cq_itemtype and modified it so it was identical to your table layout in the first post. I will await an update when you're feeling better, no rush



Edit

I finally got it to work correctly, I think it was an error on my side all along.

For anyone else having issues. What I did to fix it was remove all special characters such as ` and ' also make sure there aren't any spaces in the name or description area.


Eurion is offline  
Reply

Tags
convertor, itemtype, table



« [Release] Snake Pets | [RELEASE]Complete 1070 DNP Extractor »

Similar Threads
[Release]DNP Extractor Open Source
09/04/2015 - EO PServer Guides & Releases - 12 Replies
First credits where they belong. Credits to: unknownone for writing the Filename -> Hash method. The application is available in open source, so if people wish they can code it further to allow for packing files into a dnp file as well as extracting. It works with the current EO client. Directions of Use: Place DNPExtractor.exe, Data.InputOutput.dll and DNPManager.dll in your EO client folder where your dnp files are located. (Examples are...
[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] Open source Launcher v1
01/02/2013 - EO PServer Guides & Releases - 21 Replies
Devil's launcher open source project °Features : Server status picture based. News . Costom GUI. Rollover pictures. Special Design.
[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]Pathfinder Open Source
11/30/2010 - EO PServer Guides & Releases - 10 Replies
Yes as you see this is now open source. Meaning NO one can make money using this code in ANY way. It's a 100% free. All I ask is you give credits to those that deserve it! Reason for me being so nice is people (mostly Hio77) are actually doing something and willing to share! So I am now giving out the ByteMap Encryption keys and even the source code to my pathfinder app I made. Be aware I coded this a long time ago and rushed it. I know it's not perfect. I will be updating it later on for...



All times are GMT +1. The time now is 21:57.


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.