[ Release ] Set, Update Cash Coin & Premium Services 2.2.3.2

[gabidon]

Hello everyone, i want to share a 3 Type of SQL Code to inject Premium Service & Cash Coin

use your own RF_User DB.
Tested on : 2.2.3.2

• Set Cash Coin
• Update Cash Coin
• Set Premium Services

This code is created by Roslaw, i just modified it.
code credits : Hanry Roslaw Saputra

Set Cash Coin

Spoiler

This code is used when you want to set the value of the cash coin.

example:
Early Cash Value Coin: 10,000
Value inserted into SQL: 5,000
Cash Value Coin after the set: 5,000

I usually use this if there are mistakes Cash Coin purchases.

/****** SET CASH SHOP COIN ******/
/****** Script Owner : Hanry Roslaw Saputra ******/
USE BILLING

DECLARE [USER=1333344765]name[/USER] VARCHAR(13)
DECLARE [USER=315880]cas[/USER]h int

SET [USER=1333344765]name[/USER] = 'roslaw' /* ID game */

SET [USER=315880]cas[/USER]h = '0' /* Set Value of CashCoin */

/************************************************************************************************************************************************/
BEGIN

	update [BILLING].[dbo].[tbl_UserStatus]
	set [Cash] = [USER=315880]cas[/USER]h 
	where id = CONVERT(BINARY, [USER=1333344765]name[/USER])
	
end

/*************************************************************************************************************************************************/

Update Cash Coin

Spoiler

This code is used when you want to update the cash value of the coin.

example:
Early Cash Value Coin: 10,000
Value inserted into SQL: 5,000
Cash Value Coin after set: 15,000

This usually happens when there is a Cash Coin purchases.

/****** UPDATE CASH SHOP COIN ******/
/****** Script Owner : Hanry Roslaw Saputra ******/
USE BILLING

DECLARE [USER=1333344765]name[/USER] VARCHAR(13)
DECLARE [USER=315880]cas[/USER]h int
DECLARE @buy int

SET [USER=1333344765]name[/USER] = 'roslaw01' /* ID game */

SET @buy = '400000' /* Set Value of payment */
SELECT [USER=315880]cas[/USER]h = Cash from tbl_UserStatus where id = [USER=1333344765]name[/USER]

/************************************************************************************************************************************************/
BEGIN

	update [BILLING].[dbo].[tbl_UserStatus]
	set [Cash] = [USER=315880]cas[/USER]h + @buy
	where id = CONVERT(BINARY, [USER=1333344765]name[/USER])
	
end

/*************************************************************************************************************************************************/

Set Premium Services

Spoiler

Code ini digunakan apabila anda mendapatkan pembelian PREMIUM SERVICE.

Apabila anda menset Premium Service Sebelumnya adalah Lama = 30, lalu anda execute lagi dengan value Lama = 90 maka ID tersebut akan mendapatkan Premium Service Selama 120 hari.

/****** Script Owner : Hanry Roslaw Saputra ******/
/****** PURCHASEMENT OF PERMIUM SERVICES ******/
DECLARE [USER=1333344765]name[/USER] VARCHAR(13)
DECLARE [USER=1333337597]Status[/USER] int
DECLARE [USER=315880]cas[/USER]h int
DECLARE [USER=2000147291]Lam[/USER]a int

SET [USER=1333344765]name[/USER] = 'roslawit' /* ID game */

SET [USER=1333337597]Status[/USER] = '2' /* 1 for Standard | 2 for Premium */

SET [USER=2000147291]Lam[/USER]a ='30' /* Duration of Premium Services ( days ) */

/************************************************************************************************************************************************/
BEGIN

	update [BILLING].[dbo].[tbl_UserStatus]
	set [Status] =  [USER=1333337597]Status[/USER],
	[DTStartPrem] = CONVERT(datetime,GETDATE()),
	[DTEndPrem] = CONVERT(datetime,GETDATE() [USER=2000147291]Lam[/USER]a)
	where id = CONVERT(BINARY, [USER=1333344765]name[/USER])
	
end

/*************************************************************************************************************************************************/

 

[d1m45135]

Msg 102, Level 15, State 1, Line 20Incorrect syntax near '@Lama'.

 

[hendrigo]

When I log in the game, i got my db back to 1... what is going on?