<?php

error_reporting(E_ALL);

ini_set('display_errors',1);

date_default_timezone_set('Asia/Singapore');

define( 'WP_USE_THEMES', FALSE );

require( './wp-load.php' );

date_default_timezone_set('Asia/Singapore');

session_start();

$review = $_REQUEST['review'];

$id = $_REQUEST['id'];

$name = $_REQUEST['review_name'];

$designation = $_REQUEST['designation'];

$email = $_REQUEST['email'];

$display_name = $_REQUEST['display_name'];

$hide_name = $_REQUEST['hide_name'];

$datetime_added = date('Y-m-d');





function detectWords($string, $words) {
    // Escape special characters in the words array
    $escapedWords = array_map('preg_quote', $words);
    
    // Create a regular expression pattern to match any of the words
    $pattern = '/\b(' . implode('|', $escapedWords) . ')\b/i';

    // Perform the regular expression match
    if (preg_match($pattern, $string)) {
        return true; // Word(s) found in the string
    } else {
        return false; // Word(s) not found in the string
    }
}

$review = strip_tags($review);

$abusive_words_info = $wpdb->get_row( "SELECT * FROM badwords WHERE id = 1" );

$abusive_words = $abusive_words_info->badwords;
$words_to_detect = explode("\n", $abusive_words); // here you got an array of strings


if (detectWords($review, $words_to_detect)) {
    print '99';
	exit;
}

if($display_name != '')
{
	$masking = 1;
	
}

$data=array(
	'company_id' => $id, 
	'status' => 0, 
	'name' => $name,
	'designation' => $designation,	
	'email' => $email,
	'display_name' => $display_name,
	'masking' => $masking,
	'overwrite_name' => $display_name,
	'review' => $review,
	'datetime_sent' => date('Y-m-d H:i:s')

);


$a = $wpdb->insert( 'rating', $data);



// Attempt to add post

if($a)
{

	$to = 'digital@imas.org.sg';
	$subject = 'New Review Requires Approval';
	$body = '
	
	<p>Dear Admin,</p>

<p>A new review has been posted and is currently pending approval.</p>

<p>Kindly log in to the admin backend to approve or reject this review.</p>
	';
	$headers = array('Content-Type: text/html; charset=UTF-8');
	
	$headers[] = 'Bcc: tech@arkstudio.sg';
	$headers[] = 'Cc: chowching_teng@imas.org.sg';

	//wp_mail( $to, $subject, $body, $headers );
	

	print '1';

}