llagerlof’s gists

llagerlof / id_date_valid.php

Created August 12, 2019 19:00

One liner to identify a valid datetime "Y-m-d H:i:s" on PHP

	<?php
	/*
	This script can be used on terminal. Eg:
	$ php id_date_valid.php 2019-08-12 15:23:58
	*/

	$datetime = $argv[1] . ' ' . $argv[2];
	if ($datetime == date('Y-m-d H:i:s', strtotime ($datetime))) {
	echo "true";
	} else {

llagerlof / set_utf8.sh

Last active August 6, 2019 13:36 — forked from panchicore/bash

GIT error on push/pull: "remote: perl: warning: Setting locale failed" [SOLVED]

	#!/bin/bash

	# perl: warning: Setting locale failed.
	# perl: warning: Please check that your locale settings:
	# LANGUAGE = (unset),
	# LC_ALL = (unset),
	# LC_CTYPE = "UTF-8",
	# LANG = "en_US.UTF-8"
	# are supported and installed on your system.
	# perl: warning: Falling back to the standard locale ("C").

llagerlof / unistall_node_manually.txt

Created August 1, 2019 16:57

	Delete node and/or node_modules from /usr/local/lib
	Delete node and/or node_modules from /usr/local/include
	Delete node, node-debug, and node-gyp from /usr/local/bin
	Delete .npmrc from your home directory (these are your npm settings, don’t delete this if you plan on re-installing Node right away)
	Delete .npm from your home directory
	Delete .node-gyp from your home directory
	Delete .node_repl_history from your home directory
	Delete node* from /usr/local/share/man/man1/
	Delete npm* from /usr/local/share/man/man1/
	Delete node.d from /usr/local/lib/dtrace/

llagerlof / count_bytes.sh

Created June 28, 2019 17:50

Count bytes in files grouping by byte number

	#!/bin/bash
	# Thanks Stephen Kitt (https://unix.stackexchange.com/a/527524/273356)

	od -t x1 -w1 -v -An mybinaryfile \| sort \| uniq -c

llagerlof / identify_foreign_key_oracle.sql

Created April 4, 2019 14:08

Identify a Oracle constraint or foreign key rule by its name.

	/*
	USE REF_CONSTRAINT IF ITS A FOREIGN KEY.
	USE CONSTRAINT IF ITS ANOTHER TYPE OF CONSTRAINT.
	*/
	SELECT DBMS_METADATA.GET_DDL('REF_CONSTRAINT', 'FK_HUMAN_PLANET') FROM dual;

llagerlof / kill_oracle_connections_by_session.sql

Last active March 26, 2019 13:41

How to kill oracle connections by session

	SELECT * FROM V$SESSION WHERE SCHEMANAME = 'MYSCHEMA' AND MACHINE = 'applicationserver.localdomain' AND STATUS = 'INACTIVE';
	ALTER SYSTEM KILL SESSION '87,33311'; -- SID,SERIAL
	ALTER SYSTEM DISCONNECT SESSION '87,33311' IMMEDIATE;

llagerlof / generateCallTrace.php

Last active February 23, 2022 09:35

PHP function to generate a human readable call trace.

	<?php
	/**
	* generateCallTrace() function
	*
	* A function for getting a nice and comprehensible call trace.
	* It is probably more resource-intensive than some other alternatives but it is short,
	* understandable, and gives nice output (Exception->getTraceAsString()).
	*
	* @package generateCallTrace
	* @version 1.0

llagerlof / duplicate_mysql_database.sh

Created September 3, 2018 13:14

How to duplicate a entire MySQL database to another one in the same MySQL server

	# Use the -p flag if needed:
	mysqldump -u root db_with_data \| mysql -u root db_empty

	# If you have the error
	# "mysqldump: Got error: 1449: The user specified as a definer ('someuser'@'someaddress')
	# does not exist when using LOCK TABLES",
	# create the missing user:
	mysql> create user 'someuser'@'someaddress';

	# Run the dump:

llagerlof / CSS_insertRule_example.js

Created August 28, 2018 12:11

How to change CSS rules dinamically

	/*
	source: https://developer.mozilla.org/en-US/docs/Web/API/CSSStyleSheet/insertRule
	*/
	var styleElement = document.createElement('style');
	document.head.appendChild(styleElement);
	styleSheet = styleElement.sheet;
	styleSheet.insertRule("p, h1, h2, h3 {font-family: Courier New; color: blue;", 0);

llagerlof / PhabricatorAnnoyanceRemover.user.js

Last active February 8, 2025 18:18

Phabricator task edit's textarea height is auto adjusted to content. All comment entries that aren't true comments are removed from view. Task view and task edit font is set to Courier New.

	// ==UserScript==
	// @name Phabricator Annoyance Remover
	// @description Task view description and task edit description font is set to Courier New. The edit description height is auto adjusted to content. All comment entries that aren't true comments are removed from view.
	// @namespace https://github.com/llagerlof/
	// @author 2018, Lawrence Lagerlof (https://github.com/llagerlof)
	// @license MIT
	// @include /https?:\/\/.*\/maniphest\/task\/edit\//
	// @include /https?:\/\/.*\/T[0-9]+(?:#([0-9]+))?$/
	// @require https://cdnjs.cloudflare.com/ajax/libs/autosize.js/4.0.2/autosize.min.js
	// @version 1.3

Lawrence llagerlof