diff options
author | tomsmeding <tom.smeding@gmail.com> | 2017-03-15 10:20:55 +0100 |
---|---|---|
committer | tomsmeding <tom.smeding@gmail.com> | 2017-03-15 10:20:55 +0100 |
commit | a441b302c2c11c291df60fe642ec0d51646218dd (patch) | |
tree | 22200cb885c3b7e38871f3827490700606c025c2 /db.c | |
parent | f1634688d62f2a6115739b65a311ab2b1cf79764 (diff) |
Start with implementing online status etc for broadcasting
Diffstat (limited to 'db.c')
-rw-r--r-- | db.c | 15 |
1 files changed, 15 insertions, 0 deletions
@@ -170,6 +170,21 @@ i64 db_find_user(const char *name){ } +void db_create_message(i64 roomid,i64 userid,i64 timestamp,const char *message){ + sqlite3_stmt *stmt; + SQLITE(prepare_v2,database, + "insert into Messages (room, user, time, message) " + "values (?, ?, ?, ?)" + ,-1,&stmt,NULL); + SQLITE(bind_int64,stmt,1,roomid); + SQLITE(bind_int64,stmt,2,userid); + SQLITE(bind_int64,stmt,3,timestamp); + SQLITE(bind_blob,stmt,4,message,strlen(message),SQLITE_STATIC); + if(sqlite3_step(stmt)!=SQLITE_DONE)die_sqlite("sqlite3_step"); + SQLITE(finalize,stmt); +} + + void db_nullify_name_id(struct db_name_id ni){ if(ni.name)free(ni.name); } |