[Release] [SQL QUERY] Manual Insert Premium Service.
SQL Query for newbie who want to input Premium Service and Cashshop manualy from SQL management Studio
Code:
/****** Script Owner : Hanry Roslaw Saputra ******/
/****** Created by : Hanry Roslaw Saputra ******/
/****** Tanggal Pembuatan : 18-07-2012 ******/
/****** Script ini hanya berlaku di 2.2.3.2 Golden Age ******/
DECLARE @name VARCHAR(13)
DECLARE @pw VARCHAR(13)
DECLARE @Birth smalldatetime
DECLARE @email nvarchar(50)
DECLARE @status int
DECLARE @cash int
/****** Nama Loe ******/
SET @name = 'nathan'
/****** Password Loe ******/
SET @pw = 'lingkungan'
/****** Tanggal Lahir Loe ******/
SET @Birth = '07-22-1980'
/****** Email Loe ******/
SET @email = 'natanael2207@gmail.com'
/****** Set 1 untuk jadi normal dan Set 2 untuk jadi premium ******/
SET @status = '2'
/****** Jumlah Cash yg mau di isi ******/
SET @cash = '1000000'
/************************************************************************************************************************************************/
BEGIN
INSERT INTO [RF_USER].[dbo].[tbl_rfaccount]
(
[id],
[password],
[birthdate],
[Email]
)
VALUES
(
CONVERT(BINARY(13) @name),
CONVERT(BINARY(13),@pw),
@Birth,
@email
)
INSERT INTO [BILLING].[dbo].[tbl_UserStatus]
(
[id],
[Status],
[DTStartPrem],
[DTEndPrem],
[Cash]
)
VALUES
(
@name,
@status,
CONVERT(datetime,GETDATE()),
CONVERT(datetime,GETDATE()+3),
@cash
)
END
/*************************************************************************************************************************************************/
Re: [Release] [SQL QUERY] Manual Insert Premium Service.
be aware for GETDATE in php function.
Re: [Release] [SQL QUERY] Manual Insert Premium Service.
thanks mr gingerman aka roslaw
love you till bass drop is forbidden
Re: [Release] [SQL QUERY] Manual Insert Premium Service.
it's for rf 2.2.3 BSB ?
and it's for new id ? if yes can old id make to premium service ?
=================================
ini untuk rf 2.2.3 BSB?
dan apakah itu untuk membuat id baru ? kalo iya
bagai mana jika untuk id lama ?? bisakan d buat jadi premium juga ?
Re: [Release] [SQL QUERY] Manual Insert Premium Service.
Quote:
Originally Posted by
devnaya23
it's for rf 2.2.3 BSB ?
and it's for new id ? if yes can old id make to premium service ?
=================================
ini untuk rf 2.2.3 BSB?
dan apakah itu untuk membuat id baru ? kalo iya
bagai mana jika untuk id lama ?? bisakan d buat jadi premium juga ?
for old account re-registrasy for create premium account, with id same,,,
Re: [Release] [SQL QUERY] Manual Insert Premium Service.
This is for 2232 not for 223 it won't work for you if you are using BillCrux
Re: [Release] [SQL QUERY] Manual Insert Premium Service.
Quote:
Originally Posted by
Busman
This is for 2232 not for 223 it won't work for you if you are using BillCrux
ok thank you bust man
Re: [Release] [SQL QUERY] Manual Insert Premium Service.
yeah,,old user can have premium service :)
just modify your methode..look @ auto cash by time play thread
Re: [Release] [SQL QUERY] Manual Insert Premium Service.
why i cant see the userstatus in my billing?
Re: [Release] [SQL QUERY] Manual Insert Premium Service.
Quote:
Originally Posted by
Michael Quisoy
why i cant see the userstatus in my billing?
Look @ roslaw thread for auto cashop.
I think have query for user status
Send From My Xperia Using Tapatalk 2
Re: [Release] [SQL QUERY] Manual Insert Premium Service.
If u want to check status Premoium Service
U can use this Query
Code:
USE [Billing]
GO
DECLARE @ret char(1)
EXEC [dbo].[RF_ActivatePremium]
@userID = N'LOGIN',
@months = 1,--the number of months (1 to 255)
@ret = @ret OUTPUT -- returns T (True) if all goes well, or F (False) if there is no such login
SELECT @ret as N @ret'
GO
Re: [Release] [SQL QUERY] Manual Insert Premium Service.
