From 62b038cde3c8178b62ecbae1237046bec80dff4f Mon Sep 17 00:00:00 2001 From: tomsmeding Date: Thu, 16 Mar 2017 22:33:22 +0100 Subject: Include room and user in _push message --- db.c | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) (limited to 'db.c') 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); -- cgit v1.2.3-70-g09d2