Guest User

Untitled

a guest
Mar 2nd, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.78 KB | None | 0 0
  1. 'use strict';
  2.  
  3. const path = require('path');
  4.  
  5. module.exports = {
  6. entry: './src/main.js',
  7. target: 'node',
  8. output: {
  9. filename: 'gept_api.js',
  10. path: path.resolve(__dirname, 'dist'),
  11. },
  12. node: {
  13. __dirname: true,
  14. },
  15. };
  16.  
  17. TypeError: Cannot read property 'query' of undefined
  18. at Object.getItem (C:UsersfreekDropboxCodeAppsGEPTGEPTv2_APIdistgept_api.js:1:154359)
  19. at t.db_pool.getConnection (C:UsersfreekDropboxCodeAppsGEPTGEPTv2_APIdistgept_api.js:1:154841)
  20. at c._callback (C:UsersfreekDropboxCodeAppsGEPTGEPTv2_APIdistgept_api.js:1:68269)
  21. at c.end (C:UsersfreekDropboxCodeAppsGEPTGEPTv2_APIdistgept_api.js:1:8397)
  22. at C:UsersfreekDropboxCodeAppsGEPTGEPTv2_APIdistgept_api.js:1:322509
  23. at Array.forEach (<anonymous>)
  24. at C:UsersfreekDropboxCodeAppsGEPTGEPTv2_APIdistgept_api.js:1:322487
  25. at process._tickCallback (internal/process/next_tick.js:112:11)
  26.  
  27. 'use strict';
  28.  
  29. var mysql = require('mysql');
  30. var secret = require('./db-secret');
  31.  
  32. module.exports = {
  33. name: 'gept_api',
  34. hostname: 'https://api.toxsickproductions.com/gept',
  35. version: '1.3.0',
  36. port: process.env.PORT || 1910,
  37. db_pool: mysql.createPool({
  38. host: secret.host,
  39. port: secret.port,
  40. user: secret.user,
  41. password: secret.password,
  42. database: secret.database,
  43. ca: secret.ca,
  44. }),
  45. };
  46.  
  47. pool.getConnection((err, connection) => {
  48. PlayerRepository.getPlayer(req.params.username, connection, (statusCode, player) => {
  49. connection.release();
  50. res.status(statusCode);
  51. res.send(player);
  52. return next();
  53. });
  54. });
  55.  
  56. /** Get the player, and logs to HiscoreSearch if exists.
  57. *
  58. * Has callback with statusCode and player. Status code can be 200, 404 or 500.
  59. * @param {string} username The player's username.
  60. * @param {connection} connection The mysql connection object.
  61. * @param {(statusCode: number, player: { username: string, playerType: string }) => void} callback Callback with statusCode and the player if found.
  62. */
  63. function getPlayer(username, connection, callback) {
  64. const query = 'SELECT p.*, pt.type FROM Player p JOIN PlayerType pt ON p.playerType = pt.id WHERE username = ?';
  65.  
  66. connection.query(query, [username.toLowerCase()], (outerError, results, fields) => {
  67. if (outerError) callback(500);
  68. else if (results && results.length > 0) {
  69. logHiscoreSearch(results[0].id, connection, innerError => {
  70. if (innerError) callback(500);
  71. else callback(200, {
  72. username: results[0].username,
  73. playerType: results[0].type,
  74. deIroned: results[0].deIroned,
  75. dead: results[0].dead,
  76. lastChecked: results[0].lastChecked,
  77. });
  78. });
  79. } else callback(404);
  80. });
  81. }
Add Comment
Please, Sign In to add comment