Boa tarde galera, por um acaso alguem ja viu fala dessa query (WZ_CustomMonsterReward) ou tem essa query para partilhar???? se alguem poder dar uma luz agradeco..
abraco 4i20
Boa tarde galera, por um acaso alguem ja viu fala dessa query (WZ_CustomMonsterReward) ou tem essa query para partilhar???? se alguem poder dar uma luz agradeco..
abraco 4i20
Last edited by Mentor; 25/06/2019 at 08:49 PM.
Fica nas procedures...
eu tbm queria ela
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_CustomMonsterReward] Script Date: 14/05/2016 02:12:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE Procedure [dbo].[WZ_CustomMonsterReward]
@Account varchar(10),
@Name varchar(10),
@MonsterClass int,
@MapNumber int,
@RewardValue1 int,
@RewardValue2 int
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON
UPDATE PcPointData SET PcPoint=PcPoint+@RewardValue1 WHERE AccountID=@Account
SET NOCOUNT OFF
SET XACT_ABORT OFF
END
qual é a função dessa query?USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_CustomMonsterReward] Script Date: 14/05/2016 02:12:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE Procedure [dbo].[WZ_CustomMonsterReward]
@Account varchar(10),
@Name varchar(10),
@MonsterClass int,
@MapNumber int,
@RewardValue1 int,
@RewardValue2 int
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON
UPDATE PcPointData SET PcPoint=PcPoint+@RewardValue1 WHERE AccountID=@Account
SET NOCOUNT OFF
SET XACT_ABORT OFF
END
use [muonline]
go
/****** object: Storedprocedure [dbo].[wz_custommonsterreward] script date: 14/05/2016 02:12:42 ******/
set ansi_nulls on
go
set quoted_identifier on
go
create procedure [dbo].[wz_custommonsterreward]
@account varchar(10),
@name varchar(10),
@monsterclass int,
@mapnumber int,
@rewardvalue1 int,
@rewardvalue2 int
as
begin
set nocount on
set xact_abort on
update pcpointdata set pcpoint=pcpoint+@rewardvalue1 where accountid=@account
set nocount off
set xact_abort off
end
esta query esta incompleta!! Favor tem como postar ela completa, para podermos modificar a mesma...
Ta completa, tirei do Meu Servidor
Pra que serve essa query?
voce tem q dar um drop para colocar ela. pois ja existe a sua.
tenta assim
use [muonline]
go
drop procedure [dbo].[wz_custommonsterreward]
go
/****** object: Storedprocedure [dbo].[wz_custommonsterreward] script date: 14/05/2016 02:12:42 ******/
set ansi_nulls on
go
set quoted_identifier on
go
create procedure [dbo].[wz_custommonsterreward]
@account varchar(10),
@name varchar(10),
@monsterclass int,
@mapnumber int,
@rewardvalue1 int,
@rewardvalue2 int
as
begin
set nocount on
set xact_abort on
update pcpointdata set pcpoint=pcpoint+@rewardvalue1 where accountid=@account
set nocount off
set xact_abort off
end
Last edited by TonyAMT; 14/05/2016 at 03:59 PM.