Ejemplo n.º 1
0
        /// <summary>
        /// Queries the database, returns an datatable.
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public static DataTable GetMultiQuery(string sql)
        {
            DataTable dt = new DataTable();

            try
            {
                SQLiteConnection SConnection = new SQLiteConnection();
                SConnection.ConnectionString =
                    "Data Source=users.siu;" +
                    "UseUTF16Encoding=True;" +
                    "Legacy Format=False;";

                SConnection.Open();

                SQLiteCommand Command = new SQLiteCommand(SConnection);
                Command.CommandText = sql;

                SQLiteDataReader Reader = Command.ExecuteReader();
                dt.Load(Reader);
                Reader.Close();
                Reader.Dispose();
                Command.Dispose();

                SConnection.Close();
                SConnection.Dispose();
            }
            catch (Exception e)
            {
                SiusLog.Log(SiusLog.WARNING, "GetQuery", e.Message);
            }
            return(dt);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// RequestStop() will set the connected status to false,
        /// abort the thread, and close the socket.
        /// </summary>
        public void RequestStop()
        {
            if (thrListener != null && thrListener.IsAlive)             // thread is active
            {
                // set event "Stop"
                Sius.Connected = false;
                thrListener.Abort();
                Listening.Stop();

                TcpClient[] tcpClients = new TcpClient[htRcon.Count];
                htRcon.Values.CopyTo(tcpClients, 0);

                for (int i = 0; i < tcpClients.Length; i++)
                {
                    try
                    {
                        if (tcpClients[i] != null)
                        {
                            tcpClients[i].Close();
                        }
                    }
                    catch (Exception e)
                    {
                        SiusLog.Log(SiusLog.DEBUG, "disconnect", e.Message);
                    }
                }
            }
        }
Ejemplo n.º 3
0
        public static void Connect()
        {
            try
            {
                SQLiteConnection SConnection = new SQLiteConnection();
                SConnection.ConnectionString =
                    "Data Source=users.siu;" +
                    "UseUTF16Encoding=True;" +
                    "Legacy Format=False;";

                SConnection.Open();

                CreatePlayersTable(SConnection);
                CreateBannersTable(SConnection);
                CreateMessagesTable(SConnection);
                CreateSquadsTable(SConnection);
                SiusLog.Log(SiusLog.DEBUG, "SQLite", "Attempted to create all necessary database tables.");

                SConnection.Close();
                SConnection.Dispose();
            }
            catch (Exception e)
            {
                SiusLog.Log(SiusLog.ERROR, "SQLite", e.Message);
            }
        }
Ejemplo n.º 4
0
        /// <summary>
        /// Begin listening for incoming TCP connections on the specified port number
        /// </summary>
        public void StartListening()
        {
            int port = SiusConf.GetSetting.Integer("port");

            // TCP port numbers are 16 bits in length, so they can only be within the range of 0 - 65535
            if (port <= 0 || port >= 65535)
            {
                SiusLog.Log(SiusLog.ERROR, "server", "An error occured when trying to define a port number. Please make sure the port is within the range of 1 - 65534");
                Sius.Connected = false;
                return;
            }

            string    address = SiusConf.GetSetting.String("ip");
            IPAddress localAddr;

            // check if the IP Address is valid
            if (SiusUtil.IsValidIP(address) == false)
            {
                SiusLog.Log(SiusLog.ERROR, "server", "Unable to retrieve IP Address. Please make sure that you are using a valid IP Address such as 127.0.0.1");
                Sius.Connected = false;
                return;
            }
            else
            {
                localAddr = IPAddress.Parse(address);
            }

            // Log our port and ip address
            SiusLog.Log(SiusLog.INFORMATION, "server", "Server port: " + port + ", Server IP: " + address);

            // Create TCP Listener and start checking for incoming connections
            try
            {
                Listening = new TcpListener(localAddr, port);
                Listening.Start();
            }
            catch (SocketException e)
            {
                SiusLog.Log(SiusLog.ERROR, "connect", e.Message);
                Sius.Connected = false;
                return;
            }

            // Server is connected!
            Sius.Connected = true;

            // Start a new thread
            thrListener = new Thread(KeepListening);
            thrListener.Start();
        }
Ejemplo n.º 5
0
        /// <summary>
        /// Creates the initial "banners" table.
        /// ID - NAME - BANNER
        /// </summary>
        private static void CreateBannersTable(SQLiteConnection SConnection)
        {
            try
            {
                SQLiteCommand Command = new SQLiteCommand(SConnection);
                Command.CommandText =
                    "CREATE TABLE IF NOT EXISTS [banners] (" +
                    "[name] TEXT COLLATE NOCASE  UNIQUE NOT NULL," +
                    "[banner] TEXT  NOT NULL" +
                    ")";

                Command.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                SiusLog.Log(SiusLog.ERROR, "SQLite", e.Message);
            }
        }
Ejemplo n.º 6
0
        private void KeepListening()
        {
            // While the server is running
            while (Sius.Connected == true)
            {
                try
                {
                    // Accept a pending connection
                    tcpClient = Listening.AcceptTcpClient();

                    // Create a new instance of Connection
                    Connection newConnection = new Connection(tcpClient);
                }
                catch (SocketException e)
                {
                    SiusLog.Log(SiusLog.WARNING, "connect", e.Message);
                }
            }
        }
Ejemplo n.º 7
0
        /// <summary>
        /// Creates the initial "messages" table.
        /// ID - NAME - MESSAGE - FLAG
        /// </summary>
        private static void CreateMessagesTable(SQLiteConnection SConnection)
        {
            try
            {
                SQLiteCommand Command = new SQLiteCommand(SConnection);
                Command.CommandText =
                    "CREATE TABLE IF NOT EXISTS [messages] (" +
                    "[name] TEXT COLLATE NOCASE  NOT NULL," +
                    "[sender] TEXT COLLATE NOCASE  NOT NULL," +
                    "[message] TEXT  NOT NULL," +
                    "[time] TEXT  NULL," +
                    "[flag] INTEGER  DEFAULT 0" +
                    ")";

                Command.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                SiusLog.Log(SiusLog.ERROR, "SQLite", e.Message);
            }
        }
Ejemplo n.º 8
0
        /// <summary>
        /// Will send a sql query without expecting a result returned.
        /// </summary>
        /// <param name="sql"></param>
        public static void SendQuery(string sql)
        {
            try
            {
                SQLiteConnection SConnection = new SQLiteConnection();
                SConnection.ConnectionString =
                    "Data Source=users.siu;UseUTF16Encoding=True;Legacy Format=False;";

                SConnection.Open();

                SQLiteCommand Command = new SQLiteCommand(SConnection);
                Command.CommandText = sql;
                Command.ExecuteNonQuery();
                Command.Dispose();
                SConnection.Close();
                SConnection.Dispose();
            }
            catch (Exception e)
            {
                SiusLog.Log(SiusLog.DEBUG, "SendQuery", e.Message);
            }
        }
Ejemplo n.º 9
0
        /// <summary>
        /// Creates the initial "players" table.
        /// ID - NAME - PASSWORD - USAGE - CREATED - LASTLOGIN
        /// </summary>
        private static void CreatePlayersTable(SQLiteConnection SConnection)
        {
            try
            {
                SQLiteCommand Command = new SQLiteCommand(SConnection);
                Command.CommandText =
                    "CREATE TABLE IF NOT EXISTS [players] (" +
                    "[id] INTEGER  PRIMARY KEY AUTOINCREMENT NOT NULL," +
                    "[name] TEXT COLLATE NOCASE  UNIQUE NOT NULL," +
                    "[password] TEXT  NULL," +
                    "[salt] TEXT  NULL," +
                    "[squad] TEXT COLLATE NOCASE  NULL," +
                    "[usage] INTEGER  DEFAULT 0," +
                    "[created] TEXT  NULL," +
                    "[lastseen] TEXT DEFAULT CURRENT_TIMESTAMP NULL" +
                    ")";

                Command.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                SiusLog.Log(SiusLog.ERROR, "SQLite", e.Message);
            }
        }
Ejemplo n.º 10
0
        static void Main(string[] args)
        {
            try
            {
                // Add to the console
                Console.Title = "Sius";
                Console.WriteLine("Sius");
                Console.Write("Press any key to exit ..." + Environment.NewLine);

                Time = DateTime.Now;

                // Check if we are logging
                if (!string.IsNullOrEmpty(SiusConf.GetSetting.String("logging")))
                {
                    SiusLog.Logging = true;
                }

                // Check if we want to clear the log before starting
                if (SiusConf.GetSetting.Boolean("clearlog"))
                {
                    SiusLog.ClearLogFile();
                }

                // Create the SQLite database and tables
                SQLite.Connect();

                // Log that Sius has successfully started
                SiusLog.Log(SiusLog.INFORMATION, "server", "Sius successfully started.");

                // Initialize the Transmission Control Protocol (TCP) connection
                Listen tcp = new Listen();
                tcp.StartListening();

                // Start the Ping timer
                System.Timers.Timer SendPing = new System.Timers.Timer();
                SendPing.Elapsed += new ElapsedEventHandler(Protocol.Ping.OnTimedEvent);

                if (SiusConf.GetSetting.Integer("ping") >= 10)
                {
                    SendPing.Interval = SiusConf.GetSetting.Integer("ping") * 1000;
                }
                else
                {
                    SendPing.Interval = 150000;                     // 150 seconds
                }
                SendPing.Enabled = true;
                SendPing.Start();

                // Start the Scorereset timer
                System.Timers.Timer Scorereset = new System.Timers.Timer();
                Scorereset.Elapsed += new ElapsedEventHandler(Protocol.Scorereset.OnTimedEvent);

                if (SiusConf.GetSetting.Integer("scorereset") >= 1)
                {
                    Scorereset.Interval = SiusConf.GetSetting.Integer("scorereset") * 3600000;
                }
                else
                {
                    Scorereset.Interval = 1209600000;                     // 2 weeks
                }
                Scorereset.Enabled = true;
                Scorereset.Start();

                // Wait until we're told to exit the program
                while (Running == true)
                {
                    // press any key to exit
                    Console.ReadKey(true);
                    Running = false;
                    SendPing.Close();
                    Scorereset.Close();
                }

                // Cleanup and end all TCP connections
                Sius.Connected = false;
                SiusLog.Log(SiusLog.INFORMATION, "server", "Exiting");
                tcp.RequestStop();

                // Append a line to the log to mark the end of a run.
                SiusLog.DirectLogToFile("-----------------------------------------------------");
            }
            catch (Exception e)
            {
                // Log any unexpected errors
                SiusLog.Log(SiusLog.ERROR, "server", "Error: " + e.StackTrace);
            }
        }
Ejemplo n.º 11
0
        // Occurs when a new client is accepted
        private void AcceptClient()
        {
            srReceiver = new StreamReader(tcpClient.GetStream());
            swSender   = new StreamWriter(tcpClient.GetStream());

            // Read the account information from the client
            strReceive = srReceiver.ReadLine();

            // We received a response from the zone
            if (!string.IsNullOrEmpty(strReceive))
            {
                //SiusLog.Log(SiusLog.INFORMATION, "zone", strReceive);
                string respond = Protocol.Connect.Try(strReceive);

                if (!string.IsNullOrEmpty(respond))
                {
                    //SiusLog.Log(SiusLog.DEBUG, "zone", respond); //CONNECTOK
                    swSender.WriteLine(respond);
                    swSender.Flush();
                }

                if (respond.StartsWith("CONNECTBAD"))
                {
                    CloseConnection();
                }
            }
            else
            {
                CloseConnection();
                return;
            }

            // Add the zone to the hash table
            Zone.AddZone(tcpClient);

//	        try
//			{
            // Keep waiting for a message from the user
            while ((Sius.Connected == true) && thrSender.IsAlive)
            {
                if (!string.IsNullOrEmpty(strReceive = srReceiver.ReadLine()))
                {
                    //SiusLog.Log(SiusLog.INFORMATION, "zone", strReceive);
                    string respond = Message.Receive(strReceive);

                    if (!string.IsNullOrEmpty(respond))
                    {
                        try
                        {
                            //SiusLog.Log(SiusLog.DEBUG, "zone", respond);
                            swSender.WriteLine(respond);
                            swSender.Flush();
                        }
                        catch (Exception e)
                        {
                            SiusLog.Log(SiusLog.DEBUG, "connect", e.Message);
                        }
                    }
                }
                else
                {
                    break;
                }
            }
//			}
//	        catch (Exception e)
//			{
//	            SiusLog.Log(SiusLog.MALICIOUS, "disconnect", e.Message);
//			}
            //Disconnect
            Zone.RemoveZone(tcpClient);
            SiusLog.Log(SiusLog.INFORMATION, "disconnect", Zone.ZoneName + " disconnected from network.");
            CloseConnection();
        }