patrickmaciel

"controller_mappings"
{
	"version"		"3"
	"title"		"GW2 Total Control by CoryOp v1"
	"description"		"#SettingsController_AutosaveDescription"
	"creator"		"76561198141443709"
	"controller_type"		"controller_steamcontroller_gordon"
	"group"
	{
		"id"		"0"

patrickmaciel

SET @outpath = "/var/lib/mysql-files/";
SET @outfile = (SELECT date_format(now(), '%Y%m%d%H%m%S'));
SET @outextension = "_products.csv";
SET @csvfinal = ' FIELDS TERMINATED BY \',\' ENCLOSED BY \'"\' LINES TERMINATED BY \'\n\'';

SELECT CONCAT("your query here INTO OUTFILE ",@outpath,@outfile,@outextension,@csvfinal) 
INTO @SQL; PREPARE stmt FROM @SQL;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

patrickmaciel

Lumen 5 HTTP Exception Handlers with JSON support.

Configure PHP Lumen 5 HTTP Exception Handlers with common JSON responses.

Setup

Copy (replace) only the attached files to their respective directories. app/Exceptions/Handler.php and app/Http/Middleware/Authenticate.php

patrickmaciel

alias fgf='cd ~/workspace/fgf/'
alias vi='nvim'
alias vimdiff='nvim -d'
alias gst='git status'
alias gca='git commit -a'
alias gaa='git add --all'
alias valias='nvim ~/.bash_aliases'
alias zalias='source ~/.bash_profile'
alias balias='nvim ~/.bash_profile'
alias zss='nvim ~/.zshrc'

patrickmaciel

<?php

function array_diff_assoc_recursive($array1, $array2) {
    $difference=array();
    foreach($array1 as $key => $value) {
        if( is_array($value) ) {
            if( !isset($array2[$key]) || !is_array($array2[$key]) ) {
                $difference[$key] = $value;
            } else {
                $new_diff = array_diff_assoc_recursive($value, $array2[$key]);

patrickmaciel

#!/bin/sh

# This command and the ppa and auto apt-get update after that
sudo env LC_ALL=C.UTF-8 add-apt-repository --yes ppa:ondrej/php 

# Install PHP 7.2 and the most common extesions
sudo apt-get install php7.4-fpm php7.4-common php7.4-dev php7.4-curl php7.4-gd php7.4-json php7.4-mysql php7.4-odbc php7.4-pgsql php7.4-pspell php7.4-readline php7.4-sqlite3 php7.4-tidy php7.4-xml php7.4-xmlrpc php7.4-bcmath php7.4-bz2 php7.4-intl php7.4-mbstring php7.4-phpdbg php7.4-soap php7.4-zip php-imagick php-redis php-memcached

patrickmaciel

Em andamento

composer global require phpunit/phpunit
composer global require phpunit/dbunit
composer global require phing/phing
composer global require phpdocumentor/phpdocumentor
composer global require sebastian/phpcpd
composer global require phploc/phploc
composer global require phpmd/phpmd

patrickmaciel

<?php 

// Se você quer converter uma data vinda do MYSQL para o formato PT-BR use o seguinte comando:

$data = implode("/",array_reverse(explode("-",$data)));

// Assim vai converter a data do mysql para o formato brasileiro.
// Ex: 2010-31-04 para 31/04/2010
// Se você quer converter uma data em formato brasileiro para inserir no mysql use:

patrickmaciel

alias gst="git status"
alias gcm="git commit -m"
alias gca="git commit -a"
alias gaa="git add --all"
alias cc="cd /c"
alias comdo="composer dump-autoload -o"
alias comda="composer dump-autoload"
alias vhosts="vim /c/Windows/System32/drivers/etc/hosts"
alias tinker="php artisan tinker"
alias arti="php artisan"

patrickmaciel

                    using (var context = new IABFLUIDAL.Context.IABModel())
                    {
                        using (DbContextTransaction tran = context.Database.BeginTransaction(IsolationLevel.ReadCommitted))
                        {
                            var conn = context.Database.Connection;
                            using (var command = conn.CreateCommand())
                            {
                                //command.CommandText = "flui.func_test_patrick";
                                //command.CommandType = CommandType.StoredProcedure;
                                //command.Parameters.Add(macaddress);