function clearTrafficTable()
{
$sql = new Sqlite(null, "vpstraffic");
$sql->rawquery("delete from vpstraffic;");
}
protected final function initVirtualListIfUndef($class)
{
global $gbl, $sgbl, $login, $ghtml;
$list = "{$class}_l";
//list($iclass, $mclass, $rclass) = get_composite($class);
$rclass = $class;
$this->__list_list = array_push_unique($this->__list_list, $class);
$typevar = "__listtype_{$class}";
$totalvar = "__virtualtotal_{$class}";
if (!isset($this->{$list})) {
$this->{$list} = null;
}
if (isset($this->{$typevar}) && ($this->{$typevar} === 'fullist' || $this->{$typevar} === 'virtuallist')) {
return $this->{$totalvar};
}
$this->backuplist = $this->{$list};
if ($rule = exec_class_method($rclass, 'initThisListRule', $this, $class)) {
$query = $this->getDefaultQuery($class, $rule);
//dprint(' <br> ' .$query . "<br> \n");
$filter = $this->getFilterForThis($class);
$string = exec_class_method($rclass, "getdbFilter", $filter, $class);
if ($string) {
if ($query) {
$query .= " AND {$string}";
} else {
$query .= " where {$string}";
}
}
$db = new Sqlite($this->__masterserver, $this->getTheTable($rclass));
$countquery = $query;
$table = $this->getTheTable($rclass);
print_time('count');
//$db->rawquery("begin;");
$countres = $db->rawquery("select count(*) from {$table} {$countquery}");
if ($sgbl->__var_database_type === 'mysql') {
$countres = $countres[0]['count(*)'];
} else {
if ($sgbl->__var_database_type === 'mssql') {
$countres = $countres[0]['computed'];
} else {
$countres = $countres[0]['count(*)'];
}
}
//print_time('count', "CountResult");
print_time('getdb');
$f = $this->getDbOrderLimit($filter, $countres, $class);
$table = $this->getTheTable($rclass);
$sortby = $f['sortby'];
$sortdir = $f['sortdir'];
$skiprows = $f['skiprows'];
$pagesize = $f['pagesize'];
$revsortdir = $f['revsortdir'];
if ($sgbl->__var_database_type === 'mysql') {
$desc = get_classvar_description($class, $sortby);
if (csa($desc[0], "q")) {
$sortby = "(used_q_{$sortby} + 0)";
}
$query = "select * from {$table} {$countquery} order by {$sortby} {$sortdir} limit {$skiprows}, {$pagesize}";
} else {
if ($sgbl->__var_database_type === 'mssql') {
$tot = $pagesize + $skiprows;
$query = "select * from (select top {$pagesize} * from ( select top {$tot} * from {$table} {$countquery} order by {$sortby} {$sortdir} ) as t_{$table} order by {$sortby} {$revsortdir}) as t2_{$table} order by {$sortby} {$sortdir}";
} else {
$query = "select * from {$table} {$countquery} order by {$sortby} {$sortdir} limit {$skiprows}, {$pagesize}";
}
}
$res = $db->rawQuery($query);
//$db->rawquery("commit;");
//print_time('getdb', 'GetResult');
} else {
$res = exec_class_method($rclass, 'initThisList', $this, $class);
$countres = count($res);
}
//$this->ApplyFilter($res);
$this->setListFromArray($this->__masterserver, $this->__readserver, $class, $res);
foreach ((array) $this->backuplist as $v) {
$this->{$list}[$v->nname] = $v;
}
$this->{$typevar} = 'virtuallist';
$this->{$totalvar} = $countres;
return $countres;
}
function check_raw_password($class, $client, $pass)
{
//return true;
if (!$class || !$client || !$pass) {
return false;
}
$rawdb = new Sqlite(null, $class);
$password = $rawdb->rawquery("select password from {$class} where nname = '{$client}'");
$enp = $password[0]['password'];
if ($enp && check_password($pass, $enp)) {
return true;
}
return false;
//$rawdb->close();
}
function check_raw_password($class, $client, $pass)
{
//return true;
if (!$class || !$client || !$pass) {
return false;
}
$rawdb = new Sqlite(null, $class);
// LxCenter - DT30011014
$password = $rawdb->rawquery("select password from " . mysql_real_escape_string($class) . " where nname = '" . mysql_real_escape_string($client) . "'");
$enp = $password[0]['password'];
if ($enp && check_password($pass, $enp)) {
return true;
}
return false;
//$rawdb->close();
}
