Quests, hairstyles and no items

[grues0me]

Hi forum.

I set up my server 2 days ago, using devlors guide (using EQEmu Binary 0.4.4-DR1+Telmet + Drawde's updated DB addon worlddata1.1.beta5) and all went smooth, server running and user in my lan have accounts on it. Now i sourced in Drawdes 1.1 final but still i have a few problems:

1. Even tho the quests folder is placed correctly in eqgame, i cant transport via scions to nexus. I tell him "i wish to journey to luclin" and the answers "as you wish" but nothing happens ever.

2. No starting items, whatever char/class i choose. Shops have items in stock. Is this supposed to be like that? I sourced in the items.sql and books.sql but it didnt help at all. Also the priest of discord wants to give me a book, but a item error shows up.

3. Creating a char i choose a hairstyle and distribute my points. After finishing creation and returning to char selection, the char has again the standard hairstyle.

I tried even to setup my own db by sourcing db.sql and then drawdes 1.1 followed by items and books; but it showed tons of column errors. Server ran, but points mentioned above were still not solved. I even re-installed ALL and no success.

I hope you guys can help me. Great work by the way!

[grues0me]

Ok. Then i answer myself :P

The quest files (even the quest-quoted one) have errors inside. The scions castspell command is wrong:

castspell("$userid","2935") is correct. The spellnumber (2935) must be quoted also so the scion actually CASTS the spell and not just says "Very well".

Same with the books or other rewards. All numbers must be quoted it seems.

The hairstyle is just diplayed wrong in char selection screen. Ingame its all right.

But i could still use help to give ALL players food+water in the beginning. Cant there be a "global" starting items section in the admin tool? Besides being able to give money would be a help. Or is there any addon where starting gear is already sourced in?

[xezor]

I think I read it somewhere that if you are a GM you won't have starting items. It could be wrong though.

[mwmdragon]

You can also change spawns and everything in there

[IANumtin]

If you download Drawdes latest worlddata and unzip it to your bin directory in MySQL you'll notice some .txt files in there. One of them is for starting items. Just open mysql.exe, type in use eq; and then source it in by typing source startingitems.txt; or whatever the .txt file is called. Anything else that's missing from your database should also be in a .txt file within the same worlddata. Just source in what you need.

[grues0me]

Thanks, gonna try it!