That, well kinda.. there is a thread in rz about it but ill check what i can do for you.
EventData -> dbo.cabal_ems_event_table:
EventID: Number from 1 to MAX_INT, cant be repeated
Event Type:
Code:
EMST_INVALID = 0,
EMST_EVENT_MONSTER_SPAWN = 1,
EMST_EVENT_ITEM_COLLECTING = 2,
// EMST_EVENT_LOTTERY_ITEM = 3,
EMST_EVENT_GOAL = 4,
EMST_EVENT_MULTIPLE = 5,
EMST_EVENT_MULTIPLE_15 = 6,
EMST_DROPPOOL = 0xA0,
EMST_NPCITEMSHOP = 0xA1,
EMST_NCPSCRIPT = 0xA2,
EMST_ITEMDESC = 0xA3,
// EMST_LOTTERY_ITEMDESC = 0xA4,
EMST_LOTTERY_ITEMPOOL = 0xA5,
EMST_GOAL_REWARD_ITEMS = 0xA6,
EMST_GOAL_REWARD_BONUSES = 0xA7,
EMST_GOAL_GOALUNITS = 0xA8,
EMST_NPCITEMSHOP_ITEMPRICE = 0xA9,
EMST_MULTIPLE_VALUES = 0xAA,
EMST_CRAFT_FORMULACARD = 0xAB,
EMST_CRAFT_RECIPEPOOL = 0xAC,
EMST_MULTIPLE_VALUES_15TH = 0xAD,
------
EDO_DEFAULT = 0,
EDO_FOR_NPCITEMSHOP = 1
Also as per cabal_sp_ems_get_eventdata:
ELSE IF
eventType = CAST(0xA1 AS INT)) --- 0xA1 is EMST_NPCITEMSHOP
BEGIN
-- EMST_NPCITEMSHOP (PricePoint is Ecash/Ecoins, ItemPriceID is a item id to be used as payment
SELECT
ItemKindIdx, ItemOption, ItemDurationIdx, PriceAlz, PricePoint, SlotIdx, ItemPriceID
FROM cabal_ems_event_npcitemshop_table
WHERE EventID = eventID
-- This piece of code also tells you, you have to alter cabal_ems_event_npcitemshop_table and add
-- Items to the event manually
END
BeginDate: Starting date to be safe make it yesterdays date
EndDate: Date the event ends
LastModifiedDate: Last time i checked this isnt used and is normally 00/00/00 00:00
UseFlag=3, -> what this does exactly is still unknown to me
Name: Event's Name
LogMessages: Null,
worldIndex: Normally 3 for ep8-, 1 for bloody ice npc though you will have to add npc 49 to BI or just use a npc thats already there like say Henkoff (though never tested)
npcIndex: 49, <- It was always 49 as far as i know (if using Henkoff or other npc set this to appropriate npc index)
Lastly execute this:
Code:
USE [EventData]
GO
/****** Object: StoredProcedure [dbo].[cabal_sp_ems_get_events] Script Date: 5/11/2019 12:29:26 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Yoo Seung Kim
-- Create date: 2008-10-01
-- Description:
-- =============================================
ALTER PROCEDURE [dbo].[cabal_sp_ems_get_events]
AS
BEGIN
SET NOCOUNT ON
DECLARE [USER=2296]time[/USER]Zone INT
SET [USER=2296]time[/USER]Zone = DATEDIFF(hour, GETUTCDATE(), GETDATE())
SELECT
TOP 10
EventID,
EventType,
DATEADD(hour, [USER=2296]time[/USER]Zone, BeginDate),
DATEADD(hour, [USER=2296]time[/USER]Zone, EndDate),
DATEADD(hour, [USER=2296]time[/USER]Zone, LastModifiedDate),
worldIndex,
npcIndex,
Name
FROM
cabal_ems_event_table
WHERE
UseFlag= 3
ORDER BY EndDate DESC
END