peijiehu

SHOW events;

DROP EVENT delete_old_posts;

CREATE EVENT delete_old_posts
ON SCHEDULE EVERY 1 DAY STARTS '2016-10-28 08:00:00'
-- !!! no *END*: will continue until you explicitly drop the event
DO 
DELETE FROM article WHERE inserted_at < DATE_SUB(NOW(), INTERVAL 7 DAY);

rmehta

<?php
	
	// contributed by supplify.com
   	error_reporting(E_ALL);
	ini_set('display_errors', 1);
	require_once '../curl/Zebra_cURL.php';
	require_once '../app/Mage.php';
   	Mage::app();

	class action extends Zebra_cURL{

fotinakis

#!/bin/bash

# Have to redirect stderr to stdout here because slave.py uses stderr for output.
~/bin/slave.py list 2>&1 >/dev/null | grep beaker-slave- | while read slave; do
  echo
  echo "Checking status of $slave..."

  # First, check if we can SSH into the host. If we can, then check the process and maybe shut down.
  # This makes sure that we don't consider an SSH failure to be reason to shut down the node.
  if ssh $slave echo < /dev/null; then

sebsto

sudo wget http://repos.fedorapeople.org/repos/dchen/apache-maven/epel-apache-maven.repo -O /etc/yum.repos.d/epel-apache-maven.repo
sudo sed -i s/\$releasever/6/g /etc/yum.repos.d/epel-apache-maven.repo
sudo yum install -y apache-maven
mvn --version

kevin-smets

Default

Powerlevel10k

TemporaryJam

source: http://www.markbrilman.nl/2011/08/howto-convert-a-pfx-to-a-seperate-key-crt-file/

`openssl pkcs12 -in [yourfile.pfx] -nocerts -out [keyfile-encrypted.key]`

What this command does is extract the private key from the .pfx file. Once entered you need to type in the importpassword of the .pfx file.  This is the password that you used to protect your keypair when you created your .pfx file.  If you cannot remember it anymore you can just throw your .pfx file away, cause you won’t be able to import it again, anywhere!.  Once you entered the import password OpenSSL requests you to type in another password, twice!. This new password will protect your .key file.

Now let’s extract the certificate:

`openssl pkcs12 -in [yourfile.pfx] -clcerts -nokeys -out [certificate.crt]`

sindresorhus

#!/usr/bin/env bash
# MIT © Sindre Sorhus - sindresorhus.com

# git hook to run a command after `git pull` if a specified file was changed
# Run `chmod +x post-merge` to make it executable then put it into `.git/hooks/`.

changed_files="$(git diff-tree -r --name-only --no-commit-id ORIG_HEAD HEAD)"

check_run() {
	echo "$changed_files" | grep --quiet "$1" && eval "$2"

ilguzin

1. Convert our ".jks" file to ".p12" (PKCS12 key store format):
 
keytool -importkeystore -srckeystore oldkeystore.jks -destkeystore newkeystore.p12 -deststoretype PKCS12
 
1.1. List new keystore file contents:
 
keytool -deststoretype PKCS12 -keystore newkeystore.p12 -list
 
2. Extract pem (certificate) from ".p12" keysotre file: