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:
or this
use your own RF_User DB.
all credit goes to bang Roslaw and others. forgot about the DB credit LOL.
Download file:
You must be registered to see links
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: