bug unique-points-logger-pservercms need fix it

[M@hmoud]

i use unique-points-logger-pservercms but add point to some player and not add point for ather player
player in guild no take point but player no have guild take point why
i need fix it and add all point for all player



declare @ varchar(max) = (select CharName from SRO_VT_ACCOUNT..srZor_uniques where id=(select max (id) from SRO_VT_ACCOUNT..srZor_uniques))
declare @ed varchar(max) = (select mobname from SRO_VT_ACCOUNT..srZor_uniques where id=(select max (id) from SRO_VT_ACCOUNT..srZor_uniques))
declare @arid int = (select charid from SRO_VT_SHARD.._char where charname16 @)
declare @id int = (select id from SRO_VT_SHARD.._refobjcommon where codename128 = @ed and service =1 )
DECLARE @int int =(Select points From SRO_VT_SHARD.dbo._UniqueRanking Where CharID = @arid )
DECLARE @ldid int =(Select GuildID From SRO_VT_SHARD.._char Where CharID = @arid )
DECLARE @ldname varchar(max) =(Select Name From SRO_VT_SHARD.dbo._Guild Where ID = @ldid )

if @d in (4,6,9,11,10) AND (select count(*)from SRO_VT_ACCOUNT..srZor_uniques ) > 0
begin
declare @Point int = 0
-- this is unique points logger for pservercms by mixawy
if @id = 14936 begin-- Ivy ----Normal Uniques
SET @Point = 5 END
if @id = 1954 begin --Tiger
SET @Point = 5 END
if @id = 5871 begin --Kerberos
SET @Point = 5 END
if @id = 2002 begin --Isyutaru
SET @Point = 5 END
if @id = 1982 begin --Uruchi
SET @Point = 5 END
if @id = 3875 begin --Demon
SET @Point = 5 END
if @id = 3810 begin --Lord
SET @Point = 5 END
if @id = 414231 begin-- Baal ----Strong Uniques
SET @Point = 10 END
if @id = 414221 begin-- Babilion
SET @Point = 10 END
if @id = 414201 begin --Zielkiaxe 1
SET @Point = 10 END
if @id = 414211 begin --Zielkiaxe 2
SET @Point = 10 END
if @id = 414161 begin --The Earth 1
SET @Point = 10 END
if @id = 414171 begin --The Earth 2
SET @Point = 10 END
if @id = 414191 begin --Jupiter
SET @Point = 10 END
if @id = 414181 begin --Yuno
SET @Point = 10 END
if @id = 468531 begin-- Giant Overlord
SET @Point = 10 END
if @id = 475721 begin-- Harrison
SET @Point = 10 END
if @id = 468551 begin --Dinosaur
SET @Point = 10 END
if @id = 468511 begin --Abshad Force
SET @Point = 10 END
if @id = 468541 begin --Genie
SET @Point = 10 END
if @id = 468501 begin --Thief Boss
SET @Point = 10 END
if @id = 475731 begin --Venefica
SET @Point = 10 END
if @id = 475741 begin --Demon Vene
SET @Point = 10 END
if @id = 462061 begin --Death Bone
SET @Point = 10 END
if @id = 10000004 begin --King Of Tremor
SET @Point = 10 END
if @id = 44025 begin --Arabian Shitan
SET @Point = 10 END
if @id = 28819 begin --White Knight
SET @Point = 10 END
if @id = 38211 begin --Selket
SET @Point = 30 END
if @id = 38212 begin --Neith
SET @Point = 30 END
if @id = 38213 begin --Anubis
SET @Point = 30 END
if @id = 38214 begin --Isis
SET @Point = 30 END
if @id = 14997 begin --Medusa --big uniques
SET @Point = 50 END

/* insert */
if @Point >0 and @ldid >0 and (not exists (select charid from SRO_VT_SHARD.._UniqueRanking where CharID = @arid) ) begin
insert into SRO_VT_SHARD.._UniqueRanking (CharID,CodeName128,points) values @arid @ldname @Point)
end
else if @Point >0 and @ldid =0 and (not exists (select charid from SRO_VT_SHARD.._UniqueRanking where CharID = @arid) ) begin
insert into SRO_VT_SHARD.._UniqueRanking (CharID,CodeName128,points) values @arid,0 @Point)
end

/* update */
else if @ldid >0 and (exists (select charid from SRO_VT_SHARD.._UniqueRanking where CharID = @arid)) begin
UPDATE SRO_VT_SHARD.dbo._UniqueRanking SET CodeName128 = @ldname Where CharID = @arid
end
else if @Point >0 and (exists (select charid from SRO_VT_SHARD.._UniqueRanking where CharID = @arid)) begin
UPDATE SRO_VT_SHARD.dbo._UniqueRanking SET points = @int @Point Where CharID = @arid
end

/* uniquekilllist & clean */
insert into SRO_VT_SHARD.._UniqueKillList (CharID,CodeName128,time) VALUES @arid @ed,Getdate())
delete from SRO_VT_ACCOUNT..srZor_uniques where id=(select max (id) from SRO_VT_ACCOUNT..srZor_uniques)
end