main.php

<?php 
// GiftWeb: PHP/PostgreSQL online Gift Registry System 
// Matthew T. Jachimstal
// Copyright (C) 2000-2008  Matthew T. Jachimstal
//
// email: matthew@jachimstal.com
//
// Snail mail: Matthew Jachimstal
//             1106 Canterbury Ct, Unit D
//             Elgin, IL 60120
//
// This program is free software; you can redistribute it and/or
// modify it under the terms of the GNU General Public License
// as published by the Free Software Foundation; either version 2
// of the License, or (at your option) any later version.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with this program; if not, write to the Free Software
// Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
//
//
require "./main.inc";
require "./util.php";

$s = $_COOKIE["GiftWeb_Session"];

$uid = validatesession($s);
$conn = ADONewConnection($dbtype);
$conn->PConnect($dbhost, $dbuser, $dbpass, $dbname);

startpage_old("Main Gift Registry Page", 1);
checkprimary($uid);

// check if user is group admin of any groups. If so, grpadm will
// be > 0, making 'if($grpadm)' true
$sql = "SELECT count(*) AS count FROM groups WHERE admin='$uid'";
$result = $conn->Execute($sql);
$grpadm = $result->fields["count"];

// check if user is the site admin. If so, siteadm will
// be > 0, making 'if($siteadm)' true
$sql = "SELECT count(*) AS count FROM giftweb WHERE admin='$uid'";
$result = $conn->Execute($sql);
$siteadm = $result->fields["count"];

?>

<h3><a href="editprefs.php" title="Preferences">Edit</a> your preferences. (email
address, groups, events, etc.)</h3>
<h3><a href="editlist.php" title="Edit My List">Edit</a> your wish list.</h3>
<h3><a href="viewusers.php" title="Other Users">View</a> other wish lists.</h3>
<?php 
if ($grpadm)
{
	$sql = "SELECT * FROM groups, members ";
	$sql .= "WHERE groups.gid=members.gid ";
	$sql .= "  and groups.admin='$uid' ";
	$sql .= "  and members.request='t'";
	$result = $conn->Execute($sql);

	?>
	<h3><a href="grpadm.php" title="Group Maint">Group Maintenance</a>
	<?php 

	if ($result->RecordCount() > 0)
	{
		echo "&nbsp;&nbsp;Requests pending";
	}

	echo "</h3>";
}

if ($siteadm)
{
	?>
	<h3><a href="siteadmin.php" title="Site Maint">Site Maintenance</a></h3>
	<p>
	<?php 
}

?>
	<b><a href="news.php" target="_blank" title="News">Site News</a></b> Updated 12 Nov 2001<br>
	<b><a href="todo.php" target="_blank" title="ToDo">ToDo List</a></b> New 27 Nov 2000
<p>

<?php 
	endpage_old(1);
?>