$conn->connect();
// Finding whether it overlaps with some of existing orders
$check_availability = "SELECT guest_id, date_in, date_out, date_overlap(date_in, date_out, '{$date_in}', '{$date_out}') FROM orders WHERE bed_index={$bed_index} AND room_id={$room_id}";
$conn->run_query($check_availability);
$order_info = new stdClass();
while ($line = $conn->fetch_array()) {
if ($line['date_overlap'] == 1) {
// avail = 0; does mean there exists at least on order
// which conflicts with the current order.
$order_info->avail = 0;
$order_info->date_in = $line['date_in'];
$order_info->date_out = $line['date_out'];
$guest_id = $line['guest_id'];
$guest_query = "SELECT * FROM guests WHERE id = '{$guest_id}'";
$conn->run_query($guest_query);
if ($conn->affected_rows() == 1) {
$guest_row = $conn->fetch_array();
$order_info->first_name = $guest_row['first_name'];
$order_info->last_name = $guest_row['last_name'];
$order_info->telephone = $guest_row['telephone'];
} else {
$order_info->first_name = 'Name';
$order_info->last_name = 'Surname';
$order_info->telephone = '';
}
echo json_encode($order_info);
// Not available
http_response_code(200);
exit;
}
}
<?php
session_start();
require_once "../app-config.php";
include_once ABSPATH . "/php/hostconfig.php";
include_once ABSPATH . "/php/CDBConn.php";
$input_email = $_POST['email'];
$input_reg_token = $_POST['reg_token'];
$input_password1 = $_POST['password1'];
$input_password2 = $_POST['password2'];
//printf("input_email=%s<br>input_reg_token=%s<br>input_password1=%s<br>input_password2=%s<br>", $input_email, $input_reg_token, $input_password1, $input_password2);
$conn = new CDBConn($jet_ip, $db_name, $db_user, "qwerty123", FALSE);
$conn->connect();
$query = "SELECT reg_token, is_activated FROM users WHERE login='******'";
if ($conn->run_query($query)) {
switch ($conn->affected_rows()) {
case 0:
echo "This email has no associated registration inquiry. Link is invalid. Please, review whether you fully copied the activation link. If you don't know what's happened, just try signup again.<br>";
http_response_code(422);
break;
case 1:
$arr = $conn->fetch_array();
//var_dump($arr['reg_token']);
//var_dump($_POST['reg_token']);
if ($arr["reg_token"] == $input_reg_token) {
$adduser_query = "UPDATE users SET is_activated = TRUE, password='******' WHERE login='******'";
if ($arr["is_activated"] === 't') {
echo "Your email has been activated. You may log in to your account";
http_response_code(422);
exit;
}
session_start();
if (!isset($_SESSION['g_username'])) {
header("Location: /login/index.php");
exit;
}
$path_to_cdbconn = $_SERVER["DOCUMENT_ROOT"] . "/php/CDBConn.php";
include_once $path_to_cdbconn;
$hostel_info = json_decode($_POST["hostel_info"]);
$rooms = json_decode($_POST["rooms"]);
$conn = new CDBConn($jet_ip, $db_name, $db_user, "qwerty123", TRUE);
$conn->connect();
// Creating new hostel
$insert_query = "INSERT INTO hostels (name, room_count, is_configured) VALUES('{$hostel_info->hostel_name}', {$hostel_info->room_count}, TRUE) RETURNING id";
$conn->run_query($insert_query);
echo $conn->affected_rows() . " rows inserted.";
$new_hostel_id = 0;
while ($line = $conn->fetch_array()) {
echo "id = " . $line[0];
$new_hostel_id = $line[0];
}
// Associating email with hostel
$login_from_session = $_SESSION['g_username'];
$update_query = "UPDATE users SET hostel_id = {$new_hostel_id} WHERE login = '******'";
$conn->run_query($update_query);
$_SESSION['g_hostel_id'] = $new_hostel_id;
// Associating rooms with hostel
for ($i = 0; $i < count($rooms); $i++) {
$cur_room_name = $rooms[$i]->name;
$cur_room_capacity = $rooms[$i]->capacity;
$cur_room_type = $rooms[$i]->type;
/*
SELECT date_overlap(date_in, date_out, '2016-01-12', '2016-01-13') FROM orders WHERE bed_index=1 AND room_id=328
*/
// check avalability
$check_availability = "SELECT date_overlap(date_in, date_out, '{$date_in}', '{$date_out}') FROM orders WHERE bed_index={$bed_index} AND room_id={$room_id}";
$conn->run_query($check_availability);
$line = $conn->fetch_array();
if ($line['date_overlap'] == 1) {
echo 'dates are not available';
http_response_code(409);
exit;
}
$get_guest = "SELECT id FROM guests WHERE first_name='{$first_name}' AND last_name='{$last_name}' AND telephone = '{$telephone}'";
$conn->run_query($get_guest);
$guest_id = 0;
if ($conn->affected_rows() == 0) {
$insert_guest = "INSERT INTO guests(first_name, last_name, telephone) VALUES('{$first_name}','{$last_name}','{$telephone}') RETURNING id";
$conn->run_query($insert_guest);
$arr = $conn->fetch_array();
$guest_id = $arr['id'];
echo "New guest id = " . $guest_id . "<br>";
} else {
if ($conn->affected_rows() == 1) {
$arr = $conn->fetch_array();
$guest_id = $arr['id'];
echo 'Old guest id = ' . $guest_id . "<br>";
} else {
echo "Please, contact support";
http_response_code(409);
exit;
}
<?php
$confirm = $_GET['confirm'];
$table = $_GET['table'];
if ($table == "") {
echo "Please, specify table name<br>";
exit(1);
}
if ($confirm == 1) {
$path_to_cdbconn = $_SERVER["DOCUMENT_ROOT"] . "/php/CDBConn.php";
$path_to_hostconfig = $_SERVER["DOCUMENT_ROOT"] . "/php/hostconfig.php";
include_once $path_to_cdbconn;
include_once $path_to_hostconfig;
$conn = new CDBConn($jet_ip, $db_name, $db_user, "qwerty123", TRUE);
$conn->connect();
$sql = 'DELETE FROM "public".' . $table . ' WHERE true';
$conn->run_query($sql);
echo $conn->affected_rows() . " rows deleted.<br>";
$conn->close();
} else {
echo "you must add confirm=1 param to delete";
}
<?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>";
