Mercenary And Gift Voucher Problem..

[devit65]

Is there someone who knows 2 problem-solving?

 

[Stricted]

go in the database CabalCash table and run this query

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

 

[devit65]

go in the database CabalCash table and run this query

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

 

[dens6666]

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.)

 

[devit65]

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

 

[jaguar666]

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

 

[dens6666]

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?

 

[jaguar666]

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.

 

[dens6666]

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?

 

[Stricted]

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

 

[devit65]

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 )

 

[Onplay]

already query in account db but not work why ????

after have this voucher gold , right click cant use the item why ?????

 

[bsitmark]

what i did is configure CABALCASH > TABLES > VoucherDetails and VoucherItemMaster and VoucherMaster

ex. VoucherItemMaster

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

 

[KeelzYou]

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.

 

[AMD79]

Anyone manage to sell the voucher at agent shop?

 

[bsitmark]

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

 

[Onplay]

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

 

[bsitmark]

still can't use coupon gold

because that script is for registration only, here's the coupon Voucher

i tested it for mutiple account and its working

 

[Onplay]

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

 

[emiukey]

what i did is configure CABALCASH > TABLES > VoucherDetails and VoucherItemMaster and VoucherMaster

ex. VoucherItemMaster

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...