BF2Statistics.Database.GamespyDatabase.GetPlayerId C# (CSharp) Method

GetPlayerId() public method

Fetches a Gamespy Account id from an account name
public GetPlayerId ( string Nick ) : int
Nick string
return int
        public int GetPlayerId(string Nick)
        {
            var Rows = base.Query("SELECT id FROM accounts WHERE name=@P0", Nick);
            return (Rows.Count == 0) ? 0 : Int32.Parse(Rows[0]["id"].ToString());
        }

Usage Example

        /// <summary>
        /// This is the primary method for fetching an accounts BF2 PID
        /// </summary>
        /// <param name="recvData"></param>
        private void SendCheck(Dictionary<string, string> recvData)
        {
            // Make sure we have the needed data
            if (!recvData.ContainsKey("nick"))
            {
                Stream.SendAsync(@"\error\\err\0\fatal\\errmsg\Invalid Query!\id\1\final\");
                return;
            }

            // Try to get user data from database
            try
            {
                using (GamespyDatabase Db = new GamespyDatabase())
                {
                    int pid = Db.GetPlayerId(recvData["nick"]);
                    if(pid == 0)
                        Stream.SendAsync(@"\error\\err\265\fatal\\errmsg\Username [{0}] doesn't exist!\id\1\final\", recvData["nick"]);
                    else
                        Stream.SendAsync(@"\cur\0\pid\{0}\final\", pid);
                }
            }
            catch
            {
                Stream.SendAsync(@"\error\\err\265\fatal\\errmsg\Database service is Offline!\id\1\final\");
            }
        }