From 2844835b5061265d849e237ee937e3a2f9602b7e Mon Sep 17 00:00:00 2001
From: francis <francis>
Date: Fri, 9 May 2008 01:11:41 +0000
Subject: Oops.

---
 script/request-creation-graph | 7 ++++---
 1 file changed, 4 insertions(+), 3 deletions(-)

(limited to 'script/request-creation-graph')

diff --git a/script/request-creation-graph b/script/request-creation-graph
index d5d87063d..0bd0eee49 100755
--- a/script/request-creation-graph
+++ b/script/request-creation-graph
@@ -5,7 +5,7 @@
 # Copyright (c) 2008 UK Citizens Online Democracy. All rights reserved.
 # Email: francis@mysociety.org. WWW: http://www.mysociety.org/
 # 
-# $Id: request-creation-graph,v 1.1 2008-05-09 00:55:43 francis Exp $
+# $Id: request-creation-graph,v 1.2 2008-05-09 01:11:41 francis Exp $
 
 GPLOT_OUTPUT="set terminal png font 'Vera.ttf' 9 size 1200,400"
 EXTENSION=".png"
@@ -40,6 +40,7 @@ function grab_data {
         date(created_at), count(*)
         from info_requests
         $1
+        and prominence != 'backpage'
         group by date(created_at)
         order by date(created_at)
         ;" | psql --host $OPTION_FOI_DB_HOST --port $OPTION_FOI_DB_PORT -A -F " " $OPTION_FOI_DB_NAME $OPTION_FOI_DB_USER | egrep -v "date|rows" >$2
@@ -91,8 +92,8 @@ cat >$GPSCRIPT <<END
          "$SOURCEC" using 1:2 with impulses lt 5 lw 15 title "not_held",\
          "$SOURCED" using 1:2 with impulses lt 6 lw 15 title "rejected",\
          "$SOURCEE" using 1:2 with impulses lt 7 lw 15 title "successful",\
-         "$SOURCEE" using 1:2 with impulses lt 8 lw 15 title "partially_successful",\
-         "$SOURCEE" using 1:2 with impulses lt 9 lw 15 title "requires_admin",\
+         "$SOURCEF" using 1:2 with impulses lt 8 lw 15 title "partially_successful",\
+         "$SOURCEG" using 1:2 with impulses lt 9 lw 15 title "requires_admin",\
     "< awk 'BEGIN { n = 0 } { n += \$2; print \$1, \$2, n; }' $SOURCEA" using 1:3 axes x1y2 with lines lt 2 title "cumulative total number of requests"
 END
 #echo "gpscript $GPSCRIPT"
-- 
cgit v1.2.3