To use this service, you will need to log in; if you don't have an account here, you'll need to create one, but it's quick and painless.
");
}
include("dbclose.inc");
?>
If you have comments about this page, please contact
addressbook/logout.php3 100644 764 764 205 6743773501 15057 0 ustar bentonw bentonw
User logoutClick here
addressbook/addrbook.sql 100644 764 764 11134 6744501326 15316 0 ustar bentonw bentonw create sequence id;
create table session
(session_id varchar(256) primary key,
username varchar(32) not null,
password varchar(256) not null,
expires int not null);
create table luser
(uid int primary key default nextval('id'),
ulogin varchar(15) not null,
upass varchar(15) not null,
fname varchar(15) not null,
lname varchar(20),
email varchar(90) not null,
privlevel int not null default 0);
create table person
(pid int primary key default nextval('id'),
uid int not null references luser,
fname varchar(15) not null,
minit varchar(5),
lname varchar(20),
dyn_id varchar(10));
create table email
(eid int primary key default nextval('id'),
pid int not null references person,
address varchar(90) not null);
create table www_url
(wid int primary key default nextval('id'),
pid int not null references person,
url varchar(90) not null);
create table telephone
(tid int primary key default nextval('id'),
pid int not null references person,
countrycode varchar(5) default '1',
areacode varchar(5),
phone varchar(10),
ext varchar(10));
create table country
(cid int primary key default nextval('id'),
cname varchar(20) not null);
create table state
(sid int primary key default nextval('id'),
cid int references country,
sname varchar(20) not null);
create table post_main
(aid int primary key default nextval('id'),
pid int not null references person,
city varchar(30),
sid int references state,
cid int references country,
postcode varchar(15));
create table post_lines
(plid int primary key default nextval('id'),
pmid int references post_main,
ltext varchar(90));
-- a view representing a postal address
-- we will want to order by uid, pid, aid, plid;
create view post_addresses as
select luser.uid as user_id,
person.pid as person_id,
aid, plid,
person.fname as first_name,
person.minit as middle,
person.lname as last_name,
dyn_id,
ltext as address_line,
city,
sname as state,
cname as country,
postcode as postal_code
from luser, person, post_main,
post_lines, state,
country
where luser.uid = person.uid and
post_main.pid = person.pid and
post_lines.pmid = post_main.aid and
state.sid = post_main.sid and
country.cid = post_main.cid;
-- this function makes a pretty phone number from
-- countrycode, areacode, phonenumber
-- in the format "+ xxx (yyy) zzzzzzzz"
-- where xxx is countrycode
-- yyy is areacode
-- and zzz is the phonenumber
create function mkphone(varchar, varchar, varchar) returns varchar
as 'select (''+'' || ($1 || ('' ('' || ( $2 || ( '') '' || $3)))));'
language 'sql';
create view phone_numbers as
select luser.uid as user_id,
tid as pnum_id,
person.pid as person_id,
person.fname as first_name,
person.minit as middle,
person.lname as last_name,
mkphone(countrycode, areacode, phone) as phone_num,
ext
from luser, person, telephone
where luser.uid = person.uid and
telephone.pid = person.pid;
create function mkmailto(varchar) returns varchar
as 'select '''' || ($1 || '''')));'
language 'sql';
create view email_addresses as
select luser.uid as user_id,
eid as eaddr_id,
person.pid as person_id,
person.fname as first_name,
person.minit as middle,
person.lname as last_name,
address as email,
mkmailto(address) as mailto_url
from luser, person, email
where luser.uid = person.uid and
email.pid = person.pid;
create function mkhref(varchar) returns varchar
as 'select '''' || ($1 || '''')));'
language 'sql';
create view www_addresses as
select luser.uid as user_id,
wid as www_id,
person.pid as person_id,
url as url_text,
mkhref(url) as href
from luser, person, www_url
where luser.uid = person.uid and
www_url.pid = person.pid;
-- you will probably want to change this in a production
-- environment by creating a new db user
grant all on
country, email, email_addresses, id, luser, person,
phone_numbers, post_addresses, post_lines, post_main,
state, telephone, www_addresses, www_url
to public; addressbook/redir.inc 100644 764 764 50 6743773501 14530 0 ustar bentonw bentonw addressbook/config.inc 100644 764 764 370 6743775417 14725 0 ustar bentonw bentonw addressbook/dbopen.inc 100644 764 764 425 6743775164 14727 0 ustar bentonw bentonw Database connection error".
"please notify ".
"$SERVER_ADMIN_EMAIL");
?>
addressbook/login.php3 100644 764 764 1541 6743775263 14711 0 ustar bentonw bentonw 0) {
$vrow=pg_fetch_array($verify, 0);
$uid=$vrow[0];
setcookie("addressbook_user", $uid, 0, "/", "", 0);
// $redir_to="index.php3";
// include("redir.php3");
echo("Welcome, $user\n");
include("index.php3");
exit();
} else {
echo("Invalid login or password\n");
echo("\n");
echo("You can create an account or retry.");
}
}
?>
Log in to addressbook
addressbook/dbclose.inc 100644 764 764 26 6743773501 15041 0 ustar bentonw bentonw addressbook/alookup.inc 100644 764 764 446 6743775715 15137 0 ustar bentonw bentonw
addressbook/redir.php3 100644 764 764 51 6743773501 14632 0 ustar bentonw bentonw
addressbook/checkcookie.inc 100644 764 764 5146 6744501364 15742 0 ustar bentonw bentonw $currtime");
pg_exec
($conn,
"delete from session where username='$user' " .
" and password='$pass' and expires<$currtime");
if(pg_numrows($ila_res)) {
$rrow=pg_fetch_row($ila_res, 0);
$sess_id=$rrow[0];
pg_exec
($conn,
"update session set expires=$newexpires where session_id='$sess_id'");
return $sess_id;
} else {
return 0;
}
}
function u_logout($user, $pass) {
global $conn;
pg_exec($conn,
"delete from session where username='$user' and password='$pass'");
}
function s_logout($sess_id) {
global $conn;
pg_exec($conn,
"delete from session where session_id='$sess_id'");
}
function s_lookup($sess_id) {
global $conn;
$result = pg_exec
($conn,
"select username, password, expires from session where session_id='$sess_id'");
if(pg_numrows($result)) {
$row=pg_fetch_row($result, 0);
if($row[2]
addressbook/setcookie.php3 100644 764 764 163 6743773501 15536 0 ustar bentonw bentonw
addressbook/my-addressbook.php3 100644 764 764 2071 6743773501 16514 0 ustar bentonw bentonw Address book\n\n");
?>
People you know:
No entries in your addressbook\n");
} else {
echo("
");
?>
addressbook/states.sql 100644 764 764 5423 6743773501 15025 0 ustar bentonw bentonw insert into state (cid, sname) values (2, 'Alabama');
insert into state (cid, sname) values (2, 'Alaska');
insert into state (cid, sname) values (2, 'Arizona');
insert into state (cid, sname) values (2, 'Arkansas');
insert into state (cid, sname) values (2, 'California');
insert into state (cid, sname) values (2, 'Colorado');
insert into state (cid, sname) values (2, 'Connecticut');
insert into state (cid, sname) values (2, 'Delaware');
insert into state (cid, sname) values (2, 'Florida');
insert into state (cid, sname) values (2, 'Georgia');
insert into state (cid, sname) values (2, 'Hawaii');
insert into state (cid, sname) values (2, 'Idaho');
insert into state (cid, sname) values (2, 'Illinois');
insert into state (cid, sname) values (2, 'Indiana');
insert into state (cid, sname) values (2, 'Iowa');
insert into state (cid, sname) values (2, 'Kansas');
insert into state (cid, sname) values (2, 'Kentucky');
insert into state (cid, sname) values (2, 'Louisiana');
insert into state (cid, sname) values (2, 'Maine');
insert into state (cid, sname) values (2, 'Maryland');
insert into state (cid, sname) values (2, 'Massachusetts');
insert into state (cid, sname) values (2, 'Michigan');
insert into state (cid, sname) values (2, 'Minnesota');
insert into state (cid, sname) values (2, 'Mississippi');
insert into state (cid, sname) values (2, 'Missouri');
insert into state (cid, sname) values (2, 'Montana');
insert into state (cid, sname) values (2, 'Nebraska');
insert into state (cid, sname) values (2, 'Nevada');
insert into state (cid, sname) values (2, 'New Hampshire');
insert into state (cid, sname) values (2, 'New Jersey');
insert into state (cid, sname) values (2, 'New Mexico');
insert into state (cid, sname) values (2, 'New York');
insert into state (cid, sname) values (2, 'North Carolina');
insert into state (cid, sname) values (2, 'North Dakota');
insert into state (cid, sname) values (2, 'Ohio');
insert into state (cid, sname) values (2, 'Oklahoma');
insert into state (cid, sname) values (2, 'Oregon');
insert into state (cid, sname) values (2, 'Pennsylvania');
insert into state (cid, sname) values (2, 'Rhode Island');
insert into state (cid, sname) values (2, 'South Carolina');
insert into state (cid, sname) values (2, 'South Dakota');
insert into state (cid, sname) values (2, 'Tennessee');
insert into state (cid, sname) values (2, 'Texas');
insert into state (cid, sname) values (2, 'Utah');
insert into state (cid, sname) values (2, 'Vermont');
insert into state (cid, sname) values (2, 'Virginia');
insert into state (cid, sname) values (2, 'Washington');
insert into state (cid, sname) values (2, 'Washington, D.C.');
insert into state (cid, sname) values (2, 'West Virginia');
insert into state (cid, sname) values (2, 'Wisconsin');
insert into state (cid, sname) values (2, 'Wyoming');
addressbook/add-addressbook-entries.php3 100644 764 764 1556 6743773501 20275 0 ustar bentonw bentonw
");
echo("Add a person");
echo("");
} else {
pg_exec($conn, "insert into person (uid, fname, minit, lname) values ($addressbook_user, '$fname', '$minit', '$lname')");
include("dbclose.inc");
header("Location: my-addressbook.php3?mode=view\n\n");
exit();
}
?>
addressbook/add-begin.inc 100644 764 764 532 6743773501 15262 0 ustar bentonw bentonw Adding $addtype\n");
echo("\n");
echo("
addressbook/add-end.inc 100644 764 764 56 6743773501 14725 0 ustar bentonw bentonw ");
include("dbclose.inc");
?> addressbook/add-phone.php3 100644 764 764 1177 6743773501 15436 0 ustar bentonw bentonw
phone: () x
addressbook/add-post.php3 100644 764 764 3500 6743773501 15302 0 ustar bentonw bentonw
postal address:
city:
postcode:
addressbook/post_main 100600 764 764 1003 6743773501 14673 0 ustar bentonw bentonw select * from person
;
insert into person (uid, fname, minit, lname) values (1, 'Andrea', 'L', 'Gronstal');
insert into person (uid, fname, minit, lname) values (1, 'Ben', 'A R', 'Brown');
insert into person (uid, fname, minit, lname) values (1, 'Michael', 'R', 'Marchick');
select * from person
;
delete from person where pid=129;
select * from person
l
;
delete from person where pid=130;
\d email
select * from email;
delete from email where eid=136;
\d telephone
\d
\d www_url
select * from state;
\s post_main
addressbook/new-account.php3 100644 764 764 2556 6743773501 16024 0 ustar bentonw bentonw Add a new account
Sorry!\n
\nWe already have a user here named $add_name. You are more than welcome to pick a new login name, though.\n");
} else {
$nluser=pg_exec($conn, "insert into luser (ulogin, upass, email, fname, lname) values ('$add_name', '$add_pass', '$add_email', 'web', 'web');");
mail("$add_email", "new addressbook user at $SERVER_NAME", "Welcome!\nYou now have an addressbook account at $SERVER_NAME.\nHere's what you need to know:\n login: '$add_name'\n pass: '$add_pass'\n\n", "Reply-to: webmaster@$SERVER_NAME\nX-Mailer: Addressbook service at $SERVER_NAME\nFrom: Addressbook Service ");
echo("Welcome to the addressbook service, $add_name!
We have sent an email confirming your account to $add_email.