Todi Adiyatmo Wijoyo todiadiyatmo

Cek string pada options yang panjang

SELECT option_name, LENGTH(option_value), autoload FROM wp_options ORDER BY autoload DESC, option_name ASC;

Delete transient

DELETE FROM `wp_options` WHERE `option_name` LIKE ('_transient_%');
DELETE FROM `wp_options` WHERE `option_name` LIKE ('_site_transient_%');

set @meterR = 111195;
set @range = 2300 / @meterR;

select id,( st_distance(shape,point(-7.747347,110.404036)) * @meterR  ) as distance from locations 
where st_distance(shape,point(-7.747347,110.404036)) < @range
and locationable_type = 'App\\Models\\Perawat'

wp-config.php

define('DISABLE_WP_CRON', 'true');

Crontab

*/2 * * * * wget -q -O - https://yoursite.com/wp-cron.php?doing_wp_cron  >/dev/null 2>&1

PHP Replace

php srdb.cli.php  -h localhost -u [user] -s "[search]" -n [db_name] -r "[replace]" -p "[password]"

Redis stat

/usr/local/rvm/gems/ruby-2.3.0/bin/redis-stat --server --daemon --auth=[]

Search String

define('WP_PROXY_HOST', '10.7.1.7');
define('WP_PROXY_PORT', '8080');
define('WP_PROXY_USERNAME', '');
define('WP_PROXY_PASSWORD', '');
define('WP_PROXY_BYPASS_HOSTS', 'localhost');

Favourite Package

https://atom.io/packages/project-manager

# BEGIN W3TC Browser Cache
<IfModule mod_mime.c>
    AddType text/css .css
    AddType text/x-component .htc
    AddType application/x-javascript .js
    AddType application/javascript .js2
    AddType text/javascript .js3
    AddType text/x-js .js4
    AddType video/asf .asf .asx .wax .wmv .wmx

	*.log
	*.zip
	*.wpress
	*.tar.gz
	*.rar
	*.tar
	wp-config.php
	/.htaccess
	/license.txt
	/readme.html

	<html><head></head><body><div id="htmlscript">
	<a href="http://www.pu.edu.pk/" target="_blank">
	<img style="width: 100%;height: auto;" src="http://stagging-adserver.hipwee.com/images/1_ca.jpeg?1490622262"></a>
	</div></body></html>

	- nodemodules/nunjucks/bin ( precompile )
	- specify the the source directory and destination file
	- precompile templates\items > templates\showitem.js