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:
Código: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:
Código: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 OFFEND
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
Código: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