Hi epvp, i have a problem with check race char by UniqueID
i write store procdure to check race
ALTER PROCEDURE [dbo].[_GetRaceByUniqueID]
@[Only registered and activated users can see links. Click Here To Register...]ID bigint
AS
DECLARE @[Only registered and activated users can see links. Click Here To Register...] INT
BEGIN
IF EXISTS( SELECT RefObjID
FROM SRO_VT_SHARD.._Char C
INNER JOIN _LogPlayers LP
ON C.CharName16 = LP.CharName16
COLLATE SQL_Latin1_General_CP1_CI_AS
WHERE UniqueID = @[Only registered and activated users can see links. Click Here To Register...]ID AND RefObjID < 1933)
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 1 //CH
END
ELSE
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 0 //EU
END
END
SELECT @[Only registered and activated users can see links. Click Here To Register...]
If char is CH it return 1 else return 0
it work onl DB but when i call it in program
uint TargetID = _pck.ReadUInt32(); //return values 3xxxxx
SqlDataReader reader = sqlCon.Return("[" + FilterMain.SUP_DB + "].[dbo].[_GetRaceByUniqueID]", new SqlParameter( @[Only registered and activated users can see links. Click Here To Register...]ID", TargetID));
reader.Read();
int isAsi = reader.GetInt32(0);
it not work at reader.Read(); . I don't know why it not work, please help me!
i write store procdure to check race
ALTER PROCEDURE [dbo].[_GetRaceByUniqueID]
@[Only registered and activated users can see links. Click Here To Register...]ID bigint
AS
DECLARE @[Only registered and activated users can see links. Click Here To Register...] INT
BEGIN
IF EXISTS( SELECT RefObjID
FROM SRO_VT_SHARD.._Char C
INNER JOIN _LogPlayers LP
ON C.CharName16 = LP.CharName16
COLLATE SQL_Latin1_General_CP1_CI_AS
WHERE UniqueID = @[Only registered and activated users can see links. Click Here To Register...]ID AND RefObjID < 1933)
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 1 //CH
END
ELSE
BEGIN
SET @[Only registered and activated users can see links. Click Here To Register...] = 0 //EU
END
END
SELECT @[Only registered and activated users can see links. Click Here To Register...]
If char is CH it return 1 else return 0
it work onl DB but when i call it in program
uint TargetID = _pck.ReadUInt32(); //return values 3xxxxx
SqlDataReader reader = sqlCon.Return("[" + FilterMain.SUP_DB + "].[dbo].[_GetRaceByUniqueID]", new SqlParameter( @[Only registered and activated users can see links. Click Here To Register...]ID", TargetID));
reader.Read();
int isAsi = reader.GetInt32(0);
it not work at reader.Read(); . I don't know why it not work, please help me!