[RELEASE] ManGOS DB Handler

**feal87** · 21-10-06

Rev 145 Deleted for a serious bug, for those who update i suggest to revert back.

**feal87** · 21-10-06

1 - Fixed a serious bug in the exporter.
2 - Added support for \ character in the SQL queries of all program. Please test it intensively. :)
3 - Highly optimized the Export Accounts/Chars function. (i encourage to re-export your accounts/chars with the new function)
4 - Fixed a bug with " character support inside the SQL Queries of the character_handler.

**Frubbish** · 21-10-06

Still getting an unhandled exception error when trying to export characters with version 146

**feal87** · 21-10-06

Originally Posted by Frubbish

Still getting an unhandled exception error when trying to export characters with version 146

can you post here the report?
So i can fix? :)

**feal87** · 21-10-06

Removed

**feal87** · 21-10-06

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

1 - Unhandled exception on exporting hopefully fixed.

**feal87** · 21-10-06

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

1 - Fixed importing and exporting by ShellExtension

**feal87** · 21-10-06

Posted Revision 150 (i've posted the installshield distribution for this revision and the update on the updater system so you can choose freely) :

1 - Fixed executing SQLs via ShellExtension on Realmd Database

I've posted another Installshield release cause we got enough update to make it worth. :D

**Frubbish** · 21-10-06

Working now with rev150 thankya sir!

I still have the error log for 146 if you need it for any reason.

Frub

**feal87** · 22-10-06

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

1 - Added support for # comment at the end of the line in the DB Management Area. (Maked for fixing the update 2469 released by the developers)

**feal87** · 22-10-06

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.

**Frubbish** · 23-10-06

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.

**feal87** · 23-10-06

try to export again with 152 and reimport. This problem was fixed long ago...

**feal87** · 23-10-06

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...

**feal87** · 23-10-06

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.

[RELEASE] ManGOS DB Handler

LinkBack

Thread Tools

Posting Permissions