Genel Araştırma

bulun ve değiştirin CREATE PROCEDURE [dbo].[KING_INSERT_PRIZE_EVENT] @byType tinyint, @byNation tinyint, @nAmount int, @strUserID char(21) AS UPDATE KING_SYSTEM SET nNationalTreasury = nNationalTreasury - @nAmount WHERE byNation = @byNation eğer bulup değiştiremiyorsanız aşağıdaki sql kodunu query olarak uygulayın ALTER PROCEDURE [dbo].[KING_INSERT_PRIZE_EVENT] @byType tinyint, @byNation tinyint, @nAmount int, @strUserID char(21) AS UPDATE KING_SYSTEM SET nNationalTreasury = nNationalTreasury - @nAmount WHERE byNation = @byNation son olarak Problem is that they're in the reverse order in a lot of databases; these queries should fix that: 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 twostars