X-Git-Url: https://defaria.com/gitweb/?a=blobdiff_plain;f=maps%2Fphp%2FMAPS.php;h=6f1a8bac713513482541e2155a6de3d1997e6281;hb=15842e23ec99588d83312f43b66e468fabe40eec;hp=7fd877b3067b8537afd57e661225a53d7f3a8854;hpb=e06c4b0f74af031952ecf6876c5dceb6886764a0;p=clearscm.git diff --git a/maps/php/MAPS.php b/maps/php/MAPS.php index 7fd877b..6f1a8ba 100755 --- a/maps/php/MAPS.php +++ b/maps/php/MAPS.php @@ -1,24 +1,24 @@ Error # $errno $errmsg"; print "
SQL Statement: $statement"; - exit ($errno); + exit($errno); } // DBError -function OpenDB () { - $db = mysql_connect ("mysql.clearscm.com", "adefaria_admin", "adefaria_admin") - or DBError ("OpenDB: Unable to connect to database server", "Connect"); +function OpenDB() { + global $db; + + $db = mysqli_connect("127.0.0.1", "maps", "spam") + or DBError("OpenDB: Unable to connect to database server", "Connect"); - mysql_select_db ("adefaria_maps") - or DBError ("OpenDB: Unable to select MAPS database", "adefaria_maps"); + mysqli_select_db($db, "MAPS") + or DBError("OpenDB: Unable to select MAPS database", "adefaria_maps"); } // OpenDB -function SetContext ($new_userid) { +function CloseDB() { + global $db; + + if (isset ($db)) { + mysqli_close($db); + } // if +} // CloseDB + +function SetContext($new_userid) { global $userid; $userid = $new_userid; } // SetContext -function Encrypt ($password, $userid) { - $statement = "select encode(\"$password\",\"$userid\")"; +function Encrypt($password, $userid) { + global $db; + + $statement = "select hex(aes_encrypt(\"$password\",\"$userid\"))"; - $result = mysql_query ($statement) - or DBError ("Encrypt: Unable to execute statement", $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]; + return $row[0]; } // Encrypt -function UserExists ($userid) { +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"]; + $dbuserid = $row["userid"]; + $dbpassword = $row["password"]; if ($dbuserid != $userid) { return -1; @@ -87,11 +105,12 @@ function UserExists ($userid) { } # if } // UserExists -function Login ($userid, $password) { - $password = Encrypt ($password, $userid); +function Login($userid, $password) { + $password = Encrypt($password, $userid); // Check if user exists - $dbpassword = UserExists ($userid); + $dbpassword = UserExists($userid); + print "dbpassword = $dbpassword
"; // Return -1 if user doesn't exist if ($dbpassword == -1) { @@ -102,200 +121,205 @@ function Login ($userid, $password) { if ($password != $dbpassword) { return -2; } else { - setcookie ("MAPSUser", $userid, time()+60*60*24*30, "/maps"); - SetContext ($userid); + setcookie("MAPSUser", $userid, time()+60*60*24*30, "/maps"); + SetContext($userid); return 0; } // if } // 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) - or DBError ("CountList: Unable to count list: ", $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"]; + return $row["count"]; } // CountList -function FindList ($type, $next, $lines) { +function FindList($type, $next, $lines) { global $db; global $userid; global $lines; $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); + return array($count, $result); } // FindList -function Today2SQLDatetime () { +function Today2SQLDatetime() { return date ("Y-m-d H:i:s"); } // Today2SQLDatetime -function countem ($table, $condition) { +function countem($table, $condition) { + global $db; + $statement = "select count(distinct sender) as count from $table where $condition"; - $result = mysql_query ($statement) - or DBError ("countem: Unable to perform 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"]; + return $row["count"]; } // countem -function countlog ($condition="") { +function countlog($condition="") { global $userid; if ($condition != "") { - return countem ("log", "userid=\"$userid\" and " . $condition); + return countem("log", "userid=\"$userid\" and " . $condition); } else { - return countem ("log", "userid=\"$userid\""); + return countem("log", "userid=\"$userid\""); } // if } // countlog -function SubtractDays ($date, $nbr_days) { - +function SubtractDays($date, $nbr_days) { + } // SubtractDays -function GetStats ($nbr_days, $date = "") { +function GetStats($nbr_days, $date = "") { global $Types; if ($date == "") { - $date = Today2SQLDatetime (); + $date = Today2SQLDatetime(); } // if while ($nbr_days > 0) { - $ymd = substr ($date, 0, 10); + $ymd = substr($date, 0, 10); $sod = $ymd . " 00:00:00"; $eod = $ymd . " 23:59:59"; foreach ($Types as $type) { $condition = "type=\"$type\" and (timestamp > \"$sod\" and timestamp < \"$eod\")"; - $stats[$type] = countlog ($condition); + $stats[$type] = countlog($condition); } # foreach $dates[$ymd] = &$stats; - $date = SubtractDays ($date, 1); + $date = SubtractDays($date, 1); $nbr_days--; } # while return $dates; } # GetStats -function displayquickstats () { - $today = substr (Today2SQLDatetime (), 0, 10); - $dates = getquickstats ($today); - $current_time = date ("g:i a"); +function displayquickstats() { + $today = substr (Today2SQLDatetime(), 0, 10); + $dates = getquickstats($today); + $current_time = date("g:i:s a"); // Start quickstats - print "
"; - print "

