Dannny s9011514

## bulk-del-comments-meta.sql
/* 批次刪除不存在的迴響之meta值 */
DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments);

## bulk-comments-1.sql
/*批次關閉所有文章留言*/
UPDATE wp_posts SET comment_status = 'close' WHERE post_type = 'post' ;

## wp_srcset_fix.php
<?php
add_filter('wp_get_attachment_image_attributes', function($attr) {
    if (isset($attr['sizes'])) unset($attr['sizes']);
    if (isset($attr['srcset'])) unset($attr['srcset']);
    return $attr;
}, PHP_INT_MAX);
add_filter('wp_calculate_image_sizes', '__return_false', PHP_INT_MAX);
add_filter('wp_calculate_image_srcset', '__return_false', PHP_INT_MAX);
remove_filter('the_content', 'wp_make_content_images_responsive');

## change-name.php
<?php
/**
 功能：檔案避免中文檔名
 **/
function achang_chang_filename_to_date($filename) {
	$info = pathinfo($filename);
	$ext  = empty($info['extension']) ? '' : '.' . $info['extension'];
	$name = basename($filename, $ext);
	if(!is_numeric($name)){

## robots.txt

#Googlebot
User-agent: Googlebot
Allow: *.css
Allow: *.js

# Other bot spider
User-agent: *
Disallow: /wp-admin/
Disallow: /wp-includes/

## php-mail.php
<?php
  $to =" yourmail@your.com "; //收件者
  $subject = "test"; //信件標題
  $msg = "smtp發信測試";//信件內容
  $headers = "From: admin@your.com"; //寄件者

  if(mail("$to", "$subject", "$msg", "$headers")):
   echo "信件已經發送成功。";//寄信成功就會顯示的提示訊息
  else:
   echo "信件發送失敗！";//寄信失敗顯示的錯誤訊息

## remove-iframe.html
<script>
//<![CDATA[
if (top.location != location ) {
	top.location.href = location.href;
}
//]]>
</script>

## step1.html
<script src="https://apis.google.com/js/plusone.js"></script>
<div class="g-savetodrive" data-filename="檔案名稱" data-sitename="網站名稱" data-src="檔案路徑">
</div>

## step1.html
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>

## step1.html
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
	/* 批次刪除不存在的迴響之meta值 */
	DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments);
	/批次關閉所有文章留言/
	UPDATE wp_posts SET comment_status = 'close' WHERE post_type = 'post' ;
	<?php
	add_filter('wp_get_attachment_image_attributes', function($attr) {
	if (isset($attr['sizes'])) unset($attr['sizes']);
	if (isset($attr['srcset'])) unset($attr['srcset']);
	return $attr;
	}, PHP_INT_MAX);
	add_filter('wp_calculate_image_sizes', '__return_false', PHP_INT_MAX);
	add_filter('wp_calculate_image_srcset', '__return_false', PHP_INT_MAX);
	remove_filter('the_content', 'wp_make_content_images_responsive');
	<?php
	/**
	功能：檔案避免中文檔名
	**/
	function achang_chang_filename_to_date($filename) {
	$info = pathinfo($filename);
	$ext = empty($info['extension']) ? '' : '.' . $info['extension'];
	$name = basename($filename, $ext);
	if(!is_numeric($name)){

	#Googlebot
	User-agent: Googlebot
	Allow: *.css
	Allow: *.js

	# Other bot spider
	User-agent: *
	Disallow: /wp-admin/
	Disallow: /wp-includes/
	<?php
	$to =" yourmail@your.com "; //收件者
	$subject = "test"; //信件標題
	$msg = "smtp發信測試";//信件內容
	$headers = "From: admin@your.com"; //寄件者

	if(mail("$to", "$subject", "$msg", "$headers")):
	echo "信件已經發送成功。";//寄信成功就會顯示的提示訊息
	else:
	echo "信件發送失敗！";//寄信失敗顯示的錯誤訊息
	<script src="https://apis.google.com/js/plusone.js"></script>
	<div class="g-savetodrive" data-filename="檔案名稱" data-sitename="網站名稱" data-src="檔案路徑">
	</div>