Junior Spellweaver
- Joined
- Jan 18, 2011
- Messages
- 113
- Reaction score
- 25
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
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..
Attachments
You must be registered for see attachments list