<?php

namespace App\User;

use Qs_Auth_Adapter_DbTable as AdapterDbTable;

class AuthAdapter extends AdapterDbTable
{
    protected $_tableAlias = 'User';
    protected $_identityColumn = 'email';
    protected $_credentialColumn = 'password';
    protected $_credentialTreatment = 'MD5(CONCAT(`salt`, ?))';


    protected function _authenticateCreateSelect()
    {
        $dbSelect = parent::_authenticateCreateSelect();
        $dbSelect->where('`bought` = "y"');
        return $dbSelect;
    }
}