diff options
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); } |