V 0.0.10 ^-^

[Kayot]

Bet cha thought I was going for the big 0.1.0. Anyway

Download Link:
EQemu MySQL Editor

New

• New Layouts, Lets face it, the multi window wasn't working out. It corrupted items, and mess up my taxes... sort of...
• Item Editor/Zone editor - Yeay for tabs, took a bunch of rewriting but I think it works.
• Character editor is still bugged, (The whole needing one item or it fails to save bug)
• New Tool - Item Icon Book, ever wanted to see every item icon in the game? Now you can with their ids. Good for making new items. It still doesn't have a click, and may never have one. Why? Because the DB customizer should have some work, stop being lazy!
• Merged all the Available/Open into one window, the buttons are just for show right now.
• Tradeskill editor is *Still* broken, I'm still working on it. Blame keyboarding class, that program is evil (No backspacing allowed, we hates them)
• Augment editor - Sort of kind of doesn't really work all that well. It's low on my priority list... really low. Go in game and mount it for now.
• Book Editor - Don't save, oh dear god, don't save. You'll regret it. However the program now shows the text in paragraph form. Its pretty.
• Multi windows is no longer an option. Its always on. Why? Why not?
• There was a bunch of code changes... I'm sure of it.
• DLLs - Yeay, no more DLLs. Feel free to get rid of them. The program is now (Minus setting files) self contained.

Programmer: I fixed/Updated/Broke allot. I'm currently working on issues brought up on the board. I want to add a spell reader. I hate putting 1000 for the cast id. I want to search for a spell with certain stuff in it and use it. I'm also working on exporters. And a script maker that is in Alfa-, Be looking forward to the next release.

P.S. Amra asked for the name of my server. My server is called KayotRO. It's only on-line for short times and is more for the devs of KayotRO than anything else. We are finnaly testing the program out.

[uncommon]

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

[Kayot]

Everything is built in ^-^. No need for subfolders, or DLLs.

[mamba666]

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.

[Kayot]

I'll have that fixed in the next version.

Update: Which DB are you using?

[mamba666]

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.

[samandhi]

I know this is kinda' off topic (sorry for that), but

Originally Posted by Kayot

Everything is built in ^-^. No need for subfolders, or DLLs.

Did that little proggy from M$ work with the dll's? If it did, WOW something from M$ that works =P

[Kayot]

Yea, it worked, and worked well. I enjoyed using it.

[mwmdragon]

Yeah I have the same error with the latest cavedude install

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

************** Exception Text **************
System.FormatException: Input string was not in a correct format.
   at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
   at MySql.Data.Common.DBConnectionString.ConnectionParameterParsed(Hashtable hash, String key, String value)
   at MySql.Data.MySqlClient.MySqlConnectionString.ConnectionParameterParsed(Hashtable hash, String key, String value)
   at MySql.Data.Common.DBConnectionString.Parse(String newConnectString)
   at MySql.Data.MySqlClient.MySqlConnection.set_ConnectionString(String value)
   at MySql.Data.MySqlClient.MySqlConnection..ctor(String connectionString)
   at EQemu_SQL_Editor.Common.DatabaseConnect()
   at EQemu_SQL_Editor.frmDBLogin.LoadSQLConnect()
   at EQemu_SQL_Editor.frmDBLogin.cmdLoadSQL_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
----------------------------------------
KayotRO's EQemu SQL Editor Merged
    Assembly Version: 1.0.2662.41906
    Win32 Version: 1.0.2662.41906
    CodeBase: file:///C:/Documents%20and%20Settings/MWMDragon/Desktop/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
----------------------------------------

************** 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 tried it with the PEQ and the AX databases with the same result.

Hope this helps.

[Kayot]

mamba666 - Have you tried updating your DB's to the PEQ CVS? Cave dudes DB is old, and by old I mean it's missing sevearal thousand entrys.

I checked the scheme of the newest PEQ database and rulesflag is in there.

CREATE TABLE account (
  id int(11) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  charname varchar(64) NOT NULL default '',
  sharedplat int(11) NOT NULL default '0',
  `password` varchar(50) NOT NULL default '',
  `status` int(5) NOT NULL default '0',
  lsaccount_id int(11) unsigned default NULL,
  gmspeed tinyint(3) unsigned NOT NULL default '0',
  revoked tinyint(3) unsigned NOT NULL default '0',
  minilogin_ip varchar(32) NOT NULL default '',
  hideme tinyint(4) NOT NULL default '0',
  rulesflag tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY lsaccount_id (lsaccount_id)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

Also, mwmdragon, are you using Mysql 4.0? That error is about the input of the mysql command being messed up because the connector libabry is for 4.1+

[mamba666]

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.

[techguy84]

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.

[cavedude]

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.

[mamba666]

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.

[mamba666]

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.