public override void setupServer() { //throw new NotImplementedException(); setup(); if (!changeDb) { String[] configLines = File.ReadAllLines(Application.StartupPath + "\\serverconfig.cfg"); AppSettings.DefaultConnectionParameters = new String[] { configLines[0], configLines[1], configLines[2], configLines[3] }; AppSettings.QueryTimeOut = configLines.Length >= 7 ? int.Parse(configLines[5]) : AppSettings.QueryTimeOut; AppSettings.MaxRecordLevelSecurityCacheAge = new TimeSpan(0, 5, 0); MySqlDatabaseHandler dbHandler = new MySqlDatabaseHandler(); } else { String[] configLines = File.ReadAllLines(Application.StartupPath + "\\serverconfig1.cfg"); AppSettings.DefaultConnectionParameters = new String[] { configLines[0], configLines[1], configLines[2], configLines[3] }; AppSettings.QueryTimeOut = configLines.Length >= 7 ? int.Parse(configLines[5]) : AppSettings.QueryTimeOut; AppSettings.MaxRecordLevelSecurityCacheAge = new TimeSpan(0, 5, 0); MySqlDatabaseHandler dbHandler = new MySqlDatabaseHandler(configLines); DatabaseHandler.DefaultDatabaseHandlerObject = dbHandler; MySqlDatabaseHandler.DefaultDatabaseHandlerObject = dbHandler; } }
public async Task CreatureLookup(string name) { var message = await Context.Channel.SendMessageAsync("Let me see... :thinking:"); var creature = MySqlDatabaseHandler.GetCreature(name); if (creature == null) { return; } var eb = new EmbedBuilder(); eb.WithTitle(creature.Name); eb.WithDescription("This is what I could find:"); eb.AddField("Entry:", " " + creature.Entry, true); eb.AddField("Model ID:", " " + creature.ModelID1, true); eb.AddField("Min Level:", " " + creature.minLevel, true); eb.AddField("Max Level:", " " + creature.maxLevel, true); eb.AddField("AI Name:", " " + creature.AIName, true); eb.AddField("Script Name:", " " + creature.ScriptName, true); eb.WithTimestamp(DateTime.Now); eb.WithColor(Color.Red); await Context.Channel.SendMessageAsync("", false, eb.Build()); await message.DeleteAsync(); Console.WriteLine("[" + DateTime.Now + "]" + "[BOT] -> Send Result : " + name); }
private void setDbSettings(string[] configLines) { AppSettings.DefaultConnectionParameters = new String[] { configLines[0], configLines[1], configLines[2], configLines[3] }; AppSettings.QueryTimeOut = configLines.Length >= 7 ? int.Parse(configLines[5]) : AppSettings.QueryTimeOut; AppSettings.MaxRecordLevelSecurityCacheAge = new TimeSpan(0, 5, 0); MySqlDatabaseHandler dbHandler = new MySqlDatabaseHandler(configLines); DatabaseHandler.DefaultDatabaseHandlerObject = dbHandler; }
public override void setupWindowsClient() { setup(); String assemblyLocation = Util.getDirectoryPath(Assembly.GetExecutingAssembly().Location); string clientconfigfilename = assemblyLocation + "\\clientconfig.cfg"; String[] configLines = File.ReadAllLines(clientconfigfilename); if (AppSettings.Servers.Count == 0) { using (TimedLock.Lock(AppSettings.Servers)) { if (AppSettings.Servers.Count == 0) { String iplist = configLines[0].Trim(); String[] ips = iplist.Split(new char[] { ' ', ',' }, StringSplitOptions.RemoveEmptyEntries); String portlist = configLines[1].Trim(); String[] ports = portlist.Split(new char[] { ' ', ',' }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < ips.Length; i++) { AppSettings.Servers.Add(new AppFramework.AppClasses.AppSettings.ServerIPAndPort(ips[i], int.Parse(ports[i]))); } } } } try { MySqlDatabaseHandler dbHandler = new MySqlDatabaseHandler(); } catch (Exception e) { Infolog.writeToEventLog(e, InfoType.Error); if (System.Threading.Thread.CurrentThread.GetApartmentState() == System.Threading.ApartmentState.STA) { MessageBox.Show("Unable to establish server connection to server. Please view event logs for further details"); } Environment.Exit(205); } }
public override void setupWindowsClient() { setup(); String assemblyLocation = Util.getDirectoryPath(Assembly.GetExecutingAssembly().Location); string clientconfigfilename = assemblyLocation + "\\clientconfig.cfg"; String[] configLines = File.ReadAllLines(clientconfigfilename); if (AppSettings.Servers.Count == 0) { using (TimedLock.Lock(AppSettings.Servers)) { if (AppSettings.Servers.Count == 0) { String iplist = configLines[0].Trim(); String[] ips = iplist.Split(new char[] { ' ', ',' }, StringSplitOptions.RemoveEmptyEntries); String portlist = configLines[1].Trim(); String[] ports = portlist.Split(new char[] { ' ', ',' }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < ips.Length; i++) { AppSettings.Servers.Add(new AppFramework.AppClasses.AppSettings.ServerIPAndPort(ips[i], int.Parse(ports[i]))); } } } } try { MySqlDatabaseHandler dbHandler = new MySqlDatabaseHandler(); } catch (Exception e) { Infolog.writeToEventLog(e, InfoType.Error); if (System.Threading.Thread.CurrentThread.GetApartmentState() == System.Threading.ApartmentState.STA) { MessageBox.Show("Unable to establish server connection to server. Please view event logs for further details"); } Environment.Exit(205); } }
public async Task CharStatAsync(string name) { var message = await Context.Channel.SendMessageAsync("Let me see... :thinking:"); var character = MySqlDatabaseHandler.GetCharStats(name); if (character == null) { return; } var eb = new EmbedBuilder(); eb.WithTitle("Character Stats"); eb.WithDescription("This is what I could find:"); eb.AddField("Max Health:", " " + character.MaxHealth, true); eb.AddField("Mana:", " " + character.MaxPower1, true); eb.AddField("Rage:", " " + character.MaxPower2, true); eb.AddField("Focus:", " " + character.MaxPower3, true); eb.AddField("Energy:", " " + character.MaxPower4, true); eb.AddField("Happiness:", " " + character.MaxPower5, true); eb.AddField("Rune:", " " + character.MaxPower6, true); eb.AddField("Runic Power:", " " + character.MaxPower7, true); eb.AddField("Strength:", " " + character.Strength, true); eb.AddField("Agility:", " " + character.Agility, true); eb.AddField("Stamina:", " " + character.Stamina, true); eb.AddField("Intellect:", " " + character.Intellect, true); eb.AddField("Spirit:", " " + character.Spirit, true); eb.AddField("Armor:", " " + character.Armor, true); eb.WithTimestamp(DateTime.Now); eb.WithColor(Color.Red); await Context.Channel.SendMessageAsync("", false, eb.Build()); await message.DeleteAsync(); Console.WriteLine("[" + DateTime.Now + "]" + "[BOT] -> Send Character Stats : " + name); }
public override void setupServer() { //throw new NotImplementedException(); setup(); String[] configLines = File.ReadAllLines(Application.StartupPath + "\\serverconfig.cfg"); AppSettings.DefaultConnectionParameters = new String[] { configLines[0], configLines[1], configLines[2], configLines[3] }; //if (configLines.Length > 6) //{ // AppSettings.CompanyName = configLines[6]; //} //int port; //if (configLines.Length >= 9 && int.TryParse(configLines[8], out port)) //{ // AppSettings.Servers.Add(new AppSettings.ServerIPAndPort("", port)); //} AppSettings.QueryTimeOut = configLines.Length >= 4 ? int.Parse(configLines[4]) : AppSettings.QueryTimeOut; AppSettings.MaxRecordLevelSecurityCacheAge = new TimeSpan(0, 5, 0); MySqlDatabaseHandler dbHandler = new MySqlDatabaseHandler(); }
public async Task CharAsync(string name) { var message = await Context.Channel.SendMessageAsync("Let me see... :thinking:"); var character = MySqlDatabaseHandler.GetCharacter(name); if (character == null) { return; } var eb = new EmbedBuilder(); eb.WithDescription("This is what I could find:"); eb.AddField("Race:", " " + Convert.ToString(character.Race).Replace('_', ' '), true); eb.AddField("Class:", " " + Convert.ToString(character.Class).Replace('_', ' '), true); eb.AddField("Gender:", " " + Convert.ToString(character.Gender), true); eb.AddField("Level:", " " + character.Level, true); switch (character.Class) { case Class.Warrior: eb.WithThumbnailUrl("https://vignette.wikia.nocookie.net/wowwiki/images/e/ee/Warrior_crest.png/revision/latest?cb=20130813095500"); break; case Class.Paladin: eb.WithThumbnailUrl("https://vignette.wikia.nocookie.net/wowwiki/images/e/ee/Warrior_crest.png/revision/latest?cb=20130813095500"); break; case Class.Hunter: eb.WithThumbnailUrl("https://vignette.wikia.nocookie.net/wowwiki/images/2/20/Hunter_crest.png/revision/latest?cb=20130813094921"); break; case Class.Rogue: eb.WithThumbnailUrl("https://vignette.wikia.nocookie.net/wowwiki/images/e/e2/Rogue_crest.png/revision/latest?cb=20130813095139"); break; case Class.Priest: eb.WithThumbnailUrl("https://vignette.wikia.nocookie.net/wowwiki/images/7/71/Priest_crest.png/revision/latest?cb=20130813095106"); break; case Class.Death_Knight: eb.WithThumbnailUrl("https://vignette.wikia.nocookie.net/wowwiki/images/3/30/Death_knight_crest.png/revision/latest?cb=20130813094520"); break; case Class.Shaman: eb.WithThumbnailUrl("https://vignette.wikia.nocookie.net/wowwiki/images/d/df/Shaman_crest.png/revision/latest?cb=20130813095240"); break; case Class.Mage: eb.WithThumbnailUrl("https://vignette.wikia.nocookie.net/wowwiki/images/b/b8/Mage_crest.png/revision/latest?cb=20130813094952"); break; case Class.Warlock: eb.WithThumbnailUrl("https://vignette.wikia.nocookie.net/wowwiki/images/4/4f/Warlock_crest.png/revision/latest?cb=20130813095321"); break; case Class.Monk: eb.WithThumbnailUrl("https://vignette.wikia.nocookie.net/wowwiki/images/6/60/Monk_crest.png/revision/latest?cb=20130817144820"); break; case Class.Druid: eb.WithThumbnailUrl("https://vignette.wikia.nocookie.net/wowwiki/images/5/55/Druid_crest.png/revision/latest?cb=20130813094831"); break; case Class.Demon_Hunter: eb.WithThumbnailUrl("https://vignette.wikia.nocookie.net/wowwiki/images/d/db/Demon_hunter_crest-250x271.png/revision/latest?cb=20151004044357"); break; } eb.WithTimestamp(DateTime.Now); eb.WithAuthor(author => { author .WithName(character.Name); }); eb.WithColor(Color.Red); await Context.Channel.SendMessageAsync("", false, eb.Build()); await message.DeleteAsync(); Console.WriteLine("[" + DateTime.Now + "]" + "[BOT] -> Send Character : " + name); }