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
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
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