WordPress.org
Get WordPress

Plugin Directory

Changeset 2618790


Ignore:
Timestamp:
10/23/2021 02:29:50 PM (4 years ago)
Author:
crisworth
Message:

Feature update

Location:
mondoplayer/trunk
Files:
4 edited

Legend:

Unmodified
Added
Removed

  • mondoplayer/trunk/includes/class_mondoplayer_autopilot.php

    r2618072 r2618790  
    290290        $views = null;
    291291
    292         if ( $wpdb->get_var( "SHOW TABLES LIKE 'wp_mondoplayer_ad_tracking'" ) === 'wp_mondoplayer_ad_tracking' ) {
    293             $views = $wpdb->get_results("SELECT COUNT(*) as total, autopilot_id FROM wp_mondoplayer_ad_tracking WHERE add_date > DATE_SUB(CURDATE(), INTERVAL 90 DAY) AND autopilot_id > 0 GROUP BY autopilot_id", OBJECT);
     292        if ( $wpdb->get_var( "SHOW TABLES LIKE 'wp_mondoplayer_ad_stats'" ) === 'wp_mondoplayer_ad_stats' ) {
     293            $views = $wpdb->get_results("SELECT COUNT(*) as total, autopilot_id FROM wp_mondoplayer_ad_stats WHERE add_date > DATE_SUB(CURDATE(), INTERVAL 90 DAY) AND autopilot_id > 0 GROUP BY autopilot_id", OBJECT);
    294294        } else if ( $wpdb->get_var( "SHOW TABLES LIKE 'wp_statify'" ) === 'wp_statify' ) {
    295295            $views = $wpdb->get_results("SELECT COUNT(*) as total, wp_postmeta.meta_value as autopilot_id FROM wp_statify, wp_posts, wp_postmeta WHERE wp_statify.created > DATE_SUB(NOW(), INTERVAL 90 DAY) AND wp_posts.post_name = REPLACE(SUBSTRING_INDEX(wp_statify.target, '/', 2), '/', '') AND wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = 'mondoplayer_autopilot_id' AND wp_statify.target <> '/' GROUP BY wp_postmeta.meta_value", OBJECT);
    … …  
    936936        <option value='7'>Last 7 Days</option>
    937937        <option value='14'>Last 14 Days</option>
    938         <option value='30'>Last 30 Days</option>
    939         <option value='90' selected>Last 90 Days</option>
     938        <option value='30' selected>Last 30 Days</option>
     939        <option value='90'>Last 90 Days</option>
    940940    </select> <input type="button" value="Update" class="form_submit_btn_light" onclick='get_autopilot_report()' style='display:inline-block; width: initial' /> <input type="button" name="report" id="report" class="form_submit_btn_light" value="Back" onclick='close_autopilot_report_details()' style='background-color: white; color: rgb(0, 115, 170); border: 1px solid rgb(0, 115, 170);margin: 0;display: inline-block;float:right' /></p>
    941941<div id="autopilot_report_popup" class='right_sub_page right_panel_form' style="display: none">

  • mondoplayer/trunk/includes/class_mondoplayer_forms.php

    r2593356 r2618790  
    484484            );
    485485        }
     486        if ( $wpdb->get_var( "SHOW TABLES LIKE 'wp_mondoplayer_ad_stats'" ) === 'wp_mondoplayer_ad_stats' ) {
     487            $report['views'] = $wpdb->get_results("SELECT COUNT(*) as total, wp_posts.ID as ID, wp_posts.post_title, wp_mondoplayer_ad_stats.autopilot_id as autopilot_id, (SELECT meta_value FROM wp_postmeta WHERE post_id = wp_posts.ID AND meta_key = 'mondoplayer_search_terms' ) as search_terms, DAYOFYEAR(wp_mondoplayer_ad_stats.add_date) as day FROM wp_mondoplayer_ad_stats, wp_posts, wp_postmeta WHERE wp_mondoplayer_ad_stats.add_date > DATE_SUB(CURDATE(), INTERVAL 90 DAY) AND wp_posts.ID = wp_mondoplayer_ad_stats.post_id AND wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = 'mondoplayer_autopilot_id' AND wp_postmeta.meta_value = " . intval($_POST['autopilot_id']) . " AND wp_mondoplayer_ad_stats.post_id <> 0 GROUP BY wp_posts.ID, wp_postmeta.meta_value, day", OBJECT);
     488        } else {
    486489        $report['views'] = $wpdb->get_results("SELECT COUNT(*) as total, wp_posts.ID as ID, wp_posts.post_title, wp_postmeta.meta_value as autopilot_id, (SELECT meta_value FROM wp_postmeta WHERE post_id = wp_posts.ID AND meta_key = 'mondoplayer_search_terms' ) as search_terms, DAYOFYEAR(wp_statify.created) as day FROM wp_statify, wp_posts, wp_postmeta WHERE wp_statify.created > DATE_SUB(NOW(), INTERVAL 90 DAY) AND wp_posts.post_name = REPLACE(SUBSTRING_INDEX(wp_statify.target, '/', 2), '/', '') AND wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = 'mondoplayer_autopilot_id' AND wp_postmeta.meta_value = " . intval($_POST['autopilot_id']) . " AND wp_statify.target <> '/' GROUP BY wp_posts.ID, wp_statify.target, wp_postmeta.meta_value, day", OBJECT);
     490        }
    487491
    488492        header("Content-Type: application/json");

  • mondoplayer/trunk/js/web_player_v2.js

    r2618072 r2618790  
    42564256
    42574257    for (var i = 0; i < new_domains.length; i++) {
    4258         var new_domain = trim_domain(new_domains[i]);
     4258        var new_domain = trim_domain(new_domains[i], true);
    42594259        if (new_domain != "") {
    42604260            if (excluded_domains.indexOf(new_domain) > -1) {
    … …  
    42654265    }
    42664266    for (var i = 0; i < new_domains.length; i++) {
    4267         var new_domain = trim_domain(new_domains[i]);
     4267        var new_domain = trim_domain(new_domains[i], true);
    42684268        if (new_domain != "") {
    42694269            excluded_domains.push(new_domain);
    … …  
    46474647
    46484648    for (var i = 0; i < new_domains.length; i++) {
    4649         var new_domain = trim_domain(new_domains[i]);
     4649        var new_domain = trim_domain(new_domains[i], false);
    46504650        if (new_domain != "") {
    46514651            if (trusted_domains.indexOf(new_domain) > -1) {
    … …  
    46604660            new_domain = new_domains[i];
    46614661        } else {
    4662             new_domain = trim_domain(new_domains[i]);
     4662            new_domain = trim_domain(new_domains[i], false);
    46634663        }
    46644664        console.log("new domain: " + new_domain);
    … …  
    67256725
    67266726    for (var i = 0; i < new_domains.length; i++) {
    6727         var new_domain = trim_domain(new_domains[i]);
     6727        var new_domain = trim_domain(new_domains[i], true);
    67286728        if (new_domain != "") {
    67296729            excluded_domains.push(new_domain);
    … …  
    94019401}
    94029402
    9403 function trim_domain(domain) {
     9403function trim_domain(domain, include_path) {
    94049404    var regexp = /[\w\.-]+/gi;
    94059405    var matches = domain.match(regexp);
    94069406    var retval = "";
    94079407    for (var i = 0; i < matches.length; i++) {
    9408         if (matches[i].indexOf(".") > -1) {
     9408        if (retval != "" && matches[i].length > 0 && include_path) {
     9409            retval = retval + "/" + matches[i];
     9410        } else if (matches[i].indexOf(".") > -1) {
    94099411            retval = matches[i];
    9410             break;
    94119412        }
    94129413    }

  • mondoplayer/trunk/mondoplayer.php

    r2618073 r2618790  
    55    Description: Video Content Curation Plugin - automatically curate and share videos. Boost engagement on your website and in social media with compelling video.
    66    Author: MondoTag
    7     Version: 1.0.352
     7    Version: 1.0.353
    88    Tested up to: 5.7.2
    99    License: GPLv2 or later
    … …  
    188188
    189189        wp_register_style( $this->mondoplayer_plugin_slug, plugins_url("css/web_player.css",__FILE__), false, '1.0.52' );
    190         wp_register_script( $this->mondoplayer_plugin_slug, plugins_url("js/web_player_v2.js",__FILE__), false, '1.0.121' );
     190        wp_register_script( $this->mondoplayer_plugin_slug, plugins_url("js/web_player_v2.js",__FILE__), false, '1.0.122' );
    191191        $db = get_option("mondoplayer_db_version", '');
    192192        if ($db != $db_version) {
Note: See TracChangeset for help on using the changeset viewer.