"nulllist"
);
+$db;
+
function DBError($msg, $statement) {
- $errno = mysql_errno();
- $errmsg = mysql_error();
+ global $db;
+
+ $errno = mysqli_errno($db);
+ $errmsg = mysqli_error($db);
print "$msg<br>Error # $errno $errmsg";
print "<br>SQL Statement: $statement";
} // DBError
function OpenDB() {
- $db = mysql_connect("localhost", "mapsadmin", "mapsadmin")
+ global $db;
+
+ $db = mysqli_connect("localhost", "maps", "spam")
or DBError("OpenDB: Unable to connect to database server", "Connect");
- mysql_select_db("MAPS")
+ 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;
} // SetContext
function Encrypt($password, $userid) {
+ global $db;
+
$statement = "select encode(\"$password\",\"$userid\")";
- $result = mysql_query($statement)
+ $result = mysqli_query($db, $statement)
or DBError("Encrypt: Unable to execute statement", $statement);
// Get return value, which should be the encoded password
- $row = mysql_fetch_array($result);
+ $row = mysqli_fetch_array($result);
return $row[0];
} // Encrypt
function UserExists($userid) {
+ global $db;
+
$statement = "select userid, password from user where userid = \"$userid\"";
- $result = mysql_query($statement)
+ $result = mysqli_query($db, $statement)
or DBError ("UserExists: Unable to execute statement", $statement);
- $row = mysql_fetch_array($result);
+ $row = mysqli_fetch_array($result);
$dbuserid = $row["userid"];
$dbpassword = $row["password"];
} // Login
function CountList ($type) {
- global $userid;
+ global $userid, $db;
$statement = "select count(*) as count from list where type=\"$type\" and userid=\"$userid\"";
- $result = mysql_query($statement)
+ $result = mysqli_query($db, $statement)
or DBError("CountList: Unable to count list: ", $statement);
// How many rows are there?
- $row = mysql_fetch_array($result);
+ $row = mysqli_fetch_array($result);
return $row["count"];
} // CountList
$statement = "select * from list where type=\"$type\" and userid=\"$userid\" order by sequence limit $next, $lines";
- $result = mysql_query($statement)
+ $result = mysqli_query($db, $statement)
or DBError ("FindList: Unable to execute query: ", $statement);
- $count = mysql_num_rows($result);
+ $count = mysqli_num_rows($result);
return array($count, $result);
} // FindList
} // Today2SQLDatetime
function countem($table, $condition) {
+ global $db;
+
$statement = "select count(distinct sender) as count from $table where $condition";
- $result = mysql_query($statement)
+ $result = mysqli_query($db, $statement)
or DBError("countem: Unable to perform query: ", $statement);
// How many rows are there?
- $row = mysql_fetch_array($result);
+ $row = mysqli_fetch_array($result);
return $row["count"];
} // countem
function displayquickstats() {
$today = substr (Today2SQLDatetime(), 0, 10);
$dates = getquickstats($today);
- $current_time = date("g:i a");
+ $current_time = date("g:i:s a");
// Start quickstats
print "<div class=quickstats>";
print <<<END
<div class="username">Welcome $Userid</div>
<div class="menu">
- <a href="/maps/">MAPS Home</a><br>
+ <a href="/maps/">Home</a><br>
<a href="/maps/bin/stats.cgi">Statistics</a><br>
- <a href="/maps/bin/editprofile.cgi">Edit Profile</a><br>
+ <a href="/maps/bin/editprofile.cgi">Profile</a><br>
<a href="/maps/php/Reports.php">Reports</a><br>
- <a href="/maps/php/list.php?type=white">White List</a><br>
- <a href="/maps/php/list.php?type=black">Black List</a><br>
- <a href="/maps/php/list.php?type=null">Null List</a><br>
+ <a href="/maps/php/list.php?type=white">White</a><br>
+ <a href="/maps/php/list.php?type=black">Black</a><br>
+ <a href="/maps/php/list.php?type=null">Null</a><br>
<a href="/maps/doc/">Help</a><br>
- <a href="/maps/adm/">MAPS Admin</a><br>
+ <a href="/maps/adm/">Admin</a><br>
<a href="/maps/?logout=yes">Logout</a>
</div>
END;
} # NavigationBar
function GetUserLines() {
- global $userid;
+ global $userid, $db;
$lines = 10;
$statement = "select value from useropts where userid=\"$userid\" and name=\"Page\"";
- $result = mysql_query($statement)
+ $result = mysqli_query($db, $statement)
or DBError("GetUserLines: Unable to execute query: ", $statement);
- $row = mysql_fetch_array ($result);
+ $row = mysqli_fetch_array ($result);
if (isset ($row["value"])) {
$lines = $row["value"];
global $userid;
global $total;
global $last;
+ global $db;
$statement = "select * from list where userid=\"$userid\" and type=\"$type\" order by sequence limit $next, $lines";
- $result = mysql_query($statement)
+ $result = mysqli_query($db, $statement)
or DBError("DisplayList: Unable to execute query: ", $statement);
for ($i = 0; $i < $lines; $i++) {
- $row = mysql_fetch_array ($result);
+ $row = mysqli_fetch_array ($result);
if (!isset ($row ["sequence"])) {
break;
} // MAPSHeader
function ListDomains($top = 10) {
- global $userid;
+ global $userid, $db;
// Generate a list of the top 10 spammers by domain
$statement = "select count(sender) as nbr, ";
$statement = $statement . "group by domain order by nbr desc";
// Do the query
- $result = mysql_query($statement)
+ $result = mysqli_query($db, $statement)
or DBError("ListDomains: Unable to execute query: ", $statement);
print <<<END
// Get results
for ($i = 0; $i < $top; $i++) {
- $row = mysql_fetch_array ($result);
+ $row = mysqli_fetch_array ($result);
$domain = $row["domain"];
$nbr = $row["nbr"];
print <<<END
<tr>
- <td align=center colspan=4><input type="submit" name="action" value="Nulllist Marked" onclick="return CheckAtLeast1Checked (document.domains);" /><input type="submit" name="action" value="Reset Marks" onclick="return ClearAll (document.domains);" />
+ <td align=center colspan=4><input type="submit" name="action" value="Nulllist" onclick="return CheckAtLeast1Checked (document.domains);" /><input type="submit" name="action" value="Reset" onclick="return ClearAll (document.domains);" />
</td>
</tr>
<table>
} // ListDomains
function Space() {
- global $userid;
+ global $userid, $db;
// Tally up space used by $userid
$space = 0;
$statement = "select * from email where userid = \"$userid\"";
- $result = mysql_query($statement)
+ $result = mysqli_query($db, $statement)
or DBError("Space: Unable to execute query: ", $statement);
- while ($row = mysql_fetch_array ($result)) {
+ while ($row = mysqli_fetch_array ($result)) {
$msg_space =
strlen($row["userid"]) +
strlen($row["sender"]) +
strlen($row["subject"]) +
strlen($row["timestamp"]) +
strlen($row["data"]);
- $space = $space + $msg_space;
+ $space += $msg_space;
} // while
+ mysqli_free_result($result);
+
return $space;
} // Space
?>