Starting items

[VoyageurCeleste]

Hello all !
First, i have follow the wiki and i use actually EQEmu-0.7.0-936 with the last db from EQ project. All work fine, i can connect , zone , kill but i still have a little prob.
Here is my call. When i create a char it start with a bag but without the starting items we had in EQ real version. Is it normal ? Is there someone who worked on it and has the sql code to implement my peq database or can explain me how to do it ?

Thanks for the answer

[devilspuppet]

I setup a personal server just to play around with. I noticed that when I create a new character, I do not receive any weapon at the start of the game. The database I installed is the Luclin PEQ DB. Is there an updated starting items table I missed? I haven't quite figured out how to edit the database to add my own yet... Any help would be appreciated...

http://www.eqemulator.net/wiki/wikka...DatabaseSchema

look under starting items..

[devilspuppet]

I did notice that bread and water are included in the starting items for all race class combo's (I think, since it lists 0 for both variables). New characters on my server do not receive these, as far as I can tell. Every character I have created only gets a backpack and a note.

[LostZaphod]

If you are using mysql5 you must comment out strict mode in my.ini.

http://www.eqemulator.net/forums/showthread.php?t=21556

[devilspuppet]

Thanks, that might be the problem, I will give it a try when I get home

[sesmar]

Maybe this will help you.

http://eqemulator.net/forums/showthr...Starting+Items

Please try searching the forums before posting a new topic.

[VoyageurCeleste]

http://www.eqemulator.net/wiki/wikka...astartingitems

I have read the link but nothing can help me tyhere .. or maybe the info are broken

Tahnks anyway for the help

[Aerewen]

editing starting items takes a knowledge of MySQL and a little bit of work

there's a table in the database called "starting_items"

if you open the query browser and select the peq database (or whatever yours is called), type "SELECT * FROM `starting_items`" and execute the query to see all the start items.

Race should be 0 to give the item to any race (ie the bread cakes, backpacks etc) The only thing that is race specific are the notes to the guildmasters. (Though i think the quests may have been re-routed to the GM's in POK? anyone know for certain? cuz if so, the notes are not race specific anymore...)

Races:(may or may not be accurate, i'm basing them on PEQ Editor)
1: human
2: barbarian
3: erudite
4: wood elf
5: high elf
6: dark elf
7: half elf
8: dwarf
9: troll
10: ogre
11: halfling
12: gnome

Classes will need to be specified for weapons, but as with the race flag.. bread cakes and whatnot can be left as 0 (i think?)

1: warrior
2: cleric
3: paladin
4: ranger
5: shadowknight
6: druid
7: monk
8: bard
9: rogue
10: shaman
11: necromancer
12: wizard
13: magician
14: enchanter
15: beastlord
16: berzerker

item charges should always be 1 except for the stackable items: Bandages* Bread Cakes* and Skin of Milk*

itemid is the field for telling PEQ what item it is:

Bread Cakes* - 9991
Bandages* - 21779
Skin of Milk* - 9990
Backpack* - 32601
Gloomingdeep Lantern - 9979
No clue what the note was called... so i cant give u an itemid for it
==weapons==
Dagger* - 9997
Club* - 9999
Short Sword* - 9998
Dull Axe* - 55623

==bank items==
Gold Coin - 22290
Bakcpack - 17005

Leave GM set to 0 always
Leave slot set to -1 to place it in the first available inventory slot

I'm not positive on this numbering scheme... but i believe it is as follows:
0 upper left slot
1 upper right
2 2nd left
3 2nd right
4 etc...
5 ...
6 ...
7 lower left slot
8 lower right slot

as far as bags and bank slots go i have not tested this as of yet, will post back later with the details when i have time.

Diety info can probably just be set to 0 for everything... none of the starting items depend on a specific diety, but again you could use this field to grant a special item to each diety if you wanted to.

zoneid should be 0

now whoopdedoo basil what does it all mean?!

use those variables to enter the information into the database, first you will need to remove the existing items... but might want to make a backup first just in case

then use the query below, just copy/paste it into the query browser and change the values from [value] to what it should be... make sure to delete the brackets [ ] from around the info but LEAVE the single quotations alone ' ' !!!

INSERT INTO `starting_items` VALUES (0,[race number],[class number],[diety number],[zone id],[ITEM ID],[item charges],[gm flag, set always to 0],[slot number, use -1 for first available]);

so executing the query:

INSERT INTO `starting_items` VALUES (0,1,1,0,0,9998,1,0,-1);

would give all human warriors 1 Short Sword* in the first available inventory slot.

Have fun and good luck

PS: might wanna sticky or wiki this one :P

[John Adams]

That is great info! I feel a WIKI page coming on!

[Aerewen]

lol that was pretty much the whole reason i wrote it... seen the wiki for starting items recently?

http://www.eqemulator.net/wiki/wikka...astartingitems

lol