$site = ad_getsite($p);
ad_connect_db("db");
$qh = ad_query("select * from ads where adid = '{$ad}'");
$nr = ad_queryrows($qh);
if ($nr > 0) {
$r = ad_fetch($qh);
} else {
return;
}
// Add entry to mysql log
$qh = ad_query("insert into adlog SET " . "adid = '{$r['adid']}'," . "type = 'click'," . "remotehost = '{$REMOTE_HOST}'," . "remoteaddr = '{$REMOTE_ADDR}'," . "site = '{$site['name']}'," . "entrydate = '{$dt}'");
// Update Information (unless localhost)
if (!ad_is_localhost()) {
// Update click count
$r[clicks] = $r[clicks] + 1;
$qh = ad_query("update ads SET clicks = '{$r['clicks']}' WHERE adid = '{$ad}'");
// If logfile is not empty, make an entry
// Format: YYYY-MM-DD HH:MM:SS CLICK|HIT domain clientaddress
if (!empty($r[logfile])) {
if ($fp = fopen($ad_logpath_default . "/" . $r[logfile], "a+")) {
$ca = getenv("REMOTE_HOST");
if (empty($ca)) {
$ca = getenv("REMOTE_ADDR");
}
fputs($fp, "{$dt} CLICK {$site['name']} {$ca}\n");
fclose($fp);
}
}
}
// Redirect to URL
header("Location: {$r['url']}");
<th>Hits</th>
<th>Clicks</th>
<th>Current State</th>
<th>View Log</th>
<th>Edit</th>
<th class="last">Delete</th>
</tr>
<?php
$now = strftime("%Y-%m-%d %H:%M:%S", time());
ad_connect_db("ads");
if (empty($sort)) {
$sort = "title";
}
$qh = ad_query("select * from ads order by {$sort},title");
if (!$qh) {
die("Database Error");
}
$nr = ad_queryrows($qh);
$ct = 0;
$i = 0;
if ($nr > 0) {
$array_hits_value = array();
$array_clicks_value = array();
while ($nr > $ct) {
$ad = ad_fetch($qh);
if ($ad['expiredate'] > $now) {
?>
<tr>
<td class="first style1">
if (!empty($edit)) {
include "edit.domain.php";
} else {
show_domains();
}
break;
case "log":
viewlog($id, $size);
break;
case "resetstats":
$dt = strftime("%Y-%m-%d %H:%M:%S", time());
ad_connect_db();
if (!empty($id)) {
ad_query("update ads set hits=0,clicks=0,statsreset='{$dt}' where adid = '{$id}'");
} else {
ad_query("update ads set hits=0,clicks=0,statsreset='{$dt}'");
}
if (!empty($rp)) {
include "{$rp}";
} else {
include "admin.editad.php";
}
break;
case "optdb":
optdb();
break;
case "buildhc":
buildhc();
break;
case "imgsize":
getimgsize($img);
} else {
return;
}
} else {
qpe(&$title, &$banner, &$url, &$trackingurl, &$logfile, &$textad, &$textadurl, &$notes);
$domains = implode("|", $domains);
if ($logtype != NULL) {
$logtype = join(",", $logtype);
} else {
$logtype = "";
}
if (strtoupper($updmodifydate) == 'ON') {
$modifydate = strftime("%Y-%m-%d %H:%M:%S", time());
}
$iq = "update ads set " . "domains='{$domains}'," . "title='{$title}'," . "banner='{$banner}'," . "width='{$width}'," . "height='{$height}'," . "url='{$url}'," . "logfile='{$logfile}'," . "trackingurl='{$trackingurl}'," . "textad='{$textad}'," . "textadurl='{$textadurl}'," . "hits='{$hits}'," . "clicks='{$clicks}'," . "adclass='{$adclass}'," . "logtype='{$logtype}'," . "createdate='{$createdate}'," . "modifydate='{$modifydate}'," . "expiredate='{$expiredate}'," . "lastdisplay='{$lastdisplay}'," . "statsreset='{$statsreset}'," . "active='{$active}'," . "notes='{$notes}'" . " where adid='{$edit}'";
$qh = ad_query($iq);
print mysql_error();
$edit = "";
$new = FALSE;
include "admin.php";
return;
}
?>
<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript">
<!--
function getimagesize() {
window.open("admin.php?view=imgsize&img=" + editad.banner.value, "getimagesize",
"height=70,width=250,resizable=1");
}
| pass | varchar(64) | YES | | NULL | |
| firstname | varchar(64) | YES | | NULL | |
| lastname | varchar(64) | YES | | NULL | |
| email | varchar(64) | YES | | NULL | |
| zcode | varchar(64) | YES | | NULL | |
| active | int(1) | YES | | NULL | |
| id | int(12) | | PRI | NULL | auto_increment |
| status | int(1) | YES | | NULL | |
| timestamp | int(15) | | | 0 | |
| ip | varchar(40) | | | 0 | |
| file | varchar(100) | | | | |
| admin_v | int(2) | YES | | NULL | |
+-----------+--------------+------+-----+---------+----------------+
*/
ad_connect_db("yard");
$qh = ad_query("select user,email from users");
}
if (!$qh) {
die("Database Error");
}
$nr = ad_queryrows($qh);
$ct = 0;
if ($nr > 0) {
while ($nr > $ct) {
$ad = ad_fetch($qh);
?>
<tr>
<!-- <td class="first style1">- <?php
echo $ad[title];
?>
</td> -->
