Read user lines from database.

1 files changed, 17 insertions, 1 deletions

diff --git a/pg.pgc b/pg.pgc
index a2a0957..87c27b9 100644
--- a/pg.pgc
+++ b/pg.pgc
@@ -252,7 +252,7 @@ void pg_users_get(int channel) {
 	EXEC SQL BEGIN DECLARE SECTION;
 	int channel_id = channel;
 	VARCHAR nick[0x100];
-	int id = 0, words, characters, kicks, kicked, monolog_lines, monologs, seen_first, seen_last;
+	int id = 0, words, characters, kicks, kicked, monolog_lines, monologs, seen_first, seen_last, index, lines;
 	EXEC SQL END DECLARE SECTION;
 
 	EXEC SQL DECLARE usercursor CURSOR FOR SELECT id, nick, words, characters, kicks, kicked, monolog_lines, monologs, seen_first, seen_last
@@ -275,6 +275,22 @@ void pg_users_get(int channel) {
 		user->monologs = monologs;
 		user->seen_first = seen_first;
 		user->seen_last = seen_last;
+
+		EXEC SQL DECLARE userlinescursor CURSOR FOR SELECT time_index, lines FROM user_hours WHERE user_id = :id;
+		EXEC SQL OPEN userlinescursor;
+		EXEC SQL FETCH NEXT FROM userlinescursor INTO :index, :lines;
+
+		if(iserror())
+			goto pg_userlines_error;
+
+		do {
+			user->lines[index] = lines;
+			EXEC SQL FETCH NEXT FROM userlinescursor INTO :index, :lines;
+		} while(!iserror());
+
+pg_userlines_error:
+		EXEC SQL CLOSE userlinescursor;
+
 		EXEC SQL FETCH NEXT FROM usercursor INTO :id, :nick, :words, :characters, :kicks, :kicked, :monolog_lines, :monologs, :seen_first, :seen_last;
 	} while(!iserror());