Esempio n. 1
0
        public void MarkQuestCompleted(Quest quest)
        {
            //find the quest in the player's quest list
            PlayerQuest playerQuest = Quests.SingleOrDefault(
                pq => pq.Details.ID == quest.ID);

            if (playerQuest != null)
            {
                playerQuest.IsCompleted = true;
            }
        }
Esempio n. 2
0
        public static Player CreatePlayerFromXmlString(string xmlPlayerData)
        {
            try
            {
                XmlDocument playerData = new XmlDocument();

                playerData.LoadXml(xmlPlayerData);

                int currentHitPoints = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/CurrentHitPoints").InnerText);
                int maximumHitPoints = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/MaximumHitPoints").InnerText);
                int gold             = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/Gold").InnerText);
                int experiencePoints = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/ExperiencePoints").InnerText);

                Player player = new Player(currentHitPoints, maximumHitPoints, gold, experiencePoints);

                int currentLocationID = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/CurrentLocation").InnerText);
                player.CurrentLocation = World.LocationByID(currentLocationID);

                if (playerData.SelectSingleNode("/Player/Stats/CurrentWeapon") != null)
                {
                    int currentWeaponID = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/CurrentWeapon").InnerText);
                    player.CurrentWeapon = (Weapon)World.ItemByID(currentWeaponID);
                }

                foreach (XmlNode node in playerData.SelectNodes("/Player/InventoryItems/InventoryItem"))
                {
                    int id       = Convert.ToInt32(node.Attributes["ID"].Value);
                    int quantity = Convert.ToInt32(node.Attributes["Quantity"].Value);

                    for (int i = 0; i < quantity; i++)
                    {
                        player.AddItemToInventory(World.ItemByID(id));
                    }
                }

                foreach (XmlNode node in playerData.SelectNodes("/Player/PlayerQuests/PlayerQuest"))
                {
                    int  id          = Convert.ToInt32(node.Attributes["ID"].Value);
                    bool isCompleted = Convert.ToBoolean(node.Attributes["IsCompleted"].Value);

                    PlayerQuest playerQuest = new PlayerQuest(World.QuestByID(id));
                    playerQuest.IsCompleted = isCompleted;

                    player.Quests.Add(playerQuest);
                }

                return(player);
            }
            catch
            {
                // If there was an error with the XML data, return a default player object
                return(Player.CreateDefaultPlayer());
            }
        }
        public void MarkQuestCompleted(Quest quest)
        {
            // NOTE:  If the player does not have 'quest', this will do nothing

            // Find the quest in the player's quest list
            PlayerQuest playerQuest = Quests.SingleOrDefault(
                pq => pq.Details.ID == quest.ID);

            if (playerQuest != null)
            {
                // if we found the quest in player's quest list, complete it
                playerQuest.IsCompleted = true;
            }
        }
Esempio n. 4
0
        public void UpdateQuest(int questID, int state)
        {
            PlayerQuest playerQuest = Quests.SingleOrDefault(
                pq => pq.ID == questID);

            if (playerQuest == null)
            {
                Quests.Add(new PlayerQuest(World.GetQuest(questID), state, false));
            }
            else
            {
                playerQuest.State = state;
            }
        }
Esempio n. 5
0
        // mark the specified quest as completed and give the player the rewards
        public void CompleteQuest(int questID)
        {
            PlayerQuest playerQuest = Quests.SingleOrDefault(
                pq => pq.ID == questID);

            if (playerQuest != null)
            {
                foreach (var item in playerQuest.Data.RewardItems)
                {
                    AddItemToInventory(item.Data, item.Quantity);
                }
                AddCombatExperience(playerQuest.Data.RewardXP);
                Gold += playerQuest.Data.RewardGold;
                playerQuest.IsComplete = true;
            }
        }
