Howdy, Stranger!
Categories
- 6.2K All Categories
- 3.1K Everything Achaea
- 1.5K North of Thera
- 26 Archives of the Terraformer
- 256 The Matsuhama Arena
- 885 The Golden Dais of Creation
- 299 The Scarlattan Theatre
- 149 The Blank Canvas
- 2K Getting Help
- 412 General Questions
- 258 Quick Class Questions
- 1.3K Tech Support
- 313 Client Help
- 486 Curing Systems and Scripts
- 841 Off-Topic
- 255 The Wander Inn
- 586 The Universal Membrane
- 298 Class Discussions
- 298 Individual Class Sections
- 20 Alchemist
- 9 Apostate
- 30 Blademaster
- 9 Depthswalker
- 14 Druid
- 4 Infernal
- 20 Jester
- 19 Magi
- 34 Monk
- 11 Occultist
- 8 Paladin
- 7 Priest
- 29 Runewarden
- 18 Sentinel
- 26 Serpent
- 20 Shaman
- 9 Sylvan
[MUDLET] Databases
Klendathu
Eye of the Storm
in Client Help
I've decided to learn how to use databases for Mudlet, so am starting with a relatively simple idea, a way to store shrine locations. I've created the database (I can see the relevant file in my profile folder), but am encountering an error when I try to db:fetch...
kln = kln or {}
kln.db = kln.db or {}
db:create("klndb", {shrines={"divine","roomNum"}}) -- database is created
local klndb = db:get_database("klndb") -- assign database to variable name
kln.db.testAdd = function()
db:add(klndb.shrines,{divine="test",roomNum=1234})
end
kln.db.testShow = function()
display(db.fetch(klndb.shrines))
end
I don't get an error when running kln.db.testAdd() but when I try to run kln.db.testShow(), it returns the following error:
<mudlet-lua/lua/DB.lua:848: attempt to index local 'sheet' (a nil value)>
It returns the same error whether or not I'm using display(). I'm sure I've missed something trivial, but I'm falling at the first hurdle!
0
Comments
GMCP documentation: https://github.com/keneanung/GMCPAdditions
svof github site: https://github.com/svof/svof and documentation at https://svof.github.io/svof
Can a database be created in a different folder than the profile folder? If so, how? I've tried adding the path in the db:create line to no avail.
Excerpt from that function:
... db.__conn[db_name] = db.__env:connect(getMudletHomeDir() .. "/Database_" .. db_name .. ".db") ...GMCP documentation: https://github.com/keneanung/GMCPAdditions
svof github site: https://github.com/svof/svof and documentation at https://svof.github.io/svof
Thanks both, back to my musings