01-06-2021, 12:50 AM
|
#2
|
|
• الانـتـسـاب » Aug 2019
|
• رقـم العـضـويـة » 144048
|
• المشـــاركـات » 620
|
• الـدولـة » بيلف الارض
|
• الـهـوايـة » *-Developer-*
|
• اسـم الـسـيـرفـر » Private Server
|
• الـجـنـس » Male
|
• نقـاط التقييم » 22
|
|
|
رد: عندى مشكله فى رينك اليونيك
جرب ده كده
كود PHP:
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
وال رانك ده لل pservercms*
|
|
|