Query WZ_CustomMonsterReward...

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

Fica nas procedures...

eu tbm queria ela

Citação:

---

Originally Posted by richardj [Only registered and activated users can see links. Click Here To Register...]

eu tbm queria ela

---

a query de premiacao da arena ate consegui, mais essa dos monster ta dificil...

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

Citação:

---

Originally Posted by lorranmota [Only registered and activated users can see links. Click Here To Register...]

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?

Citação:

---

Originally Posted by lorranmota [Only registered and activated users can see links. Click Here To Register...]

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 :D

Pra que serve essa query?

Citação:

---

Originally Posted by lorranmota [Only registered and activated users can see links. Click Here To Register...]

Ta completa, tirei do Meu Servidor :D

---

Desculpe da completa mesmo, mais nao consigo executa ela, fala q a procedure ja existe sendo q nem tenho ela, vc sebe o q pode esstar acontecendo?, ou onde posso localizar essa procedure do meu server e modificar...

obg deste ja


abraco 4i20

[Only registered and activated users can see links. Click Here To Register...]
imagem do erro no sql

voce tem q dar um drop para colocar ela. pois ja existe a sua.
tenta assim

Citação:

---

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

---

Qual a utilidade dessa Query?