Resolvendo Alguns Erro Repack S8 By Louis

[HorrorStory]

Vamos la, bom arrumei meu server +- enfim resolvi postar aki algumas coisas que vao ajudar voces a corrigir erro no server de voces --' as vezes o erro chega ser tao besta.

ERRO JOB PREMIAR TOPS:

CREATE Procedure [dbo].[PREMIAR_TOPS]
account[/MENTION] varchar(10),
@Name varchar(10),
@WC int,
@WP int,
@GP int,
@XP int,
@VIP1 int,
@VIP2 int,
@VIP3 int,
@EVENTOS int
AS
BEGIN

SET NOCOUNT ON
SET XACT_ABORT ON

[Only registered and activated users can see links]
BEGIN
UPDATE CashShopData
[Only registered and activated users can see links]
END

[Only registered and activated users can see links]
BEGIN
[Only registered and activated users can see links]
END

[Only registered and activated users can see links]
BEGIN
UPDATE Character
[Only registered and activated users can see links]
END

[Only registered and activated users can see links]
BEGIN
-- ADD VIP NA CONTA VIP_AL1
[Only registered and activated users can see links]
-- ADD VIP NA CONTA VIP_AL0
[Only registered and activated users can see links]

if (select COUNT(*) from MEMB_INFO where memb___id = account and AccountLevel = 1) > 0
[Only registered and activated users can see links]
END

[Only registered and activated users can see links]
BEGIN
-- ADD VIP NA CONTA VIP_AL2
[Only registered and activated users can see links]

if (select COUNT(*) from MEMB_INFO where memb___id = account and AccountLevel = 2) > 0
[Only registered and activated users can see links]
END

[Only registered and activated users can see links]
BEGIN
-- ADD VIP NA CONTA VIP_AL3
[Only registered and activated users can see links]

if (select COUNT(*) from MEMB_INFO where memb___id = account and AccountLevel = 3) > 0
[Only registered and activated users can see links]
END
End

Fenix Nao Conta No Site:





USE [MuOnline]GO
/****** Object: StoredProcedure [dbo].[WZ_CustomMonsterReward] Script Date: 05/04/2017 23:38:03 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER Procedure [dbo].[WZ_CustomMonsterReward]
account[/MENTION] varchar(10),
@Name varchar(10),
@MonsterClass int,
@MapNumber int,
@RewardValue1 int,
@RewardValue2 int
AS
BEGIN


SET NOCOUNT ON
SET XACT_ABORT ON


[Only registered and activated users can see links]


[Only registered and activated users can see links]
begin
[Only registered and activated users can see links]
end
SET NOCOUNT OFF
SET XACT_ABORT OFF



END


MK_QUEST ERRO:
BOM :V ESSE JA FICA 1 POCO CHATO MAS.. VAMO LA, CARA ESSE FOI A FORMA QUE EU ACHEI DE RESOLVER OK? SE ALGUEM SOUBER OUTRA POSTAR PORFAVOR ;-; VAMOS LA

1- CRIE OUTRA DB COM O NOME QUAL QUER 123 SLA
2- VAI EM NEW QUERY RODE ESSA QUERY NELE



CREATE TABLE [dbo].[MK_Quest](
[Name] [nvarchar](10) NOT NULL,
[quest1] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest1] DEFAULT ((0)),
[quest2] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest2] DEFAULT ((0)),
[quest3] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest3] DEFAULT ((0)),
[quest4] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest4] DEFAULT ((0)),
[quest5] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest5] DEFAULT ((0)),
[quest6] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest6] DEFAULT ((0)),
[quest7] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest7] DEFAULT ((0)),
[quest8] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest8] DEFAULT ((0)),
[quest9] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest9] DEFAULT ((0)),
[quest10] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest10] DEFAULT ((0)),
[quest11] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest11] DEFAULT ((0)),
[quest12] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest12] DEFAULT ((0)),
[quest13] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest13] DEFAULT ((0)),
[quest14] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest14] DEFAULT ((0)),
[quest15] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest15] DEFAULT ((0)),
[quest16] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest16] DEFAULT ((0)),
[quest17] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest17] DEFAULT ((0)),
[quest18] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest18] DEFAULT ((0)),
[quest19] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest19] DEFAULT ((0)),
[quest20] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest20] DEFAULT ((0)),
[nivel] [smallint] NOT NULL CONSTRAINT [DF_Quest_nivel] DEFAULT ((0)),
[quest21] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest21] DEFAULT ((0)),
[quest22] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest22] DEFAULT ((0)),
[quest23] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest23] DEFAULT ((0)),
[quest24] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest24] DEFAULT ((0)),
[quest25] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest25] DEFAULT ((0)),
[quest26] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest26] DEFAULT ((0)),
[quest27] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest27] DEFAULT ((0)),
[quest28] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest28] DEFAULT ((0)),
[quest29] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest29] DEFAULT ((0)),
[quest30] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest30] DEFAULT ((0)),
[quest31] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest31] DEFAULT ((0)),
[quest32] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest32] DEFAULT ((0)),
[quest33] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest33] DEFAULT ((0)),
[quest34] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest34] DEFAULT ((0)),
[quest35] [smallint] NOT NULL CONSTRAINT [DF_Quest_quest35] DEFAULT ((0)),
CONSTRAINT [PK_Quest] PRIMARY KEY CLUSTERED
(
[Name] 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
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO



3- VAI NA SUA DB LADO DIREITO DEPOIS VAI EM TASKS>IMPORT DATA
4- NEXT,SERVER NAME(LOCAL) Data Base Name(o nome da db que vc crio)
5-Apenas olhe se esta MuOnline na db depois da next
6- Deixa marcado a 1 opçao da net, ai vai pedir um negocio pra finalizar clica la
7- clica ne continuar algo assim ai via começar a importar a mk_Quest da db que vc crio pra sua db muonline :)