Jump to content
Sign in to follow this  
Антон

LotterySystem

Recommended Posts

Всем доброго утра!

 

Здоровья, добра и мирного неба над головой )

При запуске гс следующая ошибка.

Ошибка

В skilleffect данного аддона не добавлено.

Нигде не могу найти где он включен.

Заранее благодарю.

Share this post


Link to post
Share on other sites

Привет, @Антон!

 

Попробуй выполнить следующий SQL-запрос в Microsoft SQL Server Management Studio:

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

USE GameDB

CREATE TABLE [dbo].[LotterySetting](
[section] [smallint] NOT NULL,
[issue] [smallint] NOT NULL,
[state] [smallint] NOT NULL,
[createdate] [datetime] NOT NULL,
[updatetime] [datetime] NULL,
[itemno] [nvarchar](50) NULL,
CONSTRAINT [PK_LotterySetting] PRIMARY KEY CLUSTERED
(
[section] ASC,
[issue] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'服务器分区' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LotterySetting', @level2type=N'COLUMN',@level2name=N'section'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'期号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LotterySetting', @level2type=N'COLUMN',@level2name=N'issue'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态:0 当前期 1 往期 2 作废期 ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LotterySetting', @level2type=N'COLUMN',@level2name=N'state'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LotterySetting', @level2type=N'COLUMN',@level2name=N'createdate'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新时间戳' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'LotterySetting', @level2type=N'COLUMN',@level2name=N'updatetime'
GO

 

  • Like 1

Share this post


Link to post
Share on other sites
5 hours ago, Антон said:

Lottery убралось, помогло.

Появилось новая проблема (

Ticket

Попробуй взять базы данных из сборки PKO 1.38, либо поискать на форуме SQL-запрос, который создаст таблицу "Ticket" в GameDB (по тексту ошибки).

 

 


Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...