diff options
Diffstat (limited to 'lib/class/shoutbox.class.php')
| -rw-r--r-- | lib/class/shoutbox.class.php | 304 |
1 files changed, 152 insertions, 152 deletions
diff --git a/lib/class/shoutbox.class.php b/lib/class/shoutbox.class.php index 42adec08..0bd12070 100644 --- a/lib/class/shoutbox.class.php +++ b/lib/class/shoutbox.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) @@ -22,211 +22,211 @@ class Shoutbox { - public $id; + public $id; - /** - * Constructor - * This pulls the shoutbox information from the database and returns - * a constructed object, uses user_shout table - */ - public function __construct($shout_id) { + /** + * Constructor + * This pulls the shoutbox information from the database and returns + * a constructed object, uses user_shout table + */ + public function __construct($shout_id) { - // Load the data from the database - $this->_get_info($shout_id); + // Load the data from the database + $this->_get_info($shout_id); - return true; + return true; - } // Constructor + } // Constructor - /** - * _get_info - * does the db call, reads from the user_shout table - */ - private function _get_info($shout_id) { + /** + * _get_info + * does the db call, reads from the user_shout table + */ + private function _get_info($shout_id) { - $sticky_id = Dba::escape($shout_id); + $sticky_id = Dba::escape($shout_id); - $sql = "SELECT * FROM `user_shout` WHERE `id`='$shout_id'"; - $db_results = Dba::read($sql); + $sql = "SELECT * FROM `user_shout` WHERE `id`='$shout_id'"; + $db_results = Dba::read($sql); - $data = Dba::fetch_assoc($db_results); + $data = Dba::fetch_assoc($db_results); - foreach ($data as $key=>$value) { - $this->$key = $value; - } + foreach ($data as $key=>$value) { + $this->$key = $value; + } - return true; + return true; - } // _get_info + } // _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'"); - } - } + /** + * 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 - */ - public static function get_top($limit) { + /** + * get_top + * This returns the top user_shouts, shoutbox objects are always shown regardless and count against the total + * number of objects shown + */ + public static function get_top($limit) { - $shouts = self::get_sticky(); + $shouts = self::get_sticky(); - // If we've already got too many stop here - if (count($shouts) > $limit) { - $shouts = array_slice($shouts,0,$limit); - return $shouts; - } + // If we've already got too many stop here + if (count($shouts) > $limit) { + $shouts = array_slice($shouts,0,$limit); + return $shouts; + } - // Only get as many as we need - $limit = intval($limit) - count($shouts); - $sql = "SELECT * FROM `user_shout` WHERE `sticky`='0' ORDER BY `date` DESC LIMIT $limit"; - $db_results = Dba::read($sql); + // Only get as many as we need + $limit = intval($limit) - count($shouts); + $sql = "SELECT * FROM `user_shout` WHERE `sticky`='0' ORDER BY `date` DESC LIMIT $limit"; + $db_results = Dba::read($sql); - while ($row = Dba::fetch_assoc($db_results)) { - $shouts[] = $row['id']; - } + while ($row = Dba::fetch_assoc($db_results)) { + $shouts[] = $row['id']; + } - return $shouts; + return $shouts; - } // get_top + } // get_top - /** - * get_sticky - * This returns all current sticky shoutbox items - */ - public static function get_sticky() { + /** + * get_sticky + * This returns all current sticky shoutbox items + */ + public static function get_sticky() { - $sql = "SELECT * FROM `user_shout` WHERE `sticky`='1' ORDER BY `date` DESC"; - $db_results = Dba::read($sql); + $sql = "SELECT * FROM `user_shout` WHERE `sticky`='1' ORDER BY `date` DESC"; + $db_results = Dba::read($sql); - $results = array(); + $results = array(); - while ($row = Dba::fetch_assoc($db_results)) { - $results[] = $row['id']; - } + while ($row = Dba::fetch_assoc($db_results)) { + $results[] = $row['id']; + } - return $results; + return $results; - } // get_sticky + } // get_sticky - /** - * get_object - * This takes a type and an ID and returns a created object - */ - public static function get_object($type,$object_id) { + /** + * get_object + * This takes a type and an ID and returns a created object + */ + public static function get_object($type,$object_id) { - $allowed_objects = array('song','genre','album','artist','radio'); + $allowed_objects = array('song','genre','album','artist','radio'); - if (!in_array($type,$allowed_objects)) { - return false; - } + if (!in_array($type,$allowed_objects)) { + return false; + } - $object = new $type($object_id); + $object = new $type($object_id); - return $object; + return $object; - } // get_object + } // get_object - /** - * get_image - * This returns an image tag if the type of object we're currently rolling with - * has an image associated with it - */ - public function get_image() { + /** + * get_image + * This returns an image tag if the type of object we're currently rolling with + * has an image associated with it + */ + public function get_image() { - switch ($this->object_type) { - case 'album': - $image_string = "<img class=\"shoutboximage\" height=\"75\" width=\"75\" src=\"" . Config::get('web_path') . "/image.php?id=" . $this->object_id . "&thumb=1\" />"; - break; - case 'artist': + switch ($this->object_type) { + case 'album': + $image_string = "<img class=\"shoutboximage\" height=\"75\" width=\"75\" src=\"" . Config::get('web_path') . "/image.php?id=" . $this->object_id . "&thumb=1\" />"; + break; + case 'artist': - break; - case 'song': - $song = new Song($this->object_id); - $image_string = "<img class=\"shoutboximage\" height=\"75\" width=\"75\" src=\"" . Config::get('web_path') . "/image.php?id=" . $song->album . "&thumb=1\" />"; - break; - default: - // Rien a faire - break; - } // end switch + break; + case 'song': + $song = new Song($this->object_id); + $image_string = "<img class=\"shoutboximage\" height=\"75\" width=\"75\" src=\"" . Config::get('web_path') . "/image.php?id=" . $song->album . "&thumb=1\" />"; + break; + default: + // Rien a faire + break; + } // end switch - return $image_string; + return $image_string; - } // get_image + } // get_image - /** - * create - * This takes a key'd array of data as input and inserts a new shoutbox entry, it returns the auto_inc id - */ - public static function create($data) { + /** + * create + * This takes a key'd array of data as input and inserts a new shoutbox entry, it returns the auto_inc id + */ + public static function create($data) { - $user = Dba::escape($GLOBALS['user']->id); - $text = Dba::escape(strip_tags($data['comment'])); - $date = time(); - $sticky = isset($data['sticky']) ? 1 : 0; - $object_id = Dba::escape($data['object_id']); - $object_type = Dba::escape($data['object_type']); + $user = Dba::escape($GLOBALS['user']->id); + $text = Dba::escape(strip_tags($data['comment'])); + $date = time(); + $sticky = isset($data['sticky']) ? 1 : 0; + $object_id = Dba::escape($data['object_id']); + $object_type = Dba::escape($data['object_type']); - $sql = "INSERT INTO `user_shout` (`user`,`date`,`text`,`sticky`,`object_id`,`object_type`) " . - "VALUES ('$user','$date','$text','$sticky','$object_id','$object_type')"; - $db_results = Dba::write($sql); + $sql = "INSERT INTO `user_shout` (`user`,`date`,`text`,`sticky`,`object_id`,`object_type`) " . + "VALUES ('$user','$date','$text','$sticky','$object_id','$object_type')"; + $db_results = Dba::write($sql); - $insert_id = Dba::insert_id(); + $insert_id = Dba::insert_id(); - return $insert_id; + return $insert_id; - } // create + } // create - /** - * update - * This takes a key'd array of data as input and updates a shoutbox entry - */ - public static function update($data) { + /** + * update + * This takes a key'd array of data as input and updates a shoutbox entry + */ + public static function update($data) { - $id = Dba::escape($data['shout_id']); - $text = Dba::escape(strip_tags($data['comment'])); - $sticky = make_bool($data['sticky']); + $id = Dba::escape($data['shout_id']); + $text = Dba::escape(strip_tags($data['comment'])); + $sticky = make_bool($data['sticky']); - $sql = "UPDATE `user_shout` SET `text`='$text', `sticky`='$sticky' WHERE `id`='$id'"; - $db_results = Dba::write($sql); + $sql = "UPDATE `user_shout` SET `text`='$text', `sticky`='$sticky' WHERE `id`='$id'"; + $db_results = Dba::write($sql); - return true; + return true; - } // create + } // create - /** - * format - * this function takes the object and reformats some values - */ + /** + * format + * this function takes the object and reformats some values + */ - public function format() { - $this->sticky = ($this->sticky == "0") ? 'No' : 'Yes'; - $this->date = date("m\/d\/Y - H:i", $this->date); - return true; + public function format() { + $this->sticky = ($this->sticky == "0") ? 'No' : 'Yes'; + $this->date = date("m\/d\/Y - H:i", $this->date); + return true; - } //format + } //format - /** - * delete - * this function deletes a specific shoutbox entry - */ + /** + * delete + * this function deletes a specific shoutbox entry + */ - public function delete($shout_id) { + public function delete($shout_id) { - // Delete the shoutbox post - $shout_id = Dba::escape($shout_id); - $sql = "DELETE FROM `user_shout` WHERE `id`='$shout_id'"; - $db_results = Dba::write($sql); + // Delete the shoutbox post + $shout_id = Dba::escape($shout_id); + $sql = "DELETE FROM `user_shout` WHERE `id`='$shout_id'"; + $db_results = Dba::write($sql); - } // delete + } // delete } // Shoutbox class ?> |