// projects.php - 10/04/2006 - /phpApps/ - Displays summary info for geographic location.
/*
communityneeds.projects
CREATE TABLE IF NOT EXISTS `project` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`description` text NOT NULL,
`startdate` date NOT NULL,
`enddate` date NOT NULL,
`createdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`owner_id` bigint(20) NOT NULL,
`city` varchar(20) NOT NULL,
`state` varchar(2) NOT NULL,
`status` varchar(6) NOT NULL,
`groupid` bigint(20) NOT NULL COMMENT 'Group ID',
PRIMARY KEY (`id`),
KEY `title` (`title`),
KEY `groupid` (`groupid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
*/
session_start();
require_once('Bootstrap.php');
$bootstrap = Bootstrap::create();
$narrowScreen = 1;
$param = '&bmf=1';
$thisApp = 'projects.php';
include($bootstrap->libraryDirectory.'settings.php');
include($bootstrap->libraryDirectory.'datacon.php');
require($bootstrap->libraryDirectory.'proclib.php');
if (! $dbstate){
$pageHdg = "NCCS - Project Management";
} elseif ($dbstate =='boston') {
$pageHdg = "Massachusetts Project Management";
} else {
$pageHdg = "Project Management";
}
$maxRecs = 600;
$action = '';
$debug = 0;
if (isset($gUser)){
if ($gUser == 'tpollak'){
$debug = 0;
}
if (strlen($gUser)>0){
$gUserOk = 1;
}
}
if (checkUserAccessRights($gUser, 'SUPER',0) == 1 or eregi('denatal',$gUser) ){
$admin = 1;
}
if (checkUserAccessRights($gUser, 'CMTY',0) == 1 ){
$cmtyUser = 1;
}
include($bootstrap->libraryDirectory.'head.php');
include($bootstrap->libraryDirectory.'head2.php');
echo "$pageHdg
\n";
?>