[Guide] EVENT System Works

[toast2250]

Has anyone succeeded in the the Tpoint selling NPC?
Ive tried different types, NPCs, added the NPC to Event.scp,..

[NpcPos] Flags WorldIdx Index PosX PosY Type IsRangeCheck
0 0 3 49 195 56 8 1
1 0 1 10 11 25 8 0

world
[Tue Apr 23 2013 10:29:57.623163 2869226384]: [##ERROR##] pITSRequest->result is raised in OnITCEMSNPCAction() (Proc/EMS.cpp:368)

pcbang
[Tue Apr 23 2013 10:29:57.615558 3033619344]: [##ERROR##] User(2), Event(1254), Type(1) : OnIPCNPCAction fail
[Tue Apr 23 2013 10:29:57.615577 3033619344]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Could not find stored procedure 'dbo.TPoint_InsertPointShopLog'.
[Tue Apr 23 2013 10:29:57.615589 3033619344]: [##ERROR##] DB ERROR(CODE) : 2812
[Tue Apr 23 2013 10:29:57.615600 3033619344]: [##ERROR##] DB ERROR(VAR_INFO) :
[Tue Apr 23 2013 10:29:57.615610 3033619344]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Tue Apr 23 2013 10:29:57.615620 3033619344]: [##ERROR##] DB ERROR(STM_TEXT) : {call dbo.TPoint_InsertPointShopLog(? , ? , ? , ? , ?



I think something is missing for the Tpoint,..

 

[GODSKIN]

Has anyone succeeded in the the Tpoint selling NPC?
Ive tried different types, NPCs, added the NPC to Event.scp,..

[NpcPos] Flags WorldIdx Index PosX PosY Type IsRangeCheck
0 0 3 49 195 56 8 1
1 0 1 10 11 25 8 0

[Tue Apr 23 2013 10:29:57.623163 2869226384]: [##ERROR##] pITSRequest->result is raised in OnITCEMSNPCAction() (Proc/EMS.cpp:368)

[Tue Apr 23 2013 10:29:57.615558 3033619344]: [##ERROR##] User(2), Event(1254), Type(1) : OnIPCNPCAction fail
[Tue Apr 23 2013 10:29:57.615577 3033619344]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Could not find stored procedure 'dbo.TPoint_InsertPointShopLog'.
[Tue Apr 23 2013 10:29:57.615589 3033619344]: [##ERROR##] DB ERROR(CODE) : 2812
[Tue Apr 23 2013 10:29:57.615600 3033619344]: [##ERROR##] DB ERROR(VAR_INFO) :
[Tue Apr 23 2013 10:29:57.615610 3033619344]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Tue Apr 23 2013 10:29:57.615620 3033619344]: [##ERROR##] DB ERROR(STM_TEXT) : {call dbo.TPoint_InsertPointShopLog(? , ? , ? , ? , ?

View attachment 128536

Need add new DB dbo.TPoint_InsertPointShop

Or Creat item Shop In Wepsite Use Item By T point
Or Toint Convert To Cashpoint
And idea

 

[GODSKIN]

...................

 

[VizesLufi]

Hello guys i need ur helps masters!

EventDBAgent.log--->

[##ERROR##] OnIPCEMSGetEvents fail
[##ERROR##] DB ERROR(MSG) : Incompatible data types in stream operation
[##ERROR##] DB ERROR(CODE) : 32000
[##ERROR##] DB ERROR(VAR_INFO) : Column: 4<SHORT INT>, datatype in operator <</>>: TIMESTAMP
[##ERROR##] DB ERROR(SQLSTATE) :
[##ERROR##] DB ERROR(STM_TEXT) : {call dbo.cabal_sp_ems_get_events}


Why i get this error always when i want to start the event? (i using hefa eventdata backup!)
Thanks for answers!

 

[magraopb]

missing tables/ or something wrong on the table if exist

 

[Revy]

Hello guys i need ur helps masters!

EventDBAgent.log--->

[##ERROR##] OnIPCEMSGetEvents fail
[##ERROR##] DB ERROR(MSG) : Incompatible data types in stream operation
[##ERROR##] DB ERROR(CODE) : 32000
[##ERROR##] DB ERROR(VAR_INFO) : Column: 4<SHORT INT>, datatype in operator <</>>: TIMESTAMP
[##ERROR##] DB ERROR(SQLSTATE) :
[##ERROR##] DB ERROR(STM_TEXT) : {call dbo.cabal_sp_ems_get_events}


Why i get this error always when i want to start the event? (i using hefa eventdata backup!)
Thanks for answers!

cabal_sp_ems_get_events
check your stored procedure :

 

[Asero1933]

any scripts for stored procedure

 

[hefajstos]

here my SP but multiple Event (type 5 , 6) infinite
cabal_sp_ems_get_eventdata

Spoiler

USE [EventData]
GO

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

USE [EventData]
GO

/****** Object: StoredProcedure [dbo].[cabal_sp_ems_get_eventdata] Script Date: 04/28/2013 22:39:02 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO





CREATE PROCEDURE [dbo].[cabal_sp_ems_get_eventdata]
(
@EventID INT,
@EventType INT,
@Option TINYINT = 0
)
AS
/*
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,
*/
BEGIN
SET NOCOUNT ON

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

IF (@EventType = 1)
BEGIN
-- EMST_EVENT_MONSTER_SPAWN
SELECT EventMonsterID, SpawnInterval, AuthorityType, PerfectDrop, MultiDropType, MultiDropMin,
MultiDropMax, XPos, YPos, Width, Height, SpawnWorldIdx, DropPoolID, SpawnServers, SpawnChannels
FROM cabal_ems_event_monster_spawn_table
WHERE EventID = @EventID
END

ELSE IF (@EventType = 2)
BEGIN
-- EMST_EVENT_ITEM_COLLECTING
SELECT ItemKindIdx, ItemOption, DropRate, DropServers, DropRegions
FROM cabal_ems_event_item_collecting_table
WHERE EventID = @EventID
END

ELSE IF (@EventType = 4)
BEGIN
-- EMST_EVENT_GOAL
SELECT MaxGoalCompletingCount
FROM cabal_ems_goalevent_table
WHERE EventID = @EventID
END

ELSE IF (@EventType = 5)
BEGIN
-- EMST_EVENT_MULTIPLE
SELECT
DATEADD(hour, -@TimeZone, BeginDateTime),
DATEADD(hour, -@TimeZone, EndDateTime)
FROM cabal_ems_multipleevent_datetime_table
WHERE
EventID = @EventID
AND
GETDATE() <= EndDateTime
ORDER BY BeginDateTime ASC
END

ELSE IF (@EventType = 6)
BEGIN
SELECT TOP 1 type, [case], timespan, allowedtimesec
FROM cabal_ems_event_timer_condition_table
WHERE EventID = @EventID
END

ELSE IF (@EventType = CAST(0xA0 AS INT)) --160
BEGIN
-- EMST_DROPPOOL
SELECT DropPoolID, ItemKindIdx, ItemOption, ItemDurationIdx, DropRate
FROM cabal_ems_droppool_table
WHERE DropPoolID IN
(
SELECT DISTINCT (DropPoolID)
FROM cabal_ems_event_monster_spawn_table
WHERE EventID = @EventID
)
ORDER BY DropPoolID ASC, [Order] ASC
END

ELSE IF (@EventType = CAST(0xA1 AS INT)) --161
BEGIN
-- EMST_NPCITEMSHOP
SELECT ItemKindIdx, ItemOption, ItemDurationIdx, PriceAlz, PricePoint, SlotIdx, ItemPriceID
FROM cabal_ems_event_npcitemshop_table
WHERE EventID = @EventID
END

ELSE IF (@EventType = CAST(0xA2 AS INT)) --162
BEGIN
-- EMST_NCPSCRIPT
SELECT Script1, Script2, Script3, Script4, Script5
FROM cabal_ems_event_npcscript_table
WHERE EventID = @EventID
END

ELSE IF (@EventType = CAST(0xA3 AS INT)) --163
BEGIN
-- EMST_ITEMDESC
SELECT ItemIdx, ItemOption, ExternalID, TextureItemIdx, ItemName, ItemDesc
FROM cabal_ems_event_item_table
WHERE EventID = @EventID
END

ELSE IF (@EventType = CAST(0xA5 AS INT)) --165
BEGIN
-- EMST_LOTTERY_ITEMPOOL
SELECT LotteryID, ItemKindIdx, ItemOption, DurationIdx, Ratio
FROM cabal_ems_lotterydroppool_table
WHERE LotteryID IN
(
SELECT ExternalID
FROM cabal_ems_event_item_table
WHERE EventID = @EventID
)
END

ELSE IF (@EventType = CAST(0xA6 AS INT)) --166
BEGIN
-- EMST_GOAL_REWARD_ITEMS
SELECT A.GoalID, B.ItemKindIdx, B.ItemOption, B.ItemDurationIdx, B.ItemCount, B.RewardableFlag
FROM cabal_ems_goalevent_goal_table as A, cabal_ems_goalevent_reward_itempool_table as B
WHERE A.EventID = @EventID
AND A.RewardItemPoolID = B.ItemPoolID
ORDER BY A.GoalID
END

ELSE IF (@EventType = CAST(0xA7 AS INT)) --167
BEGIN
-- EMST_GOAL_REWARD_BONUSES
SELECT A.GoalID, B.Type, B.Value
FROM cabal_ems_goalevent_goal_table as A, cabal_ems_goalevent_reward_bonuspool_table as B
WHERE A.EventID = @EventID
AND A.RewardBonusPoolID = B.BonusPoolID
ORDER BY A.GoalID
END

ELSE IF (@EventType = CAST(0xA8 AS INT)) --168
BEGIN
-- EMST_GOAL_GOALUNITS
SELECT GoalID, Type, MinParticipationLevel, MaxParticipationLevel, TargetLevel,
MaxRetryCount, TargetQuests, RewardItemCount, RewardBonusCount
FROM cabal_ems_goalevent_goal_table
WHERE EventID = @EventID
ORDER BY GoalID
SELECT * FROM cabal_ems_goalevent_goal_table
END

ELSE IF (@EventType = CAST(0xA9 AS INT)) --169
BEGIN
-- EMST_NPCITEMSHOP_ITEMPRICE
SELECT ItemPriceID, ItemKindIdx, ItemOption, ItemCount
FROM cabal_ems_event_npcitemshop_itemprice_table
WHERE ItemPriceID IN
(
SELECT DISTINCT (ItemPriceID)
FROM cabal_ems_event_npcitemshop_table
WHERE EventID = @EventID
)
END

ELSE IF (@EventType = CAST(0xAA AS INT)) --176
BEGIN
SELECT
MultiplePoolID,
DATEADD(hour, -@TimeZone, BeginDateTime),
DATEADD(hour, -@TimeZone, EndDateTime),
ApplyNation,
ServerList,
ChannelList,
WorldList
FROM cabal_ems_multipleevent_datetime_table
WHERE EventID = @EventID
AND
GETDATE() <= EndDateTime
ORDER BY BeginDateTime ASC
END

ELSE IF (@EventType = CAST(0xAB AS INT)) --171
BEGIN
-- EMST_CRAFT_FORMULACARD
SELECT RecipeID, Rate, ItemKindIdx, ItemOption, ItemDurationIdx
FROM cabal_ems_craftsevent_formulacard_table
WHERE RecipeID IN
(
SELECT ExternalID
FROM cabal_ems_event_item_table
WHERE EventID = @EventID
)
END

ELSE IF (@EventType = CAST(0xAC AS INT)) --172
BEGIN
-- EMST_CRAFT_RECIPEPOOL
SELECT RecipeID, ItemKindIdx, ItemOption, ItemCount
FROM cabal_ems_craftsevent_recipepool_table
WHERE RecipeID IN
(
SELECT RecipeID
FROM cabal_ems_craftsevent_formulacard_table
WHERE RecipeID IN
(
SELECT ExternalID
FROM cabal_ems_event_item_table
WHERE EventID = @EventID
)
)
END

ELSE IF (@EventType = CAST(0xAD AS INT)) --173
BEGIN
SELECT uiStyle
FROM cabal_ems_event_npcitemshop_uistyle_table
WHERE EventID = @EventID
END

ELSE IF (@EventType = 0xB0) --176
BEGIN
SELECT
MultiplePoolID,
DATEADD(hour, -@TimeZone, BeginDateTime),
DATEADD(hour, -@TimeZone, EndDateTime),
ApplyNation,
ServerList,
ChannelList,
WorldList
FROM cabal_ems_multipleevent_datetime_table
WHERE EventID = @EventID
AND
GETDATE() <= EndDateTime
ORDER BY BeginDateTime ASC
END

ELSE IF (@EventType = 0xB1) --177
BEGIN
SELECT timerid, rewardid, timespan
from cabal_ems_event_timer_event_table
WHERE EventID = @EventID
ORDER BY timerid
END

ELSE IF (@EventType = 0xB2) -- 178
BEGIN
SELECT rewardid, itemkindIndex, itemoption, itemDurationIndex
FROM cabal_ems_event_timer_rewarditem_table
WHERE EventID = @EventID
END

ELSE IF (@EventType = 3) --170
BEGIN
-- EMST_MULTIPLE_VALUES
SELECT A.MultiplePoolID, DurationServiceType, ServiceIndex, ColumnType,
MultpleValue, AppliedBeginLevel, AppliedEndLevel
FROM cabal_ems_multipleevent_multiple_table AS B
INNER JOIN
(
SELECT MultiplePoolID
FROM cabal_ems_multipleevent_datetime_table
GROUP BY MultiplePoolID
) AS A ON A.MultiplePoolID = B.MultiplePoolID
WHERE B.EventID = @EventID
END


--SELECT [Option]
-- FROM cabal_ems_event_table
-- WHERE EventID = @EventID
END




GO

cabal_sp_ems_get_events

Spoiler

USE [EventData]
GO

/****** Object: StoredProcedure [dbo].[cabal_sp_ems_get_events] Script Date: 04/28/2013 22:57:31 ******/
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: 04/28/2013 22:57:31 ******/
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,
[Option],
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
--SELECT [Option]
-- FROM cabal_ems_event_table
-- WHERE EventID = @EventID
END







GO

Hello guys i need ur helps masters!

EventDBAgent.log--->

[##ERROR##] OnIPCEMSGetEvents fail
[##ERROR##] DB ERROR(MSG) : Incompatible data types in stream operation
[##ERROR##] DB ERROR(CODE) : 32000
[##ERROR##] DB ERROR(VAR_INFO) : Column: 4<SHORT INT>, datatype in operator <</>>: TIMESTAMP <--DB = datetime
[##ERROR##] DB ERROR(SQLSTATE) :
[##ERROR##] DB ERROR(STM_TEXT) : {call dbo.cabal_sp_ems_get_events}


Why i get this error always when i want to start the event? (i using hefa eventdata backup!)
Thanks for answers!

you have an error in column 4
server dictates which type is to be
incorrect
correct

 

[cyberangel]

how to add timer_event?

 

[Stricted]

here my eventdata backup

You must be registered to see links

i tested only eventmob spawn and event npy yul not the t-point shop

thanks goes to all they post here the fixes

 

[luis R]

Some people did not understand the message of this topic.
Please do not post a just pictures and the works. Either solution or nothing.
Solution.
Add to database (cabal_ems_event_table) new row (Option)
View attachment 128471
and change (cabal_sp_ems_get_events)
View attachment 128473
go to new row (cabal_ems_event_table)>(Option) and edit.
View attachment 128474
If use value =1 NPC not clickable
2 = works script NPC
change UI style Schop in (cabal_ems_event_npcitemshop_uistyle_table)
1.2.3
Normal, T-Point Schop UI
That all

What is for EventID and EventType?

 

[KaitoDaumoto]

Like ive said u dont need to edit any on event.scp, report whatever u want.
Ps: Options are between 2-9 all diferents.

got guide sir? thank you for advance .. newbie here :/

 

[Revy]

got guide sir? thank you for advance .. newbie here :/

http://forum.ragezone.com/f459/cabal-event-data-event-list-928025/

 

[KaitoDaumoto]

http://forum.ragezone.com/f459/cabal-event-data-event-list-928025/

Thanks! But , the link was down ..

 

[Revy]

Thanks! But , the link was down ..

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

 

[Wataryx23]

any One know how to adjust level in Cabal Lantern?

 

[luis R]

mobs.scp

 

[Wataryx23]

and also t-point shop failed to purchase an item how to fix?

mobs.scp

Thabks man i got it

 

[luis R]

and also t-point shop failed to purchase an item how to fix?




Thabks man i got it

Hit like if helped ☺

 

[Wataryx23]

Hit like if helped ☺

u failed t-points shop too man?