'; return $output; } //display a list of the most frequently play tracks and number of times played since a given date function playlist_most_played($limit = 10, $start_date = "2011-01-01 00:00:00", $end_date = null, $include_date = false) { global $wpdb; //fetch the requested number of playlist songs, and their album info $query = "SELECT `artist`, `track`, `artist_id`, `album_id`, COUNT(*) AS `count` FROM ".$wpdb->prefix."playlist WHERE `time` >= UNIX_TIMESTAMP('".$start_date."') "; if($end_date) { $query .= "AND `time` <= UNIX_TIMESTAMP('".$end_date."') "; } $query .= "GROUP BY `track` ORDER BY `count` DESC LIMIT ".$limit; $entries = $wpdb->get_results($query); //generate the output $output = ''; return $output; } /* Because Wordpress doesn't handle dates in a way that makes any sense whatsoever, * and returns everything in UTC no matter what you do, we have to work around this. * This function is a modification of current_time_fixed() from the Wordpress Codex: * http://codex.wordpress.org/Function_Reference/current_time */ function playlist_time_fixed( $time, $type, $date_format = "Y-m-d H:m:i", $gmt = 0 ) { $t = ( $gmt ) ? gmdate( $date_format ) : gmdate( $date_format, ( $time + ( get_option( 'gmt_offset' ) * 3600 ) ) ); switch ( $type ) { case 'mysql': return $t; break; case 'timestamp': return strtotime($t); break; } } //insert a playlist entry into the databasee function playlist_insert($artist, $track) { global $wpdb; //check that the insertion request is comming from the allowed IP address (if it has been specified) $securityCheck = get_option('playlist_allowed_ip'); if($securityCheck != '') { if($_SERVER['REMOTE_ADDR'] != $securityCheck) { return false; } } $artist_id = null; $album_id = null; //$now = current_time("timestamp"); $now = time(); //time() always returns server time... mktime() gets overwritten //$now = strtotime(gmdate( "Y-m-d H:m:i" )); //mktime() gets overridden by Wordpress core //first, look to see if we have the track in the database //fix word ordering problems with "the" if(substr($artist, -5) == ", The") { $artist = "The ".str_replace(", The", "", $artist); } //if the artist comes in with the format "lastname, firstname", fix that. if(strstr($artist, ",")) { $snip = explode(",", $artist); $fixName = implode(" ", array_reverse($snip)); $snipAgain = explode(" ", $fixName); if(empty($snipAgain[0])) { unset($snipAgain[0]); } $artist = implode(" ", $snipAgain); } //the artists and tracks sometimes come in with quotes and apostrophes escaped... not good for matching $find = array("\\\"", "\\'"); $replace = array("\"", "'"); $track = str_replace($find, $replace, $track); $artist = str_replace($find, $replace, $artist); //find the artist's taxonomy id $slug = sanitize_title_with_dashes($artist); $taxCheck = playlist_check_for_artist($artist); if($taxCheck) { //get a list of albums for that taxonomy $albumCheck = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."posts AS `posts` JOIN ".$wpdb->prefix."term_relationships AS `tax` ON `posts`.`ID` = `tax`.`object_id` WHERE `tax`.`term_taxonomy_id` = '".$taxCheck->term_taxonomy_id."'"); //get the track list for each album $albums = array(); if(!empty($albumCheck)) { foreach($albumCheck as $album) { $trackCheck = $wpdb->get_results("SELECT `meta`.`meta_value` FROM ".$wpdb->prefix."posts AS `posts` JOIN ".$wpdb->prefix."postmeta AS `meta` ON `posts`.`ID` = `meta`.`post_id` WHERE `meta`.`meta_key` = 'track' AND `posts`.`ID` = ".$album->ID); $tracks = array(); foreach($trackCheck as $addTrack) { $tracks[] = strval($addTrack->meta_value); } $albums[] = array('title' => $album->post_title, 'album_slug' => $album->post_name, 'album_id' => $album->ID, 'artist_id' => $taxCheck->term_taxonomy_id, 'tracks' => $tracks); } } //see if we can find the track we're looking for in the results foreach($albums as $album) { foreach($album['tracks'] as $checkTrack) { if($album_id != null) { continue; //if we've already found it, we can move on } $formatedTrack = strtolower($track); $formatedCheckTrack = str_replace($find, $replace, strtolower($checkTrack)); if(stristr($formatedCheckTrack, $formatedTrack)) { $artist_id = $album['artist_id']; $album_id = $album['album_id']; } } } } else { //we'll need to create the artist record $newArtist = playlist_fetch_new_artist_data($artist); //try to match the entry to the new artist data if(isset($newArtist['albums'])) { foreach($newArtist['albums'] as $album) { foreach($album['tracks'] as $checkTrack) { if($album_id != null) { continue; //if we've already found it, we can move on } $checkTrack = str_replace($find, $replace, strtolower($checkTrack)); if(stristr($checkTrack, strtolower($track))) { $artist_id = $newArtist['artist_id']; $album_id = $album['album_id']; } } } } } //insert the playlist entry $rows_affected = $wpdb->insert( $wpdb->prefix.'playlist', array('time' => $now, 'artist' => $artist, 'track' => $track, 'artist_id' => $artist_id, 'album_id' => $album_id) ); return true; } //insert a new Artist record into the database function playlist_fetch_new_artist_data($artist) { global $wpdb; $siteurl = get_option('siteurl'); $newArtist = array(); $info = new AudioscrobblerComponent(); $artistData = $info->topAlbumsForArtist($artist); //if the artist has no albums we're pretty much done here if(empty($artistData->topalbums->album)) { return false; } $newArtist['name'] = $artist; $newArtist['albums'] = array(); //if we found albums, let's process them into something useful $albums = array(); $found = array(); foreach($artistData->topalbums->album as $album) { $albumData = $info->artistAlbum($artist, strval($album->name)); // If LastFM doesn't know anything about this album skip over it if (!$albumData) { continue; } // If there aren't any tracks for this album, or it's a single it's useless if (count($albumData->album->tracks->track) <= 1) { continue; } //LastFM tends to have duplicates... let's weed those out and save ourselves some time. if(in_array(strtolower(strval($album->name)), $found)) { continue; } else { $found[] = strtolower(strval($album->name)); } $tracks = array(); foreach($albumData->album->tracks->track as $track) { $tracks[] = strval($track->name); } $newArtist['albums'][] = array( 'name' => strval($album->name), 'coverart' => strval($albumData->album->image[3]), 'tracks' => $tracks ); } //insert into the database foreach($newArtist['albums'] as $i => $album) { //check that the album doesn't already exist $post_slug = sanitize_title_with_dashes($newArtist['name']).'-'.sanitize_title_with_dashes($album['name']); $postCheck = $wpdb->get_row("SELECT * FROM ".$wpdb->prefix."posts AS `posts` WHERE `posts`.`post_name` = '".$post_slug."'"); if($postCheck) { continue; //if the album is already there, we can jump to the next one on the list } //insert a new post for the album $albumdata = array(); $albumdata = array( 'post_author' => 1, 'post_date' => current_time('mysql'), 'post_date_gmt' => current_time('mysql'), 'post_title' => $album['name'], 'post_status' => 'publish', 'comment_status' => 'closed', 'ping_status' => 'closed', 'post_type' => 'artistalbum', 'post_name' => $post_slug, 'post_modified' => current_time('mysql'), 'post_modified_gmt' => current_time('mysql') ); $rows_affected = $wpdb->insert( $wpdb->prefix.'posts', $albumdata ); //get the id of the new post $albumID = mysql_insert_id(); //create the artist taxonomy if it doesn't exist and add it to the post $slug = sanitize_title_with_dashes($newArtist['name']); $taxCheck = $wpdb->get_row("SELECT * FROM ".$wpdb->prefix."terms AS `terms` JOIN ".$wpdb->prefix."term_taxonomy AS `tax` ON `terms`.`term_id` = `tax`.`term_id` WHERE `terms`.`slug` = '".$slug."' AND `tax`.`taxonomy` = 'artists'"); if(!$taxCheck) { $rows_affected = $wpdb->insert( $wpdb->prefix.'terms', array('name' => $newArtist['name'], 'slug' => $slug, 'term_group' => 0) ); $termID = mysql_insert_id(); $rows_affected = $wpdb->insert( $wpdb->prefix.'term_taxonomy', array('term_id' => $termID, 'taxonomy' => 'artists', 'description' => '', 'parent' => 0, 'count' => 0) ); $termTaxID = mysql_insert_id(); $rows_affected = $wpdb->insert( $wpdb->prefix.'term_relationships', array('object_id' => $albumID, 'term_taxonomy_id' => $termTaxID, 'term_order' => 0) ); $newArtist['artist_id'] = $termTaxID; } else { //if the artist already exists, just grab the appropriate IDs $termTaxCheck = $wpdb->get_row("SELECT * FROM ".$wpdb->prefix."term_taxonomy AS `termtax` WHERE `termtax`.`term_id` = '".$taxCheck->term_id."'"); $rows_affected = $wpdb->insert( $wpdb->prefix.'term_relationships', array('object_id' => $albumID, 'term_taxonomy_id' => $termTaxCheck->term_taxonomy_id, 'term_order' => 0) ); $newArtist['artist_id'] = $termTaxCheck->term_taxonomy_id; } //add the coverart if($album['coverart'] != '') { $artDir = 'wp-content/uploads/artistalbum/'; if(!file_exists(ABSPATH.$artDir)) { mkdir(ABSPATH.$artDir); } $ext = array_pop(explode(".", $album['coverart'])); $new_filename = 'albumart'.$albumID.".".$ext; copy($album['coverart'], ABSPATH.$artDir.$new_filename); $file_info = getimagesize(ABSPATH.$artDir.$new_filename); $artdata = array(); $artdata = array( 'post_author' => 1, 'post_date' => current_time('mysql'), 'post_date_gmt' => current_time('mysql'), 'post_title' => $album['name'].' cover', 'post_status' => 'inherit', 'comment_status' => 'closed', 'ping_status' => 'closed', 'post_type' => 'artistalbum', 'post_name' => sanitize_title_with_dashes($newArtist['name']).'-'.sanitize_title_with_dashes($album['name']).'-cover', 'post_modified' => current_time('mysql'), 'post_modified_gmt' => current_time('mysql'), 'post_parent' => $albumID, 'post_type' => 'attachment', 'guid' => $siteurl.'/'.$artDir.$new_filename, 'post_mime_type' => $file_info['mime'] ); $rows_affected = $wpdb->insert( $wpdb->prefix.'posts', $artdata ); $artID = mysql_insert_id(); $rows_affected = $wpdb->insert( $wpdb->prefix.'postmeta', array('post_id' => $albumID, 'meta_key' => '_thumbnail_id', 'meta_value' => $artID) ); $rows_affected = $wpdb->insert( $wpdb->prefix.'postmeta', array('post_id' => $artID, 'meta_key' => '_wp_attached_file', 'meta_value' => 'artistalbum/'.$new_filename) ); } //insert the track listing into post_meta foreach($album['tracks'] as $track) { $rows_affected = $wpdb->insert( $wpdb->prefix.'postmeta', array('post_id' => $albumID, 'meta_key' => 'track', 'meta_value' => $track) ); } $newArtist['albums'][$i]['album_id'] = $albumID; } return $newArtist; } function playlist_update_artist_data($artist, $artist_id) { global $wpdb; $siteurl = get_option('siteurl'); $newArtist = array(); $info = new AudioscrobblerComponent(); $artistData = $info->topAlbumsForArtist($artist); //if the artist has no albums we're pretty much done here if(empty($artistData->topalbums->album)) { return false; } $newArtist['name'] = $artist; $newArtist['albums'] = array(); //if we found albums, let's process them into something useful $albums = array(); $found = array(); foreach($artistData->topalbums->album as $album) { $albumData = $info->artistAlbum($artist, strval($album->name)); // If LastFM doesn't know anything about this album skip over it if (!$albumData) { continue; } // If there aren't any tracks for this album, or it's a single it's useless if (count($albumData->album->tracks->track) <= 1) { continue; } //LastFM tends to have duplicates... let's weed those out and save ourselves some time. if(in_array(strtolower(strval($album->name)), $found)) { continue; } else { $found[] = strtolower(strval($album->name)); } $tracks = array(); foreach($albumData->album->tracks->track as $track) { $tracks[] = strval($track->name); } $newArtist['albums'][] = array( 'name' => strval($album->name), 'coverart' => strval($albumData->album->image[3]), 'tracks' => $tracks ); } $saved = array(); //insert into the database foreach($newArtist['albums'] as $i => $album) { //check that the album doesn't already exist $post_slug = sanitize_title_with_dashes($newArtist['name']).'-'.sanitize_title_with_dashes($album['name']); $postCheck = $wpdb->get_row("SELECT * FROM ".$wpdb->prefix."posts AS `posts` WHERE `posts`.`post_name` = '".$post_slug."'"); if($postCheck) { continue; //if the album is already there, we can jump to the next one on the list } //insert a new post for the album $albumdata = array(); $albumdata = array( 'post_author' => 1, 'post_date' => current_time('mysql'), 'post_date_gmt' => current_time('mysql'), 'post_title' => $album['name'], 'post_status' => 'publish', 'comment_status' => 'closed', 'ping_status' => 'closed', 'post_type' => 'artistalbum', 'post_name' => $post_slug, 'post_modified' => current_time('mysql'), 'post_modified_gmt' => current_time('mysql') ); $rows_affected = $wpdb->insert( $wpdb->prefix.'posts', $albumdata ); //get the id of the new post $albumID = mysql_insert_id(); //add the artist $rows_affected = $wpdb->insert( $wpdb->prefix.'term_relationships', array('object_id' => $albumID, 'term_taxonomy_id' => $artist_id, 'term_order' => 0) ); $newArtist['artist_id'] = $artist_id; //add the coverart if($album['coverart'] != '') { $artDir = 'wp-content/uploads/artistalbum/'; if(!file_exists(ABSPATH.$artDir)) { mkdir(ABSPATH.$artDir); } $ext = array_pop(explode(".", $album['coverart'])); $new_filename = 'albumart'.$albumID.".".$ext; copy($album['coverart'], ABSPATH.$artDir.$new_filename); $file_info = getimagesize(ABSPATH.$artDir.$new_filename); $artdata = array(); $artdata = array( 'post_author' => 1, 'post_date' => current_time('mysql'), 'post_date_gmt' => current_time('mysql'), 'post_title' => $album['name'].' cover', 'post_status' => 'inherit', 'comment_status' => 'closed', 'ping_status' => 'closed', 'post_type' => 'artistalbum', 'post_name' => sanitize_title_with_dashes($newArtist['name']).'-'.sanitize_title_with_dashes($album['name']).'-cover', 'post_modified' => current_time('mysql'), 'post_modified_gmt' => current_time('mysql'), 'post_parent' => $albumID, 'post_type' => 'attachment', 'guid' => $siteurl.'/'.$artDir.$new_filename, 'post_mime_type' => $file_info['mime'] ); $rows_affected = $wpdb->insert( $wpdb->prefix.'posts', $artdata ); $artID = mysql_insert_id(); $rows_affected = $wpdb->insert( $wpdb->prefix.'postmeta', array('post_id' => $albumID, 'meta_key' => '_thumbnail_id', 'meta_value' => $artID) ); $rows_affected = $wpdb->insert( $wpdb->prefix.'postmeta', array('post_id' => $artID, 'meta_key' => '_wp_attached_file', 'meta_value' => 'artistalbum/'.$new_filename) ); } //insert the track listing into post_meta foreach($album['tracks'] as $track) { $rows_affected = $wpdb->insert( $wpdb->prefix.'postmeta', array('post_id' => $albumID, 'meta_key' => 'track', 'meta_value' => $track) ); } $saved[] = $album['name']; } return $saved; } function playlist_check_for_artist($artist) { global $wpdb; //find the artist's taxonomy id $taxCheck = $wpdb->get_row("SELECT * FROM ".$wpdb->prefix."terms AS `terms` JOIN ".$wpdb->prefix."term_taxonomy AS `tax` ON `terms`.`term_id` = `tax`.`term_id` WHERE `terms`.`name` = '".$artist."' AND `tax`.`taxonomy` = 'artists' LIMIT 1"); //if an exact match doesn't work, let's give things a little more leeway if(!$taxCheck) { $taxCheck = $wpdb->get_row("SELECT * FROM ".$wpdb->prefix."terms AS `terms` JOIN ".$wpdb->prefix."term_taxonomy AS `tax` ON `terms`.`term_id` = `tax`.`term_id` WHERE `terms`.`name` LIKE '%".$artist."%' AND `tax`.`taxonomy` = 'artists' LIMIT 1"); if($taxCheck) { return $taxCheck; } else { return false; } } else { return $taxCheck; } } //admin function to automatically import or update data from Last.FM function playlist_options_page() { // Process the form submission if (isset($_POST['wpms_action']) && $_POST['wpms_action'] == __('Submit', 'playlist') && isset($_POST['artist'])) { $artist = $_POST['artist']; $taxCheck = playlist_check_for_artist($artist); if(!$taxCheck) { $result = playlist_fetch_new_artist_data($artist); } else { $result = playlist_update_artist_data($artist, $taxCheck->term_taxonomy_id); //$result = $taxCheck; } // Output the response ?> ' . __( 'Settings', 'playlist217' ) . ''; array_unshift( $links, $settings_link ); return $links; } ?>