Ejemplo n.º 1
0
        private void cmdUpgrade_Click(object sender, EventArgs e)
        {
            try
            {
                using (OpenFileDialog OFD = new OpenFileDialog())
                {
                    OFD.FileName = "GameSrv.db";
                    OFD.Filter = "GameSrv.db|GameSrv.db";
                    if (OFD.ShowDialog() == DialogResult.OK)
                    {
                        richTextBox1.Clear();
                        using (RMSQLiteConnection DB = new RMSQLiteConnection(Path.GetDirectoryName(OFD.FileName), Path.GetFileName(OFD.FileName), false))
                        {
                            SQL = "SELECT Value FROM ConfigTbl WHERE Option = '_DBVERSION'";
                            if (DB.ExecuteScalar(SQL).ToString() == "6")
                            {
                                // Values that can be harvested for gamesrv.ini
                                HandleGameSrvDotIni(DB);

                                // Values that can be harvested for logoffprocess.ini (LogoutProcessTbl order by StepNumber)
                                HandleLogOffOrOnProcessDotIni(DB, "off", "out");
                                HandleLogOffOrOnProcessDotIni(DB, "on", "in");

                                // Values that can be harvested for doors
                                HandleDoors(DB);

                                // Values that can be harvested for menus
                                HandleMenus(DB);

                                // Values that can be harvested for users
                                HandleUsers(DB);
                            }
                            else
                            {
                                Dialog.Error("Sorry, that file doesn't appear to be from a GameSrv v10.04.02 install", "Upgrade aborted");
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Dialog.Error("Error upgrading: " + ex.Message, "Upgrade failed");
            }
        }
Ejemplo n.º 2
0
        private void HandleMenus(RMSQLiteConnection DB)
        {
            AddToLog("Importing menus");

            // Get menu names
            List<string> MenuNames = new List<string>();
            SQL = "SELECT DISTINCT MenuName FROM MenuTbl WHERE MenuName <> 'GLOBAL' ORDER BY MenuName";
            DB.ExecuteReader(SQL);
            while (DB.Reader.Read())
            {
                MenuNames.Add(DB.Reader["MenuName"].ToString());
            }
            DB.Reader.Close();

            // Erase old menus
            foreach (string MenuName in MenuNames)
            {
                string FileName = StringUtils.PathCombine(ProcessUtils.StartupPath, "menus", MenuName.ToLower().Replace(" ", "_") + ".ini");
                if (File.Exists(FileName)) FileUtils.FileDelete(FileName);
            }

            // Add hotkeys to menus
            SQL = "SELECT * FROM MenuTbl ORDER BY MenuName, HotKey";
            DB.ExecuteReader(SQL);
            while (DB.Reader.Read())
            {
                string HotKey = DB.Reader["HotKey"].ToString();
                string Name = DB.Reader["Description"].ToString();
                string Action = CommandToAction(DB.Reader["Command"].ToString());
                string Parameters = DB.Reader["Parameters"].ToString();
                string RequiredAccess = DB.Reader["RequiredAccess"].ToString();

                // Modify parameters, for those that need it
                if (Action == "ChangeMenu")
                {
                    Parameters = Parameters.Replace(" ", "_");
                }
                else if (Action == "RunDoor")
                {
                    Parameters = GetSafeDoorFileName(Name);
                }

                if (Action == DB.Reader["Command"].ToString())
                {
                    AddToLog(" - Ignoring command that no longer exists (" + Action + ")");
                }
                else
                {
                    List<string> MenuNamesToUpdate = new List<string>();
                    if (DB.Reader["MenuName"].ToString().ToUpper() == "GLOBAL")
                    {
                        foreach (string MenuName in MenuNames)
                        {
                            // Don't add the global CHANGE_MENU commands to the menu we're wanting to change to
                            // i.e. Don't add a CHANGE_MENU MAIN to the MAIN menu
                            if ((Action != "ChangeMenu") || (Parameters.ToUpper() != MenuName.ToUpper()))
                            {
                                MenuNamesToUpdate.Add(MenuName);
                            }
                        }
                    }
                    else
                    {
                        MenuNamesToUpdate.Add(DB.Reader["MenuName"].ToString());
                    }

                    foreach (string MenuNameToUpdate in MenuNamesToUpdate)
                    {
                        using (IniFile Ini = new IniFile(StringUtils.PathCombine(ProcessUtils.StartupPath, "menus", MenuNameToUpdate.ToLower().Replace(" ", "_") + ".ini")))
                        {
                            Ini.WriteString(HotKey, "Name", Name);
                            Ini.WriteString(HotKey, "Action", Action);
                            Ini.WriteString(HotKey, "Parameters", Parameters);
                            Ini.WriteString(HotKey, "RequiredAccess", RequiredAccess);

                            AddToLog(" - Added Menu = " + MenuNameToUpdate);
                            AddToLog("         HotKey = " + HotKey);
                            AddToLog("         Name = " + Name);
                            AddToLog("         Action = " + Action);
                            AddToLog("         Parameters = " + Parameters);
                            AddToLog("         RequiredAccess = " + RequiredAccess);
                        }
                    }
                }

            }
            DB.Reader.Close();

            // RecordID, MenuName, HotKey, Description, Command, Parameters, RequiredAccess
            AddToLog("");
        }
Ejemplo n.º 3
0
        private void HandleUsers(RMSQLiteConnection DB)
        {
            AddToLog("Importing users");
            SQL = "SELECT * FROM UserTbl U INNER JOIN GroupTbl G ON U.GroupID = G.GroupID";
            DB.ExecuteReader(SQL);
            while (DB.Reader.Read())
            {
                // UserID, GroupID, RLoginHostID, UserName, Password, RealName, Email, EmailVerification, EmailVerified, RegistrationDate
                string AccessLevel = DB.Reader["AccessLevel"].ToString();
                string Alias = DB.Reader["UserName"].ToString();
                string PasswordSalt = StringUtils.RandomString(100);
                string PasswordHash = UserInfo.GetPasswordHash(DB.Reader["Password"].ToString(), PasswordSalt, _PasswordPepper);
                string UserId = DB.Reader["UserID"].ToString();

                using (IniFile Ini = new IniFile(StringUtils.PathCombine(ProcessUtils.StartupPath, "users", UserInfo.SafeAlias(Alias.ToLower()) + ".ini")))
                {
                    Ini.WriteString("USER", "AccessLevel", AccessLevel);
                    Ini.WriteString("USER", "Alias", Alias);
                    Ini.WriteString("USER", "PasswordSalt", PasswordSalt);
                    Ini.WriteString("USER", "PasswordHash", PasswordHash);
                    Ini.WriteString("USER", "UserId", UserId);

                    AddToLog(" - Added Alias = " + Alias);
                    AddToLog("         AccessLevel = " + AccessLevel);
                    AddToLog("         PasswordSalt = " + PasswordSalt);
                    AddToLog("         PasswordHash = " + PasswordHash);
                    AddToLog("         UserId = " + UserId);
                    AddToLog("");
                }
            }
            DB.Reader.Close();
        }
Ejemplo n.º 4
0
        private void HandleLogOffOrOnProcessDotIni(RMSQLiteConnection DB, string offOrOn, string inOrOut)
        {
            AddToLog("Importing settings for log" + offOrOn + "process.ini");
            using (IniFile Ini = new IniFile(StringUtils.PathCombine(ProcessUtils.StartupPath, "config", "log" + offOrOn + "process.ini")))
            {
                // Erase old sections
                string[] Sections = Ini.ReadSections();
                foreach (string Section in Sections)
                {
                    Ini.EraseSection(Section);
                }

                SQL = "SELECT * FROM Log" + inOrOut + "ProcessTbl ORDER BY StepNumber";
                DB.ExecuteReader(SQL);
                while (DB.Reader.Read())
                {
                    string Name = "Log" + offOrOn + "Process" + DB.Reader["StepNumber"].ToString();
                    string Action = CommandToAction(DB.Reader["Command"].ToString());
                    string Parameters = DB.Reader["Parameters"].ToString();
                    string RequiredAccess = DB.Reader["RequiredAccess"].ToString();

                    if (Action == DB.Reader["Command"].ToString())
                    {
                        AddToLog(" - Ignoring command that no longer exists (" + Action + ")");
                    }
                    else
                    {
                        // See if we need to add the logon/off process as a door
                        if (Action == "RunDoor")
                        {
                            string[] CommandAndParameters = DB.Reader["Parameters"].ToString().Split(' ');
                            string Command = CommandAndParameters[0];
                            string DoorParameters = string.Join(" ", CommandAndParameters, 1, CommandAndParameters.Length - 1);
                            bool Native = DB.Reader["Command"].ToString() == "EXEC";

                            using (IniFile DoorIni = new IniFile(StringUtils.PathCombine(ProcessUtils.StartupPath, "doors", GetSafeDoorFileName(Name) + ".ini")))
                            {
                                DoorIni.WriteString("DOOR", "Name", Name);
                                DoorIni.WriteString("DOOR", "Command", Command);
                                DoorIni.WriteString("DOOR", "Parameters", DoorParameters);
                                DoorIni.WriteString("DOOR", "Native", Native.ToString());
                                DoorIni.WriteString("DOOR", "ForceQuitDelay", "5");
                                DoorIni.WriteString("DOOR", "WindowStyle", "Minimized");
                            }

                            AddToLog(" - Added Door = " + Name);
                            AddToLog("         Command = " + Command);
                            AddToLog("         Parameters = " + DoorParameters);
                            AddToLog("         Native = " + Native.ToString());

                            // Override settings to be used below
                            Action = "RunDoor";
                            Parameters = Name;
                        }

                        Ini.WriteString(Name, "Name", Name);
                        Ini.WriteString(Name, "Action", Action);
                        Ini.WriteString(Name, "Parameters", Parameters);
                        Ini.WriteString(Name, "RequiredAccess", RequiredAccess);

                        AddToLog(" - Added Name = " + Name);
                        AddToLog("         Action = " + Action);
                        AddToLog("         Parameters = " + Parameters);
                        AddToLog("         RequiredAccess = " + RequiredAccess);
                    }
                }
                DB.Reader.Close();
            }
            AddToLog("");
        }
Ejemplo n.º 5
0
        private void HandleGameSrvDotIni(RMSQLiteConnection DB)
        {
            AddToLog("Importing settings for gamesrv.ini");
            using (IniFile Ini = new IniFile(StringUtils.PathCombine(ProcessUtils.StartupPath, "config", "gamesrv.ini")))
            {
                string BBSName = DB.ExecuteScalar("SELECT Value FROM ConfigTbl WHERE Option = 'BBSName'").ToString();
                Ini.WriteString("CONFIGURATION", "BBSName", BBSName);
                AddToLog(" - BBSName = " + BBSName);

                string SysopName = DB.ExecuteScalar("SELECT Value FROM ConfigTbl WHERE Option = 'SysOpName'").ToString();
                string SysopFirstName = SysopName;
                string SysopLastName = "";
                if (SysopName.Trim().Contains(" "))
                {
                    string[] SysopNameElements = SysopName.Split(' ');
                    SysopFirstName = SysopNameElements[0];
                    SysopLastName = string.Join(" ", SysopNameElements, 1, SysopNameElements.Length - 1);
                }
                Ini.WriteString("CONFIGURATION", "SysopFirstName", SysopFirstName);
                AddToLog(" - SysopFirstName = " + SysopFirstName);
                Ini.WriteString("CONFIGURATION", "SysopLastName", SysopLastName);
                AddToLog(" - SysopLastName = " + SysopLastName);

                string SysopEmail = DB.ExecuteScalar("SELECT Value FROM ConfigTbl WHERE Option = 'SysOpEmailAddress'").ToString();
                Ini.WriteString("CONFIGURATION", "SysopEmail", SysopEmail);
                AddToLog(" - SysopEmail = " + SysopEmail);

                int FirstNode = Convert.ToInt32(DB.ExecuteScalar("SELECT Value FROM ConfigTbl WHERE Option = 'FirstNode'"));
                int Nodes = Convert.ToInt32(DB.ExecuteScalar("SELECT Value FROM ConfigTbl WHERE Option = 'Nodes'"));
                int LastNode = FirstNode + Nodes - 1;
                Ini.WriteString("CONFIGURATION", "FirstNode", FirstNode.ToString());
                AddToLog(" - FirstNode = " + FirstNode.ToString());
                Ini.WriteString("CONFIGURATION", "LastNode", LastNode.ToString());
                AddToLog(" - LastNode = " + LastNode.ToString());

                string TimePerCall = DB.ExecuteScalar("SELECT MinutesPerCall FROM GroupTbl WHERE GroupID = 2").ToString();
                Ini.WriteString("CONFIGURATION", "TimePerCall", TimePerCall);
                AddToLog(" - TimePerCall = " + TimePerCall);

                string NextUserId = DB.ExecuteScalar("SELECT MAX(UserID) + 1 FROM UserTbl").ToString();
                Ini.WriteString("CONFIGURATION", "NextUserId", NextUserId);
                AddToLog(" - NextUserId = " + NextUserId);

                if (DB.ExecuteScalar("SELECT COUNT(*) FROM ServerThreadTbl WHERE ConnectionType = 2").ToString() != "0")
                {
                    string TelnetServerIP = DB.ExecuteScalar("SELECT LocalAddress FROM ServerThreadTbl WHERE ConnectionType = 2 ORDER BY ServerThreadID LIMIT 1").ToString();
                    Ini.WriteString("CONFIGURATION", "TelnetServerIP", TelnetServerIP);
                    AddToLog(" - TelnetServerIP = " + TelnetServerIP);

                    string TelnetServerPort = DB.ExecuteScalar("SELECT LocalPort FROM ServerThreadTbl WHERE ConnectionType = 2 ORDER BY ServerThreadID LIMIT 1").ToString();
                    Ini.WriteString("CONFIGURATION", "TelnetServerPort", TelnetServerPort);
                    AddToLog(" - TelnetServerPort = " + TelnetServerPort);
                }

                if (DB.ExecuteScalar("SELECT COUNT(*) FROM ServerThreadTbl WHERE ConnectionType = 1").ToString() != "0")
                {
                    string RLoginServerIP = DB.ExecuteScalar("SELECT LocalAddress FROM ServerThreadTbl WHERE ConnectionType = 1 ORDER BY ServerThreadID LIMIT 1").ToString();
                    Ini.WriteString("CONFIGURATION", "RLoginServerIP", RLoginServerIP);
                    AddToLog(" - RLoginServerIP = " + RLoginServerIP);

                    string RLoginServerPort = DB.ExecuteScalar("SELECT LocalPort FROM ServerThreadTbl WHERE ConnectionType = 1 ORDER BY ServerThreadID LIMIT 1").ToString();
                    Ini.WriteString("CONFIGURATION", "RLoginServerPort", RLoginServerPort);
                    AddToLog(" - RLoginServerPort = " + RLoginServerPort);
                }

                _PasswordPepper = (chkPlaintextPasswords.Checked) ? "DISABLE" : StringUtils.RandomString(100);
                Ini.WriteString("CONFIGURATION", "PasswordPepper", _PasswordPepper);
                AddToLog(" - PasswordPepper = " + _PasswordPepper);
            }
            AddToLog("");
        }
Ejemplo n.º 6
0
        private void HandleDoors(RMSQLiteConnection DB)
        {
            AddToLog("Importing settings for doors.ini");
            SQL = "SELECT * FROM MenuTbl WHERE Command IN ('EXEC', 'EXEC_NETFOSS', 'EXEC_MSYNCFOS')";
            DB.ExecuteReader(SQL);
            while (DB.Reader.Read())
            {
                string Name = DB.Reader["Description"].ToString();
                string[] CommandAndParameters = DB.Reader["Parameters"].ToString().Split(' ');
                string Command = CommandAndParameters[0];
                string Parameters = string.Join(" ", CommandAndParameters, 1, CommandAndParameters.Length - 1);
                bool Native = DB.Reader["Command"].ToString() == "EXEC";

                using (IniFile Ini = new IniFile(StringUtils.PathCombine(ProcessUtils.StartupPath, "doors", GetSafeDoorFileName(Name) + ".ini")))
                {
                    Ini.WriteString("DOOR", "Name", Name);
                    Ini.WriteString("DOOR", "Command", Command);
                    Ini.WriteString("DOOR", "Parameters", Parameters);
                    Ini.WriteString("DOOR", "Native", Native.ToString());
                    Ini.WriteString("DOOR", "ForceQuitDelay", "5");
                    Ini.WriteString("DOOR", "WindowStyle", "Minimized");
                }

                AddToLog(" - Added Name = " + Name);
                AddToLog("         Command = " + Command);
                AddToLog("         Parameters = " + Parameters);
                AddToLog("         Native = " + Native.ToString());
            }
            DB.Reader.Close();
            AddToLog("");
        }
Ejemplo n.º 7
0
        // Show the high scores
        static void HighScores()
        {
            Door.TextAttr(7);
            Door.ClrScr();

            Door.GotoXY(25, 2);
            Door.Write("|0ERMastermind Top 10 Fastest Solves");
            Door.DrawBox(2, 3, 79, 14, Crt.White, Crt.Blue, CrtPanel.BorderStyle.SingleV);
            Door.GotoXY(4, 3);
            Door.Write("|1F###");
            Door.CursorRight(1);
            Door.Write("Player Name");
            Door.CursorRight(29);
            Door.Write("Seconds");
            Door.CursorRight(1);
            Door.Write("Date");
            Door.GotoXY(1, 4);

            using (RMSQLiteConnection DB = new RMSQLiteConnection("HighScores.sqlite", false))
            {
                int i = 0;
                DB.ExecuteReader("SELECT * FROM HighScores ORDER BY Seconds, RecordDate LIMIT 10");
                while (DB.Reader.Read())
                {
                    i++;
                    Door.CursorRight(3);
                    Door.Write(StringUtils.PadLeft(i.ToString(), '0', 2) + ". ");
                    Door.Write(StringUtils.PadRight(DB.Reader["PlayerName"].ToString(), ' ', 40));
                    Door.Write(StringUtils.PadLeft(DB.Reader["Seconds"].ToString(), ' ', 5) + "   ");
                    Door.Write(StringUtils.PadRight(DB.Reader["RecordDate"].ToString(), ' ', 22));
                    Door.WriteLn();
                }

                while (i < 10)
                {
                    i++;
                    Door.CursorRight(3);
                    Door.WriteLn(StringUtils.PadLeft(i.ToString(), '0', 2) + ". ");
                }
            }

            Door.GotoXY(1, 16);
            Door.More();
        }
Ejemplo n.º 8
0
        // Check to see if all four pegs are black }
        static bool CheckWon()
        {
            for (int i = 0; i < 4; i++)
            {
                if (Lines[CurLine].Peg[i] != 1) return false;
            }

            GameOver = true;
            ChangeMsg("Congratulations, You Win!");
            DrawAnswer();

            // Save the high score
            DateTime EndTime = DateTime.Now;
            TimeSpan TS = EndTime - StartTime;
            using (RMSQLiteConnection DB = new RMSQLiteConnection("HighScores.sqlite", false))
            {
                string SQL = "";
                SQL = "INSERT INTO HighScores (PlayerName, Seconds, RecordDate) VALUES (";
                SQL += DB.AddVarCharParameter(Door.DropInfo.Alias) + ", ";
                SQL += DB.AddIntParameter((int)TS.TotalSeconds) + ", ";
                SQL += DB.AddDateTimeParameter(StartTime) + ") ";
                DB.ExecuteNonQuery(SQL);
            }

            return true;
        }