Ive searched other threads and found no anser so i'll post it here
i used that code to try and update my nickname in game and it wont stay also in my info my login id apears in lower case is there anyway to correct this i'll attach pics below as soon as i log out my nickname reverds back to my login id also my login ID is displayed under my info page in lower case any way to remove it from being Shown..Code:USE [Pangya_S4_TH] GO /****** Object: StoredProcedure [dbo].[USP_NICKNAME_UPDATE] Script Date: 02/01/2011 22:12:36 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[USP_NICKNAME_UPDATE] @x int, @y varchar(20) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; DECLARE @Occupied INT EXEC @Occupied = [dbo].[USP_NICKNAME_CHECK] @y IF @Occupied = 0 BEGIN UPDATE Pangya_Member_Info SET NickName = @y WHERE userid = @x SELECT 0 END ELSE BEGIN SELECT 1 END END






