jsuryahyd

--connection status 
show status like '%conn%';
--full process list 
SHOW full processlist;
--global variables 
show global variables like '%connect%';
--session variables 
SHOW SESSION VARIABLES LIKE "%connect%";

jsuryahyd

//dont remember, where got this from, but,
function selectText(id) {
  var node = document.getElementById(id);

  if (document.body.createTextRange) {
    const range = document.body.createTextRange();
    range.moveToElementText(node);
    range.select();
  } else if (window.getSelection) {

jsuryahyd

const mysql = require("mysql");
const async = require('async')
const dbConfig = require("./tables.js").tables;
const db = mysql.createPool({
  host: "localhost",
  user: dbConfig.username,
  password: dbConfig.password,
  database: "click2magic",
  multipleStatements:true
});

jsuryahyd

const express = require('express');
const path = require('path');
const util = require('util');
const fs = require('fs');
const morgan = require('morgan')
const https = require('https')
const app = express();

//static
app.use(express.static(path.join(__dirname,'./public')));

jsuryahyd

// Escapes HTML characters in a template literal string, to prevent XSS.
// See https://www.owasp.org/index.php/XSS_%28Cross_Site_Scripting%29_Prevention_Cheat_Sheet#RULE_.231_-_HTML_Escape_Before_Inserting_Untrusted_Data_into_HTML_Element_Content
function sanitizeHTML(strings) {
  const entities = {'&': '&amp;', '<': '&lt;', '>': '&gt;', '"': '&quot;', "'": '&#39;'};
  let result = strings[0];
  for (let i = 1; i < arguments.length; i++) {
    result += String(arguments[i]).replace(/[&<>'"]/g, (char) => {
      return entities[char];
    });
    result += strings[i];

jsuryahyd

const http = require('http');

http.createServer((req,res)=>{
  let route = req.url;
  if(route == '/'){
    res.end('root route.')
  }else if(route == '/hello'){
    res.end('hello')
  }
}).listen(3000,()=>{console.log('listening on a domain')})