Notice: Any messages purporting to come from this site telling you that your password has expired, or that you need to verify your details, confirm your email, resolve issues, making threats, or asking for money, are
spam. We do not email users with any such messages. If you have lost your password you can obtain a new one by using the
password reset link.
Due to spam on this forum, all posts now need moderator approval.
Entire forum
➜ MUSHclient
➜ Tips and tricks
➜ Designing databases
It is now over 60 days since the last post. This thread is closed.
Refresh page
| Posted by
| Rjak
Romania (42 posts) Bio
|
| Date
| Sat 22 Mar 2003 02:52 PM (UTC) |
| Message
| How can I desig an items database? Like i said in my prevoius post, I know almost nothing about programming. Any links, any informational stuff will be of great help. If you don't want to spam this forum with newbie stuff, send me it directly to me. valu@home.ro
Rjak
PS Don't get me wrong, I don't want you to do this for me, (even i would like that, lol), i just want some directions where I can start.
Thank you. | | Top |
|
| Posted by
| Vaejor
(120 posts) Bio
|
| Date
| Reply #1 on Sat 22 Mar 2003 05:02 PM (UTC) |
| Message
| Well, I can think of a few more questions that should be asked before I could give any pointers.
1) How do you want to store this database information? Do you want to use a predesigned database solution?(Microsoft Access, MySQL) Do you want to just use a formatted text file?
2) Once you know how you want to store the data, how are you going to access it? MS Access is able to be accessed directly through ActiveX(anyone feel free to correct me if I'm spouting something incorrectly. I use this daily, but I don't keep up on the terminology well enough). I believe MySQL, MS Access and possibly text files can be accessed via ODBC connections using an ActiveX component.
The ActiveX component is important in this case, because VBScript can access databases directly and manipulate them more easily using these tools inside of the VBScript. Without them, you may just have to read in a long textfile, and manipulate all the data yourself inside your own VBScript code.
3) Now you know how you want to store it and how you will access it, decide what information you want to store. What information are you going to pull from the mud and store in the database. What information might you want to throw in in addition to things the mud might make available(area found in, mob found on, general personal description of item's usefulness). Plan out each field you will need, how much room you need for each field; if it will contain strings or numbers, etc.
4) Next is going to be storing the data. This depends primarily on how you are going to be getting to the data, so not much can be said about it now.
5) After you store the data, what do you want to do with it? There will probably need to be some way to retrieve data according to a request, and send it to your screen or send it to the mud. Figure out how you want to interact with your data once you have it.
Start with these questions and we can go from there. | | Top |
|
| Posted by
| Rjak
Romania (42 posts) Bio
|
| Date
| Reply #2 on Sat 22 Mar 2003 06:24 PM (UTC) |
| Message
| I want to "make" a database who can be accesses from Mushclient. Let's say... copy item properties then r-click. At this point, to have an option: copy items properties to data base.
The format is:
You pay X dollars to have a phantom mask apreaised.
The [public appraiser/Raymond, etc] gives you the following report:
item type is: clothing
weight: 5 lbs. recomeded retail value: 3000
Additional affects:
+ INT
+ FIGHT
- ENERGY
For a better understanding, "my" mud is Zone Runner, a high tech mud. Is skill based, and all you need in order to play needs to be learned. Also, if you want to be able to "analyze" an item, you have to be cyborg and learn that skill. Are public appraisers who gives you a rough ideea about the item properties, like in the example. But the name of the appraiser is not the same all the time.
I downloaded the pluggin, but i'm unable to manipulate it. Or I don't have enough knowledge.
Do you think is something can be done?
Rjak
| | Top |
|
| Posted by
| Nick Gammon
Australia (23,165 posts) Bio
Forum Administrator |
| Date
| Reply #3 on Sat 22 Mar 2003 09:57 PM (UTC) |
| Message
| You could do it, sure. What plugin did you download?
What I would do first is make a series of triggers that match on an appraisal, and store the results in local variables. For example, triggers like this:
* gives you the following report:
item type is: *
weight: * lbs. recommended retail value: *
Each trigger would store its wildcard (ie. the appraisal result) in a variable (you could do that without scripting even).
Then you might have an alias "update_database" that takes the most recent appraisal and store the results into an Access database. You need to make the appropriate tables first. :) |
- Nick Gammon
www.gammon.com.au, www.mushclient.com | | Top |
|
| Posted by
| Rjak
Romania (42 posts) Bio
|
| Date
| Reply #4 on Mon 24 Mar 2003 08:04 PM (UTC) |
| Message
| | the one with object databases, of course, but when I try to insall it, i receive a whole lot of error messages, and i have to admit, I don't even know what i have to do to correct them. | | Top |
|
| Posted by
| Nick Gammon
Australia (23,165 posts) Bio
Forum Administrator |
| Date
| Reply #5 on Tue 25 Mar 2003 05:51 AM (UTC) |
| Message
| Hard to comment without knowing the error messages, but I think the plugins page gives a link to a thread on the forum that explored some difficulties people had with the database. As with any external thing (like database DLLs) I am at the mercy of what you have installed on your system. :)
However if you are unfamiliar with databases and programming, perhaps some exploratory work with some simple databases would ease the pain later on. Try the mySQL site, they have quite a lot of information there, and SQL itself must be dealt with in thousands of web pages. |
- Nick Gammon
www.gammon.com.au, www.mushclient.com | | Top |
|
The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).
To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.
21,031 views.
It is now over 60 days since the last post. This thread is closed.
Refresh page
![[Go to top]](/images/gototop.gif)
top