[M@hmoud]

عندى مشكله فى رينك اليونيك ساعات بيضيف نقط للبلاير وساعات مش بيضيف وبيضيف لناس وناس لا يا ريت لو حد عنده حل يقولى عليه
انا لاحظت ان ناس اللى فى جيلد مش بتاخد نقط واللى من غير جيلد هوا اللى بياخد
انا شغال برينك بتاع ميكساوى هوا دا

declare @killer varchar(max) = (select CharName from SRO_VT_ACCOUNT..srZor_uniques where id=(select max (id) from SRO_VT_ACCOUNT..srZor_uniques))
declare @uniquekilled varchar(max) = (select mobname from SRO_VT_ACCOUNT..srZor_uniques where id=(select max (id) from SRO_VT_ACCOUNT..srZor_uniques))
declare @killercharid int = (select charid from SRO_VT_SHARD.._char where charname16=@killer)
declare @uniqueid int = (select id from SRO_VT_SHARD.._refobjcommon where codename128 = @uniquekilled and service =1 )
DECLARE @killerPoint int =(Select points From SRO_VT_SHARD.dbo._UniqueRanking Where CharID = @killercharid )
DECLARE @killerguildid  int =(Select GuildID From SRO_VT_SHARD.._char Where CharID = @killercharid )
DECLARE @killerguildname varchar(max) =(Select Name From SRO_VT_SHARD.dbo._Guild Where ID = @killerguildid  )

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

/*  insert */
if @uniquePoint >0 and @killerguildid >0 and (not exists (select charid from SRO_VT_SHARD.._UniqueRanking where CharID = @killercharid) ) begin
insert into SRO_VT_SHARD.._UniqueRanking (CharID,CodeName128,points) values (@killercharid,@killerguildname,@uniquePoint) 
end
else if @uniquePoint >0 and @killerguildid =0 and (not exists (select charid from SRO_VT_SHARD.._UniqueRanking where CharID = @killercharid) ) begin
insert into SRO_VT_SHARD.._UniqueRanking (CharID,CodeName128,points) values (@killercharid,0,@uniquePoint) 
end

/*  update */
else if @killerguildid >0 and (exists (select charid from SRO_VT_SHARD.._UniqueRanking where CharID = @killercharid)) begin
UPDATE SRO_VT_SHARD.dbo._UniqueRanking SET CodeName128 = @killerguildname Where CharID = @killercharid 
end
else if @uniquePoint >0 and (exists (select charid from SRO_VT_SHARD.._UniqueRanking where CharID = @killercharid)) begin
UPDATE SRO_VT_SHARD.dbo._UniqueRanking SET points = @killerPoint +@uniquePoint Where CharID = @killercharid 
end

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