Make players start with a custom item.

[spectre123]

Can anyone make me a sql thing or tell me a guide so when a player creates a char and logs in it automaticly adds this item id? <18261> its name has been changed to what we wanted it to be.

please reply

[Vindicated]

Use the playercreateinfo_items table if you use any of the Ascent branches (Like ArcEmu/AspireCore/Hearthstone)

[spectre123]

Yea. im not so good with DB Editing with a SQL.

[Vindicated]

Well that's your only option :P

[spectre123]

Ehhh finne lol. but i mean, isnt there a .sql thing that i just run in the quirey to add item?

[Vindicated]

It really isn't that hard, just open up your database and go into the playercreateinfo_items table, there is a guide on this just use the search feature

[spectre123]

oh sorry. Never thought about that. Thanks Man. at 11:31 PM. I get lazy. :P

[stoneharry]

Theres a creator that can save you a lot of time.

Starting Gear Generator

Hope this helps

[pryd]

For Mangos users-

playercreateinfo_item

race,class,itemid,amount
1,1,25596,1
1,2,25596,1
1,4,25596,1
1,5,25596,1
1,6,25596,1
1,8,25596,1
1,9,25596,1
2,1,25596,1
2,3,25596,1
2,4,25596,1
2,6,25596,1
2,7,25596,1
2,9,25596,1
3,2,25596,1
3,1,25596,1
3,3,25596,1
3,4,25596,1
3,5,25596,1
3,6,25596,1
4,1,25596,1
4,3,25596,1
4,4,25596,1
4,5,25596,1
4,6,25596,1
4,11,25596,1
5,1,25596,1
5,4,25596,1
5,5,25596,1
5,6,25596,1
5,8,25596,1
5,9,25596,1
6,1,25596,1
6,3,25596,1
6,6,25596,1
6,7,25596,1
6,11,25596,1
7,1,25596,1
7,4,25596,1
7,6,25596,1
7,8,25596,1
7,9,25596,1
8,1,25596,1
8,3,25596,1
8,4,25596,1
8,5,25596,1
8,6,25596,1
8,7,25596,1
8,8,25596,1
10,2,25596,1
10,3,25596,1
10,4,25596,1
10,5,25596,1
10,6,25596,1
10,8,25596,1
10,9,25596,1
11,1,25596,1
11,2,25596,1
11,3,25596,1
11,5,25596,1
11,6,25596,1
11,7,25596,1
11,8,25596,1

playercreateinfo_spell

race,class,Spell,Note
1,1,58985,Perception
1,2,58985,Perception
1,4,58985,Perception
1,5,58985,Perception
1,6,58985,Perception
1,8,58985,Perception
1,9,58985,Perception
2,1,58985,Perception
2,3,58985,Perception
2,4,58985,Perception
2,6,58985,Perception
2,7,58985,Perception
2,9,58985,Perception
3,2,58985,Perception
3,1,58985,Perception
3,3,58985,Perception
3,4,58985,Perception
3,5,58985,Perception
3,6,58985,Perception
4,1,58985,Perception
4,3,58985,Perception
4,4,58985,Perception
4,5,58985,Perception
4,6,58985,Perception
4,11,58985,Perception
5,1,58985,Perception
5,4,58985,Perception
5,5,58985,Perception
5,6,58985,Perception
5,8,58985,Perception
5,9,58985,Perception
6,1,58985,Perception
6,3,58985,Perception
6,6,58985,Perception
6,7,58985,Perception
6,11,58985,Perception
7,1,58985,Perception
7,4,58985,Perception
7,6,58985,Perception
7,8,58985,Perception
7,9,58985,Perception
8,1,58985,Perception
8,3,58985,Perception
8,4,58985,Perception
8,5,58985,Perception
8,6,58985,Perception
8,7,58985,Perception
8,8,58985,Perception
10,2,58985,Perception
10,3,58985,Perception
10,4,58985,Perception
10,5,58985,Perception
10,6,58985,Perception
10,8,58985,Perception
10,9,58985,Perception
11,1,58985,Perception
11,2,58985,Perception
11,3,58985,Perception
11,5,58985,Perception
11,6,58985,Perception
11,7,58985,Perception
11,8,58985,Perception

These Templates will hit up all race and class. They are CSV files. Best thing to do with these is to copy and paste into seperate .txt then rename the files to playercreateinfo_item.csv and playercreateinfo_spell.csv

Next with your favorite text editor find and replace the itemid or if you are using spells, spell & note. Lastly import the .csv into the right table. I use Heidi seems to work great. Hope this helps.

[Trollin]

Get Navicat Lite, super duper easy.. I'm sure there's a guide on SQL things also.