problem with event king season 8

[alexischoque]

I have this problem already inserting the querry of king but just as I throw this error as I solve it


[Only registered and activated users can see links]

[djagripnos]

Run Query sql



USE [MuOnline]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Server_banco_golds]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MK_Server] DROP CONSTRAINT [DF_Server_banco_golds]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Server_votacao]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MK_Server] DROP CONSTRAINT [DF_Server_votacao]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Server_votacao_on]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MK_Server] DROP CONSTRAINT [DF_Server_votacao_on]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Server_rei_do_mk]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MK_Server] DROP CONSTRAINT [DF_Server_rei_do_mk]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Server_min_rei]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MK_Server] DROP CONSTRAINT [DF_Server_min_rei]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Server_ranking_dv]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MK_Server] DROP CONSTRAINT [DF_Server_ranking_dv]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Server_contas]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MK_Server] DROP CONSTRAINT [DF_Server_contas]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Server_contas_vip]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MK_Server] DROP CONSTRAINT [DF_Server_contas_vip]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Server_contas_svip]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MK_Server] DROP CONSTRAINT [DF_Server_contas_svip]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Server_contas_bvip]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MK_Server] DROP CONSTRAINT [DF_Server_contas_bvip]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Server_site_contas_bloc]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MK_Server] DROP CONSTRAINT [DF_Server_site_contas_bloc]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Server_site_compras]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MK_Server] DROP CONSTRAINT [DF_Server_site_compras]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Server_site_guilds]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MK_Server] DROP CONSTRAINT [DF_Server_site_guilds]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Server_site_banidos]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MK_Server] DROP CONSTRAINT [DF_Server_site_banidos]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Server_site_online]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MK_Server] DROP CONSTRAINT [DF_Server_site_online]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Server_resetes_dobro]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MK_Server] DROP CONSTRAINT [DF_Server_resetes_dobro]
END

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_Server_resetes_dobro_tempo]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MK_Server] DROP CONSTRAINT [DF_Server_resetes_dobro_tempo]
END

GO

USE [MuOnline]
GO

/****** Object: Table [dbo].[MK_Server] Script Date: 01/03/2017 01:21:56 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MK_Server]') AND type in (N'U'))
DROP TABLE [dbo].[MK_Server]
GO

CREATE TABLE [dbo].[MK_Server]( [rei_do_mk] [smallint] NOT NULL )
GO

ALTER TABLE [dbo].[MK_Server] ADD CONSTRAINT [DF_Server_rei_do_mk] DEFAULT ((0)) FOR [rei_do_mk]
GO

INSERT INTO MK_SERVER (REI_DO_MK) VALUES (0)

ALTER TABLE GUILD ADD OWNER int DEFAULT (0)
ALTER TABLE GUILD ADD OWNER_TIME int DEFAULT (0)
ALTER TABLE GUILD ADD OWNER_COUNT int DEFAULT (0)
GO

ALTER TABLE GUILDMEMBER ADD EVENT_COUNT int DEFAULT (0)
GO

[louis]

this version of king is old and work with my site only ^^

wait for new update