aboutsummaryrefslogtreecommitdiffstats
path: root/public/admin/model/extension/report/activity.php
diff options
context:
space:
mode:
Diffstat (limited to 'public/admin/model/extension/report/activity.php')
-rw-r--r--public/admin/model/extension/report/activity.php8
1 files changed, 8 insertions, 0 deletions
diff --git a/public/admin/model/extension/report/activity.php b/public/admin/model/extension/report/activity.php
new file mode 100644
index 0000000..94612f7
--- /dev/null
+++ b/public/admin/model/extension/report/activity.php
@@ -0,0 +1,8 @@
+<?php
+class ModelExtensionReportActivity extends Model {
+ public function getActivities() {
+ $query = $this->db->query("SELECT a.key, a.data, a.date_added FROM ((SELECT CONCAT('customer_', ca.key) AS `key`, ca.data, ca.date_added FROM `" . DB_PREFIX . "customer_activity` ca) UNION (SELECT CONCAT('affiliate_', aa.key) AS `key`, aa.data, aa.date_added FROM `" . DB_PREFIX . "affiliate_activity` aa)) a ORDER BY a.date_added DESC LIMIT 0,5");
+
+ return $query->rows;
+ }
+} \ No newline at end of file