Skip to content

Instantly share code, notes, and snippets.

Remco Tolsma remcotolsma

Block or report user

Report or block remcotolsma

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View svg-test-ie11.html
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>SVG test on IE11</title>
<meta name="description" content="SVG test on IE11.">
<meta name="author" content="Pronamic">
@remcotolsma
remcotolsma / pronamic-pay-export-payments.sql
Last active Feb 3, 2020
Export completed Pronamic Pay payments.
View pronamic-pay-export-payments.sql
SELECT
post.ID,
post.post_title,
post.post_date,
post.post_status,
MAX( IF( meta.meta_key = "_pronamic_payment_description", meta.meta_value, NULL ) ) AS payment_description,
MAX( IF( meta.meta_key = "_pronamic_payment_amount", meta.meta_value, NULL ) ) AS payment_amount,
MAX( IF( meta.meta_key = '_pronamic_payment_currency', meta.meta_value, NULL ) ) AS payment_currency,
MAX( IF( meta.meta_key = '_pronamic_payment_config_id', meta.meta_value, NULL ) ) AS payment_config_id,
MAX( IF( meta.meta_key = '_pronamic_payment_status', meta.meta_value, NULL ) ) AS payment_status,
@remcotolsma
remcotolsma / functions.php
Last active Feb 7, 2020
Pronamic Pay Google Analytics ecommerce tracking item hit name Gravity Forms entry source URL (HelpScout ticket #19062)
View functions.php
<?php
/**
* Custom.
*/
\add_action(
'plugins_loaded',
function() {
/**
* Check for Gravity Forms API.
View geocode-providers.php
<?php
define( 'WP_USE_THEMES', false );
require './wp-blog-header.php';
$query = new WP_Query(
array(
'post_type' => 'provider',
'nopaging' => true,
@remcotolsma
remcotolsma / lookup-gf-entries-meta.sql
Created Nov 11, 2019
Query Gravity Forms entries of specific form and some extra meta values.
View lookup-gf-entries-meta.sql
SELECT
entry.id AS entry_id,
entry.date_created AS entry_created_on,
entry.form_id AS form_id,
form.title AS form_title,
user.display_name AS user_display_name,
emtry_meta_km.meta_value AS number_kilometers,
emtry_meta_office_id.meta_value AS office_id,
emtry_meta_date.meta_value AS period,
office.code AS office_code,
@remcotolsma
remcotolsma / functions.php
Created Oct 9, 2019
Update Gravity Forms currency EUR.
View functions.php
<?php
/**
* Update Gravity Forms currency EUR.
*
* @link https://www.pronamic.nl/2012/04/gravity-forms-euro-teken-voor-bedrag/
* @link https://docs.gravityforms.com/gform_currencies/#1-update-euro
*/
\add_filter(
'gform_currencies',
@remcotolsma
remcotolsma / test.php
Created Aug 29, 2019
Providers and slots GEO query WordPress.
View test.php
<?php
$providers_query = new WP_Query(
array(
'post_type' => 'provider',
'tax_query' => array(
array(
'taxonomy' => 'country',
'field' => 'slug',
'terms' => 'nl',
@remcotolsma
remcotolsma / index.php
Created Jul 31, 2019
Holiday Media widgets test WordPress
View index.php
<?php
define( 'WP_USE_THEMES', false );
require '../wp-blog-header.php';
/**
* Holiday Media.
*
* @link https://gitlab.com/pronamic-plugins/holiday-media-booking-widget/blob/develop/holiday-media-booking-widget.php
@remcotolsma
remcotolsma / rcp-update-2-to-3-fixer.php
Last active Jul 23, 2019
Restrict Content Pro update 2 to 3 fixer
View rcp-update-2-to-3-fixer.php
<?php
define( 'WP_USE_THEMES', false );
require '../../../../wp-blog-header.php';
global $wpdb;
$query = new WP_Query(
array(
View lookup-query-henk.sql
SELECT
t.*,
d.*
FROM
(
SELECT
`company_code`,
`company_name` as `CompanyName`,
`period_start_date` as `Begindatum`,
`period_end_date` as `Einddatum`,
You can’t perform that action at this time.