show_errors(); $player_table = $wpdb->prefix . "mvp_players"; $stmt = $wpdb->prepare("SELECT preset, options FROM {$player_table} WHERE id = %d", $player_id); $result = $wpdb->get_row($stmt, ARRAY_A); $default_options = mvp_player_options(); $preset_options = mvp_player_options_preset(); $player_options = unserialize($result['options']); $preset = $result["preset"]; $preset = mvp_checkPreset($preset); $options = $player_options + $default_options + $preset_options[$preset]; if($stmt !== false){ echo json_encode($options); } wp_die(); }else{ wp_die(); } } //############################################// /* meta */ //############################################// function mvp_add_metabox_shortcode() { wp_enqueue_script("mvp-metabox", plugins_url('/js/admin_global.js', __FILE__), array('jquery')); wp_enqueue_script("mvp-metabox-shortcode", plugins_url('/js/admin_shortcode.js', __FILE__), array('jquery')); wp_localize_script('mvp-metabox-shortcode', 'mvp_data', array('plugins_url' => plugins_url('', __FILE__), 'ajax_url' => admin_url( 'admin-ajax.php'), 'security' => wp_create_nonce( 'mvp-security-nonce' ))); $id = 'mvp-metabox-shortcode'; $title = 'Ultimate Video Gallery Shortcode Generator'; $posts = array('post', 'page'); $args = array( 'public' => true, '_builtin' => false ); $custom_post_types = get_post_types($args); foreach ($custom_post_types as $screen){ $posts[] = $screen; } foreach ($posts as $screen){ add_filter( "postbox_classes_{$screen}_{$id}", 'mvp_minify_my_metabox' ); } add_meta_box($id, $title, 'mvp_shortcode_metabox_data', $posts, 'normal', 'low'); } function mvp_shortcode_metabox_data() { global $wpdb; $wpdb->show_errors(); $player_table = $wpdb->prefix . "mvp_players"; $playlist_table = $wpdb->prefix . "mvp_playlists"; $global_ad_table = $wpdb->prefix . "mvp_global_ad"; include("includes/shortcode_manager.php"); } function mvp_minify_my_metabox( $classes ) { array_push( $classes, 'closed' ); return $classes; } //############################################// /* statistics */ //############################################// function mvp_get_stat_data(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['type'])){ $type = $_POST["type"]; if($type == 'player'){ $player_id = $_POST["type_id"]; }else if($type == 'playlist'){ $playlist_id = $_POST["type_id"]; $data = array( 'results' => mvp_getAll($playlist_id, null, 'title'), 'total' => mvp_getTotal($playlist_id), 'top_day' => mvp_getTopPlayToday($playlist_id), 'top_day_grand_total' => mvp_getTopPlayLastXDaysTotal(null, $playlist_id, 30), 'top_week' => mvp_getTopPlayThisWeek($playlist_id), 'top_month' => mvp_getTopPlayThisMonth($playlist_id), 'top_plays' => mvp_getTopPlayAllTime($playlist_id), 'top_downloads' => mvp_getTopDownloadAllTime($playlist_id), 'top_finish' => mvp_getTopFinishAllTime($playlist_id), 'top_plays_country' => mvp_getTopPlaysPerCountryAllTime($playlist_id), 'top_plays_user' => mvp_getTopPlaysPerUserAllTime($playlist_id), ); } echo json_encode($data); wp_die(''); }else { wp_die(''); } } function mvp_stat_create_graph(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['media_id'])){ $media_id = $_POST["media_id"]; $title = stripslashes($_POST['title']); $return_days = $_POST["return_days"]; $data_display = json_decode(stripcslashes($_POST['data_display']), true); global $wpdb; $wpdb->show_errors(); $statistics_table = $wpdb->prefix . "mvp_statistics"; $results = mvp_getTotalLastXDays($media_id, $title, $return_days, $data_display); echo json_encode($results); wp_die(''); }else { wp_die(''); } } function mvp_play_count(){ if(isset($_POST['media_id']) && isset($_POST['playlist_id'])){ $media_id = (int)$_POST["media_id"]; $playlist_id = (int)$_POST["playlist_id"]; $date = date("Y-m-d"); $title = stripslashes($_POST['title']); $thumb = stripslashes($_POST['thumb']); $currentTime = (int)$_POST['currentTime']; $duration = (int)$_POST['duration']; $percentToCountAsPlay = $_POST['percentToCountAsPlay']; $countryData = isset($_POST['countryData']) ? json_decode(stripcslashes($_POST['countryData']), true) : null; $video_url = stripslashes($_POST['video_url']); $percent = $duration / (100 / $percentToCountAsPlay); if($currentTime > $percent){ $play_add = 1; } else { $play_add = 0; } global $wpdb; $statistics_table = $wpdb->prefix . "mvp_statistics"; $statistics_country_table = $wpdb->prefix . "mvp_statistics_country"; $statistics_country_play_table = $wpdb->prefix . "mvp_statistics_country_play"; $statistics_user_table = $wpdb->prefix . "mvp_statistics_user"; $statistics_user_play_table = $wpdb->prefix . "mvp_statistics_user_play"; //check if exist $wpdb->get_row($wpdb->prepare("SELECT id FROM $statistics_table WHERE media_id=%d AND title=%s AND c_date=%s", $media_id, $title, $date)); if($wpdb->num_rows == 0){//create entry $stmt = $wpdb->query("INSERT INTO $statistics_table (title, c_play, c_time, c_download, c_finish, c_date, media_id, playlist_id) VALUES ('$title', 1, '$currentTime', 0, 0, '$date', '$media_id', '$playlist_id')"); }else{//update $stmt = $wpdb->query($wpdb->prepare("UPDATE $statistics_table SET c_play=c_play+$play_add, c_time=c_time+%d WHERE media_id=%d AND title=%s AND c_date=%s LIMIT 1", $currentTime, $media_id, $title, $date)); } //country if(isset($countryData) && !empty($countryData)){ $stmt = $wpdb->get_var($wpdb->prepare("SELECT id FROM $statistics_country_table WHERE country_code=%s", $countryData['country_code'])); if($wpdb->num_rows == 0){ $country = $countryData['country']; $country_code = $countryData['country_code']; $continent = $countryData['continent']; $wpdb->query("INSERT INTO $statistics_country_table (country, country_code, continent) VALUES ('$country', '$country_code', '$continent')"); $country_id = $wpdb->insert_id; }else{ $country_id = $stmt; } $wpdb->get_row($wpdb->prepare("SELECT id FROM $statistics_country_play_table WHERE media_id=%d AND title=%s AND c_date=%s AND country_id=%d", $media_id, $title, $date, $country_id)); if($wpdb->num_rows == 0){ $wpdb->query("INSERT INTO $statistics_country_play_table (title, thumb, video_url, c_play, c_time, c_date, media_id, playlist_id, country_id) VALUES ('$title', '$thumb', '$video_url', 1, '$currentTime', '$date', '$media_id', '$playlist_id', '$country_id')"); }else{//update $wpdb->query($wpdb->prepare("UPDATE $statistics_country_play_table SET c_play=c_play+$play_add, c_time=c_time+%d WHERE media_id=%d AND title=%s AND c_date=%s AND country_id=%d LIMIT 1", $currentTime, $media_id, $title, $date, $country_id)); } } //user if(is_user_logged_in()){ $current_user = wp_get_current_user(); $stmt = $wpdb->get_var($wpdb->prepare("SELECT id FROM $statistics_user_table WHERE user_id=%s", $current_user->ID)); if($wpdb->num_rows == 0){ $uid = $current_user->ID; $user_display_name = $current_user->display_name; $user_role = implode(",", $current_user->roles); $wpdb->query("INSERT INTO $statistics_user_table (user_id, user_display_name, user_role) VALUES ('$uid', '$user_display_name', '$user_role')"); $user_id = $wpdb->insert_id; }else{ $user_id = $stmt; } $wpdb->get_row($wpdb->prepare("SELECT id FROM $statistics_user_play_table WHERE media_id=%d AND title=%s AND c_date=%s AND user_id=%d", $media_id, $title, $date, $user_id)); if($wpdb->num_rows == 0){ $wpdb->query("INSERT INTO $statistics_user_play_table (title, thumb, video_url, c_play, c_time, c_date, media_id, playlist_id, user_id) VALUES ('$title', '$thumb', '$video_url', 1, '$currentTime', '$date', '$media_id', '$playlist_id', '$user_id')"); }else{//update $wpdb->query($wpdb->prepare("UPDATE $statistics_user_play_table SET c_play=c_play+$play_add, c_time=c_time+%d WHERE media_id=%d AND title=%s AND c_date=%s AND user_id=%d LIMIT 1", $currentTime, $media_id, $title, $date, $user_id)); } } if($stmt !== false){ echo json_encode($stmt); } wp_die(); }else { wp_die(); } } function mvp_download_count(){ if(isset($_POST['media_id']) && isset($_POST['playlist_id'])){ $media_id = (int)$_POST["media_id"]; $playlist_id = (int)$_POST["playlist_id"]; $date = date("Y-m-d"); $title = stripslashes($_POST['title']); global $wpdb; $wpdb->show_errors(); $statistics_table = $wpdb->prefix . "mvp_statistics"; //check if exist $wpdb->get_row($wpdb->prepare("SELECT id FROM $statistics_table WHERE media_id=%d AND title=%s AND c_date=%s", $media_id, $title, $date)); if($wpdb->num_rows == 0){//create entry $stmt = $wpdb->query("INSERT INTO $statistics_table (title, c_play, c_time, c_download, c_finish, c_date, media_id, playlist_id) VALUES ('$title', 0, 0, 1, 0, '$date', '$media_id', '$playlist_id')"); }else{//update $stmt = $wpdb->query($wpdb->prepare("UPDATE $statistics_table SET c_download=c_download+1 WHERE media_id=%d AND title=%s AND c_date=%s LIMIT 1", $media_id, $title, $date)); } if($stmt !== false){ echo json_encode($stmt); } wp_die(); }else { wp_die(); } } function mvp_finish_count(){ if(isset($_POST['media_id']) && isset($_POST['playlist_id'])){ $media_id = (int)$_POST["media_id"]; $playlist_id = (int)$_POST["playlist_id"]; $date = date("Y-m-d"); $title = stripslashes($_POST['title']); global $wpdb; $wpdb->show_errors(); $statistics_table = $wpdb->prefix . "mvp_statistics"; //check if exist $wpdb->get_row($wpdb->prepare("SELECT id FROM $statistics_table WHERE media_id=%d AND title=%s AND c_date=%s", $media_id, $title, $date)); if($wpdb->num_rows == 0){//create entry $stmt = $wpdb->query("INSERT INTO $statistics_table (title, c_play, c_time, c_download, c_finish, c_date, media_id, playlist_id) VALUES ('$title', 0, 0, 0, 1, '$date', '$media_id', '$playlist_id')"); }else{//update $stmt = $wpdb->query($wpdb->prepare("UPDATE $statistics_table SET c_finish=c_finish+1 WHERE media_id=%d AND title=%s AND c_date=%s LIMIT 1", $media_id, $title, $date)); } if($stmt !== false){ echo json_encode($stmt); } wp_die(); }else { wp_die(); } } function mvp_get_stats($atts){ if(!isset($atts['action']))return "Action parameter missing!"; $action = $atts['action']; $playlist_id = isset($atts['playlist_id']) ? $atts["playlist_id"] : -1; $days = isset($atts['days']) ? $atts['days'] : 7; $limit = isset($atts['limit']) ? $atts['limit'] : 10; $dir = isset($atts['dir']) ? strtoupper($atts['dir']) : 'DESC'; $title = isset($atts['title']) ? $atts['title'] : ''; $hiperlink_video = isset($atts['hiperlink_video']) ? $atts['hiperlink_video'] : '0'; if($action == 'top_play_today')$results = mvp_getTopPlayToday($playlist_id, $limit, $dir); else if($action == 'top_play_last_x_days')$results = mvp_getTopPlayLastXDays($playlist_id, $days, $limit, $dir); else if($action == 'top_play_this_week')$results = mvp_getTopPlayThisWeek($playlist_id, $limit, $dir); else if($action == 'top_play_this_month')$results = mvp_getTopPlayThisMonth($playlist_id, $limit, $dir); else if($action == 'top_play_all_time')$results = mvp_getTopPlayAllTime($playlist_id, $limit, $dir); else if($action == 'top_download_all_time')$results = mvp_getTopDownloadAllTime($playlist_id, $limit, $dir); else if($action == 'top_finish_all_time')$results = mvp_getTopFinishAllTime($playlist_id, $limit, $dir); else return "Action parameter incorrect!"; if(count($results) > 0){ $id = 'mvp-stat-wrap'.mt_rand();//to limit selector for click $markup = '
'.esc_html($title).'
    '; foreach($results as $key) : if($hiperlink_video == '1'){ $markup .= '
  1. ';//we need title and artist and special song selection if songs come from grouped source (and media-id is the same) $markup .= ''.esc_html($key['title']).''; }else{ $markup .= '
  2. '; $markup .= esc_html(trim($key['title'])); } $markup .= '('.$key['total_count'].')
    3. '; endforeach; $markup .= '
