· 6 years ago · Aug 29, 2019, 12:22 PM
1function add_update_room(uid, room)
2 sql = [[
3 INSERT OR REPLACE INTO rooms (uid, name, desc, area, fillcolour, fillbrush, bordercolour, info, notes, exits)
4 VALUES
5 (']]..uid..[[',
6 ']]..fix_sql(room.name)..[[',
7 ']]..fix_sql(room.desc)..[[',
8 ']]..fix_sql(room.area)..[[',
9 ']]..fix_sql(room.fillcolour)..[[',
10 ']]..fix_sql(room.fillbrush)..[[',
11 ']]..fix_sql(room.bordercolour)..[[',
12 ']]..fix_sql(room.info)..[[',
13 ']]..fix_sql(room.notes)..[[',
14 ']]..fix_sql(serialize.save_simple(room.exits))..[[')
15 ]]
16 run_sql(sql)
17end
18
19function check_create_db()
20 sql = [[
21 CREATE TABLE IF NOT EXISTS rooms (
22 uid TEXT PRIMARY KEY,
23 name TEXT,
24 desc TEXT,
25 area TEXT,
26 fillcolour INTEGER,
27 fillbrush INTEGER,
28 bordercolour INTEGER,
29 info TEXT,
30 notes TEXT,
31 exits TEXT
32 )
33 ]]
34 run_sql(sql)
35end