Send cash for all player

[dhenmas210]

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

[MentaL]

[nughi]

just insert into table cash

[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

[AsliJowo]

LoL its your program ?

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

[reiza48]

LoL its your program ?

from you bro

[dhenmas210]

Thank you for sharing..

[nughi]

Simple one

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

[dhenmas210]

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..?

[nughi]

If wanna create a code coupons..?

You can use in game feature to trace it

[lightryuk12]

Can you Explain this Agent??

Simple one

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

[nughi]

Can you Explain this Agent??

basicly like this

https://ibb.co/N327Sqg

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

[lightryuk12]

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

basicly like this

https://ibb.co/N327Sqg

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

[nughi]

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

[dhenmas210]

Solved

[Gretek]

Solved

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

[dhenmas210]

Php script

[Gretek]

Php script

Yes i know it's on cash folder (balance & payment.php), but i think there is more line of code to connect to database.
i have changed MakeResponse("S000",$id,99999999); to MakeResponse("S000",$id,$balance); but changed to 0.
Already changed cash field on Account table (dnmembership), but still 0,,,

Any clue sir,, ?

[dhenmas210]

Dnmembership, Functions, add cash

[Gretek]

Dnmembership, Functions, add cash

Did you have php file for reading cash amount from database ?
It's no use if i change/add cash on database, but the game can't read value from database,,,

[dhenmas210]

I don't know, I don't have that's.
In my database all players have "0" cash. But ingame they have a lot cash.

[Gretek]

I don't know, I don't have that's.
In my database all players have "0" cash. But ingame they have a lot cash.

No, i mean php files on WWW/cash folder and WWW/member/2 folder too,,,
For database, i think im using the same databse as you,,,