MudDatabase

Posted by Microphone on Wed 07 May 2003 08:08 PM — 7 posts, 25,019 views.

#0
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?
Australia Forum Administrator #1
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.
#2
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.
Australia Forum Administrator #3
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)
Amended on Tue 20 Nov 2007 04:16 AM by Nick Gammon
#4
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
#5
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.
Australia Forum Administrator #6
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.