[Guide] EVENT System Works

[hefajstos]

Hi Ragezone i repair Event System its works

bug is cabal_sp_ems_get_events
solved:

Spoiler

USE [EventData]
GO

/****** Object: StoredProcedure [dbo].[cabal_sp_ems_get_events] Script Date: 03/03/2013 13:55:28 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cabal_sp_ems_get_events]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[cabal_sp_ems_get_events]
GO

USE [EventData]
GO

/****** Object: StoredProcedure [dbo].[cabal_sp_ems_get_events] Script Date: 03/03/2013 13:55:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


-- =============================================
-- Author: Hefajstos
-- Create date: 2013-01-08
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[cabal_sp_ems_get_events]
AS
BEGIN

SET NOCOUNT ON

DECLARE @TimeZone INT
SET @TimeZone = DATEDIFF(hour, GETUTCDATE(), GETDATE())

SELECT
TOP 10
EventID,
EventType,
UseFlag,
DATEADD(hour, -@TimeZone, BeginDate),
DATEADD(hour, -@TimeZone, EndDate),
DATEADD(hour, -@TimeZone, LastModifiedDate),
worldIndex,
npcIndex,
Name
FROM
cabal_ems_event_table
WHERE
UseFlag= 1
ORDER BY EndDate DESC

END


GO

I still tested all Event type and repair missing tables
liked?:

 

[matrixfinity]

how you start the event

 

[xender16]

DATEADD(hour, -@TimeZone, BeginDate),
DATEADD(hour, -@TimeZone, EndDate),
DATEADD(hour, -@TimeZone, LastModifiedDate),
I think you edit in the table

 

[AMD79]

Mind telling us what did you fill in those table? Cause I cant seem to find the data for the event.

 

[Spik3man]

the only difference between original one and this is only : UseFlag,

 

[hefajstos]

not edit table, [ERROR] row 3<TIMESTAMP> not BeginDate
is UseFlag, i used orginal Backup EventData.bak and changed date in tables: cabal_ems_event_table
1254 2 2013-03-02 18:35:53.443 2013-11-17 10:00:00.000 2011-10-27 12:11:39.723 1 Enter the Haunted Dungeons test/ 3 49
1255 1 2013-03-02 18:35:53.443 2013-11-17 10:00:00.000 2011-10-27 12:11:39.737 1 Slay the Giant Pumpkins ???? ????? @_@)/ 1 10

UseFlag = 0/1-off/on

Desing my table:

EventID int Unchecked
EventType tinyint Unchecked
BeginDate datetime Unchecked
EndDate datetime Unchecked
LastModifiedDate datetime Unchecked
UseFlag tinyint Unchecked
Name varchar(128) Unchecked
LogMessages text Checked
worldIndex int Unchecked
npcIndex int Unchecked

Event type:
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,

not use 0xA0 (hex) convert to binary = 160,0xA1=161,etc....
tested type 1,2,3,4 works

my backup:

You must be registered to see links

 

[AMD79]

Got this error on my first try :
[Mon Mar 4 2013 02:14:49.678166 3085896592]: [##ERROR##] [EMS] Invalid Event(1255) Type(174)
[Mon Mar 4 2013 02:14:49.717710 3085896592]: [##ERROR##] UpdateEventData(): [EMS] Failed to find Event(1255)
[Mon Mar 4 2013 02:14:49.717758 3085896592]: [##ERROR##] UpdateEventData(): [EMS] Failed to find Event(1255)

What did I do wrong?

p/s I did restore the eventdata db backup and modified the sp...

 

[hefajstos]

event type 1,2,3,4,5 work more type something is wrong i stll tested :
I want to start:
T-Point Shop in BI
Yul NPC all type Event and all type UI NPC Event
I think that it is possible to enter for WAR Forcecalibur world_id=73 name world 75

 

[Drav3n]

How to start this event? any query to run to fill up the table of cabal_ems_event_table?

 

[devit65]

working properly
my EVENTDATA
Refer to apply

 

[Drav3n]

working properly
my EVENTDATA
Refer to apply
View attachment 125064 View attachment 125066

It work but when you talked Event NPC Yul, there's no selection of the event list.

 

[Tmxx Rush]

Nice its work just need find out something more cuz cant open Yul :/

 

[AMD79]

I can see the event monster but whenever I click the event npc nothing popup? Here is my worldserver log error :

[Mon Mar 4 2013 07:44:35.295740 2845457296]: GetInitializePacket(): breaklee NOT Dirty Event : 1
[Mon Mar 4 2013 07:44:43.247303 2845457296]: GetInitializePacket(): breaklee NOT Dirty Event : 1
[Mon Mar 4 2013 07:44:46.052846 2845457296]: GetInitializePacket(): breaklee NOT Dirty Event : 1
[Mon Mar 4 2013 07:44:47.913835 2845457296]: GetInitializePacket(): breaklee NOT Dirty Event : 1
[Mon Mar 4 2013 07:44:48.782337 2845457296]: GetInitializePacket(): breaklee NOT Dirty Event : 1
[Mon Mar 4 2013 07:44:49.684425 2845457296]: GetInitializePacket(): breaklee NOT Dirty Event : 1

Any hint?

 

[cadena]

use husky

 

[Spik3man]

seems like yul is fully working , and moster event are working too
now all we need to make work is Lakeside 4 like EU and , guild emblem system event

 

[Stricted]

not edit table, [ERROR] row 3<TIMESTAMP> not BeginDate
is UseFlag, i used orginal Backup EventData.bak and changed date in tables: cabal_ems_event_table
1254 2 2013-03-02 18:35:53.443 2013-11-17 10:00:00.000 2011-10-27 12:11:39.723 1 Enter the Haunted Dungeons test/ 3 49
1255 1 2013-03-02 18:35:53.443 2013-11-17 10:00:00.000 2011-10-27 12:11:39.737 1 Slay the Giant Pumpkins ???? ????? @_@)/ 1 10

UseFlag = 0/1-off/on

Desing my table:

EventID int Unchecked
EventType tinyint Unchecked
BeginDate datetime Unchecked
EndDate datetime Unchecked
LastModifiedDate datetime Unchecked
UseFlag tinyint Unchecked
Name varchar(128) Unchecked
LogMessages text Checked
worldIndex int Unchecked
npcIndex int Unchecked

Event type:
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,

not use 0xA0 (hex) convert to binary = 160,0xA1=161,etc....
tested type 1,2,3,4 works

my backup:

You must be registered to see links

i have restore your backup the logfiles say event is startet
ingame is no event why?!?

 

[Extornia]

seems like yul is fully working , and moster event are working too
now all we need to make work is Lakeside 4 like EU and , guild emblem system event

Guild emblem doesent work on EU or BR.

 

[Spik3man]

actually all of them are working look on egarena

 

[AMD79]

seems like yul is fully working , and moster event are working too
now all we need to make work is Lakeside 4 like EU and , guild emblem system event

Does NPC yul actually working? Can you post some screenshot? Whenever I click that npc nothing popup... not even the dialog window..

 

[rooankesley]

me too, anyone can help us?

Does NPC yul actually working? Can you post some screenshot? Whenever I click that npc nothing popup... not even the dialog window..