Starting items

[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...

[mattmeck]

http://www.eqemulator.net/wiki/wikka.php?wakka=CategoryDatabaseSchema

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 :)

[John Adams]

I have the same problem with MySQL5 on new chars. Thanks for the tip, LZ.

[devilspuppet]

Well, changing strict mode worked like a charm, thanks :)

I now noticed that if you select a caster you do not receive the note to get the starting armor...

Your inventory slots are full...

I might just remove either the lantern or bandages, just wondering if there was a way to put some of this stuff inside your starting backpack...

[Rhodan]

I'd like to know if you can put starting items in a container as well. I know you can assign wearables to a slot, but i dunno about containers.

btw: The lantern is assigned to all races (race 0) and all classes (class 0), so if you remove it from the starting items, nobody will get one. Believe me, being a barbarian or human at night without a light is a PAIN. Particularly if you try heading into Blackburrow from the Halas side - there's no fire beetles in Everfrost.

If we can't put things in containers, then I'm just going to add wearables to the starting items and put them directly on the paperdoll.

[devilspuppet]

Can you place the starting weapon in hand at the onset of the game, or does it need to go into inventory? That might free up the last slot for the note to be in inventory...

[fathernitwit]

the slot column should let you put it anywhere, including bags or the bank.

[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

http://www.eqemulator.net/forums/images/icons/icon7.gif

[sesmar]

Maybe this will help you.

http://eqemulator.net/forums/showthread.php?t=21785&highlight=Starting+Items

Please try searching the forums before posting a new topic.

[VoyageurCeleste]

http://www.eqemulator.net/wiki/wikka.php?wakka=EQEmuDBSchemastartingitems

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

Tahnks anyway for the help

[Aerewen]

as i recall for those looking to emulate a close-to-EQ server...
Starting items are:
1 weapon (depends on class as to what type)
20 bandages*
20 skin of milk*
20 bread cakes*
1 Note for guildmaster
1 backpack* (notrade version)
1 gloomingdeep lantern

and that's it for inventory items

bank contains:
1 gold coin
1 backpack (regular tradable version)

[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 :D

PS: might wanna sticky or wiki this one :P

[Angelox]

as i recall for those looking to emulate a close-to-EQ server...
Starting items are:
1 weapon (depends on class as to what type)
20 bandages*
20 skin of milk*
20 bread cakes*
1 Note for guildmaster
1 backpack* (notrade version)
1 gloomingdeep lantern

and that's it for inventory items

bank contains:
1 gold coin
1 backpack (regular tradable version)

Lately, didn't the caster classes start with a few spells (for mem) also?

[John Adams]

When did they do away with the Book of Discord, or whatever it was called? Come to think of it, I haven't seen that on a new toon in a while (always used to destroy them). How does a noob follow the ways of Discord these days?

And Angelox, I believe you are right for casters. I remember a recent mage having a basic level 1 shield and some fire spell. The rest I had to buy.

[John Adams]

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

[Aerewen]

tome of order and discord is handed out by the priest of discord

when you ask him about the [tome of order and discord] he gives you one and explains it... handing it back will make u pvp

and yes you are correct about the spells. i believe the caster classes each start out with a level 1 spell... additionally they also have a spell scribed in their spellbook usually... but i dont know if there is a way to implement that using the `start_items` table or not

edit:

i also made another post after taking the time to make a list of all the races/classes etc for the starting items table: http://www.eqemulator.net/forums/showthread.php?t=22079

might help you with the modifications

[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.php?wakka=EQEmuDBSchemastartingitems

lol

[cavedude]

Two topics right next to each other with the same exact subject! Mods get in here and bust some heads!

[Cripp]

merged them together :-D hope it turned out ok lol..

[John Adams]

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

http://www.eqemulator.net/wiki/wikka.php?wakka=EQEmuDBSchemastartingitems

lol
Well get to it! Bust that baby into the page already. :D

(Wiki 101 can be a little tricky, but gets easier the more you play with it)

[eqfenam]

awesome info in this thread... was just wondering (and I'm probably posting this in the wrong thread but cannot find anything on it through searches) does anyone have the table of the 73 skills? I'm trying to figure out what each one of them are so I can edit a couple bugs I have found for a custom server, but wih there being 73 of them, that's a lot of trial and error... Thanks in advance!

[JrFaust]

Is this what you are looking for? The only other list I know of is here (http://www.eqemulator.net/wiki/wikka.php?wakka=SkillList).

// Correct Skill Numbers as of 4-14-2002
typedef enum {
_1H_BLUNT = 0,
_1H_SLASHING = 1,
_2H_BLUNT = 2,
_2H_SLASHING = 3,
ABJURE = 4,
ALTERATION = 5,
APPLY_POISON = 6,
ARCHERY = 7,
BACKSTAB = 8,
BIND_WOUND = 9,
BASH = 10,
BLOCKSKILL = 11,
BRASS_INSTRUMENTS = 12,
CHANNELING = 13,
CONJURATION = 14,
DEFENSE = 15,
DISARM = 16,
DISARM_TRAPS = 17,
DIVINATION = 18,
DODGE = 19,
DOUBLE_ATTACK = 20,
DRAGON_PUNCH = 21 , //aka Tail Rake
DUAL_WIELD = 22,
EAGLE_STRIKE = 23,
EVOCATION = 24,
FEIGN_DEATH = 25,
FLYING_KICK = 26,
FORAGE = 27,
HAND_TO_HAND = 28,
HIDE = 29,
KICK = 30,
MEDITATE = 31,
MEND = 32,
OFFENSE = 33,
PARRY = 34,
PICK_LOCK = 35,
PIERCING = 36,
RIPOSTE = 37,
ROUND_KICK = 38,
SAFE_FALL = 39,
SENSE_HEADING = 40,
SINGING = 41,
SNEAK = 42,
SPECIALIZE_ABJURE = 43,
SPECIALIZE_ALTERATION = 44,
SPECIALIZE_CONJURATION = 45,
SPECIALIZE_DIVINATION = 46,
SPECIALIZE_EVOCATION = 47,
PICK_POCKETS = 48,
STRINGED_INSTRUMENTS = 49,
SWIMMING = 50,
THROWING = 51,
TIGER_CLAW = 52,
TRACKING = 53,
WIND_INSTRUMENTS = 54,
FISHING = 55,
MAKE_POISON = 56,
TINKERING = 57,
RESEARCH = 58,
ALCHEMY = 59,
BAKING = 60,
TAILORING = 61,
SENSE_TRAPS = 62,
BLACKSMITHING = 63,
FLETCHING = 64,
BREWING = 65,
ALCOHOL_TOLERANCE = 66,
BEGGING = 67,
JEWELRY_MAKING = 68,
POTTERY = 69,
PERCUSSION_INSTRUMENTS = 70,
INTIMIDATION = 71,
BERSERKING = 72,
TAUNT = 73,
GENERIC_TRADESKILL = 75
} SkillType;

#define HIGHEST_SKILL TAUNT

#endif

[eqfenam]

yes!! that is exactly what I was looking for in your post!! Thanx again!!

[wolvenbane]

When did they do away with the Book of Discord, or whatever it was called? Come to think of it, I haven't seen that on a new toon in a while (always used to destroy them). How does a noob follow the ways of Discord these days?

And Angelox, I believe you are right for casters. I remember a recent mage having a basic level 1 shield and some fire spell. The rest I had to buy.

Using the PEQ Luclin DB from this wiki (http://www.eqemulator.net/wiki/wikka.php?wakka=ws70845mysql5) (and I haven't edited the starting items yet) all my toons get the Tome of Order and Discord. This is a bit of a hassle as I remember casters starting with two basic spells (usually one shielding spell and a heal/damage based on class). In this version all toons start with a lantern, weapon, milk, bread, bandages, note, tome, and a no trade backpack. I'll have to do some updating....after I get Nexus and Bazaar fixed. Oh well.

#summonitem (blue diamond ID here)
/dance
/shout I can now afford my spells through level 20 yay!