Zugg Software :: View topic - Need help with a certain type of DB find script

Newbie Joined: 15 Oct 2007 Posts: 9

Ok, so I have an immortal bot on a mud who just runs quests, then displays the results on an item afterwards.
It needs to edit the items (which are player names in a room, ie. exa mordalphus would return my score), but
if the item doesnt exist (ie, the player hasn't played the game before) the bot has to create the item before it
can edit it.

I have a trigger to add names of people who are playing the quest for the first time to a DB, but I need to know:

Can you do an if statement that queries a DB?

Like... I want to do something like this:

#if {#find mordalphus gemallowed = null} {createitem mordalphus;editscore mordalphus}

in this case, character name is mordalphus, if he's not found in the DB, create the item, then edit it.

Any way to do this? just a true/false query to see if a DB entry exists?

-- mordalphus

Newbie Joined: 15 Oct 2007 Posts: 9

meh, i figured it out...

in case anyone is interested...

it's #if {%find(%1)} {createitem %1;editscore %1}