• This is a read only backup of the old Emudevs forum. If you want to have anything removed, please message me on Discord: KittyKaev

[Trinity] Manti Manager

Heitx

Emulation Addict
[TrinityCore DB Manager] Manti Manager

titleManti.png


~~ Information ~~

Manti (Manager) is a database editor, allowing the user to create, update or delete from the datebase easily.
The application is easy to get started with and contains different tools, such as a Control Panel and Offline mode.

The program is programmed in C# and the source code can be found at the bottom of the thread.

~~ Offline Mode ~~

I mentioned in the beginning that the program had an offline feature. Offline mode is when the information to the database is not needed,
but you cannot search and update directly from the application - you have to generate sql's within the program and upload them later
when there you have a connection.

The project is being revamped, so you have to compile the program yourself for now.

Requirement(s): .NET FRAMEWORK 4.6 or above. Only been tested on TrinityCore/Eluna 3.3.5a.

Disclaimer: When using this program it is at own risk. Any corruption to the database is not my responsibility.

mySQL.png

mainscreen.png

selection.png

controlpanel.png


~~ Features (v0.3-alpha) ~~

++ Save MySQL Information ++
++ Control Panel (World & Auth) ++
++ Search /w filters ++
++ Template Viewer ++
++ Script Generator ++
++ Script Section (to review/edit the SQL) ++
++ Field Buttons (helps the user to select) ++
++ More to come! ++

Every search tab uses 'exact' search, which means the word/sentence has to be exactly as the database.
However, there is a method to bypass this and that is the character '%'.
When a search begins or ends with '%', it searches for something that comes before or after.
An example: "%Glaive of Azzi%" -> Warglaive of Azzinoth appears.

~~ Upcoming Features ~~

+ Suggestions! +


Source code & download link!

 
Last edited:

Neccta

Exalted Member
I'll say a few words, please understand that this is constructive criticism.

First off you should get a better understanding of Object-Oriented Programming. You have one class (MainForm) which does about everything, with 3900 lines of code; this is a disaster. This makes maintaining your code incredibly hard, and anyone looking to contribute will have a hard time doing so.
Start by learning some practices and patterns, such as the SOLID principles and since you're using WinForms I recommend using the MVC pattern.

As a side note I see your doing object-mapping manually. While there's nothing wrong with this it's a huge pain and I'm sure you don't want to be doing it. Look into using AutoMapper or Dapper from the Nuget Library.
 

Heitx

Emulation Addict
I'll say a few words, please understand that this is constructive criticism.

First off you should get a better understanding of Object-Oriented Programming. You have one class (MainForm) which does about everything, with 3900 lines of code; this is a disaster. This makes maintaining your code incredibly hard, and anyone looking to contribute will have a hard time doing so.
Start by learning some practices and patterns, such as the SOLID principles and since you're using WinForms I recommend using the MVC pattern.

As a side note I see your doing object-mapping manually. While there's nothing wrong with this it's a huge pain and I'm sure you don't want to be doing it. Look into using AutoMapper or Dapper from the Nuget Library.

Classes?
 

Heitx

Emulation Addict
I'm currently trying to clean the code (seperate it into classes - no idea how to use controllers) and afterwards I'll develop on it again.

EDIT (13/02/2017): Nothing is happening on the github, because I'm still revamping the code. It may take a while, but it will be finished soon.
EDIT (16/02/2017): I'm done with Account and Character, semi-done with Creature. Currently working on quests. A few changes have been made to the searching.
EDIT (18/02/2017): Most of the tabs are functional (only need item), however, sql generating is not.
EDIT (19/02/2017): All the tabs work with sql generating, but the small tabs (vendors, etc) isn't working yet.
 
Last edited:
Top