PHP phpAds_dbNumRows函数代码示例

function phpAds_getDaysLeft($campaignid)
{
    global $phpAds_config;
    global $date_format;
    // uses the following language settings:
    global $strExpiration, $strNoExpiration, $strDaysLeft, $strEstimated;
    // preset return values
    $estimated_end = "-";
    $days_left = "-";
    $description = "";
    $absolute = 0;
    // Get client record
    $campaign_query = "SELECT" . " views" . ",clicks" . ",expire" . ",DATE_FORMAT(expire, '" . $date_format . "') as expire_f" . ",TO_DAYS(expire)-TO_DAYS(NOW()) as days_left" . " FROM " . $phpAds_config['tbl_campaigns'] . " WHERE campaignid=" . $campaignid;
    $res_campaign = phpAds_dbQuery($campaign_query) or phpAds_sqlDie();
    if (phpAds_dbNumRows($res_campaign) == 1) {
        $row_campaign = phpAds_dbFetchArray($res_campaign);
        // Check if the expiration date is set
        if ($row_campaign['expire'] != '0000-00-00' && $row_campaign['expire'] != '') {
            $expiration[] = array("days_left" => round($row_campaign["days_left"]), "date" => $row_campaign["expire_f"], "absolute" => true);
        }
        if ($row_campaign["views"] != -1) {
            $view_query = "SELECT" . " SUM(views) as total_views" . ",MAX(TO_DAYS(day))-TO_DAYS(NOW()) as days_since_last_view" . ",TO_DAYS(NOW())-MIN(TO_DAYS(day)) as days_since_start" . " FROM " . $phpAds_config['tbl_banners'] . " AS b" . " LEFT JOIN " . $phpAds_config['tbl_adstats'] . " AS v" . " USING (bannerid)" . " WHERE b.campaignid=" . $campaignid;
            $res_views = phpAds_dbQuery($view_query) or phpAds_sqlDie();
            if (phpAds_dbNumRows($res_views) == 1) {
                $row_views = phpAds_dbFetchArray($res_views);
                if (!isset($row_views["days_since_start"]) || $row_views["days_since_start"] == '' || $row_views["days_since_start"] == 0 || $row_views["days_since_start"] == null) {
                    $row_views["days_since_start"] = 1;
                }
                if (!empty($row_views["total_views"]) && $row_views["total_views"] > 0) {
                    $days_left = round($row_campaign["views"] / ($row_views["total_views"] / $row_views["days_since_start"]));
                    if ($row_campaign["views"] > 0) {
                        $estimated_end = strftime($date_format, mktime(0, 0, 0, date("m"), date("d") + $days_left, date("Y")));
                        $expiration[] = array("days_left" => $days_left, "date" => $estimated_end, "absolute" => false);
                    } else {
                        $estimated_end = strftime($date_format, mktime(0, 0, 0, date("m"), date("d") - $row_views["days_since_last_view"], date("Y")));
                        $expiration[] = array("days_left" => 0 - $row_views["days_since_last_view"], "date" => $estimated_end, "absolute" => true);
                    }
                }
            }
        }
        if ($row_campaign["clicks"] != -1) {
            $click_query = "SELECT" . " SUM(clicks) as total_clicks" . ",MAX(TO_DAYS(day))-TO_DAYS(NOW()) as days_since_last_click" . ",TO_DAYS(NOW())-MIN(TO_DAYS(day)) as days_since_start" . " FROM " . $phpAds_config['tbl_adstats'] . " LEFT JOIN " . $phpAds_config['tbl_banners'] . " USING (bannerid)" . " WHERE campaignid=" . $clientid . " AND clicks > 0";
            $res_clicks = phpAds_dbQuery($click_query) or phpAds_sqlDie();
            if (phpAds_dbNumRows($res_clicks) == 1) {
                $row_clicks = phpAds_dbFetchArray($res_clicks);
                if (!isset($row_clicks["days_since_start"]) || $row_clicks["days_since_start"] == '' || $row_clicks["days_since_start"] == 0 || $row_clicks["days_since_start"] == null) {
                    $row_clicks["days_since_start"] = 1;
                }
                if (!empty($row_clicks["total_clicks"]) && $row_clicks["total_clicks"] > 0) {
                    $days_left = round($row_campaign["clicks"] / ($row_clicks["total_clicks"] / $row_clicks["days_since_start"]));
                    if ($row_campaign["clicks"] > 0) {
                        $estimated_end = strftime($date_format, mktime(0, 0, 0, date("m"), date("d") + $days_left, date("Y")));
                        $expiration[] = array("days_left" => $days_left, "date" => $estimated_end, "absolute" => false);
                    } else {
                        $estimated_end = strftime($date_format, mktime(0, 0, 0, date("m"), date("d") - $row_clicks["days_since_last_view"], date("Y")));
                        $expiration[] = array("days_left" => 0 - $row_clicks["days_since_last_view"], "date" => $estimated_end, "absolute" => true);
                    }
                }
            }
        }
    }
    // Build Return value
    if (isset($expiration) && sizeof($expiration) > 0) {
        $sooner = $expiration[0];
        for ($i = 0; $i < sizeof($expiration); $i++) {
            if ($expiration[$i]['days_left'] < $sooner['days_left']) {
                $sooner = $expiration[$i];
            }
        }
        if ($sooner['days_left'] < 0) {
            $sooner['days_left'] = 0;
        }
        if ($sooner['absolute']) {
            $ret_val[] = $strExpiration . ": " . $sooner['date'] . " (" . $strDaysLeft . ": " . $sooner['days_left'] . ")";
        } else {
            $ret_val[] = $strEstimated . ": " . $sooner['date'] . " (" . $strDaysLeft . ": " . $sooner['days_left'] . ")";
        }
        $ret_val[] = $sooner['date'];
        $ret_val[] = $sooner['days_left'];
    } else {
        // Unknown
        $ret_val[] = $strExpiration . ": " . $strNoExpiration;
        $ret_val[] = '';
        $ret_val[] = '';
    }
    return isset($ret_val) ? $ret_val : false;
}

                $zone_count++;
                $row['linked'] = true;
                $affiliates[$row['affiliateid']]['zones'][$row['zoneid']] = $row;
                $affiliates[$row['affiliateid']]['ZoneCampaigns']++;
            }
        }
    }
} else {
    if (phpAds_isUser(phpAds_Admin)) {
        $query = "SELECT" . " z.zoneid as zoneid" . ",z.affiliateid as affiliateid" . ",z.zonename as zonename" . ",z.description as description" . ",z.width as width" . ",z.height as height" . ",z.what as what" . ",z.zonetype as zonetype" . ",z.delivery as delivery" . " FROM " . $phpAds_config['tbl_zones'] . " AS z" . "," . $phpAds_config['tbl_banners'] . " AS b" . " WHERE b.bannerid=" . $bannerid . " AND (z.width=b.width OR z.width=-1)" . " AND (z.height=b.height OR z.height=-1)" . " AND z.zonetype=" . phpAds_ZoneBanners . " AND z.delivery != " . phpAds_ZoneText . phpAds_getZoneListOrder($listorder, $orderdirection);
    } elseif (phpAds_isUser(phpAds_Agency)) {
        $query = "SELECT" . " z.zoneid as zoneid" . ",z.affiliateid as affiliateid" . ",z.zonename as zonename" . ",z.description as description" . ",z.width as width" . ",z.height as height" . ",z.what as what" . ",z.zonetype as zonetype" . ",z.delivery as delivery" . " FROM " . $phpAds_config['tbl_zones'] . " AS z" . "," . $phpAds_config['tbl_banners'] . " AS b" . "," . $phpAds_config['tbl_affiliates'] . " AS a" . " WHERE a.affiliateid=z.affiliateid" . " AND a.agencyid=" . phpAds_getUserID() . " AND b.bannerid=" . $bannerid . " AND (z.width=b.width OR z.width=-1)" . " AND (z.height=b.height OR z.height=-1)" . " AND z.zonetype=" . phpAds_ZoneBanners . " AND z.delivery != " . phpAds_ZoneText . phpAds_getZoneListOrder($listorder, $orderdirection);
    }
    // Get banner zones
    $res = phpAds_dbQuery($query) or phpAds_sqlDie();
    $zone_count = phpAds_dbNumRows($res);
    while ($row = phpAds_dbFetchArray($res)) {
        if (isset($affiliates[$row['affiliateid']])) {
            $row['linked'] = phpAds_IsBannerInZone($bannerid, $row['zoneid'], $row['what']);
            $affiliates[$row['affiliateid']]['zones'][$row['zoneid']] = $row;
            $affiliates[$row['affiliateid']]['ZoneBanners']++;
        }
    }
    if (phpAds_isUser(phpAds_Admin)) {
        $query = "SELECT zoneid,affiliateid,zonename,description,width,height,what,zonetype,delivery" . " FROM " . $phpAds_config['tbl_zones'] . " WHERE zonetype=" . phpAds_ZoneCampaign . phpAds_getZoneListOrder($listorder, $orderdirection);
    } elseif (phpAds_isUser(phpAds_Agency)) {
        $query = "SELECT z.zoneid,z.affiliateid,z.zonename,z.description,z.width,z.height,z.what,z.zonetype,z.delivery" . " FROM " . $phpAds_config['tbl_zones'] . " AS z" . "," . $phpAds_config['tbl_affiliates'] . " AS a" . " WHERE z.affiliateid=a.affiliateid" . " AND a.agencyid=" . phpAds_getUserID() . " AND z.zonetype=" . phpAds_ZoneCampaign . phpAds_getZoneListOrder($listorder, $orderdirection);
    }
    // Get campaign zones
    $res = phpAds_dbQuery($query) or phpAds_sqlDie();
    while ($row = phpAds_dbFetchArray($res)) {

        echo "<a href='tracker-campaigns.php?clientid=" . $clientid . "&trackerid=" . $row_trackers['trackerid'] . "'><img src='images/icon-zone-linked.gif' border='0' align='absmiddle'>&nbsp;{$strLinkedCampaigns}</a>";
    } else {
        echo "&nbsp;";
    }
    echo "</td>\n";
    echo "\t\t\t\t\t<td height='25'>";
    if (phpAds_isUser(phpAds_Admin) || phpAds_isUser(phpAds_Agency) || phpAds_isAllowed(phpAds_DeleteTracker)) {
        echo "<a href='tracker-delete.php?clientid=" . $clientid . "&trackerid=" . $row_trackers['trackerid'] . "&returnurl=advertiser-trackers.php'" . phpAds_DelConfirm($strConfirmDeleteTracker) . "><img src='images/icon-recycle.gif' border='0' align='absmiddle' alt='{$strDelete}'>&nbsp;{$strDelete}</a>";
    } else {
        echo "&nbsp;";
    }
    echo "</td>\n";
    echo "\t\t\t\t</tr>\n";
    $i++;
}
if (phpAds_dbNumRows($res_trackers) > 0) {
    //	echo "\t\t\t\t<tr height='1'>\n";
    //	echo "\t\t\t\t\t<td colspan='4' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td>\n";
    //	echo "\t\t\t\t</tr>\n";
    //}
    //if (isset($campaigns) && count($campaigns))
    //{
    echo "\t\t\t\t<tr height='1'>\n";
    echo "\t\t\t\t\t<td colspan='4' bgcolor='#888888'><img src='images/break-el.gif' height='1' width='100%'></td>\n";
    echo "\t\t\t\t</tr>\n";
    echo "\t\t\t\t<tr height='25'>\n";
    echo "\t\t\t\t\t<td colspan='4' height='25' align='" . $phpAds_TextAlignRight . "'>";
    echo "<img src='images/icon-recycle.gif' border='0' align='absmiddle'>&nbsp;<a href='tracker-delete.php?clientid=" . $clientid . "&returnurl=advertiser-trackers.php'" . phpAds_DelConfirm($strConfirmDeleteAllTrackers) . ">{$strDeleteAllTrackers}</a>&nbsp;&nbsp;";
    echo "</td>\n";
    echo "\t\t\t\t</tr>\n";
}

