kciRP62X

1--Rollanz's MushClient names database script
2
3ndb = ndb or {}
4ndb.namedb = sqlite3.open(GetInfo(66).."ndb.sqlite3")
5
6function ndb:init()
7  self.namedb:execute[[
8    PRAGMA journal_mode = WAL;
9    CREATE TABLE IF NOT EXISTS adventurers (
10      name TEXT PRIMARY KEY,
11      city TEXT,
12      enemy INTEGER,
13      pirate INTEGER,
14      note TEXT,
15      date_added DATE
16    );
17  ]]
18end --ndb:init
19
20function ndb:add(name,city)
21  if not name or not city then
22    return
23  end
24  self.namedb:execute(string.format(
25    [[INSERT OR REPLACE INTO adventurers(name, city)
26    VALUES ('%s', '%s');]], name, city))
27end --ndb:add
28
29function ndb:getPlayer(name)
30  if not name then
31    return
32  end
33  for player in self.namedb:nrows(string.format(
34    [[SELECT * FROM adventurers where name = '%s']], name)
35  ) do
36    return player
37  end
38end
39
40ndb:init()