[Ascent] Adding items to new characters on creation?

[dracus]

I'm sure this has been answered, but I've been searching for the last hour or so and can't find anything other than "edit scripts/classes.scp", but ascent doesn't have that so I assume it's in the database.

I've been looking at the regular items that new chars start with like Light Quiver and Refreshing Spring Water, and I'm sure I'm close to figuring it out, but a push in the right direction would be nice. It looks like all the items that appear on new characters are stored in playercreateinfo_items in the world db, but no matter what I try to add in there, nothing happens (after a complete server restart to make sure the new rows have been seen). Can anyone help me out please? I'd like to add my new item (that I've tested and it exists and works fine) to all new characters that are created. Thanks in advance!

[MentaL]

[gmaze]

well, without knowing the item, makes it harder to help, but I'll give it a shot

item needs to be in items and playercreateinfo_items tables.
item needs to have no level limit and be usable by all races and classes.

i've done this before, and worked for me, so don't know why you have an issue with it.

[dracus]

Hmm thanks, at least that means I'm on the right track. The item is just a book that I made that's worth 1000g that they can read for a few helpful hints and then sell to a vendor so they can get some starting cash.

What column in the playercreateinfo_items table decides which class starts with the item? I assume I have to add a new entry for each class?

[gmaze]

INSERT INTO playercreateinfo_items
  (indexid, protoid, slotid, amount)
VALUES
  (5, 16866, 0, 1);

the first is the player indexid (to get proper info, you must cross ref with playercreateinfo table.....use the index from that table for this id. ex: index 1 is for race 1 and class 1....index 2 is for race 2 class 1, etc....its all in that table)


second is item id
third is slot to put it in
last is how many

i'm not to sure on slots, but think 0 is in bag???

[dracus]

Awesome, this helps a lot, thanks! I'm not sure about the slotid's either, but the refreshing spring water is always in either 24 or 25 it looks like, so I'm guessing the starting backpack has id's in the 20's. I'll mess with it in a bit and post my results.

[jab416171]

So

INSERT INTO playercreateinfo_items
  (indexid, protoid, slotid, amount)
VALUES
  (1, 16866, 0, 1),
(2, 16866, 0, 1),
(3, 16866, 0, 1),
(4, 16866, 0, 1),
(5, 16866, 0, 1);
...etc

Would that update it for everyone if you just continued

[gmaze]

yes, but need to make sure it matches an actual index or it will error

[dracus]

1-19 correspond to gear slots, so unless you want people to be wearing your starting item on their head, you need to use 20+ to put it in a bag. And yes, you need to add entries for indexes 1-55 in order to cover every race/class combo.

[jab416171]

Thanks mate :)

[houseplant2]

i changed the start items for one of my toons. it looked as if nothing had changed when i went to the creation page but when i made a new character he had the correct outfits. I had to alter the wow dbc file to correspond to the sql database. then they looked correct in the create screen. hope that helps.