so i update to the one u are at? could i have like a link or somthing?
Printable View
so i update to the one u are at? could i have like a link or somthing?
just go to
Log In
and search around there for an updated database and go here for an update mangos:
http://forum.ragezone.com/world-warc...-166402-8.html
k thx :)
i cant seem to find a update for mdh..
mhn...maybe i've not maked clear...
YOU NEED TO UPDATE YOUR MANGOS AND YOUR DATABASE,
NOT MDH
ooooooooooo, yea lol thats more clearer
ok i updated to mangos 2823, now where do i extract sdb too? im not very good at this kinda stuff...like i think i extracted the mangos wrong i dunno im not good at this at all..where do i extract them sdb 0.5.3 changeset 20
im still getting this error..#42S02Table 'mangos.item_loot _template' doesnt exsist.. and if im updating mangos do i have to start from the beggining or do i just update to the one u are at now??
Posted Revision 218 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Some changes are undergoing into the interfaces.
Posted Revision 219 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Fixed a bug into the creature_loot_template handler.
2 - Added the group loot ID into the creature_loot_template handler.
2 - Added the fully completed skinning_loot_template handler.
hi dunno if this has been addressed but i get this error,
"Font 'Tahoma' does not support style 'Regular'." I can continue to load MDH but it doesnt load. Thanks in advance.
Mhn...Have you tried replacing the Tahoma font with another one?
Posted Revision 220 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Added the MovementType, dynamicflags, flags field to the creature_template handler.
Posted Revision 221 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Fixed a serious bug in the item_subclass Database.
Installshield Revision 222 (Aka 0.3.0 Official) OUT
Download from the official website
Important changes from the last Installshield Release :
1 - This revision support ONLY MaNGOS Revision 2865+
2 - Updated the import/export function to the latest MaNGOS. ;)
3 - Fixed a blocking bug on the SQL Logging system.
4 - Added a restarter logging system for the newly created restarter.
5 - Fixed the Clear Log functionality for the 2 part of the program
6 - Added a FREEZE system detection and restart into the restarter!!! (Unique in the world i think :D)
7 - Added an option to minimize to tray on X button pressed.
8 - Added an option to minimize to taskbar instead of always minimizing to tray.
9 - Fixed some typo in the language file.
10 - Added a check to prevent unhandled exception at starting servers with an incorrect path.
11 - Fixed some typos in the interfaces
12 - Added a combobox for quickly select configurations without opening the configuration window. :)
13 - Reactivated the time field in the character_spell_cooldown table. (Thanks to Vladimir for the swift and fast Core Fix)
14 - Fixed the SpellDB button in the character_spell_cooldown handler.
15 - Maked sure that the DB Management page is accessible only if the connection is active. (even if database content is corrupt)
16 - Some other interface fixes
17 - Fixed a bug related to the double showing of the connection error message.
18 - Maked sure that import/export procedures are allowed only on database in line. :)
19 - Added a background configuration option.
20 - Added the fields spell1,spell2,spell3,spell4 to the creature_template handler.
21 - Added a SpellDB lookup button at the npc_trainer handler.
22 - Added licence to files where was missing.
23 - Fixed the problem of the splashscreen that was remaining active in the background.
24 - Fixed a problem that was arising when you tried to update with multiple instance of MDH running.
25 - Added an option to select what kind of SQL istructions you wanna log (SELECT,UPDATE,INSERT,DELETE).
26 - Fixed the Inventory according to MaNGOS Revision 2787 (this is basically adding the support for 28-slot bags).
27 - Fixed Item inserting in Normal/Bank Bags and i hope all the problems with the inventory.
28 - Done the first part of a WHOLE code optimization and clearing. Very long and hard work. :D (actually 30% of the work is done)
29 - Added 4 new DBs for Item Class, Item Subclass, Character Class, Character Race. This way all should be localized and optimized for every update that could occur. :)
30 - Added an integrity checker with base functionality of detection NON-LINKED records into the DB. (In next revision i'll add the Edit config... and Show Records functionality)
31 - Added the integrity system configuration editor.
32 - Added the fully completed Creature_loot_template handler.
33 - Added the group loot ID into the creature_loot_template handler.
34 - Added the fully completed skinning_loot_template handler.
35 - Added the MovementType, dynamicflags, flags field to the creature_template handler.
36 - Added the faction field in the creature_template handler
37 - Added the FactionTemplate DB in the program.
38 - Fixed a bug in the Database Information window.
This is the a polished Installshield Version with enough functionality and stability to be considered the milestone 0.3.0 of the project. (Finally we are here. :))
Thanks to ALL the guy who helped along the way with your beta-testing, suggestion and everything you have maked. I really appreciated your help.
I hope to continue to make a good work for the MaNGOS community.
Thanks,
feal87
Posted Revision 223 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Fixed a bug related to the ConnectOnStartup option.
2 - Fixed a bug related to the Button state when the program is opened.
Can anyone tell me why I can't get My databasde handler to work?...It says 0 everyhting and when I go to mangos DB management and go to click accounts etc its all in grey and I can't click them. I also get an error "mangos.item_loot_template' doesn't exist. It gives me the message "Your MDH version is OUTDATED" But I just downloaded revision 222 above me there.
-Thanks.
1) YOU MUST UPDATE MANGOS and not Mangos Database Handler.
2) To update Mangos Database Handler press the Update button on the interface. :)
Are you encountering slowdown on the creature_loot_template?
Are you trying to kill the developer?
Execute these SQLs into your Database to resolve the issue. ;)
It is a problem that MaNGOS have and i hope the developers will resolve soon. ;)
Quote:
ALTER TABLE creature_loot_template ADD INDEX (entry,item);
ALTER TABLE item_loot_template ADD INDEX (entry,item);
ALTER TABLE skinning_loot_template ADD INDEX (entry,item);
ALTER TABLE fishing_loot_template ADD INDEX (entry,item);
ALTER TABLE pickpocketing_loot_template ADD INDEX (entry,item);
I have the latest Mangos, How do I do that Alter Table stuff?
Posted Revision 224 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Fixed the item_template handler delete function that was damaged after the mail update.
2 - Fixed some graphical glitch into the interface.
3 - Fixed the item_template subclass after the new DB updates.
How do I update Mangos? If I click on any of the things in the Mangos>Updates folder I get a windows error.
Posted Revision 225 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Added a Bug-Report page to let the people report bugs easily and fastly.
Posted Revision 226 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Fixed some bugs about interface text. (Thanks to Dav2000 and Milan Obadov for the report)
2 - Fixed a bug with the item editing (related to the subclass field). (Thanks to Matthew Burke for the report)
Posted Revision 227 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Fixed the aboutbox menu that wasn't working (Thanks to Melvinchi for the report)
2 - Fixed a lot of exception inside the creature_template handle related to lots of fields.
3 - Added support for the new changes about npc_trainer appeared into MaNGOS Revision 2875 (NO OTHER REVISION WILL BE SUPPORTED)
Posted Revision 228 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Fixed a bug related to the configuration profile manager. Now even if you delete from INSIDE the program the active profile file the program should be able to start correctly. (Thanks to Drunken Panda for the report)
Posted Revision 229 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Added a forgotten line from the last update.
Posted Revision 230 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Fixed the Creature Type field (there was SOME mistake) (Thanks to *dOoM* for the report)
2 - Fixed the configuration profile deletion.
Posted Revision 230 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Fixed the Creature Type field (there was SOME mistake) (Thanks to *dOoM* for the report)
2 - Fixed the configuration profile deletion.
Posted Revision 231 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Updated MDH to be working with MaNGOS Revision 2885. (PREVIOUS REVISION WILL NOT WORK)
Posted Revision 232 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Added Fetch List... button for selecting the DB into the MySQL Server.
2 - Fixed a bug with the Data Information panel.
3 - Added a splash everytime the program try to connect to the DB for telling the user to wait.
4 - Removed a bug that caused to reload the DB cache 2 times when changing configuration options.
5 - Other minor fixes in the splashscreen visualization.
6 - Some other interface typos fixed.
Posted Revision 233 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Moved the logging system (for both SQL and Restarter) to work on a Logs subdirectory instead on the root directory.
2 - Fixed some bugs with the "please wait" window on connecting.
3 - Fixed some bugs into the language file.
4 - Added support for revision 2912+. NO OTHER REVISION WILL BE SUPPORTED. (Included areatrigger and character updates)
5 - Added a Wizard System to semplify the life of many. :D
6 - Fixed a little bug with the wait window.
7 - Fixed a SERIOUS and old bug with the profile system.
Bugs in the queue to be fixed really soon :
ServerPath bug reported by DrunkenPanda
character_ticket backup problems reported by Azlidar
Thanks for your time and good update. ;)
I am very impressed with this Software, top marks, thanks for the work you putting into it :).
/Haz
just a tiny question
whats with this : 2) MaNGOS Database MUST NOT HAVE STARTING NUMBER CHARACTER (2177 = WRONG | Hello = GOOD) hwere do i check that
(In the configuration page there is a FETCH DB button, just open the combobox near that and see what appear.)
Posted Revision 234 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Divided updates between stable and experimental. :)
PLEASE BE NOTE THAT THERE IS NO SUPPORT FOR THE EXPERIMENTAL REVISIONS. (You can obviously still report bugs you founded. ;))
Bugs in the queue to be fixed really soon :
ServerPath bug reported by DrunkenPanda
character_ticket backup problems reported by Azlidar
Thanks for your time and good update. ;)
There seems to be a major issue of importing older accounts into the new database.
I exported up my accounts when I had SDB 0.5.4 Full Changeset 42-2881.
I deleted the old mangos database and imported SDB 053 Rev48 into the mangos database.
When I used Mangos Database Handler 0.4 234 to import the accounts I get this error message:
#22001Data too long for column 'name' at row 1
Details
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: #22001Data too long for column 'name' 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.4.0.0
Win32 Version: 0.4.0.0
CodeBase: file:///F:/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:///F:/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.
That is not a bug, but it's your own mistake.
I said countless time that STARTING and ARRIVING structures must be identical otherwise the import will OBVIOUSLY not work.
Update your DB to latest revision before exporting and then reimport back into the new DB.
This is a problem.Quote:
Originally Posted by feal87
The newest version of Mangos Database Handler does connect with the older SDB 0.5.4 Full Changeset 42-2881. I can't export the old accounts out.
well, i can't help with this. As i said I only support the latest revision of MaNGOS. Older version are not supported. (Anyway you can simply downgrade your MDH and export)
I mention that using the old version of MDH and exporting is not an issue.Quote:
Originally Posted by feal87
It's importing the accounts back to the new version of the database is causing the issue.
you are not understanding what i'm trying to say.
If you export a table with 10 fields you CANNOT NEVER import back the content of this table into a table with 9 fields.
Time after time developers of MaNGOS Make changes to the structure. You need to make sure that the exported stucture is the same as the one you are trying to import into.
Posted Revision 235 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Fixed a problem arising when a server crashed with an incorrect pathname specified. (Thanks to DrunkenPanda for the report)
2 - Fixed a little bug into the updater.
Bugs in the queue to be fixed really soon :
character_ticket backup problems reported by Azlidar
password masking problems reported by dav2000.
Thanks for your time and good update. ;)
Posted Revision 236 on the UPDATER SYSTEM (there is no release, you must update) :
1 - Added password masking all over the program.
Bugs in the queue to be fixed really soon :
character_ticket backup problems reported by Azlidar
Thanks for your time and good update. ;)
hey feal, im kinda having sum technical difficulties
anyways evertime i try to connect i keep getting a error saying
Warning Your configuration file is wrong, modify your options...
You have specified an invalad column ordinal.
is this from not updating to latest revision (which i need help with too im on like 2903) or did i screw something up in mysql , or my mangos DB
<< figured it out have to get to 2912
thx much < found it in prevoius thread of sum sort
feal87 thx for great work
if i open the db handler and go to say like creatures and set the size
from a creature higher
i dont get the size to work in the game mob stays the same size
can u help?
getting the same errorQuote:
Originally Posted by nirrozero
made sure the settings were correct and even checked the .ini file manually
Where can i download MDH? website http://www.bluesailor.net/MDH.php is down...
the latest revison also seems bugged...
Mangos DataBase Handler.exe is not a valid win32 application
:rocket:
same problem here, I emailed feal, hope he gets back to me soon.
MDH is getting back.
Only some minutes of time please. :)
this works
http://www.bluesailor.net/privato/Rev222.msi
Posted Revision 237 on the updater system
1 - Began the modularization of the project. (No visible changes, but lots of changes underground)
(Yes let's go back to updating!!! ;))
Thx! :D
Posted Revision 238 on the updater system
1 - Fixed the adding new AreaTrigger after the Database update of 2912.
2 - Hopefully Fixed the Import/Export problem. (Please test)
Posted Revision 239 on the updater system
1 - Fixed Clear Log that was broken since last update.
2 - Added Language Localization for Wizard that was missing.
3 - Added equipmodelx,equipinfox,equipslotx to the creature_template handler. (still incomplete. It miss the I button and some other thing)
4 - The program will now add all the index he need on the current DB he is using to ensure maximum speed. (this way the program will be a lot faster than before)
PLEASE BE AWARE THAT THE FIRST START AFTER THIS UPDATE MAY TAKE UP TO 3 MINUTES.
Now i need some feedback to tell me if the speed is increased while using my software or not. :D (excluding the first start that require that long elaboration)
Hello all, When I download / install Mangos Database Handler I get this error when I try to run it.
http://img.photobucket.com/albums/v3...l/errorrrr.jpg
Not sure if it has to do with the repack I'm using.
Loving the new revision. Much faster when loading and making DB changes.
;) two thumbs up from me
And more optimization are coming, stay tuned. (I'm in a period of exams, but as soon as i'll get out of them lots of updates will come ^^)Quote:
Originally Posted by tmgk
Omegamagi, you need the .NET Framework 2.0 in order to run MDH.
Im getting that exact same error on the pc that hosts the server.Quote:
Originally Posted by Omegamagi
But the program runs fine on this pc:/
Any ideas?
Ok, this was an easy problem to fix.
You need to install .Netframework
I never had .net on that computer, but did have it on this. That and the error code in goolge tells you that it's not having .net frame installed thats the problem:P
I keep getting this error.
http://img352.imageshack.us/img352/7360/erroror8.jpg
I can't find this value in the config file anywhere.
that error can be caused by maximum 2 reason :
1) Database OLD
2) Database with wrong data
Contact me on MSN and we'll try to find how to resolve the issue but first try to be UP-TO-DATE (we are currently at MaNGOS Revision 3005).
Posted Revision 240 on the updater system
1 - Added the Czech Language localized by Benny (Thanks).
2 - Updated support to Revision 3010 of MaNGOS. NO PREVIOUS VERSION WILL WORK CORRECTLY.
PLEASE BE AWARE THAT VERSION OLDER THAN THE 3010 WILL NOT WORK CORRECTLY.
Thanks to all and good update (when i finish the exams i have some new feature for all of you. :D)
My mdh was running great untill I updated it to this new one:(
"your configuration is wrong. modify your option..
you have specified an invalid column ordinal"
im running the latest core/sdb and dbc files.
yea same here, i also got this ordinal error thingy.. Anyone else?
Yeah I got that same invalid column error, any idea how to fix it?
Also when I try to start Mangosd.exe it just keeps loading and crashing every second. If you know how to fix this issue PLEASE EMAIL ME (generalreon701@yahoo.com) I would appreciate it very much. Thank You
I am getting this error
"Your configuration file is wrong, modify your options...
#42502table 'mangos.game_addons' dosn't exist
where do i get that file?
EDIT#
My bad, i fixed it... lol
im getting the same error everyone else is getting now too :/
Right guys/ladies, problem sorted.
goto Mangos files section, goto last page and download 3011+Scriptdev2 Rev 13+MCH1.5c
Just import the 3010_item_template.sql first, then import the 3005.sql.
After that, mdh loads up fine.
A quick question for feal87.
Is there a way to export a char from one account, and import the char into a new account?
I have a player on my server that wants a new account, but wants the char copied over to it.
oops.. double post... my bad.. check the next one plz...
***BUMP***
-------------------------------------------
DOWNLOAD: MDH v222 (You MUST Auto-Update)
WEBSITE LINK: Bluesailor
AUTO-UPDATE: use menu in application -> OPTIONS > UPDATER
Quote:
So you've finally come to this little part of the internet right?
Let's talk a little...WHAT IS Mangos Database Handler?
Mangos Database Handler (MDH for short) is a open source development effort for making a management software, the project is still in heavy developing, that will allow MaNGOS Users to manage the related database. It's primary focus when i'm developing is EASY TO USE, allowing this way even the most newbie MaNGOS user to mess with the information contained in the database in a fast and steady way. (actually i'm the only one developer )
It's developed in several different modules that are structured to give the chance to modify separated parts of the database (items,characters, quests, etc..).
These modules are interconnected each other throu a series of functions giving more feature to the end-user.
Mangos Database Handler have Import/Export feature for Accounts/Chars that allow MaNGOS server administrator to easily backup every needed tables inside portable .EMA files compressed and ready to be imported on another server if needed. (very useful after database upgrade)
The software is made completely with Microsoft Visual C# Express 2005 and it's fully OpenSource under the BSD licence (you must accept the licence to use the software or use the sourcecode).
REMINDER FOR THE BEST USAGE :
1) You need latest MaNGOS Revision
2) MaNGOS Database MUST NOT HAVE STARTING NUMBER CHARACTER (2177 = WRONG | Hello = GOOD)
2) You need Microsoft .NET Framework 2.0
3) You need MySQL 5.*
4) You need MySQL to be configured to allow remote connection.feal87, MDH Main Developer
(These screenshots are REALLY OUTDATED!!!)Here's some screenshot of the program...http://www.bluesailor.net/images/MDH001.jpghttp://www.bluesailor.net/images/MDH002.jpghttp://www.bluesailor.net/images/MDH003.jpg
http://www.bluesailor.net/images/MDH004.jpghttp://www.bluesailor.net/images/MDH005.jpghttp://www.bluesailor.net/images/MDH006.jpg
Auto update is not a good idea.
For one thing the new mdh update wont work with anything less than 310*
And for the people that still run a server thats not using that rev, will have issues.
I only manualy download an update when needed, and I look to see whats been updated on the update list before I do so.
Posted Revision 241 (EXPERIMENTAL) on the updater system
1 - Another part of the big bad modularization!!!
PLEASE BE AWARE THAT VERSION OLDER THAN THE 3010 WILL NOT WORK CORRECTLY.
Thanks to all and good update (when i finish the exams i have some new feature for all of you. :D)
The BUG-REPORT SYSTEM is BACK ONLINE
PLEASE REMOVE THIS THING THAT IS SCREWING UP THE LAYOUT. :|
Installshield Revision 243 OUT
Download from the official website
Important changes from the last Installshield Release :
1 - This revision support ONLY MaNGOS Revision 3010+
2 - Fixed infinite numbers of bugs
3 - Added a Bug-Report page to let the people report bugs easily and fastly. ;)
4 - Added a splash everytime the program try to connect to the DB for telling the user to wait.
5 - Added Fetch List... button for selecting the DB into the MySQL Server.
6 - Moved the logging system (for both SQL and Restarter) to work on a Logs subdirectory instead on the root directory.
7 - Added a Wizard System to semplify the life of many. :D
8 - Divided updates between stable and experimental. :)
9 - Added password masking all over the program.
10 - Began the modularization of the project. (No visible changes, but lots of changes underground)
11 - Added Language Localization for Wizard that was missing.
12 - Added equipmodelx,equipinfox,equipslotx to the creature_template handler. (still incomplete. It miss the I button and some other thing)
13 - The program will now add all the index he need on the current DB he is using to ensure maximum speed. (this way the program will be a lot faster than before)
14 - Added the Czech Language localized by Benny (Thanks).
Next things in the way to be maked :
1 - Plugin System to allow people to create new plugins to add to MDH by themselves
2 - Quest_template Handler
3 - Optimization
4 - Finish the modularization
This is the a polished Installshield Version with enough functionality and stability to be considered the milestone even if not official of the project.
Thanks to ALL the guy who helped along the way with your beta-testing, suggestion and everything you have maked. I really appreciated your help.
I hope to continue to make a good work for the MaNGOS community.
Thanks,
feal87
Will there be any updates on character/account transfer from 1.12 to 2.01. The database handler works great on both of them (I have a stable 1.12 and stable 2.01) but it wont import right. I manually imported the sql files so that the colums would match up, everything shows up the way it should in the dbh, but character list still will not show (getting a mangos error).
Thx for the awesome program though, its very useful!
2.0.1 uses a different updatefield system.
Actually everything will work except the character page.
The character page will be updated accordingly when the official MaNGOS SVN will support the 2.0.1. :)
How do i add mobs with this? is there a file i can read?
With MaNGOS Database Handler you can create Template of mobs, but the creature handler to spawn these mobs inside the world isn't created yet. (you can thought just do .addspw entryofthemob to spawn the newly created mob inside the world)
I am running mangos SDB_0.5.4_Full_Changeset_55-2946 and I am getting a strange error when I go to view the characters from the accounts menu.
Has anyone seen the attached error or know why I am getting this?
Thanks in advance
are you using MaNGOS for WoW 2.0.x or TBC cause MDH does NOT support these versions. (the characters use a different updatefield system)
Posted Revision 246 (EXPERIMENTAL) on the updater system
1 - Fixed another problem with the exportation of items and creatures.
PLEASE BE AWARE THAT VERSION OLDER THAN THE 3010 WILL NOT WORK CORRECTLY.
Little guide to the new Module System language (It's highly incomplete and basically you can't do nothing by now, but its the beginning :D)
Here's an Example module.
NAME "NameOfTheModule"Code:NAME "First Module"
VER 244
MENU "Test Module"
MAIN
NEWFORM test
SETMDIFORM test
SETCAPTION test "This is a Try"
SHOW test
ENDMAIN
This function simply state the name of the module. The name must be included within ", and must not contain " as part of the text.
VER 244
This function state what version of the scripting language you have used. (this way i can block starting of old module with a new scripting language that may screw up things)
MENU "Test Module"
This function state what text will appear in the Modules menu for starting this module.
MAIN
This function state the beginning of the main code block
ENDMAIN
This function state the end of the main code block
NEWFORM test
This function create a new form named test in the script environment
SETMDIFORM test
This function set the form named test as a MDI form. (this include the adding of the workbar in the top of MDH and all the relating code)
SETCAPTION test "This is a Try"
This function set the caption of any control named test (it could be a form but also can be any other control). (The caption must contained with " and must not contain " within the text)
SHOW test
This function show a control (it could be any kind of control) named test.
Please send an e-mail to my address (feal87@yahoo.it) with the help request.Quote:
Originally Posted by mooka91
Insert inside these informations :
1) Version of Windows
2) Language of Windows
3) Version of MaNGOS
4) SDB Changeset
5) Other information you think are useful.
Ey.
Updated to: Silver SDB 88 Full By Haken
Mangos 3092+ScriptDev2 Rev 16 By Haken
When launching MDH, I get following error with this sdb/core:
"Your configuration file is wrong, modify your options...
value of '100003' is not valid for 'value'. 'value' should be between 'minimum' and 'maximum'.
Parameter name: value "
I've tried updating mdh to latest "even tried experimental revs" and it still gives me this error.
I can run my server easy enough, and it all works fine just running it with core and mysql.
But I can't use MDH with my sdb, as this error is preventing me from doing so.
feal87: Any ideas?
lol i have the same problemQuote:
Originally Posted by EvilRyu
i think ferreri allesio needs to fix this problem over here , cauze this anoing
Yup, mdh needs configured for the new core/sdb's.
I can still run my server easily, but mdh is a handy frontend tool;)
I foresee alot of people postin about this error:P
it is a handy tool you can sya that again , hehe i tried to back up my accoutn but and put that in the new sdb from haken , hehhe now my charachter is naked lol
i'm gonna fix that problem
lol
Btw, don't use mdh for backing up, it causes insane problems.Quote:
Originally Posted by elldiablo
I use sqlyog and manualy backup accounts, safer;)
As for your error, just use the mdh cleaning tool:P
It should be under db managment, check only first, and you will see a list of crap, just clean it up, then you can either add what you had or buy again:)
oki problem fixt how do you back up with sqlyog
i diddint now that you cna back up with sqlyog the same as MDH lol
First off:
1: right click on realmd and backup as sql "call it realmbak or something"
2: right click on mangos db and select backup, now..
the right window is all the tables thats being exported, so move them all to the left as you don't backup all tables;)
Tables to add to export list:
Auctionhouse
all Character tables
Corpse
All guild tables
Item_instance
All raid tables
Export and save as realmbak or whatever you want:P
Now, when new sdb/core comes along.
Del realmd/mangos db, and make new ones, import your new sdb, and any sql updates from rev release. "3005.sql Might have to edit out item_instance lines as causes issues when importing"
Once ur ready, just right click on realmd, and import ur backup and do the same with mangos db.
This way works 100% no matter what sdb/core you use.
However, when you use mdh to backup accounts, and try to import it back intoa new sdb/core, you can get errors "happened to me tons of times" and thus you get naked chars/items not in peoples inventory ect..
Hope this helps you out man:)
thanks dude this is good enough
If they can make this progress in a tool like MDH that woid be a Very nice tool
Im gonna try that now hehe
No problem man, like I said after the 6th time mdh messed up my accounts, i've done it manualy:)Quote:
Originally Posted by elldiablo
But not taking any credit away from mdh what so ever, mdh is a top notch front end tool for mangos, and once it's been updated for the newer stuff, i'll go back to using it to lunch and maintain my server "aka creture/item listings, player lookup ect.." I just don't use mdh to backup accounts or to import them:P
lol this is nice hehe maybe that can be fixt if you make a BAT file that duz that trick hehe
Hmm, id imagine that would be very diffucult todo. Well for me to make one that did it anyway lolQuote:
Originally Posted by elldiablo
For the lenth of time it takes to manualy backup, I have my main server down for 2mins tops to back it up;)
Using a bat file would be very lazy, yet kinda cool.
But if the batch file was not made 100% correctly, you could be backing up tables that you don't need to, or worse, not backing up the ones required to restore accounts lol.
hehehe i get the point , better to do it when you see that everything is backt up like it suposed to be , then some BAt that is backing up your data , but ho nows how heheh ,
Exactly, but lets not spam this thread lol.Quote:
Originally Posted by elldiablo
Hope feal updates:)
oki i hope that they update MDH for the latest sdb , so whe can go further
plop... same problem xD, we just gotta wait :P
The wait is over. ;)
Anyway regarding your method of updating...it doesn't work if there are updates on the involved tables. ;)
Posted Revision 247 on the updater system
1 - Added new functions and capabilities to the script system (still a lot unstable so don't rely on it).
2 - Updated MaNGOS SUPPORT TO SUPPORT REVISION 3092. NO PREVIOUS REVISION ARE SUPPORTED.
PLEASE BE AWARE THAT VERSION OLDER THAN THE 3092 WILL NOT WORK CORRECTLY.
For the scripting language reference refer to this link i've created :
Script Reference
I'm now working on a linux / mono version of MDH so stay tuned. ;)
nice dudethnx for updating it :d :d whoooot whooooot
Posted Revision 248 on the updater system
1 - Maked some steps toward the Mono support (So Linux and Mac support, still WIP)
2 - Fixed an hard bug on the module systems.
PLEASE BE AWARE THAT VERSION OLDER THAN THE 3092 WILL NOT WORK CORRECTLY.
For the scripting language reference refer to this link i've created :
Script Reference