Go Back   EQEmulator Home > EQEmulator Forums > Development > KayotRO
Reload this Page Version 0.1.3 to 0.2.0

KayotRO This is the forum for Kayot's Editor.

Reply
Page 1 of 2 1 2
 
Thread Tools Display Modes
  #1  
Old 05-28-2007, 08:06 AM
Kayot
Discordant
  
Join Date: Sep 2006
Location: Subsection 185.D354 C.12
Posts: 346
Default Version 0.1.3 to 0.2.0
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

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?
__________________
If at first you don't succeed destroy all evidence that you ever tried.

God doesn't give second chances... Hell, he sets you up the first time.
Reply With Quote
  #2  
Old 05-30-2007, 03:57 AM
ChaosSlayer
Demi-God
  
Join Date: May 2007
Posts: 1,032
Default
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.
Reply With Quote
  #3  
Old 05-30-2007, 09:44 AM
Kayot
Discordant
  
Join Date: Sep 2006
Location: Subsection 185.D354 C.12
Posts: 346
Default
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.
__________________
If at first you don't succeed destroy all evidence that you ever tried.

God doesn't give second chances... Hell, he sets you up the first time.
Reply With Quote
  #4  
Old 05-30-2007, 12:08 PM
mamba666
Sarnak
  
Join Date: Apr 2003
Posts: 41
Default
For Items :
Could you add expendable under flag options or somewhere else if it makes sense?
Reply With Quote
  #5  
Old 06-02-2007, 08:16 AM
Kayot
Discordant
  
Join Date: Sep 2006
Location: Subsection 185.D354 C.12
Posts: 346
Default
For which column? I don't see a column named expendable.
__________________
If at first you don't succeed destroy all evidence that you ever tried.

God doesn't give second chances... Hell, he sets you up the first time.
Reply With Quote
  #6  
Old 06-03-2007, 08:10 AM
uncommon
Sarnak
  
Join Date: Feb 2002
Posts: 52
Default
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.
Reply With Quote
  #7  
Old 06-04-2007, 03:13 AM
mamba666
Sarnak
  
Join Date: Apr 2003
Posts: 41
Default
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.
Reply With Quote
  #8  
Old 06-04-2007, 06:04 AM
Kayot
Discordant
  
Join Date: Sep 2006
Location: Subsection 185.D354 C.12
Posts: 346
Default
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 ^-^
__________________
If at first you don't succeed destroy all evidence that you ever tried.

God doesn't give second chances... Hell, he sets you up the first time.
Last edited by Kayot; 06-04-2007 at 02:09 PM..
Reply With Quote
  #9  
Old 06-06-2007, 11:03 AM
xaviusshadow
Fire Beetle
  
Join Date: Jun 2007
Posts: 6
Default Problem
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.
Reply With Quote
  #10  
Old 06-07-2007, 02:26 AM
Kayot
Discordant
  
Join Date: Sep 2006
Location: Subsection 185.D354 C.12
Posts: 346
Default
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 -
Code:
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.
__________________
If at first you don't succeed destroy all evidence that you ever tried.

God doesn't give second chances... Hell, he sets you up the first time.
Reply With Quote
  #11  
Old 06-07-2007, 04:40 AM
xaviusshadow
Fire Beetle
  
Join Date: Jun 2007
Posts: 6
Default
MySQL Version - 5.0
Database Type - PEQ
What you were doing - I was editing my character with platinum added and stats...
The error message -
Code:
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(Object key, EventArgse)
at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventIntera ctive(EventArgse,ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgsmea)
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...
Last edited by Kayot; 06-07-2007 at 01:20 PM.. Reason: Added Code Window
Reply With Quote
  #12  
Old 06-07-2007, 01:15 PM
ChaosSlayer
Demi-God
  
Join Date: May 2007
Posts: 1,032
Default
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
Reply With Quote
  #13  
Old 06-11-2007, 01:14 PM
Kayot
Discordant
  
Join Date: Sep 2006
Location: Subsection 185.D354 C.12
Posts: 346
Default
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.
__________________
If at first you don't succeed destroy all evidence that you ever tried.

God doesn't give second chances... Hell, he sets you up the first time.
Reply With Quote
  #14  
Old 06-27-2007, 03:55 PM
leslamarch
Discordant
  
Join Date: Sep 2006
Location: Green Bay, WI
Posts: 436
Default
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.

Code:
!   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
Reply With Quote
  #15  
Old 06-27-2007, 05:58 PM
koldarin
Fire Beetle
  
Join Date: Jun 2007
Posts: 2
Default hey, me too.
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?
Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

   

All times are GMT -4. The time now is 11:59 PM.

EQEmulator - Archive - Top

 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3