Viewing file:  maintenance-autotargeting.php (1.76 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php // $Revision: 1.1 $
/************************************************************************/
/* phpAdsNew 2 */
/* =========== */
/* */
/* Copyright (c) 2001 by the phpAdsNew developers */
/* http://sourceforge.net/projects/phpadsnew */
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/************************************************************************/
$report = '';
$res_campaigns = phpAds_dbQuery("
SELECT
clientid,
clientname,
DATE_FORMAT(expire, 'YYYY-MM-DD') AS expire,
target,
views
FROM
".$phpAds_config['tbl_clients']."
WHERE
parent IS NOT NULL AND
active AND
expire IS NOT NULL AND
views > 0 AND
weight = 0
ORDER BY
clientid
") or die($strLogErrorClients);
while ($row = phpAds_dbFetchArray($res_campaigns))
{
$target = ceil($row['views']/(((strtotime($row['expire']) -
mktime(0, 0, 0, date('m'), date('d'), date('Y'))) / (double)(60*60*24))));
phpAds_dbQuery("
UPDATE
".$phpAds_config['tbl_clients']."
SET
target = ".$target."
WHERE
clientid = ".$row['clientid']
);
$report .= "$row[clientname] [id$row[clientid]]: $target ($row[target])\n";
}
if ($report != '' && $phpAds_config['userlog_priority'])
phpAds_userlogAdd (phpAds_actionPriorityAutoTargeting, 0, $report);
?>
|