Server.dbs Tools for MySQL

[Reedy Boy]

Hey,

Cyrus has the http://forum.goteamspeak.com/showthread.php?t=25690 Server.dbs Tools for the Default server.dbs database

Some people use MySQL as an alternative, and i have made a version of this tool for MySQL

It is written in VB .NET, and includes the MySql.Data.dll interfacing module from the MySQL Site.

You will need v2 of the .NET Framework (This is a windows App) http://www.microsoft.com/downloads/d...displaylang=en


It is designed in a very similar style to that of Cyrus' Tool, with the same functions

At the moment, it is however, only in english

Features:

• Create, Delete and List all SuperAdmins in the MySQL Database
• Create, Delete and List all ServerAdmins for any SubServer in the MySQL Database
• Create, Delete and List all ServerUsers for any SubServer in the MySQL Database
• Change Passwords of SuperAdmins ServerAdmins, ServerUsers

It includes a feature to save connection details (IP Address/Hostname, Username, Password, and Database name) to a .xml file, which means that you only have to enter the details once, if you choose to save them. You can change them in the menu.


To Run:
Unzip the TS MySQL Tool.exe & MySql.Data.dll to a directory, and double click the TS MySQLTool.exe

This will open a console window, and as its first run, ask you to enter database details to connect, and will let you know if the database connection has been successfull


Any Problems, Comments, Queries or alike, post them on here, and i'll do my best to help you out/sort the program


Known Bugs:

• None

Fixed Bugs:

• Fixed an Infinite loop on password saving - Partial Wrong exit criteria listed, so would exit on some cases, but not others
• After reading XML file, program wont let you write to the file - not helpful if changing DB settings or password
• Fixed the positioning of the outputs from the database that didnt line up

Comments Welcome



Cheers


Sam
(Reedy Boy)

Current Version: V1.2

Change Log:
22/11/06 - V1 Released - Full VB .NET version of Cyrus' Server.dbs Tool converted and altered for MySQL

24/11/06 - Updated to V1.1 - Addition of password change feature, and some minor coding changes/Blank lines

30/12/06 - Updated to V1.11 - Fixed Infinite For Loop on Password Saving. Minor Coding Changes, and blank lines

31/12/06 - Updated to v1.2 - Fixed XML saving problem, text alignment, and also added some extra error handling

[Reedy Boy]

Cheers Thomas for changing title and making Sticky





Will add Password change facility like the server.dbs tools hopefully tommorow!

[Reedy Boy]

Version changed to 1.1, and uploaded to co-inside with changes made to Cyrus' tool for password changes

[Bastian]

Don't forget to add this to our Third Party Resources repository.

[Reedy Boy]

Don't forget to add this to our Third Party Resources repository.

I didnt even think of doing that! But i will do it

Which section would it go under? Application or Other? Application i presume sounds most feasible


Also, cyrus' Server.dbs Tool (http://forum.goteamspeak.com/showthread.php?t=25690), needs adding, will do that at the same time. Also, what section would this go under? Application again?


Cheers


Sam

[Bastian]

I didnt even think of doing that! But i will do it

Which section would it go under? Application or Other? Application i presume sounds most feasible

Sounds good. Go ahead.

Also, cyrus' Server.dbs Tool (http://forum.goteamspeak.com/showthread.php?t=25690), needs adding, will do that at the same time.

It's already in there: http://www.goteamspeak.com/index.php...y&id=1&item=16

[Bisa_Mithek]

I'm using a non-standard port and I'd like to be able to enter this in the connection configuration step. As it is now if I try to add the address

mysql.example.com:3000

it's giving me an error saying there is no such server or whatever, do you have any plans on giving us the option to enter custom ports for our connections?

[Reedy Boy]

Long time overdue response...

I will rewrite this in C# and i'll add that functionality. Its relatively simple to do (Or i might whack it in the VB version quickly)