Esempio n. 6
0
        public static Player createplayerformxmlString(string xmlPlayerData)
        {
            try
            {
                XmlDocument playerdata = new XmlDocument();

                playerdata.LoadXml(xmlPlayerData);

                int HP    = Convert.ToInt32(playerdata.SelectSingleNode("/Player/Stats/HP").InnerText);
                int MaxHP = Convert.ToInt32(playerdata.SelectSingleNode("/Player/Stats/MaxHP").InnerText);
                int gold  = Convert.ToInt32(playerdata.SelectSingleNode("/Player/Stats/Gold").InnerText);
                int exp   = Convert.ToInt32(playerdata.SelectSingleNode("/Player/Stats/EXP").InnerText);

                Player player = new Player(HP, MaxHP, 100, gold, exp, 10, 10, 10, 10, 10, 5);

                int currentLocationID = Convert.ToInt32(playerdata.SelectSingleNode("/Player/Stats/CurrentLocation").InnerText);
                player.CurrentLocation = World.LocationByID(currentLocationID);
                if (playerdata.SelectSingleNode(".Player/Stats/CurrentWeapon") != null)
                {
                    int currentWeaponID = Convert.ToInt32(playerdata.SelectSingleNode("/Player/Stats/CurrentWeapon").InnerText);
                    player.CurrentWeapon = (Weapon)World.ItemByID(currentWeaponID);
                }
                foreach (XmlNode node in playerdata.SelectNodes("/Player/Inventory/Inventory"))
                {
                    int id       = Convert.ToInt32(node.Attributes["ID"].Value);
                    int quantity = Convert.ToInt32(node.Attributes["Quantity"].Value);
                    for (int i = 0; i < quantity; i++)
                    {
                        player.additemtoinventor(World.ItemByID(id));
                    }
                }
                foreach (XmlNode node in playerdata.SelectNodes("/Player/PlayerQuest/PlayerQuest"))
                {
                    int  id          = Convert.ToInt32(node.Attributes["ID"].Value);
                    bool iscompleted = Convert.ToBoolean(node.Attributes["IsCompleted"].Value);

                    PlayerQuest playerQuest = new PlayerQuest(World.QuestByID(id));
                    playerQuest.IsCompleted = iscompleted;
                    player.Quest.Add(playerQuest);
                }
                return(player);
            }
            catch
            {
                return(CreateDefaultPlayer());
            }
        }
