WordPress database clean up queries

Orphan rows
Other

Dimasmagadan / .htaccess

Last active December 31, 2017 13:00

Rewrite for wp-content\uploads folder.To stop searching for images while working on local machine.Code to override site URL to work locally. #WordPress

	<IfModule mod_rewrite.c>
	RewriteEngine On
	RewriteRule .*\.(jpe?g\|gif\|bmp\|png)$ http://i.imgur.com/qX4w7.gif [L]
	</IfModule>

mustardBees / plugin-file.php

Created December 20, 2013 19:12

WordPress snippet which prevents your plugin from being included in the list of plugins sent to WordPress.org to check for updates.

	<?php
	/**
	* Don't update this plugin
	*
	* This prevents you from being prompted to update if there's a public plugin
	* with the same name.
	*
	* @author Phil Wylie
	* @link http://link.from.pw/1cFfcFZ
	* @param array $r Request arguments

paulund / example-wp-list-table.php

Last active January 28, 2025 16:01

An example code of using the WP_List_Table class. With Pagination.

	<?php
	/*
	* Plugin Name: Paulund WP List Table Example
	* Description: An example of how to use the WP_List_Table class to display data in your WordPress Admin area
	* Plugin URI: http://www.paulund.co.uk
	* Author: Paul Underwood
	* Author URI: http://www.paulund.co.uk
	* Version: 1.0
	* License: GPL2
	*/

ericrasch / database encoding fix.sql

Last active July 17, 2018 07:48

Fix WordPress database encoding issues with these MySQL queries... source #1: http://tanyanam.com/technology/fixing-encoding-issues-on-wordpress-comments-display-as-question-marks source #2: http://stackoverflow.com/a/3568144/284091 The 3 groups of repeated queries include the post content, post title, and the post slug.

	ALTER DATABASE 'my_wp_database' CHARACTER SET utf8;
	ALTER TABLE 'wp_comments' CHARACTER SET utf8;
	alter table 'wp_comments' change comment_content comment_content LONGTEXT CHARACTER SET utf8;
	alter table 'wp_comments' change comment_author comment_author LONGTEXT CHARACTER SET utf8;


	update `wp_posts` set `post_content` = replace(`post_content` ,'Ã¡','á');
	update `wp_posts` set `post_content` = replace(`post_content` ,'Ã©','é');
	update `wp_posts` set `post_content` = replace(`post_content` ,'í©','é');
	update `wp_posts` set `post_content` = replace(`post_content` ,'Ã³','ó');

Dimasmagadan / WP_Comment_Query.php

Last active December 31, 2017 13:03

#WordPress Comments Query

	$args = array(
	'author_email' => '',
	'ID' => '',
	'karma' => '',
	'number' => '',
	'offset' => '',
	'orderby' => '',
	'order' => 'DESC',
	'parent' => '',
	'post_ID' => '',

markjaquith / gist:2653957

Created May 10, 2012 15:36

WordPress Fragment Caching convenience wrapper

	<?php
	/*
	Usage:
	$frag = new CWS_Fragment_Cache( 'unique-key', 3600 ); // Second param is TTL
	if ( !$frag->output() ) { // NOTE, testing for a return of false
	functions_that_do_stuff_live();
	these_should_echo();
	// IMPORTANT
	$frag->store();
	// YOU CANNOT FORGET THIS. If you do, the site will break.

Dimasmagadan / WP_Query.php

Last active November 21, 2022 06:27 — forked from luetkemj/wp-query-ref.php

#WordPress query with args

	<?php
	/**
	* WordPress Query Comprehensive Reference
	* Compiled by luetkemj - luetkemj.com
	*
	* CODEX: http://codex.wordpress.org/Class_Reference/WP_Query#Parameters
	* Source: https://core.trac.wordpress.org/browser/tags/3.9/src/wp-includes/query.php
	*/
	$args = array(
	//////Author Parameters - Show posts associated with certain author.

luetkemj / wp-query-ref.php

Last active April 6, 2025 09:15

WP: Query $args

	// This gist is now maintained on github at https://github.com/luetkemj/wp-query-ref

	<?php
	/**
	* WordPress Query Comprehensive Reference
	* Compiled by luetkemj - luetkemj.github.io
	*
	* CODEX: http://codex.wordpress.org/Class_Reference/WP_Query#Parameters
	* Source: https://core.trac.wordpress.org/browser/tags/4.9.4/src/wp-includes/query.php
	*/

Dmitriy Dyakonov Dimasmagadan

WordPress database clean up queries