The stored procedure

1. CREATE PROCEDURE [dbo].[KING_INSERT_PRIZE_EVENT]
   
2.         @byType tinyint,
   
3.         @byNation tinyint,
   
4.         @nAmount int,
   
5.         @strUserID char(21)
   
6. AS
   
7. UPDATE KING_SYSTEM SET nNationalTreasury = nNationalTreasury - @nAmount WHERE byNation = @byNation

复制代码

1. ALTER PROCEDURE [dbo].[KING_INSERT_PRIZE_EVENT]
   
2.         @byType tinyint,
   
3.         @byNation tinyint,
   
4.         @nAmount int,
   
5.         @strUserID char(21)
   
6. AS
   
7. UPDATE KING_SYSTEM SET nNationalTreasury = nNationalTreasury - @nAmount WHERE byNation = @byNation

复制代码

1. UPDATE SERVER_RESOURCE SET strResource = 'The Karus King has awarded %s with %d coins' WHERE nResourceID = 210
   
2. UPDATE SERVER_RESOURCE SET strResource = 'The El Morad King has awarded %s with %d coins' WHERE nResourceID = 213

复制代码

发奖命令
- %s (character name - prize recipient)
- %d (money given)

这个是关于骑士什么的？