projects
/
clearscm.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Changed announceEmail.pl to remove things like order numbers
[clearscm.git]
/
maps
/
php
/
MAPS.php
diff --git
a/maps/php/MAPS.php
b/maps/php/MAPS.php
index
59936e2
..
9b94c17
100755
(executable)
--- a/
maps/php/MAPS.php
+++ b/
maps/php/MAPS.php
@@
-34,9
+34,13
@@
$Types = array (
"nulllist"
);
"nulllist"
);
+$db;
+
function DBError($msg, $statement) {
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";
print "$msg<br>Error # $errno $errmsg";
print "<br>SQL Statement: $statement";
@@
-44,13
+48,23
@@
function DBError($msg, $statement) {
} // DBError
function OpenDB() {
} // DBError
function OpenDB() {
- $db = mysql_connect("localhost", "maps", "spam")
+ global $db;
+
+ $db = mysqli_connect("localhost", "maps", "spam")
or DBError("OpenDB: Unable to connect to database server", "Connect");
or DBError("OpenDB: Unable to connect to database server", "Connect");
- mysql
_select_db(
"MAPS")
+ mysql
i_select_db($db,
"MAPS")
or DBError("OpenDB: Unable to select MAPS database", "adefaria_maps");
} // OpenDB
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 SetContext($new_userid) {
global $userid;
@@
-58,24
+72,28
@@
function SetContext($new_userid) {
} // SetContext
function Encrypt($password, $userid) {
} // SetContext
function Encrypt($password, $userid) {
+ global $db;
+
$statement = "select encode(\"$password\",\"$userid\")";
$statement = "select encode(\"$password\",\"$userid\")";
- $result = mysql
_query(
$statement)
+ $result = mysql
i_query($db,
$statement)
or DBError("Encrypt: Unable to execute statement", $statement);
// Get return value, which should be the encoded password
or DBError("Encrypt: Unable to execute statement", $statement);
// Get return value, which should be the encoded password
- $row = mysql_fetch_array($result);
+ $row = mysql
i
_fetch_array($result);
return $row[0];
} // Encrypt
function UserExists($userid) {
return $row[0];
} // Encrypt
function UserExists($userid) {
+ global $db;
+
$statement = "select userid, password from user where userid = \"$userid\"";
$statement = "select userid, password from user where userid = \"$userid\"";
- $result = mysql
_query(
$statement)
+ $result = mysql
i_query($db,
$statement)
or DBError ("UserExists: Unable to execute statement", $statement);
or DBError ("UserExists: Unable to execute statement", $statement);
- $row = mysql_fetch_array($result);
+ $row = mysql
i
_fetch_array($result);
$dbuserid = $row["userid"];
$dbpassword = $row["password"];
$dbuserid = $row["userid"];
$dbpassword = $row["password"];
@@
-109,15
+127,15
@@
function Login($userid, $password) {
} // Login
function CountList ($type) {
} // Login
function CountList ($type) {
- global $userid;
+ global $userid
, $db
;
$statement = "select count(*) as count from list where type=\"$type\" and userid=\"$userid\"";
$statement = "select count(*) as count from list where type=\"$type\" and userid=\"$userid\"";
- $result = mysql
_query(
$statement)
+ $result = mysql
i_query($db,
$statement)
or DBError("CountList: Unable to count list: ", $statement);
// How many rows are there?
or DBError("CountList: Unable to count list: ", $statement);
// How many rows are there?
- $row = mysql_fetch_array($result);
+ $row = mysql
i
_fetch_array($result);
return $row["count"];
} // CountList
return $row["count"];
} // CountList
@@
-129,10
+147,10
@@
function FindList($type, $next, $lines) {
$statement = "select * from list where type=\"$type\" and userid=\"$userid\" order by sequence limit $next, $lines";
$statement = "select * from list where type=\"$type\" and userid=\"$userid\" order by sequence limit $next, $lines";
- $result = mysql
_query(
$statement)
+ $result = mysql
i_query($db,
$statement)
or DBError ("FindList: Unable to execute query: ", $statement);
or DBError ("FindList: Unable to execute query: ", $statement);
- $count = mysql_num_rows($result);
+ $count = mysql
i
_num_rows($result);
return array($count, $result);
} // FindList
return array($count, $result);
} // FindList
@@
-142,13
+160,15
@@
function Today2SQLDatetime() {
} // Today2SQLDatetime
function countem($table, $condition) {
} // Today2SQLDatetime
function countem($table, $condition) {
+ global $db;
+
$statement = "select count(distinct sender) as count from $table where $condition";
$statement = "select count(distinct sender) as count from $table where $condition";
- $result = mysql
_query(
$statement)
+ $result = mysql
i_query($db,
$statement)
or DBError("countem: Unable to perform query: ", $statement);
// How many rows are there?
or DBError("countem: Unable to perform query: ", $statement);
// How many rows are there?
- $row = mysql_fetch_array($result);
+ $row = mysql
i
_fetch_array($result);
return $row["count"];
} // countem
return $row["count"];
} // countem
@@
-350,16
+370,16
@@
END;
} # NavigationBar
function GetUserLines() {
} # NavigationBar
function GetUserLines() {
- global $userid;
+ global $userid
, $db
;
$lines = 10;
$statement = "select value from useropts where userid=\"$userid\" and name=\"Page\"";
$lines = 10;
$statement = "select value from useropts where userid=\"$userid\" and name=\"Page\"";
- $result = mysql
_query(
$statement)
+ $result = mysql
i_query($db,
$statement)
or DBError("GetUserLines: Unable to execute query: ", $statement);
or DBError("GetUserLines: Unable to execute query: ", $statement);
- $row = mysql_fetch_array ($result);
+ $row = mysql
i
_fetch_array ($result);
if (isset ($row["value"])) {
$lines = $row["value"];
if (isset ($row["value"])) {
$lines = $row["value"];
@@
-372,14
+392,15
@@
function DisplayList($type, $next, $lines) {
global $userid;
global $total;
global $last;
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)
+ $result = mysql
i_query($db,
$statement)
or DBError("DisplayList: Unable to execute query: ", $statement);
for ($i = 0; $i < $lines; $i++) {
or DBError("DisplayList: Unable to execute query: ", $statement);
for ($i = 0; $i < $lines; $i++) {
- $row = mysql_fetch_array ($result);
+ $row = mysql
i
_fetch_array ($result);
if (!isset ($row ["sequence"])) {
break;
if (!isset ($row ["sequence"])) {
break;
@@
-435,7
+456,7
@@
END;
} // MAPSHeader
function ListDomains($top = 10) {
} // 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, ";
// Generate a list of the top 10 spammers by domain
$statement = "select count(sender) as nbr, ";
@@
-447,7
+468,7
@@
function ListDomains($top = 10) {
$statement = $statement . "group by domain order by nbr desc";
// Do the query
$statement = $statement . "group by domain order by nbr desc";
// Do the query
- $result = mysql
_query(
$statement)
+ $result = mysql
i_query($db,
$statement)
or DBError("ListDomains: Unable to execute query: ", $statement);
print <<<END
or DBError("ListDomains: Unable to execute query: ", $statement);
print <<<END
@@
-462,7
+483,7
@@
END;
// Get results
for ($i = 0; $i < $top; $i++) {
// Get results
for ($i = 0; $i < $top; $i++) {
- $row = mysql_fetch_array ($result);
+ $row = mysql
i
_fetch_array ($result);
$domain = $row["domain"];
$nbr = $row["nbr"];
$domain = $row["domain"];
$nbr = $row["nbr"];
@@
-494,26
+515,28
@@
END;
} // ListDomains
function Space() {
} // ListDomains
function Space() {
- global $userid;
+ global $userid
, $db
;
// Tally up space used by $userid
$space = 0;
$statement = "select * from email where userid = \"$userid\"";
// Tally up space used by $userid
$space = 0;
$statement = "select * from email where userid = \"$userid\"";
- $result = mysql
_query(
$statement)
+ $result = mysql
i_query($db,
$statement)
or DBError("Space: Unable to execute query: ", $statement);
or DBError("Space: Unable to execute query: ", $statement);
- while ($row = mysql_fetch_array ($result)) {
+ while ($row = mysql
i
_fetch_array ($result)) {
$msg_space =
strlen($row["userid"]) +
strlen($row["sender"]) +
strlen($row["subject"]) +
strlen($row["timestamp"]) +
strlen($row["data"]);
$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
} // while
+ mysqli_free_result($result);
+
return $space;
} // Space
?>
return $space;
} // Space
?>