Zugg Software :: View topic - How do you set up DB/EQ list for Eternal Darkness ?

Apprentice Joined: 26 Aug 2009 Posts: 141

Would like to be able to set up a DB using the information below.

EQ in the command prompt gives this infomation, below.

You are using:
<used as light> Eye of the Ghost Pirate (Glows) (Humms)
<worn on finger> a Goblin Signet Ring (Humms)
<worn on finger> a black onyx ring
<worn around neck> Amulet (Glows)
<worn around neck> Lykira's Brooch (Glows)
<worn on body> a Ruby Breast Plate
<worn on head> the Head Dress of MoMur (Glows) (Humms)
<worn on legs> a pair of haunted leg plates (Glows)
<worn on feet> boots of striding ..It seems distorted!
<worn on hands> Fists of the sun (Glows)
<worn on arms> a Tiger Tattoo (invisible) (Glows) (Humms)
<worn as shield> the Breast Scales of The Catacomb Dragon (Glows)
<worn about body> Phantom Cloak (invisible) ..It seems distorted!
<worn about waist> elemental waterskin (Glows) (Humms)
<worn around wrist> Condemned Bracelet
<worn around wrist> an Atlas Armlet (Glows) (Humms)
<wielded> a dragon dagger (Humms) ..It seems distorted!
<held> Nothing
<worn on ear> a pair of silver earrings
<worn on ear> Xop's earrings
<worn on face> the Tusks of the Vomammoth
<worn on ankle> a bone carved anklet
<worn on ankle> Shadow Anklet (invisible) (Glows)
<worn on back> Cyclone of the Elements (invisible) (Glows) (Humms)
<floating near by> the Orb of Drusilla (Glows)
<clan signet> Nothing
<range weapon> the Sonath Heavy Crossbow
<range ammo> an old yanagi(91/117)

Using the Identification cast 'identity' "object" spell on a given object, gives this Information Below:

Example 1

You feel informed:
Object 'Eye of the Ghost Pirate', Item type: LIGHT
Item is: GLOW HUM MAGIC !GOOD
Weight: 10, Value: 500000, Rent: 100000
Hours left: Infinite
Level Restriction : 140
Remort Restriction : No
Object Spell : detect invisible 100%
Size : 0
Can affect you as :
Affects: DAMROLL By 8
Affects: HITROLL By 4
Affects: CON By 1
Affects: MAXMANA By 100
Affects: MAXHIT By 110

Example2

Goblin Signet Ring', Item type: ARMOR
Item is: HUM BLESS
Weight: 2, Value: 200000, Rent: 0
AC-apply is 5
Level Restriction : 40
Remort Restriction : No
Object Spell : aid 100%
Size : 3
Can affect you as :
Affects: STR By 2
Affects: DAMROLL By 4
Affects: HITROLL By 2
Affects: MAXHIT By 36

Example 3

Object 'Lykira's Brooch', Item type: WORN
Item is: GLOW !GOOD !NEUTRAL
Weight: 0, Value: 0, Rent: 0
Level Restriction : 25
Remort Restriction : No
Object Spell : resist pain 100%
Size : 0
Can affect you as :
Affects: HITROLL By 2
Affects: DAMROLL By 3
Affects: MAXMANA By 35
Affects: MAXHIT By 20

Object 'elemental waterskin', Item type: LIQ CONTAINER
Item is: GLOW HUM !GOOD
Weight: 24, Value: 10000, Rent: 2000
Capacity: 90, Contains: 19 Liquid: water
Level Restriction : 10
Remort Restriction : No
Object Spell : create food 100%
Size : 0
Can affect you as :
Affects: HITROLL By 1
Affects: DAMROLL By 1
Affects: MAXMANA By 10

Example 4

Object 'the Sonath Heavy Crossbow', Item type: MISSILE
Item is: BLESS
Weight: 0, Value: 0, Rent: 0
Damage Dice is '20D20' for an average per-round damage of 210.0.
Level Restriction : 140
Remort Restriction : No
Object Spell : !RESERVED! 0%
Size : 0
Can affect you as :
Affects: MAXMANA By 25
Affects: MAXHIT By 125

Example5

Object 'an old yanagi', Item type: AMMO
Item is: !PRIMITIVE !LOCATE
Weight: 96, Value: 0, Rent: 0
Max Capacity : 117
Currently holding : 91
Ammo Spell : UNDEFINED
Level Restriction : 75
Remort Restriction : No
Object Spell : strength 100%
Size : 0
Can affect you as :
Affects: MAXHIT By 45
Affects: MAXMOVE By 50
Affects: DEX By -1
Affects: HITROLL By 4
Affects: DAMROLL By 7

LIGHT ARMOR WORN LIQ CONTAINER MISSILE AMMO seem to be the only listing that I have come across so far, if there are more please post these could be used for tables.

Well would like to be ale to record the data straight of the mud into a database ,(its' a nice dream and it's mine) This is beyond my coding skill, yet I have set up database in Access; not zmud.

Well thanks for any positive input, as this will be ongoing, the final finish effort will be post in Finished scrips.