Geeks Like Shiny Things

Pop-Up Book from HELL.

2020-11-15T22:32:00.002-08:00

One of the best responses to being startled.

Gun Ownership

2018-10-17T09:43:00.001-07:00

Gun Ownership In 2018

I own guns. I like shooting guns. My alarm system and video surveillance makes me feel safe, guns are safely tucked away. What are the numbers on guns in the US that makes some people nervous about people owning guns!?

These articles are just simple facts about ownership in US and each state.

42% of all americans surveyed own a gun or more.
Texas has almost double registered weapons than any other state.
"The US tops the list of countries with the most guns, owning about half the world’s guns while making up only 5% of the world population"

Disturbing articles about mass quantities of guns

Now these articles could make me nervous.

Three percent of the population own half of the civilian guns in the US
47 guns with LOADED high-capacity clips

Why do 3% of all US citizens own 1/2 the guns? Do they really need to? Should there be a limit to stockpiling arms? Maybe a sanity test? LOL.

How about mass shootings? That article shows that there had 154 shootings before the end of June this year (2018). What can be done to prevent this? I don't think there is truly a way. Registration does not seem to matter. Anyone can pass a psych test if they really wanted to research it and try and those are probably the ones to worry about!

What do you think?

FYI: this post sparked my inquiry.

Try it little girl😏

Javascript shortcuts using chrome search engine feature.

2018-10-05T06:30:00.000-07:00

Just add this as the URL for a search engine ... javascript:jQuery(".diff-file.file-holder").has("strong.file-title-name[data-original-title~='deleted']").toggle();

Use a search engine keyword shortcut to execute javascript on a page… in this case it will toggle visibility of all the deleted files in a gitlab merge request

Just type gtd in the address bar and select the search engine and it will execute that javascript on the current page.

SQL Server: cannot drop database because currently its in use

2018-07-18T17:54:00.000-07:00

cannot drop database because currently its in use

SQL Server 2005 Standard Edition
SQL Server 2008 Standard Edition
SQL Server 2012 Standard Edition
.... maybe others?

The big-hammer approach is...

use master;

alter database my_app

set single_user with rollback immediate;

drop database my_app;

use master;

alter database Website

set single_user with rollback immediate;

drop database Website;

use master;

alter database tempdb

set single_user with rollback immediate;

drop database tempdb;

You may try this example which take the database to Single_user immediately and drop it

Composer Packages: Revive AdServer XML API

2018-05-02T06:56:00.000-07:00

Artistan/Revive-XmlRpc Artistan@github

remote procedure calls - RPC - is a basic API that has existed on Revive since it was OpenX Source. This is a basic update to that system and extracted into a package which can be used in virtually any Php Project to access your Revive server or manage multiple Revive servers. The response data is not exactly pretty for Ads Display, but hopefully I can come up with a version 3 that format the data into a more friendly format.

Revive AdServer xml api

extracted into a package and updated to use packages rather than pear

requires

php-xml
phpxmlrpc/phpxmlrpc
carbondate/carbon

examples

these examples were testing in Laravel 5.6 Commands

composer

    "require": {
        "artistan/revive-xmlrpc": "*"
    }

Version 2 xml


use Artistan\ReviveXmlRpc\OpenAdsV2ApiXmlRpc;
$rpc = new OpenAdsV2ApiXmlRpc('ads.me.com', '/www/api/v2/xmlrpc/', 'admin', '~test~', 0, true, 15);
$list = $rpc->getAgencyList();

Version 1 xml


use Artistan\ReviveXmlRpc\OpenAdsV1ApiXmlRpc;
$rpc = new OpenAdsV1ApiXmlRpc('ads.me.com', '/www/api/v1/xmlrpc/', 'admin', '~test~', 0, true, 15);
$list = $rpc->getAgencyList();

Ad Display Retrieval xml


        $rpc = new OpenAdsDisplayXmlRpc('ads.energybin.com', '/www/delivery/axmlrpc.php', 443, true, 15);
        $rpc->setRemoteInfo('remote_addr', 'chuck-dev');
        $list = $rpc->view('zone:1', 0, '', '', 0, [], '');
        var_dump(json_decode(json_encode($list),true));

Sources:
Revive Forum

New Helper Function...

2017-10-19T14:11:00.001-07:00

Maybe you can tell that I am not a fan of helper functions :)


	if (! function_exists('💩')) {
	/**
	* Get the available laravel container instance.
	*
	* @param string $abstract
	* @param array $parameters
	* @return mixed\|\Illuminate\Foundation\Application
	*/
	function 💩($abstract = null, array $parameters = [])
	{
	return app($abstract,$parameters);
	}
	}

Why do we need all these helpers when there is a valid/verbose/intuitive framework to use.

Respecting the flag

2017-09-29T22:40:00.007-07:00

It's not about respecting the flag,but respecting ALL the people under that flag.

MacBook - Rear View Mirror

2017-09-05T06:49:00.001-07:00

How to Turn on a MacBook Camera

by Chad Anderson

The built-in iSight camera in the Apple MacBook line does not have an on and off switch. Instead, it is activated by software requesting camera input. If a piece of software is not up to date, the application may not be able to turn on the built-in webcam. Test that your webcam turns on and off properly by using the Photo Booth application. (rear view mirror)

Click the "Finder" button in your MacBook's desktop application bar.

Click the "Applications" folder on the left side of the dialog.

Scroll down to the "Photo Booth" icon, then double-click the icon to launch the program.

Wait until the green LED lights up next to the camera. Your built-in iSight camera is now on.

Tip

checkIf your MacBook's built-in iSight camera does not turn on automatically when entering Photo Booth, then you may be experiencing a hardware issue and should take your MacBook to a certified technician or Apple store.

MySQL: mysqldump, compress, to remote server, and import on remote server

2017-08-31T09:08:00.002-07:00

Here is what I do for a quick dump via mysqldump, syncing the data to another remote server with compression, decompressing it on the other side and importing the data into mysql ... assuming that you have setup an ssh key between the 2 servers

