LiamKarlMitchell

// Scenario:
// Users enter name in all lowercase or all uppercase it fixes the case.
// This isn't 100% suitable for all names but eh whatever!
// Attempts to resepect intentional ' and " and intentional multiple case.

$.fn.capitalize = function() {
    $(this).blur(function(event) {
        var box = event.target;
        var txt = $(this).val();
    var lc = txt.toLocaleLowerCase();

LiamKarlMitchell

<?php
if ($this->dbType === 'mysql' || $this->dbType === 'mysqli') {
  $this->database->Execute("SET SESSION sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'");
}

// Either in the mysql config or if you don't want to touch it there you can edit the include/database/PearDatabase.php and put that statement at the bottom of the function connect.

// And for setup

// Edit the 

LiamKarlMitchell

You can change the mysql config to apply the set options.

sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

However this is not always desireable on shared hosting you don't know the follow on effects.

So far, I've found I can simply set this in the installer and the db connection class.

include/database/PearDatabase.php

LiamKarlMitchell

@echo off
cd /D "%~dp0"
title Your - Shell
set PATH="%~dp0Your\bin";%PATH%

REM Start powershell if available otherwise use cmd.
for %%i in (powershell.exe) do if "%%~$path:i"=="" (cmd) else start powershell -NoLogo -NoExit -Command "& { $env:Path = \"%PATH%\" }"

LiamKarlMitchell

<?php
namespace LiamKarlMitchell\File;
class JSONFile
{
  public $filename;
  private $data = array();
  
  public function __construct($filename, $defaults = array())
  {
    $this->filename = $filename;

LiamKarlMitchell

<?php

$instructions = array("container", "referenceContainer", "block", "referenceBlock");
foreach ($instructions as $instruction) {
  $containers = array();

  $fp = fopen('debug_'.$instruction.'.txt', 'w');
  
  $command = 'egrep -r -i --include \*.xml "<'.$instruction.'".*?"name=" *';
  exec($command, $output);

LiamKarlMitchell

Find log files modified in last 5 min.

find / -cmin -5 -type f -name "*.log"

For example I used this to find the Akeneo daemon log so I could tail it for debugging.

tail -100f /var/log/akeneo_daemon.err.log

LiamKarlMitchell

#!/bin/sh
cd /var/www/html
sudo su -s /bin/bash www-data

LiamKarlMitchell

<?php
// Note: Has problem with color spaces if input image is not sRGB some color info will be dropped. Loss of saturation/vibrance may be noticable.
function create_square_image($original_file, $destination_file=NULL, $square_size = 96){
	// get width and height of original image
	$imagedata = getimagesize($original_file);
	$original_width = $imagedata[0];	
	$original_height = $imagedata[1];
	
	if($original_width > $original_height){
		$new_height = $square_size;

LiamKarlMitchell

powercfg -lastwake

This will show you what last woke up your PC, in my case it was Windows Updates trying to schedule a restart.
I dont care about that but could not seem to disable it even though I am logged in as an Administrator user?!

Solution download pstools from Microsoft Sysinternals
Run a cmd prompt and disable the scheduled tasks

There is probably a better way to just disable the Wake from Lan option on the task but blah!