coccoinomane

/**
 * Allow dependent drop downs in Google Sheets
 *
 * - Allows any number of nested dropdown columns.
 * - Nested dropdowns can occur anywhere in the sheet.
 * - All options for the dropdowns live in a unique separate sheet
 * - Nesting works only for adjacent columns.
 * - Works also when editing a range of cells.
 *
 * Updated code at https://gist.github.com/0bf358bafc2b4d143a0e33dfb912020c

coccoinomane

<div style="font-family: sans-serif;">
<? var data = valid(); ?>
<form id="form" name="form">
<? if(Object.prototype.toString.call(data) === '[object Array]') { ?>
<? for (var i = 0; i < data.length; i++) { ?>
<? for (var j = 0; j < data[i].length; j++) { ?>
<input type="checkbox" id="ch<?= '' + i + j ?>" name="ch<?= '' + i + j ?>" value="<?= data[i][j] ?>"><?= data[i][j] ?><br>
<? } ?>
<? } ?>
<? } else { ?>

coccoinomane

 <script type="text/javascript">
   prepaiderr_1 = "{PREPAIDERR_01}";
   prepaiderr_2 = "{PREPAIDERR_02}";
   prepaiderr_3 = "{PREPAIDERR_03}";
</script>

<script type="text/javascript">
  var  voucher_or_normal  =  {OPTIONAL} ; // 0 - no optional, 1 is basic, 2 is voucher code, 3 is SMS
  var display_facebook_button = {DISPLAY_FACEBOOK_BUTTON} ; // 1 - visible, 0 hidden
  var display_google_button = {DISPLAY_GOOGLE_BUTTON}  ;// 1 - visible, 0 hidden

coccoinomane

/**
 * Make sure that Google Forms are stored in Google Spreadsheet
 * as plain text; among other things, this script solves the problem
 * whereby leading zeros are stripped from Google Form answers.
 *
 * This is a Google Script and it needs to be attached to a Google
 * Spreadsheet:
 * 1) Open the Google Spreadsheet linked to the Google Form, and
 *    go to Tools -> Script editor.
 * 2) Paste the content of this file in the editor and save.

coccoinomane

<?php
/**
 * Send an event to GA whenever a user is about to initiate payment.
 *
 * The event is fired not just after the user clicks on the "Place Order"
 * button, but when WooCommerce is actually going to redirect the user
 * to the Payment Gateway, using the woocommerce_checkout_order_processed
 * action.
 * 
 * Furthermore, additional information is passed with the event:

coccoinomane

<?php
/**
 * Return the client's IP address.
 *
 * Returns the IP address if found, an empty string if not. The
 * output is santized via FILTER_VALIDATE_IP.
 *
 * The algorithm uses the HTTP_CLIENT_IP and HTTP_X_FORWARDED_FOR
 * globals to infer the IP address; if they are not available (as
 * it is the case in most cases), it uses the REMOTE_ADDR global.

coccoinomane

<?php
/**
 * Print to screen and save to file the most important global PHP
 * variables: _POST, _GET, _SERVER, _FILES, _REQUEST.
 *
 * As an alternative, consider also the free service http://requestb.in/.
 *
 * Created by Guido W. Pettinari on 06/06/2016.
 * Latest version: https://gist.github.com/2eae82be7d5b4c35dbfd73fcf5c7eefb
 */

coccoinomane

/**
 * Subscribe user in MailUp upon form completion, using MailUp
 * HTTP API.
 *
 * To hook into the form submission we use button click rather than
 * actual submission, because the latter approach (using $('form').submit)
 * does not seem to work.
 *
 * The MailUp API specifications can be found here:
 * http://help.mailup.com/display/mailupapi/HTTP+API+Specifications

coccoinomane

<?php

/**
 * Disable all Dashboard Widgets.
 * 
 * Inspired by https://digwp.com/2014/02/disable-default-dashboard-widgets/.
 *
 * Created on 30/4/2016 by Guido W. Pettinari 
 * Latest version: https://gist.github.com/b10f4d0bf50b8f359b52d0bc50203650
 */

coccoinomane

<?php

/**
 * PHP script to find duplicates & unique entries among two
 * separate files.
 *
 * The script outputs one file with the matching lines and
 * one with the unique ones.
 *
 * Example: