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]
[B @[Somente membros podem ver os links. ] varchar(10),[/B]
@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

IF @WC > 0 or @WP > 0 or @GP > 0
BEGIN
UPDATE CashShopData 
    SET WCoinC = WCoinC + @WC, WCoinP = WCoinP + @WP, GoblinPoint = GoblinPoint + @GP where AccountID = @[Somente membros podem ver os links. ]
END 

IF @WC > 0
BEGIN
    insert into log_creditos ( login, valor, ip, tipo ) values  @[Somente membros podem ver os links. ],@WC,'1','6')
END

IF @EVENTOS > 0 or @XP > 0
BEGIN 
UPDATE Character 
    SET exp_war = exp_war + @XP, eventos = eventos + @EVENTOS where Name = @Name and AccountID = @[Somente membros podem ver os links. ]
END

IF @VIP1 > 0
BEGIN
    -- ADD VIP NA CONTA VIP_AL1
    update memb_info set AccountExpireDate = AccountExpireDate+@VIP1 where memb___id = @[Somente membros podem ver os links. ] and accountlevel = 1
    -- ADD VIP NA CONTA VIP_AL0
    update memb_info set accountlevel = 1, AccountExpireDate = (getdate())+@VIP1 where memb___id = @[Somente membros podem ver os links. ] and accountlevel = 0

    if (select COUNT(*) from MEMB_INFO where memb___id = @[Somente membros podem ver os links. ] and AccountLevel = 1) > 0
    Insert into log_vip (login,dias,tipo) values  @[Somente membros podem ver os links. ],@VIP1,'6' )
END

if @VIP2 > 0
BEGIN
    -- ADD VIP NA CONTA VIP_AL2
    update memb_info set AccountExpireDate = AccountExpireDate+@VIP2 where memb___id = @[Somente membros podem ver os links. ] and accountlevel = 2

    if (select COUNT(*) from MEMB_INFO where memb___id = @[Somente membros podem ver os links. ] and AccountLevel = 2) > 0
    Insert into log_vip (login,dias,tipo) values  @[Somente membros podem ver os links. ],@VIP2,'7' )
END

if @VIP3 > 0
BEGIN
    -- ADD VIP NA CONTA VIP_AL3
    update memb_info set AccountExpireDate = AccountExpireDate+@VIP3 where memb___id = @[Somente membros podem ver os links. ] and accountlevel = 3

    if (select COUNT(*) from MEMB_INFO where memb___id = @[Somente membros podem ver os links. ] and AccountLevel = 3) > 0
    Insert into log_vip (login,dias,tipo) values  @[Somente membros podem ver os links. ],@VIP3,'8' )
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] 
[COLOR=#111111 @[Somente membros podem ver os links. ] varchar(10),[/COLOR]
@Name varchar(10),
@MonsterClass int,
@MapNumber int,
@RewardValue1 int,
@RewardValue2 int
AS
BEGIN


SET NOCOUNT ON
SET XACT_ABORT ON


UPDATE CashShopData SET GoblinPoint=GoblinPoint+@RewardValue1 WHERE AccountID @[Somente membros podem ver os links. ]


if (@MonsterClass =77)
begin
UPDATE Character SET fenix=fenix+1,eventos=eventos+@RewardValue1,evento s_mensal=eventos_mensal+@RewardValue1,eventos_semanal=eventos_semanal+@RewardValue1 WHERE Name=@Name
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