Sending Coins

02/14/2010 20:51 EliteWarrior#1

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:mofo:

02/14/2010 21:23 janvier123#2

OsDs has it

02/14/2010 21:36 EliteWarrior#3

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);

02/14/2010 21:40 janvier123#4

One by one

02/14/2010 21:48 freeskier4lif3#5

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

Code:

USE [cash];
GO

UPDATE dbo.user_cash
SET amount = amount +500

02/14/2010 22:44 EliteWarrior#6

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.