liquid_feedback_core
changeset 371:8344753f2ac1
For suggestions without individual rankings, set "proportional_order" to zero instead of NULL
author | jbe |
---|---|
date | Sun Mar 17 17:13:45 2013 +0100 (2013-03-17) |
parents | 794974af6d6d |
children | 5f3cd73f328d |
files | lf_update_suggestion_order.c |
line diff
1.1 --- a/lf_update_suggestion_order.c Sun Mar 17 16:15:28 2013 +0100 1.2 +++ b/lf_update_suggestion_order.c Sun Mar 17 17:13:45 2013 +0100 1.3 @@ -154,12 +154,12 @@ 1.4 char *cmd; 1.5 int i; 1.6 if (final) { 1.7 - if (asprintf(&cmd, "BEGIN; UPDATE \"initiative\" SET \"final_suggestion_order_calculated\" = TRUE WHERE \"id\" = %s; UPDATE \"suggestion\" SET \"proportional_order\" = NULL WHERE \"initiative_id\" = %s", escaped_initiative_id, escaped_initiative_id) < 0) { 1.8 + if (asprintf(&cmd, "BEGIN; UPDATE \"initiative\" SET \"final_suggestion_order_calculated\" = TRUE WHERE \"id\" = %s; UPDATE \"suggestion\" SET \"proportional_order\" = 0 WHERE \"initiative_id\" = %s", escaped_initiative_id, escaped_initiative_id) < 0) { 1.9 fprintf(stderr, "Could not prepare query string in memory.\n"); 1.10 abort(); 1.11 } 1.12 } else { 1.13 - if (asprintf(&cmd, "BEGIN; UPDATE \"suggestion\" SET \"proportional_order\" = NULL WHERE \"initiative_id\" = %s", escaped_initiative_id) < 0) { 1.14 + if (asprintf(&cmd, "BEGIN; UPDATE \"suggestion\" SET \"proportional_order\" = 0 WHERE \"initiative_id\" = %s", escaped_initiative_id) < 0) { 1.15 fprintf(stderr, "Could not prepare query string in memory.\n"); 1.16 abort(); 1.17 }