fix gnuplot sql

diff --git a/templates/user.html.ep b/templates/user.html.ep
index c97731c..ae314fd 100644 (file)
--- a/templates/user.html.ep
+++ b/templates/user.html.ep
@@ -58,8 +58,10 @@
                        , function(code, response) {
                                console.debug( code, response );
                                self.ldap = response;
-                               self.gnuplot_sql = '/gnuplot?hide=1;with=points;sql=select timestamp,snrtx,attntx,pwrtx,pwrrx,attnrx,snrrx from adsl where username = \'' + response[0].cn + '\' order by timestamp desc limit 100';
-                               self.message = 'generating ADSL graph for '+response[0].cn;
+                               var sql = 'select timestamp,h->\'Max_down\' as Max_down,h->\'Max_up\' as Max_up from cpe_Davolink where username = \'' + response[0].cn + '\' order by timestamp desc limit 100';
+                               console.info( 'sql', sql );
+                               self.gnuplot_sql = '/gnuplot?hide=1;with=points;sql=' + sql;
+                               self.message = 'generating ADSL graph for '+response[0].cn + ' ' + sql;
                        }
                );
                self.message = 'LDAP search for '+self.selected_username;