Newbie Spellweaver
- Joined
- Oct 4, 2012
- Messages
- 53
- Reaction score
- 16
how to sell or put item to YUL NPC?
EventData
Tables
dbo.cabal_ems_event_npcitemshop <- you can put the items in this table
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!how to sell or put item to YUL NPC?
thanks for the respon...
is see the tables contain [id]
i dont understand what for the [id] tables?
Anyone knows how to add more than 10 events ? seems there is a limit and cannot find anything to edit more than 10.
Limit 10 Event -___-
Why u need more event lol
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
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