public function signin() { $email = $this->f3->get('POST.email'); $password = $this->f3->get('POST.password'); $v = new Valitron\Validator(array('Email' => $email, 'Password' => $password)); $v->rule('required', ['Email', 'Password']); $v->rule('email', 'Email'); if ($v->validate()) { $account = new Account($this->db); $pwd = md5($password); $acc = $account->select("*", "email='$email' and password='******'"); if ($acc) { $this->f3->set('SESSION.acc', $acc); $acc = $acc[0]; $acc['lastlogin'] = date('Y-m-d H:i:s'); $account->update($acc,'id='.$acc['id']); $this->f3->reroute('/dashboard'); } else { $this->f3->set('email', $email); $this->f3->set('errors', array(array('Login fail, wrong username or password'))); echo Template::instance()->render('index.html'); } } else { $this->f3->set('email', $email); $this->f3->set('errors', $v->errors()); echo Template::instance()->render('index.html'); } }
function parseBrowse($cId, $eId, $cmd) { global $_PATHS, $_CONF; $objTpl = new HTML_Template_IT($_PATHS['templates']); $objTpl->loadTemplatefile("common.tpl.htm"); switch ($cId) { case NAV_ACCOUNT: $objAccounts = Account::select("SELECT * FROM punch_account ORDER BY name"); $arrDomain = explode('.', $_SERVER['HTTP_HOST']); $strRootDomain = count($arrDomain) > 2 ? str_replace(array_shift($arrDomain) . ".", "", $_SERVER['HTTP_HOST']) : $_SERVER['HTTP_HOST']; //*** Render list. foreach ($objAccounts as $objTempAccount) { $objTpl->setCurrentBlock("list-item"); $objTpl->setVariable('ITEM_LINK', "http://" . $objTempAccount->getUri() . "." . $strRootDomain); $objTpl->setVariable('ITEM_LABEL', htmlentities($objTempAccount->getName())); $objTpl->setVariable('ITEM_EXPORT', "?cid=" . NAV_ACCOUNT . "&cmd=" . CMD_EXPORT . "&eid=" . $objTempAccount->getId()); $objTpl->setVariable('ITEM_RESTORE', "?cid=" . NAV_ACCOUNT . "&cmd=" . CMD_RESTORE . "&eid=" . $objTempAccount->getId()); $objTpl->setVariable('ITEM_EDIT', "?cid=" . NAV_ACCOUNT . "&cmd=" . CMD_EDIT . "&eid=" . $objTempAccount->getId()); $objTpl->setVariable('ITEM_TYPE', "Account"); $objTpl->setVariable('ITEM_ID', $objTempAccount->getId()); $objTpl->parseCurrentBlock(); } break; case NAV_ADMIN: break; } //*** Return the output. return $objTpl->get(); }
function address() { $user_id = Account::getUserId(); $field = array('country', 'region', 'province', 'city', 'district', 'address', 'postcode', 'mobile', 'tel'); $m = new Account(); $m->clear(); $m->setField($field); $m->setTable('vcb_user_address'); $m->setWhere('user_id', '=', $user_id); $data = $m->select(); if (empty($data)) { header("location:transfer"); } $this->assign('data', $data); }
<?php $arrDomain = explode('.', $_SERVER['HTTP_HOST']); $intCatId = Request::get("cid"); if (isset($_CONF['app']['singleInstance']) && $_CONF['app']['singleInstance']) { //*** Check if the account exists. $objAccounts = Account::select(); if ($objAccounts->count() <= 0) { //*** Account does not exist. header("Location: " . Request::getURI("http") . "/?cid=" . NAV_MYPUNCH_NOACCOUNT); exit; } else { $objAccount = $objAccounts->current(); } //*** Set the PunchId. $_CONF['app']['account'] = $objAccount; $_CONF['app']['pageTitle'] = sprintf($objLang->get('pageTitle'), $_CONF['app']['account']->getName(), APP_NAME, APP_VERSION); } else { if ($intCatId != NAV_MYPUNCH_NOACCOUNT) { if (count($arrDomain) > 2) { $strDomain = $arrDomain[count($arrDomain) - 2] . "." . $arrDomain[count($arrDomain) - 1]; $strSubName = $arrDomain[0]; //*** Check if the account exists. $objAccount = Account::getByUri($strSubName); if (!is_object($objAccount)) { //*** Account does not exist. header("Location: " . Request::getURI("http") . "/?cid=" . NAV_MYPUNCH_NOACCOUNT); exit; } //*** Set the PunchId. $_CONF['app']['account'] = $objAccount;
public function testSelectWithNoParameters() { // our mock adapter $adapter = $this->adapterMock; // prepare the mock to expect the variables passed, and return a row $adapter->expects($this->once())->method('select')->with('accounts', null, null, array()); $accountsTable = new Account($adapter); // getInstance doesn't work well in testing $result = $accountsTable->select(); }
<!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title></title> </head> <body> <?php require 'autoloader.php'; Autoloader::register(); Config::load(array('dbconfig' => array('char' => array('user' => 'root', 'pass' => '', 'dsn' => 'mysql:host=127.0.0.1;dbname=characters'), 'auth' => array('user' => 'root', 'pass' => '', 'dsn' => 'mysql:host=127.0.0.1;dbname=auth')))); $accounts = Account::select('id = 1'); foreach ($accounts as $account) { $account->delete(); } DatabaseManager::get('auth')->queue->execute(); DatabaseManager::get('char')->queue->execute(); ?> </body> </html>