ctgwglzc 发表于 2011-9-17 12:59:36

Fix a broken King /prize command

The stored procedureCREATE PROCEDURE .
      @byType tinyint,
      @byNation tinyint,
      @nAmount int,
      @strUserID char(21)
AS
UPDATE KING_SYSTEM SET nNationalTreasury = nNationalTreasury - @nAmount WHERE byNation = @byNationALTER PROCEDURE .
      @byType tinyint,
      @byNation tinyint,
      @nAmount int,
      @strUserID char(21)
AS
UPDATE KING_SYSTEM SET nNationalTreasury = nNationalTreasury - @nAmount WHERE byNation = @byNation

ctgwglzc 发表于 2011-9-17 13:00:01

UPDATE SERVER_RESOURCE SET strResource = 'The Karus King has awarded %s with %d coins' WHERE nResourceID = 210
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)

雪皓松松 发表于 2011-9-17 21:37:34

这个是关于骑士什么的？
页: [1]
查看完整版本: Fix a broken King /prize command