function oQuery($params)
{
$tp = myArray($params, 'tp', 'main');
$st = myArray($params, 'st', '');
$ps = myArray($params, 'ps', array());
$pdo = myArray($params, 'pdo', null);
$logIt = myArray($params, 'logIt', false);
if (!is_array($ps)) {
$ps = array($ps);
}
$code = $st . implode(',', $ps);
$ret = mySx($code, null);
if ($ret) {
return $ret;
}
$ret = sqlQuery($tp, $st, $ps, $logIt, $pdo);
setSx($code, formatSx($ret));
return $ret;
}
<?php
session_start();
include "includeAll.php";
$ct = myGet('ct', 0);
if ($ct) {
$lista = mySx('customers');
foreach ($lista as $x) {
if ($x['id_customers'] == $ct) {
setSx('customerID', $ct);
}
}
}
$customerID = mySx('customerID');
if ($customerID) {
$profiles = array();
$profiles[1] = array('cat' => 1, 'serv' => 2, 'lat' => 7, 'lng' => 8);
$profiles[2] = array('cat' => 13, 'serv' => 14, 'lat' => 19, 'lng' => 20);
$profile = $profiles[$customerID];
setSx('profile', $profile);
}
function mySx($nome, $valor = '')
{
if (!isset($_SESSION[$nome])) {
setSx($nome, $valor);
}
return $_SESSION[$nome];
}
$login = myPost('login', '');
$password = myPost('password', '');
$ps = array($login, $password);
$busca = sqlQuery('main', '
SELECT *
FROM panel_users
WHERE pnu_username = ? AND pnu_password = ?
', $ps);
$aRet = $busca['ret'];
if ($aRet['status'] == 1) {
if ($busca['count'] == 1) {
$user = $busca['rows'][0];
setSx('uid', $user['id_panel_users']);
setSx('user', $user);
setSx('logado', 1);
$lista = getListaCustomers();
setSx('customers', $lista);
if ($lista) {
setSx('customerID', $lista[0]['id_customers']);
}
} else {
setSx('uid', 0);
setSx('user', null);
setSx('logado', 0);
setSx('customerID', 0);
$aRet['status'] = 0;
$aRet['error'] = $lb->get('session.wrong');
}
}
$aRet['logado'] = mySx('logado', 0);
echo json_encode($aRet);
