Default Items on CHAR

04/13/2013 05:53 numb3rone#1
Hi,

How can I make a newly created character come equipped with Dshop autopotions and other items when they are newly created?

If possible I want it already in the f1, f2, f3 slots instead of in the inventory bag.
04/13/2013 08:02 kurmiz#2
Put them on [DEV] chars for each class (creat account, add system dev chars to account, buy/equip what you want, after done - move chars from account).

or harder way, add lines in user_bag database yourself for each class.
04/13/2013 08:26 numb3rone#3
so let me get this right.

- I make a new account. Example, I make an AK character. Then I change that new character into a [DEV].
- I then buy Dshop potions and equip it on my F1, F2 or inventory bag.
- When I am done. I remove the character from the account by deleting it?

Then I will repeat this for every class to have all classes that are created come with the equipped Dshop potions?

Also, if I add lines into user_bag database for each class, will the item only appear in their inventory bag? How can I make it so that it is already on F1, F2 slot when new characters are created?
04/13/2013 09:14 kurmiz#4
Quote:
- I make a new account. Example, I make an AK character. Then I change that new character into a [DEV].
Nope, you need move system [DEV] char into your account (system ak: [DEV]KNIGHT; system bagi warior:[DEV]WARRIOR)
Change user_no at system [DEV] to your account number, after work done, return orginal account number.

Quote:
- I then buy Dshop potions and equip it on my F1, F2 or inventory bag.
Just buy, equip etc. but you should not move (x y).


Quote:
- When I am done. I remove the character from the account by deleting it?
No, if you delete it, database for that class will be ruined. You must return orginal account number to system [DEV] char.
04/13/2013 13:17 maliciousaid#5
Quote:
Originally Posted by kurmiz View Post
Nope, you need move system [DEV] char into your account (system ak: [DEV]KNIGHT; system bagi warior:[DEV]WARRIOR)
Change user_no at system [DEV] to your account number, after work done, return orginal account number.



Just buy, equip etc. but you should not move (x y).




No, if you delete it, database for that class will be ruined. You must return orginal account number to system [DEV] char.
it doesnt work on my segeuriper and halfbagi, any idea why?
i even try add manually user_suit and user_bag still nothing appear on new char.
04/13/2013 13:34 alexmak96#6
you must edit SP_CHAR_CREATE
04/13/2013 13:54 maliciousaid#7
on my database, theres no SP_CHAR_CREATE on my character database.


[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]
04/13/2013 14:05 alexmak96#8
Stored producer
04/13/2013 14:06 kurmiz#9
character database -> programability -> stored procedures
04/13/2013 14:09 maliciousaid#10
thank you so much, thats help. :)

Quote:
Originally Posted by alexmak96 View Post
you must edit SP_CHAR_CREATE
what the thing should i edit?

only my half bagi and segeuriper only not working on my startup item.
04/13/2013 14:17 conquer93#11
this is how i added items into new created chars.

1: if u have 11 class make sure only 6 of them has USER_NO 19999999999991
in DB character and change others to something else so they wont be on acc cus u can only have 6 chars in 1 account.
2 : create an new acc and use USER_NO 19999999999991
3: go ingame drop ur shits in ur chars
4: change the chars u just added items on to something aslong it aint 19999999999991 and change the others to 19999999999991 now. add the items to them
5: change all back to 19999999999991 and try should work xD
04/13/2013 14:56 maliciousaid#12
Quote:
Originally Posted by conquer93 View Post
this is how i added items into new created chars.

1: if u have 11 class make sure only 6 of them has USER_NO 19999999999991
in DB character and change others to something else so they wont be on acc cus u can only have 6 chars in 1 account.
2 : create an new acc and use USER_NO 19999999999991
3: go ingame drop ur shits in ur chars
4: change the chars u just added items on to something aslong it aint 19999999999991 and change the others to 19999999999991 now. add the items to them
5: change all back to 19999999999991 and try should work xD
what u mean by change the others?
oh the others 6.
04/13/2013 15:01 alexmak96#13
The account can be max 6 characters
If you have 11 characters then u can't login
ex: if u have 11 characters change 5 user_no to ex: 29999999999991
then login with the new account and get the items u want
04/13/2013 15:07 maliciousaid#14
now bit clearer. xD
thanks all :)
04/13/2013 15:22 alexmak96#15
Quote:
Originally Posted by maliciousaid View Post
thank you so much, thats help. :)



what the thing should i edit?

only my half bagi and segeuriper only not working on my startup item.
I don't remember which one i've changed cause i do not have my pc with the server anymore.

But it has a DECLARE

Quote:
DECLARE @wh_char_no VARCHAR(14)
try to change it to 15 or 16