Advertisement
Guest User

Untitled

a guest
Feb 15th, 2018
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.84 KB | None | 0 0
  1. // CLIENT EVENT
  2. private void onClientEventTrigger(Client player, string eventName, params object[] arguments)
  3. {
  4. if (eventName == "login")
  5. {
  6. string socialClubName = (string) arguments[0];
  7. string username = (string) arguments[1];
  8. string password = (string)arguments[2];
  9.  
  10. API.triggerClientEvent(player, Database.PlayerDatabase.tryLogin(socialClubName, username, password));
  11. }
  12. }
  13.  
  14.  
  15. using System;
  16. using MySql.Data.MySqlClient;
  17.  
  18. namespace GermanRoleplay.Database
  19. {
  20. class PlayerDatabase
  21. {
  22.  
  23. public static string myConnectionString = "SERVER=localhost;" + "DATABASE=gta;" + "UID=root;" + "PASSWORD=;";
  24. public static MySqlConnection connection;
  25. public static MySqlCommand command;
  26. public static MySqlDataReader reader;
  27.  
  28. public static string tryLogin(string socialClubName, string username, string password)
  29. {
  30. connection = new MySqlConnection(myConnectionString);
  31. command = connection.CreateCommand();
  32. command.CommandText = "SELECT * FROM players";
  33.  
  34. connection.Open();
  35. reader = command.ExecuteReader();
  36.  
  37. while (reader.Read())
  38. {
  39. string dbSocialClubName = reader.GetString("socialclubname");
  40. string dbUsername = reader.GetString("username");
  41. string dbPassword = reader.GetString("password");
  42.  
  43. if ((socialClubName == dbSocialClubName) && (username == dbUsername) && (password == dbPassword))
  44. {
  45. connection.Close();
  46. return "LOGIN_SUCCESS";
  47. }
  48. }
  49. connection.Close();
  50. return "LOGIN_FAILED";
  51. }
  52. }
  53. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement