EQEmulator Forums - DRP: Database Editor

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::Tools (https://www.eqemulator.org/forums/forumdisplay.php?f=593)

- - DRP: Database Editor (https://www.eqemulator.org/forums/showthread.php?t=19839)

DRP: Database Editor

Hello All,

I have been working for a quite some time now on a Database Editor that is compatable with the new DB's. While I am still working on this project and I do not consider it to be close to done yet, I have finished certain parts and thought that this might be a good time to release a beta version and get some feedback on what I have done so far.

Now please keep in mind that this is still in development and only a beta test version. I have tested everything I could think of to work so far but may have missed something. I would strongly recommend that you make a copy of your Database and use that for testing. So far I have completed Editing Loot Tables, Spell Tables, System Variables, and NPCs to a point. . Please give it a try and let me know what you think of it so far and you can email any questions of comments that you may have to EqEmuEditor@sesmar.net. For Bug reports please include a detailed message of what you were doing when the error occurred and a screenshot would be helpful if possible.

Now for installation.
You can download the installer from:
http://eqemu.sesmar.net/DB_Editor/DRP_Editor.rar

This package contains 3 files, two of them are for the installer (the .exe and .msi files). The third a .sql file needs to be sourced into your Database in order for the program to work. This is just a couple of code tables that I have created to make my life easier, such as list of spells, races, bodytypes etc. . I would suggest sourceing the .sql file first then running the file named Setup.exe to install the program. Please let know of any difficulties that any one has with the installation so I can make this easier in the future as well.

Thank you all for your time and I hope you find what I have been working on useful.

Well, from what I can see, it looks great!

However, I get errors when I try and actually do anything :(

It happened when I tried to edit Cazic Thule using the "Npc Editor" -> "Edit Npc". I did a search for the string "Cazic" and selected "Cazic_Thule" (ID 72004) from the list. When I clicked the "Select" button, I got the following error:

EDIT: Oh, if I hit "Continue" in the error dialog box, it just causes the editor to hang and the list of NPCs.

Code:

See the end of this message for details on invoking 

just-in-time (JIT) debugging instead of this dialog box.



************** Exception Text **************

System.IndexOutOfRangeException: Could not find specified column in results

   at MySql.Data.MySqlClient.MySqlDataReader.GetOrdinal(String name)

   at EMUMAIN.NPC.NPC..ctor(Int32 NPCID)

   at dbeditor.frmNpc..ctor(Int32 NPCID)

   at dbeditor.frmSearch.btnSelect_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: 2.0.0.0

    Win32 Version: 2.0.50727.42 (RTM.050727-4200)

    CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

----------------------------------------

dbeditor

    Assembly Version: 1.0.0.0

    Win32 Version: 1.0.0.0

    CodeBase: file:///C:/Program%20Files/Dark%20Rogue%20Productions/dbeditor.exe

----------------------------------------

System.Windows.Forms

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.42 (RTM.050727-4200)

    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

----------------------------------------

System

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.42 (RTM.050727-4200)

    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

----------------------------------------

System.Drawing

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.42 (RTM.050727-4200)

    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

----------------------------------------

EMUMAIN20

    Assembly Version: 1.0.2153.23323

    Win32 Version: 1.0.2153.23323

    CodeBase: file:///C:/Program%20Files/Dark%20Rogue%20Productions/EMUMAIN20.DLL

----------------------------------------

MySql.Data

    Assembly Version: 1.0.6.15336

    Win32 Version: 1.0.6.15336

    CodeBase: file:///C:/Program%20Files/Dark%20Rogue%20Productions/MySql.Data.DLL

----------------------------------------

System.Data

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.42 (RTM.050727-4200)

    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll

----------------------------------------

System.Xml

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.42 (RTM.050727-4200)

    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

----------------------------------------

System.Configuration

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.42 (RTM.050727-4200)

    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

----------------------------------------



************** JIT Debugging **************

To enable just-in-time (JIT) debugging, the .config file for this

application or computer (machine.config) must have the

jitDebugging value set in the system.windows.forms section.

The application must also be compiled with debugging

enabled.



For example:



<configuration>

    <system.windows.forms jitDebugging="true" />

</configuration>



When JIT debugging is enabled, any unhandled exception

will be sent to the JIT debugger registered on the computer

rather than be handled by this dialog box.

Note: I had to change the database referenced in the "EditorRequired.sql" file from `peq` to `eqemu` because I was getting other errors where the Editor couldn't find my database. Could that have caused the problem?

What version of the Database are you using?

Ok some how the version of the Editor that I put up was the not the most current version. I am sorry for the inconvience here. I have recompiled and put up a new version to download (use same link). You will have to uninstall the previous version in order to install this one. Thank you.

OK, I've completely reloaded my database using the PEQ Velious DB file available at http://www.projecteq.net/ and gotten everything working (by everything, I mean all my server stuff - PHP, Apache, MySQL, and Perl - as well as all the web-based tools - PHPMyAdmin, the ProjectEQ Database Editor, and the Magelo Clone thingy - so I'm good there. Note that I did have to source some additional files for the ProjectEQ Database Editor.

I've also uninstalled the old version of DRP and redownloaded/reinstalled the new one (using that first link of yours). The DRP's still crashing at the same spot however. It gives the following error message (which is now different than the one I was getting even if it is popping up in the same place):

Code:

See the end of this message for details on invoking 

just-in-time (JIT) debugging instead of this dialog box.



************** Exception Text **************

System.IndexOutOfRangeException: Could not find specified column in results

   at MySql.Data.MySqlClient.MySqlDataReader.GetOrdinal(String name)

   at EMUMAIN.NPC.NPC..ctor(Int32 NPCID)

   at dbeditor.frmNpc..ctor(Int32 NPCID)

   at dbeditor.frmSearch.btnSelect_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: 2.0.0.0

    Win32 Version: 2.0.50727.42 (RTM.050727-4200)

    CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

----------------------------------------

dbeditor

    Assembly Version: 1.0.0.0

    Win32 Version: 1.0.0.0

    CodeBase: file:///C:/Program%20Files/Dark%20Rogue%20Productions/dbeditor.exe

----------------------------------------

System.Windows.Forms

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.42 (RTM.050727-4200)

    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

----------------------------------------

System

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.42 (RTM.050727-4200)

    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

----------------------------------------

System.Drawing

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.42 (RTM.050727-4200)

    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

----------------------------------------

EMUMAIN20

    Assembly Version: 1.0.2181.25699

    Win32 Version: 1.0.2181.25699

    CodeBase: file:///C:/Program%20Files/Dark%20Rogue%20Productions/EMUMAIN20.DLL

----------------------------------------

System.Data

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.42 (RTM.050727-4200)

    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll

----------------------------------------

System.Xml

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.42 (RTM.050727-4200)

    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

----------------------------------------

MySql.Data

    Assembly Version: 1.0.7.30072

    Win32 Version: 1.0.7.30072

    CodeBase: file:///C:/Program%20Files/Dark%20Rogue%20Productions/MySql.Data.DLL

----------------------------------------

System.Configuration

    Assembly Version: 2.0.0.0

    Win32 Version: 2.0.50727.42 (RTM.050727-4200)

    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

----------------------------------------



************** JIT Debugging **************

To enable just-in-time (JIT) debugging, the .config file for this

application or computer (machine.config) must have the

jitDebugging value set in the system.windows.forms section.

The application must also be compiled with debugging

enabled.



For example:



<configuration>

    <system.windows.forms jitDebugging="true" />

</configuration>



When JIT debugging is enabled, any unhandled exception

will be sent to the JIT debugger registered on the computer

rather than be handled by this dialog box.

I'm pretty sure that it's not a DB connectivity issue (seeing as I can get a list of NPCs before the program hangs), but should I have any MySQL ODBC drivers installed?

I am trying everything I can to try and recreate this error but I can not seem to make that happen. What the error seems to be is that when trying to load the NPC from the Database my program is trying to load a field that does not exist ( or is spelled differently ) in your DB from mine. I am going to try loading a default PEQ DB to see if I can recreate the error you are getting.

As for ODBC Drivers, you do not need any. I am using MySql.Net Connector 1.07 and that is working for you.

Ok after loading a fresh DB I believe that I have found the problem. Since this DB was built they have added support for Attributes into the Emu and you will just need to source these few lines into your DB in order for the editor to work.

Code:

ALTER TABLE npc_types ADD STR MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';

ALTER TABLE npc_types ADD STA MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';

ALTER TABLE npc_types ADD DEX MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';

ALTER TABLE npc_types ADD AGI MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';

ALTER TABLE npc_types ADD _INT MEDIUMINT UNSIGNED NOT NULL DEFAULT '80';

ALTER TABLE npc_types ADD WIS MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';

ALTER TABLE npc_types ADD CHA MEDIUMINT UNSIGNED NOT NULL DEFAULT '75'; 

UPDATE npc_types SET _INT=80 WHERE _INT=75;

UPDATE npc_types SET _INT=60 WHERE _INT=80 AND ( bodytype=3 OR bodytype=8);

You can view more information on this at http://www.projecteq.net/phpBB2/viewtopic.php?t=308

And the PEQ schema repository
http://www.projecteq.net/phpBB2/viewtopic.php?t=262

Sourcing those lines in to the Database should fix your problem though.

Wewt! It works now!

/me does the happy dance

DRP Editor Beta 0.4.8.5

I have now completed Faction Tables in the Database Editor. This will allow you to create new and edit the existing faction tables in the database. I also made a small change to the Database setting editor so it will populate your current connection information. That is all the big changes for this release. Please let me know what you think of the editor and let me know about any issues or problems you may be having.

You can download the installation package at http://eqemu.sesmar.net/DB_Editor/DR...ta-0_4_8_5.rar

DRP: Database Editor - New Release

This release is mostly just bug fixes and functionality changes. I reworked the way searching for the different tables works and fixed a few bugs pertaining to Faction and Loot Tables. Also added a "Clone" feature to the NPC Form so you can quickly make a copy of the current NPC. You can download the new Setup package at:

http://eqemu.sesmar.net/DB_Editor/DR...ta_0.5.0.0.rar

Please let me know of any bugs you find of features you would like to see implemented and I will work on these things as soon as I can.

Quote:

Originally Posted by sesmar

im guessing this is for 0.6.4 and I use version 0.6.0 and it crashes.

Yes, this editor is made to support 6.2+, however it may work for you. You will have to source the EditorRequired.sql file into your Database first though.

If you have done this and it still crashes then the problem is probably that Stats have been added to the NPC's and your database does not contain these fields. Adding the npc stat fields to the database should allow you to use the editor, but I do not know what kind of problems may arise from adding these fields to your 6.0 compatable database.

Quote:

Originally Posted by sesmar

it causes major problems ,I tried that and ended up having to remove them when finished editing.
theres a lot of different fields added and it's to time consumeing to convert them all.

Well, Thanks for trying it out. Now I know that it is just not compatable with 6.0 with out making a lot of changes. Sorry it did not work out for you.