Start with implementing online status etc for broadcasting

1 files changed, 15 insertions, 0 deletions

diff --git a/db.c b/db.c
index 068817c..fa7603c 100644
--- a/db.c
+++ b/db.c
@@ -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);
 }