Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

View hiddenpearls's full-sized avatar
🏁
About to reach my GOAL

Adnan hiddenpearls

🏁
About to reach my GOAL
View GitHub Profile
@hiddenpearls
hiddenpearls / canceled-subscriptions.sql
Created January 24, 2022 21:22 — forked from webzunft/canceled-subscriptions.sql
SQL queries to analyse canceled subscriptions managed with EDD Recurring Payments
# Basic queries to analyse canceled subscriptions using EDD Recurring Payments pre EDD 3.0
# Use EXPLAIN if you have large stores since the "notes" column is not indexed and queries can take some time
# Some of these reports might be worth storing as Views and look at the graphs PHPMyAdmin can also create from them
# List subscription cancelation with creation and cancelation date, as well as the user who canceled
# good as a basis for further queries
SELECT ID,
created,
REGEXP_SUBSTR( REGEXP_SUBSTR( notes, '.* Status changed from active to cancelled .*' ), '^[a-z]+ [0-9]+, [0-9]+' ) AS 'date',
@hiddenpearls
hiddenpearls / check-edd-license
Created June 19, 2018 14:23
Check EDD License status
/**
* Check and get the license data.
*
* @param string $license The license key.
*
* @return false|array
*/
public static function check_license( $license ) {
$license = trim( $license );
@hiddenpearls
hiddenpearls / shortcode.html
Last active August 15, 2023 13:10
Analytify dashboard sections on frontend as shortcodes
<style>
.analytify_status_box_wraper {
border: 1px solid #e2e5e8;
margin-bottom: 20px;
background: #fff;
line-height: 1.5;
font-family: 'Roboto', sans-serif;
color: #848484;
font-size: 14px;
}
<?php
/*
Plugin Name: EDD Webhooks
Description: Captures new sale notifications from 3rd party service and adds to Easy Digital Downloads
Version: 1.0
Author: Brian Hogg
Author URI: https://brianhogg.com
Text Domain: edd-webhooks
License: GPL2
*/
@hiddenpearls
hiddenpearls / git archive
Last active June 1, 2017 09:56
Make a zip file to upload to theme repo
git archive --format zip --output /full/path/to/theme-name.zip master
@hiddenpearls
hiddenpearls / gist:aa911c6d6a78ca35081bfc27ea1d4c74
Last active May 4, 2017 05:43
ShortCode for World map of visitors in WordPress using Analytify Plugin
[analytify-worldmap start_date="2015-10-22" end_date="2015-10-28" analytics_for="full"]
//You can change the dates according to your needs. If you don't specify the end date It will take the current end date.
[analytify-worldmap start_date="2015-10-22" analytics_for="full"]
@hiddenpearls
hiddenpearls / purchase-phone.js
Created April 27, 2017 17:45
Simple JS program for buying a phone, Apply tax, format and add to cart.
const TAX_RATE = 0.10; // 10%
const PHONE_PRICE = 500; // $500
const ACCESSORY_PRICE = 12; //$12
const SPENDING_THRESHOLD = 900; // This should be 60% of the total bank balance.
var bank_account_balance = 0;
var quantity = 0;
var total = 0;
bank_account_balance = prompt("What is your Bank Account Balance");
@hiddenpearls
hiddenpearls / pe-customize-controls.css
Created February 13, 2017 21:16 — forked from OriginalEXE/pe-customize-controls.css
Extending WordPress Customizer Panels and Sections to allow nesting
.in-sub-panel #customize-theme-controls .customize-pane-child.current-panel-parent,
#customize-theme-controls .customize-pane-child.current-section-parent {
-webkit-transform: translateX(-100%);
-ms-transform: translateX(-100%);
transform: translateX(-100%);
}
.DS_Store
@hiddenpearls
hiddenpearls / snippet.js
Created October 4, 2016 19:01 — forked from necolas/snippet.js
Optimised async loading of cross-domain scripts
/*
* Updated to use the function-based method described in http://www.phpied.com/social-button-bffs/
* Better handling of scripts without supplied ids.
*
* N.B. Be sure to include Google Analytics's _gaq and Facebook's fbAsyncInit prior to this function.
*/
(function(doc, script) {
var js,
fjs = doc.getElementsByTagName(script)[0],