s3yZY7rF

1//Lets require/import the HTTP module
2var http = require('http');
3var port = process.env.PORT || 8080;
4var fs = require('fs');
5var express = require('express');
6var app = express();
7var path = require('path');
8var passport = require('passport');
9var bodyParser = require('body-parser');
10var crypto = require('crypto');
11var sqlite3 = require('sqlite3').verbose();
12var db = new sqlite3.Database('./database.db');
13var formidable = require('formidable');
14
15/*db.serialize(function() {
16    db.run(" \ CREATE TABLE IF NOT EXISTS Users \
17    (username TEXT, \
18    email TEXT, \
19    password TEXT)");
20});*/
21
22app.use(express.static(path.join(__dirname, '/public')));
23
24app.post("/reg", function(req, res) {
25    var form = new formidable.IncomingForm();
26    
27    form.parse(req, function(err, field, file) {
28        if (err) {
29            res.sendStatus(500);
30        }
31            var stmt = db.prepare(" \ INSERT INTO Users \
32            (username, \
33            email, \
34            password) \
35            VALUES (?, ?, ?)");
36            stmt.run(field.username, field.email, field.password);
37            stmt.finalize();
38            res.sendFile(__dirname + "/public/index.html");
39    });
40});
41app.get("/signup", function(req, res) {
42    res.sendFile(__dirname + "/public/register.html");
43});
44app.post("/login", function(req, res) {
45    var form = new formidable.IncomingForm();
46    form.parse(req, function(err, field, file) {
47        if (err) {
48            res.sendStatus(500);
49        }
50        db.all("SELECT rowid AS id, username FROM Users", function(err, row) {
51            if (err) {
52                throw err;
53            }
54            console.log(row.id + ": " + row.username);
55        });
56    });
57    res.redirect('back');
58});
59
60app.get('*', function(req, res) {
61    res.send('Not yet available.');
62});
63
64app.listen(port);
65
66// Console will print the message
67console.log('Server running on port ' + port + "!");