// UPLOAD_ERR_OK = 0 // UPLOAD_ERR_PARTIAL = 3 if (isset($_FILES['music']) && $_FILES['music']['error'] == 0) { $gal_musica = tnb_get_artista_galeria($profileuser->ID, 'music'); $acceptedFormats = array('audio/mpeg', 'audio/x-mpeg', 'audio/mp3', 'audio/x-mp3', 'audio/mpeg3', 'audio/x-mpeg3', 'audio/mpg', 'audio/x-mpg', 'audio/x-mpegaudio'); if (in_array($_FILES['music']['type'], $acceptedFormats)) { $post = array("post_title" => $_POST['music_title'], "post_content" => $_FILES['music']['name'], "post_excerpt" => $_FILES['music']['name'], "post_author" => $profileuser->ID); unset($GLOBALS['post']); $media_id = media_handle_upload('music', $gal_musica->ID, $post); if ($media_id->errors) { $msg['error'][] = implode(' ', $media_id->errors['upload_error']); } if (!$msg['error']) { $meta = get_post_meta($media_id, '_wp_attached_file'); $sizes = get_media_file_sizes($upload_dir . "/" . $meta[0]); $menu_order = count(tnb_get_artista_musicas($profileuser->ID)); $update = array('ID' => $media_id, 'menu_order' => $menu_order); wp_update_post($update); //$albuns = get_user_meta($current_user->ID, 'albuns'); update_post_meta($media_id, '_filesize', $sizes['filesize']); update_post_meta($media_id, '_playtime', $sizes['playtime']); update_post_meta($media_id, '_album', $_POST['music_album']); update_post_meta($media_id, '_download', $_POST['music_download'] ? 1 : 0); if ($_POST['music_principal'] || $menu_order == 0) { tnb_set_artista_musica_principal($profileuser->ID, $media_id); } tnb_cache_unset("ARTISTAS_MUSICAS", $profileuser->ID); } } else { $msg['error'][] = __('Tipo de arquivo não permitido', 'tnb'); }
$obj->count = 0; $obj->day = (string) $day->format($format); $result[(string) $day->format($format)] = $obj; } $obj = new stdClass(); $obj->object_id = ''; $obj->count = 0; $obj->day = $fdate; $result[$fdate] = $obj; return $result; } wp_enqueue_script('jquery-flot', TNB_URL . '/js/flot/jquery.flot.js', array('jquery')); get_header(); $plays = $downloads = array(); $totais = array(); $_musicas = tnb_get_artista_musicas($profileuser->ID); $musicas = array(); foreach ($_musicas as $mus) { $musicas[] = $mus->ID; } $music_ids = implode(',', $musicas); // define a data final: $_GET[fdate] ou CURRENT_DATE() $where = ''; if (isset($_GET['fdate']) && preg_match('/[0-9]{2}\\/[0-9]{2}\\/[0-9]{4}/', $_GET['fdate'])) { $__fdate = $fdate = preg_replace("/([0-9]{2})\\/([0-9]{2})\\/([0-9]{4})/", "\$3-\$2-\$1", $_GET['fdate']); $where .= " AND day <= '{$fdate}'"; } else { $__fdate = date('Y-m-d'); $where .= " AND day <= CURRENT_DATE()"; } // define a data inicial: $_GET[sdate] ou CURRENT_DATE() - 30 dias
protected function update_form() { $profileuser = get_user_by('id', $this->user_id); $formID = uniqid('form'); $musicas = tnb_get_artista_musicas($profileuser->ID); ?> <h3><?php _e('Músicas', 'tnb'); ?> </h3> <label> <?php _e('título', 'tnb'); ?> <input type="text" name='property[title]' value='<?php echo htmlentities(utf8_decode($this->property['title'])); ?> ' /> </label> <hr/> <div id='<?php echo $formID; ?> _exibir'> <?php _e("quais músicas", "tnb"); ?> : <label><input type='radio' name='property[exibir]' value='todas' <?php if ($this->property['exibir'] == 'todas') { echo 'checked="checked"'; } ?> ><?php _e('todas', 'tnb'); ?> </label> <label><input type='radio' name='property[exibir]' value='selecionadas' <?php if ($this->property['exibir'] == 'selecionadas') { echo 'checked="checked"'; } ?> ><?php _e('somente as selecionadas', 'tnb'); ?> </label> </div> <hr/> <div id='<?php echo $formID; ?> _musicas' <?php if ($this->property['exibir'] == 'todas') { echo 'class="hide";'; } ?> > <?php _e('selecione as músicas que deseja exibir', 'tnb'); ?> : <div class='clearfix'> <?php foreach ($musicas as $musica) { ?> <input type="checkbox" id='<?php echo $formID; ?> _widget_musica_<?php echo $musica->ID; ?> _input' name="property[musicas][]" value='<?php echo $musica->ID; ?> ' <?php if (in_array($musica->ID, $this->property['musicas'])) { echo 'checked'; } ?> /> <?php echo $musica->post_title; ?> <br/> <?php } ?> </div> </div> <script type="text/javascript"> jQuery("#<?php echo $formID; ?> _exibir input").change(function (){ if(jQuery(this).val() == 'todas') jQuery("#<?php echo $formID; ?> _musicas").slideUp(); else jQuery("#<?php echo $formID; ?> _musicas").slideDown(); }); </script> <?php }
function tnb_get_artista_musica_principal($artista_id) { if (tnb_cache_exists('ARTISTAS_MUSICA_PRINCIPAL', $artista_id)) { return tnb_cache_get('ARTISTAS_MUSICA_PRINCIPAL', $artista_id); } global $wpdb; $result = $wpdb->get_row("SELECT {$wpdb->posts}.* FROM {$wpdb->posts}, {$wpdb->usermeta} WHERE {$wpdb->posts}.ID = {$wpdb->usermeta}.meta_value AND {$wpdb->usermeta}.meta_key = '_musica_principal' AND {$wpdb->usermeta}.user_id = '{$artista_id}'"); // echo "SELECT $wpdb->posts.* FROM $wpdb->posts, $wpdb->usermeta WHERE $wpdb->posts.ID = $wpdb->usermeta.meta_value AND $wpdb->usermeta.meta_key = '_musica_principal' AND $wpdb->usermeta.user_id = '$artista_id'"; if (!$result) { $musicas = tnb_get_artista_musicas($artista_id); if (count($musicas)) { tnb_set_artista_musica_principal($artista_id, $musicas[0]->ID); } } tnb_cache_set('ARTISTAS_MUSICA_PRINCIPAL', $artista_id, $result); return $result; }