create file dump-to-server.sh
chmod to executable (chmod 0755 dump-to-server.sh)
run your sync ./dump-to-server.sh schema_name root@remote.server.net

dump-to-server.sh

\#!/bin/bash

if [[ -z "$1" || -z "$2" ]]; then
  echo "--------- usage ---------";
  echo "./dump-to-server.sh schema_name root@remote.server.net";
  echo "";
else
  mysqldump --opt "$1" | gzip -c | ssh "$2" "gunzip -c | mysql $1"
fi

mysqldump --opt "$1"

this will dump the existing database schema ($1 parameter)

gzip -c

compress the dump on the fly

ssh "$2"

ssh into your remote server ($2)

gunzip -c

decompress the stream

mysql $1

insert the resulting sql stream directly into the remote schema ($1)

Adminer.php for Laravel v2.0.1 released.

2017-07-28T04:57:00.000-07:00

adminer-for-laravel 5.*

Adminer is a full-featured database management tool written in PHP. This package automates setup for adminer and routes your.domain.here/adminer to the the adminer.php script.

Installation

Composer

composer require leung/laravel-adminer

Add directly to your `composer.json`

"require": {
    "leung/laravel-adminer": "^1.1"
},

Providers

Laravel <5.4

open your config/app.php and add this line in providers section

Simple\Adminer\AdminerServiceProvider::class

adminer-for-laravel 5.*

Adminer is a full-featured database management tool written in PHP. This package automates setup for adminer and routes your.domain.here/adminer to the the adminer.php script.

Installation

Composer

composer require leung/laravel-adminer

Add directly to your `composer.json`

"require": {
    "leung/laravel-adminer": "^2.0"
},

Providers

Laravel <5.4

open your config/app.php and add this line in providers section

Simple\Adminer\AdminerServiceProvider::class

OR prevent it being on production

open your app/Providers/AppServiceProvider.php and add this line in the register() function

if ($this->app->environment() !== 'production') {
    $this->app->register(\Simple\Adminer\AdminerServiceProvider::class);
}

Laravel 5.5 providers

auto included via automatic package discovery

   // no need to add anything!!!

Update adminer.php

Command line update

php artisan adminer:update

Composer update also automates running this script

[Optional] Middleware

Middleware is added in via the service provider

to override this you may add a adminer route to your App routes.php

    Route::any('adminer', '\Simple\Adminer\AdminerController@index')->middleware('adminer_custom_middleware'); // where you defined your middleware in app/Http/Kernel.php

Add middleware group example

to add a custom middleware group you will need to add it to middlewareGroups in your app/Http/Kernel.php

protected $middlewareGroups = [
    ...
    'adminer_custom_middleware' => [
        \App\Http\Middleware\EncryptCookies::class,
        \Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse::class,
        \Illuminate\Session\Middleware\StartSession::class,

        // you may create customized middleware to fit your needs
        ...
    ],
];

Modify app/Http/Middleware/VerifyCsrfToken.php

also add adminer to $except array if you are using the example optional adminer group

protected $except = [
     'adminer'
 ];

Interactively remove git commit from history of repo.

2017-07-25T09:57:00.005-07:00

Thanks to 1800 INFORMATION for an old, but good answer to the question

Key Points

Interactive mode for git rebase ... -i
select the commit hash for the one you want to remove ... <commit>
go back one commit and rebase from there ... ~1
Editor will be displayed with a list of commits including the offending one
Delete ( vim shortcut dd ) the lines for the commits you want to purge
Save ( vim :wq Enter )
Rebase will do the work
IF you already pushed to your remote, you will need to do a `git push --force`

this will update the history on your remote repository to match your updates

Cheers!

QUOTE / https://stackoverflow.com/a/1338756/372215

Another possibility is one of my personal favorite commands:

git rebase -i <commit>~1

This will start the rebase in interactive mode -i at the point just before the commit you want to whack. The editor will start up listing all of the commits since then. Delete the line containing the commit you want to obliterate and save the file. Rebase will do the rest of the work, deleting only that commit, and replaying all of the others back into the log.

/END QUOTE

Middleware Group Exists

2017-07-23T17:30:00.004-07:00

This took me awhile to find, so it thought I would post it for future use.

Middleware group definitions that are defined in the Kernel [app/Http/Kernel.php] but they end up in the router for Laravel 5.4 (\Route::hasMiddlewareGroup('adminer') [vendor/laravel/framework/src/Illuminate/Routing/Router.php]. This is where you can check the groups to see if one exists and optionally use it in your controller.

How else can I put this, so people will find what they need?

middleware group exists
check if middleware group is defined
check if the app hasMiddlewareGroup
stop Reflection Exception when middleware group does not exist

Example of the Controller OPTIONALLY using a middleware definition.

namespace Simple\Adminer\Controllers;

use Illuminate\Routing\Controller;

class AdminerController extends Controller
{
    public function __construct()
    {
        if(\Route::hasMiddlewareGroup('adminer')){
            $this->middleware('adminer');
        }
     // AdminerServiceProvider::register holds the middleware register so it does not need addeed manually.
    }

    public function index()
    {
        require(__DIR__.'/../resources/adminer-4.3.0-en.php');
    }
}

add middleware Example

protected $middlewareGroups = [
    ...
    'adminer' => [
        \App\Http\Middleware\EncryptCookies::class,
        \Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse::class,
        \Illuminate\Session\Middleware\StartSession::class,

        // you may create customized middleware to fit your needs
        ...
    ],
];

How to upgrade to PHP 7.1 on Ubuntu

2017-07-20T04:46:00.001-07:00

How to upgrade to PHP 7.1 on Ubuntu

Thursday, 2017-07-20

Ubuntu can easily be updates with PHP 7.1 now. I found an old how to install php7.1 with package updates, now that is not needed! Here is how to upgrade today.

1. List your current PHP packages

Your current PHP core and extensions should be installed in the php7.0-FOOBAR form as of now. Most of the extensions are already available in the PPA above, but make sure that you have all the packages in their PHP7-1 version as well.

dpkg -l | grep php | tee php.txt

Above command will list all the PHP packages you already have. Some of the packages are installed alongside php7.0-common. We are also saving the list to a text file packages.txt just in case.

copy these for the apt-get install in step 4

3. Install PHP 7.1

Depending on how you use PHP with the web server, you will probably need to turn the web server off. After that, run the following:

sudo apt-get install php7.1 php7.1-common

4. Install PHP 7.1 dependancies

This should install the basic packages on your system.
Now, make sure to install the additional packages as you need them. In my case, I also installed these packages with apt-get command.

sudo apt-get install php7.1-curl php7.1-xml ... {php.txt}

5. Test if PHP version is indeed 7.1

if everything went well, you should see the PHP 7.1 in the following command output.

php -v

6. OPTIONAL - Remove old 7.0 packages !! IF !! you do not need them for another virtual hosted site.

If everything works great, you can remove the old packages now.

sudo apt-get purge php7.0 php7.0-common

This should remove the base package and all the extensions too.

7. Update Nginx to 7.1 packages.

Find the references to php7.0

sudo grep -r php7 /etc/nginx

Update them to php7.0...

Here is an example line from my grep after updating to php7.1

/etc/nginx/sites-available/staging:  fastcgi_pass unix:/var/run/php/php7.1-fpm.sock

You may want to leave some of them as php7.0!!

Do not forget to restart the nginx service

sudo service nginx restart



Hope this helps!

PhpStorm Remote Xdebug

2017-07-13T10:05:00.000-07:00

Just do you get the Gist...

This is a remote xDebug configuration hint... it is not a guide or help or feedback. :)

