diff options
| author | David Sommerseth <dazo@users.sourceforge.net> | 2009-11-03 11:01:08 +0100 |
|---|---|---|
| committer | David Sommerseth <dazo@users.sourceforge.net> | 2009-11-03 11:01:08 +0100 |
| commit | e0d7e5a73c666a07475001921e4b6fd7f742dbe6 (patch) | |
| tree | 36fa5008549c0513ed303e8d00ed7da41a30cc76 /database | |
| parent | 89af818dd8de703222fe2273c31fcb6b041dc6ee (diff) | |
| download | eurephia-e0d7e5a73c666a07475001921e4b6fd7f742dbe6.tar.gz eurephia-e0d7e5a73c666a07475001921e4b6fd7f742dbe6.tar.xz eurephia-e0d7e5a73c666a07475001921e4b6fd7f742dbe6.zip | |
sqlite: Did not retrieve all certificate information correctly
On user accounts with several certificates associated, it did only
list up one certificate several times.
Diffstat (limited to 'database')
| -rw-r--r-- | database/sqlite/administration/useraccount.c | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/database/sqlite/administration/useraccount.c b/database/sqlite/administration/useraccount.c index b0613a5..17b9330 100644 --- a/database/sqlite/administration/useraccount.c +++ b/database/sqlite/administration/useraccount.c @@ -197,24 +197,24 @@ static xmlDoc *useracc_view(eurephiaCTX *ctx, unsigned int infoType, cert = xmlNewChild(info_n, NULL, (xmlChar *) "certificate", NULL); assert( cert != NULL ); - sqlite_xml_value(cert, XML_ATTR, "certid", qres, 0, 6); - sqlite_xml_value(cert, XML_ATTR, "depth", qres, 0, 0); - sqlite_xml_value(cert, XML_ATTR, "registered", qres, 0, 5); - sqlite_xml_value(cert, XML_NODE, "digest", qres, 0, 1); + sqlite_xml_value(cert, XML_ATTR, "certid", qres, i, 6); + sqlite_xml_value(cert, XML_ATTR, "depth", qres, i, 0); + sqlite_xml_value(cert, XML_ATTR, "registered", qres, i, 5); + sqlite_xml_value(cert, XML_NODE, "digest", qres, i, 1); - tmp = (xmlChar *)sqlite_get_value(qres, 0, 2); + tmp = (xmlChar *)sqlite_get_value(qres, i, 2); xmlReplaceChars(tmp, '_', ' '); xmlNewChild(cert, NULL, (xmlChar *) "common_name", tmp); - tmp = (xmlChar *)sqlite_get_value(qres, 0, 3); + tmp = (xmlChar *)sqlite_get_value(qres, i, 3); xmlReplaceChars(tmp, '_', ' '); xmlNewChild(cert, NULL, (xmlChar *) "organisation", tmp); - sqlite_xml_value(cert, XML_NODE, "email", qres, 0, 4); + sqlite_xml_value(cert, XML_NODE, "email", qres, i, 4); - acpr = sqlite_xml_value(cert, XML_NODE, "access_profile", qres, 0, 8); - sqlite_xml_value(acpr, XML_ATTR, "accessprofile", qres, 0, 7); - sqlite_xml_value(acpr, XML_ATTR, "fwdestination", qres, 0, 9); + acpr = sqlite_xml_value(cert, XML_NODE, "access_profile", qres, i, 8); + sqlite_xml_value(acpr, XML_ATTR, "accessprofile", qres, i, 7); + sqlite_xml_value(acpr, XML_ATTR, "fwdestination", qres, i, 9); } } sqlite_free_results(qres); |