thingy

app.js

var express = require('express');
var path = require('path');
var favicon = require('serve-favicon');
var logger = require('morgan');
var cookieParser = require('cookie-parser');
var bodyParser = require('body-parser');
var sheets = require('google-spreadsheet')

var wc3 = require ('./wc3');

var app = express();

// view engine setup
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'jade');

// uncomment after placing your favicon in /public
//app.use(favicon(path.join(__dirname, 'public', 'favicon.ico')));
app.use(logger('dev'));
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: false }));
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));

app.get('/', wc3);

// catch 404 and forward to error handler
app.use(function(req, res, next) {
  var err = new Error('Not Found');
  err.status = 404;
  next(err);
});

// error handlers

// development error handler
// will print stacktrace
if (app.get('env') === 'development') {
  app.use(function(err, req, res, next) {
    res.status(err.status || 500);
    res.render('error', {
      message: err.message,
      error: err
    });
  });
}

// production error handler
// no stacktraces leaked to user
app.use(function(err, req, res, next) {
  res.status(err.status || 500);
  res.render('error', {
    message: err.message,
    error: {}
  });
});



module.exports = app;

index.jade

// in views directory

doctype html
html(lang="en")
	head
		title= help
		
	body
		h1 Hello, world!
		
		ul
			each val in elements
				li= val

wc3.js

var express = require('express');
var router = express.Router();
var app = express();
var GoogleSpreadsheet = require('google-spreadsheet')
var path = require('path');


//buildSheet();

function buildSheet(req, res) {
	console.log('hello world');
	
	var doc_key = "1SlCyQuSjfqpoCnqMqTWalkUbVaFBxHa8osgV70BoUZI";
	var doc = new GoogleSpreadsheet(doc_key);
	var sheet;
	doc.getInfo(function(err, info) {
		console.log('Loaded doc: '+info.title+' by '+info.author.email);
		sheet = info.worksheets[0];
		console.log('sheet 1: '+sheet.title+' '+sheet.rowCount+'x'+sheet.colCount);
		
		sheet.getRows({
			offset: 1,
			orderby: 'col2'
		}, 
		function maps ( err, rows, response ){
			console.log('Read '+rows.length+' rows');
			// Places maps inside an array
			maps = []
		  
			for(var i = 0; i < rows.length; i++) {
			  maps[i] = rows[i].mapname;
			}
			// Generates random numbers to determine what maps are chosen
			var arr = []
			
			while(arr.length < 10){
				var randomnumber=Math.ceil(Math.random()*rows.length - 1)
				var found=false;
				
				for(var i=0;i<arr.length;i++){
					if(arr[i]==randomnumber){found=true;break}
				}
				
				if(!found)arr[arr.length]=randomnumber;
			}
			console.log(arr)
			// Chooses random maps
			var rngMaps = []
			for(var i = 0; i < 10; i++) {
				rngMaps.push(maps[arr[i]])
			}
			
			//result(rngMaps);
			res.render('index', {
				elements: rngMaps
			});
		});
	});
}

/*function result(element) {
	console.log(element);
	res.render('index', {elements: element});
}*/
module.exports = function(req, res) {
	buildSheet(req, res);
}

/*
app.all('/send_data', function(req, res) {
	res.render('index.jade', {foo: 'bar'});
});

module.exports = app;*/