Send cash for all player

Hi guys , please explain how to send cash to all member..
Thank you..

just insert into table cash

ALTER PROCEDURE [dbo].[_ALL_PLAYER_CASH_ADD_]

@IntCashAmount nvarchar (10)

AS
/**For Looping**/

DECLARE @accountID int = 0
DECLARE @SelectPlayer int = (SELECT max(AccountID) FROM accounts);
DECLARE @totalPlayer int = @SelectPlayer + 1;

/**For Looping**/
DECLARE @accountName nvarchar (50)

/**For Looping**/
WHILE @accountID <= @totalPlayer
/**For Looping**/
BEGIN
/**For Looping**/
SET @accountID = @accountID + 1;
SET @accountName = (SELECT AccountName FROM Accounts where AccountID @accountID);
/**For Looping**/
EXEC dnmembership.dbo.P_AddCashIncome
@accountName
, 2
, NULL
, NULL
, @IntCashAmount
, 0

END

LoL its your program ?

Quote:

---

Originally Posted by reiza48

ALTER PROCEDURE [dbo].[_ALL_PLAYER_CASH_ADD_]

@IntCashAmount nvarchar (10)

AS
/**For Looping**/

DECLARE @accountID int = 0
DECLARE @SelectPlayer int = (SELECT max(AccountID) FROM accounts);
DECLARE @totalPlayer int = @SelectPlayer + 1;

/**For Looping**/
DECLARE @accountName nvarchar (50)

/**For Looping**/
WHILE @accountID <= @totalPlayer
/**For Looping**/
BEGIN
/**For Looping**/
SET @accountID = @accountID + 1;
SET @accountName = (SELECT AccountName FROM Accounts where AccountID @accountID);
/**For Looping**/
EXEC dnmembership.dbo.P_AddCashIncome
@accountName
, 2
, NULL
, NULL
, @IntCashAmount
, 0

END

---

Quote:

---

Originally Posted by AsliJowo

LoL its your program ?

---

from you bro

Thank you for sharing..

Simple one

Quote:

---

use dnmembership
INSERT CashIncome ( [AccountID], [CashIncomeCode], [PGCode], [PGKey], [CashAmount], [IncomeDate])
select AccountID ,'2' ,NULL ,NULL ,'your amount here' ,GETDATE() from Accounts

---

if you wanna make it scheduled just use agent
note = you can modified with only online user which can received

Quote:

---

Originally Posted by nughi

Simple one

if you wanna make it scheduled just use agent
note = you can modified with only online user which can received

---

If wanna create a code coupons..?

Quote:

---

Originally Posted by dhenmas210

If wanna create a code coupons..?

---

You can use in game feature to trace it

Can you Explain this Agent??

Quote:

---

Originally Posted by nughi

Simple one

if you wanna make it scheduled just use agent
note = you can modified with only online user which can received

---

Quote:

---

Originally Posted by lightryuk12

Can you Explain this Agent??

---

basicly like this
https://ibb.co/N327Sqg
https://ibb.co/N327Sqg

you can choose which one to execute, use tsql or cmdexe
and you can add detailed schedule at schedule tab

Complete Info please..still no idea... yes i know where to do that Agent.. but how to do it?? like puting code command ect,,..

Quote:

---

Originally Posted by nughi

basicly like this
https://ibb.co/N327Sqg
https://ibb.co/N327Sqg

you can choose which one to execute, use tsql or cmdexe
and you can add detailed schedule at schedule tab

---

https://docs.microsoft.com/en-us/sql...l-server-ver15

Solved

Quote:

---

Originally Posted by dhenmas210

Solved

---

How to read cash amount from database ?
So cash amount not static 9999999