芝麻web文件管理V1.00

编辑当前文件:/home/qrafawbu/lugarcollectibles.com/admin/model/extension/dashboard/online.php
<?php class ModelExtensionDashboardOnline extends Model { public function getTotalOnline($data = array()) { $sql = "SELECT COUNT(*) AS total FROM `" . DB_PREFIX . "customer_online` co LEFT JOIN " . DB_PREFIX . "customer c ON (co.customer_id = c.customer_id)"; $implode = array(); if (!empty($data['filter_ip'])) { $implode[] = "co.ip LIKE '" . $this->db->escape($data['filter_ip']) . "'"; } if (!empty($data['filter_customer'])) { $implode[] = "co.customer_id > 0 AND CONCAT(c.firstname, ' ', c.lastname) LIKE '" . $this->db->escape($data['filter_customer']) . "'"; } if ($implode) { $sql .= " WHERE " . implode(" AND ", $implode); } $query = $this->db->query($sql); return $query->row['total']; } }