Advertisement
vitas13

CustomMonsterReward

Mar 19th, 2016
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. USE [MuOnline]
  2. GO
  3. /****** Object: StoredProcedure [dbo].[WZ_CustomMonsterReward] Script Date: 06/04/2018 19:52:48 ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8.  
  9. ALTER Procedure [dbo].[WZ_CustomMonsterReward]
  10. @Account varchar(10),
  11. @Name varchar(10),
  12. @MonsterClass int,
  13. @MapNumber int,
  14. @RewardValue1 int,
  15. @RewardValue2 int
  16. AS
  17. BEGIN
  18.  
  19. SET NOCOUNT ON
  20. SET XACT_ABORT ON
  21.  
  22. UPDATE CashShopData SET WCoinP=WCoinP+@RewardValue1 WHERE AccountID=@Account
  23.  
  24. SET NOCOUNT OFF
  25. SET XACT_ABORT OFF
  26.  
  27. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement