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
➜ Plugins
➜ MudDatabase
It is now over 60 days since the last post. This thread is closed.
Refresh page
| Posted by
| Microphone
(8 posts) Bio
|
| Date
| Wed 07 May 2003 08:08 PM (UTC) |
| Message
| | I just installed the MudDatabase plugin and since I'm pretty new to programming I have some questions. First, do I have to know Sql to make my database? Second, the alias I copied all the functions into my script and the alias MudDatabase:help gets the return message of script OnHelp not found. Third, are there any help files or anything that will help me figure out what I'm doing? | | Top |
|
| Posted by
| Nick Gammon
Australia (23,173 posts) Bio
Forum Administrator |
| Date
| Reply #1 on Thu 08 May 2003 09:42 AM (UTC) |
| Message
| You shouldn't have copied any aliases anywhere. I suggest you remove them. The "MudDatabase:help" alias is inside the plugin, it should just work when you type that. If you copy the alias from the plugin to the main world file then you have 2 aliases, the one you copied won't work.
No, you don't need to know SQL - if you want to modify the plugin it would help, to use it, no. Just type MudDatabase:help and see what it says. |
- Nick Gammon
www.gammon.com.au, www.mushclient.com | | Top |
|
| Posted by
| Microphone
(8 posts) Bio
|
| Date
| Reply #2 on Sun 11 May 2003 12:30 AM (UTC) |
| Message
| | Is there a way I can see my database? I got it set up, created the tables, but I don't know how to access it or put anything in the tables. | | Top |
|
| Posted by
| Nick Gammon
Australia (23,173 posts) Bio
Forum Administrator |
| Date
| Reply #3 on Sun 11 May 2003 12:56 AM (UTC) Amended on Tue 20 Nov 2007 04:16 AM (UTC) by Nick Gammon
|
| Message
| Apart from opening the database itself in Access, you can use the commands built into it.
eg.
addmud realms_of_despair smaug.org 4000 Realms of Despair MUD
MUD 'realms_of_despair' added to the database
listmuds
realms_of_despair IP: smaug.org Port: 4000
Realms of Despair MUD
1 MUD(s)
query SELECT * FROM muds
mud_id mud_name ip_address port description
1 realms_of_despair smaug.org 4000 Realms of Despair MUD
1 record(s)
|
- Nick Gammon
www.gammon.com.au, www.mushclient.com | | Top |
|
| Posted by
| Microphone
(8 posts) Bio
|
| Date
| Reply #4 on Sun 11 May 2003 06:57 PM (UTC) |
| Message
| Do I need to learn Sql for my scripts? I made the table Ramza Database and set it up in Access.
ID Name Member # Experience Strength
22 Ramza 1 0 10
Resistance Speed AC Intillect Aura HP Mana
5 7 10 5 10 50 50 | | Top |
|
| Posted by
| Microphone
(8 posts) Bio
|
| Date
| Reply #5 on Sun 11 May 2003 06:59 PM (UTC) |
| Message
| | I'm making a database that when someone whispers me join it will make a new record of them with those default statistics. I need to be able to retrieve those numbers and to be able to change them through my script. | | Top |
|
| Posted by
| Nick Gammon
Australia (23,173 posts) Bio
Forum Administrator |
| Date
| Reply #6 on Sun 11 May 2003 10:45 PM (UTC) |
| Message
| Ah I see, you are doing your own table.
Yes, you need to know a bit of SQL, the example plugin shows the general idea.
For instance, if your new table is called Ramza (in the existing database), then typing:
SELECT * FROM Ramza
should show any records you have put into that table. To get at individual pieces of data, look at the way the plugin did it for MUD names. |
- 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.
23,580 views.
It is now over 60 days since the last post. This thread is closed.
Refresh page
![[Go to top]](/images/gototop.gif)
top