<?php
require_once './app-config.php';
include_once ABSPATH . "/php/CDBConn.php";
include_once ABSPATH . "/php/hostconfig.php";
$conn = new CDBConn($jet_ip, $db_name, $db_user, $db_pass);
echo "CDBConn::connect_no_locathost();<br>";
$conn->connect_no_localhost();
$conn->printinfo();
$sql = "SELECT * FROM hostels";
echo "<div style=\"background-color:#00FF00\">" . $conn->run_select($sql) . "</div>";
$conn->close();
$conn2 = new CDBConn("127.0.0.1", $db_name, $db_user, $db_pass);
echo "<br>--------------<br>";
echo "CDBConn::connect()<br>";
$conn2->connect_no_localhost();
$conn2->printinfo();
$sql = "SELECT * FROM rooms";
echo "<div style=\"background-color:#00FF00\">" . $conn2->run_select($sql) . "</div>";
$conn2->close();
echo "Session is on<br>";
http_response_code(302);
exit;
}
require_once "../app-config.php";
include_once ABSPATH . "/php/CDBConn.php";
include_once ABSPATH . "/php/hostconfig.php";
$login = json_decode($_POST['login']);
$password = json_decode($_POST['password']);
$conn = new CDBConn($jet_ip, $db_name, $db_user, "qwerty123");
if (!$conn->connect()) {
http_response_code(503);
exit;
}
$check_user_sql = "SELECT * FROM users WHERE login='******' AND password='******'";
echo $conn->run_select($check_user_sql);
if ($conn->affected_rows() != 1) {
echo "user with login:'******'; and password:'******' doesnot exists" . "<br>";
http_response_code(401);
exit;
} else {
$_SESSION['g_username'] = $login;
$get_hostel_id_sql = "SELECT hostel_id FROM users WHERE login='******'";
$conn->run_query($get_hostel_id_sql);
$row = $conn->fetch_array();
$hostel_id = $row['hostel_id'];
// Even in case if hostel_id is null,
// doConfigure.php script will create it
$_SESSION['g_hostel_id'] = $hostel_id;
http_response_code(200);
exit;
<?php
require_once "../app-config.php";
include_once ABSPATH . "/php/CDBConn.php";
include_once ABSPATH . "/php/hostconfig.php";
$send_to = $_GET["email"];
if ($send_to == "") {
echo "Email is empty. nothing to do<br>";
http_response_code(422);
exit(1);
}
$conn = new CDBConn($jet_ip, $db_name, $db_user, "qwerty123", FALSE);
$conn->connect();
$conn->run_select("SELECT * FROM users WHERE login='******'");
if ($conn->affected_rows() > 0) {
echo "Following email '{$send_to}' is already used or activation requested. Please, select another email, if appropriate.<br>";
http_response_code(422);
exit(1);
} else {
$subject = "JetPMS.com Registration Request";
$message = "Dear customer, <br><br><br>We are glad to inform that you have almost done with the registration at JetPMS.<br/> Please, follow further simple instruction and be ready for evaluating our product.<br>";
/*$message .= "So far, you have requested JetPMS for:<br>";
$message .= "Beds <b>".$_POST["bedscount"] . "</b><br/>";
$message .= "Country <b>".$_POST["country"]."</b><br/>";
$message .= "Total price: <b>".$_POST["b_price"]."$/month</b><br>";
*/
$message .= "Please, click to this activation link: ";
$reg_token = bin2hex(openssl_random_pseudo_bytes(16));
$activation_link = "http://" . $_SERVER["HTTP_HOST"] . "/signup/activateAccount.php?email=" . $send_to . "®_token=" . $reg_token;
$href_tag = "<a href=" . $activation_link . ">{$activation_link}</a>";
