Cash Query - Add Cash Online Player

[second2nd]

Can someone make this works? it seems i cant do it properly, it said my query successful and several line affected, but no changes whatsoever

USE [dnmembership]
GO

declare @cash int


set @cash = '1000'

insert into cashincome (AccountID,CashIncomeCode,CashAmount,Incomedate)
Select DNAuth.AccountDBID,'2',@cash,Getdate() from DNAuth
where DNAuth.CertifyingStep = 2;

GO

 

[Kurtivan23]

Can someone make this works? it seems i cant do it properly, it said my query successful and several line affected, but no changes whatsoever

Question, are you using 2126 or 2783?



wait let me fix it for you if you are using 2126



where is the values?

[CENTER]USE [DNMembership]

[/CENTER]
GO
 DECLARE    @[I][B][URL="https://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h int
SET    @[I][B][URL="https://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h = '1000'

INSERT INTO [dbo].[CashIncome]

(
     AccountID
    ,CashIncomeCode
    ,PGCode
    ,PGKey
    ,CashAmount
    ,IncomeDate
)

SELECT DNAuth.AccountDBID, 0, 0, 0,    @[I][B][URL="https://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h, GETDATE() FROM [dbo].[DNAUth] WHERE CertifyingStep = 2;

2783 Online Cash

[COLOR=#B9BBBE]USE [DNMembership]

 GO

UPDATE dbo.Accounts [/COLOR][COLOR=#859900]SET[/COLOR][COLOR=#B9BBBE] cash [/COLOR][COLOR=#B9BBBE]=[/COLOR][COLOR=#2AA198]10 /*[/COLOR]<--- (cash Value)*/ [COLOR=#B9BBBE]+[/COLOR][COLOR=#B9BBBE] cash [/COLOR][COLOR=#859900]FROM[/COLOR][COLOR=#B9BBBE] dbo.Accounts [/COLOR][COLOR=#859900]INNER[/COLOR][COLOR=#859900]JOIN[/COLOR][COLOR=#B9BBBE] dbo.DNAuth [/COLOR][COLOR=#859900]ON[/COLOR][COLOR=#B9BBBE] dbo.Accounts.AccountName [/COLOR][COLOR=#B9BBBE]=[/COLOR][COLOR=#B9BBBE] dbo.DNAuth.AccountName [/COLOR][COLOR=#859900]WHERE[/COLOR][COLOR=#B9BBBE] dbo.DNAuth.CertifyingStep [/COLOR][COLOR=#B9BBBE]=[/COLOR][COLOR=#2AA198]2[/COLOR]

 

[second2nd]

wow thanks for helping.

I will try all these codes and inform you which one is working. thanks