Sub ReorderEachRow()
'
' ReorderEachRow Macro
'
'
Dim a As Range, b As Range
Set a = Selection
For Each b In a.Rows
Range(b.Address).Select
ActiveWorkbook.ActiveSheet.Sort.SortFields.Clear
ActiveWorkbook.ActiveSheet.Sort.SortFields.Add Key:=Range(b.Address) _
, SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.ActiveSheet.Sort
.SetRange Range(b.Address)
.Header = xlGuess
.MatchCase = False
.Orientation = xlLeftToRight
.SortMethod = xlPinYin
.Apply
End With
Next
End Sub
]]>The filter below stops the admin bar from displaying on the public side of the WordPress site.
The nocache in the url query is used to bypass the proxy cache for this particular website (we also add it to all url’s if the user is logged in).
/**
* Show admin bar when logged or when nocache is being used on frontend site.
*/
add_filter('show_admin_bar', function()
{
if (is_user_logged_in()) {
if (is_admin()) {
return true;
}
if (!isset($_REQUEST['nocache'])) {
return false;
}
}
return false;
});
Thie code below adds nocache query string to every URL, when the user is logged in. This helps bypass the proxy cache (with a page rule).
/**
* Add no cache to generated links.
*
* @param string
*/
function add_nocache_to_url($url)
{
if (is_user_logged_in()
&& stripos($url, 'nocache') === false) {
$url .= stripos($url, '?') === false ? '?' : '&';
$url .= 'nocache=1';
}
return $url;
}
/**
* Only override when logged in.
*/
if (is_user_logged_in()) {
add_filter('home_url', 'add_nocache_to_url', 99, 1);
add_filter('post_link', 'add_nocache_to_url', 10, 1);
add_filter('page_link', 'add_nocache_to_url', 10, 1);
add_filter('post_type_link', 'add_nocache_to_url', 10, 1);
add_filter('category_link', 'add_nocache_to_url', 11, 1);
add_filter('tag_link', 'add_nocache_to_url', 10, 1);
add_filter('author_link', 'add_nocache_to_url', 11, 1);
}
]]>UPDATE `wp_term_taxonomy` JOIN (SELECT `term_taxonomy_id`,count(*) as `new_count`,`count` as `old_count` FROM `wp_term_relationships` JOIN `wp_term_taxonomy` USING (`term_taxonomy_id`) GROUP BY `term_taxonomy_id`) as term_counts USING (`term_taxonomy_id`) SET `count` = `new_count` WHERE `old_count` != `new_count`]]>
The reason for this is jQuery is animating the height of the container without including the padding that may be being applied.
The very simple solution is to wrap the content with a container that doesn’t have any padding.
]]>
.sortable({
axis: 'y',
containment: 'parent',
items: '> tr',
handle: '.item-order-handle',
placeholder: 'change-order-placeholder',
tolerance: 'pointer'
});
.ui-sortable-helper {
display: table;
}
Notes
References
]]><div class="row"> <div id="first-column" class="col"></div> <div id="second-column" class="col"></div> <div id="third-column" class="col"></div> </div>
#first-column { order: 1; }
#second-column { order: 2; }
#third-column { order: 3; }
@media (max-width: 768px) {
#second-column { order: 3; }
#third-column { order: 2; }
}
References
]]>