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!

Mercenary And Gift Voucher Problem..

Experienced Elementalist
Joined
Jan 29, 2010
Messages
273
Reaction score
197
Is there someone who knows 2 problem-solving?

Cabal(130212-1001-Ver369-0000) - Mercenary And Gift Voucher Problem.. - RaGEZONE Forums Cabal(130212-1002-Ver369-0000) - Mercenary And Gift Voucher Problem.. - RaGEZONE Forums
 

Attachments

You must be registered for see attachments list
Experienced Elementalist
Joined
Feb 16, 2012
Messages
234
Reaction score
96
go in the database CabalCash table and run this query
Code:
INSERT INTO [CabalCash].[dbo].[CashAccount] ([ID], [UserNum], [Cash], [CashBonus], [UpdateDateTime]) VALUES ('userloginname', 'userid(INT)', 'cash', '0', '2013-02-06 20:27:22')
i think then you can use vouchers
 
Upvote 0
Experienced Elementalist
Joined
Jan 29, 2010
Messages
273
Reaction score
197
go in the database CabalCash table and run this query
Code:
INSERT INTO [CabalCash].[dbo].[CashAccount] ([ID], [UserNum], [Cash], [CashBonus], [UpdateDateTime]) VALUES ('userloginname', 'userid(INT)', 'cash', '0', '2013-02-06 20:27:22')
i think then you can use vouchers

I know it
does not work coupons
 
Upvote 0
Initiate Mage
Joined
Feb 8, 2013
Messages
46
Reaction score
21
About Menecary u need to buy item in Grocer to use it ;p

- You will need to buy summoning gems (From ANY NPC Grocer)
- You will gather different sorts of Mercenary cards (Normal/Rare/Epic/Unique). Remember to only buy the gems YOUR Mercenary needs. (Eg. A Corrupt Force Archer - Normal Summoning Gems.)
 
Upvote 0
Experienced Elementalist
Joined
Jan 29, 2010
Messages
273
Reaction score
197
About Menecary u need to buy item in Grocer to use it ;p

- You will need to buy summoning gems (From ANY NPC Grocer)
- You will gather different sorts of Mercenary cards (Normal/Rare/Epic/Unique). Remember to only buy the gems YOUR Mercenary needs. (Eg. A Corrupt Force Archer - Normal Summoning Gems.)
I had forgotten tkx :))

Gift Voucher problem continues to
 
Upvote 0
Elite Diviner
Joined
Aug 23, 2012
Messages
406
Reaction score
99
To use the CABAL Vouchers:

1. first add your username and your usernumber in CashAccount table OR edit your procedure in cabal_tool_registerAccont by inserting Cash automatically for every new account created.
2. run this at CabalCash >> exec up_AddMyCashItemByItem 'ACCOUNTID','0','1','2366','1150','21'
1150 - amount CABAL Gold Voucher or whatever amount you want to
 
Upvote 0
Initiate Mage
Joined
Feb 8, 2013
Messages
46
Reaction score
21
To use the CABAL Vouchers:

1. first add your username and your user number in CashAccount table
2. run this at CabalCash >> exec up_AddMyCashItemByItem 'ACCOUNTID','0','1','2366','1150','21'
1150 - amount CABAL Gold Voucher or whatever amount you want to

Not working for me, i didn't get cc :)
But i too want fix Vounchers. Someone know how?
 
Upvote 0
Elite Diviner
Joined
Aug 23, 2012
Messages
406
Reaction score
99
Not working for me, i didn't get cc :)
But i too want fix Vounchers. Someone know how?

check your CashAccount table if your username was already there, if not you have to add first.
after adding it, run the query to CabalCash in order for you to receive the CABAL Gold Voucher, then right click to use.

Note: You can't use the voucher if your accountname/username doesn't indicated in the CashAccount table.
 
Upvote 0
Initiate Mage
Joined
Feb 8, 2013
Messages
46
Reaction score
21
Can u tell how to do this?:
OR edit your procedure in cabal_tool_registerAccont by inserting Cash automatically for every new account created.

That automaticaly?
 
