Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 'use strict';
- const path = require('path');
- module.exports = {
- entry: './src/main.js',
- target: 'node',
- output: {
- filename: 'gept_api.js',
- path: path.resolve(__dirname, 'dist'),
- },
- node: {
- __dirname: true,
- },
- };
- TypeError: Cannot read property 'query' of undefined
- at Object.getItem (C:UsersfreekDropboxCodeAppsGEPTGEPTv2_APIdistgept_api.js:1:154359)
- at t.db_pool.getConnection (C:UsersfreekDropboxCodeAppsGEPTGEPTv2_APIdistgept_api.js:1:154841)
- at c._callback (C:UsersfreekDropboxCodeAppsGEPTGEPTv2_APIdistgept_api.js:1:68269)
- at c.end (C:UsersfreekDropboxCodeAppsGEPTGEPTv2_APIdistgept_api.js:1:8397)
- at C:UsersfreekDropboxCodeAppsGEPTGEPTv2_APIdistgept_api.js:1:322509
- at Array.forEach (<anonymous>)
- at C:UsersfreekDropboxCodeAppsGEPTGEPTv2_APIdistgept_api.js:1:322487
- at process._tickCallback (internal/process/next_tick.js:112:11)
- 'use strict';
- var mysql = require('mysql');
- var secret = require('./db-secret');
- module.exports = {
- name: 'gept_api',
- hostname: 'https://api.toxsickproductions.com/gept',
- version: '1.3.0',
- port: process.env.PORT || 1910,
- db_pool: mysql.createPool({
- host: secret.host,
- port: secret.port,
- user: secret.user,
- password: secret.password,
- database: secret.database,
- ca: secret.ca,
- }),
- };
- pool.getConnection((err, connection) => {
- PlayerRepository.getPlayer(req.params.username, connection, (statusCode, player) => {
- connection.release();
- res.status(statusCode);
- res.send(player);
- return next();
- });
- });
- /** Get the player, and logs to HiscoreSearch if exists.
- *
- * Has callback with statusCode and player. Status code can be 200, 404 or 500.
- * @param {string} username The player's username.
- * @param {connection} connection The mysql connection object.
- * @param {(statusCode: number, player: { username: string, playerType: string }) => void} callback Callback with statusCode and the player if found.
- */
- function getPlayer(username, connection, callback) {
- const query = 'SELECT p.*, pt.type FROM Player p JOIN PlayerType pt ON p.playerType = pt.id WHERE username = ?';
- connection.query(query, [username.toLowerCase()], (outerError, results, fields) => {
- if (outerError) callback(500);
- else if (results && results.length > 0) {
- logHiscoreSearch(results[0].id, connection, innerError => {
- if (innerError) callback(500);
- else callback(200, {
- username: results[0].username,
- playerType: results[0].type,
- deIroned: results[0].deIroned,
- dead: results[0].dead,
- lastChecked: results[0].lastChecked,
- });
- });
- } else callback(404);
- });
- }
Add Comment
Please, Sign In to add comment