Zugg Software :: View topic

Newbie Joined: 21 Nov 2003 Posts: 1 Location: USA

Hello,
I am trying to create a database of equipment so that I can then take the database into mySQL, and post it on to my guild's web site.

I would probably consider myself an average scriptor of zMUD, but I just recently started learning about more advanced triggers, and I have only briefly looked at the database feature. From what I have seen, what I want to do can definitely be done. I just am not sure where to start. So without any more babbling, I will get to my questions :-).

First of all, I play Medievia. What I would like to do is any time I use a scroll of identify, appraise an item, or compare items, it will look in the database to see if the exact item is already there, and if not it will create a new entry.

The information that I would like to include in the database is the basics. The name of the item, the location that you wear it, the minimum level requirement if above 0, special attributes, if it is a weapon it will have the dxd, any class requirements, and the condition it is in.

I don't have the exact text as of right now, so if anybody is familiar with Medievia, that would be great if you could help. If not, I will find all of the text that is shown so that you can get an idea of what it looks like.

So basically, I would like somebody to let me know the best way to configure the database (such as what fields I should have), how I should set up my triggers, and how to convert the .dbt to a basic .csv (or something that would be compatible with mySQL).

Thank you very much for your time, and I look forward to hearing how this would be done.

Thank you,
Buddy Bryan

Enchanter Joined: 20 Nov 2002 Posts: 627 Location: USA

Wow you ask alot, and I would not be suprised if you did not get your answer.

Your only shot is that if someone plays that mud and already has spen some considerable time making this exact thing.

If You feel that you are an average scriptor that you sould know by know that the best way to do this is to learn how yourself.

I am not picking on you, it's just that what you want thakes considerable amount of time and energy and your asking for it freely.

So I will give you a push in the right direction,

1)First do a search on this forum for anything related with MEDEVIL
2)read those findings
3)The Finished Scripts Forum here has TWO SCRIPTS that do EXACTLY that but for a different mud, so it is not hard to make it work with other muds IF your an AVERAGE scriptor.

4)Read the HELP file ABOUT the database and all the files and COMMANDS associated with it.

These suggestions should put you on the path with greatness.

One Last Example to help you get started to LEARN.
#trigger {you idintifiy a (%w)} {#temp {^$} {#t- getinfo};#t+ getinfo}
#trigger "getinfo" {(*)} {newinfo="%1"}

Start with something like that
but I guess if you show your example and all the info like you suggested someone will help you or do it for you.