function sc_get_template($atts) {
$param = shortcode_atts( array(
'file' => '',
), $atts );
$param['file'] = ltrim($param['file'],'/.');
$file = TEMPLATEPATH . DIRECTORY_SEPARATOR . $param['file'];
if(!file_exists($file))return '';
ob_start();
include($file);
$contents = ob_get_contents();
ob_end_clean();
return $contents;
}
add_shortcode('get_template', 'sc_get_template');
[get_template file="module/_head.php"]
CREATE TABLE `users` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARBINARY(100) NULL DEFAULT NULL, `email` VARBINARY(200) NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `id` (`id`) ) ENGINE=InnoDB ;
crypto_saltは任意の文字列
SET @key_str = SHA2('crypto_salt',512);
INSERT INTO users(name,email) VALUES(AES_ENCRYPT('佐藤鈴木',@key_str),AES_ENCRYPT('satosuzuki@nullmail.com',@key_str));
SET @key_str = SHA2('crypto_salt',512);
SELECT id,AES_DECRYPT(`name`,@key_str) AS name,AES_DECRYPT(`email`,@key_str) AS email FROM users;
require_once 'idiorm.php';
ORM::configure('mysql:host=localhost;dbname=dev_db');
ORM::configure('username', 'root');
ORM::configure('password', '');
ORM::configure('driver_options', [
PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
PDO::ATTR_EMULATE_PREPARES => false,
PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true,
]);
function echo_json($data)
{
header("Content-Type: application/json; charset=utf-8");
echo json_encode($data);
}
$words = mb_split('[\s, ]',addcslashes(trim($_POST['keywords']),'\_%'));
try{
$orm = ORM::for_table('entries')->select('id')->where_equal('deleted','0')->order_by_asc('id');
foreach ($words as $w) {
$w = trim($w);
if($w !== '')
$orm->where_like('search', "%{$w}%");
}
$recipes = $orm->find_many();
}catch (PDOException $e){
}
$result_data = array();
if(!empty($recipes)){
foreach ($recipes as $recipe)
$result_data[] = $recipe->html_id;
}
echo_json($result_data);
exit;
public function remove_protocol($url)
{
return preg_replace('/^https?:\/\/[^\/]+/', '', $url);
}
update wp_options set option_value='/manage' where option_name = 'siteurl'; update wp_options set option_value='/' where option_name = 'home'; update wp_options set option_value='/uploads' where option_name = 'upload_url_path'; update wp_options set option_value='../uploads' where option_name = 'upload_path'; update wp_options set option_value='' where option_name = 'blogdescription'; update wp_options set option_value='0' where option_name = 'start_of_week'; update wp_options set option_value='Y/m/d' where option_name = 'date_format'; update wp_options set option_value='H:i' where option_name = 'time_format'; update wp_options set option_value='closed' where option_name = 'default_comment_status'; update wp_options set option_value='closed' where option_name = 'default_ping_status'; update wp_options set option_value='0' where option_name = 'thumbnail_size_w'; update wp_options set option_value='0' where option_name = 'thumbnail_size_h'; update wp_options set option_value='0' where option_name = 'medium_size_w'; update wp_options set option_value='0' where option_name = 'medium_size_h'; update wp_options set option_value='0' where option_name = 'large_size_w'; update wp_options set option_value='0' where option_name = 'large_size_h'; update wp_options set option_value='0' where option_name = 'medium_large_size_w'; update wp_options set option_value='0' where option_name = 'medium_large_size_h'; update wp_options set option_value='0' where option_name = 'uploads_use_yearmonth_folders'; update wp_options set option_value='/%postname%/' where option_name = 'permalink_structure';
plugin require
Advanced Custom Fields PRO Custom Post Type UI Scheduled Post Trigger User Role Editor WP Term Order Duplicate Post
plugin option
Radio Buttons for Taxonomies Parent Category Toggler Adjust Admin Categories
function download_file($filePath)
{
header("Content-Disposition: inline; filename=\"" . basename($filePath) . "\"");
header("Content-Length: " . filesize($filePath));
header("Content-Type: application/octet-stream");
readfile($filePath);
}
.htaccessへ下記を追記
AddType application/vnd.openxmlformats-officedocument.wordprocessingml.document .docx AddType application/vnd.openxmlformats-officedocument.spreadsheetml.sheet .xlsx AddType application/vnd.openxmlformats-officedocument.presentationml.presentation .pptx
public function get_image_rgb($image_path,$x=0,$y=0)
{
if(!is_readable($image_path))
return false;
$im = imagecreatefrompng($image_path);
$rgb = imagecolorat($im, $x, $y);
$r = ($rgb >> 16) & 0xFF;
$g = ($rgb >> 8) & 0xFF;
$b = $rgb & 0xFF;
return array(
'r' => $r,
'g' => $g,
'b' => $b,
);
}
mt-config.cgiに下記を追記
DirUmask 0022 HTMLPerms 0755 UploadPerms 0755
public function imagescale_output($image_path,$save_path,$width,$height,$aspect_fill = true,$strict_size_on_aspect_fit = true,$space_color = array('r'=>255,'g'=>255,'b'=>255))
{
if(!is_readable($image_path))
return false;
$o_img = $this->imagecreate($image_path);
$o_w = imagesx($o_img);
$o_h = imagesy($o_img);
$w_ratio = $width / $o_w;
$h_ratio = $height / $o_h;
$ratio = $aspect_fill ? max($w_ratio,$h_ratio) : min($w_ratio,$h_ratio);
$new_w = round($o_w * $ratio);
$new_h = round($o_h * $ratio);
if(function_exists('imagescale')){
$new_img = imagescale($o_img,$new_w,$new_h);
}else{
$new_img = imagecreatetruecolor($new_w, $new_h);
imagecopyresampled($new_img, $o_img, 0, 0, 0, 0, $new_w, $new_h, $o_w, $o_h);
}
$param = $aspect_fill ? array('x' => round(abs($width - $new_w) * 0.5), 'y' => round(abs($height - $new_h) * 0.5), 'width' => $width, 'height' => $height) : array('x' => 0, 'y' => 0, 'width' => $new_w, 'height' => $new_h);
if(function_exists('imagecrop')) {
$dest_img = imagecrop($new_img, $param);
}else{
$dest_img = imagecreatetruecolor($param['width'], $param['height']);
imagecopy($dest_img, $new_img, 0, 0, $param['x'], $param['y'], $param['width'], $param['height']);
}
imagedestroy($new_img);
if(!$aspect_fill && $strict_size_on_aspect_fit){
$next_img = imagecreatetruecolor($width,$height);
imagefill($next_img,0,0,empty($space_color) ? imagecolorat($dest_img,round($new_w*0.5),0) : imagecolorallocate($dest_img,$space_color['r'],$space_color['g'],$space_color['b']));
imagecopy($next_img,$dest_img,round(abs($width - $new_w) * 0.5),round(abs($height - $new_h) * 0.5),0,0,$param['width'],$param['height']);
$success = $this->imageoutput($next_img,$save_path);
imagedestroy($o_img);
imagedestroy($next_img);
imagedestroy($dest_img);
}else {
$success = $this->imageoutput($dest_img, $save_path);
imagedestroy($o_img);
imagedestroy($dest_img);
}
return $success;
}