Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void HandleClientComm(object client)
- {
- TcpClient tcpClient = (TcpClient)client;
- NetworkStream clientStream = tcpClient.GetStream();
- using (BinaryReader reader = new BinaryReader(clientStream))
- {
- string username, pw, email;
- while (true)
- {
- #region stuff....
- ////////////////////////////
- // MYSQL CONNECTION INFO //
- //////////////////////////
- string connString = "Server=196.220.60.236;Port=3307;Database=gamedb;Uid=testuser;password=testpass;"; // INTERNET DATABASE
- MySqlConnection conn = new MySqlConnection(connString);
- MySqlCommand command = conn.CreateCommand();
- ////////////////////////////
- // MYSQL CONNECTION INFO //
- //////////////////////////
- //////////////////////////////////////
- // READ BYTES RECIEVED FROM CLIENT //
- ////////////////////////////////////
- try
- {
- //blocks until a client sends a message
- username = reader.ReadString();//THE ORDER MATTERS!!!
- pw = reader.ReadString();
- email = reader.ReadString();
- }
- catch
- {
- //PROBABLY a socket error has occured
- break;
- }
- ///////////////////////
- // INSERT STATEMENT //
- /////////////////////
- if (username == null || username.Length == 0)
- {
- //throw?
- }
- else if (pw == null || pw.Length == 0)
- {
- //throw?
- }
- else if (email == null || email.Length == 0)
- {
- //throw?
- }
- else
- {
- command.CommandText = "Insert into players (id,username,email,password) values('','" + username + "','" + email + "','" + pw + "')";
- try
- {
- conn.Open();
- command.ExecuteNonQuery();
- }
- catch (Exception ex)
- {
- MessageBox.Show(ex.Message);
- }
- MessageBox.Show("DONE!");
- }
- ///////////////////////
- // INSERT STATEMENT //
- /////////////////////
- /////////////////////////////
- // CLOSE MYSQL CONNECTION //
- ///////////////////////////
- conn.Close();
- /////////////////////////////
- // CLOSE MYSQL CONNECTION //
- ///////////////////////////
- #endregion
- }
- }
- }
Add Comment
Please, Sign In to add comment