Problem with check race char

[athena1410]

Hi epvp, i have a problem with check race char by UniqueID
i write store procdure to check race
ALTER PROCEDURE [dbo].[_GetRaceByUniqueID]
@ID bigint

AS
DECLARE @ 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 = @ID AND RefObjID < 1933)
BEGIN
SET @ = 1 //CH
END
ELSE
BEGIN
SET @ = 0 //EU
END
END
SELECT @

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( @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!

[sigel123456789]

maybe that tut help u

 Spoiler

https://www.elitepvpers.com/forum/sro-pserver-guides-releases/4353475-scroll-change-you-race-100-perfect-simple.html

[athena1410]

Originally Posted by sigel123456789

maybe that tut help u

 Spoiler

https://www.elitepvpers.com/forum/sro-pserver-guides-releases/4353475-scroll-change-you-race-100-perfect-simple.html

no, i have problem with check char race in filter not DB.