function OpenDB() {
global $db;
- $db = mysqli_connect("localhost", "maps", "spam")
+ $db = mysqli_connect("127.0.0.1", "maps", "spam")
or DBError("OpenDB: Unable to connect to database server", "Connect");
mysqli_select_db($db, "MAPS")
or DBError("OpenDB: Unable to select MAPS database", "adefaria_maps");
} // OpenDB
+function CloseDB() {
+ global $db;
+
+ if (isset ($db)) {
+ mysqli_close($db);
+ } // if
+} // CloseDB
+
function SetContext($new_userid) {
global $userid;
function Encrypt($password, $userid) {
global $db;
- $statement = "select encode(\"$password\",\"$userid\")";
+ $statement = "select hex(aes_encrypt(\"$password\",\"$userid\"))";
$result = mysqli_query($db, $statement)
or DBError("Encrypt: Unable to execute statement", $statement);
// Check if user exists
$dbpassword = UserExists($userid);
+ print "dbpassword = $dbpassword<br>";
// Return -1 if user doesn't exist
if ($dbpassword == -1) {
// Start quickstats
print "<div class=quickstats>";
- print "<h4 align=center class=header>Today's Activity</h4>";
+ print "<h4 align=center class=todaysactivity>Today's Activity</h4>";
print "<p align=center><b>as of $current_time</b></p>";
$processed = $dates[$today]["processed"];
if (!isset ($userid) || $userid == "") {
print <<<END
- <div class="username">Welcome to MAPS</div>
+ <h2 align='center'><font style="color: white">MAPS 2.0</font></h2>
+ <div class="username">Welcome to MAPS</div>
<div class="menu">
<a href="/maps/doc/">What is MAPS?</a><br>
<a href="/maps/doc/SPAM.php">What is SPAM?</a><br>
} else {
$Userid = ucfirst($userid);
print <<<END
- <div class="username">Welcome $Userid</div>
+ <h2 align='center'><font style="color: white">MAPS 2.0</font></h2>
+ <div class="username">Welcome $Userid</div>
<div class="menu">
<a href="/maps/">Home</a><br>
<a href="/maps/bin/stats.cgi">Statistics</a><br>
<a href="/maps/?logout=yes">Logout</a>
</div>
END;
+
+ displayquickstats();
+
print <<<END
<div class="search">
<form method="get" action="/maps/bin/search.cgi" name="search">
</div>
END;
- displayquickstats();
-
print <<<END
<div class="search">
<form "method"=post action="javascript://" name="address"
<input type="text" class="searchfield" id="searchfield" name="email"
size="20" maxlength="255" value="" onclick="document.address.email.value = '';">
</form>
+ <p></p>
</div>
END;
} // if
or DBError("DisplayList: Unable to execute query: ", $statement);
for ($i = 0; $i < $lines; $i++) {
- $row = mysqli_fetch_array ($result);
+ $row = mysqli_fetch_array($result);
- if (!isset ($row ["sequence"])) {
+ if (!isset ($row["sequence"])) {
break;
} // if
$domain = $row["domain"] == "" ? " " : $row["domain"];
$hit_count = $row["hit_count"] == "" ? " " : $row["hit_count"];
$last_hit = $row["last_hit"] == "" ? " " : $row["last_hit"];
+ $retention = $row["retention"] == "" ? " " : $row["retention"];
$comments = $row["comment"] == "" ? " " : $row["comment"];
// Remove time from last hit
$rightclass = ($i == $lines || $sequence == $total || $sequence == $last) ?
"tablebottomright" : "tablerightdata";
- print "<td class=$leftclass align=center>" . $sequence . "</td>";
- print "<td class=$dataclass align=center><input type=checkbox name=action" . $sequence . " value=on></td>\n";
+ print "<td class=$leftclass align=right>" . $sequence . "<input type=checkbox name=action" . $sequence . " value=on></td>\n";
print "<td class=$dataclass align=right>" . $username . "</td>";
print "<td class=$dataclass align=center>@</td>";
print "<td class=$dataclass align=left><a href=\"http://$domain\" target=_blank>$domain</a></td>";
print "<td class=$dataclass align=right>" . $hit_count . "</td>";
print "<td class=$dataclass align=center>" . $last_hit . "</td>";
+ print "<td class=$dataclass align=right>" . $retention . "</td>";
print "<td class=$rightclass align=left>" . $comments . "</td>";
print "</tr>";
} // for
if ($i < $top - 1) {
print "<td class=tableleftdata align=center><input type=checkbox name=action" . $i . " value=on></td>\n";
print "<td align=center class=tabledata>" . $ranking . "</td>";
- print "<td class=tabledata>$domain</td>";
+ print "<td class=tabledata><a href=\"http://$domain\">$domain</as></td>";
print "<input type=hidden name=email$i value=\"@$domain\">";
print "<td align=center class=tablerightdata>$nbr</td>";
} else {
print "<td class=tablebottomleft align=center><input type=checkbox name=action" . $i . " value=on></td>\n";
print "<td align=center class=tablebottomdata>" . $ranking . "</td>";
- print "<td class=tablebottomdata>$domain</td>";
+ print "<td class=tablebottomdata><a href=\"http://$domain\">$domain</a></td>";
print "<input type=hidden name=email$i value=\"@$domain\">";
print "<td align=center class=tablebottomright>$nbr</td>";
} // if
strlen($row["subject"]) +
strlen($row["timestamp"]) +
strlen($row["data"]);
- $space = $space + $msg_space;
+ $space += $msg_space;
} // while
+ mysqli_free_result($result);
+
return $space;
} // Space
?>