node/index.js at master · SaltyCam/node · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
let express = require('express');
let app = express();
//let mysql = require('mysql')
let mysql = require('mysql2');
let cors = require('cors');

app.use(cors());
app.use(express.json());

let ask4 = 'select c.id, c.level, c.class, c.level, c.circlet, c.belt, c.pendant, c.cloak, cb.onyx, cb.zircon, cb.spinel, cb.coral, cb.amber, cb.moonstone, cb.opal, cb.beryl, ca.ignis, ca.petram, ca.nebula, ca.joy, ca.procella, ct.aden, ct.eva, ct.speed, ct.authority, ct.venir from characters.character_details c join characters.character_brooches cb on c.id = cb.id join characters.character_talismans ct on c.id = ct.id join characters.character_agathions ca on c.id = ca.id';

const pool = mysql.createPool({
    connectionLimit: 10,
    host: 'notsalty.eu',
    user: 'saltycam',
    password: 'password',
    database: 'characters'
});


app.get('/get', (req, res)=> {
    pool.query(ask4, (err, results)=> {
        if(err) alert('bug')
        res.send(results);
    })

})

app.post('/post', (req, res)=> {
    let clas = req.body.clas;
    let level = req.body.level;
    let circlet = req.body.circlet;
    let pendant = req.body.pendant;
    let cloak = req.body.cloak;
    let belt = req.body.belt;

    let onyx = req.body.onyx;
    let coral = req.body.coral;
    let zircon = req.body.zircon;
    let amber = req.body.amber;
    let opal = req.body.opal;
    let moonstone = req.body.moonstone;
    let beryl =req.body.beryl;
    let spinel = req.body.spinel;

    let aden = req.body.aden;
    let speed = req.body.speed;
    let eva = req.body.eva;
    let authority = req.body.authority;
    let venir = req.body.venir;

    let ignis = req.body.ignis;
    let petram = req.body.petram;
    let nebula = req.body.nebula;
    let procella = req.body.procella;
    let joy = req.body.joy;


    pool.query("INSERT INTO characters.character_talismans (aden, eva, speed, authority, venir) VALUES (?, ?, ?, ?,?)", [aden, eva, speed, authority, venir],
    (err, result)=> {
        if(err){
            console.log(err);
        } else {
            return res
        }
    })

    pool.query("INSERT INTO characters.character_details (class, level, circlet, belt, pendant,cloak) VALUES (?, ?, ?, ?,?,?)", [clas, level, circlet, belt, pendant, cloak],
    (err, result)=> {
        if(err){
            console.log(err);
        } else {
            console.log(ignis, procella, joy, nebula, petram);
            console.log(clas, level, circlet, belt);
            return res
        }
    })


    pool.query("INSERT INTO characters.character_agathions (ignis, petram, nebula, joy, procella) VALUES (?, ?, ?, ?,?)", [ignis, petram, nebula, joy, procella],
    (err, result)=> {
        if(err){
            console.log(err);
        } else {
            return res
        }
    })

    pool.query("INSERT INTO characters.character_brooches (onyx, zircon, spinel, coral, amber, moonstone, opal, beryl) VALUES (?, ?, ?, ?, ?, ?, ?, ?)", [onyx, zircon, spinel, coral, amber, moonstone, opal, beryl],
    (err, result)=> {
        if(err){
            console.log(err);
        } else {
            return res
        }
    })
})

app.listen(3001, ()=> {
    console.log("Working");
})