//ALTER TABLE `site_stats` ADD `ssSchoolID` INT( 11 ) NULL DEFAULT NULL AFTER `ssIP` 

Ext.chart.Chart.CHART_URL = '/common/charts.swf';
     
     
  function windowStatViewer(loadMode){
    if (!canEdit)
      return false;


    var hourlyHitsDay = new Ext.data.Store({
      reader : new Ext.data.JsonReader({
          root : 'hourlyHitsDay'
        },[
          {name: 'name', mapping: 'name'},
          {name: 'total', mapping: 'total'}
        ]
      )
    });
    var hourlyHitsYesterday = new Ext.data.Store({
      reader : new Ext.data.JsonReader({
          root : 'hourlyHitsYesterday'
        },[
          {name: 'name', mapping: 'name'},
          {name: 'total', mapping: 'total'}
        ]
      )
    });
    var hourlyHitsWeek = new Ext.data.Store({
      reader : new Ext.data.JsonReader({
          root : 'hourlyHitsWeek'
        },[
          {name: 'name', mapping: 'name'},
          {name: 'total', mapping: 'total'}
        ]
      )
    });
    var store2 = new Ext.data.Store({
      autoLoad: true,
      url: '/ajax/stats/getLiveUsage2.cfm',
      reader: new Ext.data.JsonReader({},[]),
      listeners: {
        load: function(ds){
          hourlyHitsDay.loadData(store2.reader.jsonData);
          hourlyHitsYesterday.loadData(store2.reader.jsonData);
          hourlyHitsWeek.loadData(store2.reader.jsonData);
        }
      }
    });
    
    var visitoruserContainer = {};
    var browserosContainer = {};

    var mainHolder = new Ext.Panel({
      border: false,          
      layout: 'border',
      items: [
        {
          region: 'north', 
          margins:'10 10 10 10',
          cmargins:'3 3 3 3',
          baseCls: 'x-plain', 
          border: true, 
          html: '<strong>These statistics are calculated from the traffic to your entire district over the past 30 days</strong>'
        },
        new Ext.TabPanel({
                            activeTab: 0,
                            region: 'center',
                            id: 'siteConfigTabHolder',
                            deferredRender:true,
                            items: [visitoruserContainer,browserosContainer]
                          }),
        {
          region: 'south', 
          margins:'4 4 4 4',
          cmargins:'3 3 3 3',
          baseCls: 'x-plain', 
          border: true, 
          bodyStyle: 'font-size: 9px; color: #666; text-align: center',
          html: 'This module is still under construction. More features will be enabled shortly.'
        }]
    });
    
    if (loadMode){
      mainHolder.title = 'Stats';
      return mainHolder;
    }
      
    var winStatView = new Ext.Window({
          width:500,
          height:550,
          title: 'Site Statistics',
          layout:'fit',
          closeAction:'close',
          modal:true,
          closable:false,
          border:false,
          maximizable:true,
          items: mainHolder,
          buttons: [{ text: 'OK', handler: function(){ winStatView.close(); } }]
      });
    winStatView.show(this);
  }