homestead box - remote xdebug

Laravel and PhpStorm needed proper inheritance hinting

2017-07-13T07:36:00.000-07:00

Thanks again to Taylor Otwell for quick response to a needed update for Laravel 5.4 to work properly with PhpStorm ide helpers.

Eloquent\Builder does this already

/**
 * @mixin \Illuminate\Database\Eloquent\Query
 * @mixin \Illuminate\Database\Query\Builder
 */

So adding it to the Model and Relations it is consistent with existing mixins (plus one)

Here are some other additions to help with hinting!!

Here is an example of a Repository Pattern which would use this.

/**
 * @mixin \Illuminate\Database\Eloquent\Model
 */
abstract class EloquentAbstractRepository
{
 /**
  * @var \Illuminate\Database\Eloquent\Model
  */
    protected $model;

    /**
     * Make a new instance of the entity to query on
     *
     * @param array $with
     * @return \Illuminate\Database\Eloquent\Model
     */
    public function make(array $with = array())
    {
        return $this->model->with($with);
    }

    /**
     * Find an entity by id
     *
     * @param $id
     * @param array $with
     * @return Model
     */
    public function getById($id, array $with = array())
    {
        $query = $this->make($with);

        return $query->find($id);
    }

    /**
     * Find a single entity by key value
     *
     * @param string $key
     * @param string $value
     * @param array $with
     *
     * @return mixed
     */
    public function getFirstBy($key, $value, array $with = array())
    {
        return $this->make($with)->where($key, '=', $value)->first();
    }

 /**
  * Handle dynamic method calls into the model.
  *
  * @param  string  $method
  * @param  array  $parameters
  * @return mixed
  */
 public function __call($method, $parameters)
 {
  return $this->model->$method(...$parameters);
 }

}

which can be used with proper inheritance


class EloquentReservationRepository extends EloquentAbstractRepository
{
    protected $model;
    protected $placeRepo;
    protected $carbon;

    /**
     * Create a new reservation eloquent model
     *
     * @param Reservation $model
     * @param placeRepository $placeRepo
     * @param Carbon $carbon
     */
    public function __construct(
        Reservation $model,
        placeRepository $placeRepo,
        Carbon $carbon
    )
    {
        $this->model                = $model;
        $this->placeRepo        = $placeRepo;
        $this->carbon              = $carbon;
    }

 /**
  * Validate provided reservation token
  *
  * @param $reservation
  * @param $token
  * @return bool
  */
 public function validateReservationToken($reservation, $token)
 {
  if (!($reservation instanceof Reservation)) {
   try {
    $reservation = $this->findOrFail($reservation);
   } catch (\Exception $e) {
    abort($e->getCode(), $e->getMessage());

    return false;
   }
  }

  return $this->getReservationToken($reservation->id) === $token;
 }

}

and we can have the repo calls to the model method be properly recognized.

        // get reservation object
        try {
            $reservation = $this->reservation_repo->findOrFail($form_data['reservation_id']);
        } catch (\Exception $e) {
            return response()->json(['error' => $e->getMessage()]);
        }

Custom Chunk Sizes in Laravel Scout

2017-07-12T10:55:00.000-07:00

For those who want to know.

You may now update your config (not env, that was removed) to allow for custom global chunk sizes for Laravel/Scout. Thank for the quick update @taylorotwell !!

    /*
    |--------------------------------------------------------------------------
    | Chuck Sizes
    |--------------------------------------------------------------------------
    |
    | These options allow you to control the maximum chunk size when you are
    | mass importing data into the search engine. This allows you to fine
    | tune these chunk sizes based on the capabilites of your machines.
    |
    */

    'chunk' => [
        'searchable' => 500,
        'unsearchable' => 500,
    ],

Taylor Otwell to this a step further and also updated to make individual models customizable.

Love this update, it is a great addition to the config you accepted from me...
For those who just want to know what it does... We can now customize the chunk size for making a model searchable PER MODEL... Add this to your model.

    const CUSTOM_CHUNK_SIZE=200;

    /**
     * Make all instances of the model searchable.
     *
     * @return void
     */
    public static function makeAllSearchable()
    {
        $self = new static();

        $self->newQuery()
            ->orderBy($self->getKeyName())
            ->searchable( self::CUSTOM_CHUNK_SIZE );
    }

All of this is available now! Laravel/Scout v3.0.6

