File Manager

X7ROOT File Manager

Current Path: /home/katmhsmi/public_html/wp-content/plugins/xagio/models

home / katmhsmi / public_html / wp-content / plugins / xagio / models /

📁 ..
📄 .htaccess(420 B)
📄 wp_affiliate.php(14.41 KB)
📄 wp_api.php(131.08 KB)
📄 wp_batches.php(3.67 KB)
📄 wp_bulk_image_converter.php(2.25 KB)
📄 wp_captcha.php(2.33 KB)
📄 wp_captcha_comment.php(1.8 KB)
📄 wp_captcha_login.php(976 B)
📄 wp_captcha_register.php(819 B)
📄 wp_clone.php(21.76 KB)
📄 wp_comments.php(1.26 KB)
📄 wp_default.php(6.98 KB)
📄 wp_exif.php(11.1 KB)
📄 wp_extend_widgets.php(4.21 KB)
📄 wp_freshstart.php(16.03 KB)
📄 wp_groups.php(30.02 KB)
📄 wp_keywords.php(52.68 KB)
📄 wp_log404.php(19.68 KB)
📄 wp_migration.php(16.26 KB)
📄 wp_redirects.php(5.16 KB)
📄 wp_rescue.php(17.66 KB)
📄 wp_review.php(3.2 KB)
📄 wp_reviewr.php(3.76 KB)
📄 wp_reviews.php(16.82 KB)
📄 wp_schema.php(16.12 KB)
📄 wp_seo.php(79.76 KB)
📄 wp_settings.php(32.76 KB)
📄 wp_sync.php(1.74 KB)
📄 wp_tinymce_buttons.php(6.23 KB)
📄 wp_troubleshooting.php(2.91 KB)
📄 wp_update.php(7.9 KB)

Editing: wp_reviews.php

<?php

if ( ! class_exists( 'MXAG_Reviews' ) ) {

class MXAG_Reviews extends MXAG_Model  {

public static function initialize() {
			// Disable Model if not license is present
			if (!XAG_Licencator::isLicenseSet()) return;

add_action('admin_post_xag_bulkReviews',      array('MXAG_Reviews', 'bulkReview'));
			add_action('admin_post_xag_unapproveReview',  array('MXAG_Reviews', 'unapproveReview'));
			add_action('admin_post_xag_approveReview',    array('MXAG_Reviews', 'approveReview'));
			add_action('admin_post_xag_cloneReview',      array('MXAG_Reviews', 'cloneReview'));
			add_action('admin_post_xag_removeReview',     array('MXAG_Reviews', 'removeReview'));
			add_action('admin_post_xag_getReviews',       array('MXAG_Reviews', 'getReviews_Datatables'));
			add_action('admin_post_xag_getReview',        array('MXAG_Reviews', 'getReview'));
			add_action('admin_post_xag_editReview',       array('MXAG_Reviews', 'editReview'));
			add_action('admin_post_xag_newReview',        array('MXAG_Reviews', 'newReview'));
			add_action('admin_post_nopriv_xag_newReview', array('MXAG_Reviews', 'newReview'));
			add_action('admin_post_xag_saveReviewWidget', array('MXAG_Reviews', 'saveReviewWidget'));
		}

public static function allowedReviewSchemas() {
			return array(
				'Brand',
				'Product',
				'LocalBusiness',
				'Organization',
				'AccountingService',
				'Attorney',
				'AutoBodyShop',
				'AutoDealer',
				'AutoPartsStore',
				'AutoRental',
				'AutoRepair',
				'AutoWash',
				'Article',
				'Bakery',
				'BarOrPub',
				'BeautySalon',
				'BedAndBreakfast',
				'BikeStore',
				'BookStore',
				'CafeOrCoffeeShop',
				'ChildCare',
				'ClothingStore',
				'ComputerStore',
				'DaySpa',
				'Dentist',
				'DryCleaningOrLaundry',
				'Electrician',
				'ElectronicsStore',
				'EmergencyService',
				'EntertainmentBusiness',
				'EventVenue',
				'ExerciseGym',
				'FinancialService',
				'Florist',
				'FoodEstablishment',
				'FurnitureStore',
				'GardenStore',
				'GeneralContractor',
				'GolfCourse',
				'HVACBusiness',
				'HairSalon',
				'HardwareStore',
				'HealthAndBeautyBusiness',
				'HobbyShop',
				'HobbyShop or Store',
				'HomeAndConstructionBusiness',
				'HomeGoodsStore',
				'Hospital',
				'Hotel',
				'HousePainter',
				'InsuranceAgency',
				'JewelryStore',
				'LiquorStore',
				'Locksmith',
				'LodgingBusiness',
				'MedicalClinic',
				'MensClothingStore',
				'MobilePhoneStore',
				'Motel',
				'MotorcycleDealer',
				'MotorcycleRepair',
				'MovingCompany',
				'MusicStore',
				'NailSalon',
				'NightClub',
				'Notary',
				'OfficeEquipmentStore',
				'Optician',
				'PetStore',
				'Physician',
				'Plumber',
				'ProfessionalService',
				'RVPark',
				'RealEstateAgent',
				'Residence',
				'Restaurant',
				'RoofingContractor',
				'School',
				'See alternate instructions',
				'SelfStorage',
				'ShoeStore',
				'SkiResort',
				'SportingGoodsStore',
				'SportsClub',
				'Store',
				'TattooParlor',
				'Taxi',
				'TennisComplex',
				'TireShop',
				'ToyStore',
				'TravelAgency',
				'VeterinaryCare',
				'WholesaleStore',
				'Winery'
			);
		}

public static function reviewsWidgetShortcode($instance) {

$render = function($instance) {
				global $post;
				$isShortcode = true;
				ob_start();
				include(XAG_PATH . '/pages/metabox/xag_review.php');
				return ob_get_clean();
			};

return $render($instance);
		}

public static function reviewsDisplayShortcode($instance) {

$render = function($instance) {
				global $post;
				$isShortcode = true;
				ob_start();
				include(XAG_PATH . '/pages/metabox/xag_display_reviews.php');
				return ob_get_clean();
			};

return $render($instance);

}

public static function saveReviewWidget() {
			wp_cache_delete ( 'alloptions', 'options' );
			if (!empty($_POST)) {
				if(!isset($_POST['ps_review'])) {
					XAG_Init::json( 'error', 'Sorry, something went worng. Please try again!' );
				}

$psReview = array();
				foreach ($_POST['ps_review'] as $key => $value) {
					foreach($value as $k => $v) {
						$value[$k] = xag_stripAllSlashes(htmlspecialchars($v));
					}
					$psReview[$key] = $value;
				}

if (! isset( $_POST['_wpnonce'] ) || ! wp_verify_nonce( $_POST['_wpnonce'], 'xag_saveReviewWidget' ) ) {
					XAG_Init::json( 'error', 'Sorry, you are not auththorized user.' );
				} else {
					if(isset($psReview)) {
						update_option('ps_review', $psReview);
						XAG_Init::json( 'success', 'Your settings have been saved.' );
					}
				}
			}
			XAG_Init::json( 'error', 'Sorry, you are not auththorized user.' );
		}

public static function bulkReview() {

if( isset($_POST['ids']) && isset($_POST['type']) ) {
				$ids  = $_POST['ids'];
				$type = sanitize_text_field($_POST['type']);

if ($type === 'approve') {

self::updateData(array(
						'approved' => 1
					), array(
						'id' => $ids
					));

} else if ($type === 'unapprove') {

self::updateData(array(
						'approved' => 0
					), array(
						'id' => $ids
					));

} else if ($type === 'delete') {

self::removeData(array(
						'id' => $ids
					));

} else if ($type === 'move') {

if(isset($_POST['post_id'])) {

$post_id = $_POST['post_id'];
						$ids = explode(',' , $ids);

self::updateData(array(
							'page_id' => $post_id
						), array(
							'id' => $ids
						));

}

}
			}

}

public static function cloneReview() {

if(isset($_POST['post_ids']) && isset($_POST['review_id'])) {
				$post_ids   = explode(',' , $_POST['post_ids']);
				$review_id  = sanitize_text_field($_POST['review_id']);

$review_data = self::getData('*', array(
					'id' => $review_id
				));

// remove id
				unset($review_data['id']);

foreach ( $post_ids as $post_id ) {
					$review_data['page_id'] = $post_id;

self::insertData($review_data);
				}

wp_send_json(array('status'=>'success', 'message'=>"All data successfully cloned"));
			}

}

public static function approveReview() {
			if(isset($_POST['id'])) {
				$review_id = trim(sanitize_text_field($_POST['id']));

self::updateData(array(
					'approved' => 1
				), array(
					'id' => $review_id
				));
			}
		}

public static function unapproveReview() {
			if(isset($_POST['id'])) {
				$review_id = trim(sanitize_text_field($_POST['id']));

self::updateData(array(
					'approved' => 0
				), array(
					'id' => $review_id
				));
			}
		}

public static function removeReview() {
			if(isset($_POST['id'])) {
				$review_id = trim(sanitize_text_field($_POST['id']));

self::removeData(array(
					'id' => $review_id
				));
			}
		}

public static function countReviews($id = null) {
			if ($id != null) {
				$id = array(
					'page_id' => $id
				);
			}
			return self::getCount($id);
		}

private static function validateVars($vars) {
			$allowed_vars = array(
				"action",
				"name",
				"review",
				"title",
				"rating",
				"email",
				"website",
				"telephone",
				"location",
				"age",
				"page_id",
				"stars_only"
			);
			unset($vars['captcha']);
			foreach($allowed_vars as $var) {
				if (!isset($vars[$var])) {
					return false;
				}
			}
			return $vars;
		}

public static function getReviewsGlobal( $stars_only = false, $random_order = false ) {

$stars = '';
			if ($stars_only === true) {
				$stars = 'AND stars_only = 1';
			}

$order = 'rating DESC';
			if ($random_order === true) {
				$order = 'RAND()';
			}

$query = "SELECT * FROM " . static::TABLE_NAME . " WHERE approved = 1 " . $stars . " ORDER BY " . $order;

return self::query($query);
		}

public static function getReviewsForPage( $page_id = 0, $stars_only = null, $random_order = false ) {

$stars = '';
			if ($stars_only === true) {
				$stars = 'AND stars_only = 1';
			} else if ($stars_only === false) {
				$stars = 'AND stars_only = 0';
			}

$order = 'rating DESC';
			if ($random_order === true) {
				$order = 'RAND()';
			}

if ( MXAG_Seo::is_home_posts_page() || MXAG_Seo::is_posts_page() || MXAG_Seo::is_home_static_page() ) {
				$query = "SELECT * FROM " . static::TABLE_NAME . " WHERE (page_id = 0 OR page_id = '$page_id') AND approved = 1 " . $stars . " ORDER BY " . $order;
			} else {
				$query = "SELECT * FROM " . static::TABLE_NAME . " WHERE page_id = '$page_id' AND approved = 1 " . $stars . " ORDER BY " . $order;
			}

return self::query($query);
		}

public static function getReview() {
			if(isset($_POST['id'])) {
				$data = self::getData('*', array(
					'id' => $_POST['id']
				));
				$data['review'] = stripcslashes( $data['review'] );
				wp_send_json($data);
			}
		}

public static function editReview() {
			$data = $_POST;
			if(isset($data) && !empty($data)) {
				if (! isset( $_POST['_wpnonce'] ) || ! wp_verify_nonce( $_POST['_wpnonce'], 'xag_editReview' ) ) {
					XAG_Init::json( 'error', 'Sorry, you are not auththorized user.' );
				} else {
					$ID = $data['id'];

unset($data['action']);
					unset($data['id']);
					$data['date'] = (isset($data['date']) && !empty($data['date'])) ? $data['date'] : date('Y-m-d H:i:s');

if(isset($data['_wpnonce'])){
						unset($data['_wpnonce']);
						unset($data['_wp_http_referer']);
					}

if ($ID == 0) {
						self::insertData($data);
					} else {
						self::updateData($data, array(
							'id' => $ID
						));
					}
					XAG_Init::json('success', 'Successfully finished operation.');
				}
			}
			XAG_Init::json( 'error', 'Sorry, you are not auththorized user.' );
		}

public static function getReviews_Datatables() {
			global $wpdb;

$aColumns = array(
				'id',
				'name',
				'title',
				'review',
				'rating',
				'email',
				'website',
				'telephone',
				'location',
				'age',
				'date',
				'page_id',
				'approved'
			);

/* Indexed column (used for fast and accurate table cardinality) */
			$sIndexColumn = "id";

/* DB table to use */
			$sTable = self::TABLE_NAME;

/*
			 * Paging
			 */
			$sLimit = '';
			if ( isset( $_POST['iDisplayStart'] ) && $_POST['iDisplayLength'] != '-1' ) {
				$sLimit = "LIMIT " . ( $_POST['iDisplayStart'] ) . ", " .
				          ( $_POST['iDisplayLength'] );
			} else {
				$sLimit = "LIMIT 0,50";
			}

/*
			 * Ordering
			 */
			$sOrder = '';
			if ( isset( $_POST['iSortCol_0'] ) ) {
				$sOrder = "ORDER BY  ";
				for ( $i = 0; $i < intval( $_POST['iSortingCols'] ); $i ++ ) {
					if ( $_POST[ 'bSortable_' . intval( $_POST[ 'iSortCol_' . $i ] ) ] == "true" ) {
						$sOrder .= $_POST[ 'mDataProp_' . intval( $_POST[ 'iSortCol_' . $i ] ) ]  . "
				 	" . ( $_POST[ 'sSortDir_' . $i ] ) . ", ";
					}
				}

$sOrder = substr_replace( $sOrder, "", - 2 );
				if ( $sOrder == "ORDER BY" ) {
					$sOrder = "";
				}
			}

$customFilters = array(
				'approved' => @$_POST['ReviewState'],
				'search'   => @$_POST['sSearch']
			);

$customWhere = "";

foreach($customFilters as $key=>$column){

if($column != ''){
					if($customWhere == ""){
						$customWhere = "WHERE ";
					}else{
						$customWhere .= " AND ";
					}

if($key == 'search'){
						$customWhere .= " (`name` LIKE '%" . ($column) . "%' OR `review` LIKE '%" . ($column) . "%') ";
					}else{
						$customWhere .= $key . " = " . ($column) . " ";
					}
				}
			}

/*
			 * SQL queries
			 * Get data to display
			 */
			$sQuery  = "
				SELECT SQL_CALC_FOUND_ROWS " . str_replace( " , ", " ", implode( ", ", $aColumns ) ) . "
				FROM   $sTable
				$customWhere
				$sOrder
				$sLimit";

$rResult = $wpdb->get_results( $sQuery, ARRAY_A );

$sQuery             = "SELECT FOUND_ROWS()";
			$aResultFilterTotal = $wpdb->get_results( $sQuery, ARRAY_A );
			$iFilteredTotal     = $aResultFilterTotal[0]['FOUND_ROWS()'];

/* Total data set length */
			$sQuery       = "
				SELECT COUNT(" . $sIndexColumn . ")
				FROM   $sTable";

$aResultTotal = $wpdb->get_results( $sQuery, ARRAY_A );
			$iTotal       = $aResultTotal[0]['COUNT(id)'];

$datt = array();
			foreach($rResult as $d) {

$d['name'] = stripslashes($d['name']);
				$d['review'] = stripslashes($d['review']);

if ($d['page_id'] == 0) {

$frontpage_id = get_option( 'page_on_front' );

$d['page_url']   = get_site_url();

if (empty($frontpage_id)) {

$d['page_title'] = 'Global Review';
						$d['page_edit']  = $d['page_url'];

} else {

$d['page_title'] = 'Homepage';
						$d['page_edit']  = get_edit_post_link($frontpage_id);

}

} else {
					$d['page_title'] = get_the_title($d['page_id']);
					$d['page_url']   = get_permalink($d['page_id']);
					$d['page_edit']  = get_edit_post_link($d['page_id']);
				}

unset($d['page_id']);
				$datt[] = $d;
			}

/*
			 * Output
			 */
			$output = array(
				"sEcho"                => intval( $_POST['sEcho'] ),
				"iTotalRecords"        => $iTotal,
				"iTotalDisplayRecords" => $iFilteredTotal,
				"aaData"               => $datt
			);

echo json_encode( $output );
		}

public static function newReview() {
			$vars = self::validateVars($_POST);
			if ($vars == false) {
				XAG_Init::json('error', 'Invalid Request!');
			}

// Check if cookie tracking is on
			$ps_review = get_option('ps_review');
			if (
				isset($ps_review['settings']['prevent_multiple']) &&
				$ps_review['settings']['prevent_multiple'] == '1'
			) {
				if (!self::isAllowedToPost()) {
					XAG_Init::json('error', 'You already submitted a review!');
				}
			}

// Check if captcha
			if (isset($vars['g-recaptcha-response'])) {
				$response = wp_remote_post( 'https://www.google.com/recaptcha/api/siteverify', array(
						'method' => 'POST',
						'timeout' => 45,
						'redirection' => 5,
						'httpversion' => '1.0',
						'blocking' => true,
						'headers' => array(),
						'body' => array( 'secret' => $ps_review['details']['captcha_server'], 'response' => $vars['g-recaptcha-response'], 'remoteip' => $_SERVER['REMOTE_ADDR'] ),
						'cookies' => array()
					)
				);
				if ( is_wp_error( $response ) ) {
					XAG_Init::json('error', 'You have entered an invalid captcha! Please try again!');
				} else {
					$body = json_decode($response['body'], TRUE);
					if ($body['success'] == false) {
						XAG_Init::json('error', 'You have entered an invalid captcha! Please try again!');
					}
				}
			}

if ( empty($vars['website']) ) {
				$vars['website'] = '';
			} else {
				$vars['website'] = esc_url_raw($vars['website']);
			}

// Ratings
			$stars_only = intval($vars['stars_only']);

$approved = 0;

// Check if auto approve is on
			if (@$ps_review['settings']['stars_approve'] == 1 && $stars_only == 1) {
				$approved = 1;
			}
			if (@$ps_review['settings']['reviews_approve'] == 1 && $stars_only == 0) {
				$approved = 1;
			}

$data = array(
				'name'       => sanitize_text_field($vars['name']),
				'review'     => sanitize_text_field($vars['review']),
				'title'      => sanitize_text_field($vars['title']),
				'rating'     => intval($vars['rating']),
				'email'      => sanitize_email($vars['email']),
				'website'    => $vars['website'],
				'telephone'  => sanitize_text_field($vars['telephone']),
				'location'   => sanitize_text_field($vars['location']),
				'age'        => intval($vars['age']),
				'approved'   => $approved,
				'date'       => date('Y-m-d H:i:s'),
				'page_id'    => intval($vars['page_id']),
				'stars_only' => $stars_only
			);

$result = self::insertData($data);

if (is_integer($result)) {
				XAG_Init::json('success', 'Review added!', $result);
			} else {
				XAG_Init::json('error', $result);
			}
		}

private static function isAllowedToPost() {
			if (isset($_COOKIE['_psrl'])) {
				return false;
			} else {
				setcookie('_psrl', true,  time() + 86400); // 1 day
			}
			return true;
		}

protected static $TABLE_NAME;
		public function __construct(){
			static::$TABLE_NAME = self::TABLE_NAME;
		}

// MySQL
		const TABLE_NAME = 'prs_reviews';
		public static function createTable() {
			global $wpdb;
			require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );

$charset_collate = $wpdb->get_charset_collate();
			$creation_query =
				'CREATE TABLE ' . self::TABLE_NAME . ' (
			         `id` int(11) NOT NULL AUTO_INCREMENT,
                     `name` varchar(255) DEFAULT NULL,
                     `title` varchar(255) DEFAULT NULL,
                     `review` text,
                     `rating` int(1) DEFAULT NULL,
                     `email` varchar(255) DEFAULT NULL,
                     `website` varchar(255) DEFAULT NULL,
                     `telephone` varchar(255) DEFAULT NULL,
                     `location` text,
                     `age` int(2) DEFAULT NULL,
                     `date` datetime DEFAULT NULL,
                     `page_id` int(11) DEFAULT 0,
                     `approved` int(1) DEFAULT 0,
                     `stars_only` int(1) DEFAULT 0,
			          PRIMARY KEY  (`id`)
			    ) ' .$charset_collate. ';';
			@dbDelta( $creation_query );
		}
		public static function removeTable() {
			global $wpdb;
			$query = 'DROP TABLE IF EXISTS ' . self::TABLE_NAME . ';';
			$wpdb->query( $query );
		}

}
}

X7ROOT File Manager

Editing: wp_reviews.php

Upload File

Create Folder