[Guide] EVENT System Works

Hi Ragezone i repair Event System its works
Attachment 125034Attachment 125035Attachment 125036Attachment 125037
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?:):

how you start the event

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

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

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

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:
http://www.4shared.com/rar/3K25iUAV/EventData.html?

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...

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

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

working properly
my EVENTDATA
Refer to apply
Attachment 125064 Attachment 125066

Quote:

---

Originally Posted by devit65

working properly
my EVENTDATA
Refer to apply
Attachment 125064 Attachment 125066

---

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

Attachment 125070

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

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?

use husky

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