İlk paylaşımım, Uniqe Mob drop düzenlemek yerine bu şekilde daha rahat olacağını düşündüm. Box System yapılıp Uniqlere eklenebilir. Görsel mevcuttur.
Paylaşım Adı: | Uniqe Kill Ödülü |
Paylaşım İçeriği: | Prosedür, Query. |
Download: |
1. İşlem
USE [KGuardEDGE]
GO
/****** Object: StoredProcedure [dbo].[_AddItemToChest] Script Date: 10.06.2023 11:58:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[_AddItemToChest]
@CharID int,
@CodeName128 varchar(128),
@Count smallint,
@RegisterNote varchar(50)
as
begin
insert into KGuardEDGE.._ItemChest
(CharID, CodeName, [Count], Plus, RegisterNote)
values
(@CharID, @CodeName128, @Count, 0, @RegisterNote)
end
2. İşlem
Live_Unique_OnKill tablosuna eklenecek.
declare @uniqueRefObjID int
select @uniqueRefObjID = RefObjID
from _Live_Unique
where GameserverObjID = @GameserverObjID
and GameserverID = @GameserverID
---UNİQ KİLL ÖDÜLÜ
if(@uniqueRefObjID in ('1954')) --tiger girl / diğer uniqlerin idleri eklenerek çoğaltılabilir.
begin
insert into KGuardEDGE.._DeveloperCommands (Cmd, Data1, Data2)
values ('private_sendenglishnote', @KillerCharname, 'Your reward has been sent to your Item Chest.'),
('private_sendturkishnote', @KillerCharname, 'Ödülünüz Item Chest''inize gönderilmiştir.')
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_SILK_SCROLL_1',1,'Chest'
exec KGuardEDGE.._AddItemToChest @KillerCharID,'ITEM_MALL_GACHA_CARD',1,'Chest'
end
|
VirusTotal: | XXX |
The Virustotal link has to be attached along with the Share file content.
Topics that do not include a Virustotal link will not be approved.
