|
Use [SRO_VT_SHARDLOG]
Go
Create Table [dbo].[_UniquesEvent] -- Uniques table
([ID] Int Not Null Primary Key Identity,
[MonsterCodeName] Varchar(128) Not Null,
[Amount] Int Not Null)
Go
Create Procedure [dbo].[_ManageUniqueEvent] -- manage event procedure
@Type Int ,
@Notice Varchar(8000) ,
@ID Int
As
Declare @MonsterID Int , @MonsterCodeName Varchar(128) , @Amount Int
IF @Type = 0
Begin
Insert Into [dbo].[iLegend_Tool] (Service,Type,Message,Date)
Values (1,'Notice',@Notice,Getdate())
End
IF @Type = 1 /* Warp to event region */
Begin
Insert Into [dbo].[iLegend_Tool] (Service,Type,RegionID,PosX,PosY,PosZ,WorldID,Date)
Values (1,'Warp','RegionID','X','Y','Z','WorldID',Getdate()) /* Set Warp Point For Event Place */
End
IF @Type = 2
Begin
Select @MonsterCodeName = MonsterCodeName , @Amount = Amount From [dbo].[_UniquesEvent] Where ID = @ID
-- Get ref monster id
Set @MonsterID = (Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 = @MonsterCodeName)
Insert Into [dbo].[iLegend_Tool] (Service,Type,RefMobID,Amount,Date)
Values (1,'Loadmonster',@MonsterID,@Amount,Getdate())
End
|