Today's Activity

"; - print "

as of $current_time

"; + print "
"; + print "

Today's Activity

"; + print "

as of $current_time

"; - $processed = $dates[$today]["processed"]; - $returned = $dates[$today]["returned"]; - $returned_pct = $processed == 0 ? 0 : + $processed = $dates[$today]["processed"]; + $returned = $dates[$today]["returned"]; + $returned_pct = $processed == 0 ? 0 : number_format ($returned / $processed * 100, 1, ".", ""); - $whitelist = $dates[$today]["whitelist"]; - $whitelist_pct = $processed == 0 ? 0 : + $whitelist = $dates[$today]["whitelist"]; + $whitelist_pct = $processed == 0 ? 0 : number_format ($whitelist / $processed * 100, 1, ".", ""); - $blacklist = $dates[$today]["blacklist"]; - $blacklist_pct = $processed == 0 ? 0 : + $blacklist = $dates[$today]["blacklist"]; + $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 : + $registered = $dates[$today]["registered"]; + $mailloop = $dates[$today]["mailloop"]; + $nulllist = $dates[$today]["nulllist"]; + $nulllist_pct = $processed == 0 ? 0 : number_format ($nulllist / $processed * 100, 1, ".", ""); - $returned_link = $returned == 0 ? 0 : - "$returned"; - $whitelist_link = $whitelist == 0 ? 0 : - "$whitelist"; - $blacklist_link = $blacklist == 0 ? 0 : - "$blacklist"; - $registered_link = $registered == 0 ? 0 : - "$registered"; - $mailloop_link = $mailloop == 0 ? 0 : - "$mailloop"; - $nulllist_link = $nulllist == 0 ? 0 : - "$nulllist"; + $returned_link = $returned == 0 ? '' : + ""; + $whitelist_link = $whitelist == 0 ? '' : + ""; + $blacklist_link = $blacklist == 0 ? '' : + ""; + $registered_link = $registered == 0 ? '' : + ""; + $mailloop_link = $mailloop == 0 ? '' : + "\""; + $nulllist_link = $nulllist == 0 ? '' : + ""; print << - + - - + + + + + + - - + - - + - - + - - + - - - -
ProcessedProcessed $processed n/a
Returned$returned_link + ${nulllist_link}Nulllist$nulllist$nulllist_pct%
${returned_link}Returned$returned $returned_pct%
Whitelist$whitelist_link + ${whitelist_link}Whitelist$whitelist $whitelist_pct%
Blacklist$blacklist_link + ${blacklist_link}Blacklist$blacklist $blacklist_pct%
Registered$registered_link + ${registered_link}Registered$registered n/a
Mailloop$mailloop_link + ${mailloop_link}Mailloop$mailloop n/a
Nulllist$nulllist_link - $nulllist_pct%
+
EOT; } // displayquickstats -function getquickstats ($date) { +function getquickstats($date) { global $Types; - $dates = GetStats (1, $date); + $dates = GetStats(1, $date); foreach ($Types as $type) { - if (isset ($dates [$date]["processed"])) { - $dates [$date]["processed"] += $dates [$date][$type]; + if (isset ($dates[$date]["processed"])) { + $dates[$date]["processed"] += $dates[$date][$type]; } else { - $dates [$date]["processed"] = $dates [$date][$type]; + $dates[$date]["processed"] = $dates[$date][$type]; } // if } # foreach return $dates; } // getquickstats -function NavigationBar ($userid) { +function NavigationBar($userid) { print "
"; if (!isset ($userid) || $userid == "") { print <<Welcome to MAPS
+

MAPS 2.0

