Register to post in forums, or Log in to your existing account
 

Play RetroMUD
Post new topic  Reply to topic     Home » Forums » zMUD General Discussion
dangdongho1
Newbie


Joined: 17 Apr 2018
Posts: 1

PostPosted: Tue Apr 17, 2018 9:42 pm   

help needed making an eq database, thank you!
 
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]
Reply with quote
shalimar
GURU


Joined: 04 Aug 2002
Posts: 3849
Location: Pensacola, FL, USA

PostPosted: 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.
_________________
Windows 10 Home Premium 64-bit
AMD Phenom II x6 1055T 2.8GHz 16GB
CMUD Pro v3.34
Reply with quote
Display posts from previous:   
Post new topic   Reply to topic     Home » Forums » zMUD General Discussion All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

© 2009 Zugg Software. Hosted by Wolfpaw.net