Include room and user in _push message

1 files changed, 28 insertions, 0 deletions

diff --git a/db.c b/db.c
index e7740a0..80f9867 100644
--- a/db.c
+++ b/db.c
@@ -128,6 +128,20 @@ i64 db_find_room(const char *name){
 	return roomid;
 }
 
+char* db_get_roomname(i64 roomid){
+	sqlite3_stmt *stmt;
+	SQLITE(prepare_v2,database,"select name from Rooms where id = ?",-1,&stmt,NULL);
+	SQLITE(bind_int64,stmt,1,roomid);
+	const unsigned char *name_sq=NULL;
+	if(sqlite3_step(stmt)==SQLITE_ROW){
+		name_sq=sqlite3_column_text(stmt,0);
+	}
+	char *name=NULL;
+	if(name_sq)name=strdup((const char*)name_sq);
+	SQLITE(finalize,stmt);
+	return name;
+}
+
 struct db_room_list db_list_rooms(i64 userid){
 	sqlite3_stmt *stmt;
 	SQLITE(prepare_v2,database,
@@ -174,6 +188,20 @@ i64 db_create_user(const char *name,const char *pass){
 	}
 }
 
+char* db_get_username(i64 userid){
+	sqlite3_stmt *stmt;
+	SQLITE(prepare_v2,database,"select name from Users where id = ?",-1,&stmt,NULL);
+	SQLITE(bind_int64,stmt,1,userid);
+	const unsigned char *name_sq=NULL;
+	if(sqlite3_step(stmt)==SQLITE_ROW){
+		name_sq=sqlite3_column_text(stmt,0);
+	}
+	char *name=NULL;
+	if(name_sq)name=strdup((const char*)name_sq);
+	SQLITE(finalize,stmt);
+	return name;
+}
+
 char* db_get_pass(i64 userid){
 	sqlite3_stmt *stmt;
 	SQLITE(prepare_v2,database,"select pass from Users where id = ?",-1,&stmt,NULL);