Upvote 0
Experienced Elementalist
Joined
Feb 16, 2012
Messages
234
Reaction score
96
Code:
ALTER  PROCEDURE [dbo].[cabal_tool_registerAccount]   (@id varchar(32),  @password  varchar(32))
AS
begin tran
	declare @UserNum as int

	insert into cabal_auth_table( ID, Password, Login, AuthType, IdentityNo ) 
	values(@id, pwdencrypt(@password), '0', 1, '7700000000000' )

	set @UserNum = @@identity


	insert into cabal_charge_auth(usernum, type, expiredate, payminutes)
	values(@UserNum, 0, DATEADD(day, 1000, getdate()), 0)
	
	INSERT INTO [CabalCash].[dbo].[CashAccount] ([ID], [UserNum], [Cash], [CashBonus]) 
	VALUES (@id, @UserNum, '0', '0')

	select @UserNum as usernum
commit
i dont know if its work

EDIT:// ok tested its work :)
 
Upvote 0
Experienced Elementalist
Joined
Jan 29, 2010
Messages
273
Reaction score
197
Code:
ALTER  PROCEDURE [dbo].[cabal_tool_registerAccount]   (@id varchar(32),  @password  varchar(32))
AS
begin tran
	declare @UserNum as int

	insert into cabal_auth_table( ID, Password, Login, AuthType, IdentityNo ) 
	values(@id, pwdencrypt(@password), '0', 1, '7700000000000' )

	set @UserNum = @@identity


	insert into cabal_charge_auth(usernum, type, expiredate, payminutes)
	values(@UserNum, 0, DATEADD(day, 1000, getdate()), 0)
	
	INSERT INTO [CabalCash].[dbo].[CashAccount] ([ID], [UserNum], [Cash], [CashBonus]) 
	VALUES (@id, @UserNum, '0', '0')

	select @UserNum as usernum
commit
i dont know if its work

EDIT:// ok tested its work :)

thx all work :))
 
Upvote 0
Junior Spellweaver
Joined
Sep 7, 2012
Messages
166
Reaction score
16
what i did is configure CABALCASH > TABLES > VoucherDetails and VoucherItemMaster and VoucherMaster

ex. VoucherItemMaster
Code:
32772	2364	500	31	2013-02-15 20:50:28.147	1	Bronze
49158	2365	1000	31	2013-02-15 20:55:20.747	1	Silver
65544	2366	2000	31	2013-02-15 20:57:50.687	1	Gold
 
Upvote 0
Initiate Mage
Joined
Oct 17, 2009
Messages
96
Reaction score
47
So when I use a Gold Voucher it's updating on the CashAccount but not ingame...

Edit: Nvm, I fully relogged and it's updated.
 
Last edited:
Upvote 0
Junior Spellweaver
Joined
Sep 7, 2012
Messages
166
Reaction score
16
So when I use a Gold Voucher it's updating on the CashAccount but not ingame...

Edit: Nvm, I fully relogged and it's updated.

Basically this is on the server side, if im not busy i will check where we could change the time to get the info of cash to db to client
 
Upvote 0
Elite Diviner
Joined
Jun 23, 2012
Messages
465
Reaction score
39
Originally Posted by Stricted
Code:
ALTER PROCEDURE [dbo].[cabal_tool_registerAccount] (@id varchar(32), @password varchar(32))
AS
begin tran
declare @UserNum as int

insert into cabal_auth_table( ID, Password, Login, AuthType, IdentityNo )
values(@id, pwdencrypt(@password), '0', 1, '7700000000000' )

set @UserNum = @@identity


insert into cabal_charge_auth(usernum, type, expiredate, payminutes)
values(@UserNum, 0, DATEADD(day, 1000, getdate()), 0)

INSERT INTO [CabalCash].[dbo].[CashAccount] ([ID], [UserNum], [Cash], [CashBonus])
VALUES (@id, @UserNum, '0', '0')

select @UserNum as usernum
commiti dont know if its work

EDIT:// ok tested its work :)


still can't use coupon gold
 
Upvote 0
Elite Diviner
Joined
Jun 23, 2012
Messages
465
Reaction score
39
why many time ask same problem cos still not clear what we need do it ......... pls give more step by step so clear we can test ...... not asking same question ....... so can soft problem cos still happent ????

thnks
 
Upvote 0
Initiate Mage
Joined
Feb 16, 2013
Messages
12
Reaction score
0
what i did is configure CABALCASH > TABLES > VoucherDetails and VoucherItemMaster and VoucherMaster

ex. VoucherItemMaster
Code:
32772    2364    500    31    2013-02-15 20:50:28.147    1    Bronze
49158    2365    1000    31    2013-02-15 20:55:20.747    1    Silver
65544    2366    2000    31    2013-02-15 20:57:50.687    1    Gold

What should I edit with VoucherDetails and Voucher Master?? Pls help!

Sorry for my bad English...
 
Upvote 0
Back
Top