Advertisement
Guest User

WHAT IS THE ISSUE?!

a guest
Oct 30th, 2016
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.18 KB | None | 0 0
  1.         [HttpPost]
  2.         [Route("A3Bans/searchBan")]
  3.         public string oSearchBan(tBan ban)
  4.         {
  5.             {
  6.                 tBan bans = new tBan();
  7.                 string dbConnection = "datasource=127.0.0.1;port=3306;username=admin;password=00000";
  8.                 MySqlConnection conDataBase = new MySqlConnection(dbConnection);
  9.                 MySqlDataReader dbReader;
  10.                 MySqlCommand SelectCommand = new MySqlCommand ("SELECT * FROM a3bans.bans WHERE GUID =" + dbReader.GetString(ban.GuidOrIP);
  11.                 conDataBase.Open();
  12.                 dbReader = SelectCommand.ExecuteReader();
  13.                 while (dbReader.Read())
  14.                 {
  15.                     tBan searchBan = new tBan();
  16.                     searchBan.GuidOrIP = dbReader.GetString("GUID");
  17.                     searchBan.BanType = dbReader.GetString("BanType");
  18.                     searchBan.BanReason = dbReader.GetString("Reason");
  19.                     searchBan.Proof = dbReader.GetString("Proof");
  20.                     bans = searchBan;
  21.                 }
  22.                 dbReader.Close();
  23.                 return bans.Proof;
  24.                
  25.                
  26.             }
  27.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement