Advertisement
Guest User

Untitled

a guest
Jun 6th, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. private string GetName(string Id, bool bGetCreatureName)
  2. {
  3. string connStr = "server=" + MySQLSettings.server + ";user=" + MySQLSettings.user + ";database= " + MySQLSettings.database + ";port=" + MySQLSettings.port + ";password=" + MySQLSettings.password + ";";
  4. MySqlConnection conn = new MySqlConnection(connStr);
  5. try
  6. {
  7. string sql = "";
  8. if (bGetCreatureName == true)
  9. sql = "SELECT Name FROM creature_template WHERE entry=" + Id +";";
  10. else
  11. sql = "SELECT SpellName FROM dbc_spell WHERE Id =" + Id + ";";
  12.  
  13. conn.Open();
  14.  
  15. MySqlCommand cmd = new MySqlCommand(sql, conn);
  16. MySqlDataReader rdr = cmd.ExecuteReader();
  17.  
  18. while (rdr.Read())
  19. {
  20. return rdr[0].ToString();
  21. }
  22.  
  23. rdr.Close();
  24.  
  25. }
  26. catch (Exception ex)
  27. {
  28. MessageBox.Show(ex.ToString());
  29. }
  30.  
  31. conn.Close();
  32. return "";
  33. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement