diff options
author | matt <matt@59fd770c-687e-43c8-a1e3-f5a4ff64c105> | 2009-12-09 01:53:17 +0300 |
---|---|---|
committer | matt <matt@59fd770c-687e-43c8-a1e3-f5a4ff64c105> | 2009-12-09 01:53:17 +0300 |
commit | 4b6e2990d01ddacdb68bb4f9da72d6bc3985d371 (patch) | |
tree | c4452c764d1ec4dea10ab51d79680f8a1ccb2cb2 /plugins/Live | |
parent | 7e8fe7606c1998ecd2c1a137f9a6754257f7f489 (diff) |
- Few updates in the messaging
- in DBStats API, table name is not bound using ? in the query, so it has to be escaped
Diffstat (limited to 'plugins/Live')
-rw-r--r-- | plugins/Live/API.php | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/plugins/Live/API.php b/plugins/Live/API.php index 488455d39c..383ed63a74 100644 --- a/plugins/Live/API.php +++ b/plugins/Live/API.php @@ -304,6 +304,7 @@ class Piwik_Live_API /* + * TODO should be refactored with function below * @return array */ private function loadLastVisitorDetailsInLastXMinFromDatabase($visitorId = null, $idSite = null, $limit = 1000, $minIdVisit = false, $minutes = 0 ) @@ -345,11 +346,12 @@ class Piwik_Live_API FROM " . Piwik::prefixTable('log_visit') . " $sqlWhere ORDER BY idvisit DESC - LIMIT " . $limit; + LIMIT " . (int)$limit; return Piwik_FetchAll($sql, $whereBind); } /* + * TODO should be refactored with function above * @return array */ private function loadLastVisitorDetailsInLastXDaysFromDatabase($visitorId = null, $idSite = null, $limit = 1000, $minIdVisit = false, $days = 0 ) @@ -391,12 +393,12 @@ class Piwik_Live_API FROM " . Piwik::prefixTable('log_visit') . " $sqlWhere ORDER BY idvisit DESC - LIMIT " . $limit; - + LIMIT " . (int)$limit; return Piwik_FetchAll($sql, $whereBind); } /* + * TODO should be refactored with function above * @return array */ private function loadLastVisitedPagesInLastXMinFromDatabase($visitorId = null, $idSite = null, $limit = null, $minIdVisit = false, $minutes = 0 ) @@ -443,6 +445,7 @@ class Piwik_Live_API } /* + * TODO should be refactored with function above * @return array */ private function loadLastVisitedPagesInLastXDaysFromDatabase($visitorId = null, $idSite = null, $limit = null, $minIdVisit = false, $days = 0 ) |