} // DBError
function OpenDB () {
- $db = mysql_connect ("mysql.clearscm.com", "adefaria_admin", "adefaria_admin")
+ $db = mysql_connect ("localhost", "mapsadmin", "mapsadmin")
or DBError ("OpenDB: Unable to connect to database server", "Connect");
- mysql_select_db ("adefaria_maps")
+ mysql_select_db ("MAPS")
or DBError ("OpenDB: Unable to select MAPS database", "adefaria_maps");
} // OpenDB
function countem ($table, $condition) {
$statement = "select count(distinct sender) as count from $table where $condition";
- $result = mysql_query ($statement)
+ $result = mysql_query ($statement)
or DBError ("countem: Unable to perform query: ", $statement);
// How many rows are there?
} // countlog
function SubtractDays ($date, $nbr_days) {
-
+
} // SubtractDays
function GetStats ($nbr_days, $date = "") {
$processed = $dates[$today]["processed"];
$returned = $dates[$today]["returned"];
- $returned_pct = $processed == 0 ? 0 :
+ $returned_pct = $processed == 0 ? 0 :
number_format ($returned / $processed * 100, 1, ".", "");
$whitelist = $dates[$today]["whitelist"];
- $whitelist_pct = $processed == 0 ? 0 :
+ $whitelist_pct = $processed == 0 ? 0 :
number_format ($whitelist / $processed * 100, 1, ".", "");
$blacklist = $dates[$today]["blacklist"];
- $blacklist_pct = $processed == 0 ? 0 :
+ $blacklist_pct = $processed == 0 ? 0 :
number_format ($blacklist / $processed * 100, 1, ".", "");
$registered = $dates[$today]["registered"];
$mailloop = $dates[$today]["mailloop"];
$nulllist = $dates[$today]["nulllist"];
- $nulllist_pct = $processed == 0 ? 0 :
+ $nulllist_pct = $processed == 0 ? 0 :
number_format ($nulllist / $processed * 100, 1, ".", "");
- $returned_link = $returned == 0 ? 0 :
+ $returned_link = $returned == 0 ? 0 :
"<a href=/maps/bin/detail.cgi?type=returned;date=$today>$returned</a>";
- $whitelist_link = $whitelist == 0 ? 0 :
+ $whitelist_link = $whitelist == 0 ? 0 :
"<a href=/maps/bin/detail.cgi?type=whitelist;date=$today>$whitelist</a>";
- $blacklist_link = $blacklist == 0 ? 0 :
+ $blacklist_link = $blacklist == 0 ? 0 :
"<a href=/maps/bin/detail.cgi?type=blacklist;date=$today>$blacklist</a>";
- $registered_link = $registered == 0 ? 0 :
+ $registered_link = $registered == 0 ? 0 :
"<a href=/maps/bin/detail.cgi?type=registered;date=$today>$registered</a>";
- $mailloop_link = $mailloop == 0 ? 0 :
+ $mailloop_link = $mailloop == 0 ? 0 :
"<a href=/maps/bin/detail.cgi?type=mailloop;date=$today>$mailloop</a>";
- $nulllist_link = $nulllist == 0 ? 0 :
+ $nulllist_link = $nulllist == 0 ? 0 :
"<a href=/maps/bin/detail.cgi?type=nulllist;date=$today>$nulllist</a>";
print <<<EOT
<div class="search">
<form method="get" action="/maps/bin/search.cgi" name="search">
Search Sender/Subject
- <input type="text" class="searchfield" id="searchfield" name="str"
+ <input type="text" class="searchfield" id="searchfield" name="str"
size="20" maxlength="255" value="" onclick="document.search.str.value='';">
</form>
</div>
$last_hit = substr ($last_hit, 5, 2) . "/" .
substr ($last_hit, 8, 2) . "/" .
substr ($last_hit, 0, 4);
- $leftclass = ($i == $lines || $sequence == $total || $sequence == $last) ?
+ $leftclass = ($i == $lines || $sequence == $total || $sequence == $last) ?
"tablebottomleft" : "tableleftdata";
$dataclass = ($i == $lines || $sequence == $total || $sequence == $last) ?
"tablebottomdata" : "tabledata";
or DBError ("Space: Unable to execute query: ", $statement);
while ($row = mysql_fetch_array ($result)) {
- $msg_space =
- strlen ($row["userid"]) +
+ $msg_space =
+ strlen ($row["userid"]) +
strlen ($row["sender"]) +
strlen ($row["subject"]) +
strlen ($row["timestamp"]) +