public function getStatsList($where = '1', $limit = 30)
{
$p = $_REQUEST['p'] ? $_REQUEST['p'] : 1;
$start = ($p - 1) * $limit;
$sqlCount = 'SELECT COUNT(1) as count FROM ' . C('DB_PREFIX') . "online_stats WHERE {$where} ";
if ($count = $this->odb->query($sqlCount)) {
$count = $count[0]['count'];
} else {
$count = 0;
}
$sql = 'SELECT * FROM ' . C('DB_PREFIX') . "online_stats WHERE {$where} LIMIT {$start},{$limit}";
$data = $this->odb->query($sql);
$p = new Page($count, $limit);
$output['count'] = $count;
$output['totalPages'] = $p->totalPages;
$output['totalRows'] = $p->totalRows;
$output['nowPage'] = $p->nowPage;
$output['html'] = $p->show();
$output['data'] = $data;
return $output;
}