[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.

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 [Only registered and activated users can see links. Click Here To Register...] and [Only registered and activated users can see links. Click Here To Register...] 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.

Nice realease dude btw why your itemtypeeditor application when im using it and after item reach 5000 description become [Only registered and activated users can see links. Click Here To Register...] .com ? can you explain about that?

Nice Release !! Thanks .. Going tu push thaT THANKS Button :D

"Load Text file that has pasted data from your cq_itemtype"
I Don't understeand it..

Well done, im impressed :)

Quote:

Originally Posted by zombaxcrop Nice realease dude btw why your itemtypeeditor application when im using it and after item reach 5000 description become [Only registered and activated users can see links. Click Here To Register...] .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 "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.

Well Done. Its much easier If Itemtype.dat convert to cq_itemtype. because Need time to make new description.

Quote:

Originally Posted by linja12 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: [Only registered and activated users can see links. Click Here To Register...]

FUnhacker. This Aplication not work for me. Im Already setting it right. can help?

Quote:

Originally Posted by linja12 FUnhacker. This Aplication not work for me. Im Already setting it right. can help?

Care to elaborate?

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

Quote:

Originally Posted by Eurion 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

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?

Quote:

Originally Posted by Eurion 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..

Quote:

Originally Posted by 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..

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.