Zugg Software :: View topic - updating and extracting database in cmud when command(s) are given.

Beginner Joined: 18 Aug 2009 Posts: 14

I am new to database, and have been thinking for years, to make one, and upon reading help files being dumbfounded.

yes. I know how to create any trigger possible with variables, multiple trigger lines, and usually end up storing data in variables instead of a database.

now here is what Im looking at:
[46 class1 ] name0 (Lich)
[46 class1 ] name1 title (Lich)
[45 class2 ] name2 this is a bigger title clan1 (Phantom)
[42 class3 ] name3 amazing long title that I wouldnt need clan2 (Barbarian)

So I figure, with around 300 people on and off the mud I see their race and have to make a trigger when they enter my room/when I type look and output some info on what their class is, as I am very fragile to some class. pvp by the way.

so what I found trying to code this, was. variables dont stand a chance to hold the data I need. or I can make a trigger for each name and #echo it, which I would have to update.

I am sorry for asking. but how in gods name do I find info on how to create the database, and upon typing who update the database on their race and class name to display with a #echo?

I dont need the triggers, I need to know the commands to update and extract info to and from the database.

the actual triggers I use is to trigger when I look or enter a room on top of someone, to display their class and level.

Posted: Sun Aug 26, 2012 6:57 pm

depends on if you mean an actual sql database, or a variable database, i prefer the variable method myself

Read the various #HELP files: #ADDKEY, #DELKEY #SHOWDB

Beginner Joined: 18 Aug 2009 Posts: 14

I mean the database inside cmud.

I found &class lists the variable but I want to learn using the cmud database to later develope a item database. so I start off easy.

I just need to know:

Add a field value (I have 4 fields, level class name race)

update fields level
check if record for name exists
display a field(s) in #echo

#addkey will not work as #showdb lists several lines. I can have up to 20 enemies in a single room.

GURU Joined: 23 Dec 2000 Posts: 4834 Location: USA

The in-cmud database module is a REALLY old feature, and is a proprietary flat-file format (no other database applications can read it). It's relatively buggy, and most users are either not using it or have switched to the SQL features. If you really want to learn how to use it, open up the Documents window (Help menu, the Contents option will take you there) and start looking under the Feature Reference section.

Beginner Joined: 18 Aug 2009 Posts: 14

what did I do wrong here?
field1 is name
field2 is race
field3 is class
field4 is level
this is the trigger action:
and I get a error: does not compile

%3 is in trigger the name

#if {%iskey(name) = %3}
{#echo already in}
{#addkey {name=%3|level=%1|class=%2|race=%4}
}

GURU Joined: 23 Dec 2000 Posts: 4834 Location: USA

Proper syntax matters in cmud. () has to go around expression arguments (see the #if helpfile).

Beginner Joined: 18 Aug 2009 Posts: 14

thank you for that excess of retorical exponation.

alright. so back to database inside cmud. I will have to figure out how to use it, unless someone has an example of how its used. this would be greatly appreciated.

Posted: Sun Aug 26, 2012 9:20 pm

I can give you plenty of examples for a dbVariable, but the module you are using i never bothered with... how married are you to using that DB?

Posted: Sun Aug 26, 2012 9:26 pm

#ADDKEY people.merlin {class=wizard}
#ADDKEY people.merlin {race=human}
#SHOWDB @people.merlin

#SAYADD @people.merlin.class @people.merlin.race

Wizard Joined: 22 Mar 2007 Posts: 2320

Beginner Joined: 18 Aug 2009 Posts: 14

Wizard Joined: 22 Mar 2007 Posts: 2320

If you know SQL, connecting a database to Cmud is actually quite easy. The only commands and functions that you need are: #SQLDB[to create a connection and open it] or %sqldb() [to create a connection and return a COM object] , #SQLCLOSE [to close a connection], and %sql() [to execute an arbitrary SQL command string]. All of these are documented.

One limitation is that if you want to use something other than SQLite, you need CmudPro. But SQLite will probably be sufficient for you?

Here are a couple examples:

GURU Joined: 23 Dec 2000 Posts: 4834 Location: USA

Beginner Joined: 18 Aug 2009 Posts: 14

cool. I have cmud pro already. however I decided to use mysql.

Going to attempt to make triggers like specified by you earlier. also, a identify script :)

Beginner Joined: 18 Aug 2009 Posts: 14

so I use this on mysql ...

db = %sqldb("MyDB", "dbname", "mysql", "localhost", 3306)
db.LoginPrompt = 1
#CALL @db.Open
#CALL @db.Execute(%concat("INSERT INTO chartable (Name, Race, Class, Level) VALUES ('", %1, "', '", %2, "', '", %3, "', '", %4, "')"))
#CALL @db.Close

Dont I have to type a password to enter into it? also, how do I get the database to load a certain character's specifications into cmud pro?
like, and echo or show.

thanks for all your help already! awesome!
edit:
also.... I would want no duplicate entries for a name..

Sorcerer Joined: 15 Apr 2011 Posts: 809

It should prompt you for a username and password when you open the database, since you set LoginPrompt to 1. You could also hardcode the username and password if you want, with this code: db = %sqldb("MyDB", "dbname", "mysql", "localhost", 3306, "username", "password"). That's less hassle for you, since you won't need to type the password every time you want to open the database, but it's less secure, anyone who gets their hands on your settings can just look at your password in plaintext.

Rahab's first example shows how you would use %sql to select data from the database. Preventing duplicate entries would fall into the realm of table design - make the name a primary key and you won't be able to duplicate it.

Beginner Joined: 18 Aug 2009 Posts: 14

how about "ansi" trigger for a equipment database? so the duplicates with diffrent colors react one way?

Wizard Joined: 22 Mar 2007 Posts: 2320

I'm not sure what you mean. Do you actually want to store the color in the database? If you do, how do you want it to handle a red "myname" when there is already a green "myname" in the database? Do you want the red version to replace the green one, or become a new entry? Your question is a bit confusing.