V 0.0.10 ^-^
 

Very nice release, items icon viewer is a must!
Also tabs on windows is the way to go imo, previous system with just buttons was sometimes annoying.

Thank you for the various bugfixes, i'll continue to report the issues i run into.

Are icons built into too ? (i mean the EQDragItem folder.)

Account edit error
 

I get the following error when I try to edit or even load an account with the editor.

Any ideas as to what the problem might be?

The server database seems to be working. Accounts can log on and such and is very playable.

I would just liek an easy way to edit the account information and i really like this tool. Other functions in the tool work, so I know it is able to connect to the database.

Thank You for the good work. Any help is appreciated.


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

************** Exception Text **************
MySql.Data.MySqlClient.MySqlException: Unknown column 'rulesflag' in 'field list'
at MySql.Data.MySqlClient.PacketReader.CheckForError( )
at MySql.Data.MySqlClient.PacketReader.ReadHeader()
at MySql.Data.MySqlClient.PacketReader.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(Int 64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.CommandResult.ReadNextResul t(Boolean isFirst)
at MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume)
at MySql.Data.MySqlClient.MySqlCommand.GetNextResultS et(MySqlDataReader reader)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult( )
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( )
at EQemu_SQL_Editor.frmAccountEdit.Load_SQL()
at EQemu_SQL_Editor.frmAccountEdit.cmdLoadList_Click( Object sender, EventArgs e)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Obje ct key, EventArgs e)
at System.Windows.Forms.ToolStripButton.OnClick(Event Args e)
at System.Windows.Forms.ToolStripItem.HandleClick(Eve ntArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(M ouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventIntera ctive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(Event Args e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEven tArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Mes sage& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(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
----------------------------------------
KayotRO's EQemu SQL Editor Merged
Assembly Version: 1.0.2662.41906
Win32 Version: 1.0.2662.41906
CodeBase: file:///C:/incomming/eqemu/db%20tools/KayotRO_EQemu_Editor/KayotRO's%20EQemu%20SQL%20Editor.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
----------------------------------------
Microsoft.VisualBasic
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.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.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
----------------------------------------
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
----------------------------------------

************** 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 am using Cavedude's EQEMUserverpack-3.52.exe

It says it is compatible with 66 or 7.0

It also seems to include an eq database and peq database. I use the eq database which I believe is Cavedudes or is it DRP?

I was also using Mysql 4.025 and upgraded to 5.037 without much trouble.

I had an eqemu server going - nothing special back when we had to patch for live all the time. I just came back and was able to obtain the Titanium CD's so I am screwing around with it again.

I know this is kinda' off topic (sorry for that), but Did that little proggy from M$ work with the dll's? If it did, WOW something from M$ that works =P

Error with cavedude install
 

Yeah I have the same error with the latest cavedude install

I tried it with the PEQ and the AX databases with the same result.

Hope this helps.

I downloaded the latest CVS of PEQ and was unable to source it. I kept getting errors.

I then made a backup of the peq I have and update it with the cvs source. This didn't work because of the duplicate entries and the tables weren't quite the same.

I know this isn't your problem and I will figure it out. I just wanted to let you know that I was trying a new database. Once I get it going I'll try your editor on it.

The error with sourceing the CVS is that you have to navigate your command prompt to the directory where the files are located before running mysql. If you just run mysql, it will look for the files in your bin directory of mysql.

For example, if you downloaded the CVS to c:\peq_db you would then need to cd\peq_db in your command prompt to go into that folder first.

You can't update the PEQ database, you have to wipe the system tables and then resource them. Using CVS, source drop_system.sql and source load_system.sql will do that for you.

Yeah, my db is way out of date. Most of the data it contained I have merged into PEQ anyway so it's near 100% obsolete.

I tried starting form a clean fersh database and still didn't work.

This thread really isn't for installing dtabase so I'm gonna stop posting about updating my database here. I'll go to the PEQ forums or the server setup forums.

I'm happy with what I have right now and will address upgrading my database later.

For now I can still use most of the functions of the KayotRo tools. I also can access through an Access front end as well as Navicat MySQL. I'll have trouble with the (Blob) stuff, until I can get the latest database up and running.

Thanks for the help guys. I have a lot of ideas and things to try.

OK Update.I now have 98% or so fuctionality. I ahd to make a few updates to the databse that I have.

These updates are stated on the PEQ forums. Here are specifically the 2 I had to update.

ALTER TABLE `account` ADD `rulesflag` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';

-- This allowed me to edit the accounts

ALTER TABLE `zone` ADD `cancombat` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';

-- this allowed me to edit the zones

If I was able to source in the CVS database this would have been fixed I am sure.

The forum reference is http://www.projecteq.net/phpBB2/viewtopic.php?t=1679

I am pretty happy now and hope that htis may help someone else.

This should fix the database for using this editor if you installed the EQEMUServerpack3.6 or even 3.52 mostlikely.