ACR_ServerCommunicator.GameWorldManager.ReferencePlayerById C# (CSharp) Method

ReferencePlayerById() public method

Reference the data for a player by the player id. If the data was not yet available, it is retrieved from the database.
public ReferencePlayerById ( int PlayerId, IALFADatabase Database ) : ACR_ServerCommunicator.GamePlayer
PlayerId int Supplies the object id.
Database IALFADatabase Supplies the database connection to use for /// queries, if required. The active rowset may be consumed.
return ACR_ServerCommunicator.GamePlayer
        public GamePlayer ReferencePlayerById(int PlayerId, IALFADatabase Database)
        {
            //
            // Check if the object is already known first.
            //

            GamePlayer Player = (from P in Players
                                 where P.PlayerId == PlayerId
                                 select P).FirstOrDefault();

            if (Player != null)
                return Player;

            //
            // Need to pull the data from the database.
            //

            if (Database == null)
                return null;

            Database.ACR_SQLQuery(String.Format(
                "SELECT `Name`, `IsDM` FROM `players` WHERE `ID` = {0}",
                PlayerId));

            if (!Database.ACR_SQLFetch())
                return null;

            Player = new GamePlayer(this);

            Player.PlayerName = Database.ACR_SQLGetData(0);
            Player.PlayerId = PlayerId;
            Player.IsDM = ConvertToBoolean(Database.ACR_SQLGetData(1));

            InsertNewPlayer(Player, Database);

            return Player;
        }