• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

[RELEASE] Cash Coin for 2.2.3.2 (DB Included)

Newbie Spellweaver
Joined
Jun 3, 2014
Messages
18
Reaction score
1
You know exactly what to do with these files.

Download file:


DB file is RusBill, ZoneServer used = RU.

SQL Query:
Code:
DECLARE @[I][B][URL="http://forum.ragezone.com/members/1333344765.html"]name[/URL][/B][/I] VARCHAR(13)DECLARE @pw VARCHAR(13)
DECLARE @[I][B][URL="http://forum.ragezone.com/members/848971.html"]Birth[/URL][/B][/I] smalldatetime
DECLARE @[I][B][URL="http://forum.ragezone.com/members/213273.html"]email[/URL][/B][/I] varchar(255)
DECLARE @status int
DECLARE @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h int
DECLARE @BCodeTU tinyint
DECLARE @[I][B][URL="http://forum.ragezone.com/members/2000147291.html"]Lam[/URL][/B][/I]a int


/****** Nama Loe ******/
SET @[I][B][URL="http://forum.ragezone.com/members/1333344765.html"]name[/URL][/B][/I] = 'roslaw01'


/****** Password Loe ******/
SET @pw = 'roslaw123'


/****** Tanggal Lahir Loe ******/
SET @[I][B][URL="http://forum.ragezone.com/members/848971.html"]Birth[/URL][/B][/I] = '07-22-1987'


/****** Email Loe ******/
SET @[I][B][URL="http://forum.ragezone.com/members/213273.html"]email[/URL][/B][/I] = 'roslaw.it@gmail.com'
SET @BCodeTU = '1'


/****** Set 1 untuk jadi normal dan Set 2 untuk jadi premium ******/
SET @status = '2'


/****** Set untuk menentukan berapa lama Preium service berlaku saat pertama x di add ******/
SET @[I][B][URL="http://forum.ragezone.com/members/2000147291.html"]Lam[/URL][/B][/I]a = '2'


/****** Jumlah Cash yg mau di isi ******/
SET @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h = '1000'


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


INSERT INTO [RF_USER].[dbo].[tbl_rfaccount] 
(
[id],
[password],
[birthdate],
[BCodeTU],
[Email]
)
VALUES
(
CONVERT(BINARY(13) @[I][B][URL="http://forum.ragezone.com/members/1333344765.html"]name[/URL][/B][/I]),
CONVERT(BINARY(13),@pw), @[I][B][URL="http://forum.ragezone.com/members/848971.html"]Birth[/URL][/B][/I],
@BCodeTU, @[I][B][URL="http://forum.ragezone.com/members/213273.html"]email[/URL][/B][/I]
)


INSERT INTO [BILLING].[dbo].[tbl_UserStatus] 
(
[id],
[Status],
[DTStartPrem],
[DTEndPrem],
[Cash]
)
VALUES
( @[I][B][URL="http://forum.ragezone.com/members/1333344765.html"]name[/URL][/B][/I],
@status,
CONVERT(datetime,GETDATE()),
CONVERT(datetime,GETDATE() @[I][B][URL="http://forum.ragezone.com/members/2000147291.html"]Lam[/URL][/B][/I]a), @[I][B][URL="http://forum.ragezone.com/members/315880.html"]cas[/URL][/B][/I]h
)

or this

Code:
/****** Script Owner : Hanry Roslaw Saputra ******//****** Created by : Hanry Roslaw Saputra ******/


DECLARE [USER=1333344765]name[/USER] VARCHAR(13)
DECLARE @pw VARCHAR(13)
DECLARE @status int
DECLARE [USER=315880]cas[/USER]h int
DECLARE [USER=2000147291]Lam[/USER]a int
DECLARE [USER=848971]Birth[/USER] smalldatetime


/****** Your Name ******/
SET [USER=1333344765]name[/USER] = 'bbccxx'


/****** Your Password ******/
SET @pw = 'test'


/****** Tanggal Lahir Loe ******/
SET [USER=848971]Birth[/USER] = '07-22-1987'


/****** Set 2 for turn on Premium or Set 1 for turn off Premium  ******/
SET @status = '2'


/****** How long players get premium service (in days) exemple : 1 for 1 days, 2 for 2 days, 3 for 3days. ******/
SET [USER=2000147291]Lam[/USER]a = '5'


/****** Cashpoint amount ******/
SET [USER=315880]cas[/USER]h = '100000'


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


INSERT INTO [RF_USER].[dbo].[tbl_rfaccount] 
    (
        [id],
        [password],
        [birthdate]
    )
    VALUES
    (
        CONVERT(BINARY(13) [USER=1333344765]name[/USER]),
        CONVERT(BINARY(13),@pw),
        [USER=848971]Birth[/USER]
    )


INSERT INTO [BILLING].[dbo].[tbl_UserStatus] 
    (
        [id],
        [Status],
        [DTStartPrem],
        [DTEndPrem],
        [Cash]
    )
    VALUES
    (
        [USER=1333344765]name[/USER],
        @status,
        CONVERT(datetime,GETDATE()),
        CONVERT(datetime,GETDATE() [USER=2000147291]Lam[/USER]a),
        [USER=315880]cas[/USER]h
    )


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

use your own RF_User DB.

all credit goes to bang Roslaw and others. forgot about the DB credit LOL.
 

Attachments

You must be registered for see attachments list
Last edited:
Back
Top