If I want item when born.

[kinnaree]

If I want all the characters start to occur in a steam-CashShop immediately.
I need to enter code and how?
Please suggest precisely
With illustrations is better

example

Enterprise Manager > Database > Account > Stored Procedures

Find cabal_tool_registerAccount (right click) properties

 

[Yamachi]

I have no idea what you're trying to do... Sorry, but the translator you're using is crap. The only thing I can suggest for you to do is to read the guides in the Tutorials section.

 

[kinnaree]

sorry for word

all character new born with Board, costume and pet in CashShop.
where to fix and how to fix?
Please suggest precisely
With illustrations is better

 

[cypher]

there is a guide for this, search for character templates.

 

[Yamachi]

there is a guide for this, search for character templates.

You wouldn't be able to do that with character templates, as cashshop items go by account, not by character. You could edit the stored procedure that handles character creation.

 

[chumpywumpy]

You won't be able to do it by templates unless you know how to edit the binary values and have enough SQL skill to update binary tables with queries.

Open cabal_sp_newchar in the gamedb and find this:

		-- 리턴값 0xA1 ~ 0xA6
		drop table #tempTable
		select convert(int, @result)

Change to:

		-- 리턴값 0xA1 ~ 0xA6
		drop table #tempTable
                cabalcash.dbo.up_addmycashitem(characterIdx/8,'1',@servrIdx,'<item number>','<itemopt>','<durationidx>','0')
		select convert(int, @result)

You need 1 cabalcash call for each item.

And before you totally mess up your server make sure that all of your items are account binding! If you your players will create lots of new chars, sell the free items, delete the char and repeat until rich. Also, all of your players are going to get the same board, same pet and same costume.

 

[kinnaree]

thx for chumpy ^ ^

all item with binding

today i come here with image

sample 3 item

ps. if lv 150 all character recieve costume binding.

Where I change code in SQL. :

 

[chumpywumpy]

I don't understand what you mean. You can only give items when creating new chars, you can't set it so they automatically get something else when they hit level 150.

 

[kinnaree]

		-- 리턴값 0xA1 ~ 0xA6
		drop table #tempTable
                cabalcash.dbo.up_addmycashitem(characterIdx/8,'1',@servrIdx,'<item number>','<itemopt>','<durationidx>','0')
		select convert(int, @result)

cabalcash.dbo.up_addmycashitem(characterIdx/8,'1',@servrIdx,'<464>','<0>','<0>','0')

check syntax is error ??? :scared:

 

[Moonfly]

Try it without the < > symbols
cabalcash.dbo.up_addmycashitem(characterIdx/8,'1',@servrIdx,'464','0','0','0')

 

[kinnaree]

Try it without the < > symbols
cabalcash.dbo.up_addmycashitem(characterIdx/8,'1',@servrIdx,'464','0','0','0')

i make follow u post but it not work
check syntax failed too. :grr:

error 170: Line 65: Incorrect syntax near 'cabalcash'.

characterIdx/8,'1' mean ..............

server i is 24

 

[chumpywumpy]

using up_addmycashitem can cause problems i noticed with a little more testing. Use this method instead.

-- 리턴값 0xA1 ~ 0xA6
drop table #tempTable
insert into CabalCash.dbo.MyCashItem ( UserNum, TranNo, ServerIdx, ItemKindIdx, ItemOpt, DurationIdx )
values (@UserNum, 1, @ServerIdx, <ItemIdx>, <ItemOpt>, <DurationIdx> )

 

[kinnaree]

using up_addmycashitem can cause problems i noticed with a little more testing. Use this method instead.

-- 리턴값 0xA1 ~ 0xA6
drop table #tempTable
insert into CabalCash.dbo.MyCashItem ( UserNum, TranNo, ServerIdx, ItemKindIdx, ItemOpt, DurationIdx )
values (@UserNum, 1, @ServerIdx, <ItemIdx>, <ItemOpt>, <DurationIdx> )

ok thx it work.

--------------------------------------------------------
when i log in i see item in cash but i dont recieve it.
it stay in a cash slot. :grr:

It is about here?
exec dbo.up_addmycashitem 33,1,24,429,0,0
is complete in sql query but i dont recieve item too.

--------------------------------------------------------
Script in my up_AddMyCashItem (SQL\Databases\CabalCash\Stored Procedures)

/****** Object: Stored Procedure dbo.up_AddMyCashItem Script Date: 2008-4-14 21:43:04 ******/
CREATE PROCEDURE DBO.up_AddMyCashItem
(
@UserNum INT,
@TranNo BIGINT,
@ServerIdx INT,
@ItemIdx INT,
@ItemOpt INT,
@DurationIdx INT,
@ProductType int = 0
)
AS
BEGIN
SET NOCOUNT ON
DECLARE @Result INT
DECLARE @GoodsType INT

If @ProductType = 2 Begin
Insert Into Cabal_Activation(CashlogNo,ItemIdx,UserNum)
Values(@TranNo,@ItemIdx,@UserNum)
End
Else Begin
INSERT INTO MyCashItem( UserNum, TranNo, ServerIdx, ItemKindIdx, ItemOpt, DurationIdx )
VALUES (@UserNum, @TranNo, @ServerIdx, @ItemIdx, @ItemOpt, @DurationIdx )
End

SET @Result = 0
SELECT @Result as Ret
SET NOCOUNT OFF
END




GO
----------------------------------------------------

now i dont install Chumpy's.CashShop.v1.5
----------------------------------------------------

ok clear
dbo.up_addmycashitem 33,1,24,429,0,31 success