Skip to content

Instantly share code, notes, and snippets.

View davidsword's full-sized avatar

David Sword davidsword

17 followers · 0 following
View GitHub Profile
@davidsword
davidsword / restrict-wordpress-user-to-one-page-without-plugin.php
Last active February 3, 2018 03:08
<?php
add_action('admin_init','HR_user_lockout');
function HR_user_lockout() {
global $current_user, $menu, $submenu;
$restricted_user = 1;
// check for current user
if ($current_user->data->ID == $restricted_user) {
// remove admin menus
$menu = array();
$submenu = array();
@davidsword
davidsword / query-refresh-part-of-page.php
Created September 14, 2016 21:09
<html>
<head>
<script src="http://code.jquery.com/jquery-latest.js"></script>
<script type='text/javascript'>
$(document).ready(function() {
setInterval(function() {
var url = 'http://full_url_of_this_page.html';
$('#refresh_zone-wrapper').load(url + ' #refresh_zone'); //note: space between intentional
}, 2000); // milliseconds
@davidsword
davidsword / media-temple-mysqldump-to-local-error-2049-authentication-protocol-refused-1.txt
Created September 14, 2016 21:14
mysqldump: Got error: 2005: Unknown MySQL server host
'external-db.s000000.gridserver.com' (0) when trying
to connect
@davidsword
davidsword / media-temple-mysqldump-to-local-error-2049-authentication-protocol-refused.sql
Created September 14, 2016 21:17
mysqldump -h external-db.s000000.gridserver.com --add-drop-table -u db000000_username -p db000000_database > ~/Sites/db000000.sql
@davidsword
davidsword / media-temple-mysqldump-to-local-error-2049-authentication-protocol-refused-2.txt
Created September 14, 2016 21:17
mysqldump: Got error: 2049: Connection using old (pre-4.1.1)
authentication protocol refused (client option 'secure_auth'
enabled) when trying to connect
@davidsword
davidsword / clean-revisions-1.sql
Last active February 3, 2018 03:08
DELETE a,b,c FROM wp_posts a LEFT JOIN
wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id) WHERE a.post_type = 'revision';
@davidsword
davidsword / clean-revisions.php
Last active February 3, 2018 03:07
<?
global $wpdb;
$wpdb->query("DELETE a,b,c FROM wp_posts a LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) LEFT JOIN wp_postmeta c ON (a.ID = c.post_id) WHERE a.post_type = 'revision'");
?>
@davidsword
davidsword / clean-revisions-2.php
Last active February 3, 2018 03:07
<?
define('AUTOSAVE_INTERVAL', 300 );
define('WP_POST_REVISIONS', false );
?>
@davidsword
davidsword / changing-main-domain-of-wordpress-network-when-domain-mapping-1.php
Created September 14, 2016 21:27
define( 'DOMAIN_CURRENT_SITE', 'newname.com' );
@davidsword
davidsword / changing-main-domain-of-wordpress-network-when-domain-mapping-2.txt
Last active February 3, 2018 03:07
rows: `siteurl`, `home` in: `wp_options`
rows: `domain` in: `wp_site`
row: `siteurl` in: `wp_sitemeta`
row: `home`, `site url` in every: `wp_*_options`
then
`UPDATE `wp_blogs` SET `domain`='newdomain.com'`