PhpStorm (JetBrains) is SHINY!! for merging updates

2017-07-11T21:00:00.002-07:00

So, I LOVE the wizard involved with merging git pull requests in PhpStorm 2017.1 which is one of many of the things that PhpStorm does well, like managing git branches.

Open Preferences, [ ⌘, ]

Search for "pull"

Find the Keymap for Pull

Double Click the Pull Option

Click on "Add Keyboard Shortcut"

Select your shortcut ... like F10

!!!! YAY !!!!

Now you can hit "F10" and the Verbose version of Pull Changes pops up...

This allows you to select a REMOTE repository

AND a REMOTE branch to merge into your local repository.

Why do this?

BECAUSE the Merge Revisions
is so easy and intuitive to use!

Laravel 5.4 .env files — how they autoload

2017-05-09T08:20:00.002-07:00

Laravel 5.4 .env files — how they autoload

up vote down vote favorite

Laravel 5.4 .env files How do I load the .env.production file vs .env.dev file or the base .env file?

down vote accept

In my vagrant box I had ...

    setenv:
        - 'APP_ENV dev'

After creating a .env.dev , I noticed it was not loading that file!

WHY? HOW!?

Well, the bootstrap is auto detecting the app environment from the servers APP_ENV environment variable which can be set on the server or virtual host level of your server.

https://laravel.com/docs/5.4/configuration#environment-configuration

The code that does it... vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/LoadEnvironmentVariables.php

/**
 * Detect if a custom environment file matching the APP_ENV exists.
 *
 * @param  \Illuminate\Contracts\Foundation\Application  $app
 * @return void
 */
protected function checkForSpecificEnvironmentFile($app)
{
    if (php_sapi_name() == 'cli' && with($input = new ArgvInput)->hasParameterOption('--env')) {
        $this->setEnvironmentFilePath(
            $app, $app->environmentFile().'.'.$input->getParameterOption('--env')
        );
    }

    if (! env('APP_ENV')) {
        return;
    }

    // this will load the .env.{APP_ENV} file
    $this->setEnvironmentFilePath(
        $app, $app->environmentFile().'.'.env('APP_ENV')
    );
}

xdebug with phpstorm and puphpet vagrant box

2016-12-12T09:20:00.000-08:00

Xdebug is useful in many ways. debugging, profiling, error reporting.

I have linked to many of these articles throughout this post.

This one, is likely the most helpful for puphpet (vagrant box), php, and xdebug.

Assuming you have already used that article to setup puphpet with phpstorm, this is how you can add profiling... (could add these configs to your puphpet box also!)

Configure your php.ini for xdebug with remote handling and profiling.

 /etc/php.d/99-xdebug.ini

 [XDEBUG]
 xdebug.default_enable=1
 xdebug.remote_connect_back=1
 xdebug.remote_enable=1
 xdebug.remote_handler=dbgp
 xdebug.remote_port=9000
 xdebug.remote_autostart=1
 ;xdebug.profiler_enable=1 ; uncomment for always enabled
 xdebug.profiler_output_dir=/var/www/vhosts/xdebug ; where to store output
 xdebug.profiler_enable_trigger=1 ; allow cookie/get/post to enable.
 ;XDEBUG_PROFILE cookie or GET/POST == 1

Add XDEBUG_PROFILE to your cookies or GET/POST

http://mytest.net/?XDEBUG_PROFILE=1

OR
https://www.jetbrains.com/phpstorm/marklets/ -- add bookmarks to your browser to make it easier!

Find your output

in xdebug.profiler_output_dir (directory)

file names are like "cachegrind.out.%d" where %d is unique per logged profile

Open with Phpstorm

Then select your file...

and you will end up with a profile that allows deep analysis of your script execution

Older article which may provide some more insight.

For LARGE cachegrind files... use qcachegrind

session_regenerate_id causing fatal error in Php 7

2016-12-05T11:04:00.000-08:00

While upgrading to Php 7, our code had an issue with session_regenerate_id().

Catchable fatal error: session_regenerate_id(): Failed to create(read) session ID: user (path: /var/lib/php/session)

Thanks to bellosthomas, I was able to determine that our DB_Sessions class was causing the issue. It was a simple fix of FORCING the return values to be strings. I have marked the code and comments with BOLD and UNDERLINED text so you can see the strings. Just make sure that your "sess_read" method is returning a string!

https://bugs.php.net/bug.php?id=70871

[2015-11-13 05:23 UTC] bellosthomas at gmail dot com

I was also getting a fatal error (check comment above), with a custom session handler. After yohgaki's comment about the return value of the read() method, which needs to return a string, I checked my session handler and I saw I was returning boolean false in some cases. Casting the return value to string, solved it.

https://gist.github.com/Artistan/0838c95d46ffad965570afa0ec354091
<?php

/**
 * Initial Setup of file
 * Garbage collection sucks, we should have a time check during read and auto destroy/not recover old sessions
 */
class DB_Sessions
{
 var $session_life = 300;
 var $sessiontable = 'sessions';
 var $recordtable = 'sessions_loginrecord';
 /**
  * @var DB_Wrapper
  */
 var $dbhost;
 var $sessionhash;
 var $write_callback;
 var $memcache;

 function __construct(&$dbhost)
 {
  $this->dbhost =& $dbhost;
  ini_set('session.save_handler', 'user');
  session_set_save_handler(
   array($this, 'sess_open'),
   array($this, 'sess_close'),
   array($this, 'sess_read'),
   array($this, 'sess_write'),
   array($this, 'sess_destroy'),
   array($this, 'sess_gc')
  );

  if(function_exists('memcache_pconnect')) {
   $this->memcache = @memcache_pconnect($_SERVER['MEMCACHE_SERVER'], $_SERVER['MEMCACHE_PORT']);
  }
 }

 /**************************************
  * sess_open
  ***************************************
  * Notes:
  ***************************************
  * Used In
  ***************************************
  * @author Richard Thomas
  *
  * @param $save_path    STRING
  * @param $session_name STRING
  *
  * @return BOOL
  */
 function sess_open($save_path, $session_name)
 {
  return true;
 }

