Caravan time period setting

[ch265410]

Hello everyone, how to set the time period for running a business. For example, only 12:00 noon to 24:00 can run business, other times can not buy goods。 My English is not very good.

[chipno0p]

You can easily manage with a filter

[#HB]

Originally Posted by chipno0p

You can easily manage with a filter

Not necessary at all.

You can basically create a job system that exists in many server right now. The system will reward player after he delivers the trade and restarts his character. You can set a time for the system, for example:

DECLARE @CurrHour TINYINT;
SELECT @CurrHour = DATEPART(HOUR, GETDATE());

IF (@CurrHour IS NOT NULL AND @CurrHour BETWEEN 12 AND 23)
BEGIN
	//system do work
END

[ch265410]

引用：
最初由chipno0p发表 查看帖子
您可以轻松使用过滤器进行管理
完全没有必要。

您基本上可以创建一个现在在许多服务器中都存在的作业系统。系统将在玩家下达交易并重新启动角色后奖励玩家 。您可以设置系统时间，例如：
码：
DECLARE @CurrHour TINYINT ;
SELECT @CurrHour = DATEPART （HOUR ，GETDATE （））;

IF （@CurrHour IS NOT NULL和@CurrHour 之间的12 和23 ）BEGIN //系统做工作END


A syntax error occurred

[PortalDark]

#moved

[ch265410]

How do you write the grammar?