[RELEASE] ManGOS DB Handler

Posted Revision 152 on the UPDATER SYSTEM (there is no release, you must update) :

1 - Added the fields mingold,maxgold,ScriptName,AIName to the creature_template handler.
2 - Rearranged the creature_template handler.
 
Running mangos ver2465 with DB Handler ver152

Unable to import characters, receive the following part way through the process:

Code:
 See 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: #HY000Incorrect integer value: '' for column 'type' at row 1
   at MySql.Data.MySqlClient.PacketReader.CheckForError()
   at MySql.Data.MySqlClient.PacketReader.ReadHeader()
   at MySql.Data.MySqlClient.PacketReader.OpenPacket()
   at MySql.Data.MySqlClient.NativeDriver.ReadResult(Int64& affectedRows, Int64& lastInsertId)
   at MySql.Data.MySqlClient.CommandResult.ReadNextResult(Boolean isFirst)
   at MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume)
   at MySql.Data.MySqlClient.MySqlCommand.GetNextResultSet(MySqlDataReader reader)
   at MySql.Data.MySqlClient.MySqlCommand.Consume()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at Mangos_Database_Handler.DB.NonExecuteQuery(String SQL, Int32 D)
   at Mangos_Database_Handler.Functions.ImportTables(TextReader Lettore, Boolean Ricarica)
   at Mangos_Database_Handler.DBManagement.cmdImport_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
----------------------------------------
Mangos Database Handler
    Assembly Version: 0.3.0.0
    Win32 Version: 0.3.0.0
    CodeBase: file:///C:/Program%20Files/MaNGOS%20Database%20Handler/Mangos%20Database%20Handler.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
----------------------------------------
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
----------------------------------------
MySql.Data
    Assembly Version: 1.0.7.30072
    Win32 Version: 1.0.7.30072
    CodeBase: file:///C:/Program%20Files/MaNGOS%20Database%20Handler/MySql.Data.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
----------------------------------------

************** 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 need someone with a german and spanish wow version to contact me.
I need german and spanish DBCs for localization of most part of the program.. (i already have french and english dbcs)
If someone can aid me...
 
Posted Revision 153 on the UPDATER SYSTEM with these changes from revision 152 (there is no release, you must update) :

1 - Added Multilanguage support for the various DBs (French for now. I'll add the rest when i got the files needed)
2 - Modified the update system to be fully dynamic. (Now the updates will be lighter and specialized)

If someone have a german or Spanish client tell me here so i can make DBs for these languages too.
 
Posted Revision 154 on the UPDATER SYSTEM with these changes from revision 153 (there is no release, you must update) :

1 - Fixed the NPC Vendor Add function. (Thanks to Jonathan Kipp)
2 - Fixed a typo in the configuration screen.
3 - Added the french language. (Thanks to ThunderFX)

If someone have a german or Spanish client tell me here so i can make DBs for these languages too.
 
Posted Revision 155 on the UPDATER SYSTEM with these changes from revision 154 (there is no release, you must update) :

1 - Fixed Characters Deletion when deleting their registered account. (Thanks to Virnik for the report)
 
Last edited:
Yep, i haven't saw that bug. Fortunately Virnik reported. ;)

Posted Revision 156 on the UPDATER SYSTEM with these changes from revision 155 (there is no release, you must update) :

1 - Deleted the zlib.dll 32bit and added a Managed code implementation that work on every 32 or 64 bit without problems. :)
2 - Fixed a bug with updater.

From now on MDH is fully usable on every windows 32 or 64 bit system. :)
 
Posted Revision 157 on the UPDATER SYSTEM with these changes from revision 156 (there is no release, you must update) :

1 - Changed the exporter code for Creatures and items to be in the form DELETE...INSERT.

If someone have a german or Spanish client tell me here so i can make DBs for these languages too.
 
Posted Revision 159 on the UPDATER SYSTEM with these changes from revision 157 (there is no release, you must update) :

1 - REALLY Fixed Accounts Backup. (Thanks to Itizai for the report)
 
Posted Revision 160 on the UPDATER SYSTEM with these changes from revision 159 (there is no release, you must update) :

1 - Slightly optimized Export Function
2 - The updater will now create the updates folder if not present. :)
 
Posted Revision 162 on the UPDATER SYSTEM with these changes from revision 161 (there is no release, you must update) :

1 - Added Spanish Language DBs Support (Thanks to HadesFLG3 for the Files)

If someone have a german client tell me here so i can make DBs for this languages too.
 
Posted Revision 164 on the UPDATER SYSTEM with these changes from revision 162 (there is no release, you must update) :

1 - Completed the SECOND part of the new MDI UI system. It's the first public available release. :)
2 - Fixed the edit of the creatures to delete associated tables.
3 - Fixed the deletion of the creatures to delete associated tables.

If someone have a german client tell me here so i can make DBs for this languages too.

This version is still in BETA Testing so if you find a bug or you have a suggestion please report. ;)
 
Posted Revision 165 on the UPDATER SYSTEM with these changes from revision 164 (there is no release, you must update) :

1 - Inserted German DBs. (Thanks to Sanastro for the files. :))
2 - Fixed a bug that hided the special character from the various languages. :)
 
Posted Revision 166 on the UPDATER SYSTEM with these changes from revision 165 (there is no release, you must update) :

1 - Fixed an exception at unloading the forms through the X.
2 - Maked some changes to the updater.
 
Posted Revision 167 on the UPDATER SYSTEM with these changes from revision 166 (there is no release, you must update) :

1 - Added a Connection Status panel in the main form with fast configuration changes for dummies. :)
 
Back