 /**************************************
  * sess_close
  ***************************************
  * Notes:
  ***************************************
  * Used In
  ***************************************
  * @author Richard Thomas
  * @return BOOL
  */
 function sess_close()
 {
  return true;
 }

 /**************************************
  * sess_read
  ***************************************
  * Notes:
  ***************************************
  * Used In
  ***************************************
  * @author Richard Thomas
  *
  * @param $key STRING
  *
  * @return BOOL
  */
 function sess_read($key)
 {
  if (!is_object($this->memcache) OR (!$value = $this->memcache->get('sess_key_' . $key)))
  {
   $qry = "SELECT `value` FROM " . $this->sessiontable . " WHERE `sesskey` = '$key'";
   $qid = $this->dbhost->query($qry);
   if (list($value) = $qid->fetch_row())
   {
    $this->sessionhash = md5($value);
    if (is_object($this->memcache) AND $value)
    {
     $this->memcache->set('sess_key_' . $key, $value, COMPRESS_CACHE);
    }

    return (String) $value;
   }
  }
  else
  {
   $this->sessionhash = md5($value);

   return (String) $value;
  }

  return '';
 }

 /**************************************
  * sess_write
  ***************************************
  * Notes:
  ***************************************
  * Used In
  ***************************************
  * @author Richard Thomas
  *
  * @param $key STRING
  * @param $val STRING
  *
  * @return BOOL
  */
 function sess_write($key, $val)
 {
  $expiry = time() + $this->session_life;
  $value  = addslashes($val);
  if (md5($val) == $this->sessionhash)
  {
   $qry = "UPDATE " . $this->sessiontable . " SET expiry = $expiry, userkey = '" . @$_SESSION['login'] . "' WHERE sesskey = '$key'";
  }
  else
  {
   if (is_object($this->memcache))
   {
    $this->memcache->delete('sess_key_' . $key);
   }
   $qry = "UPDATE " . $this->sessiontable . " SET expiry = $expiry, value = '$value', userkey = '" . @$_SESSION['login'] . "' WHERE sesskey = '$key'";
   if ($this->write_callback)
   {
    call_user_func($this->write_callback, $val);
   }
  }
  $qid = $this->dbhost->query($qry);
  if (!$this->dbhost->affected_rows())
  {
   if (!empty($_SERVER['REMOTE_ADDR']))
   {
    $qry = "INSERT INTO " . $this->sessiontable . " VALUES ('$key', $expiry, '$value','" . @$_SESSION['login'] . "','$expiry','" . $_SERVER['REMOTE_ADDR'] . "','" . $_SERVER['HTTP_HOST'] . "')";
   }
   else
   {
    $qry = "INSERT INTO " . $this->sessiontable . " VALUES ('$key', $expiry, '$value','" . @$_SESSION['login'] . "','$expiry','\"\"','" . $_SERVER['HTTP_HOST'] . "')";
   }
   $qid = $this->dbhost->query($qry);
  }

  return $qid;
 }

 /**************************************
  * sess_destroy
  ***************************************
  * Notes:
  ***************************************
  * Used In
  ***************************************
  * @author Richard Thomas
  *
  * @param $key STRING
  *
  * @return BOOL
  */
 function sess_destroy($key)
 {
  $temp = time();
  if (is_object($this->memcache))
  {
   $this->memcache->delete('sess_key_' . $key);
  }
  $qry     = "SELECT userkey,started,ip,host FROM " . $this->sessiontable . " WHERE sesskey = '$key'";
  $qid     = $this->dbhost->query($qry);
  $row     = $qid->fetch_assoc();
  $userkey = $row['userkey'];
  $started = $row['started'];
  $ip      = $row['ip'];
  $host    = $row['host'];
  if ($userkey <> "" AND $this->recordtable)
  {
   $qry = "INSERT INTO " . $this->recordtable . " VALUES ('$userkey','$started','$temp','$ip','$host')";
   $qid = $this->dbhost->query($qry);
  }
  $qry = "DELETE FROM " . $this->sessiontable . " WHERE sesskey = '$key'";
  $qid = $this->dbhost->query($qry);

  return $qid;
 }

 /**************************************
  * sess_gc
  ***************************************
  * Notes:
  ***************************************
  * Used In
  ***************************************
  * @author Richard Thomas
  *
  * @param $maxlifetime INT
  *
  * @return BOOL
  */
 function sess_gc($maxlifetime)
 {
  $temp   = time();
  $qry    = "SELECT sesskey FROM " . $this->sessiontable . " WHERE expiry < " . $temp;
  $result = $this->dbhost->query($qry);
  for ($i = 0; $i < $result->num_rows(); $i++)
  {
   $row = $result->fetch_assoc();
   $key = $row['sesskey'];
   if (is_object($this->memcache))
   {
    $this->memcache->delete('sess_key_' . $key);
   }
   $qry = "SELECT userkey,started,ip,host FROM " . $this->sessiontable . " WHERE sesskey = '$key'";
   $qid = $this->dbhost->query($qry);
   if ($qid)
   {
    $row     = $qid->fetch_assoc();
    $userkey = $row['userkey'];
    $started = $row['started'];
    $ip      = $row['ip'];
    $host    = $row['host'];
    if ($userkey <> "" AND $this->recordtable)
    {
     $qry = "INSERT INTO " . $this->recordtable . " VALUES ('$userkey','$started','$temp','$ip','$host')";
     $qid = $this->dbhost->query($qry);
    }
   }
  }
  $qry = "DELETE FROM " . $this->sessiontable . " WHERE expiry < " . $temp;
  $qid = $this->dbhost->query($qry);

  return $this->dbhost->affected_rows();
 }

