prerna-p

MongoDB Cheat Sheet

Show All Databases

show dbs

Show Current Database

trey8611

WP All Import Optimizations

If you have a slow import, or if you're running into a lot of server timeouts, then you can follow these steps to optimize your import.

Slow Import Guide

Follow all of the steps listed here: http://www.wpallimport.com/documentation/troubleshooting/slow-imports/.

Skip posts if their data has not changed

rmpel

update wp_posts SET post_title = REPLACE(post_title, UNHEX('e280a8'), '') WHERE post_title LIKE concat('%', UNHEX('e280a8'), '%');
update wp_posts SET post_content = REPLACE(post_content, UNHEX('e280a8'), '') WHERE post_content LIKE concat('%', UNHEX('e280a8'), '%');

QWp6t

<?php

namespace Valet\Drivers\Custom;

class BedrockMultisiteValetDriver extends \Valet\Drivers\Specific\BedrockValetDriver
{
    /**
     * Determine if the incoming request is for a static file.
     *
     * @return string|false

ideadude

/*
	1. Make sure PMPro and PMPro Proration are both active.
	2. Edit the pmpro_checkout_level_custom_prorating_rules function below to your needs.
	3. Then add this code into a custom plugin for your site.
*/

/**
 * Swap in our custom prorating function.
 */
function init_custom_prorating_rules() {

valerianpereira

/*
 * Display the array in a formatted manner
 * Skip the struggle reading the array unformatted.
 * Usage: rPrint($arrayElement);
 */ 
function rPrint($arr) {
  echo '<pre>';
  print_r($arr);
  echo '</pre>';
}

joshbuchea

Semantic Commit Messages

See how a minor change to your commit message style can make you a better programmer.

Format: <type>(<scope>): <subject>

<scope> is optional

Example

VladimirAlexiev

How to use Google Sheets to Manage Wikidata Coreferencing

A previous post How to Add Museum IDs to Wikidata explained how to use SPARQL to find missing data on Wikidata (Getty Museum IDs), how to create such values (from museum webpage URLs) and how to format them properly for QuickStatements.

Here I explain how to use Google sheets to manage a more advanced task. The sheet AAT-Wikidata matches about 3k AAT concepts to Wikipedia, WordNet30 and BabelNet (it restored an old mapping to Wordnet, retrieved it from BabelNet, mapped to Wikipedia).

• For each row, it uses the following Google sheet formula (column C) to query the Wikipedia API and get the corresponding Wikidata ID (wikibase_item); split on two lines for readability:

=ImportXml(concat("https://en.wikipedia.o

ControlledChaos

Change Default Posts to News

WordPress Snippet

strangerstudios

<?php
/*
Plugin Name: PMPro Custom Prorating Code
Plugin URI: http://www.paidmembershipspro.com/wp/pmpro-custom-prorating/
Description: Custom Prorating Code and Other Code for PMPro
Version: .2
Author: Stranger Studios
Author URI: http://www.strangerstudios.com
*/