public void Excecute(IRocketPlayer caller, string[] args) { if (args.Length != 2) { LoonePermissions.Say(caller, "invalid_args", Color.red); return; } string groupId = args[0].ToLower(); string perm = args[1].ToLower(); if (!MySqlManager.GroupExists(groupId)) { LoonePermissions.Say(caller, "group_not_exists", Color.red); return; } if (MySqlManager.GetPermission(perm, groupId) == -1) { LoonePermissions.Say(caller, "perm_not_exists", Color.red, groupId, perm); return; } MySqlManager.RemovePermission(groupId, perm); LoonePermissions.Say(caller, "perm_removed", Color.green, perm, groupId); RocketLogger.Log(string.Format("{0} removed the permission {1} from {2}!", caller.DisplayName, perm, groupId), ConsoleColor.Yellow); }
public INVCommandHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser,HelpCommandHandler MyHelpCommandHandler, MySqlManager MyMySqlManager, Inventory MyInventory, TradeHandler MyTradeHandler, Stats MyStats) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheHelpCommandHandler = MyHelpCommandHandler; this.TheMySqlManager = MyMySqlManager; this.TheInventory = MyInventory; this.TheTradeHandler = MyTradeHandler; this.TheStats = MyStats; //this.CommandIsDisabled = MyMySqlManager.CheckIfCommandIsDisabled("#inv",Settings.botid); //if (CommandIsDisabled == false) { if (Settings.IsTradeBot == true) { TheHelpCommandHandler.AddCommand("#inventory / #inv / #i - show what I am selling"); TheHelpCommandHandler.AddCommand("#invmembers / #im - member rates"); TheHelpCommandHandler.AddCommand("#inv - null"); TheHelpCommandHandler.AddCommand("#i - null"); TheHelpCommandHandler.AddCommand("#inb - null"); TheHelpCommandHandler.AddCommand("#sell - null"); TheHelpCommandHandler.AddCommand("#selling - null"); TheHelpCommandHandler.AddCommand("#im - null"); TheHelpCommandHandler.AddCommand("#invmember - null"); TheHelpCommandHandler.AddCommand("#invmemver - null"); TheHelpCommandHandler.AddCommand("#invmemvers - null"); } TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); } }
public static void OnLogoutSocketConnection(Socket ClientSocket, String data) { ClientUpdateDataManager(data); MySqlManager.CheckClientsOnLogoutData(ClientSocket, Clients.GetUserId(), Clients.GetUserState()); }
private static void Init() { MySqlManager.InitializeDB(); // MySqlManager.LoadAllMessage(); // StartUpdate(); }
public PRIZECommandHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser,HelpCommandHandler MyHelpCommandHandler, MySqlManager MyMySqlManager, Inventory MyInventory, TradeHandler MyTradeHandler, Stats MyStats, Logger MyLogger, ActorHandler MyActorHandler) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheHelpCommandHandler = MyHelpCommandHandler; this.TheMySqlManager = MyMySqlManager; this.TheInventory = MyInventory; this.TheTradeHandler = MyTradeHandler; this.TheStats = MyStats; this.TheActorHandler = MyActorHandler; this.TheLogger = MyLogger; this.TheTCPWrapper.GotCommand += new TCPWrapper.GotCommandEventHandler(OnGotCommand); //this.CommandIsDisabled = MyMySqlManager.CheckIfCommandIsDisabled("#inv",Settings.botid); //if (CommandIsDisabled == false) { if (Settings.IsTradeBot == true && TheMySqlManager.IGamble()) { TheHelpCommandHandler.AddCommand("#prize - show my prize list"); TheHelpCommandHandler.AddCommand("#prizes - null"); } TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); this.TheInventory.GotNewInventoryList += new Inventory.GotNewInventoryListEventHandler(OnGotNewInventoryList); this.TheMessageParser.Got_AbortTrade += new BasicCommunication.MessageParser.Got_AbortTrade_EventHandler(OnGotAbortTrade); } }
public PRIZECommandHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser, HelpCommandHandler MyHelpCommandHandler, MySqlManager MyMySqlManager, Inventory MyInventory, TradeHandler MyTradeHandler, Stats MyStats, Logger MyLogger, ActorHandler MyActorHandler) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheHelpCommandHandler = MyHelpCommandHandler; this.TheMySqlManager = MyMySqlManager; this.TheInventory = MyInventory; this.TheTradeHandler = MyTradeHandler; this.TheStats = MyStats; this.TheActorHandler = MyActorHandler; this.TheLogger = MyLogger; this.TheTCPWrapper.GotCommand += new TCPWrapper.GotCommandEventHandler(OnGotCommand); //this.CommandIsDisabled = MyMySqlManager.CheckIfCommandIsDisabled("#inv",Settings.botid); //if (CommandIsDisabled == false) { if (Settings.IsTradeBot == true && TheMySqlManager.IGamble()) { TheHelpCommandHandler.AddCommand("#prize - show my prize list"); TheHelpCommandHandler.AddCommand("#prizes - null"); } TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); this.TheInventory.GotNewInventoryList += new Inventory.GotNewInventoryListEventHandler(OnGotNewInventoryList); this.TheMessageParser.Got_AbortTrade += new BasicCommunication.MessageParser.Got_AbortTrade_EventHandler(OnGotAbortTrade); } }
public void Excecute(IRocketPlayer caller, string[] args) { if (args.Length != 1) { LoonePermissions.Say(caller, "invalid_args", Color.red); return; } if (!MySqlManager.GroupExists(args[0].ToLower())) { LoonePermissions.Say(caller, "group_not_exists", Color.red); return; } if (LoonePermissionsConfig.DefaultGroup.ToLower() == args[0].ToLower()) { LoonePermissions.Say(caller, "group_default_already", Color.red); return; } MySqlManager.ReassignTo(LoonePermissionsConfig.DefaultGroup.ToLower(), args[0].ToLower(), true); LoonePermissionsConfig.SetDefaultGroup(args[0].ToLower()); LoonePermissions.Say(caller, "group_default", Color.green, args[0].ToLower()); RocketLogger.Log(string.Format("{0} set the default group to {1}!", caller.DisplayName, args[0].ToLower()), ConsoleColor.Yellow); }
public TextCommandsHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser, HelpCommandHandler MyHelpCommandHandler, MySqlManager MyMySqlManager, Logger MyLogger) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheHelpCommandHandler = MyHelpCommandHandler; this.TheMySqlManager = MyMySqlManager; this.TheLogger = MyLogger; //this.CommandIsDisabled = MyMySqlManager.CheckIfCommandIsDisabled("#donate",Settings.botid); string commands = TheMySqlManager.TextCommandlist(Settings.botid); if (commands.Length == 0) { return; } string[] commandsarray = commands.Split(' '); foreach (string command in commandsarray) { string paddedcommand = ""; if (command[0] != '#') { paddedcommand = "#"; } paddedcommand = paddedcommand + command; if (TheMySqlManager.CheckIfTextCommandIsDisabled(paddedcommand, Settings.botid) == false) { string text = TheMySqlManager.TextCommandHelpText(paddedcommand, Settings.botid); TheHelpCommandHandler.AddCommand(paddedcommand + text); } } TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); }
public INVCommandHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser, HelpCommandHandler MyHelpCommandHandler, MySqlManager MyMySqlManager, Inventory MyInventory, TradeHandler MyTradeHandler, Stats MyStats) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheHelpCommandHandler = MyHelpCommandHandler; this.TheMySqlManager = MyMySqlManager; this.TheInventory = MyInventory; this.TheTradeHandler = MyTradeHandler; this.TheStats = MyStats; //this.CommandIsDisabled = MyMySqlManager.CheckIfCommandIsDisabled("#inv",Settings.botid); //if (CommandIsDisabled == false) { if (Settings.IsTradeBot == true) { TheHelpCommandHandler.AddCommand("#inventory / #inv / #i - show what I am selling"); TheHelpCommandHandler.AddCommand("#invmembers / #im - member rates"); TheHelpCommandHandler.AddCommand("#inv - null"); TheHelpCommandHandler.AddCommand("#i - null"); TheHelpCommandHandler.AddCommand("#inb - null"); TheHelpCommandHandler.AddCommand("#sell - null"); TheHelpCommandHandler.AddCommand("#selling - null"); TheHelpCommandHandler.AddCommand("#im - null"); TheHelpCommandHandler.AddCommand("#invmember - null"); TheHelpCommandHandler.AddCommand("#invmemver - null"); TheHelpCommandHandler.AddCommand("#invmemvers - null"); } TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); } }
public BANCommandHandler(HelpCommandHandler MyHelpCommandHandler, TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser, AdminHelpCommandHandler MyAminHelpCommandHandler, MySqlManager MyMySqlManager, Logger MyLogger) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheAdminHelpCommandHandler = MyAminHelpCommandHandler; this.TheMySqlManager = MyMySqlManager; this.TheLogger = MyLogger; this.TheHelpCommandHandler = MyHelpCommandHandler; //this.CommandIsDisabled = MyMySqlManager.CheckIfCommandIsDisabled("#BAN",Settings.botid); //if (CommandIsDisabled == false) { TheAdminHelpCommandHandler.AddCommand("#ban - ban a player"); TheAdminHelpCommandHandler.AddCommand("#unban - unban a banned player"); TheAdminHelpCommandHandler.AddCommand("#banguild / #bg - ban a guild"); TheAdminHelpCommandHandler.AddCommand("#unbanguild / #ug - unban a banned guild"); TheAdminHelpCommandHandler.AddCommand("#prefer - give a player preferential rates"); TheAdminHelpCommandHandler.AddCommand("#preferguild / #pg - give a guild preferential rates"); TheAdminHelpCommandHandler.AddCommand("#rank - change player's admin level rank"); TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); TheHelpCommandHandler.AddCommand("#bg - null"); TheHelpCommandHandler.AddCommand("#ug - null"); TheHelpCommandHandler.AddCommand("#pg - null"); } }
/// <summary> /// 获取封禁原因 /// </summary> /// <param name="banPlayer">目标玩家</param> /// <returns></returns> public string GetBanReason(ServerPlayer banPlayer) { try { MySqlManager dbm = new MySqlManager(); dbm.Connect(); MySqlCommand cmd = dbm.command; cmd.CommandText = "select ban, banreason from users where username = @UserName"; cmd.Parameters.AddWithValue("@UserName", banPlayer.Name); using (MySqlDataReader mdr = cmd.ExecuteReader()) { if (mdr.Read()) { Ban = mdr["ban"].ToString(); BanReason = mdr["banreason"].ToString(); } } cmd.Cancel(); if (Ban == "1") { return(BanReason); } else { return(""); } } catch (Exception ex) { ErrorLog = ex.Message; return(""); } }
public TextCommandsHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser, HelpCommandHandler MyHelpCommandHandler, MySqlManager MyMySqlManager, Logger MyLogger) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheHelpCommandHandler = MyHelpCommandHandler; this.TheMySqlManager = MyMySqlManager; this.TheLogger = MyLogger; //this.CommandIsDisabled = MyMySqlManager.CheckIfCommandIsDisabled("#donate",Settings.botid); string commands = TheMySqlManager.TextCommandlist(Settings.botid); if (commands.Length == 0) { return; } string[] commandsarray = commands.Split(' '); foreach (string command in commandsarray) { string paddedcommand = ""; if (command[0] != '#') paddedcommand = "#"; paddedcommand = paddedcommand + command; if (TheMySqlManager.CheckIfTextCommandIsDisabled(paddedcommand, Settings.botid) == false) { string text = TheMySqlManager.TextCommandHelpText(paddedcommand, Settings.botid); TheHelpCommandHandler.AddCommand(paddedcommand + text); } } TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); }
public override void SetUp() { base.SetUp(); person = new Person { FirstName = "Paymon", LastName = "Khamooshi" }; #region Create database for Person entity var server = new MySqlManager(); if (server.Exists(TempDatabaseName, TempDatabaseName)) { return; } server.ClearConnectionPool(); server.Delete(TempDatabaseName); foreach (var file in GetExecutableCreateDbScripts(TempDatabaseName)) { try { server.Execute(file.Value, TempDatabaseName); } catch (Exception ex) { throw new Exception("Could not execute sql file '" + file.Key.FullName + "'", ex); } } server.ClearConnectionPool(); #endregion }
public WANTEDCommandHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser, HelpCommandHandler MyHelpCommandHandler, MySqlManager MyMySqlManager, Logger MyLogger, TradeHandler MyTradeHandler, Inventory MyInventory, Stats MyStats) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheHelpCommandHandler = MyHelpCommandHandler; this.TheMySqlManager = MyMySqlManager; this.TheLogger = MyLogger; this.TheTradeHandler = MyTradeHandler; this.TheInventory = MyInventory; this.TheStats = MyStats; //this.CommandIsDisabled = MyMySqlManager.CheckIfCommandIsDisabled("#wanted",Settings.botid); //if (CommandIsDisabled == false) { if (Settings.IsTradeBot == true) { TheHelpCommandHandler.AddCommand("#wanted / #w - see what I am buying"); TheHelpCommandHandler.AddCommand("#w - null"); TheHelpCommandHandler.AddCommand("#want - null"); TheHelpCommandHandler.AddCommand("#buying - null"); } TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); } }
public Stats(TCPWrapper MyTCPWrapper, Logger MyLogger, MySqlManager MyMySqlManager) { this.TheTCPWrapper = MyTCPWrapper; this.TheTCPWrapper.GotCommand += new TCPWrapper.GotCommandEventHandler(OnGotCommand); this.TheLogger = MyLogger; this.TheMySqlManager = MyMySqlManager; }
public PMHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser, MySqlManager MyMySqlManager) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheMySqlManager = MyMySqlManager; CommandArrayList.Clear(); TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); }
public GreetPlayers(TCPWrapper MyTCPWrapper, MySqlManager MyMySqlManager, ActorHandler MyActorHandler) { this.TheTCPWrapper = MyTCPWrapper; this.TheMySqlManager = MyMySqlManager; this.TheActorHandler = MyActorHandler; this.TheActorHandler.AddNewActor += new ActorHandler.AddNewActorEventHandler (OnAddNewActor); }
public AssessThreat(TCPWrapper MyTCPWrapper, MySqlManager MyMySqlManager, ActorHandler MyActorHandler) { this.TheTCPWrapper = MyTCPWrapper; this.TheMySqlManager = MyMySqlManager; this.TheActorHandler = MyActorHandler; this.TheActorHandler.AddNewActor += new ActorHandler.AddNewActorEventHandler(OnAddNewActor); }
public MessageParser(BasicCommunication.RawText MyRawText, Logger MyLogger, TCPWrapper MyTCPWrapper, MySqlManager MyMySqlManager) { this.TheLogger = MyLogger; this.TheTCPWrapper = MyTCPWrapper; this.TheMySqlManager = MyMySqlManager; TheRawText = MyRawText; TheRawText.Got_RAW_TEXT += new BasicCommunication.RawText.Got_RAW_TEXT_EventHandler(OnGot_RAW_TEXT); }
public Perks(TCPWrapper MyTCPWrapper, Logger MyLogger, MySqlManager MyMySqlManager) { this.TheTCPWrapper = MyTCPWrapper; this.TheTCPWrapper.GotCommand += new TCPWrapper.GotCommandEventHandler(OnGotCommand); this.TheLogger = MyLogger; this.TheMySqlManager = MyMySqlManager; //TheTCPWrapper.Send(CommandCreator.SEND_PM(TradeHandler.username, "I'm too far away from storage to open it, move me closer please!")); }
public AssessThreat(TCPWrapper MyTCPWrapper, MySqlManager MyMySqlManager, ActorHandler MyActorHandler) { this.TheTCPWrapper = MyTCPWrapper; this.TheMySqlManager = MyMySqlManager; this.TheActorHandler = MyActorHandler; this.TheActorHandler.AddNewActor += new ActorHandler.AddNewActorEventHandler (OnAddNewActor); }
public Inventory(TCPWrapper MyTCPWrapper, Logger MyLogger, MySqlManager MyMySqlManager) { this.TheTCPWrapper = MyTCPWrapper; this.TheTCPWrapper.GotCommand += new TCPWrapper.GotCommandEventHandler(OnGotCommand); this.TheLogger = MyLogger; this.TheMySqlManager = MyMySqlManager; TheTCPWrapper.GotDisconnected += new TCPWrapper.GotDisconnectedEventHandler(GotServerDisconnected); }
public ActorHandler(TCPWrapper MyTCPWrapper, Logger MyLogger, MySqlManager MyMySqlManager) { this.TheTCPWrapper = MyTCPWrapper; this.TheLogger = MyLogger; this.TheMySQLManager = MyMySqlManager; TheTCPWrapper.GotCommand += new TCPWrapper.GotCommandEventHandler(OnGotCommand); }
public void Excecute(IRocketPlayer caller, string[] args) { if (args.Length != 2 && args.Length != 3) { LoonePermissions.Say(caller, "invalid_args", Color.red); return; } if (!MySqlManager.GroupExists(args[0].ToLower())) { LoonePermissions.Say(caller, "group_not_exists", Color.red); return; } string groupId = args[0].ToLower(); string perm = args[1].ToLower(); bool doModify; int oldCooldown = MySqlManager.GetPermission(perm, groupId); doModify = oldCooldown != -1; int cooldown; if (args.Length == 3) { if (!int.TryParse(args[2], out cooldown)) { LoonePermissions.Say(caller, "invalid_args", Color.red); return; } } else { cooldown = 0; } if (doModify) { if (oldCooldown == cooldown) { LoonePermissions.Say(caller, "perm_exists", Color.red); return; } else { MySqlManager.ModifyPermsission(groupId, perm, cooldown); LoonePermissions.Say(caller, "perm_modified", Color.green, perm, groupId, cooldown); RocketLogger.Log(string.Format("{0} has set the cooldown of {1} to {2} in {3}!", caller.DisplayName, perm, cooldown, groupId), ConsoleColor.Yellow); } } else { MySqlManager.AddPermission(groupId, perm, cooldown); LoonePermissions.Say(caller, "perm_added", Color.green, perm, groupId, cooldown); RocketLogger.Log(string.Format("{0} added the permission {1} with a cooldown of {2} to {3}!", caller.DisplayName, perm, cooldown, groupId), ConsoleColor.Yellow); } }
public LoginLogger(BasicCommunication.Login MyLogin, Logger MyLogger, TCPWrapper MyTCPWrapper, MySqlManager MyMySqlManager) { TheLogger = MyLogger; TheLogin = MyLogin; TheTCPWrapper = MyTCPWrapper; TheMySqlManager = MyMySqlManager; this.TheLogin.Got_LOG_IN_OK += new BasicCommunication.Login.Got_LOG_IN_OK_EventHandler(LOG_IN_OK); this.TheLogin.Got_LOG_IN_NOT_OK += new BasicCommunication.Login.Got_LOG_IN_NOT_OK_EventHandler(LOG_IN_NOT_OK); }
public new_minute(TCPWrapper MyTCPWrapper, MySqlManager MyMySqlManager, Inventory MyInventory) { TheTCPWrapper = MyTCPWrapper; TheTCPWrapper.GotCommand += new TCPWrapper.GotCommandEventHandler(OnGotCommand); this.TheMySqlManager = MyMySqlManager; this.TheInventory = MyInventory; TheTCPWrapper.GotConnected += new TCPWrapper.GotConnectedEventHandler(OnGotConnected); TheTCPWrapper.GotDisconnected += new TCPWrapper.GotDisconnectedEventHandler(OnGotDisconnected); }
public void Init() { GetPhysicalAddress(); manager = new MySqlManager("23.105.221.177", "feedback", "feedback", "1344710445"); manager.onSqlConnected += OnSqlConnected; manager.OpenSqlConnection(); Mediator.AddListener(this, "feedback"); Mediator.AddValue(this, "reply"); }
public GuildTextHandler(BasicCommunication.RawText MyRawText, TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser, MySqlManager MyMySqlManager, Logger MyLogger) { this.TheLogger = MyLogger; this.TheMessageParser = MyMessageParser; this.TheRawText = MyRawText; this.TheMySqlManager = MyMySqlManager; this.TheTCPWrapper = MyTCPWrapper; TheMessageParser.Get_GlobalMessage += new BasicCommunication.MessageParser.Get_GlobalMessageEventHandler(Got_GlobalMessage); }
public MessageLogger(BasicCommunication.MessageParser MyMessageParser, Logger MyLogger, MySqlManager MyMySqlManager) { TheLogger = MyLogger; TheMessageParser = MyMessageParser; TheMySqlManager = MyMySqlManager; this.TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); this.TheMessageParser.Send_PM += new BasicCommunication.MessageParser.Send_PM_EventHandler(OnSendPM); this.TheMessageParser.Get_GlobalMessage += new BasicCommunication.MessageParser.Get_GlobalMessageEventHandler(OnGlobalMessage); }
public static void Main() { IDatabase db = new Database(); //read from zip file & populate the database with more data + create updates pdf, xml & json files var reader = new ReadExcelFromZip(); var movies = reader.SelectExcelFilesFromZip("../../../../Movies.zip"); foreach (var movie in movies) { Console.WriteLine(movie.Name); } var import = new MoviesImportToSql(); import.Import(movies); Console.WriteLine("Importing data from xml..."); //Importing data from xml XmlImporter.ImportXml(db); //Console.WriteLine("Importing data to Mongo..."); //Importing data to MongoDB //ImportToMongo.ImportToMongo.ImportData(); Console.WriteLine("Generating xml files..."); //Generating Xml file report var generateXMLFile = new XMLGenerator(); generateXMLFile.Generate(db); Console.WriteLine("Generating json files..."); //Generating Json file reports var generateJsonReports = new JSONGenerator(); generateJsonReports.Generate(db); Console.WriteLine("Generating pdf reports..."); //Generating Pdf fle reports var generatePdfReports = new PDFGenerator(); generatePdfReports.Generate(db); Console.WriteLine("Sending data to MySql..."); //Sending data to MySql var sendDataToMySQL = new MySqlManager(); sendDataToMySQL.SendDataToMySql(); Console.WriteLine("Exporting data from MySql to excel file..."); //Exporting data from MySql to excel file var mySqlExcelExport = new MySqlManager(); mySqlExcelExport.ExportDataFromMySql(); }
public bool CreateNewAffectsForChar() { bool valid = MySqlManager.InsertNewAffects(this.CharSqlID); if (valid) { MySqlManager.SetAffect(this.CharSqlID, "Rotting_In_Jail"); } return(valid); }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <returns></returns> public Country GetCountry(int id) { MySqlManager db = new MySqlManager(DbConnectionString); StringBuilder sbQuery = new StringBuilder(); Country country = new Country(); try { sbQuery.Append("select ") .Append("Id, ") .Append("NameEn, ") .Append("NameEs, ") .Append("ISO2, ") .Append("ISO3 ") .Append("from country ") .Append("where Id = ").Append(id); if (db.Open() == true) { MySqlDataReader reader = db.ExecuteReader(CommandType.Text, sbQuery.ToString()); if (reader.HasRows) { while (reader.Read()) { country = new Country { Id = Convert.ToInt32(reader["Id"].ToString()), NameEn = reader["NameEn"].ToString(), NameEs = reader["NameEs"].ToString(), ISO2 = reader["ISO2"].ToString(), ISO3 = reader["ISO3"].ToString() }; } } else { country = null; } reader.Close(); db.Close(); } else { // Error at Connect to SQL-Server Server ErrorMessage = db.ErrorMessage; return(null); } return(country); } catch { ErrorMessage = db.ErrorMessage; return(null); } }
public CancelTradeCommandHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser, AdminHelpCommandHandler MyAdminHelpCommandHandler, MySqlManager MyMySqlManager, Logger MyLogger, TradeHandler MyTradeHandler) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheMySqlManager = MyMySqlManager; this.TheAdminHelpCommandHandler = MyAdminHelpCommandHandler; this.TheLogger = MyLogger; this.TheTradeHandler = MyTradeHandler; TheAdminHelpCommandHandler.AddCommand("#canceltrade - cancels trade and resets trade indicator"); TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); }
public WhoIsTradingCommandHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser, AdminHelpCommandHandler MyAdminHelpCommandHandler, MySqlManager MyMySqlManager, Logger MyLogger, TradeHandler MyTradeHandler) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheMySqlManager = MyMySqlManager; this.TheAdminHelpCommandHandler = MyAdminHelpCommandHandler; this.TheLogger = MyLogger; this.TheTradeHandler = MyTradeHandler; TheAdminHelpCommandHandler.AddCommand("#whoistrading - tells you who's trading with me"); TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); }
internal static void FieldTypeEquals(FieldType type, string connectionString, string databaseName, string tableName, string fieldName) { var sql = "SELECT DATA_TYPE FROM [" + databaseName + "].INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @tableName AND COLUMN_NAME = @fieldName"; var actual = ExecuteScalar(connectionString, sql, new MySqlParameter("tableName", tableName), new MySqlParameter("fieldName", fieldName)).ToString(); var actualType = MySqlManager.GetFieldType(actual); if (type != actualType) { throw new Exception("Field '" + fieldName + "' in table '" + tableName + "' is not a " + type + ", its " + actual + " (" + actualType + ")"); } }
public OpenStorage(HelpCommandHandler MyHelpCommandHandler, TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser, MySqlManager MyMySqlManager, ActorHandler MyActorHandler,AdminHelpCommandHandler MyAdminHelpCommandHandler) { this.TheTCPWrapper = MyTCPWrapper; this.TheMySqlManager = MyMySqlManager; this.TheActorHandler = MyActorHandler; this.TheMessageParser = MyMessageParser; this.TheAdminHelpCommandHandler = MyAdminHelpCommandHandler; this.TheHelpCommandHandler = MyHelpCommandHandler; TheAdminHelpCommandHandler.AddCommand("#openstorage / #os - Open storage"); TheHelpCommandHandler.AddCommand("#os - null"); TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); }
public AFKCommandHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser, HelpCommandHandler MyHelpCommandHandler, MySqlManager MyMySqlManager, Logger MyLogger) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheHelpCommandHandler = MyHelpCommandHandler; this.TheMySqlManager = MyMySqlManager; this.TheLogger = MyLogger; TheHelpCommandHandler.AddCommand("#automessage: - null"); TheHelpCommandHandler.AddCommand("#automessage - null"); TheHelpCommandHandler.AddCommand("#afk - null"); TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); }
public Shutdown(TCPWrapper MyTCPWrapper, MessageParser MyMessageParser, MySqlManager MyMySqlManager, errorHandler MyErrorHandler) { TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheMySqlManager = MyMySqlManager; this.TheErrorHandler = MyErrorHandler; ShutdownTimer.Interval=MainClass.ONE_MINUTE; ShutdownTimer.Elapsed += new ElapsedEventHandler(ShutdownTimer_Tick); TheTCPWrapper.GotConnected += new TCPWrapper.GotConnectedEventHandler(OnGotConnected); TheTCPWrapper.GotDisconnected += new TCPWrapper.GotDisconnectedEventHandler(OnGotDisconnected); }
public QuitCommandHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser, AdminHelpCommandHandler MyAdminHelpCommandHandler, MySqlManager MyMySqlManager, Logger MyLogger, TradeHandler MyTradeHandler, Inventory MyInventory) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheMySqlManager = MyMySqlManager; this.TheAdminHelpCommandHandler = MyAdminHelpCommandHandler; this.TheLogger = MyLogger; this.TheTradeHandler = MyTradeHandler; this.TheInventory = MyInventory; TheAdminHelpCommandHandler.AddCommand("#quit / #exit / #shutdown - make me shut down"); TheAdminHelpCommandHandler.AddCommand("#exit - null"); TheAdminHelpCommandHandler.AddCommand("#shutdown - null"); TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); }
public HouseKeepingHandler(TCPWrapper MyTCPWrapper, MySqlManager MyMySqlManager, Logger MyLogger, errorHandler MyErrorHandler) { this.TheLogger = MyLogger; this.TheMySqlManager = MyMySqlManager; this.TheTCPWrapper = MyTCPWrapper; this.TheErrorHandler = MyErrorHandler; TheTCPWrapper = MyTCPWrapper; TheMySqlManager = MyMySqlManager; TheLogger.Debug("New HouseKeepingTimer.Interval: " + this.HouseKeepingTimer.Interval + "\n"); HouseKeepingTimer.Elapsed += new ElapsedEventHandler(HouseKeepingTimer_Tick); TheTCPWrapper.GotConnected += new TCPWrapper.GotConnectedEventHandler(OnGotConnected); TheTCPWrapper.GotDisconnected += new TCPWrapper.GotDisconnectedEventHandler(OnGotDisconnected); }
public GTCommandHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser, AdminHelpCommandHandler MyAdminHelpCommandHandler, MySqlManager MyMySqlManager, Logger MyLogger) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheAdminHelpCommandHandler = MyAdminHelpCommandHandler; this.TheMySqlManager = MyMySqlManager; this.TheLogger = MyLogger; //this.CommandIsDisabled = MyMySqlManager.CheckIfCommandIsDisabled("#gt", Settings.botid); //if (this.CommandIsDisabled == false) { this.TheAdminHelpCommandHandler.AddCommand("#gt - Provide guild feed to the bot"); this.TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); } }
public ISOnlineCommandHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser,HelpCommandHandler MyHelpCommandHandler, MySqlManager MyMySqlManager, Logger MyLogger) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheHelpCommandHandler = MyHelpCommandHandler; this.TheMySqlManager = MyMySqlManager; this.TheLogger = MyLogger; //this.CommandIsDisabled = MyMySqlManager.CheckIfCommandIsDisabled("#loc",Settings.botid); //if (CommandIsDisabled == false) { TheHelpCommandHandler.AddCommand("#isonline - tells you the online status of a player"); TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); } }
public ACCEPTMECommandHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser, AdvHelpCommandHandler MyAdvHelpCommandHandler, MySqlManager MyMySqlManager, Logger MyLogger) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheAdvHelpCommandHandler = MyAdvHelpCommandHandler; this.TheMySqlManager = MyMySqlManager; this.TheLogger = MyLogger; //this.CommandIsDisabled = MyMySqlManager.CheckIfCommandIsDisabled("#acceptme", Settings.botid); //if (this.CommandIsDisabled == false) { this.TheAdvHelpCommandHandler.AddCommand("#acceptme - accept me into the guild"); this.TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); } }
public HelpCommandHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser,PMHandler MyPMHandler, MySqlManager MyMySqlManager) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.ThePMHandler = MyPMHandler; this.TheMySqlManager = MyMySqlManager; //this.CommandIsDisabled = MyMySqlManager.CheckIfCommandIsDisabled("#help",Settings.botid); //if (CommandIsDisabled == false) { ThePMHandler.AddCommand("#help"); ThePMHandler.AddCommand("#h"); TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); } }
//private bool CommandIsDisabled; public PMCommandHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser,AdminHelpCommandHandler MyAdminHelpCommandHandler, MySqlManager MyMySqlManager) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheAdminHelpCommandHandler = MyAdminHelpCommandHandler; this.TheMySqlManager = MyMySqlManager; TheAdminHelpCommandHandler.AddCommand("#pm - send a pm to somebody"); TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); //this.CommandIsDisabled = MyMySqlManager.CheckIfCommandIsDisabled("#pm",Settings.botid); //if (CommandIsDisabled == false) //{ // TheAdminHelpCommandHandler.AddCommand("#pm - send a pm to somebody"); // TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); //} }
public UseObject(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser, AdminHelpCommandHandler MyAdminHelpCommandHandler, MySqlManager MyMySqlManager, PMHandler MyPMHandler) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheAdminHelpCommandHandler = MyAdminHelpCommandHandler; this.TheMySqlManager = MyMySqlManager; this.ThePMHandler = MyPMHandler; //this.CommandIsDisabled = MyMySqlManager.CheckIfCommandIsDisabled("#help",Settings.botid); //if (CommandIsDisabled == false) { TheAdminHelpCommandHandler.AddCommand("#useobject - Use a map object(like a banner)"); TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); } }
public ELTCCommandHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser, HelpCommandHandler MyHelpCommandHandler, MySqlManager MyMySqlManager, Logger MyLogger) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheHelpCommandHandler = MyHelpCommandHandler; this.TheMySqlManager = MyMySqlManager; this.TheLogger = MyLogger; TheHelpCommandHandler.AddCommand("#thx - null"); TheHelpCommandHandler.AddCommand("#thy - null"); TheHelpCommandHandler.AddCommand("#thank - null"); TheHelpCommandHandler.AddCommand("#thanks - null"); TheHelpCommandHandler.AddCommand("#ty - null"); TheHelpCommandHandler.AddCommand("#tyvm - null"); TheHelpCommandHandler.AddCommand("#thanx - null"); TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); }
public DepositCommandHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser, AdvHelpCommandHandler MyAdvHelpCommandHandler, MySqlManager MyMySqlManager, Inventory MyInventory, TradeHandler MyTradeHandler, Stats MyStats, Storage MyStorage) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheAdvHelpCommandHandler = MyAdvHelpCommandHandler; this.TheMySqlManager = MyMySqlManager; this.TheInventory = MyInventory; this.TheTradeHandler = MyTradeHandler; this.TheStats = MyStats; this.TheStorage = MyStorage; { TheAdvHelpCommandHandler.AddCommand("#deposit - deposit something(s) into my storage"); TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); this.TheTCPWrapper.GotCommand += new TCPWrapper.GotCommandEventHandler(OnGotCommand); } }
public DropCommandHandler(TCPWrapper MyTCPWrapper, BasicCommunication.MessageParser MyMessageParser,AdminHelpCommandHandler MyAdminHelpCommandHandler, MySqlManager MyMySqlManager, Logger MyLogger,TradeHandler MyTradeHandler, Inventory MyInventory) { this.TheTCPWrapper = MyTCPWrapper; this.TheMessageParser = MyMessageParser; this.TheAdminHelpCommandHandler = MyAdminHelpCommandHandler; this.TheMySqlManager = MyMySqlManager; this.TheLogger = MyLogger; this.TheTradeHandler = MyTradeHandler; this.TheInventory = MyInventory; //this.CommandIsDisabled = MyMySqlManager.CheckIfCommandIsDisabled("#drop",Settings.botid); //if (CommandIsDisabled == false) { TheAdminHelpCommandHandler.AddCommand("#drop - make me drop a item from my inventory"); TheMessageParser.Got_PM += new BasicCommunication.MessageParser.Got_PM_EventHandler(OnGotPM); } }
/* public int nextlineset { get { return nextline; } set { nextline = value; } } */ public RulesHandler(TCPWrapper MyTCPWrapper, MySqlManager MyMySqlManager, Logger MyLogger, TradeHandler MyTradeHandler) { if (Settings.botid != 1) return; this.TheLogger = MyLogger; this.TheMySqlManager = MyMySqlManager; this.TheTCPWrapper = MyTCPWrapper; this.TheTradeHandler = MyTradeHandler; TheTCPWrapper = MyTCPWrapper; TheMySqlManager = MyMySqlManager; this.RulesTimer.Interval = 1000; RulesTimer.Elapsed += new ElapsedEventHandler(RulesTimer_Tick); TheTCPWrapper.GotConnected += new TCPWrapper.GotConnectedEventHandler(OnGotConnected); TheTCPWrapper.GotDisconnected += new TCPWrapper.GotDisconnectedEventHandler(OnGotDisconnected); }