Zugg Software :: View topic

Apprentice Joined: 09 Jun 2002 Posts: 186 Location: USA

I was hoping this is possible.

There is a chart that says how much I need for each skill to advance in DR. I made a database with every field being a skill I need. In DR the skills go up the same for pretty much every level. What I want to do is this

Weapon1 for instance starts at 4 at level 2 and goes up by 2 every level there after. So at level 3 I need 6, etc. I was going to make it that each level was the corrosponding record number in the database. So I can just get the info for record 20 and it will be the info I need for level 20, etc.....

Anyway. What I want is to do something like that with all my skills.

If you would like to look at the skill chart that I am converting it from goto:

http://www.arcanewolf.com/thief/tfchart.html

Thank you

GURU Joined: 10 Oct 2000 Posts: 4379 Location: USA

If the question is if it is possible, then the answer is yes. If what you want is an idea on how to get the info into the database, then I suggest creating the fields in the database, then copying and pasting the tables into excel, export them as a CSV file and import the file into zMUD's database.

Apprentice Joined: 09 Jun 2002 Posts: 186 Location: USA

Gah! I don't have excel. Is there any other, possibly free, program that does the same thing?

Apprentice Joined: 09 Jun 2002 Posts: 186 Location: USA

Ok, I made a database in ZMUD, made the fields, and manually entered all the information.

Now all I need is to know how to get that info back out

What I want to do when the whole thing is done is this.

I want when I type MM 20 that is will get all the exp I currently have by using triggers, this I can do, then get the info from the MM database, record 20 and compare the values it got from my exp and the values in the record. It will say -# if I need more of that skill or +# if I am that much over of what I need...

I guess what I need to know is how to get the info out of the database now that it is in there.

These are the values for the fields I have....
Magic, PP, Astrology, Scholarship, Teaching, Lore1, Lore2, Survival1, Survival2, Survival3, Survival4, Survival5, Survival6, Survival7, Survival8

Thanks in advance

GURU Joined: 10 Oct 2000 Posts: 4379 Location: USA

To retrieve a specific record from the database sue the %dbget function:
#VAR record %dbget(20)

Now you can sue the %db function as normal with this record to extract any value given its key.

Apprentice Joined: 09 Jun 2002 Posts: 186 Location: USA

What exactly do you mean KEY? I was trying to find out what you mean by this by looking through the help files but couldn't find out what it means

Apprentice Joined: 09 Jun 2002 Posts: 186 Location: USA

AH! I got it! THanks

Apprentice Joined: 09 Jun 2002 Posts: 186 Location: USA

Well, I figured it out enough to get a working script. I am posting it in the finished script folder. What the script does is tells you what you need for a certain level. And how much more of the skills you need to get there....

THESE ARE FOR DRAGONREALMS