Advertisement
Guest User

Untitled

a guest
Mar 2nd, 2016
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. var express = require('express');
  2. var router = express.Router();
  3. var mysql = require('mysql');
  4.  
  5. var MINIMAP_IMAGE_WIDTH = 1203, MINIMAP_IMAGE_HEIGHT = 554;
  6.  
  7. var distributionPoints = function(xs) {
  8.     var RESOLUTION = 10;
  9.     var min = Math.floor(Math.min.apply(null, xs) * 10) / 10;
  10.     var max = Math.floor(Math.max.apply(null, xs) * 10) / 10;
  11.     var jumps = Math.round(((max-min)/RESOLUTION) * 100) / 100;
  12.     console.log('xs: ' + xs);
  13.     console.log('jumps: ' + jumps);
  14.     console.log('min: ' + min);
  15.     console.log('max: ' + max);
  16.     var points = [
  17.         /*
  18.         {x: x,
  19.         y: y
  20.         }
  21.          */
  22.     ];// value: count
  23.     for(var p = min; p < max + jumps; p += jumps) {
  24.         points.push({
  25.                 x: Math.round(p * 100) / 100,
  26.                 y: 0
  27.             });
  28.     }
  29.     for(var i = 0; i < xs.length; i++) {
  30.         var matchingPoint = Math.round((Math.floor((xs[i] - min)/jumps)*jumps + min) * 100) / 100;
  31.         for(var j = 0; j <points.length; j++) {
  32.             if (points[j].x == matchingPoint) {
  33.                 points[j].y++;
  34.             }
  35.         }
  36.     }
  37.     if (points.length == 0 && xs.length != 0) {
  38.         points.push({
  39.             x: xs[0],
  40.             y: 1
  41.         });
  42.     }
  43.     console.log(points);
  44.     return points;
  45. };
  46.  
  47. /* GET home page. */
  48. router.get('/*', function(req, res, next) {
  49.  
  50.     var connection = mysql.createConnection({
  51.         host     : sqlHost,
  52.         user     : sqlUsername,
  53.         password : sqlPassword,
  54.         database : sqlDbName
  55.     });
  56.     connection.connect();
  57.     var games;
  58.     connection.query('SELECT * FROM games;', function(err, rows, fields) {
  59.         if (!err) {
  60.             games = rows;
  61.             var teamNumber = req.url.slice(1);
  62.             var infoType;
  63.             if (teamNumber.indexOf('/') != -1) {
  64.                 infoType = teamNumber.slice(teamNumber.indexOf('/') + 1);
  65.                 teamNumber = teamNumber.slice(0, teamNumber.indexOf('/'))
  66.             }
  67.             var gameids = [];
  68.             for (var i = 0;i<games.length;i++) {
  69.                 console.log('reviewed', typeof games[i].reviewed, games[i].reviewed);
  70.                 if (games[i].teamnumber == teamNumber && parseInt(games[i].reviewed) == 1){
  71.                     gameids.push(games[i].gameid);
  72.                 }
  73.             }
  74.             if (infoType == 'defense') {
  75.                 res.render('defense', { title: 'Express', teamNumber: teamNumber, games: JSON.stringify(games), gameids: gameids });
  76.                 return;
  77.             }
  78.             if (infoType == 'chassis') {
  79.                 res.render('chassis', { title: 'Express', teamNumber: teamNumber, games: JSON.stringify(games), gameids: gameids });
  80.                 return;
  81.             }
  82.             if (infoType == 'shooting') {
  83.                 res.render('shooting', { title: 'Express',teamNumber: teamNumber, games: JSON.stringify(games), gameids: gameids });
  84.                 return;
  85.             }
  86.             if (infoType == 'tower') {
  87.                 res.render('tower', { title: 'Express', teamNumber: teamNumber, games: JSON.stringify(games), gameids: gameids });
  88.                 return;
  89.             }
  90.             if (infoType == 'boulder') {
  91.                 res.render('boulder', { title: 'Express', teamNumber: teamNumber, games: JSON.stringify(games), gameids: gameids });
  92.                 return;
  93.             }
  94.             if (infoType == 'achievement'){
  95.                 res.render('achievement', { title: 'Express', teamNumber: teamNumber, games: JSON.stringify(games), gameids: gameids });
  96.                 return;
  97.             }
  98.         else if (err) {
  99.             res.render('team', { title: 'Express', teamNumber: teamNumber, games: JSON.stringify(games)});
  100.         }
  101.     }});
  102.  
  103.     connection.end();
  104.  
  105.  
  106. });
  107.  
  108. module.exports = router;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement