johnalarcon

UPDATE cp_options SET option_value = replace(option_value, 'OLD_URL', 'NEW_URL') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE cp_posts SET guid = replace(guid, 'OLD_URL', 'NEW_URL');

UPDATE cp_posts SET post_content = replace(post_content, 'OLD_URL', 'NEW_URL');

UPDATE cp_postmeta SET meta_value = replace(meta_value,'OLD_URL', 'NEW_URL');

UPDATE cp_usermeta SET meta_value = replace(meta_value, 'OLD_URL', 'NEW_URL');

johnalarcon

<?php

// Define reading speed of your audience. 200 WPM is average; adjust to suit.
add_filter('codepotent_estimated_read_time_speed', 'codepotent_estimated_read_time_speed');
function codepotent_estimated_read_time_speed($reading_speed) {
	return 125;
}

johnalarcon

<?php

// Change the update interval of the Discourse Stats plugin widgets.
function codepotent_discourse_stats_update_interval($seconds) {
	return 86400; // 1 day
}
add_filter('codepotent_discourse_stats_update_interval', 'codepotent_discourse_stats_update_interval');

// Change the date format for the "Join date" of the Discourse Stats plugin for ClassicPress.
// See https://www.php.net/manual/en/function.date.php for all the possible date tokens.

johnalarcon

<?php

// Enable mail server ping during registration.
add_filter('codepotent_registration_honeypot_ping_mail_server', '__return_true');

johnalarcon

<?php

// Disable shortcodes in widgets? Use this filter!
add_filter('codepotent_shortcodes_everywhere_widgets', '__return_false');

// Disable shortcodes in excerpts? Use this filter!
add_filter('codepotent_shortcodes_everywhere_excerpts', '__return_false');

// Disable shortcodes in category descriptions? Use this filter!
add_filter('codepotent_shortcodes_everywhere_terms', '__return_false');

johnalarcon

<?php

// Loose method

public function insert_featured_image($plugin_id, $image_path) {

	// Get the filename from the target.
	$filename = basename($image_path);

	// Get thumbnail id, if any.

johnalarcon

function convert_hex2dec($hex) {

	// Remove hashmark, if present.
	if (substr($hex, 0, 1) === '#') {
		$hex = substr($hex, 1);
	}

	// Max of 8 characters.
	if (strlen($hex) > 8) {
		$hex = substr($hex, 0, 8);

johnalarcon

<?php

function codepotent_add_media_library_document_filter($post_mime_types) {
    $post_mime_types['application'] = [
        0 => 'Documents',
        1 => 'Manage Documents',
        2 => [
            0 => 'Document (%s)',
            1 => 'Documents (%s)',
            'singular' => 'Document (%s)',

johnalarcon

function codepotent_get_attachment_field($select, $where, $value) {

	// Bring database object into scope.
	global $wpdb;

	// Assemble the query.
	$sql = "SELECT %s FROM $wpdb->posts WHERE %s='%s';";

	// Run the query.
	$result = $wpdb->get_var($wpdb->prepare($sql, $select, $where, trim($value)));

johnalarcon

/**
 * Site policies shortcode.
 *
 * This shortcode creates a linked list of site policies. Any page that uses the
 * word "policy" in the title or slug is deemed a policy to be listed. Using the
 * shortcode [site-policies] in any post or page (or anywhere shortcodes work on
 * your particular site,) will output a linked list the site policies.
 *
 * The following attributes are supported; include as many or as few as you like
 * to get the desired result. The default behavior is to display all policies in