Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Tools
Reload this Page DRP: Database Editor

Development::Tools 3rd Party Tools for EQEMu (DB management tools, front ends, etc...)

Reply
 
Thread Tools Display Modes
  #1  
Old 12-21-2005, 06:37 AM
sesmar
I built it I will Support it!
  
Join Date: Jun 2005
Location: Michigan
Posts: 214
Default
What version of the Database are you using?
Reply With Quote
  #2  
Old 12-21-2005, 07:25 AM
sesmar
I built it I will Support it!
  
Join Date: Jun 2005
Location: Michigan
Posts: 214
Default
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.
Reply With Quote
  #3  
Old 12-22-2005, 11:08 AM
mikenune
Discordant
  
Join Date: Apr 2004
Location: Gukta
Posts: 359
Default
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?
__________________
THE POSTER assumes no warranty, guarantee, or representation as to the accuracy
or sufficiency of the information presented herein, and THE POSTER assumes no
responsibility or liability regarding the use or misuse of such information.
Furthermore THE POSTER assumes no responsibility and makes no warranty, guarantee,
or representation for the content of any web or FTP sites linked to or from this
post.

THE POSTER reserves the right to change the terms, conditions, and notices under
which THE POSTER presents information. It is the responsibility of THE READER to
regularly review these terms, conditions, and notices. THE READER understands that
the reading of any content including or covered by this disclaimer constitutes THE
READER's acceptance of and agreement to such changes.

THE POSTER retains the right to in any way alter the content of this post at any
time with or without prior notice to THE READER.
Reply With Quote
  #4  
Old 12-23-2005, 12:13 AM
sesmar
I built it I will Support it!
  
Join Date: Jun 2005
Location: Michigan
Posts: 214
Default
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.
Reply With Quote
  #5  
Old 12-23-2005, 01:10 AM
sesmar
I built it I will Support it!
  
Join Date: Jun 2005
Location: Michigan
Posts: 214
Default
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.
Reply With Quote
  #6  
Old 12-23-2005, 06:24 PM
mikenune
Discordant
  
Join Date: Apr 2004
Location: Gukta
Posts: 359
Talking
Wewt! It works now!

/me does the happy dance
__________________
THE POSTER assumes no warranty, guarantee, or representation as to the accuracy
or sufficiency of the information presented herein, and THE POSTER assumes no
responsibility or liability regarding the use or misuse of such information.
Furthermore THE POSTER assumes no responsibility and makes no warranty, guarantee,
or representation for the content of any web or FTP sites linked to or from this
post.

THE POSTER reserves the right to change the terms, conditions, and notices under
which THE POSTER presents information. It is the responsibility of THE READER to
regularly review these terms, conditions, and notices. THE READER understands that
the reading of any content including or covered by this disclaimer constitutes THE
READER's acceptance of and agreement to such changes.

THE POSTER retains the right to in any way alter the content of this post at any
time with or without prior notice to THE READER.
Reply With Quote
  #7  
Old 01-27-2006, 06:49 AM
sesmar
I built it I will Support it!
  
Join Date: Jun 2005
Location: Michigan
Posts: 214
Default 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
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

   

All times are GMT -4. The time now is 11:54 PM.

EQEmulator - Archive - Top

 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3