/**
* Delete a Playlist from the database
*
* @param int $id
*/
function wolf_delete_playlist($id = null)
{
$songs = array();
if ($id) {
$id = intval($id);
global $wpdb;
$wolf_jplayer_playlists_table = $wpdb->prefix . 'wolf_jplayer_playlists';
$wolf_jplayer_table = $wpdb->prefix . 'wolf_jplayer';
$playlist = $wpdb->get_row("SELECT * FROM {$wolf_jplayer_playlists_table} WHERE id = {$id}");
$songs = $wpdb->get_results("SELECT * FROM {$wolf_jplayer_table} WHERE playlist_id = {$id}");
if ($playlist) {
$wpdb->query("DELETE FROM {$wolf_jplayer_table} WHERE playlist_id = {$id}");
$wpdb->query("DELETE FROM {$wolf_jplayer_playlists_table} WHERE id = {$id}");
wolf_jpayer_admin_notices(__('Playlist deleted', 'wolf'), 'updated');
} else {
wolf_jpayer_admin_notices(__('The playlist you are trying to delete does not exist.', 'wolf'), 'error');
}
}
// end if id
}
/**
* Manage song
*
* @param int $playlist_id
* @param int $sing_id
*/
function wolf_manage_song($playlist_id = 0, $song_id = null)
{
global $wpdb;
$wolf_jplayer_table = $wpdb->prefix . 'wolf_jplayer';
/* If no errors
----------------------------------------------*/
if (!wolf_error($song_id)) {
/* All good, proceed */
$name = sanitize_text_field($_POST['song_name']);
$artist = sanitize_text_field($_POST['artist']);
$itunes = esc_url($_POST['itunes']);
$amazon = esc_url($_POST['amazon']);
$buy = esc_url($_POST['buy']);
$free = !empty($_POST['free']) ? sanitize_title($_POST['free']) : null;
$mp3_url = esc_url($_POST['mp3']);
$ogg_url = isset($_POST['ogg']) ? esc_url($_POST['ogg']) : null;
$poster = esc_url($_POST['poster']);
if (!$song_id) {
/* Insertion */
$data = array('name' => $name, 'mp3' => $mp3_url, 'ogg' => $ogg_url, 'poster' => $poster, 'artist' => $artist, 'itunes' => $itunes, 'amazon' => $amazon, 'buy' => $buy, 'free' => $free, 'position' => 0, 'playlist_id' => $playlist_id);
$format = array('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%d', '%d');
if ($wpdb->insert($wolf_jplayer_table, $data, $format)) {
$notice_type = 'updated';
$confirm = __('Your song has been added to your playlist.', 'wolf');
} else {
$notice_type = 'error';
$confirm = __('Your song could not be added to your database.', 'wolf');
}
wolf_jpayer_admin_notices($confirm, $notice_type);
} else {
// if update
/* Update */
$data = array('name' => $name, 'ogg' => $ogg_url, 'mp3' => $mp3_url, 'poster' => $poster, 'artist' => $artist, 'itunes' => $itunes, 'amazon' => $amazon, 'buy' => $buy, 'free' => $free);
$format = array('%s');
$conditions = array('id' => $song_id);
$wpdb->update($wolf_jplayer_table, $data, $conditions, $format, array('%d'));
$notice_type = 'updated';
$confirm = __('Your song has been updated.', 'wolf');
wolf_jpayer_admin_notices($confirm, $notice_type);
}
// end if song id
}
// end if error
}