Version 0.1.1

[Kayot]

Status - Does anyone even read this?

Eqemu Edit 0.1.1

Changes

• I went though and rebuilt the entire applications source code. It is now faster (compared to what?) and easer for me to read. Some of the code was redundant and is now faster on execution.
• Scripting Lexicon - A 'book' of scripting information is embedded in the program. I still need to add some credits into the credits. Check the book out, you may like it. And if you like just the book it is available for separate download in another post below this one.
• I've started XML Export coding. You can now Export a character. However import isn't finished so it's a party trick for now.
• I also changed the way character editor loads data, it now deletes the Dump file between loads. ^-^
• Merged the settings files, removed the pathetic reverse compatibility as no one was really using it. No one ever posted what versions (of eqemu) they were using so consider this a backlash of anti-communication.

That sums it up. ^-^ Please play with the export and make bug reports. Though I'm sure I'll get like one bug report ^-^ <---- Is used to the quiet. Also, feel free to request features.

[John Adams]

Originally Posted by Kayot

Status - Does anyone even read this?

Read, download, install, and test, my friend. I "QA" for a living tho, so sometimes I just cannot force myself to write another analysis. Lookin very nice tho.

Originally Posted by Kayot

Status - Does anyone even read this?

I read every single post on the forums, so worse case it will be me reading it =P

[Amra]

I always read. I read your updates and crazy stories haha!

I love your additude, Kayot. You rock

[ChaosSlayer]

when tryign to open anything (like npc or item) i am geting the same error everywhere

************** Exception Text **************
System.InvalidOperationException: Connection must be valid and open
at MySql.Data.MySqlClient.MySqlCommand.CheckState()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( )
at EQemu_SQL_Editor.frmStartingEditor.Load_Items()
at EQemu_SQL_Editor.frmStartingEditor.lstClass_Select edIndexChanged(Object sender, EventArgs e)
at System.Windows.Forms.ListBox.OnSelectedIndexChange d(EventArgs e)
at System.Windows.Forms.ListBox.WmReflectCommand(Mess age& m)
at System.Windows.Forms.ListBox.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:///D:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
KayotRO's EQemu SQL Editor Merged
Assembly Version: 1.0.2701.31826
Win32 Version: 1.0.2701.31826
CodeBase: file:///D:/games/EMULATOR/KayotRO_EQemu_Editor/EQemu%20SQL%20Database%20Editor.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///D:/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:///D:/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:///D:/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:///D:/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:///D:/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.

[jimbabwe]

Originally Posted by ChaosSlayer

************** Exception Text **************
System.InvalidOperationException: Connection must be valid and open

Looks like it can't make a connection to your database. Are your settings correct?

[ChaosSlayer]

as far as i can tell they are
they identical to settings i use for all editors writen by GeorgeS

[Kayot]

I need some more information:

Bug Report Template

Message: <Error Message>

MySQL Ver: 4.0/4.1/5.0

EQemu Ver: 0.0.0R000

Database type: PEQ/Angelox/Hybrid

What you did to create error - Only use if you did something to cause the error. Like dragging an item or saving an integer. A good bug is using the symbol ' in any text field.

[ChaosSlayer]

mySQl 5.0
EQEmu 0.7.0-992
Db PEQ
What you did to create error : tried to open anything =)

Error: DB error: Unhandled exception has occured in your applictaion. Connection must be valid and open.

[Amra]

The editor does seem to time out (connection to the DB) after a while. This may be the problem you are having. It seems to happen in a shorter period of time than it used to.

[Kayot]

^-^ I think I know why it times out sooner, I had a bunch of redundant code that was reopening the connection. I removed it so the editor would move faster.

I can solve it with a timer that reconnects the database every hour or so. Any idea's how long it stays connected? I've tested functionality but I've never done a stress test. I remember eAthena had to reconnect the DB every seven hours of inactivity.

As for the connection error, I had a connection issue on my Test System. I'm quickly fixing it. Sorry about that. It may have something to do with the connection not closing during the settings resave.

[Kayot]

Status - Emergency Update

Eqemu SQL Editor

Updates

• Fixed - Login should now work perfeckty ^-^
• Character Editor - A total revamp on the code now makes this faster than ever. I learned to use DirectCast which turned an already revised loop that would check 318 image boxes every time an item was loaded. So a full inventory would loop 101,124 times not to mention check stack size. So it's much faster now. ^-^ You get to have it before next Friday. Also, by direct casting I removed a huge array. Now if I could get around the BLOB file taking so dam long to dump.

Notes: I still have to fix a script entry in the Lexicon. ^-^

Update Reason - Turns out when I rebuilt the Login I Forgot to recall the Database connect. Since I was fixing it I also removed the splash screen that shows up over the database connect and removed the second Warning pop up that was the same as the first. Also there is now some common information in the blank on load of a non existent Settings.XML.

[Amra]

Off the top of my head it's pretty short. Maybe 30min-an hour. But I could be wrong =)

EDIT: NM =)

[Amra]

The archive is corrupt.

[Kayot]

I just downloaded it and it opened for me. Are you using Winrar?

Maybe I should pick a new distribution software. I was thinking 7-zip Self Extracting.