Gammon Software Solutions forum

See www.mushclient.com/spam for dealing with forum spam. Please read the MUSHclient FAQ!

Entire forum
MUSHclient
Lua
sqlite variables

Home \| Users \| Search \| FAQ
Username:	Register forum user name
Password:	Forgotten password?

(New message)

Subject:	sqlite variables
Name:	Your forum user name. Register forum user name
Password:	Your forum password. Forgotten password?
Message:	[quote=Miloh] Hi Fiendish, you are the man!! That worked like a charm. Thank you very much. I had a feeling it was something like that. I did fail to mention that I tried everything I could think of with that pesky variable... Double quotes, no quotes at all, a ".." before the variable, a dollar sign... Anywho, again, thank you :) [/quote] Message to be posted (in English, please).
Forum codes:	Check this if your message uses 'forum codes' or templates (auto-detected for new posts). Forum codes Templates

Save this message ...

Subject review (reverse sequence)

Posted by

Fiendish USA (849 posts)

bio Global Moderator

Date

Sun 20 Nov 2011 05:36 AM (UTC) [ quote ]

Amended on Sun 20 Nov 2011 05:41 AM (UTC) by Fiendish

Message

Values for %1,%2,etc get mapped into place by MUSHclient before the Lua code gets sent to the script parser. That's the only reason you can use %2 in the way you did without breaking the query string apart into chunks (and which is why people need to wrap them in quotation marks to compare the values with strings). But MyRoom is just a Lua variable containing a string. In order to get the value from MyRoom you have to treat it as a variable and not just like some letters, which means pulling it outside of the string and using concatenation to merge the parts together.

You had
DatabasePrepare("mobs", "a_string")
when you needed
DatabasePrepare("mobs", "first_part_of_the_string"..your_variable.."the_rest_of_the_string")

http://aardwolfclientpackage.googlecode.com/

top

Posted by

Miloh (4 posts)

bio

Date

Sun 20 Nov 2011 05:26 AM (UTC) [ quote ]

Message

Hi Fiendish, you are the man!! That worked like a charm. Thank you very much. I had a feeling it was something like that. I did fail to mention that I tried everything I could think of with that pesky variable... Double quotes, no quotes at all, a ".." before the variable, a dollar sign...

Anywho, again, thank you :)

top

Posted by Fiendish USA (849 posts) bio Global Moderator

Date

Sun 20 Nov 2011 05:12 AM (UTC) [ quote ]

Amended on Sun 20 Nov 2011 05:14 AM (UTC) by Fiendish

Message

Quote:
VALUES ('%2','MyRoom')

I'm not sure what you expect that to do other than what is happening.

Perhaps you want instead

"INSERT INTO mobtable (mobname, roomname) VALUES ('%2','"..MyRoom.."')"

http://aardwolfclientpackage.googlecode.com/

top

Posted by Miloh (4 posts) bio

Date

Sun 20 Nov 2011 04:56 AM (UTC) [ quote ]

Amended on Sun 20 Nov 2011 05:02 AM (UTC) by Miloh

Message

Greetings all,

I am attempting to create a mob database with sqlite. The db is very simple - I just have two fields: mobname and roomname. Both fields go into the sqlite db. The problem is that one of the variables (MyRoom) is going into the db as the variable name itself. I am guessing this is a syntax thing? Any insight would be most appreciated. Here is what I am using:


<triggers>
  <trigger
   enabled="y"
   expand_variables="y"
   group="mobdb"
   match="^You get (.*) gold coin? from the dead body of (.*)\.$"
   regexp="y"
   send_to="12"
   sequence="100"
  >
  <send>local MyRoom
  
--RoomName set by another trigger elsewhere that captures roomname.
MyRoom = GetVariable("RoomName")

--ensure vars are correct
Note ("%2 is in ",MyRoom)

--begin db stuff

DatabaseOpen ("mobs", GetInfo (66) .. "mobs.db", 6)

-- insert a record
DatabasePrepare ("mobs", "INSERT INTO mobtable (mobname, roomname) VALUES ('%2','MyRoom')")  --&gt; returns 0 (SQLITE_OK)
DatabaseStep ("mobs")   -- returns 101 (SQLITE_DONE)
DatabaseFinalize ("mobs")  -- returns 0 (SQLITE_OK)
      
DatabaseClose ("mobs")  -- close it </send>
  </trigger>
</triggers>

And when I check the db, the "%2" or mobname goes in as correctly. But, for roomname, I get "MyRoom".

Thanks much in advance!

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.

928 views.

Reply to this subject Start a new subject Refresh page

Go to topic: Search the forum

top

Comments to: Gammon Software support
Forum RSS feed ( http://www.gammon.com.au/rss/forum.xml )