From 014a6394e4268ee698f02aede381acc772abd20d Mon Sep 17 00:00:00 2001 From: Jon Bergli Heier Date: Wed, 17 Nov 2010 21:56:18 +0100 Subject: Read user lines from database. --- pg.pgc | 18 +++++++++++++++++- 1 file changed, 17 insertions(+), 1 deletion(-) 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()); -- cgit v1.2.3