Quote:
--v1.0
-- CashPoints for kills
DECLARE @AccUID INT
DECLARE @CashPoint INT
-- set AccountUniqueNumber
SET @AccUID = (SELECT AccountUniqueNumber FROM atum2_db_1.dbo.td_Character WHERE UniqueNumber = @UniqueNumber)
-- set the cashpoints
SET @CashPoint = (SELECT CashPoint FROM atum2_db_account.dbo.td_Account WHERE AccountUniqueNumber = @AccUID) + 10
-- update the cashpoints
UPDATE atum2_db_account.dbo.td_Account SET CashPoint = @CashPoint WHERE AccountUniqueNumber = @AccUID
--V2.0
-- update the cashpoints
UPDATE atum2_db_account.dbo.td_Account
SET CashPoint = ((SELECT CashPoint FROM atum2_db_account.dbo.td_Account WHERE AccountUniqueNumber = (SELECT AccountUniqueNumber FROM atum2_db_1.dbo.td_Character WHERE UniqueNumber = @UniqueNumber)) + 10)
WHERE AccountUniqueNumber = (SELECT AccountUniqueNumber FROM atum2_db_1.dbo.td_Character WHERE UniqueNumber = @UniqueNumber)