Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using Discord;
- using MySql.Data.MySqlClient;
- using System;
- using System.Collections.Generic;
- using System.Linq;
- namespace Rambot
- {
- class Database
- {
- private string Ramtable { get; set; }
- private const string server = "localhost";
- private const string database = "Rambot";
- private const string username = "root";
- private const string password = "fillerpassword";
- private MySqlConnection dbConnection;
- public Database(string table)
- {
- this.Ramtable = Ramtable;
- MySqlConnectionStringBuilder stringBuilder = new MySqlConnectionStringBuilder();
- stringBuilder.Server = server;
- stringBuilder.UserID = username;
- stringBuilder.Password = password;
- stringBuilder.Database = database;
- stringBuilder.SslMode = MySqlSslMode.None;
- var connectionString = stringBuilder.ToString();
- dbConnection = new MySqlConnection(connectionString);
- dbConnection.Open();
- }
- public MySqlDataReader FireCommand(string query)
- {
- if (dbConnection == null)
- {
- return null;
- }
- MySqlCommand command = new MySqlCommand(query, dbConnection);
- var mySqlReader = command.ExecuteReader();
- return mySqlReader;
- }
- public void CloseConnection()
- {
- if (dbConnection != null)
- {
- dbConnection.Close();
- }
- }
- public static List<String> CheckExistingUser(IUser user)
- {
- var result = new List<String>();
- var database = new Database("Rambot");
- var str = string.Format("SELECT * FROM table_name WHERE user_id = '{0}'", user.Id);
- var tableName = database.FireCommand(str);
- while (tableName.Read())
- {
- var userId = (string)tableName["user_id"];
- result.Add(userId);
- }
- return result;
- }
- public static string EnterUser(IUser user)
- {
- var database = new Database("Rambot");
- var str = string.Format("INSERT INTO Ramtable (user_id, username, tokens ) VALUES ('{0}', '{1}', '100')", user.Id, user.Username);
- var table = database.FireCommand(str);
- database.CloseConnection();
- return null;
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement