Cash shop system

**PrinceRay** · 25-04-13

NEED HELP

I Was Succesfully make PREMIUM SERVICE ON..
but Cash Doesnt inserted -_-
I See in game Cash : 0
i dont know why ?.

can anyone help me :(

My configuration :

ACCOUNT Login

Account System.ini

Code:

[Database]
AccountDB_Machine = 127.0.0.1
AccountDB_Name = RF_User

[System]
NationCode = RU

[DB_INFO]
IP = 127.0.0.1
Port = 1433
DSN = BILLING
DBName = BILLING
Acc = sa
PW = password

[Service]
MaxAccountNum = 100000

[World]
WorldSet_Num = 1
ServiceSet_Num = 1

Name0 = RF CASHSHOP
Address0 = 127.0.0.1
DBName0 = RF_World
Type0 = 0

BillingSystem.ini

Code:

[System]
ZoneAddress = 127.0.0.1
NationCode = RU


[BILLING]
SERVER_NAME = BILLING
IP = 127.0.0.1
PORT = 1433
CP_ID = 1
GROUP_NUM = 1
SERVER_NUM = 1
GAME_ID = 1

LoginSystem.ini

Code:

[System]
ZoneAddress = 127.0.0.1
NationCode = RU


[BILLING]
[Account]
AccountAddress = 127.0.0.1

[System]
NationCode = RU

[CHECK ADDRESS]
CHECK = TRUE

[LOG]
AUTH_LOG = TRUE

[World]
Lim World Num = 1
DB Push Job = 0

[BILLING]
Check = TRUE
BillingCode = 32

[MOTP]
Service = FALSE
HostName = 127.0.0.1
HostIP = 127.0.0.1
URLPath = /MOTPValidation/ValidationServlet
Port = 12380

[IP Address Filter]
FilterNum = 2

Filter0 = 192.168.1.0
FilterRange0 = 255
Filter1 = 127.0.0.0
FilterRange1 = 255

[UserCountDisplyLimit]
Limit0 = 100
Limit1 = 300
Limit2 = 500

[BILL_RU]
DSN = BILLING
DBName = BILLING
DBIP = 127.0.0.1
DBAccount = sa
DBPassword = password
DBPort = 1433

Worldinfo.ini

Code:

[System]
WorldName = RF CASHSHOP
GateIP = 127.0.0.1
Address = 127.0.0.1
ServerType = 0

BillingCode = 1
BillOper = 1
FreeServer = 1

HBKPath = D:\Server Game\RF\InitializeFile\Work\HBK
HistoryPath = D:\Server Game\RF\InitializeFile\Work\History
NationCode = RU

[ServerMode]
BuyCashItemByGold = false
ReleaseType = Release
ExcuteService = false

[Rule]
CrystalHPMultiple   = 1.0
CrystalHPMultiple_1 = 5.0
CrystalHPMultiple_2 = 8.0
CrystalHPMultiple_3 = 11.0

[GUILD CREATE EVENT]
Enable = FALSE
START_DATE = 20130101
END_DATE = 20150120

**MentaL**

**IvonaDP** · 25-04-13

at ODBC setting the BILLING connect to Your IP,1433

**PrinceRay** · 25-04-13

Originally Posted by IvonaDP

at ODBC setting the BILLING connect to Your IP,1433

i'm already do that

**IvonaDP** · 25-04-13

try setting initialize LoginSystem.ini

;1 Open 0 Close
[ExternalConnect]
External = 1

[Account]
AccountAddress = 127.0.0.1

[System]
NationCode = RU

[CHECK ADDRESS]
CHECK = TRUE

[LOG]
AUTH_LOG = TRUE

[World]
Lim World Num = 7
DB Push Job = 0

[BILLING]
Check = TRUE
BILLINGCode = 78

[MOTP]
Service = FALSE
HostName = 127.0.0.1
HostIP = 127.0.0.1
URLPath = /MOTPValidation/ValidationServlet
Port = 12380

[IP Address Filter]
FilterNum = 2

Filter1 = 127.0.0.1
FilterRange0 = 255

Filter2 = 192.168.1.1
FilterRange0 = 255

[UserCountDisplyLimit]
Limit0 = 5000
Limit1 = 12000
Limit2 = 27000

[CHI_BILLING]
Addr = 25.4.14.160
Port = 1433
DBName = BILLING
ACC = sa
PW = Your pwd

**PrinceRay** · 26-04-13

Originally Posted by IvonaDP

try setting initialize LoginSystem.ini

;1 Open 0 Close
[ExternalConnect]
External = 1

[Account]
AccountAddress = 127.0.0.1

[System]
NationCode = RU

[CHECK ADDRESS]
CHECK = TRUE

[LOG]
AUTH_LOG = TRUE

[World]
Lim World Num = 7
DB Push Job = 0

[BILLING]
Check = TRUE
BILLINGCode = 78

[MOTP]
Service = FALSE
HostName = 127.0.0.1
HostIP = 127.0.0.1
URLPath = /MOTPValidation/ValidationServlet
Port = 12380

[IP Address Filter]
FilterNum = 2

Filter1 = 127.0.0.1
FilterRange0 = 255

Filter2 = 192.168.1.1
FilterRange0 = 255

[UserCountDisplyLimit]
Limit0 = 5000
Limit1 = 12000
Limit2 = 27000

[CHI_BILLING]
Addr = 25.4.14.160
Port = 1433
DBName = BILLING
ACC = sa
PW = Your pwd

Still Not work sir :(

**ElectricShock** · 26-04-13

post your query for cash / coin

**ammandes** · 26-04-13

electric -_- how about KJ or pela2 or kojem :v wkwkwkwkkw

help me in my post -_- about cash cant buy "item not different price"

**PrinceRay** · 26-04-13

I USE this query

Code:

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

DECLARE @name VARCHAR(13)
DECLARE @pw VARCHAR(13)
DECLARE @word VARCHAR(8)
DECLARE @status int
DECLARE @cash int
DECLARE @lama int

/****** Your Name ******/
SET @name = 'myidaccount'

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


/****** Your PIN ******/
SET @word = '123456'

/****** 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 @lama = '5'

/****** Cashpoint amount ******/
SET @cash = '100000'

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

INSERT INTO [RF_USER].[dbo].[tbl_RFTestAccount] 
	(
		[id],
		[password],
		[word]
	)
	VALUES
	(
		CONVERT(BINARY(13),@name),
		CONVERT(BINARY(13),@pw),
		CONVERT(BINARY(8),@word)
	)

INSERT INTO [BILLING].[dbo].[tbl_UserStatus] 
	(
		[id],
		[Status],
		[DTStartPrem],
		[DTEndPrem],
		[Cash]
	)
	VALUES
	(
		@name,
		@status,
		CONVERT(datetime,GETDATE()),
		CONVERT(datetime,GETDATE()+@lama),
		@cash
	)

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

**IvonaDP** · 26-04-13

/****** Created : Hanry Roslaw Saputra ******/

DECLARE @name VARCHAR(13)
DECLARE @pw VARCHAR(13)
DECLARE @birth smalldatetime
DECLARE @email varchar(255)
DECLARE @status int
DECLARE @cash int
DECLARE @lama int

/****** Your Name ******/
SET @name = 'Your username'

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

/****** Birthday ******/
SET @birth = '01-01-1900'

/****** Your Email ******/
SET @email = 'Your email address'

/****** 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 @lama = '36000'

/****** Cashpoint amount ******/
SET @cash = '1000000'
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()+@lama),
@cash
)

or use the web for activation premium and get bonus cash
here the link http://www.sendspace.com/file/wprzji
work 100% quarantee :)

how to use it = after register account use normal register page , re registration use this ..
must same info like when register first to make sure it work ...

**PrinceRay** · 26-04-13

Originally Posted by IvonaDP

/****** Created : Hanry Roslaw Saputra ******/

DECLARE @name VARCHAR(13)
DECLARE @pw VARCHAR(13)
DECLARE @birth smalldatetime
DECLARE @email varchar(255)
DECLARE @status int
DECLARE @cash int
DECLARE @lama int

/****** Your Name ******/
SET @name = 'Your username'

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

/****** Birthday ******/
SET @birth = '01-01-1900'

/****** Your Email ******/
SET @email = 'Your email address'

/****** 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 @lama = '36000'

/****** Cashpoint amount ******/
SET @cash = '1000000'
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()+@lama),
@cash
)

or use the web for activation premium and get bonus cash
here the link http://www.sendspace.com/file/wprzji
work 100% quarantee :)

how to use it = after register account use normal register page , re registration use this ..
must same info like when register first to make sure it work ...

The problem is : Cash doesnt appear :(
My Cash still 0

And i got this log From ZoneServer

Code:

0 04/26/13 13:48:04 : Query : declare @out_amount int exec prc_rfonline_auth 'maderay', @s_amount = @out_amount output select @out_amount
1 04/26/13 13:48:04 : SqlState:HY010, NativeError:0  Msg:[Microsoft][ODBC SQL Server Driver]Function sequence error 
2 04/26/13 13:48:04 : SQLExecDirect Returns : SQL_ERROR
3 04/26/13 13:48:15 : Query : declare @out_amount int exec prc_rfonline_auth 'maderay', @s_amount = @out_amount output select @out_amount
4 04/26/13 13:48:15 : SqlState:24000, NativeError:0  Msg:[Microsoft][ODBC SQL Server Driver]Invalid cursor state 
5 04/26/13 13:48:15 : SQLExecDirect Returns : SQL_ERROR
6 04/26/13 13:48:15 : EroorActionProcSQL_ERROR : DB Error!(24000) -> ReConnectDataBase()
7 04/26/13 13:48:15 :  
8 04/26/13 13:48:15 : ReConnectDataBase : Start
9 04/26/13 13:48:15 : ReConnectDataBase Count : 0 Success.

**IvonaDP** · 26-04-13

here all my initialize setting
Download setting initialize.rar from Sendspace.com - send big files the easy way

btw my ODBC setting ( use SQl server dont SQL Native Client )

User DSN :
BILLING login use sql authentication and for port your ip,61433
RF_USER and RF_WORLD_NOVUS ( for the rf world i give name like this ) login use windows NT authentication and for port your ip,61433

System DSN :
BILLING login use windows NT authentication and for port your ip,1433
RF_USER and RF_WORLD_NOVUS ( for the rf world i give name like this ) login use sql aunthentication and for port your ip,61433

my rfacc.ini at Account and Login and ZoneServer =

[Options]
DBSTR = Provider=MSDASQL;DSN=BILLING;UID=sa;PWD=Your pwd
ErrDBSTR =
LogLevel = 2

For Database i use this :
Database.rar

for can make the item mall shop work can be bought
Download fix work cashshop.7z from Sendspace.com - send big files the easy way

or the other one has edited all price 10 cash point at here :

http://www.sendspace.com/file/rmaa9y

**ElectricShock** · 26-04-13

did you use RU Billing database?

**ROSLAW** · 27-04-13

Your problem is, you don't ever want to read ..
Please read back here http://forum.ragezone.com/f480/guide...ing-ru-883454/

**Killerwoody** · 27-04-13

I got a new problem! I've matched all the files price for price but when you log in game all the prices are off by one column... anyone else have this issue?

Cash shop system

Thread Tools

Search Thread

Cash shop system

Re: Cash shop system

Re: Cash shop system

Re: Cash shop system

Re: Cash shop system

Re: Cash shop system

Re: Cash shop system

Re: Cash shop system

Re: Cash shop system

Re: Cash shop system

Re: Cash shop system

Re: Cash shop system

Re: Cash shop system

Re: Cash shop system

Advertisement