Example #1
0
function iri_StatPress_Vars($body)
{
    global $wpdb;
    $table_name = $wpdb->prefix . "statpress";
    $normallimit = " and (statuscode!='404' or statuscode is null)";
    $today = gmdate('Ymd', current_time('timestamp'));
    $yesterday = gmdate('Ymd', current_time('timestamp') - 86400);
    //今天来访者数量
    if (strpos(strtolower($body), "%visits%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as pageview FROM {$table_name} WHERE date = {$today} and spider='' and feed=''{$normallimit};");
        $body = str_replace("%visits%", $qry[0]->pageview, $body);
    }
    //昨天来访者数量
    if (strpos(strtolower($body), "%yesterdayvisits%") !== FALSE) {
        $body = str_replace("%yesterdayvisits%", get_option("statpress_archive_yesterday_visitors"), $body);
    }
    //来访者数量总计
    if (strpos(strtolower($body), "%totalvisits%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as pageview FROM {$table_name} WHERE spider='' and feed=''{$normallimit};");
        $body = str_replace("%totalvisits%", $qry[0]->pageview, $body);
    }
    //今天页面访问数量
    if (strpos(strtolower($body), "%pagevisits%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT count(*) as pageview FROM {$table_name} WHERE spider='' and feed='' and date={$today}{$normallimit};");
        $body = str_replace("%pagevisits%", $qry[0]->pageview, $body);
    }
    //昨天页面访问数量总计
    if (strpos(strtolower($body), "%yesterdaypagevisits%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT count(*) as pageview FROM {$table_name} WHERE spider='' and feed='' and date = {$yesterday}{$normallimit};");
        $body = str_replace("%yesterdaypagevisits%", get_option("statpress_archive_yesterday_pageviews"), $body);
    }
    //页面访问数量总计
    if (strpos(strtolower($body), "%totalpagevisits%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT count(*) as pageview FROM {$table_name} WHERE spider='' and feed=''{$normallimit};");
        $body = str_replace("%totalpagevisits%", $qry[0]->pageview, $body);
    }
    //当前页面被访问次数
    if (strpos(strtolower($body), "%thistotalvisits%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT count(*) as pageview FROM {$table_name} WHERE spider='' and feed='' AND urlrequested='" . iri_StatPress_URL() . "'{$normallimit};");
        $body = str_replace("%thistotalvisits%", $qry[0]->pageview, $body);
    }
    //统计起始日期
    if (strpos(strtolower($body), "%since%") !== FALSE) {
        $body = str_replace("%since%", get_option("statpress_date_first_sets"), $body);
    }
    //操作系统(当前访问者)
    if (strpos(strtolower($body), "%os%") !== FALSE) {
        $userAgent = isset($_SERVER['HTTP_USER_AGENT']) ? $_SERVER['HTTP_USER_AGENT'] : '';
        $os = iriGetOS($userAgent);
        $body = str_replace("%os%", $os, $body);
    }
    //浏览器(当前访问者)
    if (strpos(strtolower($body), "%browser%") !== FALSE) {
        $browser = iriGetBrowser($userAgent);
        $body = str_replace("%browser%", $browser, $body);
    }
    //IP地址(当前访问者)
    if (strpos(strtolower($body), "%ip%") !== FALSE) {
        $ipAddress = $_SERVER['REMOTE_ADDR'];
        $body = str_replace("%ip%", $ipAddress, $body);
    }
    //FROM何地(当前访问者)
    if (strpos(strtolower($body), "%comefrom%") !== FALSE) {
        $comeFrom = iriDomain($_SERVER['REMOTE_ADDR']);
        $body = str_replace("%comefrom%", $comeFrom, $body);
    }
    //%pagesyouvisited%
    //if(strpos(strtolower($body),"%pagesyouvisited%") !== FALSE) {
    //    $pagesyouvisited = $_SESSION['views'];
    //    $body = str_replace("%pagesyouvisited%", $pagesyouvisited, $body);
    //}
    //最近一段时间(10分钟内)的访问者数量,类似于在线人数
    if (strpos(strtolower($body), "%visitorsonline%") !== FALSE) {
        $to_time = current_time('timestamp');
        $from_time = strtotime('-10 minutes', $to_time);
        $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as visitors FROM {$table_name} WHERE spider='' and feed='' AND timestamp BETWEEN {$from_time} AND {$to_time}{$normallimit};");
        $body = str_replace("%visitorsonline%", $qry[0]->visitors, $body);
    }
    //最近一段时间(10分钟内)的用户数量,这里用户指的登记在册的内容贡献者或订阅者
    if (strpos(strtolower($body), "%usersonline%") !== FALSE) {
        $to_time = current_time('timestamp');
        $from_time = strtotime('-10 minutes', $to_time);
        $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as users FROM {$table_name} WHERE spider='' and feed='' AND user!='' AND timestamp BETWEEN {$from_time} AND {$to_time}{$normallimit};");
        $body = str_replace("%usersonline%", $qry[0]->users, $body);
    }
    //访问最多的帖子
    if (strpos(strtolower($body), "%toppost%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT urlrequested,count(*) as totale FROM {$table_name} WHERE spider='' AND feed='' and pvalue !='' and pvalue !=0{$normallimit} GROUP BY pvalue ORDER BY totale DESC LIMIT 1;");
        $body = str_replace("%toppost%", iri_StatPress_Decode($qry[0]->urlrequested), $body);
    }
    //使用最多的浏览器
    if (strpos(strtolower($body), "%topbrowser%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT browser,count(*) as totale FROM {$table_name} WHERE spider='' AND feed=''{$normallimit} GROUP BY browser ORDER BY totale DESC LIMIT 1;");
        $body = str_replace("%topbrowser%", iri_StatPress_Decode($qry[0]->browser), $body);
    }
    //使用最多的操作系统
    if (strpos(strtolower($body), "%topos%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT os,count(*) as totale FROM {$table_name} WHERE spider='' AND feed=''{$normallimit} GROUP BY os ORDER BY totale DESC LIMIT 1;");
        $body = str_replace("%topos%", iri_StatPress_Decode($qry[0]->os), $body);
    }
    //订阅数
    if (strpos(strtolower($body), "%feeds%") !== FALSE) {
        $body = str_replace("%feeds%", iri_StatPress_FeedCount(), $body);
    }
    //blog文章总数,add by 蚊子
    if (strpos(strtolower($body), "%blogtotalpost%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT count(ID) as pageview FROM {$wpdb->posts} WHERE post_status = 'publish' and post_type = 'post';");
        $body = str_replace("%blogtotalpost%", $qry[0]->pageview, $body);
    }
    //blog页面总数
    if (strpos(strtolower($body), "%blogtotalpage%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT count(ID) as pageview FROM {$wpdb->posts} WHERE post_status = 'publish' and post_type = 'page';");
        $body = str_replace("%blogtotalpage%", $qry[0]->pageview, $body);
    }
    //留言者总数
    if (strpos(strtolower($body), "%blogtotalcommentor%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT count(distinct(comment_author)) as pageview FROM {$wpdb->comments} WHERE comment_approved = '1';");
        $body = str_replace("%blogtotalcommentor%", $qry[0]->pageview, $body);
    }
    //留言总数
    if (strpos(strtolower($body), "%blogtotalcomment%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT count(*) as pageview FROM {$wpdb->comments} WHERE comment_approved = '1';");
        $body = str_replace("%blogtotalcomment%", $qry[0]->pageview, $body);
    }
    return $body;
}
Example #2
0
function iri_StatPress_Vars($body)
{
    global $wpdb;
    $table_name = $wpdb->prefix . "statpress";
    if (strpos(strtolower($body), "%visits%") !== false) {
        $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as pageview FROM {$table_name} WHERE date = '" . gmdate("Ymd", current_time('timestamp')) . "' and spider='' and feed='';");
        $body = str_replace("%visits%", $qry[0]->pageview, $body);
    }
    if (strpos(strtolower($body), "%totalvisits%") !== false) {
        $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as pageview FROM {$table_name} WHERE spider='' and feed='';");
        $body = str_replace("%totalvisits%", $qry[0]->pageview, $body);
    }
    if (strpos(strtolower($body), "%thistotalvisits%") !== false) {
        $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as pageview FROM {$table_name} WHERE spider='' and feed='' AND urlrequested='" . mysql_real_escape_string(iri_StatPress_URL()) . "';");
        $body = str_replace("%thistotalvisits%", $qry[0]->pageview, $body);
    }
    if (strpos(strtolower($body), "%since%") !== false) {
        $qry = $wpdb->get_results("SELECT date FROM {$table_name} ORDER BY date LIMIT 1;");
        $body = str_replace("%since%", irihdate($qry[0]->date), $body);
    }
    if (strpos(strtolower($body), "%os%") !== false) {
        $userAgent = isset($_SERVER['HTTP_USER_AGENT']) ? $_SERVER['HTTP_USER_AGENT'] : '';
        $os = iriGetOS($userAgent);
        $body = str_replace("%os%", $os, $body);
    }
    if (strpos(strtolower($body), "%browser%") !== false) {
        $browser = iriGetBrowser($userAgent);
        $body = str_replace("%browser%", $browser, $body);
    }
    if (strpos(strtolower($body), "%ip%") !== false) {
        $ipAddress = $_SERVER['REMOTE_ADDR'];
        $body = str_replace("%ip%", $ipAddress, $body);
    }
    if (strpos(strtolower($body), "%visitorsonline%") !== false) {
        $to_time = current_time('timestamp');
        $from_time = strtotime('-4 minutes', $to_time);
        $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as visitors FROM {$table_name} WHERE spider='' and feed='' AND timestamp BETWEEN {$from_time} AND {$to_time};");
        $body = str_replace("%visitorsonline%", $qry[0]->visitors, $body);
    }
    if (strpos(strtolower($body), "%usersonline%") !== false) {
        $to_time = current_time('timestamp');
        $from_time = strtotime('-4 minutes', $to_time);
        $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as users FROM {$table_name} WHERE spider='' and feed='' AND user<>'' AND timestamp BETWEEN {$from_time} AND {$to_time};");
        $body = str_replace("%usersonline%", $qry[0]->users, $body);
    }
    if (strpos(strtolower($body), "%toppost%") !== false) {
        $qry = $wpdb->get_results("SELECT urlrequested,count(*) as totale FROM {$table_name} WHERE spider='' AND feed='' AND urlrequested LIKE '%p=%' GROUP BY urlrequested ORDER BY totale DESC LIMIT 1;");
        $body = str_replace("%toppost%", iri_StatPress_Decode($qry[0]->urlrequested), $body);
    }
    if (strpos(strtolower($body), "%topbrowser%") !== false) {
        $qry = $wpdb->get_results("SELECT browser,count(*) as totale FROM {$table_name} WHERE spider='' AND feed='' GROUP BY browser ORDER BY totale DESC LIMIT 1;");
        $body = str_replace("%topbrowser%", iri_StatPress_Decode($qry[0]->browser), $body);
    }
    if (strpos(strtolower($body), "%topos%") !== false) {
        $qry = $wpdb->get_results("SELECT os,count(*) as totale FROM {$table_name} WHERE spider='' AND feed='' GROUP BY os ORDER BY totale DESC LIMIT 1;");
        $body = str_replace("%topos%", iri_StatPress_Decode($qry[0]->os), $body);
    }
    if (strpos(strtolower($body), "%pagestoday%") !== false) {
        $qry = $wpdb->get_results("SELECT count(ip) as pageview FROM {$table_name} WHERE date = '" . gmdate("Ymd", current_time('timestamp')) . "' and spider='' and feed='';");
        $body = str_replace("%pagestoday%", $qry[0]->pageview, $body);
    }
    if (strpos(strtolower($body), "%thistotalpages%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT count(ip) as pageview FROM {$table_name} WHERE spider='' and feed='';");
        $body = str_replace("%thistotalpages%", $qry[0]->pageview, $body);
    }
    if (strpos(strtolower($body), "%latesthits%") !== false) {
        $qry = $wpdb->get_results("SELECT search FROM {$table_name} WHERE search <> '' ORDER BY id DESC LIMIT 10");
        $body = str_replace("%latesthits%", $qry[0]->search, $body);
        for ($counter = 0; $counter < 10; $counter += 1) {
            $body .= "<br>" . $qry[$counter]->search;
        }
    }
    if (strpos(strtolower($body), "%pagesyesterday%") !== false) {
        $yesterday = gmdate('Ymd', current_time('timestamp') - 86400);
        $qry = $wpdb->get_row("SELECT count(DISTINCT ip) AS visitsyesterday FROM {$table_name} WHERE feed='' AND spider='' AND date = '" . mysql_real_escape_string($yesterday) . "'");
        $body = str_replace("%pagesyesterday%", iri_StatPress_Decode($qry[0]->visitsyesterday), $body);
    }
    return $body;
}
function iri_StatPress_Vars($body)
{
    global $wpdb;
    $table_name = $wpdb->prefix . "statpress";
    if (strpos(strtolower($body), "%visits%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as pageview FROM {$table_name} WHERE date = '" . gmdate("Ymd", current_time('timestamp')) . "' and spider='' and feed='';");
        $body = str_replace("%visits%", $qry[0]->pageview, $body);
    }
    if (strpos(strtolower($body), "%totalvisits%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as pageview FROM {$table_name} WHERE spider='' and feed='';");
        $body = str_replace("%totalvisits%", $qry[0]->pageview, $body);
    }
    if (strpos(strtolower($body), "%thistotalvisits%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as pageview FROM {$table_name} WHERE spider='' and feed='' AND urlrequested='" . iri_StatPress_URL() . "';");
        $body = str_replace("%thistotalvisits%", $qry[0]->pageview, $body);
    }
    if (strpos(strtolower($body), "%since%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT date FROM {$table_name} ORDER BY date LIMIT 1;");
        $body = str_replace("%since%", irihdate($qry[0]->date), $body);
    }
    if (strpos(strtolower($body), "%os%") !== FALSE) {
        $userAgent = isset($_SERVER['HTTP_USER_AGENT']) ? $_SERVER['HTTP_USER_AGENT'] : '';
        $os = iriGetOS($userAgent);
        $body = str_replace("%os%", $os, $body);
    }
    if (strpos(strtolower($body), "%browser%") !== FALSE) {
        $browser = iriGetBrowser($userAgent);
        $body = str_replace("%browser%", $browser, $body);
    }
    if (strpos(strtolower($body), "%ip%") !== FALSE) {
        $ipAddress = $_SERVER['REMOTE_ADDR'];
        $body = str_replace("%ip%", $ipAddress, $body);
    }
    if (strpos(strtolower($body), "%visitorsonline%") !== FALSE) {
        $to_time = current_time('timestamp');
        $from_time = strtotime('-4 minutes', $to_time);
        $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as visitors FROM {$table_name} WHERE spider='' and feed='' AND timestamp BETWEEN {$from_time} AND {$to_time};");
        $body = str_replace("%visitorsonline%", $qry[0]->visitors, $body);
    }
    if (strpos(strtolower($body), "%usersonline%") !== FALSE) {
        $to_time = current_time('timestamp');
        $from_time = strtotime('-4 minutes', $to_time);
        $qry = $wpdb->get_results("SELECT count(DISTINCT(ip)) as users FROM {$table_name} WHERE spider='' and feed='' AND user<>'' AND timestamp BETWEEN {$from_time} AND {$to_time};");
        $body = str_replace("%usersonline%", $qry[0]->users, $body);
    }
    if (strpos(strtolower($body), "%toppost%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT urlrequested,count(*) as totale FROM wp_statpress WHERE spider='' AND feed='' AND urlrequested LIKE '%p=%' GROUP BY urlrequested ORDER BY totale DESC LIMIT 1;");
        $body = str_replace("%toppost%", iri_StatPress_Decode($qry[0]->urlrequested), $body);
    }
    if (strpos(strtolower($body), "%topbrowser%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT browser,count(*) as totale FROM wp_statpress WHERE spider='' AND feed='' GROUP BY browser ORDER BY totale DESC LIMIT 1;");
        $body = str_replace("%topbrowser%", iri_StatPress_Decode($qry[0]->browser), $body);
    }
    if (strpos(strtolower($body), "%topos%") !== FALSE) {
        $qry = $wpdb->get_results("SELECT os,count(*) as totale FROM wp_statpress WHERE spider='' AND feed='' GROUP BY os ORDER BY totale DESC LIMIT 1;");
        $body = str_replace("%topos%", iri_StatPress_Decode($qry[0]->os), $body);
    }
    return $body;
}