// Include required files
include "lib-settings.inc.php";
include "lib-languages.inc.php";
// Register input variables
phpAds_registerGlobal('admin', 'pwold', 'pw', 'pw2', 'admin_fullname', 'admin_email', 'company_name', 'language', 'updates_frequency', 'admin_novice', 'userlog_email', 'userlog_priority', 'userlog_autoclean');
// Security check
phpAds_checkAccess(phpAds_Admin);
$errormessage = array();
$sql = array();
if (isset($HTTP_POST_VARS['submit']) && $HTTP_POST_VARS['submit'] == 'true') {
    if (isset($admin)) {
        if (!strlen($admin)) {
            $errormessage[0][] = $strInvalidUsername;
        } elseif (phpAds_dbNumRows(phpAds_dbQuery("SELECT * FROM " . $phpAds_config['tbl_clients'] . " WHERE LOWER(clientusername) = '" . strtolower($admin) . "'"))) {
            $errormessage[0][] = $strDuplicateClientName;
        } elseif (phpAds_dbNumRows(phpAds_dbQuery("SELECT * FROM " . $phpAds_config['tbl_affiliates'] . " WHERE LOWER(username) = '" . strtolower($admin) . "'"))) {
            $errormessage[0][] = $strDuplicateClientName;
        } else {
            phpAds_SettingsWriteAdd('admin', $admin);
        }
    }
    if (isset($pwold) && strlen($pwold) || isset($pw) && strlen($pw) || isset($pw2) && strlen($pw2)) {
        if (md5($pwold) != $phpAds_config['admin_pw']) {
            $errormessage[0][] = $strPasswordWrong;
        } elseif (!strlen($pw) || strstr("\\", $pw)) {
            $errormessage[0][] = $strInvalidPassword;
        } elseif (strcmp($pw, $pw2)) {
            $errormessage[0][] = $strNotSamePasswords;
        } else {
            $admin_pw = $pw;
            phpAds_SettingsWriteAdd('admin_pw', md5($admin_pw));

function days_left($clientid)
{
    global $phpAds_config;
    global $date_format;
    // uses the following language settings:
    global $strExpiration, $strNoExpiration, $strDaysLeft, $strEstimated;
    // preset return values
    $estimated_end = "-";
    $days_left = "-";
    $description = "";
    $absolute = 0;
    // Get client record
    $client_query = "\n\t\tSELECT\n\t\t\tviews,\n\t\t\tclicks,\n\t\t\texpire,\n\t\t\tDATE_FORMAT(expire, '" . $date_format . "') as expire_f,\n\t\t\tTO_DAYS(expire)-TO_DAYS(NOW()) as days_left\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_clients'] . "\n\t\tWHERE \n\t\t\tclientid = " . $clientid;
    $res_client = phpAds_dbQuery($client_query) or phpAds_sqlDie();
    if (phpAds_dbNumRows($res_client) == 1) {
        $row_client = phpAds_dbFetchArray($res_client);
        // Check if the expiration date is set
        if ($row_client['expire'] != '0000-00-00' && $row_client['expire'] != '') {
            $expiration[] = array("days_left" => round($row_client["days_left"]), "date" => $row_client["expire_f"], "absolute" => true);
        }
        if ($row_client["views"] != -1) {
            if ($phpAds_config['compact_stats']) {
                $view_query = "\n\t               \tSELECT\n\t                   \tSUM(views) as total_views,\n\t                    MAX(TO_DAYS(day))-TO_DAYS(NOW()) as days_since_last_view,\n\t                    TO_DAYS(NOW())-MIN(TO_DAYS(day)) as days_since_start\n\t                FROM\n\t                   \t" . $phpAds_config['tbl_banners'] . " AS b\n\t                    LEFT JOIN " . $phpAds_config['tbl_adstats'] . " AS v USING (bannerid)\n\t                WHERE\n\t                  \tb.clientid = {$clientid}";
            } else {
                $view_query = "\n\t\t\t\t\tSELECT\n\t\t\t\t\t\tcount(*) as total_views,\n\t\t\t\t\t\tMAX(TO_DAYS(v.t_stamp))-TO_DAYS(NOW()) as days_since_last_view,\n\t\t\t\t\t\tTO_DAYS(NOW())-MIN(TO_DAYS(v.t_stamp)) as days_since_start\n\t\t\t\t\tFROM\n\t\t\t\t\t\t" . $phpAds_config['tbl_adviews'] . " AS v, \n\t\t\t\t\t\t" . $phpAds_config['tbl_banners'] . " AS b \n\t\t\t\t\tWHERE\n\t\t\t\t\t\tb.clientid = {$clientid} \n\t\t\t\t\t\tAND\n\t\t\t\t\t\tb.bannerid = v.bannerid";
            }
            $res_views = phpAds_dbQuery($view_query) or phpAds_sqlDie();
            if (phpAds_dbNumRows($res_views) == 1) {
                $row_views = phpAds_dbFetchArray($res_views);
                if (!isset($row_views["days_since_start"]) || $row_views["days_since_start"] == '' || $row_views["days_since_start"] == 0 || $row_views["days_since_start"] == null) {
                    $row_views["days_since_start"] = 1;
                }
                if (!empty($row_views["total_views"]) && $row_views["total_views"] > 0) {
                    $days_left = round($row_client["views"] / ($row_views["total_views"] / $row_views["days_since_start"]));
                    if ($row_client["views"] > 0) {
                        $estimated_end = strftime($date_format, @mktime(0, 0, 0, date("m"), date("d") + $days_left, date("Y")));
                        $expiration[] = array("days_left" => $days_left, "date" => $estimated_end, "absolute" => false);
                    } else {
                        $estimated_end = strftime($date_format, @mktime(0, 0, 0, date("m"), date("d") - $row_views["days_since_last_view"], date("Y")));
                        $expiration[] = array("days_left" => 0 - $row_views["days_since_last_view"], "date" => $estimated_end, "absolute" => true);
                    }
                }
            }
        }
        if ($row_client["clicks"] != -1) {
            if ($phpAds_config['compact_stats']) {
                $click_query = "\n                \tSELECT\n                    \tSUM(clicks) as total_clicks,\n                        MAX(TO_DAYS(day))-TO_DAYS(NOW()) as days_since_last_click,\n                        TO_DAYS(NOW())-MIN(TO_DAYS(day)) as days_since_start\n\t\t\t\t\tFROM\n\t\t\t\t\t\t" . $phpAds_config['tbl_adstats'] . "\n\t\t\t\t\t\tLEFT JOIN " . $phpAds_config['tbl_banners'] . " USING (bannerid)\n\t\t\t\t\tWHERE\n\t\t\t\t\t\tclientid = '{$clientid}' AND\n\t\t\t\t\t\tclicks > 0";
            } else {
                $click_query = "\n\t\t\t\t\tSELECT\n\t\t\t\t\t\tcount(*) as total_clicks,\n\t\t\t\t\t\tMAX(TO_DAYS(c.t_stamp))- TO_DAYS(NOW()) as days_since_last_click,\n\t\t\t\t\t\tTO_DAYS(NOW())-MIN(TO_DAYS(c.t_stamp)) as days_since_start\n\t\t\t\t\tFROM\n\t\t\t\t\t\t" . $phpAds_config['tbl_adclicks'] . " AS c, \n\t\t\t\t\t\t" . $phpAds_config['tbl_banners'] . " AS b \n\t\t\t\t\tWHERE \n\t\t\t\t\t\tb.clientid = {$clientid} AND\n\t\t\t\t\t\tb.bannerid = c.bannerid";
            }
            $res_clicks = phpAds_dbQuery($click_query) or phpAds_sqlDie();
            if (phpAds_dbNumRows($res_clicks) == 1) {
                $row_clicks = phpAds_dbFetchArray($res_clicks);
                if (!isset($row_clicks["days_since_start"]) || $row_clicks["days_since_start"] == '' || $row_clicks["days_since_start"] == 0 || $row_clicks["days_since_start"] == null) {
                    $row_clicks["days_since_start"] = 1;
                }
                if (!empty($row_clicks["total_clicks"]) && $row_clicks["total_clicks"] > 0) {
                    $days_left = round($row_client["clicks"] / ($row_clicks["total_clicks"] / $row_clicks["days_since_start"]));
                    if ($row_client["clicks"] > 0) {
                        $estimated_end = strftime($date_format, @mktime(0, 0, 0, date("m"), date("d") + $days_left, date("Y")));
                        $expiration[] = array("days_left" => $days_left, "date" => $estimated_end, "absolute" => false);
                    } else {
                        $estimated_end = strftime($date_format, @mktime(0, 0, 0, date("m"), date("d") - $row_clicks["days_since_last_view"], date("Y")));
                        $expiration[] = array("days_left" => 0 - $row_clicks["days_since_last_view"], "date" => $estimated_end, "absolute" => true);
                    }
                }
            }
        }
    }
    // Build Return value
    if (isset($expiration) && sizeof($expiration) > 0) {
        $sooner = $expiration[0];
        for ($i = 0; $i < sizeof($expiration); $i++) {
            if ($expiration[$i]['days_left'] < $sooner['days_left']) {
                $sooner = $expiration[$i];
            }
        }
        if ($sooner['days_left'] < 0) {
            $sooner['days_left'] = 0;
        }
        if ($sooner['absolute']) {
            $ret_val[] = $strExpiration . ": " . $sooner['date'] . " (" . $strDaysLeft . ": " . $sooner['days_left'] . ")";
        } else {
            $ret_val[] = $strEstimated . ": " . $sooner['date'] . " (" . $strDaysLeft . ": " . $sooner['days_left'] . ")";
        }
        $ret_val[] = $sooner['date'];
        $ret_val[] = $sooner['days_left'];
    } else {
        // Unknown
        $ret_val[] = $strExpiration . ": " . $strNoExpiration;
        $ret_val[] = '';
        $ret_val[] = '';
    }
    return isset($ret_val) ? $ret_val : false;
}

function phpAds_totalStats($table, $column, $bannerid, $timeconstraint = "")
{
    global $phpAds_config;
    if ($phpAds_config['compact_stats']) {
        $where = "";
        if (!empty($bannerid)) {
            $where = "WHERE bannerid = '{$bannerid}'";
        }
        if (!empty($timeconstraint)) {
            if (!empty($bannerid)) {
                $where .= " AND ";
            } else {
                $where = "WHERE ";
            }
            if ($timeconstraint == "month") {
                $begin = date('Ymd', mktime(0, 0, 0, date('m'), 1, date('Y')));
                $end = date('Ymd', mktime(0, 0, 0, date('m') + 1, 1, date('Y')));
                $where .= "day >= {$begin} AND day < {$end}";
            } elseif ($timeconstraint == "week") {
                $begin = date('Ymd', mktime(0, 0, 0, date('m'), date('d') - 6, date('Y')));
                $end = date('Ymd', mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')));
                $where .= "day >= {$begin} AND day < {$end}";
            } else {
                $begin = date('Ymd', mktime(0, 0, 0, date('m'), date('d'), date('Y')));
                $where .= "day = {$begin}";
            }
        }
        $res = phpAds_dbQuery("SELECT SUM({$column}) as qnt FROM " . $phpAds_config['tbl_adstats'] . " {$where}") or phpAds_sqlDie();
        if (phpAds_dbNumRows($res)) {
            $row = phpAds_dbFetchArray($res);
            return $row['qnt'];
        } else {
            return 0;
        }
    } else {
        $where = "";
        if (!empty($bannerid)) {
            $where = "WHERE bannerid = '{$bannerid}'";
        }
        if (!empty($timeconstraint)) {
            if (!empty($bannerid)) {
                $where .= " AND ";
            } else {
                $where = "WHERE ";
            }
            if ($timeconstraint == "month") {
                $begin = date('YmdHis', mktime(0, 0, 0, date('m'), 1, date('Y')));
                $end = date('YmdHis', mktime(0, 0, 0, date('m') + 1, 1, date('Y')));
                $where .= "t_stamp >= {$begin} AND t_stamp < {$end}";
            } elseif ($timeconstraint == "week") {
                $begin = date('YmdHis', mktime(0, 0, 0, date('m'), date('d') - 6, date('Y')));
                $end = date('YmdHis', mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')));
                $where .= "t_stamp >= {$begin} AND t_stamp < {$end}";
            } else {
                $begin = date('YmdHis', mktime(0, 0, 0, date('m'), date('d'), date('Y')));
                $end = date('YmdHis', mktime(0, 0, 0, date('m'), date('d') + 1, date('Y')));
                $where .= "t_stamp >= {$begin} AND t_stamp < {$end}";
            }
        }
        $res = phpAds_dbQuery("SELECT count(*) as qnt FROM {$table} {$where}") or phpAds_sqlDie();
        if (phpAds_dbNumRows($res)) {
            $row = phpAds_dbFetchArray($res);
            return $row['qnt'];
        } else {
            return 0;
        }
    }
}

function phpAds_upgradeSplitClientTable()
{
    global $phpAds_config;
    if (!isset($phpAds_config['config_version']) || $phpAds_config['config_version'] < 200.162) {
        $res = phpAds_dbQuery("DESCRIBE " . $phpAds_config['tbl_clients']);
        if (phpAds_dbNumRows($res) > 0) {
            $res = phpAds_dbQuery("SELECT * FROM " . $phpAds_config['tbl_clients'] . " WHERE parent > 0");
            if ($row['target'] > 0 && $row['weight'] == 0) {
                $row['priority'] = 'h';
            } else {
                $row['priority'] = 'l';
            }
            $row['optimise'] = 'f';
            $row['anonymous'] = 'f';
            while ($row = phpAds_dbFetchArray($res)) {
                phpAds_dbQuery("INSERT INTO " . $phpAds_config['tbl_campaigns'] . " (campaignid" . ",campaignname" . ",views" . ",clicks" . ",conversions" . ",expire" . ",activate" . ",active" . ",weight" . ",target" . ",clientid" . ",priority" . ",optimise" . ",anonymous)" . " VALUES " . "('" . $row['clientid'] . "'" . ",'" . $row['clientname'] . "'" . ",'" . $row['views'] . "'" . ",'" . $row['clicks'] . "'" . ",'" . $row['conversions'] . "'" . ",'" . $row['expire'] . "'" . ",'" . $row['activate'] . "'" . ",'" . $row['active'] . "'" . ",'" . $row['weight'] . "'" . ",'" . $row['target'] . "'" . ",'" . $row['parent'] . "'" . ",'" . $row['priority'] . "'" . ",'" . $row['optimise'] . "'" . ",'" . $row['anonymous'] . "')") or phpAds_sqlDie();
            }
            // Delete rows moved into campaign table
            phpAds_dbQuery("DELETE FROM " . $phpAds_config['tbl_clients'] . " WHERE parent > 0");
            // Delete old columns
            phpAds_dbQuery("ALTER TABLE " . $phpAds_config['tbl_clients'] . " DROP COLUMN views");
            phpAds_dbQuery("ALTER TABLE " . $phpAds_config['tbl_clients'] . " DROP COLUMN clicks");
            phpAds_dbQuery("ALTER TABLE " . $phpAds_config['tbl_clients'] . " DROP COLUMN expire");
            phpAds_dbQuery("ALTER TABLE " . $phpAds_config['tbl_clients'] . " DROP COLUMN activate");
            phpAds_dbQuery("ALTER TABLE " . $phpAds_config['tbl_clients'] . " DROP COLUMN active");
            phpAds_dbQuery("ALTER TABLE " . $phpAds_config['tbl_clients'] . " DROP COLUMN weight");
            phpAds_dbQuery("ALTER TABLE " . $phpAds_config['tbl_clients'] . " DROP COLUMN target");
            phpAds_dbQuery("ALTER TABLE " . $phpAds_config['tbl_clients'] . " DROP COLUMN parent");
            phpAds_dbQuery("ALTER TABLE " . $phpAds_config['tbl_clients'] . " DROP COLUMN conversions");
            phpAds_dbQuery("ALTER TABLE " . $phpAds_config['tbl_clients'] . " DROP COLUMN priority");
            phpAds_dbQuery("ALTER TABLE " . $phpAds_config['tbl_clients'] . " DROP COLUMN optimise");
            phpAds_dbQuery("ALTER TABLE " . $phpAds_config['tbl_clients'] . " DROP COLUMN anonymous");
        }
    }
}

    echo "<tr height='25' " . ($i % 2 == 0 ? "bgcolor='#F6F6F6'" : "") . ">";
    // Empty
    echo "<td>&nbsp;</td>";
    // Button 1, 2 & 3
    echo "<td height='25' colspan='3'>";
    if (phpAds_isUser(phpAds_Admin) || phpAds_isAllowed(phpAds_LinkBanners)) {
        echo "<a href='zone-include.php?affiliateid=" . $affiliateid . "&zoneid=" . $row_zones['zoneid'] . "'><img src='images/icon-zone-linked.gif' border='0' align='absmiddle' alt='{$strIncludedBanners}'>&nbsp;{$strIncludedBanners}</a>&nbsp;&nbsp;&nbsp;&nbsp;";
    }
    echo "<a href='zone-probability.php?affiliateid=" . $affiliateid . "&zoneid=" . $row_zones['zoneid'] . "'><img src='images/icon-zone-probability.gif' border='0' align='absmiddle' alt='{$strProbability}'>&nbsp;{$strProbability}</a>&nbsp;&nbsp;&nbsp;&nbsp;";
    echo "<a href='zone-invocation.php?affiliateid=" . $affiliateid . "&zoneid=" . $row_zones['zoneid'] . "'><img src='images/icon-generatecode.gif' border='0' align='absmiddle' alt='{$strInvocationcode}'>&nbsp;{$strInvocationcode}</a>&nbsp;&nbsp;&nbsp;&nbsp;";
    if (phpAds_isUser(phpAds_Admin) || phpAds_isAllowed(phpAds_DeleteZone)) {
        echo "<a href='zone-delete.php?affiliateid=" . $affiliateid . "&zoneid=" . $row_zones['zoneid'] . "&returnurl=affiliate-zones.php'" . phpAds_DelConfirm($strConfirmDeleteZone) . "><img src='images/icon-recycle.gif' border='0' align='absmiddle' alt='{$strDelete}'>&nbsp;{$strDelete}</a>&nbsp;&nbsp;&nbsp;&nbsp;";
    }
    echo "</td></tr>";
    $i++;
}
if (phpAds_dbNumRows($res_zones) > 0) {
    echo "<tr height='1'><td colspan='4' bgcolor='#888888'><img src='images/break.gif' height='1' width='100%'></td></tr>";
}
echo "</table>";
echo "<br><br>";
/*********************************************************/
/* Store preferences                                     */
/*********************************************************/
$Session['prefs']['affiliate-zones.php']['listorder'] = $listorder;
$Session['prefs']['affiliate-zones.php']['orderdirection'] = $orderdirection;
phpAds_SessionDataStore();
/*********************************************************/
/* HTML framework                                        */
/*********************************************************/
phpAds_PageFooter();

function phpAds_ToggleCampaignInZone($clientid, $zoneid)
{
    global $phpAds_config;
    if (isset($zoneid) && $zoneid != '') {
        $res = phpAds_dbQuery("\n\t\t\tSELECT\n\t\t\t\t*\n\t\t\tFROM\n\t\t\t\t" . $phpAds_config['tbl_zones'] . "\n\t\t\tWHERE\n\t\t\t\tzoneid = '{$zoneid}'\n\t\t\t") or phpAds_sqlDie();
        if (phpAds_dbNumRows($res)) {
            $zone = phpAds_dbFetchArray($res);
            if ($zone['what'] != '') {
                $what_array = explode(",", $zone['what']);
            } else {
                $what_array = array();
            }
            $available = false;
            $changed = false;
            for ($k = 0; $k < count($what_array); $k++) {
                if (substr($what_array[$k], 0, 9) == "clientid:" && substr($what_array[$k], 9) == $clientid) {
                    // Remove from array
                    unset($what_array[$k]);
                    $available = true;
                    $changed = true;
                }
            }
            if ($available == false) {
                // Add to array
                $what_array[] = 'clientid:' . $clientid;
                $changed = true;
            }
            if ($changed == true) {
                // Convert back to a string
                $zone['what'] = implode(",", $what_array);
                // Store string back into database
                $res = phpAds_dbQuery("\n\t\t\t\t\tUPDATE\n\t\t\t\t\t\t" . $phpAds_config['tbl_zones'] . "\n\t\t\t\t\tSET \n\t\t\t\t\t\twhat = '" . $zone['what'] . "'\n\t\t\t\t\tWHERE\n\t\t\t\t\t\tzoneid = '{$zoneid}'\n\t\t\t\t\t") or phpAds_sqlDie();
                // Rebuild cache
                if (!defined('LIBVIEWCACHE_INCLUDED')) {
                    include phpAds_path . '/libraries/deliverycache/cache-' . $phpAds_config['delivery_caching'] . '.inc.php';
                }
                phpAds_cacheDelete('what=zone:' . $zoneid);
            }
        }
    }
    return false;
}

function phpAds_showZoneBanners($width, $height, $what, $zonetype, $delivery)
{
    global $phpAds_config, $showcampaigns, $hideinactive, $affiliateid, $zoneid;
    global $strName, $strID, $strUntitled, $strDescription, $phpAds_TextAlignRight, $phpAds_TextAlignLeft;
    global $strEdit, $strCheckAllNone, $strShowBanner;
    global $strNoBannersToLink, $strSaveChanges, $strSelectBannerToLink, $strInactiveBannersHidden;
    global $strShowParentCampaigns, $strHideParentCampaigns, $strHideInactiveBanners, $strShowAll;
    global $tabindex;
    if ($zonetype == phpAds_ZoneBanners) {
        // Determine selected banners
        $what_array = explode(",", $what);
        for ($k = 0; $k < count($what_array); $k++) {
            if (substr($what_array[$k], 0, 9) == "bannerid:") {
                $bannerid = substr($what_array[$k], 9);
                $bannerids[$bannerid] = true;
            }
        }
    } elseif ($zonetype == phpAds_ZoneCampaign) {
        // Determine selected campaigns
        $clientids = array();
        $what_array = explode(",", $what);
        for ($k = 0; $k < count($what_array); $k++) {
            if (substr($what_array[$k], 0, 9) == "clientid:") {
                $clientid = substr($what_array[$k], 9);
                $clientids[] = 'clientid = ' . $clientid;
            }
        }
        // Determine banners owned by selected campaigns
        if (count($clientids)) {
            $res = phpAds_dbQuery("\n\t\t\t\tSELECT\n\t\t\t\t\tbannerid\n\t\t\t\tFROM\n\t\t\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\t\t\tWHERE\n\t\t\t\t\t" . implode(' OR ', $clientids) . "\n\t\t\t");
            while ($row = phpAds_dbFetchArray($res)) {
                $bannerids[$row['bannerid']] = true;
            }
        } else {
            $bannerids = array();
        }
    } else {
        $bannerids = array();
    }
    // Fetch all campaigns
    $res = phpAds_dbQuery("\n\t\tSELECT\n\t\t\t*\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_clients'] . "\n\t\tWHERE\n\t\t\tparent > 0\n\t") or phpAds_sqlDie();
    while ($row = phpAds_dbFetchArray($res)) {
        $campaigns[$row['clientid']] = $row;
    }
    // Fetch all banners which can be linked
    $query = "\n\t\tSELECT\n\t\t\t*\n\t\tFROM\n\t\t\t" . $phpAds_config['tbl_banners'] . "\n\t\t";
    if ($delivery != phpAds_ZoneText) {
        if ($width != -1 && $height != -1) {
            $query .= "WHERE width = {$width} AND height = {$height} AND contenttype != 'txt'";
        } elseif ($width != -1) {
            $query .= "WHERE width = {$width} AND contenttype != 'txt'";
        } elseif ($height != -1) {
            $query .= "WHERE height = {$height} AND contenttype != 'txt'";
        } else {
            $query .= "WHERE contenttype != 'txt'";
        }
    } else {
        $query .= "WHERE contenttype = 'txt'";
    }
    $query .= "\n\t\tORDER BY\n\t\t\tbannerid";
    $res = phpAds_dbQuery($query);
    $compact = phpAds_dbNumRows($res) > $phpAds_config['gui_link_compact_limit'];
    while ($row = phpAds_dbFetchArray($res)) {
        $campaigns[$row['clientid']]['banners'][$row['bannerid']] = $row;
    }
    $inactivehidden = 0;
    if (!$compact) {
        echo "<form name='zonetypeselection' method='post' action='zone-include.php'>";
        echo "<input type='hidden' name='zoneid' value='" . $GLOBALS['zoneid'] . "'>";
        echo "<input type='hidden' name='affiliateid' value='" . $GLOBALS['affiliateid'] . "'>";
        echo "<input type='hidden' name='zonetype' value='" . phpAds_ZoneBanners . "'>";
        echo "<input type='hidden' name='action' value='set'>";
    } else {
        echo "<br>" . $strSelectBannerToLink . "<br><br>";
        echo "<table cellpadding='0' cellspacing='0' border='0'><tr>";
        echo "<form name='zonetypeselection' method='get' action='zone-include.php'>";
        echo "<input type='hidden' name='zoneid' value='" . $GLOBALS['zoneid'] . "'>";
        echo "<input type='hidden' name='affiliateid' value='" . $GLOBALS['affiliateid'] . "'>";
        echo "<input type='hidden' name='zonetype' value='" . phpAds_ZoneBanners . "'>";
        echo "<td><img src='images/icon-client.gif' align='absmiddle'>&nbsp;";
        echo "<select name='clientid' onChange='this.form.submit();' tabindex='" . $tabindex++ . "'>";
        if (!isset($GLOBALS['clientid']) || $GLOBALS['clientid'] == '') {
            echo "<option value='' selected></option>";
        }
        // Fetch all campaigns
        $res = phpAds_dbQuery("\n\t\t\tSELECT\n\t\t\t\t*\n\t\t\tFROM\n\t\t\t\t" . $phpAds_config['tbl_clients'] . "\n\t\t\tWHERE\n\t\t\t\tparent = 0\n\t\t") or phpAds_sqlDie();
        while ($row = phpAds_dbFetchArray($res)) {
            if (isset($GLOBALS['clientid']) && $GLOBALS['clientid'] == $row['clientid']) {
                echo "<option value='" . $row['clientid'] . "' selected>[id" . $row['clientid'] . "] " . $row['clientname'] . "</option>";
            } else {
                echo "<option value='" . $row['clientid'] . "'>[id" . $row['clientid'] . "] " . $row['clientname'] . "</option>";
            }
        }
        echo "</select>";
        echo "</td></form>";
        if (isset($GLOBALS['clientid']) && $GLOBALS['clientid'] != '') {
            echo "<form name='zonetypeselection' method='get' action='zone-include.php'>";
            echo "<input type='hidden' name='zoneid' value='" . $GLOBALS['zoneid'] . "'>";
            echo "<input type='hidden' name='affiliateid' value='" . $GLOBALS['affiliateid'] . "'>";
            echo "<input type='hidden' name='clientid' value='" . $GLOBALS['clientid'] . "'>";
//.........这里部分代码省略.........

function phpAds_SendMaintenanceReport($clientid, $first_unixtimestamp, $last_unixtimestamp, $update = true)
{
    global $phpAds_config, $phpAds_CharSet, $date_format, $strBanner, $strCampaign, $strViews, $strClicks, $strConversions, $strLinkedTo, $strMailSubject, $strMailHeader, $strMailBannerStats, $strMailFooter, $strMailReportPeriod, $strMailReportPeriodAll, $strLogErrorBanners, $strLogErrorClients, $strLogErrorViews, $strLogErrorClicks, $strLogErrorConversions, $strNoStatsForCampaign, $strNoViewLoggedInInterval, $strNoClickLoggedInInterval, $strNoCampaignLoggedInInterval, $strTotal, $strTotalThisPeriod;
    // Convert timestamps to SQL format
    $last_sqltimestamp = date("YmdHis", $last_unixtimestamp);
    $first_sqltimestamp = date("YmdHis", $first_unixtimestamp);
    // Get Client information
    $res_client = phpAds_dbQuery("SELECT" . " clientid" . ",clientname" . ",contact" . ",email" . ",language" . ",report" . ",reportinterval" . ",reportlastdate" . ",UNIX_TIMESTAMP(reportlastdate) AS reportlastdate_t" . " FROM " . $phpAds_config['tbl_clients'] . " WHERE clientid=" . $clientid);
    if (phpAds_dbNumRows($res_client) > 0) {
        $client = phpAds_dbFetchArray($res_client);
        // Load client language strings
        @(include phpAds_path . '/language/english/default.lang.php');
        if ($client['language'] != '') {
            $phpAds_config['language'] = $client['language'];
        }
        if ($phpAds_config['language'] != 'english' && file_exists(phpAds_path . '/language/' . $phpAds_config['language'] . '/default.lang.php')) {
            @(include phpAds_path . '/language/' . $phpAds_config['language'] . '/default.lang.php');
        }
        $active_campaigns = false;
        $log = "";
        // Fetch all campaigns belonging to client
        $res_campaigns = phpAds_dbQuery("SELECT" . " campaignid" . ",campaignname" . ",views" . ",clicks" . ",conversions" . ",expire" . ",UNIX_TIMESTAMP(expire) as expire_st" . ",activate" . ",UNIX_TIMESTAMP(activate) as activate_st" . ",active" . " FROM " . $phpAds_config['tbl_campaigns'] . " WHERE clientid=" . $client['clientid']) or die($strLogErrorClients);
        while ($campaign = phpAds_dbFetchArray($res_campaigns)) {
            // Fetch all banners belonging to campaign
            $res_banners = phpAds_dbQuery("SELECT" . " bannerid" . ",campaignid" . ",URL" . ",active" . ",description" . ",alt" . " FROM " . $phpAds_config['tbl_banners'] . " WHERE campaignid=" . $campaign['campaignid']) or die($strLogErrorBanners);
            $active_banners = false;
            $log .= "\n" . $strCampaign . "  " . strip_tags(phpAds_buildName($campaign['campaignid'], $campaign['campaignname'])) . "\n";
            $log .= "=======================================================\n\n";
            while ($row_banners = phpAds_dbFetchArray($res_banners)) {
                $adviews = phpAds_totalViews($row_banners["bannerid"]);
                $client["views_used"] = $adviews;
                $adclicks = phpAds_totalClicks($row_banners["bannerid"]);
                $campaign["clicks_used"] = $adclicks;
                $adconversions = phpAds_totalConversions($row_banners["bannerid"]);
                $campaign["conversions_used"] = $adconversions;
                if ($adviews > 0 || $adclicks > 0 || $adconversions > 0) {
                    $log .= $strBanner . "  " . strip_tags(phpAds_buildBannerName($row_banners['bannerid'], $row_banners['description'], $row_banners['alt'])) . "\n";
                    $log .= $strLinkedTo . ": " . $row_banners['URL'] . "\n";
                    $log .= "-------------------------------------------------------\n";
                    $active_banner_stats = false;
                    if ($adviews > 0) {
                        $log .= $strViews . " (" . $strTotal . "):    " . $adviews . "\n";
                        // Fetch all adviews belonging to banner belonging to client, grouped by day
                        $res_adviews = phpAds_dbQuery("SELECT" . " SUM(views) as qnt" . ",DATE_FORMAT(day, '{$date_format}') as t_stamp_f" . ",TO_DAYS(day) AS the_day" . " FROM " . $phpAds_config['tbl_adstats'] . " WHERE bannerid=" . $row_banners['bannerid'] . " AND views>0" . " AND UNIX_TIMESTAMP(day)>=" . $first_unixtimestamp . " AND UNIX_TIMESTAMP(day)<" . $last_unixtimestamp . " GROUP BY day" . " ORDER BY day DESC") or die($strLogErrorViews . " " . phpAds_dbError());
                        if (phpAds_dbNumRows($res_adviews)) {
                            $total = 0;
                            while ($row_adviews = phpAds_dbFetchArray($res_adviews)) {
                                $log .= "      " . $row_adviews['t_stamp_f'] . ":   " . $row_adviews['qnt'] . "\n";
                                $total += $row_adviews['qnt'];
                            }
                            $log .= $strTotalThisPeriod . ": " . $total . "\n";
                            $active_banner_stats = true;
                        } else {
                            $log .= "      " . $strNoViewLoggedInInterval . "\n";
                        }
                    }
                    if ($adclicks > 0) {
                        // Total adclicks
                        $log .= "\n" . $strClicks . " (" . $strTotal . "):   " . $adclicks . "\n";
                        // Fetch all adclicks belonging to banner belonging to client, grouped by day
                        $res_adclicks = phpAds_dbQuery("SELECT" . " SUM(clicks) as qnt" . ",DATE_FORMAT(day, '{$date_format}') as t_stamp_f" . ",TO_DAYS(day) AS the_day" . " FROM " . $phpAds_config['tbl_adstats'] . " WHERE bannerid = " . $row_banners['bannerid'] . " AND clicks>0" . " AND UNIX_TIMESTAMP(day)>=" . $first_unixtimestamp . " AND UNIX_TIMESTAMP(day)<" . $last_unixtimestamp . " GROUP BY day" . " ORDER BY day DESC") or die($strLogErrorClicks . " " . phpAds_dbError());
                        if (phpAds_dbNumRows($res_adclicks)) {
                            $total = 0;
                            while ($row_adclicks = phpAds_dbFetchArray($res_adclicks)) {
                                $log .= "      " . $row_adclicks['t_stamp_f'] . ":   " . $row_adclicks['qnt'] . "\n";
                                $total += $row_adclicks['qnt'];
                            }
                            $log .= $strTotalThisPeriod . ": " . $total . "\n";
                            $active_banner_stats = true;
                        } else {
                            $log .= "      " . $strNoClickLoggedInInterval . "\n";
                        }
                    }
                    if ($adconversions > 0) {
                        // Total adconversions
                        $log .= "\n" . $strConversions . " (" . $strTotal . "):   " . $adconversions . "\n";
                        // Fetch all adclicks belonging to banner belonging to client, grouped by day
                        $res_adconversions = phpAds_dbQuery("SELECT" . " SUM(conversions) as qnt" . ",DATE_FORMAT(day, '{$date_format}') as t_stamp_f" . ",TO_DAYS(day) AS the_day" . " FROM " . $phpAds_config['tbl_adstats'] . " WHERE bannerid = " . $row_banners['bannerid'] . " AND conversions>0" . " AND UNIX_TIMESTAMP(day)>=" . $first_unixtimestamp . " AND UNIX_TIMESTAMP(day)<" . $last_unixtimestamp . " GROUP BY day" . " ORDER BY day DESC") or die($strLogErrorConversions . " " . phpAds_dbError());
                        if (phpAds_dbNumRows($res_adconversions)) {
                            $total = 0;
                            while ($row_adconversions = phpAds_dbFetchArray($res_adconversions)) {
                                $log .= "      " . $row_adcconversions['t_stamp_f'] . ":   " . $row_adconversions['qnt'] . "\n";
                                $total += $row_adconversions['qnt'];
                            }
                            $log .= $strTotalThisPeriod . ": " . $total . "\n";
                            $active_banner_stats = true;
                        } else {
                            $log .= "      " . $strNoConversionLoggedInInterval . "\n";
                        }
                    }
                    $log .= "\n\n";
                    if ($active_banner_stats == true || $active_banner_stats == false && $campaign['active'] == 't') {
                        $active_banners = true;
                    }
                }
            }
            if ($active_banners == true) {
                $active_campaigns = true;
            } else {
                $log .= $strNoStatsForCampaign . "\n\n\n";
//.........这里部分代码省略.........

function phpAds_deactivateMail($campaign)
{
    global $phpAds_config;
    global $strMailSubjectDeleted, $strMailHeader, $strMailClientDeactivated;
    global $strNoMoreClicks, $strNoMoreViews, $strBeforeActivate, $strAfterExpire;
    global $strBanner, $strMailNothingLeft, $strMailFooter, $strUntitled;
    $clientresult = phpAds_dbQuery("SELECT *" . " FROM " . $phpAds_config['tbl_clients'] . " WHERE clientid=" . $campaign['clientid']);
    if ($client = phpAds_dbFetchArray($clientresult)) {
        if ($client["email"] != '' && $client["reportdeactivate"] == 't') {
            // Load config from the database
            if (!defined('LIBDBCONFIG_INCLUDED')) {
                include phpAds_path . '/libraries/lib-dbconfig.inc.php';
                phpAds_LoadDbConfig();
            }
            // Load client language strings
            @(include phpAds_path . '/language/english/default.lang.php');
            if ($client['language'] != '') {
                $phpAds_config['language'] = $client['language'];
            }
            if ($phpAds_config['language'] != 'english' && file_exists(phpAds_path . '/language/' . $phpAds_config['language'] . '/default.lang.php')) {
                @(include phpAds_path . '/language/' . $phpAds_config['language'] . '/default.lang.php');
            }
            // Build email
            $Subject = $strMailSubjectDeleted . ": " . $campaign['campaignname'];
            $Body = $strMailHeader . "\n";
            $Body .= $strMailClientDeactivated;
            if ($campaign['clicks'] == 0) {
                $Body .= ", {$strNoMoreClicks}";
            }
            if ($campaign['views'] == 0) {
                $Body .= ", {$strNoMoreViews}";
            }
            if (time() < $campaign["activate_st"]) {
                $Body .= ", {$strBeforeActivate}";
            }
            if (time() > $campaign["expire_st"] && $campaign["expire_st"] != 0) {
                $Body .= ", {$strAfterExpire}";
            }
            $Body .= ".\n\n";
            $res_banners = phpAds_dbQuery("SELECT" . " bannerid" . ",url" . ",description" . ",alt" . " FROM " . $phpAds_config['tbl_banners'] . " WHERE campaignid=" . $campaign['campaignid']);
            if (phpAds_dbNumRows($res_banners) > 0) {
                $Body .= "-------------------------------------------------------\n";
                while ($row_banners = phpAds_dbFetchArray($res_banners)) {
                    $name = "[id" . $row_banners['bannerid'] . "] ";
                    if ($row_banners['description'] != "") {
                        $name .= $row_banners['description'];
                    } elseif ($row_banners['alt'] != "") {
                        $name .= $row_banners['alt'];
                    } else {
                        $name .= $strUntitled;
                    }
                    $Body .= $strBanner . "  " . $name . "\n";
                    $Body .= "linked to: " . $row_banners['url'] . "\n";
                    $Body .= "-------------------------------------------------------\n";
                }
            }
            $Body .= "\n";
            $Body .= "{$strMailNothingLeft}\n\n";
            $Body .= "{$strMailFooter}";
            $Body = str_replace("{clientname}", $client["clientname"], $Body);
            $Body = str_replace("{contact}", $client["contact"], $Body);
            $Body = str_replace("{adminfullname}", $phpAds_config['admin_fullname'], $Body);
            // Send email
            phpAds_sendMail($client['email'], $client['contact'], $Subject, $Body);
            if ($phpAds_config['userlog_email']) {
                phpAds_userlogAdd(phpAds_actionDeactivationMailed, $campaign['campaignid'], $Subject . "\n\n" . $Body);
            }
        }
    }
}

function phpAds_SqlUniqueName($name)
{
    global $phpAds_config;
    $extension = substr($name, strrpos($name, ".") + 1);
    $base = substr($name, 0, strrpos($name, "."));
    $res = phpAds_dbQuery("SELECT filename FROM " . $phpAds_config['tbl_images'] . " WHERE filename='" . $base . "." . $extension . "'");
    if (phpAds_dbNumRows($res) == 0) {
        return $base . "." . $extension;
    } else {
        if (eregi("^(.*)_([0-9]+)\$", $base, $matches)) {
            $base = $matches[1];
            $i = $matches[2];
        } else {
            $i = 1;
        }
        $found = false;
        while ($found == false) {
            $i++;
            $res = phpAds_dbQuery("SELECT filename FROM " . $phpAds_config['tbl_images'] . " WHERE filename='" . $base . "_" . $i . "." . $extension . "'");
            if (phpAds_dbNumRows($res) == 0) {
                $found = true;
            }
        }
        return $base . "_" . $i . "." . $extension;
    }
}

function phpAds_AutoTargetingCaclulateFactor($profile, &$debuglog)
{
    global $phpAds_config;
    $debuglog .= "\n";
    // Use standard routine if the profile is empty
    if (!phpAds_AutoTargetingProfileSum($profile)) {
        $debuglog .= "Supplied profile is null, using default algorithm\n";
        return -1;
    }
    $target_profile = array(0, 0, 0, 0, 0, 0, 0);
    $autotarget_campaigns = 0;
    // Fetch all targeted campaigns and all which need autotargeting
    $res = phpAds_dbQuery("SELECT campaignid" . ",views" . ",UNIX_TIMESTAMP(expire) AS expire" . ",target" . " FROM " . $phpAds_config['tbl_campaigns'] . " WHERE active" . " AND weight = 0" . " AND ((expire > NOW() AND views > 0) OR target > 0)");
    $debuglog .= "Targeted campaigns: " . phpAds_dbNumRows($res) . "\n";
    while ($row = phpAds_dbFetchArray($res)) {
        $debuglog .= "\nCAMPAIGN " . $row['campaignid'] . " \n";
        $debuglog .= "--------------------------------------------------\n";
        if ($row['expire']) {
            // Expire date set, get remaining days
            $days = ($row['expire'] - phpAds_LastMidnight) / (double) (60 * 60 * 24);
            $debuglog .= "Days remaining: {$days}\n";
            if ($days <= 0) {
                continue;
            }
            if ($row['views']) {
                // Bought views set, use standard autotargeting
                $daily_target = ceil($row['views'] / $days);
                $autotarget_campaigns++;
                $debuglog .= "Campaign type: Autotargeting\n";
                $debuglog .= "Remaining AdViews: " . $row['views'] . "\n";
                $debuglog .= "Daily target: " . $daily_target . "\n";
            } elseif ($row['target']) {
                // Use target field
                $daily_target = $row['target'];
                $debuglog .= "Campaign type: Expiring high-pri\n";
                $debuglog .= "Daily target: " . $daily_target . "\n";
            } else {
                // Skip campaign
                continue;
            }
        } else {
            // Expire date not set, target field is needed
            if (!$row['target']) {
                // Skip campaign
                continue;
            }
            $daily_target = $row['target'];
            $debuglog .= "Daily target: " . $daily_target . "\n";
            if ($row['views']) {
                $debuglog .= "Campaign type: AdView based high-pri\n";
                // Bought views set, get remaining days using the current target
                $days = ceil($row['views'] / $daily_target);
                $debuglog .= "Remaining AdViews: " . $row['views'] . "\n";
            } else {
                // Set target for the whole week
                $days = 7;
                $debuglog .= "Campaign type: Default high-pri\n";
            }
            $debuglog .= "Days remaining: " . $days . "\n";
        }
        // Add this campaign to the targets profile
        for ($i = 0; $i < $days && $i < 7; $i++) {
            $target_profile[$i] += $daily_target;
        }
    }
    $debuglog .= "\nAutotargeted campaigns: " . $autotarget_campaigns . "\n";
    $debuglog .= "--------------------------------------------------\n";
    if (!$autotarget_campaigns) {
        // No autotargeting is needed, we can use default autotargeting safely
        $debuglog .= "No autotargeting needed, using default algorithm\n";
        return -1;
    }
    // Get the daily target
    $daily_target = phpAds_AutoTargetingProfileSum($target_profile);
    // Set default routine as best match
    $best = array('factor' => array(-1), 'views' => phpAds_AutoTargetingActualViews($profile, $target_profile));
    // Try factors - don't know why, but on my setup $x <= 1 skips $x == 1...
    for ($x = 0; $x <= 1.01; $x += 0.05) {
        // Smooth profile using the current factor and get the view sum
        $smooth_profile = phpAds_AutoTargetingSmoothProfile($profile, $x);
        $views = phpAds_AutoTargetingProfileSum($smooth_profile);
        // Skip if the profile is empty
        if (!$views) {
            continue;
        }
        // Fill the whieighted profile
        $new_profile = array();
        for ($i = 0; $i < 7; $i++) {
            $new_profile[$i] = round($daily_target / $views * $smooth_profile[$i]);
        }
        // Get actual views that could be reached using this profile
        $act_views = phpAds_AutoTargetingActualViews($profile, $new_profile);
        if ($act_views > $best['views']) {
            // Best factor found til now
            $best['factor'] = array($x);
            $best['views'] = $act_views;
        } elseif ($act_views == $best['views']) {
            // Add x to the best factors found til now
            $best['factor'][] = $x;
        }
//.........这里部分代码省略.........

function phpAds_showZoneBanners($zoneid)
{
    global $phpAds_config, $phpAds_TextDirection;
    global $strUntitled, $strName, $strID, $strWeight, $strShowBanner;
    global $strCampaignWeight, $strBannerWeight, $strProbability, $phpAds_TextAlignRight;
    global $strRawQueryString, $strZoneProbListChain, $strZoneProbNullPri, $strZoneProbListChainLoop;
    $zonechain = array();
    $what = '';
    $infinite_loop = false;
    while ($zoneid || $what) {
        if ($zoneid) {
            // Get zone
            $zoneres = phpAds_dbQuery("SELECT what,width,height,delivery FROM " . $phpAds_config['tbl_zones'] . " WHERE zoneid='{$zoneid}' ");
            if (phpAds_dbNumRows($zoneres) > 0) {
                $zone = phpAds_dbFetchArray($zoneres);
                // Set what parameter to zone settings
                if (isset($zone['what']) && $zone['what'] != '') {
                    $what = $zone['what'];
                } else {
                    $what = 'default';
                }
            } else {
                $what = '';
            }
            $precondition = '';
            // Size preconditions
            if ($zone['width'] > -1) {
                $precondition .= " AND " . $phpAds_config['tbl_banners'] . ".width = " . $zone['width'] . " ";
            }
            if ($zone['height'] > -1) {
                $precondition .= " AND " . $phpAds_config['tbl_banners'] . ".height = " . $zone['height'] . " ";
            }
            // Text Ads preconditions
            if ($zone['delivery'] == phpAds_ZoneText) {
                $precondition .= " AND " . $phpAds_config['tbl_banners'] . ".storagetype = 'txt' ";
            } else {
                $precondition .= " AND " . $phpAds_config['tbl_banners'] . ".storagetype <> 'txt' ";
            }
            if (!defined('LIBVIEWQUERY_INCLUDED')) {
                include phpAds_path . '/libraries/lib-view-query.inc.php';
            }
            $select = phpAds_buildQuery($what, false, $precondition);
        } else {
            // Direct selection
            if (!defined('LIBVIEWQUERY_INCLUDED')) {
                include phpAds_path . '/libraries/lib-view-query.inc.php';
            }
            $select = phpAds_buildQuery($what, false, '');
            $zone = array('what' => $what);
        }
        $res = phpAds_dbQuery($select);
        $rows = array();
        $prioritysum = 0;
        while ($tmprow = phpAds_dbFetchArray($res)) {
            // weight of 0 disables the banner
            if ($tmprow['priority']) {
                $prioritysum += $tmprow['priority'];
                $rows[$tmprow['bannerid']] = $tmprow;
            }
        }
        if (!count($rows) && isset($zone['chain']) && strlen($zone['chain'])) {
            // Follow the chain if no banner was found
            if (ereg('^zone:([0-9]+)$', $zone['chain'], $match)) {
                // Zone chain
                $zoneid = $match[1];
                $what = '';
            } else {
                // Raw querystring chain
                $zoneid = 0;
                $what = $zone['chain'];
            }
            if (in_array($zone, $zonechain)) {
                // Chain already evaluated, exit
                $zoneid = 0;
                $what = '';
                $infinite_loop = true;
            } else {
                $zonechain[] = $zone;
            }
        } else {
            // No chain settings, exit loop
            $zoneid = 0;
            $what = '';
        }
    }
    if (isset($rows) && is_array($rows)) {
        $i = 0;
        if (count($zonechain)) {
            // Zone Chain
            echo "<br><br><div class='errormessage'><img class='errormessage' src='images/info.gif' width='16' height='16' border='0' align='absmiddle'>";
            echo $infinite_loop ? $strZoneProbListChainLoop : $strZoneProbListChain;
            echo "<br><img src='images/break-el.gif' height='1' width='100%' vspace='6'><br>";
            // echo "</div>";
            /*
            echo "<br><br><table width='100% border='0' align='center' cellspacing='0' cellpadding='0'>";
            echo "<tr><td valign='top'><img src='images/info.gif' align='absmiddle'>&nbsp;</td>";
            echo "<td width='100%'><b>".($infinite_loop ? $strZoneProbListChainLoop : $strZoneProbListChain)."</b></td></tr>";
            echo "</table>";
            phpAds_ShowBreak();
            */
//.........这里部分代码省略.........