Thx very much :D! I’ll try this when VIsual Studio is updated :D! Is 12% now :D.
Anyway for “create a mysql manager” you mean something like that , to get access to the database?
I’m new on coding :D, soo I don’t know perfectly everyting . Like this, but using this .dll you provided:
using System;
using System.Collections.Generic;
using MySql.Data.MySqlClient;
using CitizenFX.Core;
using CitizenFX.Core.Native;
namespace MySqlTut
{
public class DBConnect : BaseScript
{
//database stuff
private const String SERVER = "127.0.0.1";
private const String DATABASE = "test";
private const String UID = "root";
private const String PASSWORD = "";
private static MySqlConnection dbConn;
// User class stuff
public int Id { get; private set; }
public String Username { get; private set; }
public String Password { get; private set; }
public DBConnect(){
}
private DBConnect(int id, String u, String p)
{
Id = id;
Username = u;
Password = p;
}
public static void InitializeDB()
{
MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder();
builder.Server = SERVER;
builder.UserID = UID;
builder.Password = PASSWORD;
builder.Database = DATABASE;
String connString = builder.ToString();
builder = null;
Console.WriteLine(connString);
dbConn = new MySqlConnection(connString);
}
public static List<DBConnect> GetUsers()
{
List<DBConnect> users = new List<DBConnect>();
String query = "SELECT * FROM users";
MySqlCommand cmd = new MySqlCommand(query, dbConn);
dbConn.Open();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int id = (int)reader["id"];
String username = reader["username"].ToString();
String password = reader["password"].ToString();
DBConnect u = new DBConnect(id, username, password);
users.Add(u);
}
reader.Close();
dbConn.Close();
return users;
}
public static DBConnect Insert(String u, String p)
{
String query = string.Format("INSERT INTO users(username, password) VALUES ('{0}', '{1}')", u, p);
MySqlCommand cmd = new MySqlCommand(query, dbConn);
dbConn.Open();
cmd.ExecuteNonQuery();
int id = (int)cmd.LastInsertedId;
DBConnect user = new DBConnect(id, u, p);
dbConn.Close();
return user;
}
public void Update(string u, string p)
{
String query = string.Format("UPDATE users SET username='{0}', password='{1}' WHERE ID={2}", u, p, Id);
MySqlCommand cmd = new MySqlCommand(query, dbConn);
dbConn.Open();
cmd.ExecuteNonQuery();
dbConn.Close();
}
public void Delete()
{
String query = string.Format("DELETE FROM users WHERE ID={0}", Id);
MySqlCommand cmd = new MySqlCommand(query, dbConn);
dbConn.Open();
cmd.ExecuteNonQuery();
dbConn.Close();
}
}
}