Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // CLIENT EVENT
- private void onClientEventTrigger(Client player, string eventName, params object[] arguments)
- {
- if (eventName == "login")
- {
- string socialClubName = (string) arguments[0];
- string username = (string) arguments[1];
- string password = (string)arguments[2];
- API.triggerClientEvent(player, Database.PlayerDatabase.tryLogin(socialClubName, username, password));
- }
- }
- using System;
- using MySql.Data.MySqlClient;
- namespace GermanRoleplay.Database
- {
- class PlayerDatabase
- {
- public static string myConnectionString = "SERVER=localhost;" + "DATABASE=gta;" + "UID=root;" + "PASSWORD=;";
- public static MySqlConnection connection;
- public static MySqlCommand command;
- public static MySqlDataReader reader;
- public static string tryLogin(string socialClubName, string username, string password)
- {
- connection = new MySqlConnection(myConnectionString);
- command = connection.CreateCommand();
- command.CommandText = "SELECT * FROM players";
- connection.Open();
- reader = command.ExecuteReader();
- while (reader.Read())
- {
- string dbSocialClubName = reader.GetString("socialclubname");
- string dbUsername = reader.GetString("username");
- string dbPassword = reader.GetString("password");
- if ((socialClubName == dbSocialClubName) && (username == dbUsername) && (password == dbPassword))
- {
- connection.Close();
- return "LOGIN_SUCCESS";
- }
- }
- connection.Close();
- return "LOGIN_FAILED";
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement