Viên ngọc phương Đông

ruạṛ

<?php
/*
Plugin Name: EZ SQL Reports Shortcode Widget and DB Backup
Plugin URI: http://wordpress.ieonly.com/category/my-plugins/sql-reports/
Author: Eli Scheetz
Author URI: http://wordpress.ieonly.com/category/my-plugins/
Description: Create and save SQL queries, run them from the Reports tab in your Admin, place them on the Dashboard for certain User Roles, or place them on Pages and Posts using the shortcode. And keep your database safe with scheduled backups.
Version: 4.17.42
*/
define("ELISQLREPORTS_VERSION", '4.17.42');
foreach (array("plugins_url", "get_option", "add_filter", "add_action", "add_shortcode", "register_activation_hook") as $func)
	if (!function_exists("$func"))
		die('You are not allowed to call this page directly.<p>You could try starting <a href="/">here</a>.');
/*            ___
 *           /  /\     ELISQLREPORTS Main Plugin File
 *          /  /:/     @package ELISQLREPORTS
 *         /__/::\
 Copyright \__\/\:\__  © 2011-2017 Eli Scheetz (email: wordpress@ieonly.com)
 *            \  \:\/\
 *             \__\::/ This program is free software; you can redistribute it
 *     ___     /__/:/ and/or modify it under the terms of the GNU General Public
 *    /__/\   _\__\/ License as published by the Free Software Foundation;
 *    \  \:\ /  /\  either version 2 of the License, or (at your option) any
 *  ___\  \:\  /:/ later version.
 * /  /\\  \:\/:/
  /  /:/ \  \::/ This program is distributed in the hope that it will be useful,
 /  /:/_  \__\/ but WITHOUT ANY WARRANTY; without even the implied warranty
/__/:/ /\__    of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
\  \:\/:/ /\  See the GNU General Public License for more details.
 \  \::/ /:/
  \  \:\/:/ You should have received a copy of the GNU General Public License
 * \  \::/ with this program; if not, write to the Free Software Foundation,
 *  \__\/ Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA        */

$GLOBALS["ELISQLREPORTS"] = array("query_times" => array(), "reports_keys" => array(), "encode" => '/[\?\-a-z\: \.\=\/\&\_]/ie', "backup_file" => false, "plugin_home" => "http://wordpress.ieonly.com/", "updated_images_path" => "wp-content/plugins/update/images/", "Report_SQL" => "",
	"images_path" => plugins_url("/images/", __FILE__), 
	"create-report-url" => admin_url("admin.php?page=ELISQLREPORTS-create-report"),
	"reports_array" => get_option("ELISQLREPORTS_reports_array", array()),
	"settings_array" => get_option("ELISQLREPORTS_settings_array", array()));
if (!(isset($GLOBALS["ELISQLREPORTS"]["settings_array"]["default_styles"])))
	$GLOBALS["ELISQLREPORTS"]["settings_array"]["default_styles"] = "overflow: auto;";
foreach (array_keys($GLOBALS["ELISQLREPORTS"]["reports_array"]) as $GLOBALS["ELISQLREPORTS"]["reports_key"])
	$GLOBALS["ELISQLREPORTS"]["reports_keys"][sanitize_title($GLOBALS["ELISQLREPORTS"]["reports_key"])] = $GLOBALS["ELISQLREPORTS"]["reports_key"];
$GLOBALS["ELISQLREPORTS"]["boxes"] = array("Saved Reports"=>"",
"Plugin Updates"=>'<div id="findUpdates"><center>Searching for updates ...<br /><img src="'.$GLOBALS["ELISQLREPORTS"]["images_path"].'wait.gif" alt="Wait..." /><br /><input type="button" value="Cancel" onclick="document.getElementById(\'findUpdates\').innerHTML = \'Could not find server!\';" /></center></div><script type="text/javascript" src="'.str_replace("http:", "", $GLOBALS["ELISQLREPORTS"]["plugin_home"]).$GLOBALS["ELISQLREPORTS"]["updated_images_path"].'?js='.ELISQLREPORTS_VERSION.'&p=ELISQLREPORTS"></script>',
"Plugin Links"=>'<a target="_blank" href="https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=7K3TSGPAENSGS"><img id="pp_button" src="'.$GLOBALS["ELISQLREPORTS"]["images_path"].'btn_donateCC_WIDE.gif" border="0" alt="Make a Donation with PayPal"></a>
<ul class="sidebar-links">
	<li><a target="_blank" href="https://wordpress.org/support/view/plugin-reviews/elisqlreports">Plugin Reviews on wordpress.org</a></li>
	<li><a target="_blank" href="https://wordpress.org/plugins/elisqlreports/faq/">Plugin FAQs on wordpress.org</a></li>
	<li><a target="_blank" href="https://wordpress.org/support/plugin/elisqlreports">Forum Posts on wordpress.org</a></li>
	<li><a target="_blank" href="'.$GLOBALS["ELISQLREPORTS"]["plugin_home"].'category/my-plugins/sql-reports/">Plugin Posts on Eli\'s Blog</a></li>
</ul>',
"Edit Report"=>'<div id="SQLFormDel" style="width: 256px;"><input type="submit" style="float: right; background-color: #F00;" value="DELETE REPORT" onclick="if (confirm(\'Are you sure you want to DELETE This Report?\')) { document.SQLForm.action=\'admin.php?page=ELISQLREPORTS-create-report\'; document.SQLForm.rSQL.value=\'DELETE_REPORT\'; document.SQLForm.rName.value=oldName; }"><input style="float: left;" type="button" value="Edit SQL" onclick="showhide(\'SQLFormEdit\', true); this.style.display=\'none\'; document.SQLForm.rSQL.focus();"><br style="clear: both;" /></div><div id="SQLFormSaveTo"></div>',
"Save Settings"=>'<input type="submit" value="Save Settings" class="button-primary" style="float: right;"><br style="clear: right;" />');

function ELISQLREPORTS_install() {
	global $wp_version;
	if (version_compare($wp_version, "2.6", "<"))
		die(sprintf(__("Upgrade to %s now!",'elisqlreports'), "2.6"));
}
register_activation_hook(__FILE__, "ELISQLREPORTS_install");

function ELISQLREPORTS_set_backupdir() {
	$err403 = "<?php // Silence is golden.";
	if (!(isset($GLOBALS["ELISQLREPORTS"]["settings_array"]["backup_dir"]) && strlen($GLOBALS["ELISQLREPORTS"]["settings_array"]["backup_dir"]) && is_dir($GLOBALS["ELISQLREPORTS"]["settings_array"]["backup_dir"]))) {
		$upload = wp_upload_dir();
		$GLOBALS["ELISQLREPORTS"]["settings_array"]["backup_dir"] = trailingslashit($upload["basedir"]).'SQL_Backups';
		if (!is_dir($GLOBALS["ELISQLREPORTS"]["settings_array"]["backup_dir"]) && !@mkdir($GLOBALS["ELISQLREPORTS"]["settings_array"]["backup_dir"]))
			$GLOBALS["ELISQLREPORTS"]["settings_array"]["backup_dir"] = $upload["basedir"];
		if (!is_file(trailingslashit($upload["basedir"]).'index.php'))
			@file_put_contents(trailingslashit($upload["basedir"]).'index.php', $err403);
	}
	if (!is_file(trailingslashit($GLOBALS["ELISQLREPORTS"]["settings_array"]["backup_dir"]).'.htaccess'))
		@file_put_contents(trailingslashit($GLOBALS["ELISQLREPORTS"]["settings_array"]["backup_dir"]).'.htaccess', "Options -Indexes");
	if (!is_file(trailingslashit($GLOBALS["ELISQLREPORTS"]["settings_array"]["backup_dir"]).'index.php'))
		@file_put_contents(trailingslashit($GLOBALS["ELISQLREPORTS"]["settings_array"]["backup_dir"]).'index.php', $err403);
}

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE=\'+00:00\' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=\'NO_AUTO_VALUE_ON_ZERO\' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;');
			$sql = "show full tables where Table_Type = 'BASE TABLE'";
			$result = mysqli_query($GLOBALS["ELISQLREPORTS"]["backup_connection"], $sql);
			$errors = "";
			if (mysqli_errno($GLOBALS["ELISQLREPORTS"]["backup_connection"]))
				$errors .= "/* SQL ERROR: ".mysqli_error($GLOBALS["ELISQLREPORTS"]["backup_connection"])." */\n\n/*$sql*/\n\n";
			else {
				while ($row = mysqli_fetch_row($result)) {
					$errors .= ELISQLREPORTS_get_structure($row[0]);
					if (!is_numeric($rows = ELISQLREPORTS_get_data($row[0])))
						$errors .= $rows;
				}
				mysqli_free_result($result);
				$sql = "show full tables where Table_Type = 'VIEW'";
				if ($result = mysqli_query($GLOBALS["ELISQLREPORTS"]["backup_connection"], $sql)) {
					while ($row = mysqli_fetch_row($result))
						$errors .= ELISQLREPORTS_get_structure($row[0], "View");
					mysqli_free_result($result);
				}
			}
			fclose($GLOBALS["ELISQLREPORTS"]["backup_file"]);
			$return .= "Backup: $subject Saved";
			$message .= "A database backup was saved on <a href='".trailingslashit(get_option("siteurl"))."wp-admin/admin.php?page=ELISQLREPORTS-settings'>".(get_option("blogname"))."</a>.\r\n<p><pre>$errors</pre><p>";
			if (isset($GLOBALS["ELISQLREPORTS"]["settings_array"]["compress_backup"]) && $GLOBALS["ELISQLREPORTS"]["settings_array"]["compress_backup"]) {
				$zip = new ZipArchive();
				if ($zip->open($backup_file.'.zip', ZIPARCHIVE::CREATE) === true) {
					$zip->addFile($backup_file, $filename);
					$zip->close();
				}
				if (is_file($backup_file) && is_file($backup_file).'.zip') {
					if (@unlink($backup_file))
						$backup_file .= '.zip';
				} else
					$return .= " but not Zipped";
			}
		} else
			$return .= 'Database Connection ERROR: '.mysqli_connect_error();
	} else
		$return .= "Failed to save backup!";
	if (isset($GLOBALS["ELISQLREPORTS"]["settings_array"][$backup_type."_backup"]) && $GLOBALS["ELISQLREPORTS"]["settings_array"][$backup_type."_backup"] > 0) {
		$sql_files = array();
		if ($handle = opendir($GLOBALS["ELISQLREPORTS"]["settings_array"]["backup_dir"])) {
			while (false !== ($entry = readdir($handle)))
				if (is_file(trailingslashit($GLOBALS["ELISQLREPORTS"]["settings_array"]["backup_dir"]).$entry))
					if (strpos($entry, $subject))
						$sql_files[] = "$entry";
			closedir($handle);
			rsort($sql_files);
		}
		$del=0;
		while (count($sql_files)>$GLOBALS["ELISQLREPORTS"]["settings_array"][$backup_type."_backup"])
			if (@unlink(trailingslashit($GLOBALS["ELISQLREPORTS"]["settings_array"]["backup_dir"]).array_pop($sql_files)))
				$del++;
		$message .= "\r\nNumber of archives:<li>Deleted: $del</li><li>Kept: ".count($sql_files)."</li><p>";
	}
	if (strlen($GLOBALS["ELISQLREPORTS"]["settings_array"]["backup_email"])) {
		$headers = 'From: '.get_option("admin_email")."\r\n";
		$headers .= "MIME-Version: 1.0\r\n";
		$headers .= "Content-Type: multipart/mixed; boundary=\"$uid\"\r\n";
		$upload = wp_upload_dir();
		if (file_exists($backup_file)) {
			$file_size = filesize($backup_file);
			$handle = fopen($backup_file, "rb");
			$content .= "The backup has been attached to this email for your convenience.\r\n\r\n--$uid\r\nContent-Type: application/octet-stream; name=\"".basename($backup_file)."\"\r\nContent-Transfer-Encoding: base64\r\nContent-Disposition: attachment; filename=\"".basename($backup_file)."\"\r\n\r\n".chunk_split(base64_encode(fread($handle, $file_size)), 70, "\r\n");
			fclose($handle);
		}
		if (mail($GLOBALS["ELISQLREPORTS"]["settings_array"]["backup_email"], preg_replace('/^<[^>]+?>/', "", $return), $message.$content."\r\n\r\n--$uid--", $headers))
			$return .= " Email Sent!";
		else
			mail($GLOBALS["ELISQLREPORTS"]["settings_array"]["backup_email"], preg_replace('/^<[^>]+?>/', "", $return), $message.strlen($content)." bytes is too large to attach but you can download it <a href='".admin_url("admin.php?page=ELISQLREPORTS-settings&Download_SQL_Backup=".basename($backup_file))."'>here</a>.\r\n\r\n--$uid--", $headers);
	}
	return $return.'</div>';
}
function ELISQLREPORTS_get_structure($table, $type='Table') {
	fwrite($GLOBALS["ELISQLREPORTS"]["backup_file"], "\n\n--\n-- Table structure for ".strtolower($type)." `$table`\n--\n\n");
	$sql = "SHOW CREATE $type `$table`; ";
	if ($result = mysqli_query($GLOBALS["ELISQLREPORTS"]["backup_connection"], $sql)) {
		if ($row = mysqli_fetch_assoc($result))
			fwrite($GLOBALS["ELISQLREPORTS"]["backup_file"], "DROP ".strtoupper($type)." IF EXISTS `$table`;\n/*!40101 SET @saved_cs_client     = @@character_set_client */;\n/*!40101 SET character_set_client = utf8 */;\n".preg_replace('/CREATE .+? VIEW/', 'CREATE VIEW', $row["Create $type"]).";\n/*!40101 SET character_set_client = @saved_cs_client */;");
		mysqli_free_result($result);
	} else
		return "/* requires the SHOW VIEW privilege and the SELECT privilege */\n\n";
	return '';
}
function ELISQLREPORTS_get_data($table) {
	$sql = "SELECT * FROM `$table`;";
	if ($result = mysqli_query($GLOBALS["ELISQLREPORTS"]["backup_connection"], $sql)) {
		$num_rows = mysqli_num_rows($result);
		$num_fields = mysqli_num_fields($result);
		$return = 0;
		if ($num_rows > 0) {
			fwrite($GLOBALS["ELISQLREPORTS"]["backup_file"], "\n\n--\n-- Dumping data for table `$table`\n--\n\nLOCK TABLES `$table` WRITE;\n/*!40000 ALTER TABLE `$table` DISABLE KEYS */;\n");
			$field_type = array();
			$field_list = " (";
			for ($i = 0; $meta = mysqli_fetch_field($result); $i++) {
				array_push($field_type, $meta->type);
				$field_list .= ($i?', ':'')."`$meta->name`";
			}
			$field_list .= ")";
			$field_list = ""; // field_list is not required for insert
			$maxInsertSize = 100000;
			$statementSql = "";
			for ($index = 0; $row = mysqli_fetch_row($result); $index++) {
				$return++;
				if (strlen($statementSql) > $maxInsertSize) {
					fwrite($GLOBALS["ELISQLREPORTS"]["backup_file"], $statementSql.";\n");
					$statementSql = "";
				}
				if (strlen($statementSql) == 0)
					$statementSql = "INSERT INTO `$table`$field_list VALUES ";
				else
					$statementSql .= ",";
				$statementSql .= "(";
				for ($i = 0; $i < $num_fields; $i++) {
					if (is_null($row[$i]))
						$statementSql .= "null";
					else {
						if ($field_type[$i] == 'int')
							$statementSql .= $row[$i];
						else
							$statementSql .= "'" . mysqli_real_escape_string($GLOBALS["ELISQLREPORTS"]["backup_connection"], $row[$i]) . "'";
					}
					if ($i < $num_fields - 1)
						$statementSql .= ",";
				}
				$statementSql .= ")";
			}
			if ($statementSql)
				fwrite($GLOBALS["ELISQLREPORTS"]["backup_file"], $statementSql.";\n/*!40000 ALTER TABLE `$table` ENABLE KEYS */;\nUNLOCK TABLES;");
		}
		mysqli_free_result($result);
	} else
		$return = "SELECT ERROR for `$table`: ".mysqli_error($GLOBALS["ELISQLREPORTS"]["backup_connection"])."\n";
	return $return;
}

function ELISQLREPORTS_deactivation() {
	while (wp_next_scheduled('ELISQLREPORTS_daily_backup', array("Y-m-d-H-i-s", 'daily')))
		wp_clear_scheduled_hook('ELISQLREPORTS_daily_backup', array("Y-m-d-H-i-s", 'daily'));
	while (wp_next_scheduled('ELISQLREPORTS_hourly_backup', array("Y-m-d-H-i-s", 'hourly')))
		wp_clear_scheduled_hook('ELISQLREPORTS_hourly_backup', array("Y-m-d-H-i-s", 'hourly'));
}
register_deactivation_hook(__FILE__, 'ELISQLREPORTS_deactivation');

function ELISQLREPORTS_activation() {
	$GLOBALS["ELISQLREPORTS"]["settings_array"] = get_option('ELISQLREPORTS_settings_array', array());
	if (isset($GLOBALS["ELISQLREPORTS"]["settings_array"]["daily_backup"]) && $GLOBALS["ELISQLREPORTS"]["settings_array"]["daily_backup"] && !wp_next_scheduled('ELISQLREPORTS_daily_backup', array("Y-m-d-H-i-s", 'daily')))
		wp_schedule_event(time(), 'daily', 'ELISQLREPORTS_daily_backup', array("Y-m-d-H-i-s", 'daily'));
	if (isset($GLOBALS["ELISQLREPORTS"]["settings_array"]["hourly_backup"]) && $GLOBALS["ELISQLREPORTS"]["settings_array"]["hourly_backup"] && !wp_next_scheduled('ELISQLREPORTS_hourly_backup', array("Y-m-d-H-i-s", 'hourly')))
		wp_schedule_event(time(), 'hourly', 'ELISQLREPORTS_hourly_backup', array("Y-m-d-H-i-s", 'hourly'));
}
register_activation_hook(__FILE__, 'ELISQLREPORTS_activation');

function ELISQLREPORTS_enqueue_scripts() {
    wp_enqueue_style('dashicons');
}
add_action('admin_enqueue_scripts', 'ELISQLREPORTS_enqueue_scripts');

function ELISQLREPORTS_sanitize_array($list) {
	return $list;
}

class ELISQLREPORTS_Widget_Class extends WP_Widget {
	function __construct() {
		parent::__construct('ELISQLREPORTS-Widget', __('EZ SQL Report'), array('classname' => 'ELISQLREPORTS_Widget_Class', 'description' => __('Display one of your saved Reports in the widget area.')));
	}
	function widget($args, $instance) {
		extract($args);
		if (isset($instance['title']) && strlen($instance['title']) && isset($GLOBALS["ELISQLREPORTS"]["reports_keys"][$instance['title']])) {
			echo $before_widget.$before_title.$GLOBALS["ELISQLREPORTS"]["reports_keys"][$instance['title']].$after_title."\n<style>#".$instance['title']." h2.ELISQLREPORTS-Report-Name {display: none;}</style>\n".ELISQLREPORTS_view_report($instance['title']).$after_widget;
		}
	}
	function flush_widget_cache() {
		wp_cache_delete('ELISQLREPORTS_Widget_Class', 'widget');
	}
	function update($new, $old) {
		$instance = $old;
		$instance['title'] = strip_tags($new['title']);
		return $instance;
	}
	function form($instance) {
		$title = isset($instance['title']) ? esc_attr($instance['title']) : '';
		echo '<p><label for="'.$this->get_field_id('title').'">'.__('Report to Distplay').':</label><br />
		<select name="'.$this->get_field_name('title').'" id="'.$this->get_field_id('title').'"><option value="">Select a Report</option>';
		foreach ($GLOBALS["ELISQLREPORTS"]["reports_array"] AS $Rname => $Rquery)
			echo '<option value="'.sanitize_title($Rname).'"'.(sanitize_title($Rname)==$title?" selected":"").'>'.$Rname.'</option>';
		echo '</select></p>';
	}
}
add_action('widgets_init', create_function('', 'return register_widget("ELISQLREPORTS_Widget_Class");'));

function ELISQLREPORTS_link($lText, $lAddress, $lDashicon = "", $lTag = "", $lAnchor = "") {
	if (substr($lAddress, 0, 1) == "&")
		$lAddress = $GLOBALS["ELISQLREPORTS"]["create-report-url"].$lAddress;
	elseif (substr($lAddress, 0, 1) != "#")
		$lAnchor = ' target="_blank"';
	return ($lTag?"<$lTag>":"").($lAddress?'<a'.$lAnchor.' href="'.$lAddress.'">':"").($lDashicon?'<span class="dashicons dashicons-'.$lDashicon.'"></span>':"").$lText.($lAddress?'</a>':"").($lTag?"</$lTag>":"");
}

function ELISQLREPORTS_set_plugin_action_links($links_array, $plugin_file) {
	if (strlen($plugin_file) > 10 && $plugin_file == substr(__file__, (-1 * strlen($plugin_file))))
		$links_array = array_merge(array(ELISQLREPORTS_link("Create SQL Report", "&", "welcome-add-page")), $links_array);
	return $links_array;
}
add_filter("plugin_action_links", "ELISQLREPORTS_set_plugin_action_links", 1, 2);

function ELISQLREPORTS_set_plugin_row_meta($links_array, $plugin_file) {
	if (strlen($plugin_file) > 10 && $plugin_file == substr(__file__, (-1 * strlen($plugin_file))))
		$links_array = array_merge($links_array, array(ELISQLREPORTS_link("Donate", "https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=8VWNB5QEJ55TJ", "heart")));
	return $links_array;
}
add_filter("plugin_row_meta", "ELISQLREPORTS_set_plugin_row_meta", 1, 2);

function ELISQLREPORTS_shortcode($attr) {
	$report = '';
	if (isset($attr['name']) && strlen(trim($attr['name']))) {
		if (isset($attr['style']) && strlen(trim($attr['style'])))
			$GLOBALS["ELISQLREPORTS"]["settings_array"]["default_styles"] = $attr['style'];
		$report = '<div id="'.sanitize_title($attr['name']).'-wrapper"><div id="'.sanitize_title($attr['name']).'-parent">'.ELISQLREPORTS_view_report($attr['name']).'<br style="clear: both;"></div></div>';
	}
	return $report;
}
add_shortcode("SQLREPORT", "ELISQLREPORTS_shortcode");