Esempio n. 7
0
 public static Player CreatePlayerFromXMLString(string xmlPlayerData)
 {
     try
     {
         XmlDocument playerData = new XmlDocument();
         playerData.LoadXml(xmlPlayerData);
         int    currentHitPoints = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/CurrentHitPoints").InnerText);
         int    maxHitPoints     = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/MaximumHitPoints").InnerText);
         int    gold             = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/Gold").InnerText);
         int    expPoints        = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/ExpierencePoints").InnerText);
         Player player           = new Player(currentHitPoints, maxHitPoints, gold, expPoints);
         player.currentLocation = World.locationByID(Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/CurrentLocation").InnerText));
         if (playerData.SelectSingleNode("/Player/Stats/CurrentWeapon") != null)
         {
             int crntWpnID = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/CurrentWeapon").InnerText);
             player.currentWeapon = (Weapon)World.itemByID(crntWpnID);
         }
         foreach (XmlNode node in playerData.SelectNodes("/Player/InventoryItems/InventoryItem"))
         {
             int id       = Convert.ToInt32(node.Attributes["ID"].Value);
             int quantity = Convert.ToInt32(node.Attributes["Quantity"].Value);
             for (int i = 0; i < quantity; i++)
             {
                 player.addItemtoInventory(World.itemByID(id));
             }
         }
         foreach (XmlNode node in playerData.SelectNodes("/Player/PlayerQuests/PlayerQuest"))
         {
             int         id          = Convert.ToInt32(node.Attributes["ID"].Value);
             bool        isCompleted = Convert.ToBoolean(node.Attributes["IsCompleted"].Value);
             PlayerQuest playerQuest = new PlayerQuest(World.questByID(id));
             playerQuest.isCompleted = isCompleted;
             player.quests.Add(playerQuest);
         }
         return(player);
     }
     catch (Exception e)
     {
         System.Diagnostics.Debug.WriteLine("Exception souce: {0}", e);
         Console.WriteLine("Exception souce: {0}", e);
         return(Player.createDefaultPlayer());;
     }
 }
        public static Player CreateFromDataBase()
        {
            try {
                // this is our connection to the data base
                using (NpgsqlConnection connection = new NpgsqlConnection(_connectionString)) {
                    connection.Open();
                    Player player;

                    // create a sql command object that uses the connection to our data base the sql command object is where we
                    // create our sql statement
                    using (NpgsqlCommand savedGameCommand = new NpgsqlCommand("SELECT * FROM SavedGame LIMIT 1", connection))
                        using (NpgsqlDataReader reader = savedGameCommand.ExecuteReader()) {
                            if (!reader.HasRows)
                            {
                                // there is no data in the savegame table so return null no saved player data
                                return(null);
                            }

                            // get the row/record fomr the data reader
                            reader.Read();
                            // get the column value for the row/record
                            int currentHitPoints  = (int)reader["CurrentHitPoints"];
                            int maximumHitPoints  = (int)reader["MaximumHitPoints"];
                            int gold              = (int)reader["Gold"];
                            int experiencePoints  = (int)reader["ExperiencePoints"];
                            int currentLocationID = (int)reader["CurrentLocationID"];
                            // create the player object with the saved game values
                            player = Player.CreatePlayerFromDatabase(
                                currentHitPoints, maximumHitPoints, gold, experiencePoints, currentLocationID);
                        }

                    // read the rows / records from the quest table and add them to the player
                    using (NpgsqlCommand questCommand = new NpgsqlCommand("SELECT * FROM Quest", connection))
                        using (NpgsqlDataReader reader = questCommand.ExecuteReader()) {
                            if (reader.HasRows)
                            {
                                while (reader.Read())
                                {
                                    int  questID     = (int)reader["QuestID"];
                                    bool isCompleted = (bool)reader["IsCompleted"];
                                    //build the PlayerQuest item for this row
                                    PlayerQuest playerQuest =
                                        new PlayerQuest(World.QuestByID(questID));
                                    playerQuest.IsCompleted = isCompleted;
                                    // add the PlayerQuest to the players property
                                    var playerQuestHas = player.Quests.FirstOrDefault(x => x.Details.ID == playerQuest.Details.ID);
                                    if (playerQuestHas != null)
                                    {
                                        playerQuestHas.IsCompleted = isCompleted;
                                    }
                                    else
                                    {
                                        player.Quests.Add(playerQuest);
                                    }
                                }
                            }
                        }

                    //read the rows/ records from the inventory table and add them to the player
                    using (NpgsqlCommand inventoryCommand = new NpgsqlCommand("SELECT * FROM Inventory", connection))
                        using (NpgsqlDataReader reader = inventoryCommand.ExecuteReader()) {
                            if (reader.HasRows)
                            {
                                while (reader.Read())
                                {
                                    int inventoryItemID = (int)reader["InventoryItemID"];
                                    int quantity        = (int)reader["Quantity"];

                                    // add the item to the players inventory
                                    player.AddItemToInventory(World.ItemByID(inventoryItemID), quantity);
                                }
                            }
                        }

                    //now that the player has been build from the database return it
                    return(player);
                }
            } catch (Exception ex) {
                Console.WriteLine(ex);
                //ignore errors if there is an error this function will return a null player
            }

            return(null);
        }
        public static Player CreateFromDatabase()
        {
            try
            {
                // This is the connection to the database
                using (SqlConnection connection = new SqlConnection(_connectionString))
                {
                    // Open the connection to make it possible to perform SQL commands
                    connection.Open();

                    Player player;

                    // Create a SQL command object that uses the connection to the database.
                    // The SqlCommand object is where we create our SQL statement
                    using (SqlCommand savedGameCommand = connection.CreateCommand())
                    {
                        savedGameCommand.CommandType = CommandType.Text;

                        // This SQL statement reads the first rows in the SavedGame table.
                        // For this program, we should only ever have one row, but this will
                        // ensure we only get one record in our SQL query results.
                        savedGameCommand.CommandText = "SELECT TOP 1 * FROM SavedGame";

                        // Use ExecuteReader when you expect the query to return a row, or multiple rows.
                        SqlDataReader reader = savedGameCommand.ExecuteReader();

                        // Check if the query did not return a row/record of data
                        if (!reader.HasRows)
                        {
                            // There is no data in the SavedGame table, so return null (no saved player data)
                            return(null);
                        }

                        // Get the row/record from the data reader
                        reader.Read();

                        // Get the column values for the row/record
                        int currentHitPoints  = (int)reader["CurrentHitPoints"];
                        int maximumHitPoints  = (int)reader["MaximumHitPoints"];
                        int gold              = (int)reader["Gold"];
                        int experiencePoints  = (int)reader["ExperiencePoints"];
                        int currentLocationID = (int)reader["CurrentLocationID"];

                        // Create the Player object, with the saved game values
                        player = Player.CreatePlayerFromDatabase(currentHitPoints, maximumHitPoints, gold, experiencePoints, currentLocationID);
                    }

                    // Read the rows/records from the Quest table and add them to the player's quest list
                    using (SqlCommand questCommand = connection.CreateCommand())
                    {
                        questCommand.CommandType = CommandType.Text;
                        questCommand.CommandText = "SELECT * FROM Quest";

                        SqlDataReader reader = questCommand.ExecuteReader();

                        if (reader.HasRows)
                        {
                            while (reader.Read())
                            {
                                int  questID     = (int)reader["QuestID"];
                                bool isCompleted = (bool)reader["IsCompleted"];

                                // Build the PlayerQuest item for this row
                                PlayerQuest playerQuest = new PlayerQuest(World.QuestByID(questID));
                                playerQuest.IsCompleted = isCompleted;

                                // Add the PlayerQuest to the player's property
                                player.Quests.Add(playerQuest);
                            }
                        }
                    }

                    // Read the rows/records from the Inventory table and add them to the player's inventory
                    using (SqlCommand inventoryCommand = connection.CreateCommand())
                    {
                        inventoryCommand.CommandType = CommandType.Text;
                        inventoryCommand.CommandText = "SELECT * FROM Inventory";

                        SqlDataReader reader = inventoryCommand.ExecuteReader();

                        if (reader.HasRows)
                        {
                            while (reader.Read())
                            {
                                int inventoryItemID = (int)reader["InventoryItemID"];
                                int quantity        = (int)reader["Quantity"];

                                // Add the item to the player's inventory
                                player.AddItemToInventory(World.ItemByID(inventoryItemID), quantity);
                            }
                        }
                    }

                    // Now that the player has been built from the database, return it.
                    return(player);
                }
            }
            catch (Exception ex)
            {
                // Ignore errors. If there is an error, this function will return a "null" player.
            }

            return(null);
        }
Esempio n. 10
0
        public static Player CreateFromDatabase()
        {
            try
            {
                using (NpgsqlConnection connection = new NpgsqlConnection(_connectionString))
                {
                    connection.Open();

                    Player player;

                    using (NpgsqlCommand savedGameCommand = connection.CreateCommand())
                    {
                        savedGameCommand.CommandType = CommandType.Text;
                        // reads the first rows in the SavedGame table.
                        savedGameCommand.CommandText = "SELECT TOP 1 * FROM SavedGame";

                        // Use when you expect the query to return a row, or rows
                        NpgsqlDataReader reader = savedGameCommand.ExecuteReader();

                        // Check if the query did not return a row/record of data
                        if (!reader.HasRows)
                        {
                            return(null);
                        }

                        reader.Read();

                        // Get the column values for the row/record
                        int currentHitPoints  = (int)reader["CurrentHitPoints"];
                        int maximumHitPoints  = (int)reader["MaximumHitPoints"];
                        int gold              = (int)reader["Gold"];
                        int experiencePoints  = (int)reader["ExperiencePoints"];
                        int currentLocationID = (int)reader["CurrentLocationID"];

                        // Create the Player object, with the saved game values
                        player = Player.CreatePlayerFromDatabase(currentHitPoints, maximumHitPoints, gold,
                                                                 experiencePoints, currentLocationID);
                    }

                    // Read the rows/records from the Quest table, and add them to the player
                    using (NpgsqlCommand questCommand = connection.CreateCommand())
                    {
                        questCommand.CommandType = CommandType.Text;
                        questCommand.CommandText = "SELECT * FROM Quest";

                        NpgsqlDataReader reader = questCommand.ExecuteReader();

                        if (reader.HasRows)
                        {
                            while (reader.Read())
                            {
                                int  questID     = (int)reader["QuestID"];
                                bool isCompleted = (bool)reader["IsCompleted"];

                                // Build the PlayerQuest item, for this row
                                PlayerQuest playerQuest = new PlayerQuest(World.QuestByID(questID))
                                {
                                    IsCompleted = isCompleted
                                };

                                player.Quests.Add(playerQuest);
                            }
                        }
                    }

                    using (NpgsqlCommand inventoryCommand = connection.CreateCommand())
                    {
                        inventoryCommand.CommandType = CommandType.Text;
                        inventoryCommand.CommandText = "SELECT * FROM Inventory";

                        NpgsqlDataReader reader = inventoryCommand.ExecuteReader();

                        if (reader.HasRows)
                        {
                            while (reader.Read())
                            {
                                int inventoryItemID = (int)reader["InventoryItemID"];
                                int quantity        = (int)reader["Quantity"];

                                // Add the item to the player's inventory
                                player.AddItemToInventory(World.ItemByID(inventoryItemID), quantity);
                            }
                        }
                    }

                    return(player);
                }
            }
            catch (Exception ex)
            {
                //returns null player...hopefully
            }

            return(null);
        }
Esempio n. 11
0
        public static Player CreateFromDatabase()
        {
            try
            {
                using (SqlConnection connection = new SqlConnection(_connectionString))
                {
                    connection.Open();

                    Player player;

                    using (SqlCommand savedGameCommand = connection.CreateCommand())
                    {
                        savedGameCommand.CommandType = CommandType.Text;
                        savedGameCommand.CommandText = "SELECT TOP 1 * FROM SavedGame";

                        SqlDataReader reader = savedGameCommand.ExecuteReader();

                        if (!reader.HasRows)
                        {
                            return(null);
                        }

                        reader.Read();

                        int currentHitPoints  = (int)reader["CurrentHitPoints"];
                        int maximumHitPoints  = (int)reader["MaximumHitPoints"];
                        int gold              = (int)reader["Gold"];
                        int experiencePoints  = (int)reader["ExperiencePoints"];
                        int currentLocationID = (int)reader["CurrentLocationID"];

                        player = Player.CreatePlayerFromDatabase(currentHitPoints, maximumHitPoints, gold,
                                                                 experiencePoints, currentLocationID);
                    }

                    using (SqlCommand questCommand = connection.CreateCommand())
                    {
                        questCommand.CommandType = CommandType.Text;
                        questCommand.CommandText = "SELECT * FROM Quest";

                        SqlDataReader reader = questCommand.ExecuteReader();

                        if (reader.HasRows)
                        {
                            while (reader.Read())
                            {
                                int  questID     = (int)reader["QuestID"];
                                bool isCompleted = (bool)reader["IsCompleted"];

                                PlayerQuest playerQuest = new PlayerQuest(World.QuestByID(questID));
                                playerQuest.IsCompleted = isCompleted;

                                player.Quests.Add(playerQuest);
                            }
                        }
                    }

                    using (SqlCommand inventoryCommand = connection.CreateCommand())
                    {
                        inventoryCommand.CommandType = CommandType.Text;
                        inventoryCommand.CommandText = "SELECT * FROM Inventory";

                        SqlDataReader reader = inventoryCommand.ExecuteReader();

                        if (reader.HasRows)
                        {
                            while (reader.Read())
                            {
                                int inventoryItemID = (int)reader["InventoryItemID"];
                                int quantity        = (int)reader["Quantity"];

                                player.AddItemToInventory(World.ItemByID(inventoryItemID), quantity);
                            }
                        }
                    }

                    return(player);
                }
            }
            catch (Exception ex)
            {
                //TODO add some basic error handling
            }

            return(null);
        }
        public static Player CreateFromDatabase()
        {
            try
            {
                using (SqlConnection connection = new SqlConnection(_connectionString))
                {
                    connection.Open();

                    Player player;

                    // create sql command object
                    using (SqlCommand savedGameCommand = connection.CreateCommand())
                    {
                        savedGameCommand.CommandType = CommandType.Text;
                        savedGameCommand.CommandText = "SELECT TOP 1 * FROM SavedGame";

                        // execute command and check if data is available
                        using (SqlDataReader reader = savedGameCommand.ExecuteReader())
                        {
                            if (!reader.HasRows)
                            {
                                return(null);
                            }

                            // read data from database and create player
                            reader.Read();

                            int currentHitPoints  = (int)reader["CurrentHitPoints"];
                            int maximumHitPoints  = (int)reader["MaximumHitPoints"];
                            int gold              = (int)reader["Gold"];
                            int experiencePoints  = (int)reader["ExperiencePoints"];
                            int currentLocationID = (int)reader["CurrentLocationID"];

                            player = Player.CreatePlayerFromDatabase(currentHitPoints, maximumHitPoints, gold,
                                                                     experiencePoints, currentLocationID);
                        }
                    }

                    // read quest table
                    using (SqlCommand questCommand = connection.CreateCommand())
                    {
                        questCommand.CommandType = CommandType.Text;
                        questCommand.CommandText = "SELECT * FROM Quest";

                        using (SqlDataReader reader = questCommand.ExecuteReader())
                        {
                            if (reader.HasRows)
                            {
                                while (reader.Read())
                                {
                                    int  questID     = (int)reader["QuestID"];
                                    bool isCompleted = (bool)reader["IsCompleted"];

                                    PlayerQuest playerQuest = new PlayerQuest(World.QuestByID(questID));
                                    playerQuest.IsCompleted = isCompleted;
                                    player.Quests.Add(playerQuest);
                                }
                            }
                        }
                    }

                    // read inventory
                    using (SqlCommand inventoryCommand = connection.CreateCommand())
                    {
                        inventoryCommand.CommandType = CommandType.Text;
                        inventoryCommand.CommandText = "SELECT * FROM Inventory";

                        using (SqlDataReader reader = inventoryCommand.ExecuteReader())
                        {
                            if (reader.HasRows)
                            {
                                while (reader.Read())
                                {
                                    int inventoryItemID = (int)reader["InventoryItemID"];
                                    int quantity        = (int)reader["Quantity"];

                                    player.AddItemToInventory(World.ItemByID(inventoryItemID), quantity);
                                }
                            }
                        }
                    }

                    return(player);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }

            return(null);
        }
Esempio n. 13
0
        public static Player CreatePlayerFromXmlString(string xmlPlayerData)
        {
            try
            {
                XmlDocument playerData = new XmlDocument();

                playerData.LoadXml(xmlPlayerData);

                int currentHitPoints = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/CurrentHitPoints").InnerText);
                int maximumHitPoints = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/MaximumHitPoints").InnerText);
                int gold = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/Gold").InnerText);
                int experiencePoints = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/ExperiencePoints").InnerText);

                Player player = new Player(currentHitPoints, maximumHitPoints, gold, experiencePoints);

                int currentLocationID = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/CurrentLocation").InnerText);
                player.CurrentLocation = World.LocationByID(currentLocationID);

                foreach (XmlNode node in playerData.SelectNodes("/Player/InventoryItems/InventoryItem"))
                {
                    int id = Convert.ToInt32(node.Attributes["ID"].Value);
                    int quantity = Convert.ToInt32(node.Attributes["Quantity"].Value);

                    for (int i = 0; i < quantity; i++)
                    {
                        player.AddItemToInventory(World.ItemByID(id));
                    }
                }

                foreach (XmlNode node in playerData.SelectNodes("/Player/PlayerQuests/PlayerQuest"))
                {
                    int id = Convert.ToInt32(node.Attributes["ID"].Value);
                    bool isCompleted = Convert.ToBoolean(node.Attributes["IsCompleted"].Value);

                    PlayerQuest playerQuest = new PlayerQuest(World.QuestByID(id));
                    playerQuest.IsCompleted = isCompleted;

                    player.Quests.Add(playerQuest);
                }

                return player;
            }
            catch
            {
                // If there was an error with the XML data, return a default player object
                return Player.CreateDefaultPlayer();
            }
        }
        public static Player CreateFromDataBase()
        {
            try
            {
                using (SqlConnection connection = new SqlConnection(_connectionString))
                {
                    connection.Open();

                    Player player;

                    using (SqlCommand savedGameCommand = connection.CreateCommand())
                    {
                        savedGameCommand.CommandType = CommandType.Text;
                        savedGameCommand.CommandText = "SELECT TOP 1 * FROM SavedGame";

                        SqlDataReader reader = savedGameCommand.ExecuteReader();

                        if (!reader.HasRows)
                        {
                            return(null);
                        }
                        reader.Read();

                        int HP                = (int)reader["HP"];
                        int MaxHP             = (int)reader["MaxHP"];
                        int gold              = (int)reader["Gold"];
                        int EXP               = (int)reader["EXP"];
                        int CurrentLocationID = (int)reader["CurrentLocationID"];

                        player = Player.CreatePlayerfromDatabase(HP, MaxHP, gold, EXP, CurrentLocationID);
                    }
                    using (SqlCommand questCommand = connection.CreateCommand())
                    {
                        questCommand.CommandType = CommandType.Text;
                        questCommand.CommandText = "SELECT * FROM Quest";

                        SqlDataReader reader = questCommand.ExecuteReader();

                        if (reader.HasRows)
                        {
                            while (reader.Read())
                            {
                                int  questID     = (int)reader["QuestID"];
                                bool isCompleted = (bool)reader["IsCompleted"];

                                PlayerQuest playerQuest = new PlayerQuest(World.QuestByID(questID));
                                playerQuest.IsCompleted = isCompleted;

                                player.Quest.Add(playerQuest);
                            }
                        }
                    }
                    using (SqlCommand inventoryCommand = connection.CreateCommand())
                    {
                        inventoryCommand.CommandType = CommandType.Text;
                        inventoryCommand.CommandText = "SELECT * FROM Inventory";

                        SqlDataReader reader = inventoryCommand.ExecuteReader();
                        if (reader.HasRows)
                        {
                            while (reader.Read())
                            {
                                int inventoryItemID = (int)reader["InventoryItemID"];
                                int quantity        = (int)reader["Quantity"];
                                player.additemtoinventor(World.ItemByID(inventoryItemID), quantity);
                            }
                        }
                    }
                    return(player);
                }
            }
#pragma warning disable CS0168 // Variable is declared but never used
            catch (Exception ex)
#pragma warning restore CS0168 // Variable is declared but never used
            {
            }
            return(null);
        }
Esempio n. 15
0
        public static Player LoadPlayerInformationFromXml(string xmlPlayerData)
        {
            Player player;

            try
            {
                XmlDocument playerData = new XmlDocument();
                playerData.LoadXml(xmlPlayerData);

                int    currentHitPoints = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/CurrentHitPoints").InnerText);
                int    maximumHitPoints = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/MaximumHitPoints").InnerText);
                int    gold             = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/Gold").InnerText);
                int    experiencePoints = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/ExperiencePoints").InnerText);
                int    level            = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/Level").InnerText);
                int    strength         = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/Strength").InnerText);
                int    dexterity        = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/Dexterity").InnerText);
                int    intelligent      = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/Intelligent").InnerText);
                int    currentMana      = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/CurrentMana").InnerText);
                int    maximumMana      = Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/MaximumMana").InnerText);
                Race   race             = World.RaceByID(Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/Race").InnerText));
                Armour armourUsed       = null;
                if (Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/ArmourUsed").InnerText) != 0)
                {
                    armourUsed = (Armour)World.ItemByID(Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/ArmourUsed").InnerText));
                }
                player = new Player(currentHitPoints, maximumHitPoints, gold, experiencePoints, level, strength, dexterity, intelligent, currentMana, maximumMana, race, armourUsed);
                player.CurrentLocation = World.LocationByID(Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/CurrentLocation").InnerText));
                if (Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/CurrentWeapon").InnerText) != 0)
                {
                    player.CurrentWeapon = (Weapon)World.ItemByID(Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/CurrentWeapon").InnerText));
                }
                else
                {
                    player.CurrentWeapon = null;
                }

                if (Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/CurrentPotion").InnerText) != 0)
                {
                    player.CurrentPotion = (HealingPotion)World.ItemByID(Convert.ToInt32(playerData.SelectSingleNode("/Player/Stats/CurrentPotion").InnerText));
                }
                else
                {
                    player.CurrentPotion = null;
                }
                foreach (XmlNode node in playerData.SelectNodes("/Player/InventoryItems/InventoryItem"))
                {
                    player.AddItem(World.ItemByID(Convert.ToInt32(node.Attributes["ID"].Value)), Convert.ToInt32(node.Attributes["Quantity"].Value));
                }

                foreach (XmlNode node in playerData.SelectNodes("/Player/PlayerQuests/PlayerQuest"))
                {
                    PlayerQuest playerQuest = new PlayerQuest(World.QuestByID(Convert.ToInt32(node.Attributes["ID"].Value)));
                    playerQuest.IsCompleted = Convert.ToBoolean(node.Attributes["IsCompleted"].Value);
                    player.Quests.Add(playerQuest);
                }
            }
            catch
            {
                player = new Player(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, World.RaceByID(World.RACE_ID_HUNMAN));
            }
            return(player);
        }
Esempio n. 16
0
        public static Player CreateFromDatabase()
        {
            try
            {
                //Connect to database
                using (SqlConnection connection = new SqlConnection(_connectionString))
                {
                    //Open connection
                    connection.Open();

                    Player player;

                    using (SqlCommand savedGameCommand = connection.CreateCommand())
                    {
                        savedGameCommand.CommandType = CommandType.Text;

                        savedGameCommand.CommandText = "SELECT TOP 1 * FROM SavedGame";

                        SqlDataReader reader = savedGameCommand.ExecuteReader();

                        //Check if the query did not return a row/record of data
                        if (!reader.HasRows)
                        {
                            //There is no data in SavedGame table. so return null
                            return(null);
                        }
                        //Get record from data reader
                        reader.Read();

                        //Get column values for the record
                        int currentHitPoints  = (int)reader["CurrentHitPoints"];
                        int maximumHitPoints  = (int)reader["MaximumHitPoints"];
                        int gold              = (int)reader["Gold"];
                        int experiencePoints  = (int)reader["ExperiencePoints"];
                        int currentLocationID = (int)reader["CurrentLocationID"];

                        //Create the Player object, with the saved games values
                        player = Player.CreatePlayerFromDatabase(currentHitPoints, maximumHitPoints, gold, experiencePoints, currentLocationID);
                    }

                    //Read records from Quest table, and add them to player
                    using (SqlCommand questCommand = connection.CreateCommand())
                    {
                        questCommand.CommandType = CommandType.Text;
                        questCommand.CommandText = "SELECT * FROM Quest";

                        SqlDataReader reader = questCommand.ExecuteReader();

                        if (reader.HasRows)
                        {
                            while (reader.Read())
                            {
                                int  questID     = (int)reader["QuestID"];
                                bool isCompleted = (bool)reader["IsCompleted"];

                                //Build the PlayerQuest item, for this row
                                PlayerQuest playerQuest = new PlayerQuest(World.QuestByID(questID));
                                playerQuest.IsCompleted = isCompleted;

                                //Add the PlayerQuest to inventory
                                player.Quests.Add(playerQuest);
                            }
                        }
                    }

                    using (SqlCommand inventoryCommand = connection.CreateCommand())
                    {
                        inventoryCommand.CommandType = CommandType.Text;
                        inventoryCommand.CommandText = "SELECT * FROM Inventory";

                        SqlDataReader reader = inventoryCommand.ExecuteReader();

                        if (reader.HasRows)
                        {
                            while (reader.Read())
                            {
                                int inventoryItemID = (int)reader["InventoryItemID"];
                                int quantity        = (int)reader["Quantity"];

                                //Add item to inventory
                                player.AddItemToInventory(World.ItemByID(inventoryItemID), quantity);
                            }
                        }
                    }

                    //Now the player has been built from the database, return it.
                    return(player);
                }
            }
            catch (Exception ex)
            {
                //Ignore error. If there is an error, it will return "null" player.
            }

            return(null);
        }
        public static Player CreatePlayerFromXmlString(string xmlPlayerData)
        {
            try
            {
                XmlDocument playerData = new XmlDocument();

                //  playerData.PreserveWhitespace = true;
                playerData.LoadXml(xmlPlayerData);

                int currentHitPoints = Convert.ToInt32(
                    playerData.SelectSingleNode("/Player/Stats/CurrentHitPoints").InnerText);
                int maximumHitPoints = Convert.ToInt32(
                    playerData.SelectSingleNode("/Player/Stats/MaximumHitPoints").InnerText);
                int gold = Convert.ToInt32(
                    playerData.SelectSingleNode("/Player/Stats/Gold").InnerText);
                int experiencePoints = Convert.ToInt32(
                    playerData.SelectSingleNode("/Player/Stats/ExperiencePoints").InnerText);

                Player player = new Player(
                    currentHitPoints, maximumHitPoints, gold, experiencePoints);

                int currentLocationID = Convert.ToInt32(
                    playerData.SelectSingleNode("/Player/Stats/CurrentLocation").InnerText);
                player.CurrentLocation = World.LocationByID(currentLocationID);

                if (playerData.SelectSingleNode("/Player/Stats/CurrentWeaponID") != null)
                {
                    int currentWeaponID = Convert.ToInt32(playerData.SelectSingleNode(
                                                              "/Player/Stats/CurrentWeaponID").InnerText);
                    player.CurrentWeapon = (Weapon)World.ItemByID(currentWeaponID);
                }

                if (playerData.SelectSingleNode("/Player/Stats/CurrentPotionID") != null)
                {
                    int currentPotionID = Convert.ToInt32(playerData.SelectSingleNode(
                                                              "/Player/Stats/CurrentPotionID").InnerText);
                    player.CurrentPotion = (HealingPotion)World.ItemByID(currentPotionID);
                }

                foreach (XmlNode node in playerData.SelectNodes(
                             "/Player/InventoryItems/InventoryItem"))
                {
                    int itemID       = Convert.ToInt32(node.Attributes["ID"].Value);
                    int itemQuantity = Convert.ToInt32(node.Attributes["Quantity"].Value);

                    // refactored from tutorial due to overloading AddItemToInventory with quantity
                    player.AddItemToInventory(World.ItemByID(itemID), itemQuantity);
                }

                foreach (XmlNode node in playerData.SelectNodes(
                             "/Player/PlayerQuests/PlayerQuest"))
                {
                    int  questID          = Convert.ToInt32(node.Attributes["ID"].Value);
                    bool questIsCompleted = Convert.ToBoolean(node.Attributes["IsCompleted"].Value);

                    PlayerQuest playerQuest = new PlayerQuest(World.QuestByID(questID));
                    playerQuest.IsCompleted = questIsCompleted;

                    player.Quests.Add(playerQuest);
                }

                return(player);
            }
            catch
            {
                // If there was an error with the XML data, return a default player object
                return(Player.CreateDefaultPlayer());
            }
        }