heathdutton

# Command lines tools
xcode-select --install

# Install dependencies
brew install wget autoconf openssl libjpeg libpng lzlib curl imap-uw readline postgresql libxml2 mcrypt gettext libxslt homebrew/dupes/libiconv icu4c expat bison webp freetype

# Dirs
mkdir -p /Applications/MAMP/bin/php/php7.2.10/include
cd /Applications/MAMP/bin/php/php7.2.10/include

heathdutton

// Add sums to all chart labels in Mautic.
Mautic.chartLabelSum = function () {
    if (
        typeof Mautic.chartObjects !== 'undefined'
        && Mautic.chartObjects.length
    ) {
        var total, numeric, updated, totalStr;
        mQuery.each(Mautic.chartObjects, function (i, chart) {
            updated = false;
            if (

heathdutton

#!/usr/bin/env bash

# Prevent cron tasks from being ran by multiple instances in Elastic Beanstalk.
# Automatically adjusts to new "leading instance" when scaling up or down.
# Stores the result in an environment variable for other uses as AWS_EB_CRON
#
# This must be ran by cron as the root user to function correctly.
# Anything after this file will be executed as webapp for security.
#
# Example Cron (should be created by .ebextensions):

heathdutton

UPDATE lead_fields AS f
CROSS JOIN (
	SELECT @cnt := 0
) AS dummy
JOIN (
	SELECT (@cnt := @cnt + 1) AS cnt, id
	FROM lead_fields
	CROSS JOIN (SELECT @cnt := 0) AS dummy
	ORDER BY label ASC
) AS c

heathdutton

# Recommended cron tasks for Mautic 2 in Cloudways.
#   All tasks are ran as www-data
#   Output is ignored to avoid log file overhead.
#   --quiet is used to reduce MySQL overhead on some tasks.
#   --max-contacts is used to prevent one object's backlog from locking updates for other object.

# SEGMENTS
# Update all segments.
*/5 * * * * www-data php applications/mautic/public_html/app/console mautic:segments:update --max-contacts=10000 --quiet >/dev/null 2>&1 

heathdutton

<?php

/**
 * Class TimeZoneOptionCollection
 * 
 * Dynamic collection of supported PHP Timezones:
 * - Grouped by country
 * - Commonly used abbreviations
 * - DST indicators
 * - Future-proof (leans on PHP for timezones).

heathdutton

    {{ $var }} - Echo content
    {{ $var or 'default' }} - Echo content with a default value
    {{{ $var }}} - Echo escaped content
    {{-- Comment --}} - A Blade comment
    @extends('layout') - Extends a template with a layout
    @if(condition) - Starts an if block
    @else - Starts an else block
    @elseif(condition) - Start a elseif block
    @endif - Ends a if block

heathdutton

SELECT
  TABLE_SCHEMA,
  TABLE_NAME,
  COLUMN_NAME,
  DATA_TYPE,
  COLUMN_TYPE,
  IF(
    LOCATE('unsigned', COLUMN_TYPE) > 0,
    1,
    0

heathdutton

-- So this table hit the max-int value for the auto_increment column id.
-- Really, such columns should be unsigned so they can go up to 4 bil.

ALTER TABLE campaign_lead_event_failed_log DROP FOREIGN KEY `FK_E50614D2EA675D86`;
-- This took ~3 minutes.
ALTER TABLE campaign_lead_event_failed_log CHANGE log_id log_id INT(11) UNSIGNED NOT NULL;

-- The next table was too large to modify in place, was causing an outage, so we had to do a swap like so: 
CREATE TABLE campaign_lead_event_log_new LIKE campaign_lead_event_log;
ALTER TABLE campaign_lead_event_log_new CHANGE id id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT;

heathdutton

-- Find unused segments that can be unpublished to save processing time.
SELECT l.id, l.created_by_user, l.name, IF (l.date_modified IS NULL, l.date_added, l.date_modified) AS date_modified,
  (SELECT COUNT(*) FROM lead_lists_leads WHERE leadlist_id = l.id) AS lead_count
FROM lead_lists l
WHERE
  l.is_published = 1
  AND l.id NOT IN (
    -- Find segments in use.
    SELECT l.id
    FROM lead_lists l