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
[Only registered and activated users can see links. Click Here To Register...]
declare @[Only registered and activated users can see links. Click Here To Register...] varchar(max) = (select CharName from SRO_VT_ACCOUNT..srZor_uniques where id=(select max (id) from SRO_VT_ACCOUNT..srZor_uniques))
declare @[Only registered and activated users can see links. Click Here To Register...]ed varchar(max) = (select mobname from SRO_VT_ACCOUNT..srZor_uniques where id=(select max (id) from SRO_VT_ACCOUNT..srZor_uniques))
declare @[Only registered and activated users can see links. Click Here To Register...]arid int = (select charid from SRO_VT_SHARD.._char where charname16 @[Only registered and activated users can see links. Click Here To Register...])
declare @[Only registered and activated users can see links. Click Here To Register...]id int = (select id from SRO_VT_SHARD.._refobjcommon where codename128 = @[Only registered and activated users can see links. Click Here To Register...]ed and service =1 )
DECLARE @[Only registered and activated users can see links. Click Here To Register...]int int =(Select points From SRO_VT_SHARD.dbo._UniqueRanking Where CharID = @[Only registered and activated users can see links. Click Here To Register...]arid )
DECLARE @[Only registered and activated users can see links. Click Here To Register...]ldid int =(Select GuildID From SRO_VT_SHARD.._char Where CharID = @[Only registered and activated users can see links. Click Here To Register...]arid )
DECLARE @[Only registered and activated users can see links. Click Here To Register...]ldname varchar(max) =(Select Name From SRO_VT_SHARD.dbo._Guild Where ID = @[Only registered and activated users can see links. Click Here To Register...]ldid )
if @[Only registered and activated users can see links. Click Here To Register...]d in (4,6,9,11,10) AND (select count(*)from SRO_VT_ACCOUNT..srZor_uniques ) > 0
begin
declare @[Only registered and activated users can see links. Click Here To Register...]Point int = 0
-- this is unique points logger for pservercms by mixawy
if @[Only registered and activated users can see links. Click Here To Register...]id = 14936 begin-- Ivy ----Normal Uniques
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 5 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 1954 begin --Tiger
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 5 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 5871 begin --Kerberos
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 5 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 2002 begin --Isyutaru
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 5 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 1982 begin --Uruchi
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 5 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 3875 begin --Demon
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 5 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 3810 begin --Lord
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 5 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 414231 begin-- Baal ----Strong Uniques
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 414221 begin-- Babilion
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 414201 begin --Zielkiaxe 1
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 414211 begin --Zielkiaxe 2
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 414161 begin --The Earth 1
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 414171 begin --The Earth 2
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 414191 begin --Jupiter
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 414181 begin --Yuno
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 468531 begin-- Giant Overlord
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 475721 begin-- Harrison
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 468551 begin --Dinosaur
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 468511 begin --Abshad Force
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 468541 begin --Genie
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 468501 begin --Thief Boss
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 475731 begin --Venefica
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 475741 begin --Demon Vene
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 462061 begin --Death Bone
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 10000004 begin --King Of Tremor
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 44025 begin --Arabian Shitan
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 28819 begin --White Knight
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 38211 begin --Selket
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 30 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 38212 begin --Neith
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 30 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 38213 begin --Anubis
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 30 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 38214 begin --Isis
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 30 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 14997 begin --Medusa --big uniques
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 50 END
/* insert */
if @[Only registered and activated users can see links. Click Here To Register...]Point >0 and @[Only registered and activated users can see links. Click Here To Register...]ldid >0 and (not exists (select charid from SRO_VT_SHARD.._UniqueRanking where CharID = @[Only registered and activated users can see links. Click Here To Register...]arid) ) begin
insert into SRO_VT_SHARD.._UniqueRanking (CharID,CodeName128,points) values @[Only registered and activated users can see links. Click Here To Register...]arid @[Only registered and activated users can see links. Click Here To Register...]ldname @[Only registered and activated users can see links. Click Here To Register...]Point)
end
else if @[Only registered and activated users can see links. Click Here To Register...]Point >0 and @[Only registered and activated users can see links. Click Here To Register...]ldid =0 and (not exists (select charid from SRO_VT_SHARD.._UniqueRanking where CharID = @[Only registered and activated users can see links. Click Here To Register...]arid) ) begin
insert into SRO_VT_SHARD.._UniqueRanking (CharID,CodeName128,points) values @[Only registered and activated users can see links. Click Here To Register...]arid,0 @[Only registered and activated users can see links. Click Here To Register...]Point)
end
/* update */
else if @[Only registered and activated users can see links. Click Here To Register...]ldid >0 and (exists (select charid from SRO_VT_SHARD.._UniqueRanking where CharID = @[Only registered and activated users can see links. Click Here To Register...]arid)) begin
UPDATE SRO_VT_SHARD.dbo._UniqueRanking SET CodeName128 = @[Only registered and activated users can see links. Click Here To Register...]ldname Where CharID = @[Only registered and activated users can see links. Click Here To Register...]arid
end
else if @[Only registered and activated users can see links. Click Here To Register...]Point >0 and (exists (select charid from SRO_VT_SHARD.._UniqueRanking where CharID = @[Only registered and activated users can see links. Click Here To Register...]arid)) begin
UPDATE SRO_VT_SHARD.dbo._UniqueRanking SET points = @[Only registered and activated users can see links. Click Here To Register...]int @[Only registered and activated users can see links. Click Here To Register...]Point Where CharID = @[Only registered and activated users can see links. Click Here To Register...]arid
end
/* uniquekilllist & clean */
insert into SRO_VT_SHARD.._UniqueKillList (CharID,CodeName128,time) VALUES @[Only registered and activated users can see links. Click Here To Register...]arid @[Only registered and activated users can see links. Click Here To Register...]ed,Getdate())
delete from SRO_VT_ACCOUNT..srZor_uniques where id=(select max (id) from SRO_VT_ACCOUNT..srZor_uniques)
end
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
[Only registered and activated users can see links. Click Here To Register...]
declare @[Only registered and activated users can see links. Click Here To Register...] varchar(max) = (select CharName from SRO_VT_ACCOUNT..srZor_uniques where id=(select max (id) from SRO_VT_ACCOUNT..srZor_uniques))
declare @[Only registered and activated users can see links. Click Here To Register...]ed varchar(max) = (select mobname from SRO_VT_ACCOUNT..srZor_uniques where id=(select max (id) from SRO_VT_ACCOUNT..srZor_uniques))
declare @[Only registered and activated users can see links. Click Here To Register...]arid int = (select charid from SRO_VT_SHARD.._char where charname16 @[Only registered and activated users can see links. Click Here To Register...])
declare @[Only registered and activated users can see links. Click Here To Register...]id int = (select id from SRO_VT_SHARD.._refobjcommon where codename128 = @[Only registered and activated users can see links. Click Here To Register...]ed and service =1 )
DECLARE @[Only registered and activated users can see links. Click Here To Register...]int int =(Select points From SRO_VT_SHARD.dbo._UniqueRanking Where CharID = @[Only registered and activated users can see links. Click Here To Register...]arid )
DECLARE @[Only registered and activated users can see links. Click Here To Register...]ldid int =(Select GuildID From SRO_VT_SHARD.._char Where CharID = @[Only registered and activated users can see links. Click Here To Register...]arid )
DECLARE @[Only registered and activated users can see links. Click Here To Register...]ldname varchar(max) =(Select Name From SRO_VT_SHARD.dbo._Guild Where ID = @[Only registered and activated users can see links. Click Here To Register...]ldid )
if @[Only registered and activated users can see links. Click Here To Register...]d in (4,6,9,11,10) AND (select count(*)from SRO_VT_ACCOUNT..srZor_uniques ) > 0
begin
declare @[Only registered and activated users can see links. Click Here To Register...]Point int = 0
-- this is unique points logger for pservercms by mixawy
if @[Only registered and activated users can see links. Click Here To Register...]id = 14936 begin-- Ivy ----Normal Uniques
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 5 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 1954 begin --Tiger
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 5 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 5871 begin --Kerberos
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 5 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 2002 begin --Isyutaru
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 5 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 1982 begin --Uruchi
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 5 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 3875 begin --Demon
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 5 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 3810 begin --Lord
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 5 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 414231 begin-- Baal ----Strong Uniques
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 414221 begin-- Babilion
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 414201 begin --Zielkiaxe 1
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 414211 begin --Zielkiaxe 2
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 414161 begin --The Earth 1
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 414171 begin --The Earth 2
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 414191 begin --Jupiter
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 414181 begin --Yuno
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 468531 begin-- Giant Overlord
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 475721 begin-- Harrison
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 468551 begin --Dinosaur
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 468511 begin --Abshad Force
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 468541 begin --Genie
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 468501 begin --Thief Boss
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 475731 begin --Venefica
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 475741 begin --Demon Vene
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 462061 begin --Death Bone
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 10000004 begin --King Of Tremor
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 44025 begin --Arabian Shitan
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 28819 begin --White Knight
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 10 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 38211 begin --Selket
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 30 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 38212 begin --Neith
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 30 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 38213 begin --Anubis
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 30 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 38214 begin --Isis
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 30 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 14997 begin --Medusa --big uniques
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 50 END
/* insert */
if @[Only registered and activated users can see links. Click Here To Register...]Point >0 and @[Only registered and activated users can see links. Click Here To Register...]ldid >0 and (not exists (select charid from SRO_VT_SHARD.._UniqueRanking where CharID = @[Only registered and activated users can see links. Click Here To Register...]arid) ) begin
insert into SRO_VT_SHARD.._UniqueRanking (CharID,CodeName128,points) values @[Only registered and activated users can see links. Click Here To Register...]arid @[Only registered and activated users can see links. Click Here To Register...]ldname @[Only registered and activated users can see links. Click Here To Register...]Point)
end
else if @[Only registered and activated users can see links. Click Here To Register...]Point >0 and @[Only registered and activated users can see links. Click Here To Register...]ldid =0 and (not exists (select charid from SRO_VT_SHARD.._UniqueRanking where CharID = @[Only registered and activated users can see links. Click Here To Register...]arid) ) begin
insert into SRO_VT_SHARD.._UniqueRanking (CharID,CodeName128,points) values @[Only registered and activated users can see links. Click Here To Register...]arid,0 @[Only registered and activated users can see links. Click Here To Register...]Point)
end
/* update */
else if @[Only registered and activated users can see links. Click Here To Register...]ldid >0 and (exists (select charid from SRO_VT_SHARD.._UniqueRanking where CharID = @[Only registered and activated users can see links. Click Here To Register...]arid)) begin
UPDATE SRO_VT_SHARD.dbo._UniqueRanking SET CodeName128 = @[Only registered and activated users can see links. Click Here To Register...]ldname Where CharID = @[Only registered and activated users can see links. Click Here To Register...]arid
end
else if @[Only registered and activated users can see links. Click Here To Register...]Point >0 and (exists (select charid from SRO_VT_SHARD.._UniqueRanking where CharID = @[Only registered and activated users can see links. Click Here To Register...]arid)) begin
UPDATE SRO_VT_SHARD.dbo._UniqueRanking SET points = @[Only registered and activated users can see links. Click Here To Register...]int @[Only registered and activated users can see links. Click Here To Register...]Point Where CharID = @[Only registered and activated users can see links. Click Here To Register...]arid
end
/* uniquekilllist & clean */
insert into SRO_VT_SHARD.._UniqueKillList (CharID,CodeName128,time) VALUES @[Only registered and activated users can see links. Click Here To Register...]arid @[Only registered and activated users can see links. Click Here To Register...]ed,Getdate())
delete from SRO_VT_ACCOUNT..srZor_uniques where id=(select max (id) from SRO_VT_ACCOUNT..srZor_uniques)
end