Hello, I WAS working on a Multiplayer client but I soon gave up because it was really complex. So I decided that I was going to teach you guys some main things you need in a multiplayer client, and the first major thing you need that I came accoss was MYSQL, so I thought it would be nice if I gave a step by step tutorial on how to login and/or register directly through the client.

So first for logining in, make a note that you need either a hosting account (anything is accepted)  and/or a free wamp server. You also need the MySQL component.

First you want to Add a Reference and Add the MySQL Component. Then you want to go to your code and on top of everything do:

Imports MySQL.Data.MySQLClient Imports MySql.Data.MySqlClient Imports System.Data

Add a Form with:

2 Textboxes

2 Buttons

2 Labels

Name the first label "Username" and put it beside your first textbox.

Name the second label "Password" and put it beside your second textbox.

Name one Button "Login" and put it under Password.

Name one other Button "Close" and put it beside "Login".

So it would look like this:

Click on Login and add:

Dim connection As MySqlConnection connection = New MySqlConnection Try connection.ConnectionString = "server=server; username=username; password=password; database=database;" connection.Open() Catch ex As Exception MsgBox("Error: Cant Connect!") End Try Dim myadapter As New MySqlDataAdapter Dim sqlquery = "SELECT username, password FROM login Where username='" & TextBox1.Text & "' and password='" & TextBox2.Text & "'" Dim mycommand As New MySqlCommand mycommand.Connection = connection mycommand.CommandText = sqlquery myadapter.SelectCommand = mycommand Dim mydata As MySqlDataReader mydata = mycommand.ExecuteReader If mydata.HasRows = 0 Then MsgBox("Invalid Login", MsgBoxStyle.Critical, "Error") Else Form3.Show() Me.Hide() End If End If End Sub

And if you want to add banned checker and see if this person is banned you need to create a table called banned and add this code on top of that code:

Dim bannedconnection As New MySqlConnection bannedconnection.ConnectionString = "server=server; username=username; password=password; database=database;" Try bannedconnection.Open() Catch ex As Exception MsgBox("Error: Cant Connect!") End Try Dim bannedadapter As New MySqlDataAdapter Dim bannedcommand = "SELECT username FROM banned Where username='" & TextBox1.Text & "'" Dim bannedsystem As New MySqlCommand bannedsystem.Connection = bannedconnection bannedsystem.CommandText = bannedcommand bannedadapter.SelectCommand = bannedsystem Dim banneddata As MySqlDataReader banneddata = bannedsystem.ExecuteReader If banneddata.HasRows = True Then MsgBox("Banned Account!", MsgBoxStyle.Critical, "Banned Account") End If If banneddata.HasRows = 0 Then Dim connection As MySqlConnection connection = New MySqlConnection Try connection.ConnectionString = "server=localhost; username=root; password=205714; database=gaming_rage;" connection.Open() Catch ex As Exception MsgBox("Error: Cant Connect!") End Try Dim myadapter As New MySqlDataAdapter Dim sqlquery = "SELECT username, password FROM login Where username='" & TextBox1.Text & "' and password='" & TextBox2.Text & "'" Dim mycommand As New MySqlCommand mycommand.Connection = connection mycommand.CommandText = sqlquery myadapter.SelectCommand = mycommand Dim mydata As MySqlDataReader mydata = mycommand.ExecuteReader If mydata.HasRows = 0 Then MsgBox("Invalid Login", MsgBoxStyle.Critical, "Error") Else Form3.Show() Me.Hide() End If End If End Sub

If you want to add a Register Form make it look the way you want it to look, I suggest a smexy look like this:

And add this code:

If (TextBox3.Text = TextBox4.Text) Then Dim conn As New MySqlConnection conn.ConnectionString = "server=localhost; username=root; password=205714; database=gaming_rage;" Try conn.Open() Catch ex As Exception MsgBox("Error: Couldn't Connect!") End Try Dim myadapter As New MySqlDataAdapter Dim sqlquery = "SELECT * FROM login WHERE username = '" + TextBox1.Text + "'" Dim mycommand As New MySqlCommand mycommand.Connection = conn mycommand.CommandText = sqlquery myadapter.SelectCommand = mycommand Dim mydata As MySqlDataReader mydata = mycommand.ExecuteReader If mydata.HasRows = 0 Then Dim connection As New MySqlConnection Dim mailmessage As New MailMessage connection.ConnectionString = "server=localhost; username=root; password=205714; database=gaming_rage;" connection.Open() Dim registerfinal As New MySqlDataAdapter Dim query = "INSERT INTO login (username, password, email) VALUES ('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "')" Dim newcommand2 As New MySqlCommand newcommand2.Connection = connection newcommand2.CommandText = query registerfinal.SelectCommand = mycommand Dim newdata As MySqlDataReader newdata = newcommand2.ExecuteReader mailmessage.Subject = "Gaming Rage - Beta" MailMessage.From = New MailAddress("gaming.rage5@gmail.com") mailmessage.To.Add(TextBox3.Text) mailmessage.Body = "--------------------------" & vbNewLine & vbNewLine + "Username: " + TextBox1.Text & vbNewLine + "Password: " + TextBox2.Text & vbNewLine & vbNewLine + "--------------------------" Dim smtp As New SmtpClient("smtp.gmail.com") smtp.Port = 587 smtp.EnableSsl = True smtp.Credentials = New System.Net.NetworkCredential("gaming.rage5@gmail.com", "205714ab") smtp.Send(MailMessage) MsgBox("Registered! You Have Received a Email With Your Information!", MsgBoxStyle.OkOnly, "Success") Form1.Show() Me.Hide() Else MsgBox("Error: Cant Register!") End If End If End Sub

What this does is create the user in the table and email the user his information

All the best

- iPromise

Pardon me for saying, but first off, wouldn't it be easier to have a client/server configuration?

It seems to me you have the client doing all the work, Auth, Interacting with the DB, Ban checking..

IMHO, you should setup a client/server system, it would be more secure, as each client does not store a string of the mysql database password.

Just my 2 cents.

You don't want to store the database information in the client.  Jordan is right.

@Jordan I wanted the client to be like GameRanger. Also I didn't want to make a Website for registration, etc. I wanted the Client to do the work.

@Specific Well, I will pack it with themida and secure it so dont worry.

Note: I gave up on the client so who cares.

Great tutorial on how to use MySQL in Visual Basic by the way.

The point I was trying to make is that the client should not store information that needs to be secure.  Your MySQL username, password, database, and tables in the client is easily obtainable with simple reverse engineering.  This is why the best method is to have a client application and a server application.  The client would connect to the server sending the user's login / registration information.  The server will then connect to the database, do the work, and send a result back to the client.

Thanks

@Specific I see, thanks.

Old thread revival!!

You also might want to include how one installs the MySQL component. lol