Problem with check race char

09/22/2017 13:36 athena1410#1
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!
09/23/2017 03:41 sigel123456789#2
maybe that tut help u
09/23/2017 08:51 athena1410#3
Quote:
Originally Posted by sigel123456789 View Post
maybe that tut help u
no, i have problem with check char race in filter not DB.