Version 0.1.3 to 0.2.0

[Kayot]

I think from now on, I'm going to make posts for versions in bulk. So this tread will cover Ver 0.1.3 to 0.2.0

Status - Fixing Stuff

EQemu SQL Editor (http://kayosblade.googlepages.com/KayotRO_EQemu_Editor.rar)

New as of May 28, 2007
Error Proofing - Put a check for letters in number blanks.
Error Proofing - Can now use a ' in naming, not sure if the game will like it though.
Error Proofing - Trying to open a blank ID in character edit will now open the search engine to the proper search listing.
Error Proofing - Can now save money/AA/stats up to a max values of 16,777,215.
Error Proofing - Also put in a limiter to stop people from putting letters and symbols into the text fields, it also keeps people from putting in numbers that are to high. However blank entry's will still crash the program. I'm making a protect for this.

TODO
Import of XML Character files, with possible compression on exported character files.
I need to error proof other windows to.
Get tradeskill editor to allow editing of stationary containers.
Generally get export and importing to work. I want to tackle Items after characters.

Notes : I still use WinRAR 3.30, Also, I like the bug reports and suggestions I'm getting. Keep then coming in.

Side Note - I was thinking about making another editor project. I'm going to continue working on this one. The other project would be Completely Open Source. I'm just not sure how many people would be interested in working on that project. Also, since I can't really do C# or C++ I'm not sure how many people would be interested in a VB.NET project. Any thoughts on this?

[ChaosSlayer]

well changign deity is nto havign any effect.
Editor reports that char has one deity but in game its still reporting the original deity it was (and ist not just the text - factions are not altering neither).

I also tested it whenever this is restricted by race/class combo, so i tried to change my char into a legit race/class/deity combo, but still no effect. race and class changes into anythgin you like, ogre paladins, vah shir wizards etc, but deity is stuck whatever original char had at creation.

no crushing errors to report so far.

[Kayot]

Status - Fixing Stuff

Version 0.1.3.1

Update
Deity edit now works
Add the spell icons to the program, AKA the exe is bigger now.
Added a Profile name editor, First and Last
Teaser on Character Editor

^-^ Not really an Update.

[mamba666]

For Items :
Could you add expendable under flag options or somewhere else if it makes sense?

[Kayot]

For which column? I don't see a column named expendable.

[uncommon]

Just a few things :

- I can't save any items, getting that error :
MySql.Data.MySqlClient.MySqlException: #HY000Incorrect integer value: 'False' for column 'artifactflag' at row 1

- Could you add mod2 values (shielding, avoidance, accuracy ect..) as well as focus and stuff like that to the window you get when you right click an item icon ?

Eqemu 0.7.0-992
Latest PEQ cvs
Sql editor version : it says 1.0.2706.29298

Thank you.

[mamba666]

I haven't been able to find expendable, but it is effecting the way potions work. The problem I have is that a stack of 20 potions that show expendable disapear from inventory after I click it. When I zone the stack of potions shows up in inventory again.

I figured if I made them not expandable anymore then I could just detroy them when they are used up.

[Kayot]

Wow, thats an error. For the most part, potions don't stack unless they only have one charge (And most of the time, not even then). What potion are you using? I'll look into it.

To Uncommon - I'll look into the Save problem, could you dump the item thats having the problem into a post?

As for the more information, I'll have to take a rain check on that for a little while, mainly because I still have to get the program to read spells_us.txt and use the txt file as a database and not as a delimit. After that I'll be revamping the Item Description Window to be extreamly useful.

Also, there are a lot of undocumented features in the program, so I'll start working on a Help file, however my roommates are back from their family visits, so most of my programming will happen at work. Expect Delays ^-^

[xaviusshadow]

I keep getting this error when I try to edit my character or anything else... all my info is in correctly...

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

************** Exception Text **************
System.InvalidOperationException: The CommandText property has not been properly initialized.
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()
at EQemu_SQL_Editor.frmCharacterEditor.Save_Inventory ()
at EQemu_SQL_Editor.frmCharacterEditor.cmdSave_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
----------------------------------------
EQemu SQL Editor2
Assembly Version: 1.0.2706.29298
Win32 Version: 1.0.2706.29298
CodeBase: file:///C:/Documents%20and%20Settings/Owner/My%20Documents/EQ%20Server%20Stuff/KayotRO_EQemu_Editor/EQemu%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]

Bug Reporting Template

MySQL Version - 4.0/4.1/5.0
Database Type - PEQ/Angelox/Hybrid
What you were doing - Only needed if you did something, suck as putting a letter in a number blank etc.
The error message - Message
The information you gave me is the equivalent of telling a general that a fights broken out but not telling who or where. So please make the report a little more detaled, other wise I'm going on dragon smoke. Oh, and please put the error message in a code box, it makes my life so much easer.

[xaviusshadow]

MySQL Version - 5.0
Database Type - PEQ
What you were doing - I was editing my character with platinum added and stats...
The error message -
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.InvalidOperationException: The CommandText property has not been properly initialized.
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuer y()
at EQemu_SQL_Editor.frmCharacterEditor.Save_Inventory ()
at EQemu_SQL_Editor.frmCharacterEditor.cmdSave_Click( Object sender, EventArgs e)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Obje ct key, EventArgse)
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(EventArgse,ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(Event Args e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEven tArgsmea)
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
----------------------------------------
EQemu SQL Editor2
Assembly Version: 1.0.2706.29298
Win32 Version: 1.0.2706.29298
CodeBase: file:///C:/Documents%20and%20Settings/Owner/My%20Documents/EQ%20Server%20Stuff/KayotRO_EQemu_Editor/EQemu%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.

Sorry, don't know how to put it into a codebox...

[ChaosSlayer]

Kayot, would you consider releasing your Item Icon Book as a small separate program? So I can look up icon number wihout loading the whole thing =)
thanks

[Kayot]

Alright, to xaviusshadow. I'm looking into the error. I'm not sure what caused it, though I'll try to find the error and fix it.

ChaosSlayer - I'll see about that. Sometimes sub tools are far more usefull than the full tool.

[leslamarch]

hello,
Not sure if this is the proper place to post/ask for this. When i try to unrar this tool i get 2 errors that come up.
I have tried multiple version of winrar all = same results.

! H:\eqemu files\tools\KayotRO_EQemu_Editor.rar: CRC failed in EQemu SQL Editor.exe. The file is corrupt
! H:\eqemu files\tools\KayotRO_EQemu_Editor.rar: Unexpected end of archive


Thanks for your help

[koldarin]

probably not the place for it, but it's nice to see i'm not alone. I posted a topic about it over a week ago and no response. perhaps someone who has a working version of the editor could host it somewhere?

[Kayot]

I've re uploaded the file, and added a recovery to the rar.

However, please note that this project is terminated. The project was restarted and an alfa will be coming out soon.

[leslamarch]

Kayot,
Thank you for the new download, works perfect :) can't wait to see the new project, sounds great.