#! /bin/sh

cd /var/alternc/html/e/ecosociete/stats/sigs
for graph in signature lettre_au_ministre
do
    mysql --defaults-file=/etc/alternc/my.cnf -BN -e 'set @t1=0; select @t1:=(@t1+1),nid,FROM_UNIXTIME(`created`) + 0  from node where type="'$graph'" order by created ASC;' ecosociete_drupal > slapp_${graph}_in_time
done

gnuplot <<EOF
set xdata time
set timefmt "%Y%m%d" 
set timefmt "%Y %m %d %H %M %S"
set autoscale
set xrange ["20080517":]
set terminal png
set output "support_in_time.png"
set grid
plot "slapp_signature_in_time" using 3:1 title "Signatures" with lines, "slapp_lettre_au_ministre_in_time" using 3:1 title "Lettres au ministre" with lines
EOF