Zugg Software :: View topic - help needed making an eq database, thank you!

Newbie Joined: 17 Apr 2018 Posts: 1

I just cannot figure out how to make a database for equipment. Here are some examples of what it looks like when I Stat an item.

Here is what a weapon looks like:

Short Description: 'Armageddon', Name (aliases): Armageddon
VNum: [62352], RNum: [ 7464], Type: WEAPON, SpecProc: None
L-Des: A HUGE sword is sitting here, glowing faintly.
Can be worn on: TAKE WIELD
Set char bits : NOBITS
Extra flags : GLOW !LOCATE !REMOVE POISONED !SELL HEROONLY OWNERONLY
Weight: 25, Value: 0, Cost/day: 0, Timer: 0, Level:30
In room: Nowhere, In object: None, Carried by: Nobody, Worn by: Nobody
Tohit: v0[8], Todam: v1[12] v2[11]=(12d11), Type: v3[12]
Level: [30] owner: v5[0-(None)] unused: v6[0] Clan: [0]

Affections: +50 to MAXHIT, +7 to DAMROLL, +7 to HITROLL
Spelleffects: flamestrike, level 35 - 40%

Here is an item

Short Description: 'Achilles Shield', Name (aliases): Achilles Shield
VNum: [29515], RNum: [ 6471], Type: ARMOR, SpecProc: None
L-Des: Achilles Shield is laying here.
Can be worn on: TAKE SHIELD
Set char bits : NOBITS
Extra flags : GLOW !LOCATE !SELL OWNERONLY
Weight: 20, Value: 0, Cost/day: 0, Timer: 0, Level:35
In room: Nowhere, In object: None, Carried by: Nobody, Worn by: Nobody
AC-apply: v0[10]
Level: [35] owner: v5[0-(None)] unused: v6[0] Clan: [0]

Affections: +50 to MAXHIT, +25 to MAXMOVE
Spelleffects: armor, level 30 - 100%

another item
Short Description: 'Ring of the Godslayer', Name (aliases): ring godslayer
VNum: [62353], RNum: [ 7465], Type: WORN, SpecProc: None
L-Des: An impressive looking ring is sitting here, unused.
Can be worn on: TAKE FINGER RING_FINGER
Set char bits : NOBITS
Extra flags : INVISIBLE !SELL OWNERONLY
Weight: 3, Value: 0, Cost/day: 0, Timer: 0, Level:45
In room: Nowhere, In object: None, Carried by: Nobody, Worn by: Nobody
Values 0-3: v0[0] v1[0] v2[0] v3[0]
Level: [45] owner: v5[0-(None)] unused: v6[0] Clan: [0]

Affections: +75 to MAXHIT, +35 to MAXMANA, +3 to WIS, +1 to CHA, +1 to INT
Spelleffects: strength, level 70 - 100%

Another item
Short Description: 'Skull Ring', Name (aliases): skull ring
VNum: [31203], RNum: [ 6842], Type: ARMOR, SpecProc: None
L-Des: A ring graced by a skull and bones symbol.
Extra descs: skull
Can be worn on: TAKE FINGER
Set char bits : NOBITS
Extra flags : GLOW !SELL OWNERONLY
Weight: 2, Value: 0, Cost/day: 0, Timer: 0, Level:27
In room: Nowhere, In object: None, Carried by: Nobody, Worn by: Nobody
AC-apply: v0[6]
Level: [27] owner: v5[0-(None)] unused: v6[0] Clan: [0]

Affections: +40 to MAXMANA
Spelleffects: None

Here is another item:

Short Description: 'A Wand of Lightning', Name (aliases): wand lightning
VNum: [33810], RNum: [ 7022], Type: WAND, SpecProc: None
L-Des: A Small Lightning bolt lays here.
Can be worn on: TAKE HOLD
Set char bits : NOBITS
Extra flags : NOBITS
Weight: 13, Value: 7, Cost/day: 1, Timer: 0, Level:30
In room: Nowhere, In object: None, Carried by: Nobody, Worn by: Nobody
Spell: v3[lightning breath], #of Charges: v2[1] / v1[1]
Level: [30] owner: v5[0-(None)] unused: v6[0] Clan: [0]

Affections: None
Spelleffects: None

Options for type are light,scroll,wand, staff, weapon, missle, treasure, armor, potion, armor, potion, worn, other, trash, trap, container, note, liq container, key, food, money, pen, boat, fountain, flying, pill, book, toggle, furniture, puzzle, mana battery, portal

option for worn on take, finger, neck, body, head, legs, feet, hands, arms, shield, about, waist, wrist, wield, hold, ring_finger, chest, crotch, eyes, ears, shoulders, ankles, badge, face.

not sure what else you would need.[/b]

Posted: Wed Apr 18, 2018 3:21 am

The database implementation in zMUD/CMUD is rather clunky.
Given the amount of data here I would suggest storing it in a database variable, but that feature is part of CMUD, not zMUD.

That said, first, you need triggers to be able to capture all of the information.
I would suggest a multistate trigger, but not all the lines appear for every item, might be easier to use temporary variables.

#TR {Short Description: '(*)', Name ~(aliases~): (*)} {
sdesc=%1
aliases=%replace(%trim(%2), " ", "|")
}

And so on, then once you have all the data you need you plug it into the appropriate spots in the database.
Check out the help files since I am not familiar with them.

#HELP #DBLOAD
#HELP #DBGET
#HELP #DBPUT
#HELP #DBSAVE
#HELP #DBCLOSE

If you upgrade to CMUD I can help you with the other method, or you can review one of the other threads where I have outlined the process for others.