OpenAdmin Beta - VB.NET MySQL OpenAura Server Administration Tool - Garry's Mod

Long title is long. Anyways, I made this program after a user on the C16 forums said he was working on one and I thought I should make one myself because I am new to MySQL and it would provide me with experience. In the picture below you can see most of the windows open. The program is still buggy (as seen in the physical description of my character) because it is still being worked on. Some of the RegEx patterns are not working correctly and so you may see strange data popping up here and there. [url]http://i.imgur.com/biPm0.jpg[/url] Download Link - [url]https://dl.dropbox.com/u/32687773/OpenAdmin.exe[/url] MySQL DLL (REQUIRED TO BE IN SAME DIRECTORY AS PROGRAM) - [url]https://dl.dropbox.com/u/32687773/MySql.Data.dll[/url] [url=http://pastebin.com/hW03W53m]Source[/url] (Pretty big, unorganized, and probably not the most efficient code) Most of the labels will allow you to edit the value they have (such as money, faction, name, rank, etc) but some of them only copy the value (because it doesn't really make sense to want to alter someone's SteamID). I will continue to work on this by improving the already existing code and also adding in visual displays for each model.

Doesn't even open.

[QUOTE=Halokiller38;38919020]Doesn't even open.[/QUOTE] Do you have the latest .NET framework? Does it give any errors? Did you try running the program as an admin? If none of those work, try creating an .ini file in the same directory as the program and paste this (except replace with your info). Leave the password part EMPTY as the password is encrypted in the .ini file. Just type the password manually in the program. [code][openAdmin] host=localhost db=hl2rp port=3306 user=root pass=[/code] Please post back saying what fixed it if you have resolved the problem.

Nothing. Tried it all.

[QUOTE=Halokiller38;38919254]Nothing. Tried it all.[/QUOTE] Do you have Team Viewer? Add me on Steam so I can see what's up. [url]http://steamcommunity.com/id/desolateduck[/url] EDIT: Fixed it for him. Needs the .dll file in the same folder. Added to OP.

That mysql.data.dll Worked.

cool, unique release

A suggestion. Add a system of being able to upload sql files. Would make this 10 times better.

Cool release. I have no use to it at the moment but very unique and useful.

[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 (0x80004005): Unknown column 'players._UserGroup' in 'field list' at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() at OpenAdmin.Form2.DeumosButton1_Click(Object sender, EventArgs e) in C:\Users\Sanny\Documents\aVB\OpenAdmin\Form2.vb:line 57 at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.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: 4.0.0.0 Win32 Version: 4.0.30319.17929 built by: FX45RTMREL CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll ---------------------------------------- OpenAdmin Assembly Version: 1.0.0.0 Win32 Version: 1.0.0.0 CodeBase: file:///C:/Users/Halokiller38/Desktop/Open%20Admin/OpenAdmin.exe ---------------------------------------- Microsoft.VisualBasic Assembly Version: 10.0.0.0 Win32 Version: 11.0.50709.17929 built by: FX45RTMREL CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll ---------------------------------------- System Assembly Version: 4.0.0.0 Win32 Version: 4.0.30319.17929 built by: FX45RTMREL CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Core Assembly Version: 4.0.0.0 Win32 Version: 4.0.30319.17929 built by: FX45RTMREL CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll ---------------------------------------- System.Windows.Forms Assembly Version: 4.0.0.0 Win32 Version: 4.0.30319.17929 built by: FX45RTMREL CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System.Drawing Assembly Version: 4.0.0.0 Win32 Version: 4.0.30319.17929 built by: FX45RTMREL CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- System.Runtime.Remoting Assembly Version: 4.0.0.0 Win32 Version: 4.0.30319.17929 built by: FX45RTMREL CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Remoting/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll ---------------------------------------- MySql.Data Assembly Version: 5.1.7.0 Win32 Version: 5.1.7.0 CodeBase: file:///C:/Users/Halokiller38/Desktop/Open%20Admin/MySql.Data.DLL ---------------------------------------- System.Data Assembly Version: 4.0.0.0 Win32 Version: 4.0.30319.17929 built by: FX45RTMREL CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll ---------------------------------------- System.Transactions Assembly Version: 4.0.0.0 Win32 Version: 4.0.30319.17929 built by: FX45RTMREL CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll ---------------------------------------- System.Configuration Assembly Version: 4.0.0.0 Win32 Version: 4.0.30319.17929 built by: FX45RTMREL CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- System.Xml Assembly Version: 4.0.0.0 Win32 Version: 4.0.30319.17929 built by: FX45RTMREL CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- System.EnterpriseServices Assembly Version: 4.0.0.0 Win32 Version: 4.0.30319.17929 built by: FX45RTMREL CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.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.[/CODE] [url]http://puu.sh/1DLd9[/url]

When does that happen? And what is your player's rank column called? The one with user, admin, and superadmin. Is your players table named players?

[QUOTE=sonyfuzion;38930289]When does that happen? And what is your player's rank column called? The one with user, admin, and superadmin. Is your players table named players?[/QUOTE] Yea. Whenever I look at the players.

Ya, seems I can't do any edits either.

[QUOTE=Halokiller38;38931816]Ya, seems I can't do any edits either.[/QUOTE] Open your players table and tell me the name of all of the columns you see at the top.

Neat, if I could get past the niggly feeling it has a virus :(. But then I noticed you included the source code, I might actually try this.

This is for OpenAura? I thought that died.

[QUOTE=sonyfuzion;38935769]Open your players table and tell me the name of all of the columns you see at the top.[/QUOTE] [IMG]http://puu.sh/1EgZN[/IMG]

It's a great idea and would provide an easier way to manage a MySQL database but I myself would prefer phpMyAdmin with inline editing over this. Still a great idea though :)

[QUOTE=Halokiller38;38962163][IMG]http://puu.sh/1EgZN[/IMG][/QUOTE] I meant in phpMyAdmin ;o [QUOTE=Calmon;38957436]This is for OpenAura? I thought that died.[/QUOTE] It pretty much is now. I am going to update it to make it work with CW, though.