Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Cabal Event Data , Event List Working Fully !

Junior Spellweaver
Joined
Mar 2, 2008
Messages
170
Reaction score
17
thanks for the respon...
is see the tables contain [id]
i dont understand what for the [id] tables?
 
█║▌║▌║TheMerc iful║▌║▌║█
Loyal Member
Joined
Jan 29, 2005
Messages
1,361
Reaction score
80
thanks for the respon...
is see the tables contain [id]
i dont understand what for the [id] tables?

Best Thing To Ask Is. "Can You Give Me An Example Of 1 Event So That i Can Follow Or Make A Reference Of It."

Have Not Tried The Events Yet Coz' Still Focusing On Default Configurations Of EP8. Just Hope Someone Would Give You The Answer To This Question.

Good Luck!
 
Newbie Spellweaver
Joined
Feb 15, 2010
Messages
33
Reaction score
2
Limit 10 Event -___-

Why u need more event lol

For example a custom event collect and exchange it require two events in EventData one for mob spawn and second one for exchange. If you run five of this it mean 10 events. I know i can add the exchange drop into mob drop and we have 1 event and not two but it would be to easier to obtain items like this. More events more fun to players !
 
Last edited:
Junior Spellweaver
Joined
Oct 18, 2011
Messages
164
Reaction score
78
Code:
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  [USER=2296]time[/USER]Zone INT
SET  [USER=2296]time[/USER]Zone = DATEDIFF(hour, GETUTCDATE(), GETDATE())

SELECT
TOP 10
EventID,
EventType,
UseFlag,
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= 1 [COLOR="#FF0000"]<--- change to 3[/COLOR]
ORDER BY EndDate DESC

END


GO

View attachment 156133
View attachment 156134
 
Newbie Spellweaver
Joined
Dec 31, 2015
Messages
60
Reaction score
19
Code:
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  @[I][B][URL="http://forum.ragezone.com/members/2296.html"]time[/URL][/B][/I]Zone INT
SET  @[I][B][URL="http://forum.ragezone.com/members/2296.html"]time[/URL][/B][/I]Zone = DATEDIFF(hour, GETUTCDATE(), GETDATE())

SELECT
TOP 10
EventID,
EventType,
UseFlag,
DATEADD(hour,   @[I][B][URL="http://forum.ragezone.com/members/2296.html"]time[/URL][/B][/I]Zone, BeginDate),
DATEADD(hour,   @[I][B][URL="http://forum.ragezone.com/members/2296.html"]time[/URL][/B][/I]Zone, EndDate),
DATEADD(hour,   @[I][B][URL="http://forum.ragezone.com/members/2296.html"]time[/URL][/B][/I]Zone, LastModifiedDate),
worldIndex,
npcIndex,
Name
FROM
cabal_ems_event_table
WHERE
UseFlag= 1 [COLOR=#FF0000]<--- change to 3[/COLOR]
ORDER BY EndDate DESC

END


GO

View attachment 156133
View attachment 156134

thank you for this but why the need for UseFlag value change from 1 into 3?

UseFlag= 1 <--- change to 3

 
Banned
Banned
Joined
Aug 2, 2011
Messages
1,427
Reaction score
979
eventdata ep8 original look like work same this realse

but need know how to use + enable
 
Newbie Spellweaver
Joined
Jul 1, 2011
Messages
28
Reaction score
1
i know to use/ enabel but i am stuck at failed to buy:|
 
Experienced Elementalist
Joined
Jul 11, 2014
Messages
274
Reaction score
2
how to fix failed to purchase an item in T-point SHop?
 
Back
Top