ELİTE Kguard Honor Point , Rank Point Ve Cheste Ödül Verme Enkısa yollar burada

SRO_VT_LOG TABLO
[CLUB]
USE [SRO_VT_LOG]
GO

/****** Object: Table [dbo].[_MERT_UN] Script Date: 28.09.2023 13:59:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[_MERT_UN](
[UniqueID] [int] NOT NULL,
[CodeName128] [varchar](150) NOT NULL,
[UniqName] [varchar](50) NOT NULL,
[HonorPoint] [int] NOT NULL,
[RankPoint] [int] NOT NULL
) ON [PRIMARY]
GO


[/CLUB]
Kguard Edge prosedür -Live Uniqe On Kill
[CLUB]
USE [KGuardEDGE]
GO
/****** Object: StoredProcedure [dbo].[Live_Unique_OnKill] Script Date: 28.09.2023 14:08:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER procedure [dbo].[Live_Unique_OnKill]
@GameserverID int,
@GameserverObjID int,
@KillerCharID int,
@KillerCharName varchar(64),
@KillerDamage int,
@TotalDamage int,
@AttackersCount int,
@KillRegion int,
@KillPosX real,
@KillPosY real,
@KillPosZ real
as
begin

declare @Rank_UniqueRank_Multiplier float = convert(float, @TotalDamage) / convert(float, @KillerDamage)
declare @Rank_UniqueRank_Point int = convert(int, @Rank_UniqueRank_Multiplier * @AttackersCount)

update _Live_Unique
set KillerCharID = @KillerCharID,
KillerCharName = @KillerCharName,
KillDate = getdate(),
KillerDamage = @KillerDamage,
TotalDamage = @TotalDamage,
AttackersCount = @AttackersCount,
KillRegion = @KillRegion,
KillPosX = @KillPosX,
KillPosY = @KillPosY,
KillPosZ = @KillPosZ,
Point = @Rank_UniqueRank_Point
where GameserverObjID = @GameserverObjID
and GameserverID = @GameserverID

declare @Rank_UniqueRank_ID int = null
select @Rank_UniqueRank_ID = ID from _Rank_UniqueRank where CharID = @KillerCharID

if (@Rank_UniqueRank_ID is null)
begin
insert into _Rank_UniqueRank (CharID, CharName) values (@KillerCharID, @KillerCharName)
select @Rank_UniqueRank_ID = @@IDENTITY
end

update _Rank_UniqueRank
set CharName = @KillerCharName,
TotalKillCount += 1,
TotalDamageCount += @KillerDamage,
Point += @Rank_UniqueRank_Point,
LastKillDate = getdate()
where CharID = @KillerCharID

declare @UniqueRefObjID int = (select RefObjID from _Live_Unique where GameserverObjID = @GameserverObjID and GameserverID = @GameserverID)
declare @UniqueCodename varchar(128) = (select CodeName128 from SRO_VT_SHARD.._RefObjCommon with(nolock) where ID=@UniqueRefObjID)


if (@UniqueRefObjID in (select UniqueID from SRO_VT_LOG.._MERT_UN where UniqueID = @UniqueRefObjID))
begin
declare @uniqname varchar(64),@HonorPoint int,@CampID int,@RankPoint int
select @uniqname=UniqName,@HonorPoint=HonorPoint,@RankPoint=RankPoint from SRO_VT_LOG.._MERT_UN with(nolock) where UniqueID=@UniqueRefObjID

select @CampID=CampID from SRO_VT_SHARD.._TrainingCampMember with(nolock) where CharID=@KillerCharID
if(@HonorPoint > 0)
begin
update SRO_VT_SHARD.._TrainingCampMember set HonorPoint+=@HonorPoint where CampID=@CampID
update SRO_VT_SHARD.._TrainingCamp set GraduateCount+=@HonorPoint,EvaluationPoint+=@HonorPoint where ID = @CampID
insert into KGuardEDGE.._DeveloperCommands (Cmd,Data1,Data2) values('server_sendsysmsg_colored','[ '+@KillerCharname+' ] '+@uniqname+' keserek '+convert(varchar,@HonorPoint)+' HonorPoint kazandı.','12245248')
end
if(@RankPoint > 0)
begin
declare @guildname varchar(120) = (select [Name] from SRO_VT_SHARD.._Guild where ID= (select GuildId from SRO_VT_SHARD.._Char where CharID=@KillerCharID))
if not exists(select Info1 from KGuardEDGE.._Rank_Custom1 where @KillerCharName=Info1)
insert into KGuardEDGE.._Rank_Custom1 values (@KillerCharName,@guildname,@RankPoint)
else update KGuardEDGE.._Rank_Custom1 set Score += @RankPoint,Info2=@guildname where Info1=@KillerCharName

end

end

end
----- UNİQ KİLL ÖDÜLÜ
if(@UniqueCodeName in ('MOB_CH_TIGERWOMAN','MOB_CH_TIGERWOMAN_STR','MOB_OA_URUCHI','MOB_OA_URUCHI_STR','MOB_KK_ISYUTARU','MOB_KK_ISYUTARU_STR','MOB_TK_BONELORD','MOB_TK_BONELORD_STR','MOB_RM_TAHOMET','MOB_RM_TAHOMET_STR','MOB_AM_IVY','MOB_AM_IVY_STR','MOB_AM_STR','MOB_EU_KERBEROS','MOB_EU_KERBEROS_STR'))
begin
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_BOX_SILK_UNIQUE',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_BOX_MOON_SCROLL',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_ETC_ARCHEMY_MAGICSTONE_ATHANASIA_10',1,'Chest'
end
----- UNİQ KİLL ÖDÜLÜ
if(@UniqueCodeName in ('MOB_RM_ROC_02_STR','MOB_RM_ROC_02_INT'))
begin
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_SILK_SCROLL100',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_SILK_SCROLL100',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_ETC_ARCHEMY_MAGICSTONE_ATHANASIA_10',5,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_ETC_ARCHEMY_MAGICSTONE_ASTRAL_10',5,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_100M_GOLD_BAR_01',1,'Chest'
end

----- UNİQ KİLL ÖDÜLÜ
if(@UniqueCodeName in ('MOB_TQ_WHITESNAKE_INT','MOB_TQ_WHITESNAKE_STR'))
begin
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_500M_GOLD_BAR_01',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_SILK_SCROLL100',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_SILK_SCROLL100',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_BOX_4_SCROLL',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_BOX_SILK_UNIQUE',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_ETC_ARCHEMY_MAGICSTONE_ATHANASIA_10',5,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'


end
----- UNİQ KİLL ÖDÜLÜ
if(@UniqueCodeName in ('MOB_ARABIA_KARKADANN_STR','MOB_ARABIA_KARKADANN_INT','MOB_ARABIA_KHULOOD_INT','MOB_ARABIA_KHULOOD_STR'))
begin
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_BOX_4_SCROLL',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_BOX_SILK_UNIQUE',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_ETC_ARCHEMY_MAGICSTONE_ATHANASIA_10',5,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_100M_GOLD_BAR_01',1,'Chest'

end

----- UNİQ KİLL ÖDÜLÜ
if(@UniqueCodeName in ('MOB_SD_APIS','MOB_SD_OSIRIS','MOB_SD_HORUS','MOB_SD_NEPHTHYS','MOB_RM_ROC_STR','MOB_RM_ROC_INT'))
begin
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
end

----- UNİQ KİLL ÖDÜLÜ
if(@UniqueCodeName in ('MOB_SD_ISIS','MOB_SD_SELKIS','MOB_SD_ANUBIS','MOB_SD_NEITH'))
begin
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'

end




[/CLUB]