Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[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