diff options
Diffstat (limited to 'db.c')
-rw-r--r-- | db.c | 28 |
1 files changed, 28 insertions, 0 deletions
@@ -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); |