- Joined
- Jan 29, 2010
- Messages
- 278
- Reaction score
- 198
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!INSERT INTO [CabalCash].[dbo].[CashAccount] ([ID], [UserNum], [Cash], [CashBonus], [UpdateDateTime]) VALUES ('userloginname', 'userid(INT)', 'cash', '0', '2013-02-06 20:27:22')
go in the database CabalCash table and run this query
i think then you can use vouchersCode:INSERT INTO [CabalCash].[dbo].[CashAccount] ([ID], [UserNum], [Cash], [CashBonus], [UpdateDateTime]) VALUES ('userloginname', 'userid(INT)', 'cash', '0', '2013-02-06 20:27:22')
I had forgotten tkx )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.)
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?
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 workCode: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
EDIT:// ok tested its work
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
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.
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
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