本文整理汇总了PHP中phpAds_dbNumRows函数的典型用法代码示例。如果您正苦于以下问题:PHP phpAds_dbNumRows函数的具体用法?PHP phpAds_dbNumRows怎么用?PHP phpAds_dbNumRows使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了phpAds_dbNumRows函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: phpAds_getDaysLeft
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;
}
开发者ID:miller-tamil,项目名称:openads-plus,代码行数:87,代码来源:lib-expiration.inc.php
示例2: AND
$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)) {
开发者ID:miller-tamil,项目名称:openads-plus,代码行数:31,代码来源:banner-zone.php
示例3: phpAds_DelConfirm
echo "<a href='tracker-campaigns.php?clientid=" . $clientid . "&trackerid=" . $row_trackers['trackerid'] . "'><img src='images/icon-zone-linked.gif' border='0' align='absmiddle'> {$strLinkedCampaigns}</a>";
} else {
echo " ";
}
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}'> {$strDelete}</a>";
} else {
echo " ";
}
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'> <a href='tracker-delete.php?clientid=" . $clientid . "&returnurl=advertiser-trackers.php'" . phpAds_DelConfirm($strConfirmDeleteAllTrackers) . ">{$strDeleteAllTrackers}</a> ";
echo "</td>\n";
echo "\t\t\t\t</tr>\n";
}
开发者ID:miller-tamil,项目名称:openads-plus,代码行数:31,代码来源:advertiser-trackers.php
示例4: phpAds_registerGlobal
// 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));
开发者ID:miller-tamil,项目名称:openads-plus,代码行数:31,代码来源:settings-admin.php
示例5: days_left
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;
}
开发者ID:henryhe514,项目名称:ChineseCommercial,代码行数:95,代码来源:lib-expiration.inc.php
示例6: phpAds_totalStats
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;
}
}
}
开发者ID:henryhe514,项目名称:ChineseCommercial,代码行数:68,代码来源:lib-statistics.inc.php
示例7: phpAds_upgradeSplitClientTable
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");
}
}
}
开发者ID:miller-tamil,项目名称:openads-plus,代码行数:35,代码来源:lib-install-db.inc.php
示例8: phpAds_DelConfirm
echo "<tr height='25' " . ($i % 2 == 0 ? "bgcolor='#F6F6F6'" : "") . ">";
// Empty
echo "<td> </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}'> {$strIncludedBanners}</a> ";
}
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}'> {$strProbability}</a> ";
echo "<a href='zone-invocation.php?affiliateid=" . $affiliateid . "&zoneid=" . $row_zones['zoneid'] . "'><img src='images/icon-generatecode.gif' border='0' align='absmiddle' alt='{$strInvocationcode}'> {$strInvocationcode}</a> ";
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}'> {$strDelete}</a> ";
}
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();
开发者ID:henryhe514,项目名称:ChineseCommercial,代码行数:31,代码来源:affiliate-zones.php
示例9: phpAds_ToggleCampaignInZone
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;
}
开发者ID:henryhe514,项目名称:ChineseCommercial,代码行数:42,代码来源:lib-zones.inc.php
示例10: phpAds_showZoneBanners
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'> ";
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'] . "'>";
//.........这里部分代码省略.........
开发者ID:henryhe514,项目名称:ChineseCommercial,代码行数:101,代码来源:zone-include.php
示例11: phpAds_SendMaintenanceReport
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
|
请发表评论