Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [HttpPost]
- [Route("A3Bans/searchBan")]
- public string oSearchBan(tBan ban)
- {
- {
- tBan bans = new tBan();
- string dbConnection = "datasource=127.0.0.1;port=3306;username=admin;password=00000";
- MySqlConnection conDataBase = new MySqlConnection(dbConnection);
- MySqlDataReader dbReader;
- conDataBase.Open();
- // Returns a null value from bans.Proof
- // If placing a /w real GUID without null fields, rather than "ban.GuidOrIP" , the return populates properly.
- // Either Null or Invalid Syntax...
- MySqlCommand selectCommand = new MySqlCommand("SELECT * FROM a3bans.bans WHERE `GUID` LIKE '" + ban.GuidOrIP + "' ;", conDataBase);
- // Tried to define parameters for the GUID, still a null or syntax error.
- //selectCommand.Parameters.AddWithValue("@guidID",ban.GuidOrIP);
- //Attempting NonQuery, still same result
- //selectCommand.ExecuteNonQuery();
- //selectCommand.Dispose();
- dbReader = selectCommand.ExecuteReader();
- try
- {
- while (dbReader.Read())
- {
- tBan searchBan = new tBan();
- searchBan.GuidOrIP = dbReader.GetString("GUID");
- searchBan.BanType = dbReader.GetString("BanType");
- searchBan.BanReason = dbReader.GetString("Reason");
- searchBan.Proof = dbReader.GetString("Proof");
- bans = searchBan;
- }
- }
- catch (Exception ex)
- {
- }
- finally
- {
- dbReader.Close();
- conDataBase.Close();
- }
- return bans.Proof;
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement