summaryrefslogtreecommitdiffstats
path: root/lib/class/stats.class.php
diff options
context:
space:
mode:
authorPaul Arthur <paul.arthur@flowerysong.com>2013-01-26 03:00:32 -0500
committerPaul Arthur <paul.arthur@flowerysong.com>2013-01-26 03:38:46 -0500
commitef4d3660605efc7f1328d4533b0f4bfb6c1107e2 (patch)
treee4377fb129a899e65aaaf421f8c97098aecaedd5 /lib/class/stats.class.php
parent8a750c3e875d590d351c3042570a134fcdf03e5d (diff)
downloadampache-ef4d3660605efc7f1328d4533b0f4bfb6c1107e2.tar.gz
ampache-ef4d3660605efc7f1328d4533b0f4bfb6c1107e2.tar.bz2
ampache-ef4d3660605efc7f1328d4533b0f4bfb6c1107e2.zip
Cosmetics: death to tabs
The refactoring I've been doing has reminded me of my strong preference for spaces, and I feel inclined to impose my will on the tree.
Diffstat (limited to 'lib/class/stats.class.php')
-rw-r--r--lib/class/stats.class.php396
1 files changed, 198 insertions, 198 deletions
diff --git a/lib/class/stats.class.php b/lib/class/stats.class.php
index 4ff676e9..23b17b20 100644
--- a/lib/class/stats.class.php
+++ b/lib/class/stats.class.php
@@ -1,5 +1,5 @@
<?php
-/* vim:set tabstop=8 softtabstop=8 shiftwidth=8 noexpandtab: */
+/* vim:set softtabstop=4 shiftwidth=4 expandtab: */
/**
*
* LICENSE: GNU General Public License, version 2 (GPLv2)
@@ -30,234 +30,234 @@
*/
class Stats {
- /* Base vars */
- var $id;
- var $object_type;
- var $object_id;
- var $date;
- var $user;
+ /* Base vars */
+ var $id;
+ var $object_type;
+ var $object_id;
+ var $date;
+ var $user;
- /**
- * Constructor
- * This doesn't do anything currently
- */
- public function __construct() {
+ /**
+ * Constructor
+ * This doesn't do anything currently
+ */
+ public function __construct() {
- return true;
+ return true;
- } // Constructor
+ } // Constructor
- /**
- * clear
- *
- * This clears all stats for _everything_.
- */
- public static function clear() {
- Dba::write('TRUNCATE `object_count`');
- Dba::write('UPDATE `song` SET `played` = 0');
- }
+ /**
+ * clear
+ *
+ * This clears all stats for _everything_.
+ */
+ public static function clear() {
+ Dba::write('TRUNCATE `object_count`');
+ Dba::write('UPDATE `song` SET `played` = 0');
+ }
- /**
- * gc
- *
- * This removes stats for things that no longer exist.
- */
- public static function gc() {
- foreach(array('song', 'album', 'artist', 'live_stream', 'video') as $object_type) {
- Dba::write("DELETE FROM `object_count` USING `object_count` LEFT JOIN `$object_type` ON `$object_type`.`id` = `object_count`.`object_id` WHERE `object_type` = '$object_type' AND `$object_type`.`id` IS NULL");
- }
- }
+ /**
+ * gc
+ *
+ * This removes stats for things that no longer exist.
+ */
+ public static function gc() {
+ foreach(array('song', 'album', 'artist', 'live_stream', 'video') as $object_type) {
+ Dba::write("DELETE FROM `object_count` USING `object_count` LEFT JOIN `$object_type` ON `$object_type`.`id` = `object_count`.`object_id` WHERE `object_type` = '$object_type' AND `$object_type`.`id` IS NULL");
+ }
+ }
- /**
- * insert
- * This inserts a new record for the specified object
- * with the specified information, amazing!
- */
- public static function insert($type,$oid,$user) {
+ /**
+ * insert
+ * This inserts a new record for the specified object
+ * with the specified information, amazing!
+ */
+ public static function insert($type,$oid,$user) {
- $type = self::validate_type($type);
- $oid = Dba::escape($oid);
- $user = Dba::escape($user);
- $date = time();
+ $type = self::validate_type($type);
+ $oid = Dba::escape($oid);
+ $user = Dba::escape($user);
+ $date = time();
- $sql = "INSERT INTO `object_count` (`object_type`,`object_id`,`date`,`user`) " .
- " VALUES ('$type','$oid','$date','$user')";
- $db_results = Dba::write($sql);
+ $sql = "INSERT INTO `object_count` (`object_type`,`object_id`,`date`,`user`) " .
+ " VALUES ('$type','$oid','$date','$user')";
+ $db_results = Dba::write($sql);
- if (!$db_results) {
- debug_event('statistics','Unabled to insert statistics:' . $sql,'3');
- }
+ if (!$db_results) {
+ debug_event('statistics','Unabled to insert statistics:' . $sql,'3');
+ }
- } // insert
+ } // insert
- /**
- * get_last_song
- * This returns the full data for the last song that was played, including when it
- * was played, this is used by, among other things, the LastFM plugin to figure out
- * if we should re-submit or if this is a duplicate / if it's too soon. This takes an
- * optional user_id because when streaming we don't have $GLOBALS()
- */
- public static function get_last_song($user_id='') {
-
- $user_id = $user_id ? $user_id : $GLOBALS['user']->id;
-
- $user_id = Dba::escape($user_id);
+ /**
+ * get_last_song
+ * This returns the full data for the last song that was played, including when it
+ * was played, this is used by, among other things, the LastFM plugin to figure out
+ * if we should re-submit or if this is a duplicate / if it's too soon. This takes an
+ * optional user_id because when streaming we don't have $GLOBALS()
+ */
+ public static function get_last_song($user_id='') {
+
+ $user_id = $user_id ? $user_id : $GLOBALS['user']->id;
+
+ $user_id = Dba::escape($user_id);
- $sql = "SELECT * FROM `object_count` WHERE `user`='$user_id' AND `object_type`='song' ORDER BY `date` DESC LIMIT 1";
- $db_results = Dba::read($sql);
-
- $results = Dba::fetch_assoc($db_results);
-
- return $results;
+ $sql = "SELECT * FROM `object_count` WHERE `user`='$user_id' AND `object_type`='song' ORDER BY `date` DESC LIMIT 1";
+ $db_results = Dba::read($sql);
+
+ $results = Dba::fetch_assoc($db_results);
+
+ return $results;
- } // get_last_song
+ } // get_last_song
- /**
- * get_object_history
- * This returns the objects that have happened for $user_id sometime after $time
- * used primarly by the democratic cooldown code
- */
- public static function get_object_history($user_id='',$time) {
+ /**
+ * get_object_history
+ * This returns the objects that have happened for $user_id sometime after $time
+ * used primarly by the democratic cooldown code
+ */
+ public static function get_object_history($user_id='',$time) {
- $user_id = $user_id ? $user_id : $GLOBALS['user']->id;
-
- $user_id = Dba::escape($user_id);
-
- $time = Dba::escape($time);
-
- $sql = "SELECT * FROM `object_count` WHERE `user`='$user_id' AND `object_type`='song' AND `date`>='$time' " .
- "ORDER BY `date` DESC";
- $db_results = Dba::read($sql);
-
- $results = array();
-
- while ($row = Dba::fetch_assoc($db_results)) {
- $results[] = $row['object_id'];
- }
-
- return $results;
-
- } // get_object_history
-
- /**
- * get_top
- * This returns the top X for type Y from the
- * last stats_threshold days
- */
- public static function get_top($type,$count='',$threshold = '') {
-
- /* If they don't pass one, then use the preference */
- if (!$threshold) {
- $threshold = Config::get('stats_threshold');
- }
-
- if (!$count) {
- $count = Config::get('popular_threshold');
- }
-
- $count = intval($count);
- $type = self::validate_type($type);
- $date = time() - (86400*$threshold);
+ $user_id = $user_id ? $user_id : $GLOBALS['user']->id;
+
+ $user_id = Dba::escape($user_id);
+
+ $time = Dba::escape($time);
+
+ $sql = "SELECT * FROM `object_count` WHERE `user`='$user_id' AND `object_type`='song' AND `date`>='$time' " .
+ "ORDER BY `date` DESC";
+ $db_results = Dba::read($sql);
+
+ $results = array();
+
+ while ($row = Dba::fetch_assoc($db_results)) {
+ $results[] = $row['object_id'];
+ }
+
+ return $results;
+
+ } // get_object_history
+
+ /**
+ * get_top
+ * This returns the top X for type Y from the
+ * last stats_threshold days
+ */
+ public static function get_top($type,$count='',$threshold = '') {
+
+ /* If they don't pass one, then use the preference */
+ if (!$threshold) {
+ $threshold = Config::get('stats_threshold');
+ }
+
+ if (!$count) {
+ $count = Config::get('popular_threshold');
+ }
+
+ $count = intval($count);
+ $type = self::validate_type($type);
+ $date = time() - (86400*$threshold);
- /* Select Top objects counting by # of rows */
- $sql = "SELECT object_id,COUNT(id) AS `count` FROM object_count" .
- " WHERE object_type='$type' AND date >= '$date'" .
- " GROUP BY object_id ORDER BY `count` DESC LIMIT $count";
- $db_results = Dba::read($sql);
+ /* Select Top objects counting by # of rows */
+ $sql = "SELECT object_id,COUNT(id) AS `count` FROM object_count" .
+ " WHERE object_type='$type' AND date >= '$date'" .
+ " GROUP BY object_id ORDER BY `count` DESC LIMIT $count";
+ $db_results = Dba::read($sql);
- $results = array();
+ $results = array();
- while ($row = Dba::fetch_assoc($db_results)) {
- $results[] = $row['object_id'];
- }
+ while ($row = Dba::fetch_assoc($db_results)) {
+ $results[] = $row['object_id'];
+ }
- return $results;
+ return $results;
- } // get_top
+ } // get_top
- /**
- * get_user
- * This gets all stats for atype based on user with thresholds and all
- * If full is passed, doesn't limit based on date
- */
- public static function get_user($count,$type,$user,$full='') {
+ /**
+ * get_user
+ * This gets all stats for atype based on user with thresholds and all
+ * If full is passed, doesn't limit based on date
+ */
+ public static function get_user($count,$type,$user,$full='') {
- $count = intval($count);
- $type = self::validate_type($type);
- $user = Dba::escape($user);
+ $count = intval($count);
+ $type = self::validate_type($type);
+ $user = Dba::escape($user);
- /* If full then don't limit on date */
- if ($full) {
- $date = '0';
- }
- else {
- $date = time() - (86400*Config::get('stats_threshold'));
- }
+ /* If full then don't limit on date */
+ if ($full) {
+ $date = '0';
+ }
+ else {
+ $date = time() - (86400*Config::get('stats_threshold'));
+ }
- /* Select Objects based on user */
- //FIXME:: Requires table scan, look at improving
- $sql = "SELECT object_id,COUNT(id) AS `count` FROM object_count" .
- " WHERE object_type='$type' AND date >= '$date' AND user = '$user'" .
- " GROUP BY object_id ORDER BY `count` DESC LIMIT $count";
- $db_results = Dba::read($sql);
+ /* Select Objects based on user */
+ //FIXME:: Requires table scan, look at improving
+ $sql = "SELECT object_id,COUNT(id) AS `count` FROM object_count" .
+ " WHERE object_type='$type' AND date >= '$date' AND user = '$user'" .
+ " GROUP BY object_id ORDER BY `count` DESC LIMIT $count";
+ $db_results = Dba::read($sql);
- $results = array();
+ $results = array();
- while ($r = Dba::fetch_assoc($db_results)) {
- $results[] = $r;
- }
+ while ($r = Dba::fetch_assoc($db_results)) {
+ $results[] = $r;
+ }
- return $results;
+ return $results;
- } // get_user
+ } // get_user
- /**
- * validate_type
- * This function takes a type and returns only those
- * which are allowed, ensures good data gets put into the db
- */
- public static function validate_type($type) {
+ /**
+ * validate_type
+ * This function takes a type and returns only those
+ * which are allowed, ensures good data gets put into the db
+ */
+ public static function validate_type($type) {
- switch ($type) {
- case 'artist':
- case 'album':
- case 'genre':
- case 'song':
- case 'video':
- return $type;
- default:
- return 'song';
- break;
- } // end switch
-
- } // validate_type
-
- /**
- * get_newest
- * This returns an array of the newest artists/albums/whatever
- * in this ampache instance
- */
- public static function get_newest($type,$limit='') {
-
- if (!$limit) { $limit = Config::get('popular_threshold'); }
-
- $type = self::validate_type($type);
- $object_name = ucfirst($type);
-
- $sql = "SELECT DISTINCT(`$type`), MIN(`addition_time`) AS `real_atime` FROM `song` GROUP BY `$type` ORDER BY `real_atime` DESC " .
- "LIMIT $limit";
- $db_results = Dba::read($sql);
-
- $items = array();
-
- while ($row = Dba::fetch_row($db_results)) {
- $items[] = $row['0'];
- } // end while results
-
- return $items;
-
- } // get_newest
+ switch ($type) {
+ case 'artist':
+ case 'album':
+ case 'genre':
+ case 'song':
+ case 'video':
+ return $type;
+ default:
+ return 'song';
+ break;
+ } // end switch
+
+ } // validate_type
+
+ /**
+ * get_newest
+ * This returns an array of the newest artists/albums/whatever
+ * in this ampache instance
+ */
+ public static function get_newest($type,$limit='') {
+
+ if (!$limit) { $limit = Config::get('popular_threshold'); }
+
+ $type = self::validate_type($type);
+ $object_name = ucfirst($type);
+
+ $sql = "SELECT DISTINCT(`$type`), MIN(`addition_time`) AS `real_atime` FROM `song` GROUP BY `$type` ORDER BY `real_atime` DESC " .
+ "LIMIT $limit";
+ $db_results = Dba::read($sql);
+
+ $items = array();
+
+ while ($row = Dba::fetch_row($db_results)) {
+ $items[] = $row['0'];
+ } // end while results
+
+ return $items;
+
+ } // get_newest
} // Stats class
?>