PHP iriValueTable示例

示例#1

文件： statpresscn.php 项目： hewu/blogwp

function iriStatPressMobiler()
{
    $mobileosset = "('Windows CE','iPhone','iPod','Nokia','SonyEricsson','SAMSUNG','NEC','Moto','Dopod','Amoi','Symbian','Lenovo','KBT_N650B')";
    $mobilebrowserset = "('Opera Mini','UCWEB','J2ME','MAUI WAP Browser')";
    $mobilemysqlstr = " and (os in {$mobileosset} or browser in {$mobilebrowserset} or searchengine like '%mobile%' or searchengine like '%wap%')";
    # Top page
    iriValueTable("urlrequested", __("Top pages", "statpresscn"), 10, "", "urlrequested", "AND feed='' and spider=''" . $mobilemysqlstr);
    # Top referrer，不统计搜索引擎
    iriValueTable("referrer", __("Top referrer", "statpresscn"), 10, "", "", "AND referrer!='' AND referrer NOT LIKE '%" . get_bloginfo('url') . "%' AND searchengine=''" . $mobilemysqlstr);
    # Search terms
    iriValueTable("search", __("Top search terms", "statpresscn"), 15, "", "", "AND search!=''" . $mobilemysqlstr);
    # SE
    iriValueTable("searchengine", __("Search engine", "statpresscn"), 10, "", "", "AND searchengine!=''" . $mobilemysqlstr);
    # Browser
    iriValueTable("browser", __("Browser", "statpresscn"), 10, "", "", "AND feed='' AND spider='' AND browser!=''" . $mobilemysqlstr);
    # O.S.
    iriValueTable("os", __("OS", "statpresscn"), 10, "", "", "AND feed='' AND spider='' AND os!=''" . $mobilemysqlstr);
    # Countries
    iriValueTable("nation", __("Countries (city)", "statpresscn"), 15, "", "", "AND nation!='' AND spider=''" . $mobilemysqlstr);
    # Top Days - Unique visitors
    iriValueTable("date", __("Top Days - Unique visitors", "statpresscn"), 5, "distinct", "ip", "AND feed='' and spider=''" . $mobilemysqlstr);
    /* Maddler 04112007: required patching iriValueTable */
    # Top Days - Pageviews
    iriValueTable("date", __("Top Days - Pageviews", "statpresscn"), 5, "", "urlrequested", "AND feed='' and spider=''" . $mobilemysqlstr);
    /* Maddler 04112007: required patching iriValueTable */
    # Top IPs - Pageviews
    iriValueTable("ip", __("Top IPs - Pageviews", "statpresscn"), 5, "", "urlrequested", "AND feed='' and spider=''" . $mobilemysqlstr);
    /* Maddler 04112007: required patching iriValueTable */
    heart5_print_spc_footer();
}

示例#2

文件： statpress.php 项目： jojospaghettio/wicketpixie

function iriStatPressDetails()
{
    global $wpdb;
    $table_name = $wpdb->prefix . "statpress";
    $querylimit = "LIMIT 10";
    // Top days
    iriValueTable("date", __('Top days', 'statpress'), 5);
    // O.S.
    iriValueTable("os", __('O.S.', 'statpress'), 0, "", "", "AND feed='' AND spider='' AND os<>''");
    // Browser
    iriValueTable("browser", __('Browser', 'statpress'), 0, "", "", "AND feed='' AND spider='' AND browser<>''");
    // Feeds
    iriValueTable("feed", __('Feeds', 'statpress'), 5, "", "", "AND feed<>''");
    // SE
    iriValueTable("searchengine", __('Search engines', 'statpress'), 10, "", "", "AND searchengine<>''");
    // Search terms
    iriValueTable("search", __('Top search terms', 'statpress'), 20, "", "", "AND search<>''");
    // Top referrer
    iriValueTable("referrer", __('Top referrer', 'statpress'), 10, "", "", "AND referrer<>'' AND referrer NOT LIKE '%" . get_bloginfo('url') . "%'");
    // Countries
    iriValueTable("nation", __('Countries (domains)', 'statpress'), 10, "", "", "AND nation<>'' AND spider=''");
    // Spider
    iriValueTable("spider", __('Spiders', 'statpress'), 10, "", "", "AND spider<>''");
    // Top Pages
    iriValueTable("urlrequested", __('Top pages', 'statpress'), 5, "", "urlrequested", "AND feed='' and spider=''");
    // Top Days - Unique visitors
    iriValueTable("date", __('Top Days - Unique visitors', 'statpress'), 5, "distinct", "ip", "AND feed='' and spider=''");
    /* Maddler 04112007: required patching iriValueTable */
    // Top Days - Pageviews
    iriValueTable("date", __('Top Days - Pageviews', 'statpress'), 5, "", "urlrequested", "AND feed='' and spider=''");
    /* Maddler 04112007: required patching iriValueTable */
    // Top IPs - Pageviews
    iriValueTable("ip", __('Top IPs - Pageviews', 'statpress'), 5, "", "urlrequested", "AND feed='' and spider=''");
    /* Maddler 04112007: required patching iriValueTable */
}

示例#3

文件： statpress.php 项目： jcbozonier/master/AutoBlogs/BudgetingBlogSetup/BudgetingBlog/wp-content/plugins/statpress/statpress.php

function iriStatPressDetails()
{
    global $wpdb;
    $table_name = $wpdb->prefix . "statpress";
    $querylimit = "LIMIT 10";
    # Top days
    iriValueTable("date", "Top days", 5);
    # O.S.
    iriValueTable("os", "O.S.", 0, "", "", "AND feed='' AND spider='' AND os<>''");
    # Browser
    iriValueTable("browser", "Browser", 0, "", "", "AND feed='' AND spider='' AND browser<>''");
    # Feeds
    iriValueTable("feed", "Feeds", 5, "", "", "AND feed<>''");
    # SE
    iriValueTable("searchengine", "Search engines", 10, "", "", "AND searchengine<>''");
    # Search terms
    iriValueTable("search", "Top search terms", 20, "", "", "AND search<>''");
    # Top referrer
    iriValueTable("referrer", "Top referrer", 10, "", "", "AND referrer<>'' AND referrer NOT LIKE '%" . get_bloginfo('url') . "%'");
    # Countries
    iriValueTable("nation", "Countries (domains)", 10, "", "", "AND nation<>'' AND spider=''");
    # Spider
    iriValueTable("spider", "Spiders", 10, "", "", "AND spider<>''");
    # Top Pages
    iriValueTable("urlrequested", "Top pages", 5, "", "urlrequested", "AND feed='' and spider=''");
    # Top Days - Unique visitors
    iriValueTable("date", "Top Days - Unique visitors", 5, "distinct", "ip", "AND feed='' and spider=''");
    /* Maddler 04112007: required patching iriValueTable */
    # Top Days - Pageviews
    iriValueTable("date", "Top Days - Pageviews", 5, "", "urlrequested", "AND feed='' and spider=''");
    /* Maddler 04112007: required patching iriValueTable */
    # Top IPs - Pageviews
    iriValueTable("ip", "Top IPs - Pageviews", 5, "", "urlrequested", "AND feed='' and spider=''");
    /* Maddler 04112007: required patching iriValueTable */
}