+
Welcome to MAPS
What is MAPS?
What is SPAM?
@@ -306,34 +330,36 @@ function NavigationBar ($userid) {
END; } else { - $Userid = ucfirst ($userid); + $Userid = ucfirst($userid); print <<Welcome $Userid +

MAPS 2.0

+
Welcome $Userid
- MAPS Home
+ Home
Statistics
- Edit Profile
+ Profile
Reports
- White List
- Black List
- Null List
+ White
+ Black
+ Null
Help
- MAPS Admin
+ Admin
Logout
END; + + displayquickstats(); + print <<
Search Sender/Subject -
END; - displayquickstats (); - print <<
+

END; } // if @@ -349,17 +376,17 @@ END; print ""; } # NavigationBar -function GetUserLines () { - global $userid; +function GetUserLines() { + global $userid, $db; $lines = 10; $statement = "select value from useropts where userid=\"$userid\" and name=\"Page\""; - $result = mysql_query ($statement) - or DBError ("GetUserLines: Unable to execute 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"]; @@ -368,57 +395,59 @@ function GetUserLines () { return $lines; } // GetUserLines -function DisplayList ($type, $next, $lines) { +function DisplayList($type, $next, $lines) { global $userid; global $total; global $last; + global $db; - $statement="select * from list where userid=\"$userid\" and type=\"$type\" order by sequence limit $next, $lines"; + $statement = "select * from list where userid=\"$userid\" and type=\"$type\" order by sequence limit $next, $lines"; - $result = mysql_query ($statement) - or DBError ("DisplayList: Unable to execute 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"])) { + if (!isset ($row["sequence"])) { break; } // if - $sequence = $row ["sequence"]; - $username = $row ["pattern"] == "" ? " " : $row ["pattern"]; - $domain = $row ["domain"] == "" ? " " : $row ["domain"]; - $hit_count = $row ["hit_count"] == "" ? " " : $row ["hit_count"]; - $last_hit = $row ["last_hit"] == "" ? " " : $row ["last_hit"]; - $comments = $row ["comment"] == "" ? " " : $row ["comment"]; + $sequence = $row["sequence"]; + $username = $row["pattern"] == "" ? " " : $row["pattern"]; + $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 - $last_hit = substr ($last_hit, 0, (strlen ($last_hit) - strpos ($last_hit, " ")) + 1); + $last_hit = substr($last_hit, 0, (strlen($last_hit) - strpos($last_hit, " ")) + 1); // Reformat last_hit $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) ? + $dataclass = ($i == $lines || $sequence == $total || $sequence == $last) ? "tablebottomdata" : "tabledata"; $rightclass = ($i == $lines || $sequence == $total || $sequence == $last) ? "tablebottomright" : "tablerightdata"; - print "" . $sequence . ""; - print "\n"; - print "" . $username . ""; + print "" . $sequence . "\n"; + print "" . $username . ""; print "@"; - print "" . $domain . ""; - print "" . $hit_count . ""; - print "" . $last_hit . ""; - print "" . $comments . ""; + print "$domain"; + print "" . $hit_count . ""; + print "" . $last_hit . ""; + print "" . $retention . ""; + print "" . $comments . ""; print ""; } // for } // DisplayList -function MAPSHeader () { +function MAPSHeader() { print << @@ -434,8 +463,8 @@ function MAPSHeader () { END; } // MAPSHeader -function ListDomains ($top = 10) { - global $userid; +function ListDomains($top = 10) { + global $userid, $db; // Generate a list of the top 10 spammers by domain $statement = "select count(sender) as nbr, "; @@ -447,14 +476,14 @@ function ListDomains ($top = 10) { $statement = $statement . "group by domain order by nbr desc"; // Do the query - $result = mysql_query ($statement) - or DBError ("ListDomains: Unable to execute query: ", $statement); + $result = mysqli_query($db, $statement) + or DBError("ListDomains: Unable to execute query: ", $statement); + print "
"; print << - Mark - Ranking +   Domain Returns @@ -462,22 +491,20 @@ 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 ""; $ranking = $i + 1; if ($i < $top - 1) { - print "\n"; - print "" . $ranking . ""; - print "$domain"; + print "" . $ranking . "\n"; + print "$domain"; print ""; print "$nbr"; } else { - print "\n"; - print "" . $ranking . ""; - print "$domain"; + print "" . $ranking . "\n"; + print "$domain"; print ""; print "$nbr"; } // if @@ -486,34 +513,37 @@ END; print << - + + END; } // ListDomains -function Space () { - global $userid; +function Space() { + global $userid, $db; // Tally up space used by $userid $space = 0; $statement = "select * from email where userid = \"$userid\""; - $result = mysql_query ($statement) - or DBError ("Space: Unable to execute query: ", $statement); - - while ($row = mysql_fetch_array ($result)) { - $msg_space = - strlen ($row["userid"]) + - strlen ($row["sender"]) + - strlen ($row["subject"]) + - strlen ($row["timestamp"]) + - strlen ($row["data"]); - $space = $space + $msg_space; + $result = mysqli_query($db, $statement) + or DBError("Space: Unable to execute query: ", $statement); + + while ($row = mysqli_fetch_array ($result)) { + $msg_space = + strlen($row["userid"]) + + strlen($row["sender"]) + + strlen($row["subject"]) + + strlen($row["timestamp"]) + + strlen($row["data"]); + $space += $msg_space; } // while + mysqli_free_result($result); + return $space; } // Space ?>