Hello i have one problem i testing my PSERVERCMS and all times its stack in ranking with same names same points. anyone know how i can fix it?
Thats my procedure
declare @killer 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=@killer)
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 @eventid 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-- lvy ----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 = 6 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 = 10 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 = 8 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 14995 begin-- snake
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 = 22891 begin --medusa --big uniques
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 20 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 3877 begin --roc
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 100 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
Thats my procedure
declare @killer 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=@killer)
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 @eventid 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-- lvy ----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 = 6 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 = 10 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 = 8 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 14995 begin-- snake
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 = 22891 begin --medusa --big uniques
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 20 END
if @[Only registered and activated users can see links. Click Here To Register...]id = 3877 begin --roc
SET @[Only registered and activated users can see links. Click Here To Register...]Point = 100 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