2 questions

09/18/2011 21:33 18andLife#1
In which stored procedure can I change the character's starting position? (Is it possible to set that both CH and EU chars start at the same place?)
Is it possible to add starter items to storage? I mean if someone create a new character/account, there will be items in the storage.
09/18/2011 21:55 kevin_owner#2
Uuhm how about _AddNewChar??

it's all in there and you could also add some new lines in that code too add the start items.

Btw I just opend that stored procedure and the gameserver sends the start region xyz position but you can change the values in the query to use your spot.
09/18/2011 22:18 18andLife#3
Quote:
Originally Posted by kevin_owner View Post
Uuhm how about _AddNewChar??

it's all in there and you could also add some new lines in that code too add the start items.

Btw I just opend that stored procedure and the gameserver sends the start region xyz position but you can change the values in the query to use your spot.
I already changed some stuff at _addnewchar (instant 110, 99m sp, 999b gold etc.)
I also added some items like premium, global, but there's not enough space in the inventory to add all male + female sets + weapons + accessory :/ that's why i wanted to add them to storage
09/18/2011 22:32 _HouseMusicx3#4
Quote:
Originally Posted by 18andLife View Post
I already changed some stuff at _addnewchar (instant 110, 99m sp, 999b gold etc.)
I also added some items like premium, global, but there's not enough space in the inventory to add all male + female sets + weapons + accessory :/ that's why i wanted to add them to storage
isnt it possible to change the ammount of inventorry slots ?
09/18/2011 22:35 18andLife#5
Quote:
Originally Posted by _HouseMusicx3 View Post
isnt it possible to change the ammount of inventorry slots ?
There's no column related to inventory slots at the _Char table :/
09/18/2011 22:37 lesderid#6
Well, just explore the DB a bit. You can do a lot with it. (yes, even making the inventory larger at char creation)
09/18/2011 22:42 rushcrush#7
sorry guys but why i cant find _AddNewChar teb o.o
09/18/2011 22:43 kevin_owner#8
Quote:
Originally Posted by 18andLife View Post
There's no column related to inventory slots at the _Char table :/
I suggest you to open your eyes. I open the _Char table and what do I see in middle of all columns "InventorySize":)

btw the storage items are stored somewhere and there is probably also a stored procedure so you could use that stored procedure to add the items in the storage.

Like lesderid said explore the database a bit:)

EDIT: @up read it again no one said it's a table it's a stored procedure it's under programmability -> stored procedures
09/18/2011 22:45 18andLife#9
Quote:
Originally Posted by kevin_owner View Post
I suggest you to open your eyes. I open the _Char table and what do I see in middle of all columns "InventorySize":)

btw the storage items are stored somewhere and there is probably also a stored procedure so you could use that stored procedure to add the items in the storage.

Like lesderid said explore the database a bit:)

EDIT: @up read it again no one said it's a table it's a stored procedure it's under programmability -> stored procedures
o.O I lol thanks i didn't see it, im blind
09/18/2011 22:56 rushcrush#10
Quote:
EDIT: @up read it again no one said it's a table it's a stored procedure it's under programmability -> stored procedures
ah ok...
09/18/2011 22:57 [H2K] ^ LordyK#11
Quote:
Originally Posted by 18andLife View Post
I already changed some stuff at _addnewchar (instant 110, 99m sp, 999b gold etc.)
I also added some items like premium, global, but there's not enough space in the inventory to add all male + female sets + weapons + accessory :/ that's why i wanted to add them to storage
you can change inventory slots from char on shard :) , and it is - you should search for 45 on char table , because that's the deafult inventory slot
09/18/2011 22:59 6_lucifer_6#12
do u know a alchemy increasing rate command?