'; if(isset($atts['player_id']) && $hiperlink_video == '1'){ $player_id = $atts['player_id']; //click to play in player (note: we must use the same playlist_id that is loaded in the player) $markup .= ''; } return $markup; }else{ return ''; } } function mvp_stat_clear(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['playlist_id'])){ $playlist_id = $_POST["playlist_id"]; global $wpdb; $statistics_table = $wpdb->prefix . "mvp_statistics"; if($playlist_id != -1){ $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$statistics_table} WHERE playlist_id=%d", $playlist_id)); }else{ $stmt = $wpdb->query("DELETE FROM {$statistics_table}"); } if($stmt !== false){ echo json_encode("SUCCESS"); } wp_die(); }else{ wp_die(); } } function mvp_get_stat_user_data(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['user_id'])){ $user_id = $_POST["user_id"]; $results = mvp_getTopPlaysPerUserVideosAllTime($user_id); echo json_encode($results); wp_die(''); }else { wp_die(''); } } //############################################// /* watched */ //############################################// function mvp_set_watched_percentage(){ if(isset($_POST['media_id'])){ $playlist_id = !mvp_nullOrEmpty($_POST["playlist_id"]) ? $_POST["playlist_id"] : NULL; $watched = (int)$_POST['watched']; $duration = (int)$_POST['duration']; $media_id = !mvp_nullOrEmpty($_POST["media_id"]) ? $_POST["media_id"] : NULL; $url = !mvp_nullOrEmpty($_POST["url"]) ? $_POST["url"] : NULL; $arr = array( 'title' => $url, 'watched' => $watched, 'duration' => $duration, 'media_id' => $media_id, 'playlist_id' => $playlist_id ); global $wpdb; $watched_percentage_table = $wpdb->prefix . "mvp_watched_percentage"; if($media_id && $url){ //check if exist $stmt = $wpdb->get_row($wpdb->prepare("SELECT id FROM $watched_percentage_table WHERE media_id=%d AND title=%s", $media_id, $url)); if($wpdb->num_rows == 0){//create entry $stmt = $wpdb->insert( $watched_percentage_table, $arr, array( '%s','%d','%d','%d','%d' ) ); }else{//update only if larger $query = "UPDATE $watched_percentage_table SET watched = GREATEST($watched, watched) WHERE media_id = %d AND title = %s"; $values = array($media_id, $url); $stmt = $wpdb->query( $wpdb->prepare( "$query ", $values ) ); } $response_arr = array('update' => $stmt, 'media_id' => $media_id, 'title' => $url, 'watched' => $watched, 'duration' => $duration); }else if($url){//use title for url so we dont change column //check if exist $stmt = $wpdb->get_row($wpdb->prepare("SELECT id FROM $watched_percentage_table WHERE title=%s", $url)); if($wpdb->num_rows == 0){//create entry $stmt = $wpdb->insert( $watched_percentage_table, $arr, array( '%s','%d','%d','%d','%d' ) ); }else{//update only if larger $stmt = $wpdb->query( $wpdb->prepare("UPDATE $watched_percentage_table SET watched = GREATEST($watched, watched) WHERE title = %s", $url ) ); } $response_arr = array('title' => $url, 'watched' => $watched, 'duration' => $duration); } echo json_encode($response_arr); wp_die(); }else { wp_die(); } } function mvp_get_watched_percentage(){ if(isset($_POST['data'])){ global $wpdb; $watched_percentage_table = $wpdb->prefix . "mvp_watched_percentage"; //https://stackoverflow.com/questions/44706196/mysql-multiple-columns-in-in-clause $data = json_decode(stripcslashes($_POST['data']), true); $len = count($data); $i = 0; $str = '('; foreach ($data as $d) { $title = $d['url']; if($d['media_id'] == null){ $str .= '( media_id IS NULL AND title = \''.$title.'\' )'; }else{ $str .= '( media_id = \''.$d['media_id'].'\' AND title = \''.$title.'\' )'; } if($i < $len-1)$str .= ' OR '; $i++; } $str .= ')'; $stmt = $wpdb->get_results("SELECT media_id, title, watched, duration FROM $watched_percentage_table WHERE {$str}", ARRAY_A); if($stmt !== false){ echo json_encode($stmt); } wp_die(); }else { wp_die(); } } function mvp_clear_watched_percentage(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['playlist_id'])){ $playlist_id = (int)$_POST["playlist_id"]; global $wpdb; $watched_percentage_table = $wpdb->prefix . "mvp_watched_percentage"; $stmt = $wpdb->query($wpdb->prepare("UPDATE $watched_percentage_table SET watched='0' WHERE playlist_id=%d", $playlist_id)); if($stmt !== false){ echo json_encode($stmt); } wp_die(); }else { wp_die(); } } function mvp_clear_watched_percentage_all(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } global $wpdb; $watched_percentage_table = $wpdb->prefix . "mvp_watched_percentage"; $stmt = $wpdb->query("TRUNCATE $watched_percentage_table"); if($stmt !== false){ echo json_encode($stmt); } wp_die(); } //############################################// /* */ //############################################// function mvp_annotation_shortcode(){ if(isset($_POST['shortcode'])){ $shortcode = json_decode(stripcslashes($_POST['shortcode']), true); $annotation_id = $_POST['annotation_id']; $output = do_shortcode($shortcode); echo json_encode(array("annotation_id"=>$annotation_id, "output"=> $output)); wp_die(); }else { wp_die(); } } //############################################// /* mime */ //############################################// function mvp_enable_custom_mime ( $mime_types = array() ) { $mime_types['m3u8'] = 'application/x-mpegURL,application/vnd.apple.mpegurl'; $mime_types['ts'] = 'video/MP2T'; $mime_types['xml'] = 'application/xml'; $mime_types['json'] = 'application/json'; return $mime_types; } function mvp_init_setup() { if (function_exists('register_block_type')) { register_block_type('ultimate-media-gallery/block', array( 'attributes' => array( 'player_id' => array( 'type' => 'string' ), 'playlist_id' => array( 'type' => 'string' ), 'ad_id' => array( 'type' => 'string' ) )) ); } } function mvp_register_widgets(){ register_widget('UltimateMediaGalleryWidget'); } function mvp_init_frontend() { global $wpdb; $settings_table = $wpdb->prefix . "mvp_settings"; $result = $wpdb->get_row("SELECT options FROM {$settings_table} WHERE id = '0'", ARRAY_A); if($result){ $settings = unserialize($result['options']); $overide_wp_video = isset($settings["overide_wp_video"]) ? (bool)($settings["overide_wp_video"]) : false; if($overide_wp_video){ add_filter('wp_video_shortcode_override', 'mvp_video_shortcode_override', 10, 2); add_filter('the_content', 'mvp_disable_wp_auto_p', 0 ); add_filter('embed_oembed_html', 'mvp_embed_oembed_html', 99, 4); add_filter('video_embed_html', 'mvp_embed_oembed_html'); } } } function mvp_enqueue_block_assets() { if (function_exists('register_block_type')) { wp_enqueue_script('apmvp-block', plugins_url('js/block.js', __FILE__), array( 'wp-blocks', 'wp-i18n', 'wp-element' )); wp_enqueue_style('mvp-block-editor-css', plugins_url('/css/block.css', __FILE__), array('wp-edit-blocks')); global $wpdb; $player_table = $wpdb->prefix . "mvp_players"; $playlist_table = $wpdb->prefix . "mvp_playlists"; $global_ad_table = $wpdb->prefix . "mvp_global_ad"; //load players $players = $wpdb->get_results("SELECT id, title FROM {$player_table} ORDER BY title ASC", ARRAY_A); //load playlists $playlists = $wpdb->get_results("SELECT id, title FROM {$playlist_table} ORDER BY title ASC", ARRAY_A); //load ads $ads = $wpdb->get_results("SELECT id, title FROM {$global_ad_table} ORDER BY title ASC", ARRAY_A); wp_localize_script( 'apmvp-block', 'mvp_block_data', array('players' => json_encode($players, JSON_HEX_TAG), 'playlists' => json_encode($playlists, JSON_HEX_TAG), 'ads' => json_encode($ads, JSON_HEX_TAG))); } } function mvp_disable_wp_auto_p( $content ) { remove_filter( 'the_content', 'wpautop' ); remove_filter( 'the_excerpt', 'wpautop' ); return $content; } function mvp_embed_oembed_html( $cache, $url, $attr, $post_ID ) { if ( false !== strpos( $url, 'vimeo' ) ) { if (preg_match('%^https?:\/\/(?:www\.|player\.)?vimeo.com\/(?:channels\/(?:\w+\/)?|groups\/([^\/]*)\/videos\/|album\/(\d+)\/video\/|video\/|)(\d+)(?:$|\/|\?)(?:[?]?.*)$%im', $url, $matches)) { $attr['path'] = $matches[3]; if(isset($attr['width']))$attr['wrapper_max_width'] = $attr['width']; $attr['type'] = 'vimeo_single'; $attr['playlist_position'] = 'no-playlist'; $attr['use_previous'] = '0'; $attr['use_next'] = '0'; $attr['noapi'] = '1'; $attr['vimeo_player_type'] = 'chromeless'; return mvp_add_player($attr); }else{ return $cache; } } else if ( false !== strpos( $url, 'youtube' ) ) { if ( preg_match("#(?<=v=)[a-zA-Z0-9-]+(?=&)|(?<=v\/)[^&\n]+(?=\?)|(?<=v=)[^&\n]+|(?<=youtu.be/)[^&\n]+#", $url, $matches)) { $attr['path'] = $matches[0]; if(isset($attr['width']))$attr['wrapper_max_width'] = $attr['width']; $attr['type'] = 'youtube_single'; $attr['playlist_position'] = 'no-playlist'; $attr['use_previous'] = '0'; $attr['use_next'] = '0'; $attr['noapi'] = '1'; return mvp_add_player($attr); }else{ parse_str( parse_url( $url, PHP_URL_QUERY ), $vars ); if(!empty($vars['list'])){ $attr['path'] = $vars['list']; if(isset($attr['width']))$attr['wrapper_max_width'] = $attr['width']; $attr['type'] = 'youtube_playlist'; //$attr['playlist_position'] = 'vrb'; return mvp_add_player($attr); }else{ return $cache; } } } else return $cache; } function mvp_video_shortcode_override( $html, $attr, $content ) { if(isset($attr['mp4'])){ $attr['path'] = $attr['mp4']; if(isset($attr['width']))$attr['wrapper_max_width'] = $attr['width']; $attr['type'] = 'video'; $attr['playlist_position'] = 'no-playlist'; $attr['use_previous'] = '0'; $attr['use_next'] = '0'; return mvp_add_player($attr); }else{ return ""; } }; function mvp_admin_menu(){ add_menu_page("Ultimate Video Gallery Player manager", "Ultimate Video Gallery", MVP_CAPABILITY, "mvp_settings", "mvp_settings_page", 'dashicons-playlist-video'); add_submenu_page("mvp_settings", "Ultimate Video Gallery", "Global Settings", MVP_CAPABILITY, 'mvp_settings'); add_submenu_page("mvp_settings", "Ultimate Video Gallery", "Player manager", MVP_CAPABILITY, 'mvp_player_manager', "mvp_player_manager_page"); add_submenu_page("mvp_settings", "Ultimate Video Gallery", "Playlist manager", MVP_CAPABILITY, 'mvp_playlist_manager', 'mvp_playlist_manager_page'); add_submenu_page("mvp_settings", "Ultimate Video Gallery", "Ad manager", MVP_CAPABILITY, 'mvp_ad_manager', 'mvp_ad_manager_page'); add_submenu_page("mvp_settings", "Ultimate Video Gallery", "Shortcodes", MVP_CAPABILITY, 'mvp_shortcodes', 'mvp_shortcodes_page'); add_submenu_page('mvp_settings', "Ultimate Video Gallery", 'Statistics', MVP_CAPABILITY, 'mvp_statistics', 'mvp_statistics_page'); add_submenu_page("mvp_settings", "Ultimate Video Gallery", "Demo", MVP_CAPABILITY, 'mvp_demo', 'mvp_demo_page'); } function mvp_settings_page(){ global $wpdb; $wpdb->show_errors(); $settings_table = $wpdb->prefix . "mvp_settings"; include("includes/settings.php"); } function mvp_player_manager_page(){ global $wpdb; $wpdb->show_errors(); $player_table = $wpdb->prefix . "mvp_players"; $playlist_table = $wpdb->prefix . "mvp_playlists"; $action = ""; if(isset($_GET['action'])){ $action = $_GET['action']; } switch($action) { case 'edit_player': include("includes/edit_player.php"); break; default: include("includes/player_manager.php"); break; } } function mvp_playlist_manager_page(){ global $wpdb; $wpdb->show_errors(); $player_table = $wpdb->prefix . "mvp_players"; $playlist_table = $wpdb->prefix . "mvp_playlists"; $media_table = $wpdb->prefix . "mvp_media"; $ad_table = $wpdb->prefix . "mvp_ad"; $annotation_table = $wpdb->prefix . "mvp_annotation"; $path_table = $wpdb->prefix . "mvp_path"; $subtitle_table = $wpdb->prefix . "mvp_subtitle"; $watched_percentage_table = $wpdb->prefix . "mvp_watched_percentage"; $statistics_table = $wpdb->prefix . "mvp_statistics"; $action = ""; if(isset($_GET['action'])){ $action = $_GET['action']; } switch($action) { case 'edit_playlist': include("includes/edit_playlist.php"); break; default: include("includes/playlist_manager.php"); break; } } function mvp_ad_manager_page(){ global $wpdb; $wpdb->show_errors(); $ad_table = $wpdb->prefix . "mvp_ad"; $annotation_table = $wpdb->prefix . "mvp_annotation"; $global_ad_table = $wpdb->prefix . "mvp_global_ad"; $action = ""; if(isset($_GET['action'])){ $action = $_GET['action']; } switch($action) { case 'edit_ad': include("includes/edit_ad.php"); break; default: include("includes/ad_manager.php"); break; } } function mvp_shortcodes_page(){ global $wpdb; $wpdb->show_errors(); $player_table = $wpdb->prefix . "mvp_players"; $playlist_table = $wpdb->prefix . "mvp_playlists"; $global_ad_table = $wpdb->prefix . "mvp_global_ad"; include("includes/shortcode_manager.php"); } function mvp_statistics_page(){ global $wpdb; $wpdb->show_errors(); $statistics_table = $wpdb->prefix . "mvp_statistics"; $playlist_table = $wpdb->prefix . "mvp_playlists"; include("includes/statistics_display.php"); } function mvp_demo_page(){ global $wpdb; $wpdb->show_errors(); include("includes/demo.php"); } function mvp_admin_enqueue_scripts( $hook_suffix ) { global $wpdb; $settings_table = $wpdb->prefix . "mvp_settings"; $stmt = $wpdb->get_row("SELECT options FROM {$settings_table} WHERE id = '0'", ARRAY_A); $default_settings = mvp_get_settings(); if($stmt){ $result = unserialize($stmt['options']); $settings = $result + $default_settings; }else{ $settings = $default_settings; } wp_enqueue_script('jquery'); wp_enqueue_script('jquery-ui-sortable'); wp_enqueue_media(); wp_enqueue_style("spectrum", plugins_url('/css/spectrum.css', __FILE__)); wp_enqueue_script("spectrum", plugins_url('/js/spectrum.js', __FILE__), array('jquery')); wp_enqueue_style('mvp-admin-css', plugins_url('/css/admin.css', __FILE__)); wp_enqueue_script("mvp-general", plugins_url('/js/admin_global.js', __FILE__), array('jquery','jquery-ui-sortable')); switch ( $hook_suffix ) { case get_plugin_page_hookname( 'mvp_settings', 'mvp_settings' ): //wp_enqueue_style("fa", $settings['fontAwesomeCssUrl']);//pi icons case get_plugin_page_hookname( 'mvp_player_manager', 'mvp_settings' ): //multi select wp_enqueue_style("select2", "https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.13/css/select2.min.css"); wp_enqueue_script("select2", "https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.13/js/select2.min.js", array('jquery')); wp_enqueue_style("codemirror", plugins_url('/css/codemirror.min.css', __FILE__)); wp_enqueue_script("codemirror", plugins_url('/js/codemirror.min.js', __FILE__)); break; case get_plugin_page_hookname( 'mvp_playlist_manager', 'mvp_settings' ): //multi select wp_enqueue_style("select2", "https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.13/css/select2.min.css"); wp_enqueue_script("select2", "https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.13/js/select2.min.js", array('jquery')); break; case get_plugin_page_hookname( 'mvp_ad_manager', 'mvp_settings' ): break; case get_plugin_page_hookname( 'mvp_statistics', 'mvp_settings' ): wp_enqueue_script("selectize", "//cdnjs.cloudflare.com/ajax/libs/selectize.js/0.15.2/js/selectize.min.js"); wp_enqueue_style("selectize", "//cdnjs.cloudflare.com/ajax/libs/selectize.js/0.15.2/css/selectize.bootstrap3.min.css"); wp_enqueue_script("momentjs", "//cdn.jsdelivr.net/momentjs/latest/moment.min.js"); wp_enqueue_script("chart", "//cdnjs.cloudflare.com/ajax/libs/Chart.js/2.9.3/Chart.min.js"); wp_enqueue_script("mvp-admin", plugins_url('/js/admin_stat.js', __FILE__), array('jquery')); break; case get_plugin_page_hookname( 'mvp_shortcodes', 'mvp_settings' ): wp_enqueue_style("fa", $settings['fontAwesomeCssUrl']);//pi icons wp_enqueue_script("mvp-admin-shortcode", plugins_url('/js/admin_shortcode.js', __FILE__), array('jquery')); break; case get_plugin_page_hookname( 'mvp_demo', 'mvp_settings' ): wp_enqueue_script("mvp-admin", plugins_url('/js/admin_demo.js', __FILE__), array('jquery')); break; } wp_localize_script('mvp-general', 'mvp_data', array('plugins_url' => plugins_url('', __FILE__), 'fontAwesomeUrl' => $settings['fontAwesomeCssUrl'], 'ajax_url' => admin_url( 'admin-ajax.php'), 'options' => $settings, 'security' => wp_create_nonce( 'mvp-security-nonce' ))); } function mvp_enqueue_scripts() { global $wpdb; $settings_table = $wpdb->prefix . "mvp_settings"; $result = $wpdb->get_row("SELECT options FROM {$settings_table} WHERE id = '0'", ARRAY_A); $default_settings = mvp_get_settings(); if($result){ $settings = unserialize($result['options']) + $default_settings; $js_to_footer = isset($settings["js_to_footer"]) ? (bool)($settings["js_to_footer"]) : false; }else{ $settings = $default_settings; $js_to_footer = false; } //playlist icons if($settings['add_font_awesome_css'] == '1')wp_enqueue_style('fontawesome', $settings['fontAwesomeCssUrl']); wp_enqueue_style('mvp', plugins_url('/source/css/mvp.css', __FILE__));//main css wp_enqueue_script('mvp', plugins_url('/source/js/new.js', __FILE__), null, false, $js_to_footer);//main js wp_localize_script('mvp', 'mvp_data', array('ajax_url' => admin_url( 'admin-ajax.php'))); } //############################################// /* global */ //############################################// function mvp_save_global_options(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['options'])){ $settings = json_decode(stripcslashes($_POST['options']), true); global $wpdb; $wpdb->show_errors(); $settings_table = $wpdb->prefix . "mvp_settings"; $id = $wpdb->get_row("SELECT id FROM {$settings_table}"); if($wpdb->num_rows > 0){ $stmt = $wpdb->update( $settings_table, array('options' => serialize($settings)), array('id' => 0), array('%s'), array('%d') ); }else{ $stmt = $wpdb->insert( $settings_table, array('options' => serialize($settings)), array('%s') ); } if($stmt !== false){ echo json_encode($stmt); } wp_die(); }else{ wp_die(); } } //############################################// /* player */ //############################################// function mvp_duplicate_player(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['title']) && isset($_POST['player_id'])){ $player_id = $_POST['player_id']; $title = stripslashes($_POST['title']); global $wpdb; $player_table = $wpdb->prefix . "mvp_players"; $stmt = $wpdb->prepare("SELECT preset, options, custom_css, custom_js FROM {$player_table} WHERE id = %d", $player_id);//get player options if($stmt !== false){ $result = $wpdb->get_row($stmt, ARRAY_A); $stmt = $wpdb->insert(//copy player $player_table, array( 'title' => $title, 'preset' => $result['preset'], 'options' => $result['options'], 'custom_css' => $result['custom_css'], 'custom_js' => $result['custom_js'] ), array( '%s', '%s', '%s', '%s', '%s' ) ); if($stmt !== false){ echo json_encode($wpdb->insert_id); } } wp_die(); }else{ wp_die(); } } function mvp_create_player(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['title']) && isset($_POST['preset'])){ $title = stripslashes($_POST['title']); $preset = $_POST['preset']; $default_options = mvp_player_options(); $preset_options = mvp_player_options_preset()[$preset]; //$options = $default_options + $preset_options; $options = array_replace($default_options, $preset_options);//on add player we want to overwite options from individual preset. global $wpdb; $player_table = $wpdb->prefix . "mvp_players"; $stmt = $wpdb->insert( $player_table, array( 'title' => $title, 'preset' => $preset, 'options' => serialize($options) ), array( '%s', '%s', '%s' ) ); if($stmt !== false){ echo json_encode($wpdb->insert_id); } wp_die(); }else{ wp_die(); } } function mvp_edit_player_title(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['title']) && isset($_POST['id'])){ $title = stripcslashes($_POST["title"]); $id = $_POST["id"]; global $wpdb; $player_table = $wpdb->prefix . "mvp_players"; $wpdb->update( $player_table, array( 'title' => $title ), array('id' => $id), array( '%s' ), array( '%d' ) ); wp_die(); }else{ wp_die(); } } function mvp_delete_player(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['player_id'])){ $player_id = $_POST['player_id']; global $wpdb; $wpdb->show_errors(); $player_table = $wpdb->prefix . "mvp_players"; $ids = explode(',',$player_id); $in = implode(',', array_fill(0, count($ids), '%d')); $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$player_table} WHERE id IN ($in)", $ids)); if($stmt !== false){ echo json_encode($stmt); } wp_die(); }else{ wp_die(); } } function mvp_save_player_options(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['player_id'])){ $player_id = $_POST['player_id']; global $wpdb; $wpdb->show_errors(); $player_table = $wpdb->prefix . "mvp_players"; $custom_css = !mvp_nullOrEmpty($_POST['custom_css']) ? $_POST['custom_css'] : NULL; $custom_js = !mvp_nullOrEmpty($_POST['custom_js']) ? $_POST['custom_js'] : NULL; $player_options = json_decode(stripcslashes($_POST['player_options']), true); $stmt = $wpdb->update( $player_table, array('options' => serialize($player_options), 'custom_css' => $custom_css, 'custom_js' => $custom_js), array('id' => $player_id), array('%s','%s','%s'), array('%d') ); if($stmt !== false){ echo json_encode($stmt); } wp_die(); }else{ wp_die(); } } //############################################// /* playlist */ //############################################// function mvp_create_playlist(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['title'])){ $title = stripslashes($_POST['title']); global $wpdb; $playlist_table = $wpdb->prefix . "mvp_playlists"; $stmt = $wpdb->insert( $playlist_table, array( 'title' => $title, ), array( '%s','%s' ) ); $lastid = $wpdb->insert_id; if(isset($_POST['media_id'])){//from stats $media_id = $_POST['media_id']; $_ids = explode('_', $media_id); $ids = array(); foreach($_ids as $id){ $ids[] = array("id" => $id); } mvp_duplicatePlaylist(null, $lastid, $ids, "playlist_id"); }else{ if($stmt !== false){ echo json_encode($lastid); } } wp_die(); }else{ wp_die(); } } function mvp_save_playlist_options(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['playlist_id'])){ $playlist_id = $_POST['playlist_id']; global $wpdb; $wpdb->show_errors(); $playlist_table = $wpdb->prefix . "mvp_playlists"; $playlist_options = json_decode(stripcslashes($_POST['playlist_options']), true); $stmt = $wpdb->update( $playlist_table, array('options' => serialize($playlist_options)), array('id' => $playlist_id), array('%s'), array('%d') ); echo json_encode('SUCCESS'); wp_die(); }else{ wp_die(); } } function mvp_edit_playlist_title(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['title']) && isset($_POST['id'])){ $title = stripcslashes($_POST["title"]); $id = $_POST["id"]; global $wpdb; $playlist_table = $wpdb->prefix . "mvp_playlists"; $wpdb->update( $playlist_table, array( 'title' => $title ), array('id' => $id), array( '%s' ), array( '%d' ) ); wp_die(); }else{ wp_die(); } } function mvp_delete_playlist(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['playlist_id'])){ $playlist_id = $_POST['playlist_id']; $ids = explode(',',$playlist_id); $in = implode(',', array_fill(0, count($ids), '%d')); global $wpdb; $wpdb->show_errors(); $playlist_table = $wpdb->prefix . "mvp_playlists"; $media_table = $wpdb->prefix . "mvp_media"; $statistics_table = $wpdb->prefix . "mvp_statistics"; $ad_table = $wpdb->prefix . "mvp_ad"; $annotation_table = $wpdb->prefix . "mvp_annotation"; $path_table = $wpdb->prefix . "mvp_path"; $subtitle_table = $wpdb->prefix . "mvp_subtitle"; $watched_percentage_table = $wpdb->prefix . "mvp_watched_percentage"; //path $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$path_table} WHERE playlist_id IN ($in)", $ids)); //sub $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$subtitle_table} WHERE playlist_id IN ($in)", $ids)); //ad $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$ad_table} WHERE playlist_id IN ($in)", $ids)); //ann $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$annotation_table} WHERE playlist_id IN ($in)", $ids)); //media $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$media_table} WHERE playlist_id IN ($in)", $ids)); //watched perc $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$watched_percentage_table} WHERE playlist_id IN ($in)", $ids)); //stat $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$statistics_table} WHERE playlist_id IN ($in)", $ids)); //playlist $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$playlist_table} WHERE id IN ($in)", $ids)); if($stmt !== false){ echo json_encode($stmt); } wp_die(); }else{ wp_die(); } } function mvp_duplicate_playlist(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['title']) && isset($_POST['playlist_id'])){ $playlist_id = $_POST['playlist_id']; $title = stripslashes($_POST['title']); global $wpdb; $playlist_table = $wpdb->prefix . "mvp_playlists"; $options = $wpdb->get_var($wpdb->prepare("SELECT options FROM {$playlist_table} WHERE id = %d", $playlist_id)); $stmt = $wpdb->insert( $playlist_table, array( 'title' => $title, 'options' => $options ), array( '%s','%s' ) ); if($stmt !== false){//copy tracks $lastid = $wpdb->insert_id;//playlist_id mvp_duplicatePlaylist($playlist_id, $lastid, null, "playlist_id"); } wp_die(); }else{ wp_die(); } } function mvp_duplicatePlaylist($playlist_id = null, $lastid = null, $ids = null, $msg = null){ global $wpdb; $wpdb->show_errors(); $media_table = $wpdb->prefix . "mvp_media"; $ad_table = $wpdb->prefix . "mvp_ad"; $annotation_table = $wpdb->prefix . "mvp_annotation"; $path_table = $wpdb->prefix . "mvp_path"; $subtitle_table = $wpdb->prefix . "mvp_subtitle"; $tn = 'mvp_temp_table'.time(); $order_id = 0; //copy playlist if($playlist_id != null){ //get order $stmt = $wpdb->get_row($wpdb->prepare("SELECT IFNULL(MAX(order_id)+1,0) AS order_id FROM {$media_table} WHERE playlist_id = %d", $lastid), ARRAY_A); $order_id = $stmt['order_id']; } //copy tracks if($ids == null){ $stmt = $wpdb->prepare("SELECT id FROM {$media_table} WHERE playlist_id = %d ORDER BY order_id", $playlist_id); $ids = $wpdb->get_results($stmt, ARRAY_A); } foreach ($ids as $id) { //duplicate tracks $stmt = $wpdb->query($wpdb->prepare("CREATE TEMPORARY TABLE {$tn} SELECT * FROM $media_table WHERE id=%d", $id['id'])); //copy track by track if($stmt !== false){ //media $wpdb->query("UPDATE {$tn} SET id=NULL, order_id=$order_id, playlist_id='$lastid'");//update playlist id $wpdb->query("INSERT INTO $media_table SELECT * FROM {$tn}"); $last_media_insert_id = $wpdb->insert_id;//media_id $wpdb->query("DROP TABLE {$tn}"); //copy path $wpdb->query($wpdb->prepare("CREATE TEMPORARY TABLE {$tn} SELECT * FROM $path_table WHERE media_id=%d", $id['id'])); $wpdb->query("UPDATE {$tn} SET id=NULL, media_id='$last_media_insert_id'");//update media id $wpdb->query("INSERT INTO $path_table SELECT * FROM {$tn}"); $wpdb->query("DROP TABLE {$tn}"); //copy subtitles $wpdb->query($wpdb->prepare("CREATE TEMPORARY TABLE {$tn} SELECT * FROM $subtitle_table WHERE media_id=%d", $id['id'])); $wpdb->query("UPDATE {$tn} SET id=NULL, media_id='$last_media_insert_id'");//update media id $wpdb->query("INSERT INTO $subtitle_table SELECT * FROM {$tn}"); $wpdb->query("DROP TABLE {$tn}"); //copy ads //media ads $wpdb->query($wpdb->prepare("CREATE TEMPORARY TABLE {$tn} SELECT * FROM $ad_table WHERE media_id=%d", $id['id'])); $wpdb->query("UPDATE {$tn} SET id=NULL, media_id='$last_media_insert_id'");//update media id $wpdb->query("INSERT INTO $ad_table SELECT * FROM {$tn}"); $wpdb->query("DROP TABLE {$tn}"); //copy annotations //media annotations $wpdb->query($wpdb->prepare("CREATE TEMPORARY TABLE {$tn} SELECT * FROM $annotation_table WHERE media_id=%d", $id['id'])); $wpdb->query("UPDATE {$tn} SET id=NULL, media_id='$last_media_insert_id'");//update media id $wpdb->query("INSERT INTO $annotation_table SELECT * FROM {$tn}"); $wpdb->query("DROP TABLE {$tn}"); $order_id++; } } if($msg != null){//for copy, move tracks if($stmt !== false){ if($msg == "playlist_id"){//redirect to newly created playlist echo json_encode($lastid); }else if($msg == "copy_media" || $msg == "make_playlist"){ echo json_encode("SUCCESS"); } } wp_die(); } } //############################################// /* media */ //############################################// function mvp_update_media_order(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['media_id_arr']) && isset($_POST['order_id_arr']) && isset($_POST['playlist_id'])){ $media_id_arr = explode(",",$_POST["media_id_arr"]); $order_id_arr = explode(",",$_POST["order_id_arr"]); $playlist_id = $_POST["playlist_id"]; global $wpdb; $wpdb->show_errors(); $media_table = $wpdb->prefix . "mvp_media"; for($i=0;$iupdate( $media_table, array( 'order_id' => $order_id_arr[$i] ), array('playlist_id' => $playlist_id, 'id' => $media_id_arr[$i]), array( '%d' ), array( '%d','%d' ) ); } echo json_encode($stmt); wp_die(); }else{ wp_die(); } } function mvp_delete_media(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } header("Content-Type: application/json"); if(isset($_POST['media_id'])){ $media_id = $_POST['media_id']; global $wpdb; $wpdb->show_errors(); $media_table = $wpdb->prefix . "mvp_media"; $ids = explode(',',$media_id); $in = implode(',', array_fill(0, count($ids), '%d')); $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$media_table} WHERE id IN ($in)", $ids)); if($stmt !== false){ $statistics_table = $wpdb->prefix . "mvp_statistics"; $wpdb->query($wpdb->prepare("DELETE FROM {$statistics_table} WHERE media_id IN ($in)", $ids)); echo json_encode($stmt); } wp_die(); }else{ wp_die(); } } function mvp_copy_media(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } header("Content-Type: application/json"); if(isset($_POST['media_id']) && isset($_POST['destination_playlist_id'])){ $media_id = $_POST['media_id']; $lastid = $_POST['destination_playlist_id']; $ids = explode(',',$media_id); $id_arr = array(); foreach ($ids as $id) { $id_arr[] = array('id' => $id); } mvp_duplicatePlaylist(null, $lastid, $id_arr, true); }else{ wp_die(); } } function mvp_move_media(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } header("Content-Type: application/json"); if(isset($_POST['media_id']) && isset($_POST['destination_playlist_id'])){ $media_id = $_POST['media_id']; $destination_playlist_id = $_POST['destination_playlist_id']; global $wpdb; $wpdb->show_errors(); $media_table = $wpdb->prefix . "mvp_media"; $ids = explode(',',$media_id); $in = implode(',', array_fill(0, count($ids), '%d')); //only update playlist_id $stmt = $wpdb->query($wpdb->prepare("UPDATE {$media_table} SET playlist_id = $destination_playlist_id WHERE id IN ($in)", $ids)); if($stmt !== false){ echo json_encode($stmt); } wp_die(); }else{ wp_die(); } } function mvp_edit_media(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['media_id'])){ $media_id = $_POST['media_id']; global $wpdb; $wpdb->show_errors(); $media_table = $wpdb->prefix . "mvp_media"; $path_table = $wpdb->prefix . "mvp_path"; $subtitle_table = $wpdb->prefix . "mvp_subtitle"; $ad_table = $wpdb->prefix . "mvp_ad"; $annotation_table = $wpdb->prefix . "mvp_annotation"; //media $stmt = $wpdb->prepare("SELECT title, options FROM {$media_table} WHERE id = %d", $media_id); $result = $wpdb->get_row($stmt, ARRAY_A); $data = unserialize($result['options']); $data['title'] = $result['title']; //path $paths = $wpdb->get_results($wpdb->prepare("SELECT options FROM {$path_table} WHERE media_id = %d", $media_id), ARRAY_A); $multi_path_query_result = array(); foreach($paths as $item){ $multi_path_query_result[] = unserialize($item['options']); } //subtitle $stmt = $wpdb->get_results($wpdb->prepare("SELECT options FROM {$subtitle_table} WHERE media_id = %d", $media_id), ARRAY_A); $subtitle_query_result = array(); foreach($stmt as $item){ $subtitle_query_result[] = unserialize($item['options']); } //ads $stmt = $wpdb->get_results($wpdb->prepare("SELECT options FROM {$ad_table} WHERE media_id = %d", $media_id), ARRAY_A); $ad_data = array(); foreach($stmt as $item){ $ad_data[] = unserialize($item['options']); } //annotations $stmt = $wpdb->get_results($wpdb->prepare("SELECT options FROM {$annotation_table} WHERE media_id = %d", $media_id), ARRAY_A); $annotation_data = array(); foreach($stmt as $item){ $annotation_data[] = unserialize($item['options']); } if($stmt !== false){ $arr = array( "data" => $data, "multi_path_query_result" => $multi_path_query_result, "subtitle" => $subtitle_query_result, "ad_data" => $ad_data, "annotation_data" => $annotation_data ); echo json_encode($arr); } wp_die(); }else{ wp_die(); } } function mvp_domain_rename(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['playlist_id'])){ $playlist_id = $_POST['playlist_id']; $from = $_POST['from']; $to = $_POST['to']; global $wpdb; $wpdb->show_errors(); $media_table = $wpdb->prefix . "mvp_media"; $path_table = $wpdb->prefix . "mvp_path"; $subtitle_table = $wpdb->prefix . "mvp_subtitle"; //media $stmt = $wpdb->prepare("SELECT id, options FROM $media_table WHERE playlist_id = %d", $playlist_id); $medias = $wpdb->get_results($stmt, ARRAY_A); $media_arr = array(); foreach ($medias as $media) { $media_id = $media['id']; $options = unserialize($media['options']); $type = $options['type']; if(isset($options['mp4']))$options['mp4'] = str_replace($from, $to, $options['mp4']); if(isset($options['poster']))$options['poster'] = str_replace($from, $to, $options['poster']); if(isset($options['download']))$options['download'] = str_replace($from, $to, $options['download']); if(isset($options['hover_preview']))$options['hover_preview'] = str_replace($from, $to, $options['hover_preview']); if(isset($options['slideshow_images'])){ $options['slideshow_images'] = str_replace($from, $to, $options['slideshow_images']); } if(isset($options['thumb']))$options['thumb'] = str_replace($from, $to, $options['thumb']); if(isset($options['preview_seek']))$options['preview_seek'] = str_replace($from, $to, $options['preview_seek']); if(isset($options['chapters']))$options['chapters'] = str_replace($from, $to, $options['chapters']); if(isset($options['vast']))$options['vast'] = str_replace($from, $to, $options['vast']); $stmt = $wpdb->update( $media_table, array( 'options' => serialize($options), ), array('id' => $media_id), array( '%s' ), array( '%d' ) ); //path $paths = $wpdb->get_results($wpdb->prepare("SELECT options FROM {$path_table} WHERE media_id = %d", $media_id), ARRAY_A); $media_path = array(); foreach($paths as $item){ $mp = unserialize($item['options']); $mp['path'] = str_replace($from, $to, $mp['path']); $media_path[] = $mp; } //delete current values $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$path_table} WHERE media_id = %d", $media_id)); //multi path if($type == 'video' || $type == 'audio'){ for($i = 0; $i < count($media_path); $i++){ $stmt = $wpdb->insert( $path_table, array( 'options' => serialize($media_path[$i]), 'media_id' => $media_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } }else{//path $stmt = $wpdb->insert( $path_table, array( 'options' => serialize($media_path[0]), 'media_id' => $media_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } //subtitles $subtitles = $wpdb->get_results($wpdb->prepare("SELECT options FROM {$subtitle_table} WHERE media_id = %d", $media_id), ARRAY_A); $subtitle_query_result = array(); foreach($subtitles as $item){ $mp = unserialize($item['options']); if(isset($mp['src']))$mp['src'] = str_replace($from, $to, $mp['src']); $subtitle_query_result[] = $mp; } //delete current values $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$subtitle_table} WHERE media_id = %d", $media_id)); //new values for($i = 0; $i < count($subtitle_query_result); $i++){ $stmt = $wpdb->insert( $subtitle_table, array( 'options' => serialize($subtitle_query_result[$i]), 'media_id' => $media_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } } echo json_encode(""); wp_die(); }else{ wp_die(); } } function mvp_add_media(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['options']) && isset($_POST['playlist_id'])){ $options = json_decode(stripcslashes($_POST['options']), true); $playlist_id = $_POST['playlist_id']; $save_type = $_POST['save_type']; global $wpdb; $wpdb->show_errors(); $media_table = $wpdb->prefix . "mvp_media"; $path_table = $wpdb->prefix . "mvp_path"; $subtitle_table = $wpdb->prefix . "mvp_subtitle"; $ad_table = $wpdb->prefix . "mvp_ad"; $annotation_table = $wpdb->prefix . "mvp_annotation"; $type = $_POST['type']; $media_title = str_replace('"', "'", stripslashes($_POST['title'])); $first_insert_happend = null; if($save_type == 'add_media'){ if(!empty($_POST['additional_playlist'])){ $additional_playlist = explode(",", $_POST['additional_playlist']); $additional_playlist[] = $playlist_id; }else{ $additional_playlist = array($playlist_id); } foreach ($additional_playlist as $playlist_to_insert) { $playlist_id = $playlist_to_insert; //media order $stmt = $wpdb->get_row($wpdb->prepare("SELECT IFNULL(MAX(order_id)+1,0) AS order_id FROM {$media_table} WHERE playlist_id = %d", $playlist_id), ARRAY_A); $order_id = $stmt['order_id']; $stmt = $wpdb->insert( $media_table, array( 'title' => $media_title, 'options' => serialize($options), 'playlist_id' => $playlist_id, 'order_id' => $order_id ), array( '%s','%s','%d','%d' ) ); if($stmt !== false){ $insert_id = $wpdb->insert_id; //multi path if($type == 'video' || $type == 'audio'){ $media_path = json_decode(stripcslashes($_POST['media_path']), true); for($i = 0; $i < count($media_path); $i++){ $stmt = $wpdb->insert( $path_table, array( 'options' => serialize($media_path[$i]), 'media_id' => $insert_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } }else{//path $media_path = json_decode(stripcslashes($_POST['media_path']), true); $stmt = $wpdb->insert( $path_table, array( 'options' => serialize($media_path[0]), 'media_id' => $insert_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } //subtitles if(!empty($_POST['subtitle_src'])){ $subtitle_src = json_decode(stripcslashes($_POST['subtitle_src']), true); for($i = 0; $i < count($subtitle_src); $i++){ $stmt = $wpdb->insert( $subtitle_table, array( 'options' => serialize($subtitle_src[$i]), 'media_id' => $insert_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } } //ads if(!empty($_POST['ad_pre'])){ $ad_pre = json_decode(stripcslashes($_POST['ad_pre']), true); for($i = 0; $i < count($ad_pre); $i++){ $stmt = $wpdb->insert( $ad_table, array( 'options' => serialize($ad_pre[$i]), 'media_id' => $insert_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } } if(!empty($_POST['ad_mid'])){ $ad_mid = json_decode(stripcslashes($_POST['ad_mid']), true); for($i = 0; $i < count($ad_mid); $i++){ $stmt = $wpdb->insert( $ad_table, array( 'options' => serialize($ad_mid[$i]), 'media_id' => $insert_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } } if(!empty($_POST['ad_end'])){ $ad_end = json_decode(stripcslashes($_POST['ad_end']), true); for($i = 0; $i < count($ad_end); $i++){ $stmt = $wpdb->insert( $ad_table, array( 'options' => serialize($ad_end[$i]), 'media_id' => $insert_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } } //annotations if(!empty($_POST['annotation'])){ $annotation = json_decode(stripcslashes($_POST['annotation']), true); for($i = 0; $i < count($annotation); $i++){ $stmt = $wpdb->insert( $annotation_table, array( 'options' => serialize($annotation[$i]), 'media_id' => $insert_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } } }//if($stmt !== false){ if(!$first_insert_happend){ $first_insert_happend = true; if($stmt !== false){ $data = array('insert_id' => $insert_id, 'order_id' => $order_id); echo json_encode($data); } } }//foreach ($additional_playlist as $playlist_to_insert) { }else{//edit media $media_id = $_POST['media_id']; $stmt = $wpdb->update( $media_table, array( 'title' => $media_title, 'options' => serialize($options), ), array('id' => $media_id), array( '%s','%s' ), array( '%d' ) ); //path //delete current values $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$path_table} WHERE media_id = %d", $media_id)); //multi path if($type == 'video' || $type == 'audio'){ $media_path = json_decode(stripcslashes($_POST['media_path']), true); for($i = 0; $i < count($media_path); $i++){ $stmt = $wpdb->insert( $path_table, array( 'options' => serialize($media_path[$i]), 'media_id' => $media_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } }else{//path $media_path = json_decode(stripcslashes($_POST['media_path']), true); $stmt = $wpdb->insert( $path_table, array( 'options' => serialize($media_path[0]), 'media_id' => $media_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } //subtitles //delete current values $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$subtitle_table} WHERE media_id = %d", $media_id)); //new values if(!empty($_POST['subtitle_src'])){ $subtitle_src = json_decode(stripcslashes($_POST['subtitle_src']), true); for($i = 0; $i < count($subtitle_src); $i++){ $stmt = $wpdb->insert( $subtitle_table, array( 'options' => serialize($subtitle_src[$i]), 'media_id' => $media_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } } //ads //delete current values $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$ad_table} WHERE media_id = %d", $media_id)); if(!empty($_POST['ad_pre'])){ $ad_pre = json_decode(stripcslashes($_POST['ad_pre']), true); for($i = 0; $i < count($ad_pre); $i++){ $stmt = $wpdb->insert( $ad_table, array( 'options' => serialize($ad_pre[$i]), 'media_id' => $media_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } } if(!empty($_POST['ad_mid'])){ $ad_mid = json_decode(stripcslashes($_POST['ad_mid']), true); for($i = 0; $i < count($ad_mid); $i++){ $stmt = $wpdb->insert( $ad_table, array( 'options' => serialize($ad_mid[$i]), 'media_id' => $media_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } } if(!empty($_POST['ad_end'])){ $ad_end = json_decode(stripcslashes($_POST['ad_end']), true); for($i = 0; $i < count($ad_end); $i++){ $stmt = $wpdb->insert( $ad_table, array( 'options' => serialize($ad_end[$i]), 'media_id' => $media_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } } //annotations //delete current values $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$annotation_table} WHERE media_id = %d", $media_id)); if(!empty($_POST['annotation'])){ $annotation = json_decode(stripcslashes($_POST['annotation']), true); for($i = 0; $i < count($annotation); $i++){ $stmt = $wpdb->insert( $annotation_table, array( 'options' => serialize($annotation[$i]), 'media_id' => $media_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } } if($stmt !== false){ echo json_encode('SUCCESS'); } } wp_die(); }else{ wp_die(); } } function mvp_add_media_multiple(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['media']) && isset($_POST['playlist_id'])){ $media = json_decode(stripcslashes($_POST['media']), true); $playlist_id = $_POST['playlist_id']; global $wpdb; $wpdb->show_errors(); $media_table = $wpdb->prefix . "mvp_media"; $path_table = $wpdb->prefix . "mvp_path"; $ad_table = $wpdb->prefix . "mvp_ad"; $annotation_table = $wpdb->prefix . "mvp_annotation"; $data = array(); $len = count($media); for($i=0; $i < $len; $i++){ $options = $media[$i]; $media_title = $options['title']; $order_id = $i; $stmt = $wpdb->insert( $media_table, array( 'title' => $media_title, 'options' => serialize($options), 'playlist_id' => $playlist_id, 'order_id' => $order_id ), array( '%s','%s','%d','%d' ) ); if($stmt !== false){ $insert_id = $wpdb->insert_id; //path $media_path = array('path' => $options['path']); $stmt = $wpdb->insert( $path_table, array( 'options' => serialize($media_path), 'media_id' => $insert_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); //ads if(!empty($_POST['ad_pre'])){ $ad_pre = json_decode(stripcslashes($_POST['ad_pre']), true);//same ads for all media for($i = 0; $i < count($ad_pre); $i++){ $stmt = $wpdb->insert( $ad_table, array( 'options' => serialize($ad_pre[$i]), 'media_id' => $insert_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } } if(!empty($_POST['ad_mid'])){ $ad_mid = json_decode(stripcslashes($_POST['ad_mid']), true); for($i = 0; $i < count($ad_mid); $i++){ $stmt = $wpdb->insert( $ad_table, array( 'options' => serialize($ad_mid[$i]), 'media_id' => $insert_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } } if(!empty($_POST['ad_end'])){ $ad_end = json_decode(stripcslashes($_POST['ad_end']), true); for($i = 0; $i < count($ad_end); $i++){ $stmt = $wpdb->insert( $ad_table, array( 'options' => serialize($ad_end[$i]), 'media_id' => $insert_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } } //annotations if(!empty($_POST['annotation'])){ $annotation = json_decode(stripcslashes($_POST['annotation']), true); for($i = 0; $i < count($annotation); $i++){ $stmt = $wpdb->insert( $annotation_table, array( 'options' => serialize($annotation[$i]), 'media_id' => $insert_id, 'playlist_id' => $playlist_id ), array( '%s','%d','%d' ) ); } } $data[] = array('insert_id' => $insert_id, 'order_id' => $order_id, 'options' => $options); } } //save original youtube url for update if(isset($_POST['youtube_url']) && !mvp_nullOrEmpty($_POST['youtube_url']) && isset($_POST['youtube_url_type']) && !mvp_nullOrEmpty($_POST['youtube_url_type'])){ $playlist_table = $wpdb->prefix . "mvp_playlists"; //playlist data $playlist_data = $wpdb->get_row($wpdb->prepare("SELECT options FROM {$playlist_table} WHERE id = %d", $playlist_id), ARRAY_A); $pl_options = unserialize($playlist_data['options']); $pl_options['youtubeUrl'] = $_POST['youtube_url']; $pl_options['youtubeUrlType'] = $_POST['youtube_url_type']; $stmt = $wpdb->update( $playlist_table, array('options' => serialize($pl_options)), array('id' => $playlist_id), array('%s'), array('%d') ); } echo json_encode($data); wp_die(); }else{ wp_die(); } } function mvp_add_more(){ if(isset($_POST['playlist_id'])){ $playlist_id = (int)$_POST['playlist_id']; $offset = (int)$_POST['addMoreOffset']; $limit = (int)$_POST['addMoreLimit']; $sortOrder = $_POST['addMoreSortOrder']; $sortDirection = $_POST['addMoreSortDirection']; $encryptMediaPaths = $_POST['encryptMediaPaths']; global $wpdb; $wpdb->show_errors(); $media_table = $wpdb->prefix . "mvp_media"; $stmt = $wpdb->prepare("SELECT id, title, options FROM {$media_table} WHERE disabled = 0 AND playlist_id = %d ORDER BY $sortOrder $sortDirection LIMIT $offset, $limit", $playlist_id); $medias = $wpdb->get_results($stmt, ARRAY_A); /* note: faster pagination could work for order_id sort (use order_id in both directions) but not for title sort. We would need another column id for that. https://developer.wordpress.com/2014/02/14/an-efficient-alternative-to-paging-with-sql-offsets/ */ $markup = array(); foreach($medias as $media) { $markup[] = mvp_shortcode_media($media, $encryptMediaPaths = true); } echo json_encode($markup); wp_die(); }else{ wp_die(); } } function mvp_set_disabled(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['media_id'])){ $media_id = $_POST['media_id']; $disabled = $_POST['disabled']; global $wpdb; $wpdb->show_errors(); $media_table = $wpdb->prefix . "mvp_media"; $stmt = $wpdb->query($wpdb->prepare("UPDATE {$media_table} SET disabled = %s WHERE id = %d", $disabled, $media_id)); echo json_encode(""); wp_die(); }else{ wp_die(); } } function mvp_set_disabled_all(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['media_id'])){ $media_id = $_POST['media_id']; $disabled = $_POST['disabled']; $ids = explode(',',$media_id); $in = implode(',', array_fill(0, count($ids), '%d')); global $wpdb; $wpdb->show_errors(); $media_table = $wpdb->prefix . "mvp_media"; $stmt = $wpdb->query($wpdb->prepare("UPDATE {$media_table} SET disabled = %s WHERE id IN ($in)", $disabled, ...$ids)); echo json_encode(""); wp_die(); }else{ wp_die(); } } function mvp_shortcode_media($m, $encryptMediaPaths = false){ global $wpdb; $path_table = $wpdb->prefix . "mvp_path"; $subtitle_table = $wpdb->prefix . "mvp_subtitle"; $ad_table = $wpdb->prefix . "mvp_ad"; $annotation_table = $wpdb->prefix . "mvp_annotation"; $media = unserialize($m['options']); $type = $media["type"]; $track = '
get_results($wpdb->prepare("SELECT options FROM {$path_table} WHERE media_id = %d", $m["id"]), ARRAY_A); $custom_html = null; if($wpdb->num_rows > 0){ if($type == "video" || $type == "audio"){ $quality; $quality_mobile; $path = 'data-path=\'['; foreach($paths as $r){ $row = unserialize($r['options']); if($type == "video"){ $ext = "mp4"; }else if($type == "audio"){ $ext = pathinfo($row['path'], PATHINFO_EXTENSION); if(mvp_nullOrEmpty($ext))$ext = "mp3"; } if($encryptMediaPaths)$p = MVP_BSF_MATCH.base64_encode($row['path']); else $p = $row['path']; $path .= '{"quality": "'.$row['quality_title'].'", "'.$ext.'": "'.$p.'"},'; if(!empty($row["def"]) && $row["def"] == $row['quality_title']){ $quality = $row["quality_title"]; } if(!empty($row["defMobile"]) && $row["defMobile"] == $row['quality_title']){ $quality_mobile = $row["quality_title"]; } } $path = substr_replace($path, "", -1);//remove last comma $path .= ']\' '; if(isset($quality)){ $path .= 'data-quality="'.$quality.'" '; } if(isset($quality_mobile)){ $path .= 'data-quality-mobile="'.$quality_mobile.'" '; } }else{ $prefix=''; if($type == "folder_video" || $type == "folder_audio" || $type == "folder_image"){ if(!isset($media["folder_custom_url"]) || $media["folder_custom_url"] == '0'){ $prefix = MVP_FILE_DIR; } } foreach($paths as $r){//only one $row = unserialize($r['options']); if($type == "custom_html"){ $custom_html = $row['path']; $custom_html_id = 'custom_html_id_'.mt_rand(); $p = $custom_html_id; }else{ if($encryptMediaPaths)$p = MVP_BSF_MATCH.base64_encode($prefix.$row['path']); else $p = $prefix.$row['path']; } if($type == "s3_bucket_video" || $type == "s3_video"){ $path = 'data-bucket="'.$p.'" '; }else{ $path = 'data-path="'.$p.'" '; } if($type == "folder_video" || $type == "folder_audio" || $type == "folder_image"){ if(!isset($media["folder_custom_url"]) || $media["folder_custom_url"] == '0'){ $path .= 'data-content-url="'.MVP_FILE_DIR_URL.$row['path'].'" '; } } if(!empty($row["quality_title"])){//yt? $path .= 'data-quality="'.$row["quality_title"].'" '; } if(!empty($row["mp4"])){ $path .= 'data-mp4="'.$row["mp4"].'" '; } } } $track .= $path; } if(!empty($media["exclude"])){ $track .= ' data-exclude="'.$media["exclude"].'"'; } if(!empty($media["bkey"])){ if($encryptMediaPaths)$p = MVP_BSF_MATCH.base64_encode($media['bkey']); else $p = $media['bkey']; $track .= ' data-key="'.$p.'"'; } if(isset($media["account_type"])){ $track .= 'data-user-account="'.$media["account_type"].'" '; } if(isset($media["upload_date"])){ $track .= 'data-upload-date="'.$media["upload_date"].'" '; } if(!empty($media["noapi"])){ $track .= 'data-noapi="1" '; } if(isset($media["lock_time"])){ $track .= 'data-lock-time="'.$media["lock_time"].'" '; } if(!empty($media["user_id"])){ $track .= 'data-user-id="'.$media["user_id"].'" '; } if(!empty($media["is360"])){ $track .= 'data-is360="1" '; } if(!empty($media["vrmode"])){ $track .= 'data-vr-mode="'.$media["vrmode"].'" '; } if(!empty($media["islive"])){ $track .= 'data-live-stream="1" '; } if(!empty($media["thumb"])){ $track .= 'data-thumb="'.$media["thumb"].'" '; } if(!empty($media["alt_text"])){ $track .= 'data-alt="'.$media["alt_text"].'" '; } if(!empty($m["title"])){//$m["title"] because title is sepearated from options! $track .= 'data-title="'.trim($m["title"]).'" '; } if(!empty($media["date"])){ $track .= 'data-date="'.$media["date"].'" '; } if(!empty($media["description"])){ $track .= 'data-description="'.trim($media["description"]).'" '; } if(!empty($media["slideshow_images"])){ $track .= 'data-slideshow-images="'.$media["slideshow_images"].'" '; } if(!empty($media["poster"])){ $track .= 'data-poster="'.$media["poster"].'" '; } if(!empty($media["poster_frame_time"])){ $track .= 'data-poster-frame-time="'.$media["poster_frame_time"].'" '; } if(!empty($media["download"])){ $track .= 'data-download="'.$media["download"].'" '; } if(!empty($media["preview_seek"])){ $track .= 'data-preview-seek="'.$media["preview_seek"].'" '; } if(!empty($media["hover_preview"])){ $track .= 'data-hover-preview="'.$media["hover_preview"].'" '; } if(!empty($media["share"])){ $track .= 'data-share="'.$media["share"].'" '; } if(!empty($media["limit"])){ $track .= 'data-limit="'.$media["limit"].'" '; } if(!empty($media["start"])){ $track .= 'data-start="'.$media["start"].'" '; } if(!empty($media["end"])){ $track .= 'data-end="'.$media["end"].'" '; } if(!empty($media["duration"])){ $track .= 'data-duration="'.$media["duration"].'" '; } if(!empty($media["playback_rate"])){ $track .= 'data-playback-rate="'.$media["playback_rate"].'" '; } if(!empty($media["user_id"])){ $track .= 'data-user-id="'.$media["user_id"].'" '; } if(!empty($media["load_more"]) && $media["load_more"] == '1'){ $track .= 'data-load-more="1" '; } if(!empty($media["chapters"])){ $track .= 'data-chapters="'.$media["chapters"].'" '; if(!empty($media["chapters_cors"])){ $track .= 'data-chapters-cors="'.$media["chapters_cors"].'" '; } } if(!empty($media["vast"])){ $track .= 'data-vast="'.$media["vast"].'" '; } if(!empty($media["link"])){ $track .= 'data-link="'.$media["link"].'" '; if(!empty($media["target"])){ $track .= 'data-target="'.$media["target"].'" '; } } if(!empty($media["end_link"])){ $track .= 'data-end-link="'.$media["end_link"].'" '; if(!empty($media["end_target"])){ $track .= 'data-end-target="'.$media["end_target"].'" '; } } if(isset($media["pi_icons"])){ $track .= ' data-playlist-icons=\'['; $pi_icons = ''; foreach ($media["pi_icons"] as $icon) { $pi_icons .= '{"icon": "'.$icon['icon'].'"'; if(isset($icon['rel']))$pi_icons .= ',"rel": "'.$icon['rel'].'"'; if(isset($icon['title']))$pi_icons .= ',"title": "'.$icon['title'].'"'; if(isset($icon['url']))$pi_icons .= ',"url": "'.$icon['url'].'"'; if(isset($icon['target']))$pi_icons .= ',"target": "'.$icon['target'].'"'; if(isset($icon['class']))$pi_icons .= ',"class": "'.$icon['class'].'"'; $pi_icons .= '},'; } $pi_icons = substr($pi_icons, 0, -1);//remove last comma $track .= $pi_icons; $track .= ']\''; } if($type == "folder"){ if(!empty($media["folder_sort"])){ $track .= 'data-sort="'.$media["folder_sort"].'" '; } if(!empty($media["id3"])){ $track .= 'data-id3="'.$media["id3"].'" '; } } else if($type == "gdrive_folder"){ if(!empty($media["gdrive_sort"])){ $track .= ' data-sort="'.$media["gdrive_sort"].'"'; } } else if($type == "onedrive_folder"){ if(!empty($media["onedrive_sort"])){ $track .= ' data-sort="'.$media["onedrive_sort"].'"'; } } if(!empty($media["sort_type"])){ $track .= 'data-sort="'.$media["sort_type"].'" '; if(!empty($media["sort_dir"])){ $track .= 'data-sort-direction="'.$media["sort_dir"].'" '; } } if(!empty($media["pwd"])){ $track .= 'data-pwd="'.md5($media["pwd"]).'" '; } if(!empty($media["vpwd"])){ $track .= 'data-vpwd="'.base64_encode($media["vpwd"]).'" '; } if(!empty($media["age_verify"])){ $track .= 'data-age-verify="'.$media["age_verify"].'" '; } if(!empty($media["width"])){ $track .= 'data-width="'.$media["width"].'" '; } if(!empty($media["height"])){ $track .= 'data-height="'.$media["height"].'" '; } $track .= '>'; //custom html if($custom_html){ $track .= '
'.$custom_html.'
'; } //subtitles $subtitles = $wpdb->get_results($wpdb->prepare("SELECT options FROM {$subtitle_table} WHERE media_id = %d", $m["id"]), ARRAY_A); if($wpdb->num_rows > 0){ $subtitle = '
'; foreach($subtitles as $r){ $row = unserialize($r['options']); if($encryptMediaPaths)$p = MVP_BSF_MATCH.base64_encode($row['src']); else $p = $row['src']; $subtitle .= '
get_results($wpdb->prepare("SELECT options FROM {$ad_table} WHERE media_id = %d", $m["id"]), ARRAY_A); if($wpdb->num_rows > 0){ $ad_data = array(); foreach($stmt as $item){ $ad_data[] = unserialize($item['options']); } //randomize ad comes from media $ad_options = array(); $ad_options["randomizeAdPre"] = isset($media["randomizeAdPre"]) ? $media["randomizeAdPre"] : '0'; $ad_options["randomizeAdEnd"] = isset($media["randomizeAdEnd"]) ? $media["randomizeAdEnd"] : '0'; include('includes/shortcode_ad_data.php'); } //annotations $stmt = $wpdb->get_results($wpdb->prepare("SELECT options FROM {$annotation_table} WHERE media_id = %d", $m["id"]), ARRAY_A); if($wpdb->num_rows > 0){ $annotation_data = array(); foreach($stmt as $item){ $annotation_data[] = unserialize($item['options']); } include('includes/shortcode_annotation_data.php'); } if(!empty($media["custom_content"])){ $track .= $media["custom_content"]; } $track .= '
';//end div return $track.PHP_EOL; } //############################################// /* export player */ //############################################// function mvp_export_player(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['player_id']) && isset($_POST['player_title'])){ $player_id = $_POST['player_id']; $player_title = $_POST['player_title']; global $wpdb; $wpdb->show_errors(); $player_table = $wpdb->prefix . "mvp_players"; // create zip file $zipname = 'mvp_player_id_'.$player_id.'_'.$player_title.'_'.date('m-d-Y_hia').'.zip'; $zip = new ZipArchive; $upload_path1 = MVP_FILE_DIR."/plzip/"; $zip->open($upload_path1.$zipname, ZipArchive::CREATE); //player $stmt = $wpdb->prepare("SELECT id, title, preset, options, custom_css, custom_js FROM {$player_table} WHERE id = %d", $player_id);//we need to select in specific order for bulk import! $result = $wpdb->get_results($stmt, ARRAY_N); mvp_getOutput("mvp_players", $result, $zip); // close the archive $zip->close(); $upload_path2 = MVP_FILE_DIR_URL."/plzip/"; echo json_encode(array('zip' => $upload_path2.$zipname, 'zip_clean' => $upload_path1.$zipname)); wp_die(); }else{ wp_die(); } } function mvp_import_player(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } header("Content-Type: application/json"); $posted_data = isset( $_POST ) ? $_POST : array(); $file_data = isset( $_FILES ) ? $_FILES : array(); $data = array_merge( $posted_data, $file_data ); $fileName = $data["mvp_file_upload"]["name"]; $temp_name = $data["mvp_file_upload"]["tmp_name"]; $fileError = $data["mvp_file_upload"]["error"]; $upload_path = MVP_FILE_DIR."/plzip/"; $response = array(); if($fileError > 0){ $error = array( 0 => "There is no error, the file uploaded with success", 1 => "The uploaded file exceeds the upload_max_files in server settings", 2 => "The uploaded file exceeds the MAX_FILE_SIZE from html form", 3 => "The uploaded file uploaded only partially", 4 => "No file was uploaded", 6 => "Missing a temporary folder", 7 => "Failed to write file to disk", 8 => "A PHP extension stoped file to upload" ); $response["response"] = "ERROR"; $response["error"] = $error[ $fileError ]; } else { if( move_uploaded_file( $temp_name, $upload_path.$fileName ) ){ //unzip WP_Filesystem(); $unzipfile = unzip_file( $upload_path.$fileName, $upload_path); if ( is_wp_error( $unzipfile ) ) { $response["response"] = "ERROR"; $response["error"] = 'There was an error unzipping the file.'; } else { $response["response"] = "SUCCESS"; //process csv global $wpdb; $wpdb->show_errors(); $player_table = $wpdb->prefix . "mvp_players"; //players $csv = str_replace('\\', '/', $upload_path."mvp_players".'.csv'); if(!file_exists($csv)){//in case wrong zip is uploaded (check only one file) $response["response"] = "ERROR"; $response["error"] = "No player file inside archive!"; echo json_encode( $response ); die(); } $arr = array('player' => MVP_FILE_DIR_URL . '/plzip/' . "mvp_players".'.csv'); echo json_encode($arr); wp_die(); } } else { $response["response"] = "ERROR"; $response["error"]= "Upload Failed!"; } } echo json_encode( $response ); wp_die(); } function mvp_import_player_db(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['player'])){ $player = json_decode(stripcslashes($_POST['player']), true); global $wpdb; $wpdb->show_errors(); $player_table = $wpdb->prefix . "mvp_players"; $stmt = $wpdb->insert( $player_table, array( 'title' => $player[1], 'preset' => $player[2], 'options' => $player[3], 'custom_css' => $player[4], 'custom_js' => $player[5] ), array( '%s','%s','%s','%s','%s' ) ); //delete files $upload_path = MVP_FILE_DIR."/plzip/"; $files = glob($upload_path.'/*'); foreach($files as $file){ if(is_file($file))unlink($file); } if($stmt !== false){ echo json_encode($wpdb->insert_id); } wp_die(); }else { wp_die(); } } //############################################// /* export ads */ //############################################// function mvp_export_ad(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(!extension_loaded('zip'))wp_die('PHP zip extension not installed or enabled!'); if(isset($_POST['ad_id']) && isset($_POST['ad_title'])){ $ad_id = $_POST['ad_id']; $ad_title = $_POST['ad_title']; global $wpdb; $wpdb->show_errors(); $global_ad_table = $wpdb->prefix . "mvp_global_ad"; $ad_table = $wpdb->prefix . "mvp_ad"; $annotation_table = $wpdb->prefix . "mvp_annotation"; // create zip file $zipname = 'mvp_ad_id_'.$ad_id.'_'.$ad_title.'_'.date('m-d-Y_hia').'.zip'; $zip = new ZipArchive; $upload_path1 = MVP_FILE_DIR."/plzip/"; $zip->open($upload_path1.$zipname, ZipArchive::CREATE); //ad $stmt = $wpdb->prepare("SELECT id, title, options FROM {$global_ad_table} WHERE id = %d", $ad_id);//we need to select in specific order for bulk import! $result = $wpdb->get_results($stmt, ARRAY_N); mvp_getOutput("mvp_global_ad", $result, $zip); if($wpdb->num_rows > 0){ //ad $stmt = $wpdb->prepare("SELECT id, options, ad_id FROM {$ad_table} WHERE ad_id = %d", $ad_id); $result = $wpdb->get_results($stmt, ARRAY_N); if($wpdb->num_rows > 0)mvp_getOutput("mvp_ad", $result, $zip); //annotation $stmt = $wpdb->prepare("SELECT id, options, ad_id FROM {$annotation_table} WHERE ad_id = %d", $ad_id); $result = $wpdb->get_results($stmt, ARRAY_N); if($wpdb->num_rows > 0)mvp_getOutput("mvp_annotation", $result, $zip); } // close the archive $zip->close(); $upload_path2 = MVP_FILE_DIR_URL."/plzip/"; echo json_encode(array('zip' => $upload_path2.$zipname, 'zip_clean' => $upload_path1.$zipname)); wp_die(); }else{ wp_die(); } } function mvp_import_ad(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } header("Content-Type: application/json"); $posted_data = isset( $_POST ) ? $_POST : array(); $file_data = isset( $_FILES ) ? $_FILES : array(); $data = array_merge( $posted_data, $file_data ); $fileName = $data["mvp_file_upload"]["name"]; $temp_name = $data["mvp_file_upload"]["tmp_name"]; $fileError = $data["mvp_file_upload"]["error"]; $upload_path = MVP_FILE_DIR."/plzip/"; $response = array(); if($fileError > 0){ $error = array( 0 => "There is no error, the file uploaded with success", 1 => "The uploaded file exceeds the upload_max_files in server settings", 2 => "The uploaded file exceeds the MAX_FILE_SIZE from html form", 3 => "The uploaded file uploaded only partially", 4 => "No file was uploaded", 6 => "Missing a temporary folder", 7 => "Failed to write file to disk", 8 => "A PHP extension stoped file to upload" ); $response["response"] = "ERROR"; $response["error"] = $error[ $fileError ]; } else { if( move_uploaded_file( $temp_name, $upload_path.$fileName ) ){ //unzip WP_Filesystem(); $unzipfile = unzip_file( $upload_path.$fileName, $upload_path); if ( is_wp_error( $unzipfile ) ) { $response["response"] = "ERROR"; $response["error"] = 'There was an error unzipping the file.'; } else { $response["response"] = "SUCCESS"; //process csv global $wpdb; $wpdb->show_errors(); $global_ad_table = $wpdb->prefix . "mvp_global_ad"; $ad_table = $wpdb->prefix . "mvp_ad"; $annotation_table = $wpdb->prefix . "mvp_annotation"; //ads $csv = str_replace('\\', '/', $upload_path."mvp_global_ad".'.csv'); if(!file_exists($csv)){//in case wrong zip is uploaded (check only one file) $response["response"] = "ERROR"; $response["error"] = "No ad file inside archive!"; echo json_encode( $response ); wp_die(); } $arr = array('global_ad' => MVP_FILE_DIR_URL . '/plzip/' . "mvp_global_ad".'.csv'); //ad $csv = str_replace('\\', '/', $upload_path."mvp_ad".'.csv'); if(file_exists($csv)){ $arr['ad'] = MVP_FILE_DIR_URL . '/plzip/' . "mvp_ad".'.csv'; } //annotation $csv = str_replace('\\', '/', $upload_path."mvp_annotation".'.csv'); if(file_exists($csv)){ $arr['annotation'] = MVP_FILE_DIR_URL . '/plzip/' . "mvp_annotation".'.csv'; } echo json_encode($arr); wp_die(); } } else { $response["response"] = "ERROR"; $response["error"]= "Upload Failed!"; } } echo json_encode( $response ); wp_die(); } function mvp_import_ad_db(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['global_ad'])){ $global_ad = json_decode(stripcslashes($_POST['global_ad']), true); global $wpdb; $wpdb->show_errors(); $global_ad_table = $wpdb->prefix . "mvp_global_ad"; $ad_table = $wpdb->prefix . "mvp_ad"; $annotation_table = $wpdb->prefix . "mvp_annotation"; $charset_collate = $wpdb->get_charset_collate(); $stmt = $wpdb->insert( $global_ad_table, array( 'title' => $global_ad[1], 'options' => $global_ad[2] ), array( '%s','%s' ) ); $last_global_ad_id = $wpdb->insert_id; $wpdb->query("SET FOREIGN_KEY_CHECKS=0"); //ad if(isset($_POST['ad'])){ $ad = json_decode(stripcslashes($_POST['ad']), true); $len = count($ad); for($i=0; $i < $len; $i++){ $stmt = $wpdb->insert( $ad_table, array( 'options' => $ad[$i][1], 'ad_id' => $last_global_ad_id ), array( '%s','%d' ) ); } } //annotation if(isset($_POST['annotation'])){ $annotation = json_decode(stripcslashes($_POST['annotation']), true); $len = count($annotation); for($i=0; $i < $len; $i++){ $stmt = $wpdb->insert( $annotation_table, array( 'options' => $annotation[$i][1], 'ad_id' => $last_global_ad_id ), array( '%s','%d' ) ); } } $wpdb->query("SET FOREIGN_KEY_CHECKS=1"); //delete files $upload_path = MVP_FILE_DIR."/plzip/"; $files = glob($upload_path.'/*'); foreach($files as $file){ if(is_file($file))unlink($file); } if($stmt !== false){ echo json_encode($last_global_ad_id); } wp_die(); }else { wp_die(); } } //############################################// /* export playlist */ //############################################// function mvp_export_playlist(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['playlist_id']) && isset($_POST['playlist_title'])){ $playlist_id = $_POST['playlist_id']; $playlist_title = $_POST['playlist_title']; global $wpdb; $wpdb->show_errors(); $playlist_table = $wpdb->prefix . "mvp_playlists"; $media_table = $wpdb->prefix . "mvp_media"; $ad_table = $wpdb->prefix . "mvp_ad"; $annotation_table = $wpdb->prefix . "mvp_annotation"; $path_table = $wpdb->prefix . "mvp_path"; $subtitle_table = $wpdb->prefix . "mvp_subtitle"; // create zip file $zipname = 'mvp_playlist_id_'.$playlist_id.'_'.$playlist_title.'_'.date('m-d-Y_hia').'.zip'; $zip = new ZipArchive; $upload_path1 = MVP_FILE_DIR."/plzip/"; $zip->open($upload_path1.$zipname, ZipArchive::CREATE); //playlist $stmt = $wpdb->prepare("SELECT id, title, options FROM {$playlist_table} WHERE id = %d", $playlist_id);//we need to select in specific order for bulk import! $result = $wpdb->get_results($stmt, ARRAY_N); mvp_getOutput("mvp_playlists", $result, $zip); //media $stmt = $wpdb->prepare("SELECT id, options, order_id, playlist_id FROM {$media_table} WHERE playlist_id = %d", $playlist_id); $result = $wpdb->get_results($stmt, ARRAY_A); if($wpdb->num_rows > 0){ mvp_getOutput("mvp_media", $result, $zip); $ids = array(); foreach($result as $row){ $ids[] = $row['id']; } $in = implode(',', array_fill(0, count($ids), '%d')); //path $stmt = $wpdb->prepare("SELECT id, options, media_id FROM {$path_table} WHERE media_id IN ($in)", $ids); $result = $wpdb->get_results($stmt, ARRAY_N); if($wpdb->num_rows > 0)mvp_getOutput("mvp_path", $result, $zip); //subtitle $stmt = $wpdb->prepare("SELECT id, options, media_id FROM {$subtitle_table} WHERE media_id IN ($in)", $ids); $result = $wpdb->get_results($stmt, ARRAY_N); if($wpdb->num_rows > 0)mvp_getOutput("mvp_subtitle", $result, $zip); //ad $stmt = $wpdb->prepare("SELECT id, options, media_id FROM {$ad_table} WHERE media_id IN ($in)", $ids); $result = $wpdb->get_results($stmt, ARRAY_N); if($wpdb->num_rows > 0)mvp_getOutput("mvp_ad", $result, $zip); //annotation $stmt = $wpdb->prepare("SELECT id, options, media_id FROM {$annotation_table} WHERE media_id IN ($in)", $ids); $result = $wpdb->get_results($stmt, ARRAY_N); if($wpdb->num_rows > 0)mvp_getOutput("mvp_annotation", $result, $zip); } // close the archive $zip->close(); $upload_path2 = MVP_FILE_DIR_URL."/plzip/"; echo json_encode(array('zip' => $upload_path2.$zipname, 'zip_clean' => $upload_path1.$zipname)); wp_die(); }else{ wp_die(); } } function mvp_clean_export(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['zipname'])){ @unlink($_POST['zipname']); } wp_die(); } function mvp_getOutput($table, $result, $zip){ // create a temporary file $size = 1 * 1024 * 1024; $fp = fopen('php://temp/maxmemory:$size', 'w'); if (false === $fp) { die('Failed to create temporary file'); } fprintf($fp, chr(0xEF).chr(0xBB).chr(0xBF)); foreach($result as $row){ $trimmed_array = array_map('trim',array_values($row)); $line = str_replace('^', '', $trimmed_array); fputcsv($fp, $line, '|','^'); } // return to the start of the stream rewind($fp); $zip->addFromString($table.'.csv', stream_get_contents($fp) ); //close the file fclose($fp); } function mvp_import_playlist(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } header("Content-Type: application/json"); $posted_data = isset( $_POST ) ? $_POST : array(); $file_data = isset( $_FILES ) ? $_FILES : array(); $data = array_merge( $posted_data, $file_data ); $fileName = $data["mvp_file_upload"]["name"]; $temp_name = $data["mvp_file_upload"]["tmp_name"]; $fileError = $data["mvp_file_upload"]["error"]; $upload_path = MVP_FILE_DIR."/plzip/"; $response = array(); if($fileError > 0){ $error = array( 0 => "There is no error, the file uploaded with success", 1 => "The uploaded file exceeds the upload_max_files in server settings", 2 => "The uploaded file exceeds the MAX_FILE_SIZE from html form", 3 => "The uploaded file uploaded only partially", 4 => "No file was uploaded", 6 => "Missing a temporary folder", 7 => "Failed to write file to disk", 8 => "A PHP extension stoped file to upload" ); $response["response"] = "ERROR"; $response["error"] = $error[ $fileError ]; } else { if( move_uploaded_file( $temp_name, $upload_path.$fileName ) ){ //unzip WP_Filesystem(); $unzipfile = unzip_file( $upload_path.$fileName, $upload_path); if ( is_wp_error( $unzipfile ) ) { $response["response"] = "ERROR"; $response["error"] = 'There was an error unzipping the file.'; } else { $response["response"] = "SUCCESS"; //process csv global $wpdb; $wpdb->show_errors(); $playlist_table = $wpdb->prefix . "mvp_playlists"; $media_table = $wpdb->prefix . "mvp_media"; $ad_table = $wpdb->prefix . "mvp_ad"; $annotation_table = $wpdb->prefix . "mvp_annotation"; $path_table = $wpdb->prefix . "mvp_path"; $subtitle_table = $wpdb->prefix . "mvp_subtitle"; //playlists $csv = str_replace('\\', '/', $upload_path."mvp_playlists".'.csv'); if(!file_exists($csv)){//in case wrong zip is uploaded (check only one file) $response["response"] = "ERROR"; $response["error"] = "No playlist file inside archive!"; echo json_encode( $response ); wp_die(); } $arr = array('playlist' => MVP_FILE_DIR_URL . '/plzip/' . "mvp_playlists".'.csv'); //media $csv = str_replace('\\', '/', $upload_path."mvp_media".'.csv'); if(file_exists($csv)){ $arr['media'] = MVP_FILE_DIR_URL . '/plzip/' . "mvp_media".'.csv'; } //path $csv = str_replace('\\', '/', $upload_path."mvp_path".'.csv'); if(file_exists($csv)){ $arr['path'] = MVP_FILE_DIR_URL . '/plzip/' . "mvp_path".'.csv'; } //subtitle $csv = str_replace('\\', '/', $upload_path."mvp_subtitle".'.csv'); if(file_exists($csv)){ $arr['subtitle'] = MVP_FILE_DIR_URL . '/plzip/' . "mvp_subtitle".'.csv'; } //ad $csv = str_replace('\\', '/', $upload_path."mvp_ad".'.csv'); if(file_exists($csv)){ $arr['ad'] = MVP_FILE_DIR_URL . '/plzip/' . "mvp_ad".'.csv'; } //annotation $csv = str_replace('\\', '/', $upload_path."mvp_annotation".'.csv'); if(file_exists($csv)){ $arr['annotation'] = MVP_FILE_DIR_URL . '/plzip/' . "mvp_annotation".'.csv'; } echo json_encode($arr); wp_die(); } } else { $response["response"] = "ERROR"; $response["error"]= "Upload Failed!"; } } echo json_encode( $response ); wp_die(); } function mvp_import_playlist_db(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['playlist'])){ $playlist = json_decode(stripcslashes($_POST['playlist']), true); global $wpdb; $wpdb->show_errors(); $charset_collate = $wpdb->get_charset_collate(); $playlist_table = $wpdb->prefix . "mvp_playlists"; $media_table = $wpdb->prefix . "mvp_media"; $path_table = $wpdb->prefix . "mvp_path"; $subtitle_table = $wpdb->prefix . "mvp_subtitle"; $ad_table = $wpdb->prefix . "mvp_ad"; $annotation_table = $wpdb->prefix . "mvp_annotation"; //playlist $stmt = $wpdb->insert( $playlist_table, array( 'title' => $playlist[1], 'options' => $playlist[2] ), array( '%s','%s' ) ); $last_playlist_id = $wpdb->insert_id; $wpdb->query("SET FOREIGN_KEY_CHECKS=0"); //media if(isset($_POST['media'])){ //path if(isset($_POST['path'])){ $path = json_decode(stripcslashes($_POST['path']), true); $path_temp = 'path_temp'.time(); $sql = "CREATE TEMPORARY TABLE {$path_temp} ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `options` longtext NOT NULL, `media_id` int(11) unsigned NOT NULL, PRIMARY KEY (`id`) ) $charset_collate;"; $wpdb->query($sql); $len = count($path); for($i=0; $i < $len; $i++){ $stmt = $wpdb->insert( $path_temp, array( 'options' => $path[$i][1], 'media_id' => $path[$i][2] ), array( '%s','%d' ) ); } } //subtitle if(isset($_POST['subtitle'])){ $subtitle = json_decode(stripcslashes($_POST['subtitle']), true); $subtitle_temp = 'subtitle_temp'.time(); $sql = "CREATE TEMPORARY TABLE {$subtitle_temp} ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `options` longtext NOT NULL, `media_id` int(11) unsigned NOT NULL, PRIMARY KEY (`id`) ) $charset_collate;"; $wpdb->query($sql); $len = count($subtitle); for($i=0; $i < $len; $i++){ $stmt = $wpdb->insert( $subtitle_temp, array( 'options' => $subtitle[$i][1], 'media_id' => $subtitle[$i][2] ), array( '%s','%d' ) ); } } //ad if(isset($_POST['ad'])){ $ad = json_decode(stripcslashes($_POST['ad']), true); $ad_temp = 'ad_temp'.time(); $sql = "CREATE TEMPORARY TABLE {$ad_temp} ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `options` longtext NOT NULL, `media_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;"; $wpdb->query($sql); $len = count($ad); for($i=0; $i < $len; $i++){ $stmt = $wpdb->insert( $ad_temp, array( 'options' => $ad[$i][1], 'media_id' => $ad[$i][2] ), array( '%s','%d' ) ); } } //annotation if(isset($_POST['annotation'])){ $annotation = json_decode(stripcslashes($_POST['annotation']), true); $annotation_temp = 'annotation_temp'.time(); $sql = "CREATE TEMPORARY TABLE {$annotation_temp} ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `options` longtext NOT NULL, `media_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;"; $wpdb->query($sql); $len = count($annotation); for($i=0; $i < $len; $i++){ $stmt = $wpdb->insert( $annotation_temp, array( 'options' => $annotation[$i][1], 'media_id' => $annotation[$i][2], ), array( '%s','%d' ) ); } } //media $media = json_decode(stripcslashes($_POST['media']), true); $len = count($media); for($i=0; $i < $len; $i++){ $stmt = $wpdb->insert( $media_table, array( 'options' => $media[$i][1], 'order_id' => $media[$i][2], 'playlist_id' => $last_playlist_id ), array( '%s','%d','%d' ) ); $old_media_id = $media[$i][0]; $last_media_id = $wpdb->insert_id; //path if(isset($_POST['path'])){ $sql = "INSERT INTO $path_table (id, options, media_id) SELECT NULL, options, $last_media_id FROM {$path_temp} WHERE media_id='$old_media_id'"; $wpdb->query($sql); } //subtitles if(isset($_POST['subtitle'])){ $sql = "INSERT INTO $subtitle_table (id, options, media_id) SELECT NULL, options, $last_media_id FROM {$subtitle_temp} WHERE media_id='$old_media_id'"; $wpdb->query($sql); } //ad if(isset($_POST['ad'])){ $sql = "INSERT INTO $ad_table (id, options, media_id) SELECT NULL, options, $last_media_id FROM {$ad_temp} WHERE media_id='$old_media_id'"; $wpdb->query($sql); } //annotation if(isset($_POST['annotation'])){ $sql = "INSERT INTO $annotation_table (id, options, media_id) SELECT NULL, options, $last_media_id FROM {$annotation_temp} WHERE media_id='$old_media_id'"; $wpdb->query($sql); } } }//end if media exist //drop temp tables if(isset($path_temp))$wpdb->query("DROP TABLE {$path_temp}"); if(isset($subtitle_temp))$wpdb->query("DROP TABLE {$subtitle_temp}"); if(isset($ad_temp))$wpdb->query("DROP TABLE {$ad_temp}"); if(isset($annotation_temp))$wpdb->query("DROP TABLE {$annotation_temp}"); $wpdb->query("SET FOREIGN_KEY_CHECKS=1"); //delete files $upload_path = MVP_FILE_DIR."/plzip/"; $files = glob($upload_path.'/*'); foreach($files as $file){ if(is_file($file))unlink($file); } if($stmt !== false){ echo json_encode($last_playlist_id); } wp_die(); }else { wp_die(); } } //############################################// /* ads */ //############################################// function mvp_edit_ad_title(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['title']) && isset($_POST['id'])){ $title = stripcslashes($_POST["title"]); $id = $_POST["id"]; global $wpdb; $global_ad_table = $wpdb->prefix . "mvp_global_ad"; $wpdb->update( $global_ad_table, array( 'title' => $title ), array('id' => $id), array( '%s' ), array( '%d' ) ); echo json_encode(""); wp_die(); }else{ wp_die(); } } function mvp_delete_ad(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['ad_id'])){ $ad_id = $_POST['ad_id']; global $wpdb; $wpdb->show_errors(); $global_ad_table = $wpdb->prefix . "mvp_global_ad"; $ids = explode(',',$ad_id); $in = implode(',', array_fill(0, count($ids), '%d')); $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$global_ad_table} WHERE id IN ($in)", $ids)); if($stmt !== false){ echo json_encode($stmt); } wp_die(); }else{ wp_die(); } } function mvp_duplicate_ad(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['ad_id'])){ $ad_id = $_POST['ad_id']; $title = $_POST['title']; global $wpdb; $wpdb->show_errors(); $global_ad_table = $wpdb->prefix . "mvp_global_ad"; $ad_table = $wpdb->prefix . "mvp_ad"; $annotation_table = $wpdb->prefix . "mvp_annotation"; $stmt = $wpdb->prepare("SELECT options FROM {$global_ad_table} WHERE id = %d", $ad_id); if($stmt !== false){ $result = $wpdb->get_row($stmt, ARRAY_A); $stmt = $wpdb->insert(//copy ad $global_ad_table, array( 'title' => $title, 'options' => $result['options'] ), array( '%s', '%s' ) ); $insert_id = $wpdb->insert_id; //ads $stmt = $wpdb->get_results($wpdb->prepare("SELECT options FROM {$ad_table} WHERE ad_id = %d", $ad_id), ARRAY_A); foreach($stmt as $item){ $wpdb->insert( $ad_table, array( 'options' => $item['options'], 'ad_id' => $insert_id ), array( '%s','%d' ) ); } //annotations $stmt = $wpdb->get_results($wpdb->prepare("SELECT options FROM {$annotation_table} WHERE ad_id = %d", $ad_id), ARRAY_A); foreach($stmt as $item){ $wpdb->insert( $annotation_table, array( 'options' => $item['options'], 'ad_id' => $insert_id ), array( '%s','%d' ) ); } if($stmt !== false){ echo json_encode($insert_id); } } wp_die(); }else{ wp_die(); } } function mvp_save_ad_options(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['ad_id'])){ $ad_id = $_POST['ad_id']; global $wpdb; $wpdb->show_errors(); $global_ad_table = $wpdb->prefix . "mvp_global_ad"; $ad_table = $wpdb->prefix . "mvp_ad"; $annotation_table = $wpdb->prefix . "mvp_annotation"; $global_ad_options = json_decode(stripcslashes($_POST['global_ad_options']), true); $stmt = $wpdb->update( $global_ad_table, array('options' => serialize($global_ad_options)), array('id' => $ad_id), array('%s'), array('%d') ); //ads //delete current values $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$ad_table} WHERE ad_id = %d", $ad_id)); if(!empty($_POST['ad_pre'])){ $ad_pre = json_decode(stripcslashes($_POST['ad_pre']), true); for($i = 0; $i < count($ad_pre); $i++){ $stmt = $wpdb->insert( $ad_table, array( 'options' => serialize($ad_pre[$i]), 'ad_id' => $ad_id ), array( '%s','%d' ) ); } } if(!empty($_POST['ad_mid'])){ $ad_mid = json_decode(stripcslashes($_POST['ad_mid']), true); for($i = 0; $i < count($ad_mid); $i++){ $stmt = $wpdb->insert( $ad_table, array( 'options' => serialize($ad_mid[$i]), 'ad_id' => $ad_id ), array( '%s','%d' ) ); } } if(!empty($_POST['ad_end'])){ $ad_end = json_decode(stripcslashes($_POST['ad_end']), true); for($i = 0; $i < count($ad_end); $i++){ $stmt = $wpdb->insert( $ad_table, array( 'options' => serialize($ad_end[$i]), 'ad_id' => $ad_id ), array( '%s','%d' ) ); } } //annotations //delete current values $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$annotation_table} WHERE ad_id = %d", $ad_id)); if(!empty($_POST['annotation'])){ $annotation = json_decode(stripcslashes($_POST['annotation']), true); for($i = 0; $i < count($annotation); $i++){ $stmt = $wpdb->insert( $annotation_table, array( 'options' => serialize($annotation[$i]), 'ad_id' => $ad_id ), array( '%s','%d' ) ); } } if($stmt !== false){ echo json_encode($stmt); } wp_die(); }else{ wp_die(); } } function mvp_ad_domain_rename(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['ad_id'])){ $ad_id = $_POST['ad_id']; $from = $_POST['from']; $to = $_POST['to']; global $wpdb; $wpdb->show_errors(); $global_ad_table = $wpdb->prefix . "mvp_global_ad"; $ad_table = $wpdb->prefix . "mvp_ad"; $annotation_table = $wpdb->prefix . "mvp_annotation"; //ads $stmt = $wpdb->get_results($wpdb->prepare("SELECT options FROM {$ad_table} WHERE ad_id = %d", $ad_id), ARRAY_A); $ad_data_global = array(); foreach($stmt as $item){ $mp = unserialize($item['options']); $mp['path'] = str_replace($from, $to, $mp['path']); if(isset($mp['poster']))$mp['poster'] = str_replace($from, $to, $mp['poster']); $ad_data_global[] = $mp; } //delete current values $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$ad_table} WHERE ad_id = %d", $ad_id)); //inset for($i = 0; $i < count($ad_data_global); $i++){ $stmt = $wpdb->insert( $ad_table, array( 'options' => serialize($ad_data_global[$i]), 'ad_id' => $ad_id ), array( '%s','%d' ) ); } //annotations $stmt = $wpdb->get_results($wpdb->prepare("SELECT options FROM {$annotation_table} WHERE ad_id = %d", $ad_id), ARRAY_A); $annotation_data_global = array(); foreach($stmt as $item){ $mp = unserialize($item['options']); $mp['path'] = str_replace($from, $to, $mp['path']); $annotation_data_global[] = $mp; } //delete current values $stmt = $wpdb->query($wpdb->prepare("DELETE FROM {$annotation_table} WHERE ad_id = %d", $ad_id)); //insert for($i = 0; $i < count($annotation_data_global); $i++){ $stmt = $wpdb->insert( $annotation_table, array( 'options' => serialize($annotation_data_global[$i]), 'ad_id' => $ad_id ), array( '%s','%d' ) ); } echo json_encode(""); wp_die(); }else{ wp_die(); } } function mvp_create_ad(){ if ( ! check_ajax_referer( 'mvp-security-nonce', 'security' ) ) { wp_send_json_error( 'Invalid security token sent.' ); wp_die(); } if(isset($_POST['title'])){ $title = stripslashes($_POST['title']); global $wpdb; $wpdb->show_errors(); $global_ad_table = $wpdb->prefix . "mvp_global_ad"; $stmt = $wpdb->insert( $global_ad_table, array( 'title' => $title ), array( '%s' ) ); if($stmt !== false){ echo json_encode($wpdb->insert_id); } wp_die(); }else{ wp_die(); } } function mvp_getAdData($atts){ $ad_id = $atts['ad_id']; global $wpdb; $global_ad_table = $wpdb->prefix . "mvp_global_ad"; $ad_table = $wpdb->prefix . "mvp_ad"; $annotation_table = $wpdb->prefix . "mvp_annotation"; $ad_options = null; $ad_data = null; $annotation_data = null; //options $stmt = $wpdb->get_row($wpdb->prepare("SELECT options FROM {$global_ad_table} WHERE id = %d", $ad_id), ARRAY_A); $ad_options = unserialize($stmt['options']); //ads $stmt = $wpdb->get_results($wpdb->prepare("SELECT options FROM {$ad_table} WHERE ad_id = %d", $ad_id), ARRAY_A); if($wpdb->num_rows > 0){ $ad_data = array(); foreach($stmt as $item){ $ad_data[] = unserialize($item['options']); } } //annotations $stmt = $wpdb->get_results($wpdb->prepare("SELECT options FROM {$annotation_table} WHERE ad_id = %d", $ad_id), ARRAY_A); if($wpdb->num_rows > 0){ $annotation_data = array(); foreach($stmt as $item){ $annotation_data[] = unserialize($item['options']); } } return array('ad_options' => $ad_options, 'ad_data' => $ad_data, 'annotation_data' => $annotation_data); } //############################################// /* front end playlist display */ //############################################// function mvp_playlist_display($atts){ global $wpdb; $playlist_table = $wpdb->prefix . "mvp_playlists"; $data = array(); if(isset($atts['playlist_id'])){ $playlist_id = explode(',', $atts['playlist_id']); }else{ return ''; } $in = implode(',', array_fill(0, count($playlist_id), '%d')); $playlist_id = array_merge($playlist_id,$playlist_id); $results = $wpdb->get_results($wpdb->prepare("SELECT id, title, options FROM {$playlist_table} WHERE id IN ($in) ORDER BY FIELD(id, $in)", $playlist_id), ARRAY_A); foreach($results as $result){ $pl_options = unserialize($result['options']); $data[] = array('id' => $result['id'], 'title' => $result['title'], 'description' => isset($pl_options['description']) ? $pl_options['description'] : null, 'thumb' => $pl_options['thumb']); } $id = 'mvp-playlist-display-wrap-'.mt_rand();//to limit selector for click $markup = '
'; if(!empty($atts['header_title'])){ $markup .= '
'.esc_html($atts['header_title']).'
'; } $markup .= '
'; foreach($data as $d){ if(isset($atts['active_playlist']) && $atts['active_playlist'] == $d['id'])$active_class = ' mvp-playlist-display-item-active'; else $active_class = ''; $markup .= '
'; $markup .= '
'; if(isset($d['thumb'])){ $markup .= ''.esc_attr($d['title']).''; } $markup .= '
'.esc_html($d['title']).'
'; $markup .= '
';//mvp-playlist-display-item-inner if(isset($d['description'])){ $markup .= '
'.$d['description'].'
'; } $markup .= '
';//mvp-playlist-display-item } $markup .= '
';//mvp-playlist-display-wrap if(isset($atts['player_id'])){ $player_id = $atts['player_id']; //click to load playlist in player $markup .= ''; } return $markup; } //############################################// /* install */ //############################################// function mvp_player_uninstall() { global $wpdb; $settings_table = $wpdb->prefix . "mvp_settings"; $result = $wpdb->get_row("SELECT options FROM {$settings_table} WHERE id = '0'", ARRAY_A); if($result){ $settings = unserialize($result['options']); $delete_plugin_data_on_uninstall = isset($settings["delete_plugin_data_on_uninstall"]) ? (bool)($settings["delete_plugin_data_on_uninstall"]) : false; if($delete_plugin_data_on_uninstall){ global $wpdb; if ( is_multisite() ) { $site_ids = $wpdb->get_col( "SELECT blog_id FROM $wpdb->blogs WHERE site_id = $wpdb->siteid;" ); foreach ( $site_ids as $site_id ) { switch_to_blog( $site_id ); mvp_deinstall(); restore_current_blog(); } }else{ mvp_deinstall(); } } } } function mvp_deinstall() { global $wpdb; $wpdb->show_errors(); $wpdb->query('SET foreign_key_checks=0'); $settings_table = $wpdb->prefix . "mvp_settings"; $sql = "DROP TABLE IF EXISTS $settings_table;"; $wpdb->query($sql); $player_table = $wpdb->prefix . "mvp_players"; $sql = "DROP TABLE IF EXISTS $player_table;"; $wpdb->query($sql); $path_table = $wpdb->prefix . "mvp_path"; $sql = "DROP TABLE IF EXISTS $path_table;"; $wpdb->query($sql); $subtitle_table = $wpdb->prefix . "mvp_subtitle"; $sql = "DROP TABLE IF EXISTS $subtitle_table;"; $wpdb->query($sql); $ad_table = $wpdb->prefix . "mvp_ad"; $sql = "DROP TABLE IF EXISTS $ad_table;"; $wpdb->query($sql); $annotation_table = $wpdb->prefix . "mvp_annotation"; $sql = "DROP TABLE IF EXISTS $annotation_table;"; $wpdb->query($sql); $watched_percentage_table = $wpdb->prefix . "mvp_watched_percentage"; $sql = "DROP TABLE IF EXISTS $watched_percentage_table;"; $wpdb->query($sql); $media_table = $wpdb->prefix . "mvp_media"; $sql = "DROP TABLE IF EXISTS $media_table;"; $wpdb->query($sql); $playlist_table = $wpdb->prefix . "mvp_playlists"; $sql = "DROP TABLE IF EXISTS $playlist_table;"; $wpdb->query($sql); $global_ad_table = $wpdb->prefix . "mvp_global_ad"; $sql = "DROP TABLE IF EXISTS $global_ad_table;"; $wpdb->query($sql); $statistics_country_table = $wpdb->prefix . "mvp_statistics_country"; $sql = "DROP TABLE IF EXISTS $statistics_country_table;"; $wpdb->query($sql); $statistics_country_play_table = $wpdb->prefix . "mvp_statistics_country_play"; $sql = "DROP TABLE IF EXISTS $statistics_country_play_table;"; $wpdb->query($sql); $statistics_user_table = $wpdb->prefix . "mvp_statistics_user"; $sql = "DROP TABLE IF EXISTS $statistics_user_table;"; $wpdb->query($sql); $statistics_user_play_table = $wpdb->prefix . "mvp_statistics_user_play"; $sql = "DROP TABLE IF EXISTS $statistics_user_play_table;"; $wpdb->query($sql); $statistics_table = $wpdb->prefix . "mvp_statistics"; $sql = "DROP TABLE IF EXISTS $statistics_table;"; $wpdb->query($sql); $wpdb->query('SET foreign_key_checks=1'); delete_option('mvp_video_player_version'); } function mvp_player_activate($network_wide){ global $wpdb; if ( is_multisite() ) { if ($network_wide) { $site_ids = $wpdb->get_col( "SELECT blog_id FROM $wpdb->blogs WHERE site_id = $wpdb->siteid;" ); foreach ( $site_ids as $site_id ) { switch_to_blog( $site_id ); mvp_install(); restore_current_blog(); } }else{ mvp_install(); } }else{ mvp_install(); } } function mvp_install(){ //database global $wpdb; $wpdb->show_errors(); $charset_collate = $wpdb->get_charset_collate(); require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); //WHEN altering tables, playlist_manager.php copy playlist; mvp.php copy tracks, import playlist! $settings_table = $wpdb->prefix . "mvp_settings"; if($wpdb->get_var( "show tables like '$settings_table'" ) != $settings_table){ $sql = "CREATE TABLE $settings_table ( `id` tinyint NOT NULL, `options` text, PRIMARY KEY (`id`) ) $charset_collate;"; dbDelta( $sql ); } $player_table = $wpdb->prefix . "mvp_players"; if($wpdb->get_var( "show tables like '$player_table'" ) != $player_table){ $sql = "CREATE TABLE $player_table ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL, `preset` varchar(50) NOT NULL, `options` text DEFAULT NULL, `custom_css` longtext DEFAULT NULL, `custom_js` longtext DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;"; dbDelta( $sql ); } $playlist_table = $wpdb->prefix . "mvp_playlists"; if($wpdb->get_var( "show tables like '$playlist_table'" ) != $playlist_table){ $sql = "CREATE TABLE $playlist_table ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL, `options` text DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;"; dbDelta( $sql ); } $media_table = $wpdb->prefix . "mvp_media"; if($wpdb->get_var( "show tables like '$media_table'" ) != $media_table){ $sql = "CREATE TABLE $media_table ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(300) DEFAULT NULL, `options` longtext DEFAULT NULL, `order_id` int(11) unsigned DEFAULT NULL, `playlist_id` int(11) unsigned NOT NULL, `disabled` tinyint DEFAULT 0, PRIMARY KEY (`id`), INDEX `playlist_id` (`playlist_id`) ) $charset_collate;"; dbDelta( $sql ); } $path_table = $wpdb->prefix . "mvp_path"; if($wpdb->get_var( "show tables like '$path_table'" ) != $path_table){ $sql = "CREATE TABLE $path_table ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `options` longtext DEFAULT NULL, `media_id` int(11) unsigned NOT NULL, `playlist_id` int(11) unsigned, PRIMARY KEY (`id`), INDEX `media_id` (`media_id`) ) $charset_collate;"; dbDelta( $sql ); } $subtitle_table = $wpdb->prefix . "mvp_subtitle"; if($wpdb->get_var( "show tables like '$subtitle_table'" ) != $subtitle_table){ $sql = "CREATE TABLE $subtitle_table ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `options` longtext DEFAULT NULL, `media_id` int(11) unsigned NOT NULL, `playlist_id` int(11) unsigned, PRIMARY KEY (`id`), INDEX `media_id` (`media_id`) ) $charset_collate;"; dbDelta( $sql ); } $ad_table = $wpdb->prefix . "mvp_ad"; if($wpdb->get_var( "show tables like '$ad_table'" ) != $ad_table){ $sql = "CREATE TABLE $ad_table ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `options` longtext DEFAULT NULL, `media_id` int(11) unsigned DEFAULT NULL, `playlist_id` int(11) unsigned, `ad_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), INDEX `media_id` (`media_id`) ) $charset_collate;"; dbDelta( $sql ); } $annotation_table = $wpdb->prefix . "mvp_annotation"; if($wpdb->get_var( "show tables like '$annotation_table'" ) != $annotation_table){ $sql = "CREATE TABLE $annotation_table ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `options` longtext DEFAULT NULL, `media_id` int(11) unsigned DEFAULT NULL, `playlist_id` int(11) unsigned, `ad_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), INDEX `media_id` (`media_id`) ) $charset_collate;"; dbDelta( $sql ); } $global_ad_table = $wpdb->prefix . "mvp_global_ad"; if($wpdb->get_var( "show tables like '$global_ad_table'" ) != $global_ad_table){ $sql = "CREATE TABLE $global_ad_table ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL, `options` longtext DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;"; dbDelta( $sql ); } $statistics_table = $wpdb->prefix . "mvp_statistics"; if($wpdb->get_var( "show tables like '$statistics_table'" ) != $statistics_table){ $sql = "CREATE TABLE $statistics_table ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `origtype` varchar(20) DEFAULT NULL, `title` varchar(300) DEFAULT NULL, `c_play` int(11) unsigned DEFAULT '0', `c_time` int(11) unsigned DEFAULT '0', `c_download` int(11) DEFAULT '0', `c_finish` int(11) unsigned DEFAULT '0', `c_date` date DEFAULT NULL, `media_id` int(11) unsigned NOT NULL, `playlist_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), INDEX `media_id` (`media_id`) ) $charset_collate;"; dbDelta( $sql ); } } function mvp_plugins_loaded() { //file dir for reading files from directory if(!file_exists(MVP_FILE_DIR))wp_mkdir_p(MVP_FILE_DIR); $upload_path = MVP_FILE_DIR."/plzip/"; if(!file_exists($upload_path))wp_mkdir_p($upload_path); load_plugin_textdomain(MVP_TEXTDOMAIN, false, dirname( plugin_basename( __FILE__ ) ) . '/languages/'); $current_version = get_option('mvp_video_player_version'); if($current_version == FALSE){ update_option('mvp_video_player_version', '1.0'); } $current_version = get_option('mvp_video_player_version'); global $wpdb; $wpdb->show_errors(); $charset_collate = $wpdb->get_charset_collate(); require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); $settings_table = $wpdb->prefix . "mvp_settings"; $player_table = $wpdb->prefix . "mvp_players"; $media_table = $wpdb->prefix . "mvp_media"; $playlist_table = $wpdb->prefix . "mvp_playlists"; $path_table = $wpdb->prefix . "mvp_path"; $subtitle_table = $wpdb->prefix . "mvp_subtitle"; $ad_table = $wpdb->prefix . "mvp_ad"; $annotation_table = $wpdb->prefix . "mvp_annotation"; $statistics_table = $wpdb->prefix . "mvp_statistics"; $watched_percentage_table = $wpdb->prefix . "mvp_watched_percentage"; $sql = "SHOW COLUMNS FROM {$settings_table} LIKE 'options'"; $result = $wpdb->query($sql); if($wpdb->num_rows == 0){ $sql = "ALTER TABLE {$settings_table} ADD COLUMN `options` text"; $result = $wpdb->query($sql); } //custom css $sql = "SHOW COLUMNS FROM {$player_table} LIKE 'custom_css'"; $result = $wpdb->query($sql); if($wpdb->num_rows == 0){ $sql = "ALTER TABLE {$player_table} ADD COLUMN `custom_css` longtext DEFAULT NULL"; $result = $wpdb->query($sql); } //custom javascript $sql = "SHOW COLUMNS FROM {$player_table} LIKE 'custom_js'"; $result = $wpdb->query($sql); if($wpdb->num_rows == 0){ $sql = "ALTER TABLE {$player_table} ADD COLUMN `custom_js` longtext DEFAULT NULL"; $result = $wpdb->query($sql); } //remove playlist id, ads are now sepearate from playlists, add column ad_id. $sql = "SHOW COLUMNS FROM {$ad_table} LIKE 'ad_id'"; $result = $wpdb->query($sql); if($wpdb->num_rows == 0){ $sql = "ALTER TABLE {$ad_table} ADD COLUMN `ad_id` int(11) unsigned DEFAULT NULL"; $result = $wpdb->query($sql); } $sql = "SHOW COLUMNS FROM {$annotation_table} LIKE 'ad_id'"; $result = $wpdb->query($sql); if($wpdb->num_rows == 0){ $sql = "ALTER TABLE {$annotation_table} ADD COLUMN `ad_id` int(11) unsigned DEFAULT NULL"; $result = $wpdb->query($sql); } //ad global ad table for ads and annotations $global_ad_table = $wpdb->prefix . "mvp_global_ad"; if($wpdb->get_var( "show tables like '$global_ad_table'" ) != $global_ad_table){ $sql = "CREATE TABLE $global_ad_table ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL, `options` longtext NOT NULL, PRIMARY KEY (`id`) ) $charset_collate;"; dbDelta( $sql ); } //statistics if($wpdb->get_var( "show tables like '$statistics_table'" ) != $statistics_table){ $sql = "CREATE TABLE $statistics_table ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `origtype` varchar(20) DEFAULT NULL, `title` varchar(300) NOT NULL, `c_play` int(11) unsigned NOT NULL, `c_time` int(11) unsigned NOT NULL, `c_date` date NOT NULL, `media_id` int(11) unsigned NOT NULL, `playlist_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), INDEX `media_id` (`media_id`) ) $charset_collate;"; dbDelta( $sql ); } $watched_percentage_table = $wpdb->prefix . "mvp_watched_percentage"; if($wpdb->get_var( "show tables like '$watched_percentage_table'" ) != $watched_percentage_table){ $sql = "CREATE TABLE $watched_percentage_table ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(300) DEFAULT NULL, `watched` MEDIUMINT unsigned DEFAULT NULL, `duration` MEDIUMINT unsigned DEFAULT NULL, `media_id` int(11) unsigned DEFAULT NULL, `playlist_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), INDEX `media_id` (`media_id`) ) $charset_collate;"; dbDelta( $sql ); } //add title so we can sort videos by title $sql = "SHOW COLUMNS FROM {$media_table} LIKE 'title'"; $result = $wpdb->query($sql); if($wpdb->num_rows == 0){ $sql = "ALTER TABLE {$media_table} ADD COLUMN `title` varchar(300) DEFAULT NULL"; $result = $wpdb->query($sql); //move title $media_data = $wpdb->get_results("SELECT id, options FROM {$media_table}", ARRAY_A); $values = array(); $place_holders = array(); foreach ($media_data as $d) { $options = unserialize($d['options']); foreach($options as $key => $value){ if($key == 'title' && !empty($value)){ array_push( $values, $value, $d['id']); $place_holders[] = "('%s', '%d')"; } } } if(count($values)){ $query = "INSERT INTO $media_table (title, id) VALUES "; $query .= implode( ', ', $place_holders ); $query .= "ON DUPLICATE KEY UPDATE title=VALUES(title)"; $wpdb->query( $wpdb->prepare( "$query ", $values ) ); } } //stats finish and download $sql = "SHOW COLUMNS FROM {$statistics_table} LIKE 'c_download'"; $result = $wpdb->query($sql); if($wpdb->num_rows == 0){ $sql = "ALTER TABLE {$statistics_table} ADD COLUMN `c_download` int(11) DEFAULT '0', ADD COLUMN `c_finish` int(11) unsigned DEFAULT '0'"; $result = $wpdb->query($sql); } $sql = "SHOW COLUMNS FROM {$path_table} LIKE 'playlist_id'"; $result = $wpdb->query($sql); if($wpdb->num_rows == 0){ $sql = "ALTER TABLE {$path_table} ADD COLUMN `playlist_id` int(11) unsigned"; $result = $wpdb->query($sql); } $sql = "SHOW COLUMNS FROM {$subtitle_table} LIKE 'playlist_id'"; $result = $wpdb->query($sql); if($wpdb->num_rows == 0){ $sql = "ALTER TABLE {$subtitle_table} ADD COLUMN `playlist_id` int(11) unsigned"; $result = $wpdb->query($sql); } $sql = "SHOW COLUMNS FROM {$ad_table} LIKE 'playlist_id'"; $result = $wpdb->query($sql); if($wpdb->num_rows == 0){ $sql = "ALTER TABLE {$ad_table} ADD COLUMN `playlist_id` int(11) unsigned"; $result = $wpdb->query($sql); } $sql = "SHOW COLUMNS FROM {$annotation_table} LIKE 'playlist_id'"; $result = $wpdb->query($sql); if($wpdb->num_rows == 0){ $sql = "ALTER TABLE {$annotation_table} ADD COLUMN `playlist_id` int(11) unsigned"; $result = $wpdb->query($sql); } $statistics_country_table = $wpdb->prefix . "mvp_statistics_country"; if($wpdb->get_var( "show tables like '$statistics_country_table'" ) != $statistics_country_table){ $sql = "CREATE TABLE $statistics_country_table ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `country` varchar(100), `country_code` varchar(10), `continent` varchar(15), PRIMARY KEY (`id`) ) $charset_collate;"; dbDelta( $sql ); } $statistics_country_play_table = $wpdb->prefix . "mvp_statistics_country_play"; if($wpdb->get_var( "show tables like '$statistics_country_play_table'" ) != $statistics_country_play_table){ $sql = "CREATE TABLE $statistics_country_play_table ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(300), `thumb` varchar(300), `video_url` varchar(300), `c_play` int(11) unsigned, `c_time` int(11) unsigned, `c_date` date, `media_id` int(11) unsigned, `playlist_id` int(11) unsigned, `country_id` int(11) unsigned, PRIMARY KEY (`id`), INDEX `media_id` (`media_id`) ) $charset_collate;"; dbDelta( $sql ); } $statistics_user_table = $wpdb->prefix . "mvp_statistics_user"; if($wpdb->get_var( "show tables like '$statistics_user_table'" ) != $statistics_user_table){ $sql = "CREATE TABLE $statistics_user_table ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` smallint(11) unsigned, `user_display_name` varchar(100), `user_role` varchar(50), PRIMARY KEY (`id`), INDEX `user_id` (`user_id`) ) $charset_collate;"; dbDelta( $sql ); } $statistics_user_play_table = $wpdb->prefix . "mvp_statistics_user_play"; if($wpdb->get_var( "show tables like '$statistics_user_play_table'" ) != $statistics_user_play_table){ $sql = "CREATE TABLE $statistics_user_play_table ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(300), `thumb` varchar(300), `video_url` varchar(300), `c_play` int(11) unsigned, `c_time` int(11) unsigned, `c_date` date, `media_id` int(11) unsigned, `playlist_id` int(11) unsigned, `user_id` int(11) unsigned, PRIMARY KEY (`id`), INDEX `media_id` (`media_id`) ) $charset_collate;"; dbDelta( $sql ); } //disabled $sql = "SHOW COLUMNS FROM {$media_table} LIKE 'disabled'"; $result = $wpdb->query($sql); if($wpdb->num_rows == 0){ $sql = "ALTER TABLE {$media_table} ADD COLUMN `disabled` tinyint DEFAULT 0"; $result = $wpdb->query($sql); } update_option('mvp_video_player_version', 8.02); } ?>