vzool

name: Node CI

on:
  push:
    tags:
      - 'v*'

jobs:
  upload-release:

vzool

# Add Repository to your system (ondrej/php PPA)

sudo apt install apt-transport-https lsb-release ca-certificates
sudo wget -O /etc/apt/trusted.gpg.d/php.gpg https://packages.sury.org/php/apt.gpg
sudo sh -c 'echo "deb https://packages.sury.org/php/ $(lsb_release -sc) main" > /etc/apt/sources.list.d/php.list'
sudo apt update

# Install PHP 7.1
sudo apt install php7.1

vzool

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.

vzool

# Bitbucket Git Downloader
# Copyright (c) Davide Gironi, 2021
# Released under GPLv3

# Downloads all the repository from a Bitbucket account

vzool

-- Reasonably efficient pagination without OFFSET
-- SQLite version (Adapted from MS SQL syntax)
-- Source: http://www.phpbuilder.com/board/showpost.php?p=10376515&postcount=6

SELECT foo, bar, baz, quux FROM table
 WHERE oid NOT IN ( SELECT oid FROM table
                    ORDER BY title ASC LIMIT 50 )
 ORDER BY title ASC LIMIT 10

vzool

1. Generate a gpg key

With GnuPG 2.1.15

If you want to create an RSA or DSA key in a straight forward way use:

gpg --full-gen-key

If you want to use an ECC algorithm, you need to add the --expert flag

gpg --expert --full-gen-key

vzool

<?php

// Updated code from comments

function encode($value) {
    if (!$value) {
        return false;
    }

    $key = sha1('EnCRypT10nK#Y!RiSRNn');

vzool

if [ ! -f .env ]
then
  export $(cat .env | xargs)
fi

vzool

# dump
mysqldump -u user -p database --default-character-set=utf8mb4 --result-file=dump.sql

# restore
mysql -u user -p database --default-character-set=utf8mb4 < dump.sql

vzool

package main

import (
	"crypto/rand"
	"encoding/base64"
	"fmt"
	"io"
	"math/big"
)