Example #1
0
        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);
        }
Example #2
0
        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);
            }
        }
Example #3
0
        public static void OnLogoutSocketConnection(Socket ClientSocket, String data)
        {
            ClientUpdateDataManager(data);

            MySqlManager.CheckClientsOnLogoutData(ClientSocket,
                                                  Clients.GetUserId(), Clients.GetUserState());
        }
Example #4
0
        private static void Init()
        {
            MySqlManager.InitializeDB();

            // MySqlManager.LoadAllMessage();
            // StartUpdate();
        }
Example #5
0
        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);
            }
        }
Example #6
0
        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);
            }
        }
Example #7
0
        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);
        }
Example #8
0
        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);
        }
Example #9
0
        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);
            }
        }
Example #10
0
        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");
            }
        }
Example #11
0
 /// <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("");
     }
 }
Example #12
0
        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);
        }
Example #13
0
        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
        }
Example #14
0
        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);
            }
        }
Example #15
0
        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);
            }
        }
Example #16
0
 public Stats(TCPWrapper MyTCPWrapper, Logger MyLogger, MySqlManager MyMySqlManager)
 {
     this.TheTCPWrapper             = MyTCPWrapper;
     this.TheTCPWrapper.GotCommand += new TCPWrapper.GotCommandEventHandler(OnGotCommand);
     this.TheLogger       = MyLogger;
     this.TheMySqlManager = MyMySqlManager;
 }
Example #17
0
 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);
 }
Example #18
0
		public GreetPlayers(TCPWrapper MyTCPWrapper, MySqlManager MyMySqlManager, ActorHandler MyActorHandler)
		{
			this.TheTCPWrapper = MyTCPWrapper;
			this.TheMySqlManager = MyMySqlManager;
            this.TheActorHandler = MyActorHandler;
            
            this.TheActorHandler.AddNewActor += new ActorHandler.AddNewActorEventHandler (OnAddNewActor);
		}
Example #19
0
        public AssessThreat(TCPWrapper MyTCPWrapper, MySqlManager MyMySqlManager, ActorHandler MyActorHandler)
        {
            this.TheTCPWrapper   = MyTCPWrapper;
            this.TheMySqlManager = MyMySqlManager;
            this.TheActorHandler = MyActorHandler;

            this.TheActorHandler.AddNewActor += new ActorHandler.AddNewActorEventHandler(OnAddNewActor);
        }
Example #20
0
 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);
 }
Example #21
0
 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);
 }
Example #22
0
 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!"));
 }
Example #23
0
        public AssessThreat(TCPWrapper MyTCPWrapper, MySqlManager MyMySqlManager, ActorHandler MyActorHandler)
        {
            this.TheTCPWrapper = MyTCPWrapper;
            this.TheMySqlManager = MyMySqlManager;
            this.TheActorHandler = MyActorHandler;

            this.TheActorHandler.AddNewActor += new ActorHandler.AddNewActorEventHandler (OnAddNewActor);
        }
Example #24
0
 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);
 }
Example #25
0
 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);
 }
Example #26
0
        public GreetPlayers(TCPWrapper MyTCPWrapper, MySqlManager MyMySqlManager, ActorHandler MyActorHandler)
        {
            this.TheTCPWrapper = MyTCPWrapper;
            this.TheMySqlManager = MyMySqlManager;
            this.TheActorHandler = MyActorHandler;

            this.TheActorHandler.AddNewActor += new ActorHandler.AddNewActorEventHandler (OnAddNewActor);
        }
Example #27
0
        public ActorHandler(TCPWrapper MyTCPWrapper, Logger MyLogger, MySqlManager MyMySqlManager)
        {
            this.TheTCPWrapper = MyTCPWrapper;
            this.TheLogger = MyLogger;
            this.TheMySQLManager = MyMySqlManager;

            TheTCPWrapper.GotCommand += new TCPWrapper.GotCommandEventHandler(OnGotCommand);
        }
Example #28
0
        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);
            }
        }
Example #29
0
 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);
 }
Example #30
0
 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);
 }
Example #31
0
 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);
 }
Example #32
0
 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");
 }
Example #33
0
 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);
 }
Example #34
0
 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);
 }
Example #35
0
 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);
 }
Example #36
0
 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);
 }
Example #37
0
 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);
 }
Example #38
0
        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();
        }
Example #39
0
        public bool CreateNewAffectsForChar()
        {
            bool valid = MySqlManager.InsertNewAffects(this.CharSqlID);

            if (valid)
            {
                MySqlManager.SetAffect(this.CharSqlID, "Rotting_In_Jail");
            }
            return(valid);
        }
Example #40
0
        /// <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);
            }
        }
Example #41
0
 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);
 }
Example #42
0
 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);
 }
Example #43
0
 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);
 }
Example #44
0
        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 + ")");
            }
        }
Example #45
0
 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);
 }
Example #46
0
        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);
        }
Example #47
0
        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);
        }
Example #48
0
        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);
        }
Example #49
0
 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);
 }
Example #50
0
        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);
        }
Example #51
0
        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);
            }
        }
Example #54
0
        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);
            }
        }
Example #55
0
        //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);
            }
        }
Example #57
0
 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);
     }
 }
Example #59
0
        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);
            }
        }
Example #60
0
        /*
        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);
        }