$data['updated_date'] = date('Y-m-d h:i:s');
$sendRegisterMail = false;
} else {
$password = $commonController->randomPassword();
$data['password'] = md5($password);
$data['created_date'] = date('Y-m-d h:i:s');
$sendRegisterMail = false;
}
if ($uploadFlag) {
$resultPackage = $commonController->getTableData(array('table' => 'packages', 'where' => array('price=0')));
if (mysql_num_rows($resultPackage) > 0) {
$rowPackages = mysql_fetch_array($resultPackage);
$data['subscription_id'] = $rowPackages['id'];
$data['subscribed_on'] = date('Y-m-d h:i:s');
}
if ($commonController->insertUpdateData($data) > 0) {
if ($sendRegisterMail) {
$registrationMsg = 'Hi ' . $data['username'] . ', <br /><br />';
$registrationMsg .= 'You have been successfully registered with Snoozeover site. <br />';
$registrationMsg .= 'email: ' . $data['email'] . ' <br />';
$registrationMsg .= 'password: '******' <br />';
$registrationMsg .= 'Please <a href="' . SITE_URL . '">click here</a> to have a look to our SnoozeOver <br />';
$registrationMsg .= 'Thank you <br />';
$registrationMsg .= '<br /><br /><small><i>please don\'t replay to this mail</i></small>';
$commonController->sentMail(array('to' => $data['email'], 'subject' => 'Registration Mail', 'message' => $registrationMsg));
}
header("location:listingUser.php?userType=" . $_REQUEST['userType'] . "&save=success");
} else {
$msg = 'Something went wrong. We are looking into it';
$class = 'danger';
}
$data['payer_email'] = $_POST['payer_email'];
$data['verify_sign'] = $_POST['verify_sign'];
$data['payment_type'] = $_POST['payment_type'];
$data['receiver_email'] = $_POST['receiver_email'];
$data['txn_type'] = $_POST['txn_type'];
$data['item_name'] = $_POST['item_name'];
$data['ipn_track_id'] = $_POST['ipn_track_id'];
$data['payment_for'] = 0;
// 0-upgradation, 1-booking
$data['paypal_log'] = print_r($_POST, true);
$data['table'] = 'paypal_transaction';
$data['where'] = array('txn_id=' . $_POST["txn_id"]);
$resultPaypalTransaction = $commonController->getTableData($data);
if (mysql_num_rows($resultPaypalTransaction) == 0) {
$data['created_date'] = date('Y-m-d h:i:s');
$id = $commonController->insertUpdateData($data);
$data['id'] = $id;
} else {
$row = mysql_fetch_array($resultPaypalTransaction);
$data['updated_date'] = date('Y-m-d h:i:s');
$data['id'] = $row['id'];
$commonController->insertUpdateData($data);
}
// Save and update the logs array
$paypal_log_fetch = mysql_fetch_array(mysql_query($log_query));
$paypal_log_id = $paypal_log_fetch["id"];
if ($p->validate_ipn()) {
// validate the IPN, do the others stuffs here as per your app logic
$commonController->insertUpdateData(array('table' => 'users', 'subscription_id' => $subscription_id, 'id' => $user_id, 'subscribed_on' => date('Y-m-d h:i:s')));
$subject = 'Instant Payment Notification - Recieved Payment';
//$p->send_report($subject); // Send the notification about the transaction
$flag = 0;
//$msg = 'Username and Email must be unique.';
$msg = 'Mobile number must be unique.';
$class = 'danger';
} else {
$flag = 1;
}
}
if ($uploadFlag && $flag) {
$resultPackage = $commonController->getTableData(array('table' => 'packages', 'where' => array('price=0')));
if (mysql_num_rows($resultPackage) > 0) {
$rowPackages = mysql_fetch_array($resultPackage);
$data['subscription_id'] = $rowPackages['id'];
$data['subscribed_on'] = date('Y-m-d h:i:s');
}
$insertedId = $commonController->insertUpdateData($data);
if ($insertedId > 0) {
if ($sendRegisterMail) {
$registrationMsg = 'Hi ' . $data['firstname'] . ', <br /><br />';
$registrationMsg .= 'You have been successfully registered with Snoozeover site. <br />';
$registrationMsg .= 'email: ' . $data['email'] . ' <br />';
$registrationMsg .= 'password: '******'txtPassword'] . ' <br />';
$registrationMsg .= 'Please <a href="' . SITE_URL . '">click here</a> to have a look to our SnoozeOver <br />';
$registrationMsg .= 'Thank you <br />';
$registrationMsg .= '<br /><br /><small><i>please don\'t reply to this mail</i></small>';
$commonController->sentMail(array('to' => $data['email'], 'subject' => 'Registration Mail', 'message' => $registrationMsg));
}
$_SESSION['id'] = $insertedId;
$_SESSION['username'] = $data['firstname'];
$_SESSION['type'] = $data['type'];
header('location:account.php');
$data['description'] = $_POST['txtDescription'];
$data['email'] = $_POST['txtEmail'];
$data['country_id'] = $_POST['ddlCountry'];
$data['state_id'] = $_POST['ddlState'];
$data['city_id'] = $_POST['ddlCity'];
$data['district_id'] = $_POST['ddlDistrict'];
$data['telephone'] = $_POST['hdnTelephone'];
$data['mobile'] = $_POST['txtMobile'];
$data['fax'] = $_POST['txtFax'];
$data['address'] = $_POST['txtAddress'];
$data['postal_code'] = $_POST['txtPostalCode'];
$data['facebook_url'] = !empty($_POST['txtFacebookUrl']) ? FACEBOOK_URL . $_POST['txtFacebookUrl'] : '';
$data['twitter_url'] = !empty($_POST['txtTwitterUrl']) ? TWITTER_URL . $_POST['txtTwitterUrl'] : '';
$data['status'] = 2;
$data['is_delete'] = 0;
$id = $commonController->insertUpdateData($data);
if ($id > 0) {
for ($i = 0; $i < count($_POST['txtStartWorkingTime']); $i++) {
foreach ($_POST['days' . $i] as $value) {
$dataWorkingDays['table'] = 'establishments_working_days';
$dataWorkingDays['day'] = $value;
$dataWorkingDays['establishment_id'] = $id;
$dataWorkingDays['in_time'] = $_POST['txtStartWorkingTime'][$i];
$dataWorkingDays['out_time'] = $_POST['txtEndWorkingTime'][$i];
$retValWOrkingDays = $commonController->insertUpdateData($dataWorkingDays);
}
}
//
foreach ($_POST['language_type'] as $langvalue) {
$dataLang['table'] = 'establishments_languages';
$dataLang['establishment_id'] = $id;
<?php
/*
* Title : Booking Calendar PRO (jQuery Plugin)
* Version : 2.0
* File : save.php
* File Version : 2.0
* Created / Last Modified : 29 September 2014
* Author : Dot on Paper
* Copyright : © 2011 Dot on Paper
* Website : http://www.dotonpaper.net
* Description : Save booking data in database.
*/
include '../../assets/config.php';
if (!empty($_POST['dopbcp_calendar_id']) && !empty($_GET['r']) && $_GET['r'] != "0") {
// If calendar ID is received.
$commonController = new CommonController();
$data['table'] = 'schedule';
$data['where'] = array('establishment_id=' . $_POST['dopbcp_calendar_id'], 'room_id=' . $_GET['r']);
$resultSchedule = $commonController->getTableData($data);
if (mysql_num_rows($resultSchedule)) {
$row = mysql_fetch_array($resultSchedule);
$dataSave['id'] = $row['id'];
}
$dataSave['establishment_id'] = $_POST['dopbcp_calendar_id'];
$dataSave['data'] = $_POST['dopbcp_schedule'];
$dataSave['table'] = 'schedule';
$dataSave['room_id'] = $_GET['r'];
$commonController->insertUpdateData($dataSave);
}
<?php
include 'assets/config.php';
if (!empty($_SESSION['id']) && !empty($_POST['id'])) {
$commonController = new CommonController();
$dataReview['table'] = 'establishments_reviews';
$dataReview['establishment_id'] = $_POST['id'];
$dataReview['review'] = mysql_escape_string($_POST['msg']);
$dataReview['reviewed_by'] = $_SESSION['id'];
$dataReview['created_date'] = date('Y-m-d h:i:s');
echo $commonController->insertUpdateData($dataReview);
} else {
echo '0';
}
<?php
include 'assets/config.php';
if (!empty($_SESSION['id']) && !empty($_POST['id'])) {
$status = array('0' => 'Awaiting Approval', '1' => 'Approved', '2' => 'Declined');
$commonController = new CommonController();
$resultReviews = $commonController->getTableData(array('table' => 'booking_requests br LEFT JOIN establishments e ON e.id = br.establishment_id', 'select' => 'br.*, e.name as establishment_name', 'where' => array('br.id=' . $_POST['id'])));
if (mysql_num_rows($resultReviews)) {
$row = mysql_fetch_array($resultReviews);
$rowBookingStatusMail = 'Hi ' . $row['from_name'] . ',<br />';
$rowBookingStatusMail .= 'Thank you for your booking request for <strong>
<a href="' . SITE_URL . 'detail.php?q=' . base64_encode($row['listing_id']) . '">' . $row['establishment_name'] . '</a></strong> on ' . date('m-d-Y', strtotime($row['sent_date'])) . '<br />';
$rowBookingStatusMail .= 'Your requirement meesage was as below, <br />';
$rowBookingStatusMail .= $row['message'] . '<br /><br /><br />';
$rowBookingStatusMail .= 'Your current request status is : ' . $status[$_POST['status']];
$updateData['table'] = 'booking_requests';
$updateData['id'] = $_POST['id'];
$updateData['status'] = $_POST['status'];
$updateData['status_changed_date'] = date('Y-m-d h:i:s');
$commonController->insertUpdateData($updateData);
$commonController->sentMail(array('to' => $row['from_email'], 'subject' => $row['establishment_name'] . ' Booking Request', 'message' => $rowBookingStatusMail));
echo '1';
} else {
echo '0';
}
} else {
echo '0';
}
include 'assets/config.php';
if (!empty($_SESSION['id']) && !empty($_POST['eid'])) {
$commonController = new CommonController();
$resultRate = $commonController->getTableData(array('table' => 'establishment_ratings', 'where' => array('user_id=' . $_SESSION['id'], 'establishment_id=' . $_POST['eid'])));
$existsId = 0;
if (mysql_num_rows($resultRate) > 0) {
$rowRate = mysql_fetch_array($resultRate);
$existsId = $rowRate['id'];
}
$dataRating['table'] = 'establishment_ratings';
$dataRating['establishment_id'] = $_POST['eid'];
$dataRating['user_id'] = $_SESSION['id'];
$dataRating['ratings'] = $_POST['score'];
if (!empty($_POST['id']) && $_POST['id'] > 0) {
$dataRating['id'] = $_POST['id'];
}
if ($existsId > 0 && !empty($_POST['id'])) {
echo $commonController->insertUpdateData($dataRating);
} else {
if ($existsId > 0 && empty($_POST['id'])) {
echo '0';
} else {
if ($existsId == 0) {
echo $commonController->insertUpdateData($dataRating);
}
}
}
} else {
echo '0';
}
$resultFacilitiesData = $commonController->getTableData($dataFacilities);
$dataLanguages['table'] = 'establishments_languages el';
$dataLanguages['where'] = array('el.establishment_id=' . $id);
$resultLanguageData = $commonController->getTableData($dataLanguages);
$roomsResult = $commonController->getTableData(array('table' => 'establishment_rooms', 'where' => array('establishment_id=' . $id)));
// if user is logged in, add the establishment into user viewed table
if (!empty($_SESSION['id'])) {
$dataViewed['table'] = 'users_viewed';
$dataViewed['where'] = array('user_id=' . $_SESSION['id'], 'establishment_id=' . $id);
$resultViewed = $commonController->getTableData($dataViewed);
if (mysql_num_rows($resultViewed) == 0) {
$dataInsertView['table'] = 'users_viewed';
$dataInsertView['user_id'] = $_SESSION['id'];
$dataInsertView['establishment_id'] = $id;
$dataInsertView['viewed_on'] = date('Y-m-d h:i:s');
$commonController->insertUpdateData($dataInsertView);
}
}
?>
<div class="inner-page">
<?php
if (mysql_num_rows($resultData)) {
$row = mysql_fetch_array($resultData);
?>
<div class="product-detail-wrap">
<div class="detail-blank">
<!-- <div class="beadcrum">
<a href="#">Home </a>
<a href="#">Listing Page</a>
<a href="#">Listing Detail</a>
$data['payer_email'] = $_POST['payer_email'];
$data['verify_sign'] = $_POST['verify_sign'];
$data['payment_type'] = $_POST['payment_type'];
$data['receiver_email'] = $_POST['receiver_email'];
$data['txn_type'] = $_POST['txn_type'];
$data['item_name'] = $_POST['item_name'];
$data['ipn_track_id'] = $_POST['ipn_track_id'];
$data['payment_for'] = 1;
// 0-upgradation, 1-booking
$data['paypal_log'] = print_r($_POST, true);
$data['table'] = 'paypal_transaction';
$data['where'] = array('txn_id=' . $_POST["txn_id"]);
$resultPaypalTransaction = $commonController->getTableData($data);
if (mysql_num_rows($resultPaypalTransaction) == 0) {
$data['created_date'] = date('Y-m-d h:i:s');
$id = $commonController->insertUpdateData($data);
$data['id'] = $id;
} else {
$row = mysql_fetch_array($resultPaypalTransaction);
$data['updated_date'] = date('Y-m-d h:i:s');
$data['id'] = $row['id'];
$commonController->insertUpdateData($data);
}
// Save and update the logs array
if ($p->validate_ipn()) {
// validate the IPN, do the others stuffs here as per your app logic
$dataOrder = array('table' => 'orders', 'establishment_id' => $establishment_id, 'user_id' => $user_id, 'status' => 1);
$roomsResult = $commonController->getTableData(array('table' => 'establishment_rooms', 'where' => array('id=' . $room_id)));
if (mysql_num_rows($roomsResult) > 0) {
$rowRooms = mysql_fetch_assoc($roomsResult);
$dataOrder['room_name'] = $rowRooms['name'];
