Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var express = require('express');
- var router = express.Router();
- var mysql = require('mysql');
- var MINIMAP_IMAGE_WIDTH = 1203, MINIMAP_IMAGE_HEIGHT = 554;
- var distributionPoints = function(xs) {
- var RESOLUTION = 10;
- var min = Math.floor(Math.min.apply(null, xs) * 10) / 10;
- var max = Math.floor(Math.max.apply(null, xs) * 10) / 10;
- var jumps = Math.round(((max-min)/RESOLUTION) * 100) / 100;
- console.log('xs: ' + xs);
- console.log('jumps: ' + jumps);
- console.log('min: ' + min);
- console.log('max: ' + max);
- var points = [
- /*
- {x: x,
- y: y
- }
- */
- ];// value: count
- for(var p = min; p < max + jumps; p += jumps) {
- points.push({
- x: Math.round(p * 100) / 100,
- y: 0
- });
- }
- for(var i = 0; i < xs.length; i++) {
- var matchingPoint = Math.round((Math.floor((xs[i] - min)/jumps)*jumps + min) * 100) / 100;
- for(var j = 0; j <points.length; j++) {
- if (points[j].x == matchingPoint) {
- points[j].y++;
- }
- }
- }
- if (points.length == 0 && xs.length != 0) {
- points.push({
- x: xs[0],
- y: 1
- });
- }
- console.log(points);
- return points;
- };
- /* GET home page. */
- router.get('/*', function(req, res, next) {
- var connection = mysql.createConnection({
- host : sqlHost,
- user : sqlUsername,
- password : sqlPassword,
- database : sqlDbName
- });
- connection.connect();
- var games;
- connection.query('SELECT * FROM games;', function(err, rows, fields) {
- if (!err) {
- games = rows;
- var teamNumber = req.url.slice(1);
- var infoType;
- if (teamNumber.indexOf('/') != -1) {
- infoType = teamNumber.slice(teamNumber.indexOf('/') + 1);
- teamNumber = teamNumber.slice(0, teamNumber.indexOf('/'))
- }
- var gameids = [];
- for (var i = 0;i<games.length;i++) {
- console.log('reviewed', typeof games[i].reviewed, games[i].reviewed);
- if (games[i].teamnumber == teamNumber && parseInt(games[i].reviewed) == 1){
- gameids.push(games[i].gameid);
- }
- }
- if (infoType == 'defense') {
- res.render('defense', { title: 'Express', teamNumber: teamNumber, games: JSON.stringify(games), gameids: gameids });
- return;
- }
- if (infoType == 'chassis') {
- res.render('chassis', { title: 'Express', teamNumber: teamNumber, games: JSON.stringify(games), gameids: gameids });
- return;
- }
- if (infoType == 'shooting') {
- res.render('shooting', { title: 'Express',teamNumber: teamNumber, games: JSON.stringify(games), gameids: gameids });
- return;
- }
- if (infoType == 'tower') {
- res.render('tower', { title: 'Express', teamNumber: teamNumber, games: JSON.stringify(games), gameids: gameids });
- return;
- }
- if (infoType == 'boulder') {
- res.render('boulder', { title: 'Express', teamNumber: teamNumber, games: JSON.stringify(games), gameids: gameids });
- return;
- }
- if (infoType == 'achievement'){
- res.render('achievement', { title: 'Express', teamNumber: teamNumber, games: JSON.stringify(games), gameids: gameids });
- return;
- }
- else if (err) {
- res.render('team', { title: 'Express', teamNumber: teamNumber, games: JSON.stringify(games)});
- }
- }});
- connection.end();
- });
- module.exports = router;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement