Version 0.1.1

[Amra]

I tried both winrar and 7-Zip, no luck. Must be a problem on my end.

[Kayot]

I'll make an self-installer (yuck) and post it to the board. ^-^

P.S. After looking at this option I must ask, is anyone else having a problem extracting the archive?

[ChaosSlayer]

well my archive file is openign fine, but i got a new error =)

when tryign to access char editor or npc editor

#42000 You have an error in your SQL syntax
incorect syntax near 'and componentcount >= order by item_id' at line 1


on opening item editor:

#42000 You have an error in your SQL syntax
Failed to populate DB
Incorect syntax near " at line 1

[Kayot]

Now that is a weird error, the only part of the editor that has componentcount is the tradeskill editor. That shouldn't effect loading character_ and npc_types at all.

What DB are you using?

P.S. Could you take a full screen shot and submit it to any photo sharing site. I think it might help me to see the warning.

P.S.2 Ah, I think I know your problem. I haven't put any safe guards in yet. When clicking open you have to put something in the blank other wise it breaks the sql command. I'll spend this week putting in some safety's to prevent loading a '' entry. ^-^ It's about time I made it break proof. Though I only get to Wednesday, my room mates will be back Thursday which means no computer time.

[ChaosSlayer]

umm I see.. this is kind of... not a user friendly feature if proramm expects me to know dozens of multydigit IDs of thigns i want to edit =)
i thought the program would open a search window for me to search by name etc =)

the char editor with ability to edit stats and deyty is awsome thought
still crash on Save =)

Error message below and i will try to post a screenshot later on


Arithmetic operation resulted in overflow!

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

************** Exception Text **************
System.OverflowException: Arithmetic operation resulted in an overflow.
at EQemu_SQL_Editor.frmCharacterEditor.Save_Values_to _Array()
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:///D:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
KayotRO's EQemu SQL Editor Merged
Assembly Version: 1.0.2703.24324
Win32 Version: 1.0.2703.24324
CodeBase: file:///D:/games/EMULATOR/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:///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
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///D:/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:///D:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///D:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.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]

On the tool bar there is a button that opens the search window. I'll probably add a feature that will auto open it when the number blank is empty.

The error your getting on save is because the values can't exceed 256 (One byte). I'm going to put in some safety's in the next ver. I think it's time to make the program crash proof.

[ChaosSlayer]

values can't exceed 256

if this is size of stored data..then how its posible to predict whats the limit?
like STR 100 + 500 plat in the bank is too much, but 70 STR and 20 plat will work?
some selection of combos producing an overflow? which ones?

[Kayot]

^-^ Each value can be a number ranging from 0-256. I'm still working on the loader though. I didn't even think about coins. I'll recode this and fix my Duh moment. Consider this a bug until I set it up to use Integers instead. And don't edit any characters.

Originaly the new system was made so Importing and Exporting of character files would be possible. A few tweaks will fix this. Mainly I have to increase the size of the array values to Integers.

Looks like I have some work cut out for me.

TODO

• Put a check for letters in number blanks.
• Setup a Replace that will exchange ' into '' and back to allow ' in Text Fields
• Make it so a Blank in any lookup field will skip a load and turn on the search engine. Preferable set the search engine to the proper search type.
• Change Byte to Int to allow larger values/ or build a sub that will combine and divide blanks based on their maximum values. Latter is preferred.
• Put a number limiter on many Text Fields to prevent overflows.
• Setup XML Import to work so It's no longer a party trick, see about adding a compression function so the XML files will be smaller... Most of the file is impossible to read anyway.

^-^ I'll get on that list in the morning.

[ChaosSlayer]

just made a little experiment

it appears it was the 500 plat i put into bank that were crushing the save =)

took my Agnostic Barberian Warrior (a test char) and converted him into Dark Elf Monk of Karana =)

will see if it works in game- in worst case scenario i will just delete him =)

[ChaosSlayer]

in game report: my char has succesefuly changed from barbi warrior to dark elf monk, despite all the bronze armor on him =)
The deity however is questionable: the editor reports that deity is Karana but in game I am been shown Agnostic

[Amra]

I had to extract it with another computer. I tried Alpha Zip on the other computer didn't work. Then I tried WinRar on that computer and it worked. Wierd. I never had a problem like that before. Have you changed the version of WinRar since the last time you issued a release?

Anyway, It's working =)

I haven't yet had a problem opening items or saving characters. I will play around and try to break it.