 /**************************************
  * sess_isonline
  ***************************************
  * Notes:
  ***************************************
  * Used In
  ***************************************
  * @author Richard Thomas
  *
  * @param $login STRING
  *
  * @return BOOL
  */
 function session_isonline($login)
 {
  $temp   = time();
  $query  = "SELECT userkey FROM " . $this->sessiontable . " WHERE userkey = '$login' AND expiry > $temp";
  $result = $this->dbhost->query($query);

  return $result->num_rows();
 }

}

define: mah. the ultimate lack of interest

2016-11-15T18:12:00.001-08:00

"mah.", I say.

I am so ultimately lacking in interest, meh is too strong of a word.

Google defines meh as...

expressing a lack of interest of enthusiasm.

mah

/ma/

informal

exclamation

expressing an utter lack of interest or enthusiasm.

"Mah. I have NO interest"

adjective

unworthy, unaccepting

"all of his movies are .. mah"

Handle PHP reconnect

2016-10-25T22:25:00.002-07:00

Handle PHP reconnect when getting the 2006 error code from MySQL

<?php

class reconnectPDO extends PDO
{
 var $connection_array = [];
 var $reconnect_limit = 5;
 var $reconnect_time = 1;
 var $reconnect_counter = 0;

 public function __construct($dsn, $username, $passwd, $options)
 {
  $this->connection_array = [
   'd' => $dsn,
   'u' => $username,
   'p' => $passwd,
   'o' => $options
  ];
  $this->connect();
 }

 public function connect()
 {
  echo "connecting\n";
  $c =& $this->connection_array;
  parent::__construct($c['d'], $c['u'], $c['p'], $c['o']);
  try
  {
   $this->setAttribute(PDO::ATTR_STATEMENT_CLASS, array('reconnectPDOStatement', array($this)));
   $this->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  }
  catch (PDOException $e)
  {
   die($e->getMessage());
  }
 }

 public function run_reconnect($function, $param)
 {
  echo "run_reconnect {$this->reconnect_counter}\n";
  $return = false;
  do
  {
   $reconnect = false;
   try
   {
    $return = parent::$function($param);
   }
   catch (Exception $e)
   {
    if ($e->getCode() == 2006)
    {
     $this->reconnect_counter++;
     if ($this->reconnect_counter < $this->reconnect_limit)
     {
      sleep($this->reconnect_time);
      $reconnect = true;
     }
    }
   }
  } while ($reconnect == true);

  return $return;
 }

 public function query($query, $reconnect = true)
 {
  if ($reconnect)
  {
   $result = $this->run_reconnect('query', $query);
  }
  else
  {
   $result = parent::query($query);
  }

  return ($result);
 }

 public function exec($query, $reconnect = true)
 {
  if ($reconnect)
  {
   $result = $this->run_reconnect('exec', $query);
  }
  else
  {
   $result = parent::exec($query);
  }

  return ($result);
 }

 #get the number of rows in a result
 public function num_rows($query)
 {
  $stmt = parent::prepare($query);
  if ($stmt)
  {
   $stmt->execute();

   return $stmt->rowCount();
  }
  return false;
 }
}

class reconnectPDOStatement extends PDOStatement
{
 public $dbh;

 protected function __construct($dbh)
 {
  $this->dbh = $dbh;
 }
}

Sharing host VPN with Vagrant - Rob Allen

2016-05-12T08:07:00.003-07:00

16 April 2014Computing

When moving a project into Vagrant, I realized that I needed the vagrant guest to share my OS X's VPN.

I'm using a separate IP address within a private network like this:

config.vm.network :private_network, ip: "192.168.101.101"

So, after some Googling, I added this provider configuration setting:

  config.vm.provider :virtualbox do |vb|
      vb.customize ["modifyvm", :id, "--natdnshostresolver1", "on"]
  end

and now my VM is sending data over the VPN. Note that this will not work when using the Vagrant's public_network setting though.

PuPHPet

These settings are the default for puphpet, BUT if you setup a public_network interface it will not work.

Resources

https://akrabat.com/sharing-host-vpn-with-vagrant/ -- quoted here.
http://renier.morales-rodriguez.net/post/90674523562/sharing-host-vpn-with-virtualbox-guest

Here is an example of how to add public_network only when you need it...

➜ IP='public' vagrant status

added to Vagrantfile

Vagrant.configure("2") do |config|
  ...

  # IP='public' vagrant status
  if ENV['IP'] == "public"
      # https://akrabat.com/sharing-host-vpn-with-vagrant/
      puts("[info] PUBLIC interface added")
      config.vm.network "public_network", :mac => "4CA3AB1EBBB1"
  end
end

reopen the "tab" or window when submitting a form

2016-03-09T07:57:00.000-08:00

this worked for me on form submit to reopen the target window.. so it will call window.open on the same target (or new if changed) and then continue to submit the form.

        var open_target = function (form){
            var windowName = jQuery(form).attr('target');
            window.open("", windowName );
            return true;
        };

    <form target="_search_elastic" onsubmit="return open_target(this);">
      </form>

emberjs CentOS 7 setup

2016-02-22T08:38:00.000-08:00

