Zugg Software :: View topic

Novice Joined: 30 Jan 2006 Posts: 41

Could someone help me with this equip database, I'm trying to use Dharkael's Python script. This is what I have so far.

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

That's a script alright, but what exactly is the problem you're having?
How can we help?

Novice Joined: 30 Jan 2006 Posts: 41

Well it doesn't seem to add anything into the database.

Wizard Joined: 22 Mar 2007 Posts: 2320

I only have a moment to glance at it, but take a look at the RecordAdd alias. Might it be possible that you need some spaces within your strings? Specifically, a space between 'table' and the quotation mark, and another space between the quotation mark and 'VALUES'. It looks to me like you are trying to concatenate strings there, and spaces will not be automatically inserted during concatenation.

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

Alias ID:
You cast Identify then immediately call your RecordAdd alias without waiting for the results, even if your RecordAdd alias was correct It would have no information to add.

Alias RecordAdd:
Are you trying to use the CMUD database or the Sqlite Component?
The two are very different things.
#DBFIRST
#WHILE (!%null(%rec))
#DBNEXT
Have nothing to do with the Sqlite Component
Assuming You're want to use the Sqlite component.
Have you actually created any of these tables you're trying to add information to?
The SQL syntax to enter info into a table is

Novice Joined: 30 Jan 2006 Posts: 41

Ok, so my RecordAdd alone doesn't work, so i tried a lasterror thing you showed on your original Python Script thread and got.

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

The syntax is not

Novice Joined: 30 Jan 2006 Posts: 41

Yeah, I fixed that part already and still got the same thing.

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

Well if you fix THAT part there should be a new error message.
Show the code that you're currently using in the alias.
And the error messages you're getting

Novice Joined: 30 Jan 2006 Posts: 41

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

Okay so what exactly are typing in to get this error?
I mean I don't see the code you're using to retrieve the error message.
If thats the Alias how are you using this alias what exactly are you typing in to get this message?

Novice Joined: 30 Jan 2006 Posts: 41

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

Okay I see now. My fault: Change the beginning of the string to INSERT INTO Equip

Novice Joined: 30 Jan 2006 Posts: 41

Ok, got the recordadding part done. How would I go about with using my id alias with the record adding now?

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

Bah, I was really hoping someone else would take it from here :p
There are many threads on here that demo how to write a trigger-set to capture Identifications.
At the very least you should post examples of you casting identify on various objects including any prompts that follow,
so it can be seen how your MUD delineates identifications.

Novice Joined: 30 Jan 2006 Posts: 41

Armor Identify

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

I'd say you need to remove the call to the Recordadd alias in your Id alias
and build a prompt trigger in your identify class
In that prompt trigger is where I would call Recordadd and it looks like you already have a call in RecordAdd to #T- to then disable the identify class.

Basically the problem with calling Recordadd in your Id alias is
you need time to your identify triggers to collect data before inserting it into your database.

Novice Joined: 30 Jan 2006 Posts: 41

Thanks for the help Dharkael. It works

Novice Joined: 30 Jan 2006 Posts: 41

Ok, now how would I go about adding local variables to it?

Posted: Sun May 04, 2008 10:08 pm

Adding their values to the database, or adding them to your script in some way? Because I don't think that there's anything that requires local variables here. You need to store your values in global variables so they're available for RecordAdd, and you're not doing any logic that requires them.

Novice Joined: 30 Jan 2006 Posts: 41

Adding them to my script, than adding the values to the database.

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

I think what Fang is trying to get across is that there appears to be no need or benefit to be had by using local variables in this case.
The values from your identify triggers must be stored in a global variable to be accessed by RecordAdd and those are the only variables at play in this scenario