diff options
| author | Paul Arthur <paul.arthur@flowerysong.com> | 2013-01-25 21:08:24 -0500 |
|---|---|---|
| committer | Paul Arthur <paul.arthur@flowerysong.com> | 2013-01-25 21:45:47 -0500 |
| commit | 1069d54c85149ff1cb51563d6a1fc471695f8b47 (patch) | |
| tree | e5c22762ef4d6c90dcdb3646a04de26e21ad071c /lib/class/shoutbox.class.php | |
| parent | cad1380737f7ffcfa82d46ab3066823435a48a5d (diff) | |
| download | ampache-1069d54c85149ff1cb51563d6a1fc471695f8b47.tar.gz ampache-1069d54c85149ff1cb51563d6a1fc471695f8b47.tar.bz2 ampache-1069d54c85149ff1cb51563d6a1fc471695f8b47.zip | |
Move clean functions into their respective classes
Uniformly name them gc()
Diffstat (limited to 'lib/class/shoutbox.class.php')
| -rw-r--r-- | lib/class/shoutbox.class.php | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/lib/class/shoutbox.class.php b/lib/class/shoutbox.class.php index ce85813d..3cface18 100644 --- a/lib/class/shoutbox.class.php +++ b/lib/class/shoutbox.class.php @@ -60,6 +60,17 @@ class shoutBox { } // _get_info /** + * gc + * + * Cleans out orphaned shoutbox items + */ + public static function gc() { + foreach(array('song', 'album', 'artist') as $object_type) { + Dba::write("DELETE FROM `user_shout` USING `user_shout` LEFT JOIN `$object_type` ON `$object_type`.`id` = `user_shout`.`object_id` WHERE `$object_type`.`id` IS NULL AND `user_shout`.`object_type` = '$object_type'"); + } + } + + /** * get_top * This returns the top user_shouts, shoutbox objects are always shown regardless and count against the total * number of objects shown |