Nodws’s gists

## Migration.sql
UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl');

## Cache
<?php
$cache = 'data.txt';
if(date("Ymd", filemtime($cache)) <  date("Ymd") || filesize($cache) < 1):
 $data = get_data(); // do your thing
  $file = fopen($cache,'w+');
  $text = is_array($data) ? json_encode($data) : $data;
   fwrite($file, $text);
   fclose($file);
else:
   $file = fopen($cache,'w+');

## Center hero image

.hero{
    height:200px;
    overflow:hidden;
    display:flex;
    align-items:center;
    justify-content:center
}
.hero div{
    min-width:100%; display:flex;

## Truncate text by word
function texto($text, $limit=8) {
      if (str_word_count($text, 0) > $limit) {
          $words = str_word_count($text, 2);
          $pos = array_keys($words);
          $text = substr($text, 0, $pos[$limit]) . '...';
      }
      return $text;
    }

## .htaccess
<FilesMatch "^(wp-config|wp-settings|wp-trackback|wp-comments-post|xmlrpc)\.php$">
 Order allow,deny
 Deny from all
 Satisfy All
</FilesMatch>

## Breadcrumbs
<?
//FOR POST
$t = wp_get_post_terms(get_the_id(),'taxonomy');
$t[0] = ($t[0]->parent && !$t[1]->parent) ? $t[0] : $t[1];
  if($t[0]->parent)
   { $p = get_term_by('id',$t[0]->parent,'taxonomy');
    echo '<a href="'.get_term_link($t[0]->parent,'taxonomy').'">'.$p->name.'</a> &raquo; ';  }
echo '<a href="'.get_term_link($t[0]->term_id,'taxonomy').'" class="crumb-current">'.$t[0]->name.'</a>';

//FOR ARCHIVE

## WPConfig
define('td', get_bloginfo('template_directory').'/' );
define('hd', esc_url(home_url( '/' )));

//WPconfig
$path = '/path';
define( 'WP_SITEURL', 'http://' . $_SERVER['SERVER_NAME'] . $path );
define( 'WP_HOME', 'http://' . $_SERVER['HTTP_HOST'] . $path );
define( 'AUTOSAVE_INTERVAL', 3600 );
define( 'WP_POST_REVISIONS', 3 );
define( 'WP_MAX_MEMORY_LIMIT', '256M' );

## Urlmask
<body style="padding:0; margin:0;height:100%;overflow:hidden"><iframe src="http://nodws.com" style="height: 100%;width:100% " allowtransparency="true" frameborder="0"></iframe></body>

## Partial page refresh
setInterval(function() {
$("#refresh").load(location.href+" #refresh>*","");
}, 10000); // milliseconds to wait

## Add prefix or suffix
#add prefix
rename s/'^'/'MyPrefix'/ *

#add suffix
rename s/'$'/'MySuffix'/ *

#numbered
n=1; for f in ./*.jpg; do mv "$f" $n.jpg; n=$((n+1)); done