liquid_feedback_core

diff lf_update.c @ 235:2a6984869ba3
Delete sessions:
- when they expire
- in function "delete_private_data" (security relevant in certain setups)
- in function "delete_member"

(Sessions had been removed in changeset ed2f94a397cd and re-added in changeset 4e3d8f1ca3a9 without mechanisms for deletion of sessions)
author: jbe
date: Tue Mar 13 18:04:53 2012 +0100 (2012-03-13)
parents: af3d208e81be
children: a2ab4fb1d0c7
     1.1 --- a/lf_update.c	Sun Mar 11 18:48:51 2012 +0100
     1.2 +++ b/lf_update.c	Tue Mar 13 18:04:53 2012 +0100
     1.3 @@ -54,6 +54,22 @@
     1.4      return 1;
     1.5    }
     1.6  
     1.7 +  // delete expired sessions:
     1.8 +  status = PQexec(db, "DELETE FROM \"expired_session\"");
     1.9 +  if (!status) {
    1.10 +    fprintf(stderr, "Error in pqlib while sending SQL command deleting expired sessions\n");
    1.11 +    err = 1;
    1.12 +  } else if (
    1.13 +    PQresultStatus(status) != PGRES_COMMAND_OK &&
    1.14 +    PQresultStatus(status) != PGRES_TUPLES_OK
    1.15 +  ) {
    1.16 +    fprintf(stderr, "Error while executing SQL command deleting expired sessions:\n%s", PQresultErrorMessage(status));
    1.17 +    err = 1;
    1.18 +    PQclear(status);
    1.19 +  } else {
    1.20 +    PQclear(status);
    1.21 +  }
    1.22 + 
    1.23    // check member activity:
    1.24    status = PQexec(db, "SELECT \"check_activity\"()");
    1.25    if (!status) {
author	jbe
date	Tue Mar 13 18:04:53 2012 +0100 (2012-03-13)
parents	af3d208e81be
children	a2ab4fb1d0c7