Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private string GetName(string Id, bool bGetCreatureName)
- {
- string connStr = "server=" + MySQLSettings.server + ";user=" + MySQLSettings.user + ";database= " + MySQLSettings.database + ";port=" + MySQLSettings.port + ";password=" + MySQLSettings.password + ";";
- MySqlConnection conn = new MySqlConnection(connStr);
- try
- {
- string sql = "";
- if (bGetCreatureName == true)
- sql = "SELECT Name FROM creature_template WHERE entry=" + Id +";";
- else
- sql = "SELECT SpellName FROM dbc_spell WHERE Id =" + Id + ";";
- conn.Open();
- MySqlCommand cmd = new MySqlCommand(sql, conn);
- MySqlDataReader rdr = cmd.ExecuteReader();
- while (rdr.Read())
- {
- return rdr[0].ToString();
- }
- rdr.Close();
- }
- catch (Exception ex)
- {
- MessageBox.Show(ex.ToString());
- }
- conn.Close();
- return "";
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement