Registration_module/index.js at main · Smith-Coder/Registration_module · 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
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
const express = require('express');
var nodemailer = require('nodemailer');
const bodyParser = require('body-parser');
var ejs = require("ejs");
const app = express();
const path=require('path');
const port = 3000;

app.use(express.static(path.join(__dirname,'static')));
app.use(bodyParser.urlencoded({extended: false}))
app.set('view engine', 'ejs');
app.set('views', __dirname + '/views');


var mysql = require('mysql');
var connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: '',
  database: 'registration'
})

connection.connect(function(err){
  if(err) throw err;
  console.log("connected");
})

app.get('/', (req, res) => {
  res.render('registration');
})

app.post('/submit',function(req,res,next){
  var mail1=req.body.email1;
  var mail2=req.body.email2;
  var discordName1=req.body.discord1;
  var discordName2=req.body.discord2;
  var teamnam= req.body.team;
  var mailck1=mail1.slice(-10,)
  var mailck2=mail2.slice(-10,)

  connection.query('SELECT teamname FROM teams', function (err,teamnames) {
    if (err) throw err
    for(var i=0;i<teamnames.length;i++)
    {
      var count=0;
      if(teamnames[i].teamname==teamnam){
        count=count+1;

      }
    }
    connection.query('SELECT email_1,email_2 FROM teams', function (err,emails1) {
      if (err) throw err
    for(var i=0;i<emails1.length;i++)
    {
      var count1=0;
      if(emails1[i].email_1==mail1 || emails1[i].email_2==mail1){
        count1++;
      }
    }
    connection.query('SELECT email_1,email_2 FROM teams', function (err,emails2) {
      if (err) throw err
    for(var i=0;i<emails2.length;i++)
    {
      var count2=0;
      if(emails2[i].email_2==mail2 || emails2[i].email_1==mail2){
        count2++;
      }
    }
    connection.query('SELECT member_1_discord_name,member_2_discord_name FROM teams', function (err,discordname1) {
      if (err) throw err
    for(var i=0;i<discordname1.length;i++)
    {
      var count3=0;
      if(discordname1[i].member_1_discord_name==discordName1 || discordname1[i].member_2_discord_name==discordName1){
        count3++;
      }
    }
    connection.query('SELECT member_1_discord_name,member_2_discord_name FROM teams', function (err,discordname2) {
      if (err) throw err
    for(var i=0;i<discordname2.length;i++)
    {
      var count4=0;
      if(discordname2[i].member_2_discord_name==discordName2 || discordname2[i].member_1_discord_name==discordName2){
        count4++;
      }
    }

  if(req.body.team=="" || req.body.name1=="" || req.body.name2=="" || req.body.email1=="" || req.body.email2=="" || req.body.discord1=="" || req.body.discord2=="" ){
    const respond="Please don't submit blank fields";
    res.render('registration',{respond})
  }
  else if(mailck1!="@gmail.com" && mailck2!="@gmail.com"){
    const respond="Enter email address of the format example@gmail.com";
    res.render('registration',{respond})
  }
  else if(mail1==mail2){
    const respond="both members email id cannot be same";
    res.render('registration',{respond})
  }
  else if(discordName1==discordName2){
    const respond="both members discord name cannot be same";
    res.render('registration',{respond})
  }
  else if(count>0)
  {
    const respond="This teamname already exists";
    res.render('registration',{respond})
  }
  else if(count1>0)
  {
    const respond="member 1 email is already registered to another team";
    res.render('registration',{respond})
  }
  else if(count2>0)
  {
    const respond="member 2 email is already registered to another team";
    res.render('registration',{respond})
  }
  else if(count3>0)
  {
    const respond="member 1 discord name is already registered to another team";
    res.render('registration',{respond})
  }
  else if(count4>0)
  {
    const respond="member 2 discord name is already registered to another team";
    res.render('registration',{respond})
  }
  else{
    var sql = "insert into teams values('"+ req.body.team+"','"+ req.body.name1+"','"+ req.body.name2+"','"+ req.body.email1+"','"+ req.body.email2+"','"+ req.body.discord1+"','"+ req.body.discord2+"')";
      connection.query(sql, function (err) {
      if (err) throw err
      res.send('registered')
    })
  }
})
})
    })
  })
})
})

app.listen(port, () => {
  console.log(`Example app listening at http://localhost:${port}`)
})