========= SETUP =========
* CentOS 7 Example *
### dependencies ###
yum install git,npm,nodejs;
npm install -g ember-cli
npm install -g bower
npm install -g watchman
npm install -g phantomjs
### Both should output a version number ###node -v
npm -v
npm install -g npm@latest
### open the firewall ###
iptables -I INPUT 1 -p tcp --dport 49152 -j ACCEPT
iptables -I INPUT 1 -p tcp --dport 4200 -j ACCEPT
iptables-save > /etc/sysconfig/iptables
iptables-restore < /etc/sysconfig/iptables
### setup your project ###
git clone git@github.com:me/my-app.git
cd my-app
###### NOT AS ROOT ######
npm install
bower install
### start ember server ###
ember server

	#!/bin/bash

	mkdir -p ~/Code/xdebug

	vim /etc/php/7.1/mods-available/xdebug.ini

	#update with the file contents for xdebug.ini

	nginx -s reload
	service php7.1-fpm restart

	zend_extension=xdebug.so
	xdebug.remote_enable = 1
	xdebug.remote_connect_back = 1
	xdebug.remote_port = 9000
	xdebug.max_nesting_level = 512

	xdebug.profiler_enable_trigger = 1;
	xdebug.profiler_output_dir = "~/Code/xdebug"
	xdebug.trace_enable_trigger = 1
	xdebug.trace_output_dir = "/home/vagrant/Code/xdebug"

	<?php

	/**
	* Initial Setup of file
	* Garbage collection sucks, we should have a time check during read and auto destroy/not recover old sessions
	*/
	class DB_Sessions
	{
	var $session_life = 300;
	var $sessiontable = 'sessions';
	var $recordtable = 'sessions_loginrecord';
	/**
	* @var DB_Wrapper
	*/
	var $dbhost;
	var $sessionhash;
	var $write_callback;
	var $memcache;

	function __construct(&$dbhost)
	{
	$this->dbhost =& $dbhost;
	ini_set('session.save_handler', 'user');
	session_set_save_handler(
	array($this, 'sess_open'),
	array($this, 'sess_close'),
	array($this, 'sess_read'),
	array($this, 'sess_write'),
	array($this, 'sess_destroy'),
	array($this, 'sess_gc')
	);

	if(function_exists('memcache_pconnect')) {
	$this->memcache = @memcache_pconnect($_SERVER['MEMCACHE_SERVER'], $_SERVER['MEMCACHE_PORT']);
	}
	}

	/**************************************
	* sess_open
	***************************************
	* Notes:
	***************************************
	* Used In
	***************************************
	* @author Richard Thomas
	*
	* @param $save_path STRING
	* @param $session_name STRING
	*
	* @return BOOL
	*/
	function sess_open($save_path, $session_name)
	{
	return true;
	}

	/**************************************
	* sess_close
	***************************************
	* Notes:
	***************************************
	* Used In
	***************************************
	* @author Richard Thomas
	* @return BOOL
	*/
	function sess_close()
	{
	return true;
	}

	/**************************************
	* sess_read
	***************************************
	* Notes:
	***************************************
	* Used In
	***************************************
	* @author Richard Thomas
	*
	* @param $key STRING
	*
	* @return BOOL
	*/
	function sess_read($key)
	{
	if (!is_object($this->memcache) OR (!$value = $this->memcache->get('sess_key_' . $key)))
	{
	$qry = "SELECT `value` FROM " . $this->sessiontable . " WHERE `sesskey` = '$key'";
	$qid = $this->dbhost->query($qry);
	if (list($value) = $qid->fetch_row())
	{
	$this->sessionhash = md5($value);
	if (is_object($this->memcache) AND $value)
	{
	$this->memcache->set('sess_key_' . $key, $value, COMPRESS_CACHE);
	}

	return (String) $value;
	}
	}
	else
	{
	$this->sessionhash = md5($value);

	return (String) $value;
	}

	return '';
	}

	/**************************************
	* sess_write
	***************************************
	* Notes:
	***************************************
	* Used In
	***************************************
	* @author Richard Thomas
	*
	* @param $key STRING
	* @param $val STRING
	*
	* @return BOOL
	*/
	function sess_write($key, $val)
	{
	$expiry = time() + $this->session_life;
	$value = addslashes($val);
	if (md5($val) == $this->sessionhash)
	{
	$qry = "UPDATE " . $this->sessiontable . " SET expiry = $expiry, userkey = '" . @$_SESSION['login'] . "' WHERE sesskey = '$key'";
	}
	else
	{
	if (is_object($this->memcache))
	{
	$this->memcache->delete('sess_key_' . $key);
	}
	$qry = "UPDATE " . $this->sessiontable . " SET expiry = $expiry, value = '$value', userkey = '" . @$_SESSION['login'] . "' WHERE sesskey = '$key'";
	if ($this->write_callback)
	{
	call_user_func($this->write_callback, $val);
	}
	}
	$qid = $this->dbhost->query($qry);
	if (!$this->dbhost->affected_rows())
	{
	if (!empty($_SERVER['REMOTE_ADDR']))
	{
	$qry = "INSERT INTO " . $this->sessiontable . " VALUES ('$key', $expiry, '$value','" . @$_SESSION['login'] . "','$expiry','" . $_SERVER['REMOTE_ADDR'] . "','" . $_SERVER['HTTP_HOST'] . "')";
	}
	else
	{
	$qry = "INSERT INTO " . $this->sessiontable . " VALUES ('$key', $expiry, '$value','" . @$_SESSION['login'] . "','$expiry','\"\"','" . $_SERVER['HTTP_HOST'] . "')";
	}
	$qid = $this->dbhost->query($qry);
	}

	return $qid;
	}

	/**************************************
	* sess_destroy
	***************************************
	* Notes:
	***************************************
	* Used In
	***************************************
	* @author Richard Thomas
	*
	* @param $key STRING
	*
	* @return BOOL
	*/
	function sess_destroy($key)
	{
	$temp = time();
	if (is_object($this->memcache))
	{
	$this->memcache->delete('sess_key_' . $key);
	}
	$qry = "SELECT userkey,started,ip,host FROM " . $this->sessiontable . " WHERE sesskey = '$key'";
	$qid = $this->dbhost->query($qry);
	$row = $qid->fetch_assoc();
	$userkey = $row['userkey'];
	$started = $row['started'];
	$ip = $row['ip'];
	$host = $row['host'];
	if ($userkey <> "" AND $this->recordtable)
	{
	$qry = "INSERT INTO " . $this->recordtable . " VALUES ('$userkey','$started','$temp','$ip','$host')";
	$qid = $this->dbhost->query($qry);
	}
	$qry = "DELETE FROM " . $this->sessiontable . " WHERE sesskey = '$key'";
	$qid = $this->dbhost->query($qry);

	return $qid;
	}

	/**************************************
	* sess_gc
	***************************************
	* Notes:
	***************************************
	* Used In
	***************************************
	* @author Richard Thomas
	*
	* @param $maxlifetime INT
	*
	* @return BOOL
	*/
	function sess_gc($maxlifetime)
	{
	$temp = time();
	$qry = "SELECT sesskey FROM " . $this->sessiontable . " WHERE expiry < " . $temp;
	$result = $this->dbhost->query($qry);
	for ($i = 0; $i < $result->num_rows(); $i++)
	{
	$row = $result->fetch_assoc();
	$key = $row['sesskey'];
	if (is_object($this->memcache))
	{
	$this->memcache->delete('sess_key_' . $key);
	}
	$qry = "SELECT userkey,started,ip,host FROM " . $this->sessiontable . " WHERE sesskey = '$key'";
	$qid = $this->dbhost->query($qry);
	if ($qid)
	{
	$row = $qid->fetch_assoc();
	$userkey = $row['userkey'];
	$started = $row['started'];
	$ip = $row['ip'];
	$host = $row['host'];
	if ($userkey <> "" AND $this->recordtable)
	{
	$qry = "INSERT INTO " . $this->recordtable . " VALUES ('$userkey','$started','$temp','$ip','$host')";
	$qid = $this->dbhost->query($qry);
	}
	}
	}
	$qry = "DELETE FROM " . $this->sessiontable . " WHERE expiry < " . $temp;
	$qid = $this->dbhost->query($qry);

	return $this->dbhost->affected_rows();
	}

	/**************************************
	* sess_isonline
	***************************************
	* Notes:
	***************************************
	* Used In
	***************************************
	* @author Richard Thomas
	*
	* @param $login STRING
	*
	* @return BOOL
	*/
	function session_isonline($login)
	{
	$temp = time();
	$query = "SELECT userkey FROM " . $this->sessiontable . " WHERE userkey = '$login' AND expiry > $temp";
	$result = $this->dbhost->query($query);

	return $result->num_rows();
	}

	}

