Hedley Phillips DigitalEssence

## WHMCS - Delete records from database
SELECT * FROM `tbllog_register` WHERE created_at < '2023-01-01';

## WordPress - Enfold - Custom sidebar ratio
.container .av-content-small.units {
    width: 85% !important;
}

## Database Many to Many Relationship
user
+----+-----------+----------+-------+
| id | firstname | lastname | email |
+----+-----------+----------+-------+
| 1  | Peter     | Jones    | email |
| 2  | Bob       | Smith    | email |
| 3  | Sarah     | Peters   | email |
| 4  | Christine | Hall     | email |
+----+-----------+----------+-------+

## WordPress - Enfold - PHP - Add Sticky button
// Add Header Code
function de_sticky_button() {
   	?>
		<!-- Start of Sticky Button -->
			 <a href="https://www.givey.com/renewcrew" target="_blank" title="Click to donate" class="sticky-button">CLICK TO DONATE</a>
		<!-- End of Sticky Button -->
	<?php
}
add_action('wp_body_open', 'de_sticky_button');

## Powershell - Replace space in filename with hyphen
dir | rename-item -NewName {$_.name -replace " ","-"}

## Javascript-Enqueue
// Add Javascript to select default options in Product Add on
function digitalessence_new_scripts(){
wp_enqueue_script( 'product-addon-default-values', get_stylesheet_directory_uri() . '/js/product-addon-default-value.js', array(), true );
}
add_action( 'wp_enqueue_scripts', 'digitalessence_new_scripts' );

## WordPress - Enfold - PHP - Detect if a post date is in the past and add a class
// Detect if post is in the past and if so add a custom Class "oldpost"
if (strtotime(get_the_date( "Y-m-d", $the_id )) < strtotime(date("Y-m-d"))) {
 $post_class = "post-entry post-entry-{$the_id} oldpost slide-entry-overview slide-loop-{$post_loop_count} slide-parity-{$parity} {$last}";
 }
else {
 $post_class = "post-entry post-entry-{$the_id} slide-entry-overview slide-loop-{$post_loop_count} slide-parity-{$parity} {$last}";
 }

## WordPress - PHP - Display posts dated in the future
//Display Future Posts
function de_prevent_future_type( $post_data ) {
if ( $post_data['post_status'] == 'future' && $post_data['post_type'] == 'post' )
/*Here I am checking post_type='post' , you may use different post type and if you want it
for all post type then remove "&& $post_data['post_type'] == 'post'"
*/
{
$post_data['post_status'] = 'publish';
}
return $post_data;

## WordPress - PHP - Add og Open Graph data to header
//Add Open Graph
add_action('wp_head', 'fb_opengraph');
function fb_opengraph() {
	  if( is_single() || is_page() ) {
echo '
<meta property="og:title" content="Osso Restaurant - Peebles" />
<meta property="og:description" content="Osso Restaurant Peebles - Michelin Bib Gourmand Winner 2011 to 2018" />
<meta property="og:image" content="https://www.ossorestaurant.com/wp-content/uploads/2019/03/facebook-og-image.jpg" />';
	 }
}

## WordPress - MYSQL - Delete all post revisions from database
DELETE FROM wp_posts WHERE post_type = "revision";
	user
	+----+-----------+----------+-------+
	\| id \| firstname \| lastname \| email \|
	+----+-----------+----------+-------+
	\| 1 \| Peter \| Jones \| email \|
	\| 2 \| Bob \| Smith \| email \|
	\| 3 \| Sarah \| Peters \| email \|
	\| 4 \| Christine \| Hall \| email \|
	+----+-----------+----------+-------+
	// Add Header Code
	function de_sticky_button() {
	?>
	<!-- Start of Sticky Button -->
	<a href="https://www.givey.com/renewcrew" target="_blank" title="Click to donate" class="sticky-button">CLICK TO DONATE</a>
	<!-- End of Sticky Button -->
	<?php
	}
	add_action('wp_body_open', 'de_sticky_button');
	// Add Javascript to select default options in Product Add on
	function digitalessence_new_scripts(){
	wp_enqueue_script( 'product-addon-default-values', get_stylesheet_directory_uri() . '/js/product-addon-default-value.js', array(), true );
	}
	add_action( 'wp_enqueue_scripts', 'digitalessence_new_scripts' );
	// Detect if post is in the past and if so add a custom Class "oldpost"
	if (strtotime(get_the_date( "Y-m-d", $the_id )) < strtotime(date("Y-m-d"))) {
	$post_class = "post-entry post-entry-{$the_id} oldpost slide-entry-overview slide-loop-{$post_loop_count} slide-parity-{$parity} {$last}";
	}
	else {
	$post_class = "post-entry post-entry-{$the_id} slide-entry-overview slide-loop-{$post_loop_count} slide-parity-{$parity} {$last}";
	}
	//Display Future Posts
	function de_prevent_future_type( $post_data ) {
	if ( $post_data['post_status'] == 'future' && $post_data['post_type'] == 'post' )
	/*Here I am checking post_type='post' , you may use different post type and if you want it
	for all post type then remove "&& $post_data['post_type'] == 'post'"
	*/
	{
	$post_data['post_status'] = 'publish';
	}
	return $post_data;