예제 #1
0
        public String ReturnLogin(MsSql mssql)
        {
            String ReturnString = "00000000";

            try
            {
                if ((Boolean)e.Client.ID.VarPool["CheckPassword"])
                {
                    mssql.CommandString = String.Format("SELECT id, Mail, Photo FROM Account WHERE Mail='{0}' AND Password='******';", e.Client.ID.VarPool["account"].ToString(), e.Client.ID.VarPool["password"].ToString());
                }
                else
                {
                    mssql.CommandString = String.Format("SELECT id, Mail, Photo FROM Account WHERE Mail='{0}';", e.Client.ID.VarPool["account"].ToString());
                }
                if (!mssql.MsSelect(new string[] { "id", "Mail", "Photo" }, e.Client.ID.VarPool))
                {
                    ReturnString = mssql.ErrorCode;
                }
                //String id = MsSql.VarPool["id"].ToString();
                //String Mail = MsSql.VarPool["Mail"].ToString();
                //String Photo = Game.Network.Coder.BytesToHex((Byte[])MsSql.VarPool["Photo"]);
            }
            catch (Exception ex)
            {
                ReturnString = Convert.ToString(ex.GetHashCode());
            }
            return(ReturnString);
        }