Geeks Like Shiny Things

Pop-Up Book from HELL.

Gun Ownership

Gun Ownership In 2018

Disturbing articles about mass quantities of guns

Javascript shortcuts using chrome search engine feature.

SQL Server: cannot drop database because currently its in use

cannot drop database because currently its in use

Composer Packages: Revive AdServer XML API

Artistan/Revive-XmlRpc Artistan@github

Revive AdServer xml api

requires

examples

composer

Version 2 xml

Version 1 xml

Ad Display Retrieval xml

New Helper Function...

Respecting the flag

MacBook - Rear View Mirror

How to Turn on a MacBook Camera

Tip

MySQL: mysqldump, compress, to remote server, and import on remote server

Adminer.php for Laravel v2.0.1 released.

adminer-for-laravel 5.*

Installation

Composer

Add directly to your composer.json

Providers

Laravel <5.4

adminer-for-laravel 5.*

Adminer is a full-featured database management tool written in PHP. This package automates setup for adminer and routes your.domain.here/adminer to the the adminer.php script.

Installation

Composer

composer require leung/laravel-adminer OR

Add directly to your composer.json

"require": { "leung/laravel-adminer": "^2.0" },

Providers

Laravel <5.4

open your config/app.php and add this line in providers section Simple\Adminer\AdminerServiceProvider::class

OR prevent it being on production

open your app/Providers/AppServiceProvider.php and add this line in the register() function if ($this->app->environment() !== 'production') { $this->app->register(\Simple\Adminer\AdminerServiceProvider::class); }

Laravel 5.5 providers

auto included via automatic package discovery // no need to add anything!!!

Update adminer.php

Command line update

php artisan adminer:update Composer update also automates running this script

[Optional] Middleware

Middleware is added in via the service provider

to override this you may add a adminer route to your App routes.php Route::any('adminer', '\Simple\Adminer\AdminerController@index')->middleware('adminer_custom_middleware'); // where you defined your middleware in app/Http/Kernel.php

Add middleware group example

Modify app/Http/Middleware/VerifyCsrfToken.php

also add adminer to $except array if you are using the example optional adminer group protected $except = [ 'adminer' ];

Interactively remove git commit from history of repo.

Key Points

Cheers!

Middleware Group Exists

Example of the Controller OPTIONALLY using a middleware definition.

add middleware Example

How to upgrade to PHP 7.1 on Ubuntu

How to upgrade to PHP 7.1 on Ubuntu

1. List your current PHP packages

3. Install PHP 7.1

4. Install PHP 7.1 dependancies

5. Test if PHP version is indeed 7.1

6. OPTIONAL - Remove old 7.0 packages !! IF !! you do not need them for another virtual hosted site.

7. Update Nginx to 7.1 packages.

PhpStorm Remote Xdebug

HOMESTEAD BOX

Remote PhpStorm Xdebug

Laravel and PhpStorm needed proper inheritance hinting

Here is an example of a Repository Pattern which would use this.

which can be used with proper inheritance

and we can have the repo calls to the model method be properly recognized.

Custom Chunk Sizes in Laravel Scout

PhpStorm (JetBrains) is SHINY!! for merging updates

Laravel 5.4 .env files — how they autoload

Laravel 5.4 .env files — how they autoload

xdebug with phpstorm and puphpet vagrant box

Xdebug is useful in many ways. debugging, profiling, error reporting.

Add directly to your `composer.json`

composer require leung/laravel-adminer

OR

Add directly to your `composer.json`

open your `config/app.php` and add this line in providers section

Simple\Adminer\AdminerServiceProvider::class

open your `app/Providers/AppServiceProvider.php` and add this line in the `register()` function

if ($this->app->environment() !== 'production') { $this->app->register(\Simple\Adminer\AdminerServiceProvider::class); }

auto included via automatic package discovery

// no need to add anything!!!

php artisan adminer:update

Composer update also automates running this script

to override this you may add a adminer route to your App routes.php

Route::any('adminer', '\Simple\Adminer\AdminerController@index')->middleware('adminer_custom_middleware'); // where you defined your middleware in app/Http/Kernel.php

also add adminer to $except array if you are using the example optional adminer group

protected $except = [ 'adminer' ];