Sending Coins

EliteWarrior · 02/14/2010, 20:51

Can anyone tell me how to send coins(deka coins) without replacing the current coins in the Dshop? I know one command for sql But it replaces the current amount of Dshop coins.

Posted because no post was here about it.

thx

janvier123 · 02/14/2010, 21:23

OsDs has it

EliteWarrior · 02/14/2010, 21:36

To all players? If so im helped

This command if it can be modified to ALL players,dont know how to do it:

Code:

UPDATE
						cash.dbo.user_cash
					SET
						amount = '".$coins."',
						free_amount = '".$coins."'
					WHERE
						user_no = '".$_POST['user_no']."'
					",$ms_con);

janvier123 · 02/14/2010, 21:40

One by one

freeskier4lif3 · 02/14/2010, 21:48

Simply change the "500" to w/e you want to add:

Code:

USE [cash];
GO

UPDATE dbo.user_cash
SET amount = amount +500

EliteWarrior · 02/14/2010, 22:44

I didnt know the + was crucial to Update the current amount,if u dont have the + it sets it to the amount u enter and replaces it.