openfirst-cvscommit Mailing List for openFIRST (Page 82)
Brought to you by:
xtimg
Menu
▾
▴
openfirst-cvscommit — Notify subscribers of changes to files in CVS.
You can subscribe to this list here.
| 2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(41) |
Jun
(210) |
Jul
(39) |
Aug
(153) |
Sep
(147) |
Oct
(173) |
Nov
(81) |
Dec
(163) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2004 |
Jan
(33) |
Feb
(18) |
Mar
|
Apr
(62) |
May
|
Jun
(100) |
Jul
(38) |
Aug
(58) |
Sep
(1) |
Oct
|
Nov
(25) |
Dec
(172) |
| 2005 |
Jan
(31) |
Feb
(12) |
Mar
(67) |
Apr
(92) |
May
(247) |
Jun
(34) |
Jul
(36) |
Aug
(192) |
Sep
(15) |
Oct
(42) |
Nov
(92) |
Dec
(4) |
| 2006 |
Jan
|
Feb
(21) |
Mar
|
Apr
|
May
|
Jun
(53) |
Jul
(7) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2007 |
Jan
|
Feb
|
Mar
(4) |
Apr
(4) |
May
|
Jun
(15) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: <xt...@us...> - 2003-09-01 20:16:29
|
Update of /cvsroot/openfirst/feedback/admin
In directory sc8-pr-cvs1:/tmp/cvs-serv24128
Modified Files:
index.php
Log Message:
Fix spacing issues in feedback admin which were interfering with its proper operation.
Index: index.php
===================================================================
RCS file: /cvsroot/openfirst/feedback/admin/index.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** index.php 23 Aug 2003 20:13:19 -0000 1.4
--- index.php 1 Sep 2003 20:16:25 -0000 1.5
***************
*** 35,40 ****
$line = explode("\n", $_POST["feedbackusers"]);
foreach ($line as $lin) {
! $fname = (substr($lin, strpos($lin, " ") - strlen($lin)));
! $femail = substr($lin, 0, strpos($lin, " "));
if(trim($fname) != "" && trim($femail) != "") {
// Create the new users for the feedback list
--- 35,40 ----
$line = explode("\n", $_POST["feedbackusers"]);
foreach ($line as $lin) {
! $fname = trim(substr($lin, strpos($lin, " ") - strlen($lin)));
! $femail = trim(substr($lin, 0, strpos($lin, " ")));
if(trim($fname) != "" && trim($femail) != "") {
// Create the new users for the feedback list
***************
*** 56,60 ****
echo("<textarea name='feedbackusers' rows='10' cols='50'>");
while($feedback = ofirst_dbfetch_object($query)){
! echo("$feedback->email$feedback->name\n");
}
} else {
--- 56,60 ----
echo("<textarea name='feedbackusers' rows='10' cols='50'>");
while($feedback = ofirst_dbfetch_object($query)){
! echo("$feedback->email $feedback->name\n");
}
} else {
|
|
From: <xt...@us...> - 2003-09-01 20:11:16
|
Update of /cvsroot/openfirst/members
In directory sc8-pr-cvs1:/tmp/cvs-serv23216
Modified Files:
profile.php
Log Message:
Add missing </a>
Index: profile.php
===================================================================
RCS file: /cvsroot/openfirst/members/profile.php,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** profile.php 23 Aug 2003 20:31:16 -0000 1.11
--- profile.php 1 Sep 2003 20:11:13 -0000 1.12
***************
*** 86,90 ****
<table>
! <tr><th><a href="profile.php?orderby=user">Nick Name</a></th><th><a href="profile.php?orderby=team">Team</a></th><th><a href="profile.php?orderby=email">E-mail</a></th><th><a href="profile.php?orderby=msn">MSN</a></th><th><a href="profile.php?orderby=icq">ICQ</a></th><th><a href="profile.php?orderby=aim">AIM</a></th><th><a href="profile.php?orderby=picturelocation">Photo</th></tr>
<?php
if($_GET["orderby"] == "") { $_GET["orderby"] = "user"; }
--- 86,90 ----
<table>
! <tr><th><a href="profile.php?orderby=user">Nick Name</a></th><th><a href="profile.php?orderby=team">Team</a></th><th><a href="profile.php?orderby=email">E-mail</a></th><th><a href="profile.php?orderby=msn">MSN</a></th><th><a href="profile.php?orderby=icq">ICQ</a></th><th><a href="profile.php?orderby=aim">AIM</a></th><th><a href="profile.php?orderby=picturelocation">Photo</a></th></tr>
<?php
if($_GET["orderby"] == "") { $_GET["orderby"] = "user"; }
|
|
From: <xt...@us...> - 2003-09-01 20:10:41
|
Update of /cvsroot/openfirst/photogallery
In directory sc8-pr-cvs1:/tmp/cvs-serv23033
Modified Files:
gallery.php index.php
Log Message:
Fix some alt tag issues, etc. make it closer to being valid HTML
Index: gallery.php
===================================================================
RCS file: /cvsroot/openfirst/photogallery/gallery.php,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** gallery.php 1 Sep 2003 15:29:03 -0000 1.11
--- gallery.php 1 Sep 2003 20:10:36 -0000 1.12
***************
*** 84,99 ****
// Setup column for the next image
! echo " <td width='34%'><center><a target='_blank' href='viewphoto.php?ID=".$_GET['ID']."&PHOTO=".$file."'>";
// Check if there is a thumb available for this image, if so then use it or else preview the actual reduced image
if(file_exists($dirlocate."/thumbs/".$file)){
! echo "<img border='1px' height=100 width=152 src='".$dirlocate."/thumbs/".$file."'>";
} else {
! echo "<img border='1px' height=100 width=152 src='".$dirlocate."/".$file."'>";
}
// Add e-mail and image expand buttons as well as close column
! echo "</a><br><a href='email.php?PHOTO=$file&ID=".$_GET['ID']."'><img border='0' src=email.PNG alt='Email to a friend'></a>
! <a target='_blank' href='viewphoto.php?ID=".$_GET['ID']."&PHOTO=".$file."'><img border='0' alt='Enlarge' src='enlarge.PNG'></a>
</center></td>\n";
--- 84,99 ----
// Setup column for the next image
! echo " <td width='34%'><center><a target='_blank' href='viewphoto.php?ID=".$_GET['ID']."&PHOTO=".$file."'>";
// Check if there is a thumb available for this image, if so then use it or else preview the actual reduced image
if(file_exists($dirlocate."/thumbs/".$file)){
! echo "<img border='1px' height=100 width=152 alt='Photo Gallery Image' src='".$dirlocate."/thumbs/".$file."'>";
} else {
! echo "<img border='1px' height=100 width=152 alt='Photo Gallery Image' src='".$dirlocate."/".$file."'>";
}
// Add e-mail and image expand buttons as well as close column
! echo "</a><br><a href='email.php?PHOTO=$file&ID=".$_GET['ID']."'><img border='0' src='email.PNG' alt='Email to a friend'></a>
! <a target='_blank' href='viewphoto.php?ID=".$_GET['ID']."&PHOTO=".$file."'><img border='0' alt='Enlarge' src='enlarge.PNG'></a>
</center></td>\n";
Index: index.php
===================================================================
RCS file: /cvsroot/openfirst/photogallery/index.php,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** index.php 1 Sep 2003 15:29:04 -0000 1.9
--- index.php 1 Sep 2003 20:10:37 -0000 1.10
***************
*** 51,55 ****
?>
<tr>
! <td width="61"><div align="center"><a href="gallery.php?ID=<?php echo $gallery->ID; ?>" style="color: #000000;"><img src="gallery.PNG" border="0"></a></div></td>
<td width="147"><a href='gallery.php?ID=<?php echo $gallery->ID; ?>' style="color: #000000;"><?php echo $gallery->GalleryName; ?></a></td>
<td width="297"><?php echo $gallery->Description; ?></td>
--- 51,55 ----
?>
<tr>
! <td width="61"><div align="center"><a href="gallery.php?ID=<?php echo $gallery->ID; ?>" style="color: #000000;"><img src="gallery.PNG" alt="Gallery" border="0"></a></div></td>
<td width="147"><a href='gallery.php?ID=<?php echo $gallery->ID; ?>' style="color: #000000;"><?php echo $gallery->GalleryName; ?></a></td>
<td width="297"><?php echo $gallery->Description; ?></td>
|
|
From: <dav...@us...> - 2003-09-01 17:44:52
|
Update of /cvsroot/openfirst/projects
In directory sc8-pr-cvs1:/tmp/cvs-serv27788
Modified Files:
today.php
Log Message:
Added member wrap spacing.
Index: today.php
===================================================================
RCS file: /cvsroot/openfirst/projects/today.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** today.php 1 Sep 2003 17:29:10 -0000 1.5
--- today.php 1 Sep 2003 17:44:48 -0000 1.6
***************
*** 151,155 ****
<td>--</td>
<td><?php echo $project->Description; ?></td>
! <td><?php echo $project->Assigned; ?></td>
</tr>
<?php
--- 151,155 ----
<td>--</td>
<td><?php echo $project->Description; ?></td>
! <td><?php echo str_replace(",", ", ",$project->Assigned); ?></td>
</tr>
<?php
***************
*** 174,178 ****
<td><font color='red'><?php echo $task->TaskName; ?></font></td>
<td><?php echo $task->Description; ?></td>
! <td><?php echo $task->Assigned; ?></td>
</tr>
<?php
--- 174,178 ----
<td><font color='red'><?php echo $task->TaskName; ?></font></td>
<td><?php echo $task->Description; ?></td>
! <td><?php echo str_replace(",", ", ",$task->Assigned); ?></td>
</tr>
<?php
|
|
From: <dav...@us...> - 2003-09-01 17:30:31
|
Update of /cvsroot/openfirst/base/images In directory sc8-pr-cvs1:/tmp/cvs-serv25008 Added Files: back-lighter.gif Log Message: New image which corresponds to the header td sub class change. --- NEW FILE: back-lighter.gif --- (This appears to be a binary file; contents omitted.) |
|
From: <dav...@us...> - 2003-09-01 17:29:48
|
Update of /cvsroot/openfirst/base/config
In directory sc8-pr-cvs1:/tmp/cvs-serv24780
Modified Files:
headers.php
Log Message:
Added td sub class.
Index: headers.php
===================================================================
RCS file: /cvsroot/openfirst/base/config/headers.php,v
retrieving revision 1.18
retrieving revision 1.19
diff -C2 -d -r1.18 -r1.19
*** headers.php 19 Aug 2003 20:48:46 -0000 1.18
--- headers.php 1 Sep 2003 17:29:45 -0000 1.19
***************
*** 41,44 ****
--- 41,45 ----
td.navigation { color: black; font-size: 12px; font-family: sans-serif; text-decoration: none; }
th { background-color: #999999; color: #333333;background-image: url('<?php echo("$basepath/images/"); ?>back-light.gif'); }
+ td.sub { background-color: #999999; color: #333333;background-image: url('<?php echo("$basepath/images/"); ?>back-lighter.gif'); }
</style>
</head>
|
|
From: <dav...@us...> - 2003-09-01 17:29:15
|
Update of /cvsroot/openfirst/projects
In directory sc8-pr-cvs1:/tmp/cvs-serv24636
Modified Files:
groups.php meetings.php mytask.php notes.php projects.php
tasks.php today.php
Log Message:
Design errors fixed. Sub headers have been added, cell highlighting on mouse over has been removed. A wrap feature has been added for member listings.
Index: groups.php
===================================================================
RCS file: /cvsroot/openfirst/projects/groups.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** groups.php 30 Aug 2003 14:42:57 -0000 1.8
--- groups.php 1 Sep 2003 17:29:10 -0000 1.9
***************
*** 113,133 ****
</th>
</table>
! <table width="100%" bordercolor="#999999">
! <tr bgcolor="#999999">
! <td width="5%"> </td>
! <td width="20%">Group Name</td>
! <td width="6%">Projects</td>
! <td width="35%">Description</td>
! <td width="9%">Moderators</td>
! <td width="25%">Members</td>
</tr>
<?php
// Query the current group values and loop through them
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups");
while($groups = ofirst_dbfetch_object($query)){
?>
! <tr <?php if(date("F j, Y",time()) == date("F j, Y",$groups->Dates)){ echo "bgColor='#CCCCCC'"; } ?> onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'" bgcolor="#ffffff">
<td>
<div align="center"><a href="projects.php?GroupID=<?php echo $groups->ID; ?>"><img src="../members/icons/apps/kuser.png" width="32" height="32" border="0"></a></div></td>
--- 113,133 ----
</th>
</table>
! <table width="100%">
! <tr>
! <td class="sub" width="5%"> </td>
! <td class="sub" width="20%">Group Name</td>
! <td class="sub" width="6%">Projects</td>
! <td class="sub" width="35%">Description</td>
! <td class="sub" width="9%">Moderators</td>
! <td class="sub" width="25%">Members</td>
</tr>
<?php
// Query the current group values and loop through them
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups GROUP BY GroupName");
while($groups = ofirst_dbfetch_object($query)){
?>
! <tr <?php if(date("F j, Y",time()) == date("F j, Y",$groups->Dates)){ echo "bgColor='#CCCCCC'"; } ?>>
<td>
<div align="center"><a href="projects.php?GroupID=<?php echo $groups->ID; ?>"><img src="../members/icons/apps/kuser.png" width="32" height="32" border="0"></a></div></td>
***************
*** 140,145 ****
</td>
<td><?php echo $groups->Description; ?></td>
! <td><?php echo $groups->Moderators; ?></td>
! <td><?php echo $groups->Members; ?> </td>
</tr>
<?php
--- 140,145 ----
</td>
<td><?php echo $groups->Description; ?></td>
! <td><?php echo str_replace(",", ", ",$groups->Moderators); ?></td>
! <td><?php echo str_replace(",", ", ",$groups->Members); ?> </td>
</tr>
<?php
Index: meetings.php
===================================================================
RCS file: /cvsroot/openfirst/projects/meetings.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** meetings.php 30 Aug 2003 14:42:57 -0000 1.5
--- meetings.php 1 Sep 2003 17:29:10 -0000 1.6
***************
*** 92,100 ****
</table>
<table width="100%">
! <tr bgcolor="#999999">
! <td width="6%"> </td>
! <td width="21%"><div align="center"><strong>Date</strong></div></td>
! <td width="52%"><div align="center"><strong>Description</strong></div></td>
! <td width="21%"><div align="center"><strong>Arranged For</strong></div></td>
</tr>
<?php
--- 92,100 ----
</table>
<table width="100%">
! <tr>
! <td class="sub" width="6%"> </td>
! <td class="sub" width="21%"><div align="center"><strong>Date</strong></div></td>
! <td class="sub" width="52%"><div align="center"><strong>Description</strong></div></td>
! <td class="sub" width="21%"><div align="center"><strong>Arranged For</strong></div></td>
</tr>
<?php
***************
*** 137,145 ****
</table>
<table width="100%">
! <tr bgcolor="#999999">
! <th width="6%"> </td>
! <th width="21%">Date</th>
! <th width="52%">Description</th>
! <th width="21%">Arranged For</th>
</tr>
<?php
--- 137,145 ----
</table>
<table width="100%">
! <tr>
! <td class="sub" width="6%"> </td>
! <td class="sub" width="21%">Date</th>
! <td class="sub" width="52%">Description</th>
! <td class="sub" width="21%">Arranged For</th>
</tr>
<?php
Index: mytask.php
===================================================================
RCS file: /cvsroot/openfirst/projects/mytask.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** mytask.php 30 Aug 2003 14:42:57 -0000 1.4
--- mytask.php 1 Sep 2003 17:29:10 -0000 1.5
***************
*** 47,57 ****
</tr>
</table>
! <table width="100%" bordercolor="#999999">
! <tr bgcolor="#999999">
! <th width="4%"> </th>
! <th width="20%">Task Name</th>
! <th width="13%">Target Date</th>
! <th width="33%">Description</th>
! <th width="30%">Assigned</th>
</tr>
<?php
--- 47,57 ----
</tr>
</table>
! <table width="100%">
! <tr>
! <td class="sub" width="4%"> </th>
! <td class="sub" width="20%">Task Name</th>
! <td class="sub" width="13%">Target Date</th>
! <td class="sub" width="33%">Description</th>
! <td class="sub" width="30%">Assigned</th>
</tr>
<?php
***************
*** 88,92 ****
}
?>
! <tr onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'" <?php if(date("F j, Y",time()) == date("F j, Y",$tasks->Dates)){ echo "bgColor='#CCCCCC'"; } ?>>
<td><a href="notes.php?GroupID=<?php echo $_GET['GroupID']; ?>&TaskID=<?php echo $tasks->ID; ?>&ProjectID=<?php echo $_GET['ProjectID']; ?>">
<?php
--- 88,92 ----
}
?>
! <tr <?php if(date("F j, Y",time()) == date("F j, Y",$tasks->Dates)){ echo "bgColor='#CCCCCC'"; } ?>>
<td><a href="notes.php?GroupID=<?php echo $_GET['GroupID']; ?>&TaskID=<?php echo $tasks->ID; ?>&ProjectID=<?php echo $_GET['ProjectID']; ?>">
<?php
Index: notes.php
===================================================================
RCS file: /cvsroot/openfirst/projects/notes.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** notes.php 30 Aug 2003 14:42:57 -0000 1.7
--- notes.php 1 Sep 2003 17:29:10 -0000 1.8
***************
*** 91,100 ****
</tr>
</table>
! <table width="100%" bordercolor="#999999">
! <tr bgcolor="#999999">
! <td width="5%"> </td>
! <td width="17%">Date</td>
! <td width="63%">Note Write Up</td>
! <td width="15%">Commiter</td>
</tr>
<?php
--- 91,100 ----
</tr>
</table>
! <table width="100%">
! <tr>
! <td class="sub" width="5%"> </td>
! <td class="sub" width="17%">Date</td>
! <td class="sub" width="63%">Note Write Up</td>
! <td class="sub" width="15%">Commiter</td>
</tr>
<?php
Index: projects.php
===================================================================
RCS file: /cvsroot/openfirst/projects/projects.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** projects.php 30 Aug 2003 14:42:57 -0000 1.8
--- projects.php 1 Sep 2003 17:29:10 -0000 1.9
***************
*** 103,118 ****
</tr>
</table>
! <table width="100%" bordercolor="#999999">
! <tr bgcolor="#999999">
! <td width="3%"> </td>
! <td width="22%">Project Name</td>
! <td width="9%">Completion</td>
! <td width="35%">Description</td>
! <td width="31%">Assigned</td>
</tr>
<?php
// List current projects in database
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."' ORDER BY GroupName;");
while($projects = ofirst_dbfetch_object($query)){
--- 103,118 ----
</tr>
</table>
! <table width="100%">
! <tr>
! <td class="sub" width="3%"> </td>
! <td class="sub" width="22%">Project Name</td>
! <td class="sub" width="9%">Completion</td>
! <td class="sub" width="35%">Description</td>
! <td class="sub" width="31%">Assigned</td>
</tr>
<?php
// List current projects in database
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."' ORDER BY ProjectName;");
while($projects = ofirst_dbfetch_object($query)){
***************
*** 134,138 ****
?>
! <tr <?php if(date("F j, Y",time()) == date("F j, Y",$projects->Dates)){ echo "bgColor='#CCCCCC'"; } ?> onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'" bgcolor="#ffffff">
<td>
<?php
--- 134,138 ----
?>
! <tr <?php if(date("F j, Y",time()) == date("F j, Y",$projects->Dates)){ echo "bgColor='#CCCCCC'"; } ?>>
<td>
<?php
***************
*** 170,174 ****
</td>
<td><?php echo $projects->Description; ?></td>
! <td><?php echo $projects->Assigned; ?></td>
</tr>
<?
--- 170,174 ----
</td>
<td><?php echo $projects->Description; ?></td>
! <td><?php echo str_replace(",", ", ",$projects->Assigned); ?></td>
</tr>
<?
Index: tasks.php
===================================================================
RCS file: /cvsroot/openfirst/projects/tasks.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** tasks.php 30 Aug 2003 14:42:57 -0000 1.8
--- tasks.php 1 Sep 2003 17:29:10 -0000 1.9
***************
*** 105,109 ****
$group = ofirst_dbfetch_object($query);
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."' AND ID = '".$_GET['ProjectID']."' ORDER BY GroupName;");
$project = ofirst_dbfetch_object($query);
--- 105,109 ----
$group = ofirst_dbfetch_object($query);
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."' AND ID = '".$_GET['ProjectID']."' ORDER BY ProjectName;");
$project = ofirst_dbfetch_object($query);
***************
*** 123,133 ****
</tr>
</table>
! <table width="100%" bordercolor="#999999">
! <tr bgcolor="#999999">
! <td width="4%"> </td>
! <td width="20%">Task Name</td>
! <td width="13%">Target Date</td>
! <td width="33%">Description</td>
! <td width="30%">Assigned</td>
</tr>
<?php
--- 123,133 ----
</tr>
</table>
! <table width="100%">
! <tr>
! <td class="sub" width="4%"> </td>
! <td class="sub" width="20%">Task Name</td>
! <td class="sub" width="13%">Target Date</td>
! <td class="sub" width="33%">Description</td>
! <td class="sub" width="30%">Assigned</td>
</tr>
<?php
***************
*** 155,159 ****
?>
! <tr onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'" <?php if(date("F j, Y",time()) == date("F j, Y",$tasks->Dates)){ echo "bgColor='#CCCCCC'"; } ?>>
<td>
<?php
--- 155,159 ----
?>
! <tr <?php if(date("F j, Y",time()) == date("F j, Y",$tasks->Dates)){ echo "bgColor='#CCCCCC'"; } ?>>
<td>
<?php
***************
*** 196,200 ****
?></td>
<td><?php echo $tasks->Description; ?></td>
! <td><?php echo $tasks->Assigned; ?></td>
</tr>
<?
--- 196,200 ----
?></td>
<td><?php echo $tasks->Description; ?></td>
! <td><?php echo str_replace(",", ", ",$tasks->Assigned); ?></td>
</tr>
<?
Index: today.php
===================================================================
RCS file: /cvsroot/openfirst/projects/today.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** today.php 30 Aug 2003 14:42:57 -0000 1.4
--- today.php 1 Sep 2003 17:29:10 -0000 1.5
***************
*** 113,122 ****
</p>
</form>
! <table width="100%" border="0" cellspacing="0" cellpadding="6">
! <tr>
! <th>
! <div align="center">Notes commited on <strong><?php echo $selectdate; ?></strong></div></th>
! </tr>
! </table>
<?php
--- 113,118 ----
</p>
</form>
! <font size="4">Notes commited on <strong><?php echo $selectdate; ?></strong></font><br>
! <br>
<?php
***************
*** 128,147 ****
<table width="100%" border="0" cellspacing="0" cellpadding="6">
<tr>
! <td bgcolor="#CCCCCC"> <div align="center"><font color="#000000"><strong><?php echo $group->GroupName; ?></strong></font></div></td>
</tr>
</table>
<table width="100%">
! <tr bgcolor="#999999">
! <td width="4%"> </td>
! <td width="14%">Change</td>
! <td width="15%">Project</td>
! <td width="14%">Task</td>
! <td width="35%">Decsription</td>
! <td width="18%">Assigned/Commiter</td>
</tr>
<?php
// Listed the newly added projects for this day
! $projectquery = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$group->ID."' ORDER BY GroupName");
while($project = ofirst_dbfetch_object($projectquery)){
--- 124,143 ----
<table width="100%" border="0" cellspacing="0" cellpadding="6">
<tr>
! <th> <div align="center"><font color="#000000"><strong><?php echo $group->GroupName; ?></strong></font></div></th>
</tr>
</table>
<table width="100%">
! <tr>
! <td class="sub" width="4%"> </td>
! <td class="sub" width="14%">Change</td>
! <td class="sub" width="15%">Project</td>
! <td class="sub" width="14%">Task</td>
! <td class="sub" width="35%">Decsription</td>
! <td class="sub" width="18%">Assigned/Commiter</td>
</tr>
<?php
// Listed the newly added projects for this day
! $projectquery = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$group->ID."' ORDER BY ProjectName");
while($project = ofirst_dbfetch_object($projectquery)){
***************
*** 149,153 ****
?>
! <tr onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'">
<td><img src="../members/icons/actions/project_open.png" width="32" height="32"></td>
<td>New Project</td>
--- 145,149 ----
?>
! <tr>
<td><img src="../members/icons/actions/project_open.png" width="32" height="32"></td>
<td>New Project</td>
***************
*** 172,176 ****
?>
! <tr onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'">
<td><img src="../members/icons/filesystems/desktop.png" width="32" height="32"></td>
<td>New Task</td>
--- 168,172 ----
?>
! <tr>
<td><img src="../members/icons/filesystems/desktop.png" width="32" height="32"></td>
<td>New Task</td>
***************
*** 198,202 ****
?>
! <tr onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'">
<td><img src="../members/icons/filesystems/files.png" width="32" height="32"></td>
<td>New Note Commited</td>
--- 194,198 ----
?>
! <tr>
<td><img src="../members/icons/filesystems/files.png" width="32" height="32"></td>
<td>New Note Commited</td>
|
|
From: <xt...@us...> - 2003-09-01 15:38:23
|
Update of /cvsroot/openfirst/base/config/functions
In directory sc8-pr-cvs1:/tmp/cvs-serv4865
Modified Files:
mail.php
Log Message:
Fix mail functions so that they can properly send messages using PHP or ASP header files, rather than requiring plain HTML headers in order to function correctly.
Index: mail.php
===================================================================
RCS file: /cvsroot/openfirst/base/config/functions/mail.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** mail.php 17 Aug 2003 16:22:44 -0000 1.2
--- mail.php 1 Sep 2003 15:38:16 -0000 1.3
***************
*** 56,59 ****
--- 56,81 ----
}
fclose($fle);
+ // Strip the PHP tags from the header.
+ while(stristr($fheader,"<?")) {
+ $fheader = str_replace(substr($fheader, strpos($fheader, "<?"), strpos($fheader, "?>") - strpos($fheader, "<?") + 2), "", $fheader);
+ }
+ while(stristr($ffooter,"<?")) {
+ $ffooter = str_replace(substr($ffooter, strpos($ffooter, "<?"), strpos($ffooter, "?>") - strpos($ffooter, "<?") + 2), "", $ffooter);
+ }
+ // Strip the ASP tags from the header.
+
+ while(stristr($fheader,"<%")) {
+ $fheader = str_replace(substr($fheader, strpos($fheader, "<%"), strpos($fheader, "%>") - strpos($fheader, "<%") + 2), "", $fheader);
+ }
+ while(stristr($ffooter,"<%")) {
+ $ffooter = str_replace(substr($ffooter, strpos($ffooter, "<%"), strpos($ffooter, "%>") - strpos($ffooter, "<%") + 2), "", $ffooter);
+ }
+ $fheader = str_replace("src=\"/", "src=\"http://" . $_SERVER["SERVER_NAME"] . "/" . $basepath, $fheader);
+ $fheader = str_replace("src='/", "src=\"http://" . $_SERVER["SERVER_NAME"] . "/" . $basepath, $fheader);
+ $fheader = str_replace("src=/", "src=\"http://" . $_SERVER["SERVER_NAME"] . "/" . $basepath, $fheader);
+ $ffooter = str_replace("src=\"/", "src=\"http://" . $_SERVER["SERVER_NAME"] . "/" . $basepath, $ffooter);
+ $ffooter = str_replace("src='/", "src=\"http://" . $_SERVER["SERVER_NAME"] . "/" . $basepath, $ffooter);
+ $ffooter = str_replace("src=/", "src=\"http://" . $_SERVER["SERVER_NAME"] . "/" . $basepath, $ffooter);
+
$info .= ("$fheader<pre>$message</pre>$ffooter");
return(mail($to, $subject, $info, $headers));
|
|
From: <dav...@us...> - 2003-09-01 15:29:07
|
Update of /cvsroot/openfirst/photogallery
In directory sc8-pr-cvs1:/tmp/cvs-serv3375
Modified Files:
gallery.php index.php
Log Message:
Removed some design flaws.
Index: gallery.php
===================================================================
RCS file: /cvsroot/openfirst/photogallery/gallery.php,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** gallery.php 23 Aug 2003 20:32:49 -0000 1.10
--- gallery.php 1 Sep 2003 15:29:03 -0000 1.11
***************
*** 95,99 ****
// Add e-mail and image expand buttons as well as close column
echo "</a><br><a href='email.php?PHOTO=$file&ID=".$_GET['ID']."'><img border='0' src=email.PNG alt='Email to a friend'></a>
! <img border='0' src='spacer.PNG'><a target='_blank' href='viewphoto.php?ID=".$_GET['ID']."&PHOTO=".$file."'><img border='0' alt='Enlarge' src='enlarge.PNG'></a>
</center></td>\n";
--- 95,99 ----
// Add e-mail and image expand buttons as well as close column
echo "</a><br><a href='email.php?PHOTO=$file&ID=".$_GET['ID']."'><img border='0' src=email.PNG alt='Email to a friend'></a>
! <a target='_blank' href='viewphoto.php?ID=".$_GET['ID']."&PHOTO=".$file."'><img border='0' alt='Enlarge' src='enlarge.PNG'></a>
</center></td>\n";
Index: index.php
===================================================================
RCS file: /cvsroot/openfirst/photogallery/index.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** index.php 26 Aug 2003 03:28:22 -0000 1.8
--- index.php 1 Sep 2003 15:29:04 -0000 1.9
***************
*** 50,54 ****
?>
! <tr onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'" bgcolor="#ffffff" style="color: #000000;">
<td width="61"><div align="center"><a href="gallery.php?ID=<?php echo $gallery->ID; ?>" style="color: #000000;"><img src="gallery.PNG" border="0"></a></div></td>
<td width="147"><a href='gallery.php?ID=<?php echo $gallery->ID; ?>' style="color: #000000;"><?php echo $gallery->GalleryName; ?></a></td>
--- 50,54 ----
?>
! <tr>
<td width="61"><div align="center"><a href="gallery.php?ID=<?php echo $gallery->ID; ?>" style="color: #000000;"><img src="gallery.PNG" border="0"></a></div></td>
<td width="147"><a href='gallery.php?ID=<?php echo $gallery->ID; ?>' style="color: #000000;"><?php echo $gallery->GalleryName; ?></a></td>
|
|
From: <xt...@us...> - 2003-08-30 18:26:15
|
Update of /cvsroot/openfirst/base/config
In directory sc8-pr-cvs1:/tmp/cvs-serv23017
Modified Files:
index.php
Log Message:
Add version checking ability to base module
Index: index.php
===================================================================
RCS file: /cvsroot/openfirst/base/config/index.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** index.php 28 Jun 2003 17:29:29 -0000 1.4
--- index.php 30 Aug 2003 18:26:07 -0000 1.5
***************
*** 33,36 ****
--- 33,38 ----
?>
<h1>OpenFIRST Configuration Area</h1>
+ <p><a href="version.php">Version Check</a> - ensure that your version of the openFIRST web portal
+ software and any 3rd party extensions is up to date</p>
<p><a href="install.php">Install Component</a> - required to install several new
openFIRST modules.</p>
***************
*** 42,44 ****
}
include($footer);
! ?>
\ No newline at end of file
--- 44,46 ----
}
include($footer);
! ?>
|
|
From: <xt...@us...> - 2003-08-30 18:25:05
|
Update of /cvsroot/openfirst/base/config
In directory sc8-pr-cvs1:/tmp/cvs-serv22847
Added Files:
version.php
Log Message:
Add version checking ability to config module
--- NEW FILE: version.php ---
<?php
/*
* openFIRST.base - config/version.php
*
* Copyright (C) 2003,
* openFIRST Project
* Original Author: Tim Ginn <tim...@po...>
*
* 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.
* 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
*
*/
// Purpose: set up OpenFIRST modules
include("../config/globals.php");
include($header);
if(isset($user->user) == true && $user->membertype == "administrator") {
?>
<h1>Version Information</h1>
<p>The version as displayed on your pages is <?php echo $title . " " . $version; ?></p>
<table>
<tr><th>Status</th><th>File</th><th>Module</th><th>Description</th><th>Link</th></tr>
<?php
if(function_exists("glob")) {
foreach (glob("../*/*/*/*/*/*/*") as $filename) {
if(is_file($filename)) {
$mod = str_replace("../", "", $filename);
$mod = substr($mod, 0, strpos($mod, "/", 2));
$fil = str_replace("../$mod/", "", $filename);
@include("http://update.openfirst.org/versions.php?md5=" . md5_file($filename) . "&module=$mod&file=$fil");
}
}
foreach (glob("../*/*/*/*/*/*") as $filename) {
if(is_file($filename)) {
$mod = str_replace("../", "", $filename);
$mod = substr($mod, 0, strpos($mod, "/", 2));
$fil = str_replace("../$mod/", "", $filename);
@include("http://update.openfirst.org/versions.php?md5=" . md5_file($filename) . "&module=$mod&file=$fil");
}
}
foreach (glob("../*/*/*/*/*") as $filename) {
if(is_file($filename)) {
$mod = str_replace("../", "", $filename);
$mod = substr($mod, 0, strpos($mod, "/", 2));
$fil = str_replace("../$mod/", "", $filename);
@include("http://update.openfirst.org/versions.php?md5=" . md5_file($filename) . "&module=$mod&file=$fil");
}
}
foreach (glob("../*/*/*/*") as $filename) {
if(is_file($filename)) {
$mod = str_replace("../", "", $filename);
$mod = substr($mod, 0, strpos($mod, "/", 2));
$fil = str_replace("../$mod/", "", $filename);
@include("http://update.openfirst.org/versions.php?md5=" . md5_file($filename) . "&module=$mod&file=$fil");
}
}
foreach (glob("../*/*/*") as $filename) {
if(is_file($filename)) {
$mod = str_replace("../", "", $filename);
$mod = substr($mod, 0, strpos($mod, "/", 2));
$fil = str_replace("../$mod/", "", $filename);
@include("http://update.openfirst.org/versions.php?md5=" . md5_file($filename) . "&module=$mod&file=$fil");
}
}
foreach (glob("../*") as $filename) {
if(is_file($filename)) {
$mod = str_replace("../", "", $filename);
$mod = substr($mod, 0, strpos($mod, "/", 2));
$fil = str_replace("../$mod/", "", $filename);
@include("http://update.openfirst.org/versions.php?md5=" . md5_file($filename) . "&module=$mod&file=$fil");
}
}
} else {
echo("<p>The version information requires the <strong>glob</strong> function, which your version
of PHP does not have. In the future there will be version for systems without
<strong>glob</strong> glob functionality, but at the moment only a <strong>glob</strong>
version is provided.</p>");
}
?>
</table>
<?php } else {
showlogin();
}
include($footer); ?>
|
|
From: <dav...@us...> - 2003-08-30 16:23:13
|
Update of /cvsroot/openfirst/projects
In directory sc8-pr-cvs1:/tmp/cvs-serv4559
Modified Files:
updates.php
Log Message:
Added checking to see if user wants the email or not.
Index: updates.php
===================================================================
RCS file: /cvsroot/openfirst/projects/updates.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** updates.php 30 Aug 2003 16:21:33 -0000 1.4
--- updates.php 30 Aug 2003 16:23:07 -0000 1.5
***************
*** 37,40 ****
--- 37,44 ----
}
+ if($mailgroup->ProjectsUpdates == "Off"){
+ continue;
+ }
+
$message = "";
|
|
From: <dav...@us...> - 2003-08-30 16:21:36
|
Update of /cvsroot/openfirst/projects In directory sc8-pr-cvs1:/tmp/cvs-serv4362 Added Files: updates.php Log Message: New updates file without extra features. |
|
From: <dav...@us...> - 2003-08-30 15:24:05
|
Update of /cvsroot/openfirst/projects/setup In directory sc8-pr-cvs1:/tmp/cvs-serv28088 Modified Files: setup.mysql Log Message: Values is not supposed to be set as off, rather should be set as No. Index: setup.mysql =================================================================== RCS file: /cvsroot/openfirst/projects/setup/setup.mysql,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** setup.mysql 30 Aug 2003 15:18:33 -0000 1.2 --- setup.mysql 30 Aug 2003 15:24:01 -0000 1.3 *************** *** 5,9 **** CREATE TABLE `ofirst_projects_tasks` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `TaskName` text, `ProjectID` tinytext, `GroupID` tinytext, `DateAssigned` text, `TarDate` text, `Description` text, `Assigned` text, `Dates` text, `Completion` tinytext, `Pend` text, PRIMARY KEY (`ID`)) TYPE=MyISAM; INSERT INTO ofirst_config SET includes='',modulename='projects',showonmenu='0',active='0',modulenavigation='<a href="$basepath/projects/groups.php">Action Register</a> | <a href="$basepath/projects/mytask.php">My Tasks</a> | <a href="$basepath/projects/preferences.php">Preferences</a> | <a href="$basepath/projects/meetings.php">Meetings</a> | <a href="$basepath/projects/today.php">Todays Changes</a>'; ! ALTER TABLE ofirst_members ADD COLUMN ProjectsUpdates tinytext unsigned default 'Off' ALTER TABLE ofirst_members ADD COLUMN ProjectsCommitSelect tinytext ALTER TABLE ofirst_members ADD COLUMN ProjectsSendTemplate tinytext --- 5,9 ---- CREATE TABLE `ofirst_projects_tasks` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `TaskName` text, `ProjectID` tinytext, `GroupID` tinytext, `DateAssigned` text, `TarDate` text, `Description` text, `Assigned` text, `Dates` text, `Completion` tinytext, `Pend` text, PRIMARY KEY (`ID`)) TYPE=MyISAM; INSERT INTO ofirst_config SET includes='',modulename='projects',showonmenu='0',active='0',modulenavigation='<a href="$basepath/projects/groups.php">Action Register</a> | <a href="$basepath/projects/mytask.php">My Tasks</a> | <a href="$basepath/projects/preferences.php">Preferences</a> | <a href="$basepath/projects/meetings.php">Meetings</a> | <a href="$basepath/projects/today.php">Todays Changes</a>'; ! ALTER TABLE ofirst_members ADD COLUMN ProjectsUpdates tinytext unsigned default 'No' ALTER TABLE ofirst_members ADD COLUMN ProjectsCommitSelect tinytext ALTER TABLE ofirst_members ADD COLUMN ProjectsSendTemplate tinytext |
|
From: <dav...@us...> - 2003-08-30 15:18:37
|
Update of /cvsroot/openfirst/projects/setup In directory sc8-pr-cvs1:/tmp/cvs-serv26958 Modified Files: setup.mysql Log Message: Removed a few commands and set ProjectsUpdates with default of off for updates. Index: setup.mysql =================================================================== RCS file: /cvsroot/openfirst/projects/setup/setup.mysql,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** setup.mysql 27 Aug 2003 12:58:29 -0000 1.1 --- setup.mysql 30 Aug 2003 15:18:33 -0000 1.2 *************** *** 5,10 **** CREATE TABLE `ofirst_projects_tasks` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `TaskName` text, `ProjectID` tinytext, `GroupID` tinytext, `DateAssigned` text, `TarDate` text, `Description` text, `Assigned` text, `Dates` text, `Completion` tinytext, `Pend` text, PRIMARY KEY (`ID`)) TYPE=MyISAM; INSERT INTO ofirst_config SET includes='',modulename='projects',showonmenu='0',active='0',modulenavigation='<a href="$basepath/projects/groups.php">Action Register</a> | <a href="$basepath/projects/mytask.php">My Tasks</a> | <a href="$basepath/projects/preferences.php">Preferences</a> | <a href="$basepath/projects/meetings.php">Meetings</a> | <a href="$basepath/projects/today.php">Todays Changes</a>'; ! ALTER TABLE ofirst_members ADD COLUMN ProjectsFrequency tinytext ! ALTER TABLE ofirst_members ADD COLUMN ProjectsSendCountDown tinytext ALTER TABLE ofirst_members ADD COLUMN ProjectsCommitSelect tinytext ALTER TABLE ofirst_members ADD COLUMN ProjectsSendTemplate tinytext --- 5,9 ---- CREATE TABLE `ofirst_projects_tasks` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `TaskName` text, `ProjectID` tinytext, `GroupID` tinytext, `DateAssigned` text, `TarDate` text, `Description` text, `Assigned` text, `Dates` text, `Completion` tinytext, `Pend` text, PRIMARY KEY (`ID`)) TYPE=MyISAM; INSERT INTO ofirst_config SET includes='',modulename='projects',showonmenu='0',active='0',modulenavigation='<a href="$basepath/projects/groups.php">Action Register</a> | <a href="$basepath/projects/mytask.php">My Tasks</a> | <a href="$basepath/projects/preferences.php">Preferences</a> | <a href="$basepath/projects/meetings.php">Meetings</a> | <a href="$basepath/projects/today.php">Todays Changes</a>'; ! ALTER TABLE ofirst_members ADD COLUMN ProjectsUpdates tinytext unsigned default 'Off' ALTER TABLE ofirst_members ADD COLUMN ProjectsCommitSelect tinytext ALTER TABLE ofirst_members ADD COLUMN ProjectsSendTemplate tinytext |
Update of /cvsroot/openfirst/projects
In directory sc8-pr-cvs1:/tmp/cvs-serv20649
Modified Files:
groups.php index.php meetings.php mytask.php notes.php
preferences.php projects.php tasks.php today.php
viewmeeting.php
Log Message:
Fix whitespace errors
Index: groups.php
===================================================================
RCS file: /cvsroot/openfirst/projects/groups.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** groups.php 30 Aug 2003 00:17:53 -0000 1.7
--- groups.php 30 Aug 2003 14:42:57 -0000 1.8
***************
*** 32,106 ****
include($header);
!
// Check if user is a member
! if(! ISSET($user->user)){
! showlogin();
! }else{
!
// Create button process
! if(ISSET($_POST['create'])){
!
// Check if any assigned members have been added
! if(! ISSET($_POST['members'])){
! echo "<br><br>You must assign users to this task! Click back to continue.<br><br><br>";
! die(include($footer));
}
!
// Check if any assigned moderators have been added
! if(! ISSET($_POST['moderators'])){
! echo "<br><br>You must assign users to this task! Click back to continue.<br><br><br>";
! die(include($footer));
! }
! // Check if the value has come as a single value or array then use appropriate value in modera variable
! if(is_array($_POST['moderators'])){
! $modera = implode(",",$_POST['moderators']);
! }else{
! $modera = $_POST['moderators'];
! }
! // Check if the value has come as a single value or array then use appropriate value in mem variable
! if(is_array($_POST['members'])){
! $mem = implode(",",$_POST['members']);
! }else{
! $mem = $_POST['members'];
! }
// Insert data into the database
ofirst_dbquery("INSERT INTO ofirst_projects_groups SET
! GroupName = '".$_POST['groupname']."',
! Description = '".$_POST['description']."',
! Moderators = '$modera',
! Members = '$mem',
! Dates = '".time()."'") or die(ofirst_dberror());
! echo "<br><br>Group created! [ <a href='groups.php'>Groups</a> ]<br><br>";
! die(include($footer));
}
!
// Remove button process
! if(ISSET($_POST['remove'])){
!
// If the confirmation button is selected then remove all group data
! if(! ISSET($_POST['confirm'])){
echo "<br><br>Your request to remove the group was denied because you have not confirmed! [ <a href='groups.php'>Groups</a> ]<br><br>";
die(include($footer));
}
!
// Remove data from every table that is related
ofirst_dbquery("DELETE FROM ofirst_projects_groups WHERE ID = '".$_POST['group']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_notes WHERE GroupID = '".$_POST['group']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_tasks WHERE GroupID = '".$_POST['group']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_projects WHERE GroupID = '".$_POST['group']."'") or die(ofirst_dberror());
- echo "<br><br>Group removed! [ <a href='groups.php'>Groups</a> ]<br><br>";
- die(include($footer));
-
}
?>
! <h2>System Work Groups</h2>
<table width="540">
! <tr>
! <td width="0" height="0"> <div align="left"><em>Location:</em> <a href="groups.php"><strong>Groups</strong></a>
/ </div></td>
</tr>
--- 32,106 ----
include($header);
!
// Check if user is a member
! if(! isset($user->user)){
! showlogin();
! } else {
!
// Create button process
! if(isset($_POST['create'])){
!
// Check if any assigned members have been added
! if(! isset($_POST['members'])){
! echo "<br><br>You must assign users to this task! Click back to continue.<br><br><br>";
! die(include($footer));
}
!
// Check if any assigned moderators have been added
! if(! isset($_POST['moderators'])){
! echo "<br><br>You must assign users to this task! Click back to continue.<br><br><br>";
! die(include($footer));
! }
! // Check if the value has come as a single value or array then use appropriate value in modera variable
! if(is_array($_POST['moderators'])){
! $modera = implode(",",$_POST['moderators']);
! } else {
! $modera = $_POST['moderators'];
! }
! // Check if the value has come as a single value or array then use appropriate value in mem variable
! if(is_array($_POST['members'])){
! $mem = implode(",",$_POST['members']);
! } else {
! $mem = $_POST['members'];
! }
// Insert data into the database
ofirst_dbquery("INSERT INTO ofirst_projects_groups SET
! GroupName = '".$_POST['groupname']."',
! Description = '".$_POST['description']."',
! Moderators = '$modera',
! Members = '$mem',
! Dates = '".time()."'") or die(ofirst_dberror());
! echo "<br><br>Group created! [ <a href='groups.php'>Groups</a> ]<br><br>";
! die(include($footer));
}
!
// Remove button process
! if(isset($_POST['remove'])){
!
// If the confirmation button is selected then remove all group data
! if(! isset($_POST['confirm'])){
echo "<br><br>Your request to remove the group was denied because you have not confirmed! [ <a href='groups.php'>Groups</a> ]<br><br>";
die(include($footer));
}
!
// Remove data from every table that is related
ofirst_dbquery("DELETE FROM ofirst_projects_groups WHERE ID = '".$_POST['group']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_notes WHERE GroupID = '".$_POST['group']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_tasks WHERE GroupID = '".$_POST['group']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_projects WHERE GroupID = '".$_POST['group']."'") or die(ofirst_dberror());
!
! echo "<br><br>Group removed! [ <a href='groups.php'>Groups</a> ]<br><br>";
! die(include($footer));
}
?>
! <h2>System Work Groups</h2>
<table width="540">
! <tr>
! <td width="0" height="0"> <div align="left"><em>Location:</em> <a href="groups.php"><strong>Groups</strong></a>
/ </div></td>
</tr>
***************
*** 108,118 ****
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="6">
! <tr>
! <th>
Groups Listings
</th>
</table>
<table width="100%" bordercolor="#999999">
! <tr bgcolor="#999999">
<td width="5%"> </td>
<td width="20%">Group Name</td>
--- 108,118 ----
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="6">
! <tr>
! <th>
Groups Listings
</th>
</table>
<table width="100%" bordercolor="#999999">
! <tr bgcolor="#999999">
<td width="5%"> </td>
<td width="20%">Group Name</td>
***************
*** 123,127 ****
</tr>
<?php
!
// Query the current group values and loop through them
$query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups");
--- 123,127 ----
</tr>
<?php
!
// Query the current group values and loop through them
$query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups");
***************
*** 129,152 ****
?>
! <tr <?php if(date("F j, Y",time()) == date("F j, Y",$groups->Dates)){ echo "bgColor='#CCCCCC'"; } ?> onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'" bgcolor="#ffffff">
! <td>
<div align="center"><a href="projects.php?GroupID=<?php echo $groups->ID; ?>"><img src="../members/icons/apps/kuser.png" width="32" height="32" border="0"></a></div></td>
<td><?php echo $groups->GroupName; ?></td>
<td>
! <?php
! $projquery = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$groups->ID."'");
! echo ofirst_dbnum_rows($projquery);
! ?>
! </td>
<td><?php echo $groups->Description; ?></td>
! <td><?php echo $groups->Moderators; ?></td>
<td><?php echo $groups->Members; ?> </td>
</tr>
<?php
! }
! if(ofirst_dbnum_rows($query) == 0){
! echo "<tr><td>--</td><td>--</td><td>--</td><td><center>No group has been found!</center></td><td>--</td><td>--</td>";
! }
?>
--- 129,152 ----
?>
! <tr <?php if(date("F j, Y",time()) == date("F j, Y",$groups->Dates)){ echo "bgColor='#CCCCCC'"; } ?> onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'" bgcolor="#ffffff">
! <td>
<div align="center"><a href="projects.php?GroupID=<?php echo $groups->ID; ?>"><img src="../members/icons/apps/kuser.png" width="32" height="32" border="0"></a></div></td>
<td><?php echo $groups->GroupName; ?></td>
<td>
! <?php
! $projquery = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$groups->ID."'");
! echo ofirst_dbnum_rows($projquery);
! ?>
! </td>
<td><?php echo $groups->Description; ?></td>
! <td><?php echo $groups->Moderators; ?></td>
<td><?php echo $groups->Members; ?> </td>
</tr>
<?php
! }
! if(ofirst_dbnum_rows($query) == 0){
! echo "<tr><td>--</td><td>--</td><td>--</td><td><center>No group has been found!</center></td><td>--</td><td>--</td>";
! }
?>
***************
*** 155,204 ****
<form action='groups.php' method='POST'>
<table width="39%">
! <tr>
<th> </th>
<th>Add New Group</th>
</tr>
! <tr>
<td width="19%"><div align="right">Group Name:</div></td>
<td width="31%"><input name="groupname" type="text" id="groupname"></td>
</tr>
! <tr>
<td><div align="right">Description:</div></td>
<td><textarea name="description" id="description"></textarea></td>
</tr>
! <tr>
<td><div align="right">Moderators:</div></td>
<td><select name="moderators[]" size="6" multiple="multiple" style="width: 250px;">
<?php
! $query = ofirst_dbquery("SELECT * FROM ofirst_members ORDER BY user;");
! while($members = ofirst_dbfetch_object($query)){
! echo "<option>".$members->user."</option>";
! }
! ?>
</select></td>
</tr>
! <tr>
<td valign="top">
<div align="right">Members:</div></td>
<td><select name="members[]" size="6" multiple="multiple" style="width: 250px;">
<?php
! $query = ofirst_dbquery("SELECT * FROM ofirst_members ORDER BY user;");
! while($members = ofirst_dbfetch_object($query)){
! echo "<option>".$members->user."</option>";
! }
! ?>
</select>
! </td>
</tr>
! <tr>
<td> </td>
! <td><input name="create" type="submit" id="create2" value="Create Group">
<input type="reset" name="Reset" value="Reset"> </td>
</tr>
! <tr>
<th> </th>
<th>Remove Group</th>
</tr>
! <tr>
<td><div align="right">Group Name:</div></td>
<td><select name="group" size="1" id="group">
--- 155,204 ----
<form action='groups.php' method='POST'>
<table width="39%">
! <tr>
<th> </th>
<th>Add New Group</th>
</tr>
! <tr>
<td width="19%"><div align="right">Group Name:</div></td>
<td width="31%"><input name="groupname" type="text" id="groupname"></td>
</tr>
! <tr>
<td><div align="right">Description:</div></td>
<td><textarea name="description" id="description"></textarea></td>
</tr>
! <tr>
<td><div align="right">Moderators:</div></td>
<td><select name="moderators[]" size="6" multiple="multiple" style="width: 250px;">
<?php
! $query = ofirst_dbquery("SELECT * FROM ofirst_members ORDER BY user;");
! while($members = ofirst_dbfetch_object($query)){
! echo "<option>".$members->user."</option>";
! }
! ?>
</select></td>
</tr>
! <tr>
<td valign="top">
<div align="right">Members:</div></td>
<td><select name="members[]" size="6" multiple="multiple" style="width: 250px;">
<?php
! $query = ofirst_dbquery("SELECT * FROM ofirst_members ORDER BY user;");
! while($members = ofirst_dbfetch_object($query)){
! echo "<option>".$members->user."</option>";
! }
! ?>
</select>
! </td>
</tr>
! <tr>
<td> </td>
! <td><input name="create" type="submit" id="create2" value="Create Group">
<input type="reset" name="Reset" value="Reset"> </td>
</tr>
! <tr>
<th> </th>
<th>Remove Group</th>
</tr>
! <tr>
<td><div align="right">Group Name:</div></td>
<td><select name="group" size="1" id="group">
***************
*** 208,222 ****
while($groups = ofirst_dbfetch_object($query)){
! echo "<option value='".$groups->ID."'>".$groups->GroupName."</option>";
! }
! ?>
</select></td>
</tr>
! <tr>
<td><div align="right">
<input name="confirm" type="checkbox" id="confirm" value="checkbox">
</div></td>
! <td>Click here to confirm the removal of this group. Without checking the
group will not be removed.</td>
</tr>
--- 208,222 ----
while($groups = ofirst_dbfetch_object($query)){
! echo "<option value='".$groups->ID."'>".$groups->GroupName."</option>";
! }
! ?>
</select></td>
</tr>
! <tr>
<td><div align="right">
<input name="confirm" type="checkbox" id="confirm" value="checkbox">
</div></td>
! <td>Click here to confirm the removal of this group. Without checking the
group will not be removed.</td>
</tr>
***************
*** 227,229 ****
</table>
</form>
! <?php } include($footer); ?>
--- 227,229 ----
</table>
</form>
! <?php } include($footer); ?>
Index: index.php
===================================================================
RCS file: /cvsroot/openfirst/projects/index.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** index.php 30 Aug 2003 00:08:03 -0000 1.8
--- index.php 30 Aug 2003 14:42:57 -0000 1.9
***************
*** 32,47 ****
include($header);
! if(! ISSET($user->user)){
?>
<p> </p>
! <p>Welcome to the projects module! Only team members are able to access the projects
module.<br>
Please use the login form below this:</p>
<?php
! showlogin();
! }else{
echo "<p> </p><p>Welcome ".$user->user.", thank you for logging in!<br><br>";
}
include($footer);
! ?>
--- 32,47 ----
include($header);
! if(! isset($user->user)){
?>
<p> </p>
! <p>Welcome to the projects module! Only team members are able to access the projects
module.<br>
Please use the login form below this:</p>
<?php
! showlogin();
! } else {
echo "<p> </p><p>Welcome ".$user->user.", thank you for logging in!<br><br>";
}
include($footer);
! ?>
\ No newline at end of file
Index: meetings.php
===================================================================
RCS file: /cvsroot/openfirst/projects/meetings.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** meetings.php 30 Aug 2003 00:17:53 -0000 1.4
--- meetings.php 30 Aug 2003 14:42:57 -0000 1.5
***************
*** 31,96 ****
$header_condense = true;
include($header);
!
// Check if user is a member
! if(! ISSET($user->user)){
! showlogin();
! }else{
!
// Create button process
! if(ISSET($_POST['create'])){
!
! // Check if members have been assigned to the meeting
! if(! ISSET($_POST['assign'])){
! echo "<br><br>You must assign an arranged for field to this meeting! Click back to continue.<br><br><br>";
! die(include($footer));
! }
// Check if assign is a single value or array then give variable a value
if(is_array($_POST['assign'])){
! $assign = implode(",",$_POST['assign']);
! }else{
! $assign = $_POST['assign'];
! }
// Collect date and combine it
$fordate = strtotime($_POST['month']." ".$_POST['day'].",".$_POST['year']." ".$_POST['hour'].":".$_POST['minute']." ".$_POST['ampm']);
!
// Put value into database
ofirst_dbquery("INSERT INTO ofirst_projects_meetings SET
! ForDate = '".$fordate."',
! Description = '".$_POST['description']."',
! ArrangedFor = '".$assign."',
! AbsentList = 'none',
! Status = 'wait',
! Dates = '".time()."'") or die(ofirst_dberror());
! echo "<br><br>Meeting created! [ <a href='meetings.php'>Meetings</a> ]<br><br>";
! die(include($footer));
}
!
// Remove button process
! if(ISSET($_POST['remove'])){
!
! // If remove process is confirmed
! if(! ISSET($_POST['confirm'])){
! echo "<br><br>Your request to remove the project was denied because you have not confirmed! [ <a href='projects.php?GroupID=".$_GET['GroupID']."'>Projects</a> ]<br><br>";
! die(include($footer));
! }
!
! // Remove meeting information
ofirst_dbquery("DELETE FROM ofirst_projects_meetings WHERE ID = '".$_POST['project']."'") or die(ofirst_dberror());
! echo "<br><br>Meetings removed! [ <a href='meetings.php'>Meetings</a> ]<br><br>";
! die(include($footer));
!
}
! ?>
<h2><font face="Verdana, Arial, Helvetica, sans-serif"> Meetings Organizer</font></h2>
<table width="100%">
! <tr>
<th>Upcoming Meetings</th>
</tr>
</table>
<table width="100%">
! <tr bgcolor="#999999">
<td width="6%"> </td>
<td width="21%"><div align="center"><strong>Date</strong></div></td>
--- 31,96 ----
$header_condense = true;
include($header);
!
// Check if user is a member
! if(! isset($user->user)){
! showlogin();
! } else {
!
// Create button process
! if(isset($_POST['create'])){
!
! // Check if members have been assigned to the meeting
! if(! isset($_POST['assign'])){
! echo "<br><br>You must assign an arranged for field to this meeting! Click back to continue.<br><br><br>";
! die(include($footer));
! }
// Check if assign is a single value or array then give variable a value
if(is_array($_POST['assign'])){
! $assign = implode(",",$_POST['assign']);
! } else {
! $assign = $_POST['assign'];
! }
// Collect date and combine it
$fordate = strtotime($_POST['month']." ".$_POST['day'].",".$_POST['year']." ".$_POST['hour'].":".$_POST['minute']." ".$_POST['ampm']);
!
// Put value into database
ofirst_dbquery("INSERT INTO ofirst_projects_meetings SET
! ForDate = '".$fordate."',
! Description = '".$_POST['description']."',
! ArrangedFor = '".$assign."',
! AbsentList = 'none',
! Status = 'wait',
! Dates = '".time()."'") or die(ofirst_dberror());
! echo "<br><br>Meeting created! [ <a href='meetings.php'>Meetings</a> ]<br><br>";
! die(include($footer));
}
!
// Remove button process
! if(isset($_POST['remove'])){
!
! // If remove process is confirmed
! if(! isset($_POST['confirm'])){
! echo "<br><br>Your request to remove the project was denied because you have not confirmed! [ <a href='projects.php?GroupID=".$_GET['GroupID']."'>Projects</a> ]<br><br>";
! die(include($footer));
! }
!
! // Remove meeting information
ofirst_dbquery("DELETE FROM ofirst_projects_meetings WHERE ID = '".$_POST['project']."'") or die(ofirst_dberror());
! echo "<br><br>Meetings removed! [ <a href='meetings.php'>Meetings</a> ]<br><br>";
! die(include($footer));
!
}
! ?>
<h2><font face="Verdana, Arial, Helvetica, sans-serif"> Meetings Organizer</font></h2>
<table width="100%">
! <tr>
<th>Upcoming Meetings</th>
</tr>
</table>
<table width="100%">
! <tr bgcolor="#999999">
<td width="6%"> </td>
<td width="21%"><div align="center"><strong>Date</strong></div></td>
***************
*** 99,103 ****
</tr>
<?php
!
// Check for meetings that have not passed yet
$meetquery = ofirst_dbquery("SELECT * FROM ofirst_projects_meetings WHERE Status='wait'");
--- 99,103 ----
</tr>
<?php
!
// Check for meetings that have not passed yet
$meetquery = ofirst_dbquery("SELECT * FROM ofirst_projects_meetings WHERE Status='wait'");
***************
*** 105,127 ****
?>
! <tr>
<td><div align="center"><a href="viewmeeting.php?ID=<?php echo $meeting->ID; ?>"><img src="../members/icons/apps/date.png" width="32" height="32" border="0"></a></div></td>
<td><?php echo date("F j, Y",$meeting->ForDate); ?></td>
<td><?php echo $meeting->Description; ?></td>
<td>
! <?php
! $assign = explode(",",$meeting->ArrangedFor);
! foreach($assign as $assign){
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$assign."'");
! $group = ofirst_dbfetch_object($query);
! echo "<br>".$group->GroupName;
! }
! ?>
! </td>
</tr>
<?php
}
!
// If there are no values then output a no value message
if(ofirst_dbnum_rows($meetquery) == 0){
--- 105,127 ----
?>
! <tr>
<td><div align="center"><a href="viewmeeting.php?ID=<?php echo $meeting->ID; ?>"><img src="../members/icons/apps/date.png" width="32" height="32" border="0"></a></div></td>
<td><?php echo date("F j, Y",$meeting->ForDate); ?></td>
<td><?php echo $meeting->Description; ?></td>
<td>
! <?php
! $assign = explode(",",$meeting->ArrangedFor);
! foreach($assign as $assign){
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$assign."'");
! $group = ofirst_dbfetch_object($query);
! echo "<br>".$group->GroupName;
! }
! ?>
! </td>
</tr>
<?php
}
!
// If there are no values then output a no value message
if(ofirst_dbnum_rows($meetquery) == 0){
***************
*** 132,148 ****
</table>
<table width="100%">
! <tr>
<th>Past Meetings</th>
</tr>
</table>
<table width="100%">
! <tr bgcolor="#999999">
! <td width="6%"> </td>
! <td width="21%"><div align="center"><strong>Date</strong></div></td>
! <td width="52%"><div align="center"><strong>Description</strong></div></td>
! <td width="21%"><div align="center"><strong>Arranged For</strong></div></td>
</tr>
<?php
!
// Check for passed meetings and preview them
$query = ofirst_dbquery("SELECT * FROM ofirst_projects_meetings WHERE Status='done'");
--- 132,148 ----
</table>
<table width="100%">
! <tr>
<th>Past Meetings</th>
</tr>
</table>
<table width="100%">
! <tr bgcolor="#999999">
! <th width="6%"> </td>
! <th width="21%">Date</th>
! <th width="52%">Description</th>
! <th width="21%">Arranged For</th>
</tr>
<?php
!
// Check for passed meetings and preview them
$query = ofirst_dbquery("SELECT * FROM ofirst_projects_meetings WHERE Status='done'");
***************
*** 150,172 ****
?>
! <tr>
<td><div align="center"><a href="viewmeeting.php?ID=<?php echo $meeting->ID; ?>"><img src="../members/icons/apps/date.png" width="32" height="32" border="0"></a></div></td>
<td><?php echo date("F j, Y",$meeting->ForDate); ?></td>
<td><?php echo $meeting->Description; ?></td>
<td>
! <?php
! $assign = explode(",",$meeting->ArrangedFor);
! foreach($assign as $assign){
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$assign."'");
! $group = ofirst_dbfetch_object($query);
! echo $group->GroupName;
! }
! ?>
! </td>
</tr>
<?php
}
!
// If there are no values then output a message
if(ofirst_dbnum_rows($query) == 0){
--- 150,172 ----
?>
! <tr>
<td><div align="center"><a href="viewmeeting.php?ID=<?php echo $meeting->ID; ?>"><img src="../members/icons/apps/date.png" width="32" height="32" border="0"></a></div></td>
<td><?php echo date("F j, Y",$meeting->ForDate); ?></td>
<td><?php echo $meeting->Description; ?></td>
<td>
! <?php
! $assign = explode(",",$meeting->ArrangedFor);
! foreach($assign as $assign){
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$assign."'");
! $group = ofirst_dbfetch_object($query);
! echo $group->GroupName;
! }
! ?>
! </td>
</tr>
<?php
}
!
// If there are no values then output a message
if(ofirst_dbnum_rows($query) == 0){
***************
*** 179,203 ****
<form onsubmit="return dhtmlEditorPrepareSubmit();" action='meetings.php' method='POST'>
<table width="64%">
! <tr>
<th width="19%"> </th>
<th width="31%">Plan New Meeting</th>
</tr>
! <tr>
<td valign="top">
<div align="right">Description:</div></td>
<td>
<?php
!
// If the WYSIWYG function is set then use the WYSIWYG module
! if (function_exists("make_wysiwyg")) {
! make_wysiwyg("description",500,255,"");
! }else{
echo "<textarea name='description'></textarea>";
}
?>
! </td>
</tr>
! <tr>
<td><div align="right">Meeting Date:</div></td>
<td><select name="month" id="month">
--- 179,203 ----
<form onsubmit="return dhtmlEditorPrepareSubmit();" action='meetings.php' method='POST'>
<table width="64%">
! <tr>
<th width="19%"> </th>
<th width="31%">Plan New Meeting</th>
</tr>
! <tr>
<td valign="top">
<div align="right">Description:</div></td>
<td>
<?php
!
// If the WYSIWYG function is set then use the WYSIWYG module
! if (function_exists("make_wysiwyg")) {
! make_wysiwyg("description",500,255,"");
! } else {
echo "<textarea name='description'></textarea>";
}
?>
! </td>
</tr>
! <tr>
<td><div align="right">Meeting Date:</div></td>
<td><select name="month" id="month">
***************
*** 252,260 ****
<option>31</option>
</select>
! ,
<select name="year" id="year">
<option selected><?php echo date("Y",time()); ?></option>
! <option>----</option>
! <option>2003</option>
<option>2004</option>
<option>2005</option>
--- 252,260 ----
<option>31</option>
</select>
! ,
<select name="year" id="year">
<option selected><?php echo date("Y",time()); ?></option>
! <option>----</option>
! <option>2003</option>
<option>2004</option>
<option>2005</option>
***************
*** 266,270 ****
</select>
<input name="hour" type="text" id="hour" size="2">
! : <input name="minute" type="text" id="minute" size="2">
<select name="ampm" id="ampm">
<option selected>AM</option>
--- 266,270 ----
</select>
<input name="hour" type="text" id="hour" size="2">
! : <input name="minute" type="text" id="minute" size="2">
<select name="ampm" id="ampm">
<option selected>AM</option>
***************
*** 272,301 ****
</select> </td>
</tr>
! <tr>
<td><div align="right">Arranged For:</div></td>
! <td><p>
<select name="assign[]" size="6" multiple="multiple" style="width: 250px;" id="assign">
<?php
-
- // Output a list of current groups
- $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups ORDER BY GroupName;");
- while($group = ofirst_dbfetch_object($query)){
- echo "<option value='".$group->ID."'>".$group->GroupName."</option>";
- }
! ?>
</select>
<font size="2"></font></p></td>
</tr>
! <tr>
<td> </td>
! <td><input name="create" type="submit" id="create2" value="Create Meeting">
<input type="reset" name="Reset" value="Reset"> </td>
</tr>
! <tr>
<th> </th>
<th>Remove Meeting</th>
</tr>
! <tr>
<td><div align="right">Meeting Date:</div></td>
<td><select name="project" id="project">
--- 272,301 ----
</select> </td>
</tr>
! <tr>
<td><div align="right">Arranged For:</div></td>
! <td><p>
<select name="assign[]" size="6" multiple="multiple" style="width: 250px;" id="assign">
<?php
! // Output a list of current groups
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups ORDER BY GroupName;");
! while($group = ofirst_dbfetch_object($query)){
! echo "<option value='".$group->ID."'>".$group->GroupName."</option>";
! }
!
! ?>
</select>
<font size="2"></font></p></td>
</tr>
! <tr>
<td> </td>
! <td><input name="create" type="submit" id="create2" value="Create Meeting">
<input type="reset" name="Reset" value="Reset"> </td>
</tr>
! <tr>
<th> </th>
<th>Remove Meeting</th>
</tr>
! <tr>
<td><div align="right">Meeting Date:</div></td>
<td><select name="project" id="project">
***************
*** 305,322 ****
$query = ofirst_dbquery("SELECT * FROM ofirst_projects_meetings ORDER BY ForDate");
while($meeting = ofirst_dbfetch_object($query)){
! echo "<option value='".$meeting->ID."'>".date("F j, Y h:i a",$meeting->ForDate)."</option>";
! }
! ?>
</select></td>
</tr>
! <tr>
! <td><div align="right">
<input name="confirm" type="checkbox" id="confirm" value="checkbox">
</div></td>
! <td>Click here to confirm the removal of this meeting. Without checking the
meeting will not be removed.</td>
</tr>
! <tr>
<td> </td>
<td><input name="remove" type="submit" id="remove" value="Remove"></td>
--- 305,322 ----
$query = ofirst_dbquery("SELECT * FROM ofirst_projects_meetings ORDER BY ForDate");
while($meeting = ofirst_dbfetch_object($query)){
! echo "<option value='".$meeting->ID."'>".date("F j, Y h:i a",$meeting->ForDate)."</option>";
! }
! ?>
</select></td>
</tr>
! <tr>
! <td><div align="right">
<input name="confirm" type="checkbox" id="confirm" value="checkbox">
</div></td>
! <td>Click here to confirm the removal of this meeting. Without checking the
meeting will not be removed.</td>
</tr>
! <tr>
<td> </td>
<td><input name="remove" type="submit" id="remove" value="Remove"></td>
Index: mytask.php
===================================================================
RCS file: /cvsroot/openfirst/projects/mytask.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** mytask.php 30 Aug 2003 00:04:02 -0000 1.3
--- mytask.php 30 Aug 2003 14:42:57 -0000 1.4
***************
*** 33,119 ****
// Check if user is a member
! if(! ISSET($user->user)){
! showlogin();
! }else{
! ?>
<h2>My Tasks Summarized</h2>
! <p>The information listed below is a list of summarized tasks that you have been
assigned to.</p>
<table width="100%" border="0" cellspacing="0" cellpadding="6">
! <tr>
! <td bgcolor="#666666"> <div align="center"><font color="#FFFFFF">Your Current
! Tasks </font></div></td>
</tr>
</table>
<table width="100%" bordercolor="#999999">
! <tr bgcolor="#999999">
! <td width="4%"> </td>
! <td width="20%">Task Name</td>
! <td width="13%">Target Date</td>
! <td width="33%">Description</td>
! <td width="30%">Assigned</td>
</tr>
<?php
!
// Run through the current tasks
$query = ofirst_dbquery("SELECT * FROM ofirst_projects_tasks");
while($tasks = ofirst_dbfetch_object($query)){
! $showtask = false;
! $assigned = explode(",",$tasks->Assigned);
! foreach($assigned As $member){
! if($member == $user->user){
! $showtask = true;
! }
! }
!
! if($showtask){
!
! // If value is pending then select the proper information
! if($tasks->Pend == "none"){
! $pend = false;
! }else{
!
! $taskquery = ofirst_dbquery("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$tasks->Pend."'");
! $pendtask = ofirst_dbfetch_object($taskquery);
! if($pendtask->Completion == 100){
! $pend = false;
! }else{
! $pend = true;
! }
! }
}
?>
! <tr onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'" <?php if(date("F j, Y",time()) == date("F j, Y",$tasks->Dates)){ echo "bgColor='#CCCCCC'"; } ?>>
! <td><a href="notes.php?GroupID=<?php echo $_GET['GroupID']; ?>&TaskID=<?php echo $tasks->ID; ?>&ProjectID=<?php echo $_GET['ProjectID']; ?>">
<?php
! // If value is pending then show pend graphics
! if($pend){
! echo "<img src='../members/icons/actions/encrypted.png' border='0'>";
! }else{
! echo "<a href='notes.php?GroupID=".$tasks->GroupID."&TaskID=".$tasks->ID."&ProjectID=".$tasks->ProjectID."'><img src='../members/icons/filesystems/desktop.png' border='0'></a>";
! }
! ?>
</a></td>
! <td>
<?php
! echo $tasks->TaskName." (";
! if(! $pend){
! echo $tasks->Completion."%";
! }else{
! echo "PEND ON: ".$pendtask->TaskName;
! }
! echo ")";
! ?>
</td>
<td>
<?php
! echo date("F j, Y",$tasks->TarDate);
! ?>
</td>
<td><?php echo $tasks->Description; ?></td>
--- 33,119 ----
// Check if user is a member
! if(! isset($user->user)){
! showlogin();
! } else {
! ?>
<h2>My Tasks Summarized</h2>
! <p>The information listed below is a list of summarized tasks that you have been
assigned to.</p>
<table width="100%" border="0" cellspacing="0" cellpadding="6">
! <tr>
! <th>Your Current
! Tasks </th>
</tr>
</table>
<table width="100%" bordercolor="#999999">
! <tr bgcolor="#999999">
! <th width="4%"> </th>
! <th width="20%">Task Name</th>
! <th width="13%">Target Date</th>
! <th width="33%">Description</th>
! <th width="30%">Assigned</th>
</tr>
<?php
!
// Run through the current tasks
$query = ofirst_dbquery("SELECT * FROM ofirst_projects_tasks");
while($tasks = ofirst_dbfetch_object($query)){
! $showtask = false;
! $assigned = explode(",",$tasks->Assigned);
! foreach($assigned As $member){
! if($member == $user->user){
! $showtask = true;
! }
! }
! if($showtask){
!
! // If value is pending then select the proper information
! if($tasks->Pend == "none"){
! $pend = false;
! } else {
!
! $taskquery = ofirst_dbquery("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$tasks->Pend."'");
! $pendtask = ofirst_dbfetch_object($taskquery);
!
! if($pendtask->Completion == 100){
! $pend = false;
! } else {
! $pend = true;
! }
! }
}
?>
! <tr onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'" <?php if(date("F j, Y",time()) == date("F j, Y",$tasks->Dates)){ echo "bgColor='#CCCCCC'"; } ?>>
! <td><a href="notes.php?GroupID=<?php echo $_GET['GroupID']; ?>&TaskID=<?php echo $tasks->ID; ?>&ProjectID=<?php echo $_GET['ProjectID']; ?>">
<?php
! // If value is pending then show pend graphics
! if($pend){
! echo "<img src='../members/icons/actions/encrypted.png' border='0'>";
! } else {
! echo "<a href='notes.php?GroupID=".$tasks->GroupID."&TaskID=".$tasks->ID."&ProjectID=".$tasks->ProjectID."'><img src='../members/icons/filesystems/desktop.png' border='0'></a>";
! }
! ?>
</a></td>
! <td>
<?php
! echo $tasks->TaskName." (";
! if(! $pend){
! echo $tasks->Completion."%";
! } else {
! echo "PEND ON: ".$pendtask->TaskName;
! }
! echo ")";
! ?>
</td>
<td>
<?php
! echo date("F j, Y",$tasks->TarDate);
! ?>
</td>
<td><?php echo $tasks->Description; ?></td>
***************
*** 122,130 ****
<?
}
!
if(ofirst_dbnum_rows($query) == 0){
echo "\n <tr>\n <td> </td>\n <td> </td>\n <td> </td>\n <td>There are no tasks for this project!</td>\n <td> </td>";
}
!
?>
</table>
--- 122,130 ----
<?
}
!
if(ofirst_dbnum_rows($query) == 0){
echo "\n <tr>\n <td> </td>\n <td> </td>\n <td> </td>\n <td>There are no tasks for this project!</td>\n <td> </td>";
}
!
?>
</table>
Index: notes.php
===================================================================
RCS file: /cvsroot/openfirst/projects/notes.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** notes.php 30 Aug 2003 00:04:02 -0000 1.6
--- notes.php 30 Aug 2003 14:42:57 -0000 1.7
***************
*** 33,85 ****
// If the user is logged in
! if(ISSET($user->user)){
! // Create button process
! if(ISSET($_POST['create'])){
! ofirst_dbquery("INSERT INTO ofirst_projects_notes SET
! TaskID = '".$_GET['TaskID']."',
! GroupID = '".$_GET['GroupID']."',
! ProjectID = '".$_GET['ProjectID']."',
! Description = '".$_POST['description']."',
! Commiter = '".$user->user."',
! Dates = '".time()."'") or die(ofirst_dberror());
! echo "<br><br>Note created! [ <a href='notes.php?GroupID=".$_GET['GroupID']."&ProjectID=".$_GET['ProjectID']."&TaskID=".$_GET['TaskID']."'>Notes</a> ]<br><br>";
! die(include($footer));
! }
!
! // Addcompletion button process
! if(ISSET($_POST['addcompletion'])){
! ofirst_dbquery("INSERT INTO ofirst_projects_notes SET
! TaskID = '".$_GET['TaskID']."',
! GroupID = '".$_GET['GroupID']."',
! ProjectID = '".$_GET['ProjectID']."',
! Description = '<b>Task completion set to: </b>".$_POST['completion']."%',
! Commiter = '".$user->user."',
! Dates = '".time()."'") or die(ofirst_dberror());
! ofirst_dbquery("UPDATE ofirst_projects_Tasks SET Completion = '".$_POST['completion']."' WHERE ID = '".$_GET['TaskID']."'") or die(ofirst_dberror());
! echo "<br><br>Task completion changed to: ".$_POST['completion']."% [ <a href='notes.php?GroupID=".$_GET['GroupID']."&ProjectID=".$_GET['ProjectID']."&TaskID=".$_GET['TaskID']."'>Notes</a> ]<br><br>";
! die(include($footer));
! }
!
! // Get information related to these notes
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
! $group = ofirst_dbfetch_object($query);
!
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."' AND ID = '".$_GET['ProjectID']."'");
! $project = ofirst_dbfetch_object($query);
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_tasks WHERE GroupID = '".$_GET['GroupID']."' AND ProjectID = '".$_GET['ProjectID']."' AND ID = '".$_GET['TaskID']."'");
! $task = ofirst_dbfetch_object($query);
! ?>
<h2>Notes and Descriptions</h2>
<table width="540">
! <tr>
! <td width="0" height="0"> <div align="left"><em>Location:</em> <a href="groups.php"><?php echo $group->GroupName; ?>
! Group</a> / <a href="projects.php?GroupID=<?php echo $_GET['GroupID']; ?>"><?php echo $project->ProjectName; ?>
! Project</a> / <a href="tasks.php?GroupID=<?php echo $_GET['GroupID']; ?>&ProjectID=<?php echo $_GET['ProjectID']; ?>"><?php echo $task->TaskName; ?>
Task</a> / <a href="notes.php?GroupID=<?php echo $_GET['GroupID']; ?>&ProjectID=<?php echo $_GET['ProjectID']; ?>&TaskID=<?php echo $_GET['TaskID']; ?>"><strong>Notes</strong></a></div></td>
</tr>
--- 33,85 ----
// If the user is logged in
! if(isset($user->user)){
! // Create button process
! if(isset($_POST['create'])){
! ofirst_dbquery("INSERT INTO ofirst_projects_notes SET
! TaskID = '".$_GET['TaskID']."',
! GroupID = '".$_GET['GroupID']."',
! ProjectID = '".$_GET['ProjectID']."',
! Description = '".$_POST['description']."',
! Commiter = '".$user->user."',
! Dates = '".time()."'") or die(ofirst_dberror());
! echo "<br><br>Note created! [ <a href='notes.php?GroupID=".$_GET['GroupID']."&ProjectID=".$_GET['ProjectID']."&TaskID=".$_GET['TaskID']."'>Notes</a> ]<br><br>";
! die(include($footer));
! }
! // Addcompletion button process
! if(isset($_POST['addcompletion'])){
! ofirst_dbquery("INSERT INTO ofirst_projects_notes SET
! TaskID = '".$_GET['TaskID']."',
! GroupID = '".$_GET['GroupID']."',
! ProjectID = '".$_GET['ProjectID']."',
! Description = '<b>Task completion set to: </b>".$_POST['completion']."%',
! Commiter = '".$user->user."',
! Dates = '".time()."'") or die(ofirst_dberror());
! ofirst_dbquery("UPDATE ofirst_projects_Tasks SET Completion = '".$_POST['completion']."' WHERE ID = '".$_GET['TaskID']."'") or die(ofirst_dberror());
! echo "<br><br>Task completion changed to: ".$_POST['completion']."% [ <a href='notes.php?GroupID=".$_GET['GroupID']."&ProjectID=".$_GET['ProjectID']."&TaskID=".$_GET['TaskID']."'>Notes</a> ]<br><br>";
! die(include($footer));
! }
! // Get information related to these notes
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
! $group = ofirst_dbfetch_object($query);
!
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."' AND ID = '".$_GET['ProjectID']."'");
! $project = ofirst_dbfetch_object($query);
!
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_tasks WHERE GroupID = '".$_GET['GroupID']."' AND ProjectID = '".$_GET['ProjectID']."' AND ID = '".$_GET['TaskID']."'");
! $task = ofirst_dbfetch_object($query);
!
! ?>
<h2>Notes and Descriptions</h2>
<table width="540">
! <tr>
! <td width="0" height="0"> <div align="left"><em>Location:</em> <a href="groups.php"><?php echo $group->GroupName; ?>
! Group</a> / <a href="projects.php?GroupID=<?php echo $_GET['GroupID']; ?>"><?php echo $project->ProjectName; ?>
! Project</a> / <a href="tasks.php?GroupID=<?php echo $_GET['GroupID']; ?>&ProjectID=<?php echo $_GET['ProjectID']; ?>"><?php echo $task->TaskName; ?>
Task</a> / <a href="notes.php?GroupID=<?php echo $_GET['GroupID']; ?>&ProjectID=<?php echo $_GET['ProjectID']; ?>&TaskID=<?php echo $_GET['TaskID']; ?>"><strong>Notes</strong></a></div></td>
</tr>
***************
*** 87,96 ****
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="6">
! <tr>
<th>Notes for Task <?php echo $task->TaskName; ?></th>
</tr>
</table>
<table width="100%" bordercolor="#999999">
! <tr bgcolor="#999999">
<td width="5%"> </td>
<td width="17%">Date</td>
--- 87,96 ----
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="6">
! <tr>
<th>Notes for Task <?php echo $task->TaskName; ?></th>
</tr>
</table>
<table width="100%" bordercolor="#999999">
! <tr bgcolor="#999999">
<td width="5%"> </td>
<td width="17%">Date</td>
***************
*** 100,109 ****
<?php
! // List the notes
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_notes WHERE GroupID = '".$_GET['GroupID']."' AND ProjectID = '".$_GET['ProjectID']."' AND TaskID = '".$_GET['TaskID']."'");
! while($notes = ofirst_dbfetch_object($query)){
?>
!
<tr <?php if(date("F j, Y",time()) == date("F j, Y",$notes->Dates)){ echo "bgColor='#CCCCCC'"; } ?>>
<td><img src="../members/icons/filesystems/files.png" width="32" height="32"></td>
--- 100,109 ----
<?php
! // List the notes
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_notes WHERE GroupID = '".$_GET['GroupID']."' AND ProjectID = '".$_GET['ProjectID']."' AND TaskID = '".$_GET['TaskID']."'");
! while($notes = ofirst_dbfetch_object($query)){
?>
!
<tr <?php if(date("F j, Y",time()) == date("F j, Y",$notes->Dates)){ echo "bgColor='#CCCCCC'"; } ?>>
<td><img src="../members/icons/filesystems/files.png" width="32" height="32"></td>
***************
*** 113,175 ****
</tr>
<?php
! }
!
! // If no notes are present then display message
! if(ofirst_dbnum_rows($query) == 0){
! echo "\n <tr>\n <td> </td>\n <td> </td>\n <td>There are no notes for this task!</td>\n <td> </td>\n </tr>\n";
! }
?>
</table>
<?php
! // If current user is a member of this task then allow him to add/edit a note
! $allowed = explode(",",$task->Assigned);
! $show = false;
! foreach($allowed as $allow){
! if($allow == $user->user){
! $show = true;
! }
! }
!
! if($show){
?>
<br>
<form onsubmit="return dhtmlEditorPrepareSubmit();" action='notes.php?GroupID=<?php echo $_GET['GroupID']; ?>&ProjectID=<?php echo $_GET['ProjectID']; ?>&TaskID=<?php echo $_GET['TaskID'];?>' method='POST'>
<table width="39%">
! <tr>
<th width="19%"> </th>
! <th width="31%"><div align="center">Add New Note</div></th>
</tr>
! <tr>
<td valign="top"> <div align="right">Description: </div></td>
<td>
<?php
! // If the WYSIWYG function is set then display the WYSIWYG box
! if (function_exists("make_wysiwyg")) {
! make_wysiwyg("description",500,255,"");
! }else{
! echo "<textarea name='description'></textarea>";
! }
?>
! </td>
</tr>
! <tr>
<td> </td>
! <td><input name="create" type="submit" id="create2" value="Create Note">
<input type="reset" name="Reset" value="Reset"> </td>
</tr>
! <tr>
<th> </th>
<th>Add Task Completion</th>
</tr>
! <tr>
<td><div align="right">Completion:</div></td>
<td><select name="completion" id="completion">
! <option selected><?php echo $task->Completion; ?></option>
! <option>----</option>
<option>CLOSE</option>
! <option>0</option>
<option>5</option>
<option>10</option>
--- 113,175 ----
</tr>
<?php
! }
!
! // If no notes are present then display message
! if(ofirst_dbnum_rows($query) == 0){
! echo "\n <tr>\n <td> </td>\n <td> </td>\n <td>There are no notes for this task!</td>\n <td> </td>\n </tr>\n";
! }
?>
</table>
<?php
! // If current user is a member of this task then allow him to add/edit a note
! $allowed = explode(",",$task->Assigned);
! $show = false;
! foreach($allowed as $allow){
! if($allow == $user->user){
! $show = true;
! }
! }
!
! if($show){
?>
<br>
<form onsubmit="return dhtmlEditorPrepareSubmit();" action='notes.php?GroupID=<?php echo $_GET['GroupID']; ?>&ProjectID=<?php echo $_GET['ProjectID']; ?>&TaskID=<?php echo $_GET['TaskID'];?>' method='POST'>
<table width="39%">
! <tr>
<th width="19%"> </th>
! <th width="31%">Add New Note</th>
</tr>
! <tr>
<td valign="top"> <div align="right">Description: </div></td>
<td>
<?php
! // If the WYSIWYG function is set then display the WYSIWYG box
! if (function_exists("make_wysiwyg")) {
! make_wysiwyg("description",500,255,"");
! } else {
! echo "<textarea name='description'></textarea>";
! }
?>
! </td>
</tr>
! <tr>
<td> </td>
! <td><input name="create" type="submit" id="create2" value="Create Note">
<input type="reset" name="Reset" value="Reset"> </td>
</tr>
! <tr>
<th> </th>
<th>Add Task Completion</th>
</tr>
! <tr>
<td><div align="right">Completion:</div></td>
<td><select name="completion" id="completion">
! <option selected><?php echo $task->Completion; ?></option>
! <option>----</option>
<option>CLOSE</option>
! <option>0</option>
<option>5</option>
<option>10</option>
***************
*** 201,208 ****
</table>
</form>
! <?php
! }
}
include($footer);
! ?>
\ No newline at end of file
--- 201,208 ----
</table>
</form>
! <?php
! }
}
include($footer);
! ?>
Index: preferences.php
===================================================================
RCS file: /cvsroot/openfirst/projects/preferences.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** preferences.php 30 Aug 2003 00:04:02 -0000 1.6
--- preferences.php 30 Aug 2003 14:42:57 -0000 1.7
***************
*** 31,66 ****
$header_condense = true;
include($header);
!
// Check if user is a member
! if(! ISSET($user->user)){
! showlogin();
! }else{
!
! // Save button process
! if(ISSET($_POST['save'])){
! ofirst_dbquery("UPDATE ofirst_members SET
! ProjectsUpdates = '".$_POST['updates']."',
! ProjectsCommitSelect = '".$_POST['select']."',
! ProjectsSendTemplate = '".$_POST['template']."' WHERE user = '".$user->user."'") or die(ofirst_dberror());
! echo "<br><br><br>Your account options have been updated! [ <a href='preferences.php'>Preferences</a> ]<br><br><br>";
! die(include($footer));
! }
! ?>
<h2><font face="Verdana, Arial, Helvetica, sans-serif">Preferences</font><br>
</h2>
<form action='preferences.php' method='POST'>
<table width="527" align="center">
! <tr>
<th>Update Mailer</th>
</tr>
! <tr>
<td height="190">
! <p align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Your
! E-Mail Address: <strong><?php if(! ISSET($user->email)){ echo "You must configure your user account in order for this to automatically set."; }else{ echo $user->email; } ?></strong></font></p>
! <p align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Would
! you like to be sent daily updates?
<select name="updates" id="updates">
! <option selected><?php echo $user->ProjectsUpdates; ?></option>
<option>-----</option>
<option value="On">Yes</option>
--- 31,66 ----
$header_condense = true;
include($header);
!
// Check if user is a member
! if(! isset($user->user)){
! showlogin();
! } else {
! // Save button process
! if(isset($_POST['save'])){
! ofirst_dbquery("UPDATE ofirst_members SET
! ProjectsUpdates = '".$_POST['updates']."',
! ProjectsCommitSelect = '".$_POST['select']."',
! ProjectsSendTemplate = '".$_POST['template']."' WHERE user = '".$user->user."'") or die(ofirst_dberror());
! echo "<br><br><br>Your account options have been updated! [ <a href='preferences.php'>Preferences</a> ]<br><br><br>";
! die(include($footer));
! }
!
! ?>
<h2><font face="Verdana, Arial, Helvetica, sans-serif">Preferences</font><br>
</h2>
<form action='preferences.php' method='POST'>
<table width="527" align="center">
! <tr>
<th>Update Mailer</th>
</tr>
! <tr>
<td height="190">
! <p align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Your
! E-Mail Address: <strong><?php if(! isset($user->email)){ echo "You must configure your user account in order for this to automatically set."; }else{ echo $user->email; } ?></strong></font></p>
! <p align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Would
! you like to be sent daily updates?
<select name="updates" id="updates">
! <option selected><?php echo $user->ProjectsUpdates; ?></option>
<option>-----</option>
<option value="On">Yes</option>
***************
*** 68,73 ****
</select>
</font></p>
! <p align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">What
! kind of updates would you like to be sent?
<select name="template" id="template">
<option selected><?php echo $user->ProjectsSendTemplate; ?></option>
--- 68,73 ----
</select>
</font></p>
! <p align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">What
! kind of updates would you like to be sent?
<select name="template" id="template">
<option selected><?php echo $user->ProjectsSendTemplate; ?></option>
***************
*** 77,82 ****
</select>
</font></p>
! <p align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">What
! kind of updates would you like to be sent?
<select name="select" id="select">
<option selected><?php echo $user->ProjectsCommitSelect; ?></option>
--- 77,82 ----
</select>
</font></p>
! <p align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">What
! kind of updates would you like to be sent?
<select name="select" id="select">
<option selected><?php echo $user->ProjectsCommitSelect; ?></option>
***************
*** 86,90 ****
</select>
</font></p>
! <p align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input name="save" type="submit" id="save" value="Save Preferences">
<br>
--- 86,90 ----
</select>
</font></p>
! <p align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<input name="save" type="submit" id="save" value="Save Preferences">
<br>
***************
*** 98,100 ****
include($footer);
! ?>
\ No newline at end of file
--- 98,100 ----
include($footer);
! ?>
Index: projects.php
===================================================================
RCS file: /cvsroot/openfirst/projects/projects.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** projects.php 30 Aug 2003 00:17:53 -0000 1.7
--- projects.php 30 Aug 2003 14:42:57 -0000 1.8
***************
*** 31,97 ****
$header_condense = true;
include($header);
!
// Check if user is a member
! if(! ISSET($user->user)){
! showlogin();
! }else{
!
! // Create project button process
! if(ISSET($_POST['create'])){
!
! // Check if members are assigned
! if(! ISSET($_POST['assign'])){
! echo "<br><br>You must assign users to this task! Click back to continue.<br><br><br>";
! die(include($footer));
! }
!
! // Check if value is single or array then give it a value for the database insert
! if(is_array($_POST['assign'])){
! $assign = implode(",",$_POST['assign']);
! }else{
$assign = $_POST['assign'];
! }
!
! // Create database record
! ofirst_dbquery("INSERT INTO ofirst_projects_projects SET
! ProjectName = '".$_POST['projectname']."',
! GroupID = '".$_GET['GroupID']."',
! Completion = '0',
! Pend = '".$_POST['pend']."',
! Description = '".$_POST['description']."',
! Assigned = '".$assign."',
! TarDate = 'date',
! Dates = '".time()."'") or die(ofirst_dberror());
! echo "<br><br>Project created! [ <a href='projects.php?GroupID=".$_GET['GroupID']."'>Projects</a> ]<br><br>";
! die(include($footer));
! }
!
! // Remove button process
! if(ISSET($_POST['remove'])){
!
! if(! ISSET($_POST['confirm'])){
! echo "<br><br>Your request to remove the project was denied because you have not confirmed! [ <a href='projects.php?GroupID=".$_GET['GroupID']."'>Projects</a> ]<br><br>";
! die(include($footer));
! }
!
! // Remove all values related to this project
! ofirst_dbquery("DELETE FROM ofirst_projects_projects WHERE ID = '".$_POST['project']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_notes WHERE ProjectID = '".$_POST['project']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_tasks WHERE ProjectID = '".$_POST['project']."'") or die(ofirst_dberror());
! echo "<br><br>Project removed! [ <a href='projects.php?GroupID=".$_GET['GroupID']."'>Projects</a> ]<br><br>";
! die(include($footer));
!
! }
!
! // Collect information about projects
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."' ORDER BY GroupName;");
! $group = ofirst_dbfetch_object($query);
!
! ?>
<h2>Project Listings</h2>
<table width="540">
! <tr>
! <td width="0" height="0"> <div align="left"><em>Location:</em> <a href="groups.php">
<?php echo $group->GroupName; ?> Group</a> / <a href="projects.php?GroupID=<?php echo $_GET['GroupID']; ?>"><strong>Projects</strong></a></div></td>
</tr>
--- 31,97 ----
$header_condense = true;
include($header);
!
// Check if user is a member
! if(! isset($user->user)){
! showlogin();
! } else {
!
! // Create project button process
! if(isset($_POST['create'])){
!
! // Check if members are assigned
! if(! isset($_POST['assign'])){
! echo "<br><br>You must assign users to this task! Click back to continue.<br><br><br>";
! die(include($footer));
! }
!
! // Check if value is single or array then give it a value for the database insert
! if(is_array($_POST['assign'])){
! $assign = implode(",",$_POST['assign']);
! } else {
$assign = $_POST['assign'];
! }
! // Create database record
! ofirst_dbquery("INSERT INTO ofirst_projects_projects SET
! ProjectName = '".$_POST['projectname']."',
! GroupID = '".$_GET['GroupID']."',
! Completion = '0',
! Pend = '".$_POST['pend']."',
! Description = '".$_POST['description']."',
! Assigned = '".$assign."',
! TarDate = 'date',
! Dates = '".time()."'") or die(ofirst_dberror());
! echo "<br><br>Project created! [ <a href='projects.php?GroupID=".$_GET['GroupID']."'>Projects</a> ]<br><br>";
! die(include($footer));
! }
!
!
! // Remove button process
! if(isset($_POST['remove'])){
!
! if(! isset($_POST['confirm'])){
! echo "<br><br>Your request to remove the project was denied because you have not confirmed! [ <a href='projects.php?GroupID=".$_GET['GroupID']."'>Projects</a> ]<br><br>";
! die(include($footer));
! }
!
! // Remove all values related to this project
! ofirst_dbquery("DELETE FROM ofirst_projects_projects WHERE ID = '".$_POST['project']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_notes WHERE ProjectID = '".$_POST['project']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_tasks WHERE ProjectID = '".$_POST['project']."'") or die(ofirst_dberror());
! echo "<br><br>Project removed! [ <a href='projects.php?GroupID=".$_GET['GroupID']."'>Projects</a> ]<br><br>";
! die(include($footer));
!
! }
!
! // Collect information about projects
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."' ORDER BY GroupName;");
! $group = ofirst_dbfetch_object($query);
!
! ?>
<h2>Project Listings</h2>
<table width="540">
! <tr>
! <td width="0" height="0"> <div align="left"><em>Location:</em> <a href="groups.php">
<?php echo $group->GroupName; ?> Group</a> / <a href="projects.php?GroupID=<?php echo $_GET['GroupID']; ?>"><strong>Projects</strong></a></div></td>
</tr>
***************
*** 99,108 ****
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="6">
! <tr>
<th>Project Listings for <?php echo $group->GroupName; ?> Group</th>
</tr>
</table>
<table width="100%" bordercolor="#999999">
! <tr bgcolor="#999999"> ...
[truncated message content] |
|
From: <xt...@us...> - 2003-08-30 00:17:56
|
Update of /cvsroot/openfirst/projects
In directory sc8-pr-cvs1:/tmp/cvs-serv11317
Modified Files:
groups.php meetings.php projects.php tasks.php
Log Message:
Fix some width problems that occured in some versions of Mozilla (and presumably other browsers)
Index: groups.php
===================================================================
RCS file: /cvsroot/openfirst/projects/groups.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** groups.php 30 Aug 2003 00:04:02 -0000 1.6
--- groups.php 30 Aug 2003 00:17:53 -0000 1.7
***************
*** 169,173 ****
<tr>
<td><div align="right">Moderators:</div></td>
! <td><select name="moderators[]" size="6" multiple width='40'>
<?php
$query = ofirst_dbquery("SELECT * FROM ofirst_members ORDER BY user;");
--- 169,173 ----
<tr>
<td><div align="right">Moderators:</div></td>
! <td><select name="moderators[]" size="6" multiple="multiple" style="width: 250px;">
<?php
$query = ofirst_dbquery("SELECT * FROM ofirst_members ORDER BY user;");
***************
*** 181,185 ****
<td valign="top">
<div align="right">Members:</div></td>
! <td><select name="members[]" size="6" multiple width='40'>
<?php
$query = ofirst_dbquery("SELECT * FROM ofirst_members ORDER BY user;");
--- 181,185 ----
<td valign="top">
<div align="right">Members:</div></td>
! <td><select name="members[]" size="6" multiple="multiple" style="width: 250px;">
<?php
$query = ofirst_dbquery("SELECT * FROM ofirst_members ORDER BY user;");
Index: meetings.php
===================================================================
RCS file: /cvsroot/openfirst/projects/meetings.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** meetings.php 30 Aug 2003 00:04:02 -0000 1.3
--- meetings.php 30 Aug 2003 00:17:53 -0000 1.4
***************
*** 275,279 ****
<td><div align="right">Arranged For:</div></td>
<td><p>
! <select name="assign[]" width='40' size="6" multiple id="assign">
<?php
--- 275,279 ----
<td><div align="right">Arranged For:</div></td>
<td><p>
! <select name="assign[]" size="6" multiple="multiple" style="width: 250px;" id="assign">
<?php
Index: projects.php
===================================================================
RCS file: /cvsroot/openfirst/projects/projects.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** projects.php 30 Aug 2003 00:04:02 -0000 1.6
--- projects.php 30 Aug 2003 00:17:53 -0000 1.7
***************
*** 290,294 ****
<td><div align="right">Assign:</div></td>
<td><p>
! <select name="assign[]" width='40' size="6" multiple id="assign">
<?php
--- 290,294 ----
<td><div align="right">Assign:</div></td>
<td><p>
! <select name="assign[]" multiple="multiple" style="width: 250px;" size="6" id="assign">
<?php
Index: tasks.php
===================================================================
RCS file: /cvsroot/openfirst/projects/tasks.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** tasks.php 30 Aug 2003 00:04:02 -0000 1.6
--- tasks.php 30 Aug 2003 00:17:53 -0000 1.7
***************
*** 315,319 ****
<tr>
<td><div align="right">Assign:</div></td>
! <td><select name="assign[]" width='40' size="6" multiple id="assign">
<?php
--- 315,319 ----
<tr>
<td><div align="right">Assign:</div></td>
! <td><select name="assign[]" size="6" multiple="multiple" style="width: 250px;" id="assign">
<?php
|
|
From: <xt...@us...> - 2003-08-30 00:08:07
|
Update of /cvsroot/openfirst/projects
In directory sc8-pr-cvs1:/tmp/cvs-serv8303
Modified Files:
index.php
Log Message:
Minor typo fix
Index: index.php
===================================================================
RCS file: /cvsroot/openfirst/projects/index.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** index.php 30 Aug 2003 00:04:02 -0000 1.7
--- index.php 30 Aug 2003 00:08:03 -0000 1.8
***************
*** 41,47 ****
showlogin();
}else{
! echo "<p> </p><p>Welcome ".$user->user.", thank you for loggin in!<br><br>";
}
include($footer);
! ?>
\ No newline at end of file
--- 41,47 ----
showlogin();
}else{
! echo "<p> </p><p>Welcome ".$user->user.", thank you for logging in!<br><br>";
}
include($footer);
! ?>
|
Update of /cvsroot/openfirst/projects
In directory sc8-pr-cvs1:/tmp/cvs-serv7756
Modified Files:
groups.php index.php meetings.php mytask.php notes.php
preferences.php projects.php tasks.php today.php
viewmeeting.php
Log Message:
Add multiple database support, alphabetical ordering of group names and user names
Index: groups.php
===================================================================
RCS file: /cvsroot/openfirst/projects/groups.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** groups.php 29 Aug 2003 15:50:35 -0000 1.5
--- groups.php 30 Aug 2003 00:04:02 -0000 1.6
***************
*** 35,39 ****
// Check if user is a member
if(! ISSET($user->user)){
! showLogin();
}else{
--- 35,39 ----
// Check if user is a member
if(! ISSET($user->user)){
! showlogin();
}else{
***************
*** 68,77 ****
// Insert data into the database
! mysql_query("INSERT INTO ofirst_projects_groups SET
GroupName = '".$_POST['groupname']."',
Description = '".$_POST['description']."',
Moderators = '$modera',
Members = '$mem',
! Dates = '".time()."'") or die(mysql_error());
echo "<br><br>Group created! [ <a href='groups.php'>Groups</a> ]<br><br>";
die(include($footer));
--- 68,77 ----
// Insert data into the database
! ofirst_dbquery("INSERT INTO ofirst_projects_groups SET
GroupName = '".$_POST['groupname']."',
Description = '".$_POST['description']."',
Moderators = '$modera',
Members = '$mem',
! Dates = '".time()."'") or die(ofirst_dberror());
echo "<br><br>Group created! [ <a href='groups.php'>Groups</a> ]<br><br>";
die(include($footer));
***************
*** 88,95 ****
// Remove data from every table that is related
! mysql_query("DELETE FROM ofirst_projects_groups WHERE ID = '".$_POST['group']."'") or die(mysql_error());
! mysql_query("DELETE FROM ofirst_projects_notes WHERE GroupID = '".$_POST['group']."'") or die(mysql_error());
! mysql_query("DELETE FROM ofirst_projects_tasks WHERE GroupID = '".$_POST['group']."'") or die(mysql_error());
! mysql_query("DELETE FROM ofirst_projects_projects WHERE GroupID = '".$_POST['group']."'") or die(mysql_error());
echo "<br><br>Group removed! [ <a href='groups.php'>Groups</a> ]<br><br>";
--- 88,95 ----
// Remove data from every table that is related
! ofirst_dbquery("DELETE FROM ofirst_projects_groups WHERE ID = '".$_POST['group']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_notes WHERE GroupID = '".$_POST['group']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_tasks WHERE GroupID = '".$_POST['group']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_projects WHERE GroupID = '".$_POST['group']."'") or die(ofirst_dberror());
echo "<br><br>Group removed! [ <a href='groups.php'>Groups</a> ]<br><br>";
***************
*** 125,130 ****
// Query the current group values and loop through them
! $query = mysql_query("SELECT * FROM ofirst_projects_groups");
! while($groups = mysql_fetch_object($query)){
?>
--- 125,130 ----
// Query the current group values and loop through them
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups");
! while($groups = ofirst_dbfetch_object($query)){
?>
***************
*** 135,140 ****
<td>
<?php
! $projquery = mysql_query("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$groups->ID."'");
! echo mysql_num_rows($projquery);
?>
</td>
--- 135,140 ----
<td>
<?php
! $projquery = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$groups->ID."'");
! echo ofirst_dbnum_rows($projquery);
?>
</td>
***************
*** 146,150 ****
}
! if(mysql_num_rows($query) == 0){
echo "<tr><td>--</td><td>--</td><td>--</td><td><center>No group has been found!</center></td><td>--</td><td>--</td>";
}
--- 146,150 ----
}
! if(ofirst_dbnum_rows($query) == 0){
echo "<tr><td>--</td><td>--</td><td>--</td><td><center>No group has been found!</center></td><td>--</td><td>--</td>";
}
***************
*** 171,176 ****
<td><select name="moderators[]" size="6" multiple width='40'>
<?php
! $query = mysql_query("SELECT * FROM ofirst_members");
! while($members = mysql_fetch_object($query)){
echo "<option>".$members->user."</option>";
}
--- 171,176 ----
<td><select name="moderators[]" size="6" multiple width='40'>
<?php
! $query = ofirst_dbquery("SELECT * FROM ofirst_members ORDER BY user;");
! while($members = ofirst_dbfetch_object($query)){
echo "<option>".$members->user."</option>";
}
***************
*** 183,188 ****
<td><select name="members[]" size="6" multiple width='40'>
<?php
! $query = mysql_query("SELECT * FROM ofirst_members");
! while($members = mysql_fetch_object($query)){
echo "<option>".$members->user."</option>";
}
--- 183,188 ----
<td><select name="members[]" size="6" multiple width='40'>
<?php
! $query = ofirst_dbquery("SELECT * FROM ofirst_members ORDER BY user;");
! while($members = ofirst_dbfetch_object($query)){
echo "<option>".$members->user."</option>";
}
***************
*** 205,211 ****
<?php
! $query = mysql_query("SELECT * FROM ofirst_projects_groups");
! while($groups = mysql_fetch_object($query)){
echo "<option value='".$groups->ID."'>".$groups->GroupName."</option>";
}
--- 205,211 ----
<?php
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups ORDER BY GroupName;");
! while($groups = ofirst_dbfetch_object($query)){
echo "<option value='".$groups->ID."'>".$groups->GroupName."</option>";
}
***************
*** 227,229 ****
</table>
</form>
! <?php } include($footer); ?>
\ No newline at end of file
--- 227,229 ----
</table>
</form>
! <?php } include($footer); ?>
Index: index.php
===================================================================
RCS file: /cvsroot/openfirst/projects/index.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** index.php 29 Aug 2003 15:50:35 -0000 1.6
--- index.php 30 Aug 2003 00:04:02 -0000 1.7
***************
*** 39,43 ****
Please use the login form below this:</p>
<?php
! showLogin();
}else{
echo "<p> </p><p>Welcome ".$user->user.", thank you for loggin in!<br><br>";
--- 39,43 ----
Please use the login form below this:</p>
<?php
! showlogin();
}else{
echo "<p> </p><p>Welcome ".$user->user.", thank you for loggin in!<br><br>";
Index: meetings.php
===================================================================
RCS file: /cvsroot/openfirst/projects/meetings.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** meetings.php 29 Aug 2003 15:50:35 -0000 1.2
--- meetings.php 30 Aug 2003 00:04:02 -0000 1.3
***************
*** 34,38 ****
// Check if user is a member
if(! ISSET($user->user)){
! showLogin();
}else{
--- 34,38 ----
// Check if user is a member
if(! ISSET($user->user)){
! showlogin();
}else{
***************
*** 57,61 ****
// Put value into database
! mysql_query("INSERT INTO ofirst_projects_meetings SET
ForDate = '".$fordate."',
Description = '".$_POST['description']."',
--- 57,61 ----
// Put value into database
! ofirst_dbquery("INSERT INTO ofirst_projects_meetings SET
ForDate = '".$fordate."',
Description = '".$_POST['description']."',
***************
*** 63,67 ****
AbsentList = 'none',
Status = 'wait',
! Dates = '".time()."'") or die(mysql_error());
echo "<br><br>Meeting created! [ <a href='meetings.php'>Meetings</a> ]<br><br>";
die(include($footer));
--- 63,67 ----
AbsentList = 'none',
Status = 'wait',
! Dates = '".time()."'") or die(ofirst_dberror());
echo "<br><br>Meeting created! [ <a href='meetings.php'>Meetings</a> ]<br><br>";
die(include($footer));
***************
*** 78,82 ****
// Remove meeting information
! mysql_query("DELETE FROM ofirst_projects_meetings WHERE ID = '".$_POST['project']."'") or die(mysql_error());
echo "<br><br>Meetings removed! [ <a href='meetings.php'>Meetings</a> ]<br><br>";
die(include($footer));
--- 78,82 ----
// Remove meeting information
! ofirst_dbquery("DELETE FROM ofirst_projects_meetings WHERE ID = '".$_POST['project']."'") or die(ofirst_dberror());
echo "<br><br>Meetings removed! [ <a href='meetings.php'>Meetings</a> ]<br><br>";
die(include($footer));
***************
*** 101,106 ****
// Check for meetings that have not passed yet
! $meetquery = mysql_query("SELECT * FROM ofirst_projects_meetings WHERE Status='wait'");
! while($meeting = mysql_fetch_object($meetquery)){
?>
--- 101,106 ----
// Check for meetings that have not passed yet
! $meetquery = ofirst_dbquery("SELECT * FROM ofirst_projects_meetings WHERE Status='wait'");
! while($meeting = ofirst_dbfetch_object($meetquery)){
?>
***************
*** 113,118 ****
$assign = explode(",",$meeting->ArrangedFor);
foreach($assign as $assign){
! $query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$assign."'");
! $group = mysql_fetch_object($query);
echo "<br>".$group->GroupName;
}
--- 113,118 ----
$assign = explode(",",$meeting->ArrangedFor);
foreach($assign as $assign){
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$assign."'");
! $group = ofirst_dbfetch_object($query);
echo "<br>".$group->GroupName;
}
***************
*** 125,129 ****
// If there are no values then output a no value message
! if(mysql_num_rows($meetquery) == 0){
echo "<tr><td> </td><td> </td><td>There are no planned meetings!</td><td> </td></tr>";
}
--- 125,129 ----
// If there are no values then output a no value message
! if(ofirst_dbnum_rows($meetquery) == 0){
echo "<tr><td> </td><td> </td><td>There are no planned meetings!</td><td> </td></tr>";
}
***************
*** 146,151 ****
// Check for passed meetings and preview them
! $query = mysql_query("SELECT * FROM ofirst_projects_meetings WHERE Status='done'");
! while($meeting = mysql_fetch_object($query)){
?>
--- 146,151 ----
// Check for passed meetings and preview them
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_meetings WHERE Status='done'");
! while($meeting = ofirst_dbfetch_object($query)){
?>
***************
*** 158,163 ****
$assign = explode(",",$meeting->ArrangedFor);
foreach($assign as $assign){
! $query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$assign."'");
! $group = mysql_fetch_object($query);
echo $group->GroupName;
}
--- 158,163 ----
$assign = explode(",",$meeting->ArrangedFor);
foreach($assign as $assign){
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$assign."'");
! $group = ofirst_dbfetch_object($query);
echo $group->GroupName;
}
***************
*** 170,174 ****
// If there are no values then output a message
! if(mysql_num_rows($query) == 0){
echo "<tr><td> </td><td> </td><td>There are no past meetings!</td><td> </td></tr>";
}
--- 170,174 ----
// If there are no values then output a message
! if(ofirst_dbnum_rows($query) == 0){
echo "<tr><td> </td><td> </td><td>There are no past meetings!</td><td> </td></tr>";
}
***************
*** 279,284 ****
// Output a list of current groups
! $query = mysql_query("SELECT * FROM ofirst_projects_groups");
! while($group = mysql_fetch_object($query)){
echo "<option value='".$group->ID."'>".$group->GroupName."</option>";
}
--- 279,284 ----
// Output a list of current groups
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups ORDER BY GroupName;");
! while($group = ofirst_dbfetch_object($query)){
echo "<option value='".$group->ID."'>".$group->GroupName."</option>";
}
***************
*** 303,308 ****
// Output a list of meetings by date
! $query = mysql_query("SELECT * FROM ofirst_projects_meetings");
! while($meeting = mysql_fetch_object($query)){
echo "<option value='".$meeting->ID."'>".date("F j, Y h:i a",$meeting->ForDate)."</option>";
}
--- 303,308 ----
// Output a list of meetings by date
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_meetings ORDER BY ForDate");
! while($meeting = ofirst_dbfetch_object($query)){
echo "<option value='".$meeting->ID."'>".date("F j, Y h:i a",$meeting->ForDate)."</option>";
}
***************
*** 328,330 ****
}
include($footer);
! ?>
\ No newline at end of file
--- 328,330 ----
}
include($footer);
! ?>
Index: mytask.php
===================================================================
RCS file: /cvsroot/openfirst/projects/mytask.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** mytask.php 29 Aug 2003 15:50:35 -0000 1.2
--- mytask.php 30 Aug 2003 00:04:02 -0000 1.3
***************
*** 34,38 ****
// Check if user is a member
if(! ISSET($user->user)){
! showLogin();
}else{
--- 34,38 ----
// Check if user is a member
if(! ISSET($user->user)){
! showlogin();
}else{
***************
*** 58,63 ****
// Run through the current tasks
! $query = mysql_query("SELECT * FROM ofirst_projects_tasks");
! while($tasks = mysql_fetch_object($query)){
$showtask = false;
--- 58,63 ----
// Run through the current tasks
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_tasks");
! while($tasks = ofirst_dbfetch_object($query)){
$showtask = false;
***************
*** 77,82 ****
}else{
! $taskquery = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$tasks->Pend."'");
! $pendtask = mysql_fetch_object($taskquery);
if($pendtask->Completion == 100){
--- 77,82 ----
}else{
! $taskquery = ofirst_dbquery("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$tasks->Pend."'");
! $pendtask = ofirst_dbfetch_object($taskquery);
if($pendtask->Completion == 100){
***************
*** 123,127 ****
}
! if(mysql_num_rows($query) == 0){
echo "\n <tr>\n <td> </td>\n <td> </td>\n <td> </td>\n <td>There are no tasks for this project!</td>\n <td> </td>";
}
--- 123,127 ----
}
! if(ofirst_dbnum_rows($query) == 0){
echo "\n <tr>\n <td> </td>\n <td> </td>\n <td> </td>\n <td>There are no tasks for this project!</td>\n <td> </td>";
}
Index: notes.php
===================================================================
RCS file: /cvsroot/openfirst/projects/notes.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** notes.php 29 Aug 2003 15:50:35 -0000 1.5
--- notes.php 30 Aug 2003 00:04:02 -0000 1.6
***************
*** 37,41 ****
// Create button process
if(ISSET($_POST['create'])){
! mysql_query("INSERT INTO ofirst_projects_notes SET
TaskID = '".$_GET['TaskID']."',
GroupID = '".$_GET['GroupID']."',
--- 37,41 ----
// Create button process
if(ISSET($_POST['create'])){
! ofirst_dbquery("INSERT INTO ofirst_projects_notes SET
TaskID = '".$_GET['TaskID']."',
GroupID = '".$_GET['GroupID']."',
***************
*** 43,47 ****
Description = '".$_POST['description']."',
Commiter = '".$user->user."',
! Dates = '".time()."'") or die(mysql_error());
echo "<br><br>Note created! [ <a href='notes.php?GroupID=".$_GET['GroupID']."&ProjectID=".$_GET['ProjectID']."&TaskID=".$_GET['TaskID']."'>Notes</a> ]<br><br>";
--- 43,47 ----
Description = '".$_POST['description']."',
Commiter = '".$user->user."',
! Dates = '".time()."'") or die(ofirst_dberror());
echo "<br><br>Note created! [ <a href='notes.php?GroupID=".$_GET['GroupID']."&ProjectID=".$_GET['ProjectID']."&TaskID=".$_GET['TaskID']."'>Notes</a> ]<br><br>";
***************
*** 51,55 ****
// Addcompletion button process
if(ISSET($_POST['addcompletion'])){
! mysql_query("INSERT INTO ofirst_projects_notes SET
TaskID = '".$_GET['TaskID']."',
GroupID = '".$_GET['GroupID']."',
--- 51,55 ----
// Addcompletion button process
if(ISSET($_POST['addcompletion'])){
! ofirst_dbquery("INSERT INTO ofirst_projects_notes SET
TaskID = '".$_GET['TaskID']."',
GroupID = '".$_GET['GroupID']."',
***************
*** 57,63 ****
Description = '<b>Task completion set to: </b>".$_POST['completion']."%',
Commiter = '".$user->user."',
! Dates = '".time()."'") or die(mysql_error());
! mysql_query("UPDATE ofirst_projects_Tasks SET Completion = '".$_POST['completion']."' WHERE ID = '".$_GET['TaskID']."'") or die(mysql_error());
echo "<br><br>Task completion changed to: ".$_POST['completion']."% [ <a href='notes.php?GroupID=".$_GET['GroupID']."&ProjectID=".$_GET['ProjectID']."&TaskID=".$_GET['TaskID']."'>Notes</a> ]<br><br>";
--- 57,63 ----
Description = '<b>Task completion set to: </b>".$_POST['completion']."%',
Commiter = '".$user->user."',
! Dates = '".time()."'") or die(ofirst_dberror());
! ofirst_dbquery("UPDATE ofirst_projects_Tasks SET Completion = '".$_POST['completion']."' WHERE ID = '".$_GET['TaskID']."'") or die(ofirst_dberror());
echo "<br><br>Task completion changed to: ".$_POST['completion']."% [ <a href='notes.php?GroupID=".$_GET['GroupID']."&ProjectID=".$_GET['ProjectID']."&TaskID=".$_GET['TaskID']."'>Notes</a> ]<br><br>";
***************
*** 66,77 ****
// Get information related to these notes
! $query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
! $group = mysql_fetch_object($query);
! $query = mysql_query("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."' AND ID = '".$_GET['ProjectID']."'");
! $project = mysql_fetch_object($query);
! $query = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE GroupID = '".$_GET['GroupID']."' AND ProjectID = '".$_GET['ProjectID']."' AND ID = '".$_GET['TaskID']."'");
! $task = mysql_fetch_object($query);
?>
--- 66,77 ----
// Get information related to these notes
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
! $group = ofirst_dbfetch_object($query);
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."' AND ID = '".$_GET['ProjectID']."'");
! $project = ofirst_dbfetch_object($query);
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_tasks WHERE GroupID = '".$_GET['GroupID']."' AND ProjectID = '".$_GET['ProjectID']."' AND ID = '".$_GET['TaskID']."'");
! $task = ofirst_dbfetch_object($query);
?>
***************
*** 101,106 ****
// List the notes
! $query = mysql_query("SELECT * FROM ofirst_projects_notes WHERE GroupID = '".$_GET['GroupID']."' AND ProjectID = '".$_GET['ProjectID']."' AND TaskID = '".$_GET['TaskID']."'");
! while($notes = mysql_fetch_object($query)){
?>
--- 101,106 ----
// List the notes
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_notes WHERE GroupID = '".$_GET['GroupID']."' AND ProjectID = '".$_GET['ProjectID']."' AND TaskID = '".$_GET['TaskID']."'");
! while($notes = ofirst_dbfetch_object($query)){
?>
***************
*** 116,120 ****
// If no notes are present then display message
! if(mysql_num_rows($query) == 0){
echo "\n <tr>\n <td> </td>\n <td> </td>\n <td>There are no notes for this task!</td>\n <td> </td>\n </tr>\n";
}
--- 116,120 ----
// If no notes are present then display message
! if(ofirst_dbnum_rows($query) == 0){
echo "\n <tr>\n <td> </td>\n <td> </td>\n <td>There are no notes for this task!</td>\n <td> </td>\n </tr>\n";
}
Index: preferences.php
===================================================================
RCS file: /cvsroot/openfirst/projects/preferences.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** preferences.php 29 Aug 2003 15:50:35 -0000 1.5
--- preferences.php 30 Aug 2003 00:04:02 -0000 1.6
***************
*** 34,46 ****
// Check if user is a member
if(! ISSET($user->user)){
! showLogin();
}else{
// Save button process
if(ISSET($_POST['save'])){
! mysql_query("UPDATE ofirst_members SET
ProjectsUpdates = '".$_POST['updates']."',
ProjectsCommitSelect = '".$_POST['select']."',
! ProjectsSendTemplate = '".$_POST['template']."' WHERE user = '".$user->user."'") or die(mysql_error());
echo "<br><br><br>Your account options have been updated! [ <a href='preferences.php'>Preferences</a> ]<br><br><br>";
die(include($footer));
--- 34,46 ----
// Check if user is a member
if(! ISSET($user->user)){
! showlogin();
}else{
// Save button process
if(ISSET($_POST['save'])){
! ofirst_dbquery("UPDATE ofirst_members SET
ProjectsUpdates = '".$_POST['updates']."',
ProjectsCommitSelect = '".$_POST['select']."',
! ProjectsSendTemplate = '".$_POST['template']."' WHERE user = '".$user->user."'") or die(ofirst_dberror());
echo "<br><br><br>Your account options have been updated! [ <a href='preferences.php'>Preferences</a> ]<br><br><br>";
die(include($footer));
Index: projects.php
===================================================================
RCS file: /cvsroot/openfirst/projects/projects.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** projects.php 29 Aug 2003 15:50:35 -0000 1.5
--- projects.php 30 Aug 2003 00:04:02 -0000 1.6
***************
*** 34,38 ****
// Check if user is a member
if(! ISSET($user->user)){
! showLogin();
}else{
--- 34,38 ----
// Check if user is a member
if(! ISSET($user->user)){
! showlogin();
}else{
***************
*** 54,58 ****
// Create database record
! mysql_query("INSERT INTO ofirst_projects_projects SET
ProjectName = '".$_POST['projectname']."',
GroupID = '".$_GET['GroupID']."',
--- 54,58 ----
// Create database record
! ofirst_dbquery("INSERT INTO ofirst_projects_projects SET
ProjectName = '".$_POST['projectname']."',
GroupID = '".$_GET['GroupID']."',
***************
*** 62,66 ****
Assigned = '".$assign."',
TarDate = 'date',
! Dates = '".time()."'") or die(mysql_error());
echo "<br><br>Project created! [ <a href='projects.php?GroupID=".$_GET['GroupID']."'>Projects</a> ]<br><br>";
die(include($footer));
--- 62,66 ----
Assigned = '".$assign."',
TarDate = 'date',
! Dates = '".time()."'") or die(ofirst_dberror());
echo "<br><br>Project created! [ <a href='projects.php?GroupID=".$_GET['GroupID']."'>Projects</a> ]<br><br>";
die(include($footer));
***************
*** 77,83 ****
// Remove all values related to this project
! mysql_query("DELETE FROM ofirst_projects_projects WHERE ID = '".$_POST['project']."'") or die(mysql_error());
! mysql_query("DELETE FROM ofirst_projects_notes WHERE ProjectID = '".$_POST['project']."'") or die(mysql_error());
! mysql_query("DELETE FROM ofirst_projects_tasks WHERE ProjectID = '".$_POST['project']."'") or die(mysql_error());
echo "<br><br>Project removed! [ <a href='projects.php?GroupID=".$_GET['GroupID']."'>Projects</a> ]<br><br>";
die(include($footer));
--- 77,83 ----
// Remove all values related to this project
! ofirst_dbquery("DELETE FROM ofirst_projects_projects WHERE ID = '".$_POST['project']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_notes WHERE ProjectID = '".$_POST['project']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_tasks WHERE ProjectID = '".$_POST['project']."'") or die(ofirst_dberror());
echo "<br><br>Project removed! [ <a href='projects.php?GroupID=".$_GET['GroupID']."'>Projects</a> ]<br><br>";
die(include($footer));
***************
*** 86,91 ****
// Collect information about projects
! $query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
! $group = mysql_fetch_object($query);
?>
--- 86,91 ----
// Collect information about projects
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."' ORDER BY GroupName;");
! $group = ofirst_dbfetch_object($query);
?>
***************
*** 114,119 ****
// List current projects in database
! $query = mysql_query("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."'");
! while($projects = mysql_fetch_object($query)){
// If record is not pending then set pend value false
--- 114,119 ----
// List current projects in database
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."' ORDER BY GroupName;");
! while($projects = ofirst_dbfetch_object($query)){
// If record is not pending then set pend value false
***************
*** 123,128 ****
// If pend value of the pend project is 100 then set as false or else pend is true
! $projquery = mysql_query("SELECT * FROM ofirst_projects_projects WHERE ID = '".$projects->Pend."'");
! $pendproj = mysql_fetch_object($projquery);
if($pendproj->Completion == 100){
--- 123,128 ----
// If pend value of the pend project is 100 then set as false or else pend is true
! $projquery = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE ID = '".$projects->Pend."'");
! $pendproj = ofirst_dbfetch_object($projquery);
if($pendproj->Completion == 100){
***************
*** 176,180 ****
// Display no record response
! if(mysql_num_rows($query) == 0){
echo "\n <tr>\n <td> </td>\n <td> </td>\n <td> </td>\n <td>No new projects!</td>\n <td> </td>\n </tr>";
}
--- 176,180 ----
// Display no record response
! if(ofirst_dbnum_rows($query) == 0){
echo "\n <tr>\n <td> </td>\n <td> </td>\n <td> </td>\n <td>No new projects!</td>\n <td> </td>\n </tr>";
}
***************
*** 216,222 ****
<?php
! $query = mysql_query("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."'");
! while($projects = mysql_fetch_object($query)){
echo "<option value='".$projects->ID."'>".$projects->ProjectName."</option>";
}
--- 216,222 ----
<?php
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."'");
! while($projects = ofirst_dbfetch_object($query)){
echo "<option value='".$projects->ID."'>".$projects->ProjectName."</option>";
}
***************
*** 321,326 ****
// Display current member list from the assigned values
! $query = mysql_query("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."'");
! while($projects = mysql_fetch_object($query)){
echo "<option value='".$projects->ID."'>".$projects->ProjectName."</option>";
}
--- 321,326 ----
// Display current member list from the assigned values
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."'");
! while($projects = ofirst_dbfetch_object($query)){
echo "<option value='".$projects->ID."'>".$projects->ProjectName."</option>";
}
Index: tasks.php
===================================================================
RCS file: /cvsroot/openfirst/projects/tasks.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** tasks.php 29 Aug 2003 15:50:35 -0000 1.5
--- tasks.php 30 Aug 2003 00:04:02 -0000 1.6
***************
*** 56,60 ****
// Insert record into database
! mysql_query("INSERT INTO ofirst_projects_tasks SET
TaskName = '".$_POST['taskname']."',
GroupID = '".$_GET['GroupID']."',
--- 56,60 ----
// Insert record into database
! ofirst_dbquery("INSERT INTO ofirst_projects_tasks SET
TaskName = '".$_POST['taskname']."',
GroupID = '".$_GET['GroupID']."',
***************
*** 65,69 ****
Assigned = '".$assign."',
TarDate = '".$strdate."',
! Dates = '".time()."'") or die(mysql_error());
echo "<br><br>Task created! [ <a href='tasks.php?GroupID=".$_GET['GroupID']."&ProjectID=".$_GET['ProjectID']."'>Tasks</a> ]<br><br>";
--- 65,69 ----
Assigned = '".$assign."',
TarDate = '".$strdate."',
! Dates = '".time()."'") or die(ofirst_dberror());
echo "<br><br>Task created! [ <a href='tasks.php?GroupID=".$_GET['GroupID']."&ProjectID=".$_GET['ProjectID']."'>Tasks</a> ]<br><br>";
***************
*** 75,79 ****
// Update completion value in databaes
! mysql_query("UPDATE ofirst_projects_projects SET Completion = '".$_POST['completion']."' WHERE ID = '".$_GET['ProjectID']."'") or die(mysql_error());
echo "<br><br>Project completion changed to: ".$_POST['completion']."% [ <a href='projects.php?GroupID=".$_GET['GroupID']."'>Notes</a> ]<br><br>";
--- 75,79 ----
// Update completion value in databaes
! ofirst_dbquery("UPDATE ofirst_projects_projects SET Completion = '".$_POST['completion']."' WHERE ID = '".$_GET['ProjectID']."'") or die(ofirst_dberror());
echo "<br><br>Project completion changed to: ".$_POST['completion']."% [ <a href='projects.php?GroupID=".$_GET['GroupID']."'>Notes</a> ]<br><br>";
***************
*** 91,98 ****
// Remove every task related value in the database
! mysql_query("DELETE FROM ofirst_projects_tasks WHERE ID = '".$_POST['task']."'") or die(mysql_error());
! mysql_query("DELETE FROM ofirst_projects_notes WHERE TaskID = '".$_POST['task']."'") or die(mysql_error());
! mysql_query("DELETE FROM ofirst_projects_tasks WHERE TaskID = '".$_POST['task']."'") or die(mysql_error());
! mysql_query("DELETE FROM ofirst_projects_projects WHERE TaskID = '".$_POST['task']."'") or die(mysql_error());
echo "<br><br>Task removed! [ <a href='tasks.php?GroupID=".$_GET['GroupID']."&ProjectID=".$_GET['ProjectID']."'>Projects</a> ]<br><br>";
--- 91,98 ----
// Remove every task related value in the database
! ofirst_dbquery("DELETE FROM ofirst_projects_tasks WHERE ID = '".$_POST['task']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_notes WHERE TaskID = '".$_POST['task']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_tasks WHERE TaskID = '".$_POST['task']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_projects WHERE TaskID = '".$_POST['task']."'") or die(ofirst_dberror());
echo "<br><br>Task removed! [ <a href='tasks.php?GroupID=".$_GET['GroupID']."&ProjectID=".$_GET['ProjectID']."'>Projects</a> ]<br><br>";
***************
*** 102,110 ****
// Gather information to show the following tasks
! $query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
! $group = mysql_fetch_object($query);
! $query = mysql_query("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."' AND ID = '".$_GET['ProjectID']."'");
! $project = mysql_fetch_object($query);
?>
--- 102,110 ----
// Gather information to show the following tasks
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
! $group = ofirst_dbfetch_object($query);
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."' AND ID = '".$_GET['ProjectID']."' ORDER BY GroupName;");
! $project = ofirst_dbfetch_object($query);
?>
***************
*** 134,139 ****
// Run through the current tasks in the database related to this project and group
! $query = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE ProjectID = '".$_GET['ProjectID']."' AND GroupID = '".$_GET['GroupID']."'");
! while($tasks = mysql_fetch_object($query)){
// If a pend is not set then make value false
--- 134,139 ----
// Run through the current tasks in the database related to this project and group
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_tasks WHERE ProjectID = '".$_GET['ProjectID']."' AND GroupID = '".$_GET['GroupID']."'");
! while($tasks = ofirst_dbfetch_object($query)){
// If a pend is not set then make value false
***************
*** 143,148 ****
// If the value is true then find the value of the task its pending on
! $taskquery = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$tasks->Pend."'");
! $pendtask = mysql_fetch_object($taskquery);
// If the pend task is 100% then dont continue pend value
--- 143,148 ----
// If the value is true then find the value of the task its pending on
! $taskquery = ofirst_dbquery("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$tasks->Pend."'");
! $pendtask = ofirst_dbfetch_object($taskquery);
// If the pend task is 100% then dont continue pend value
***************
*** 202,206 ****
// If no values are found then output a response
! if(mysql_num_rows($query) == 0){
echo "\n <tr>\n <td> </td>\n <td> </td>\n <td> </td>\n <td>There are no tasks for this project!</td>\n <td> </td>";
}
--- 202,206 ----
// If no values are found then output a response
! if(ofirst_dbnum_rows($query) == 0){
echo "\n <tr>\n <td> </td>\n <td> </td>\n <td> </td>\n <td>There are no tasks for this project!</td>\n <td> </td>";
}
***************
*** 242,248 ****
<?php
! $query = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE GroupID = '".$_GET['GroupID']."' AND ProjectID = '".$_GET['ProjectID']."'");
! while($tasks = mysql_fetch_object($query)){
echo "<option value='".$tasks->ID."'>".$tasks->TaskName."</option>";
}
--- 242,248 ----
<?php
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_tasks WHERE GroupID = '".$_GET['GroupID']."' AND ProjectID = '".$_GET['ProjectID']."'");
! while($tasks = ofirst_dbfetch_object($query)){
echo "<option value='".$tasks->ID."'>".$tasks->TaskName."</option>";
}
***************
*** 342,347 ****
// View a list of tasks
! $query = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE GroupID = '".$_GET['GroupID']."' AND ProjectID = '".$_GET['ProjectID']."'");
! while($tasks = mysql_fetch_object($query)){
echo "<option value='".$tasks->ID."'>".$tasks->TaskName."</option>";
}
--- 342,347 ----
// View a list of tasks
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_tasks WHERE GroupID = '".$_GET['GroupID']."' AND ProjectID = '".$_GET['ProjectID']."'");
! while($tasks = ofirst_dbfetch_object($query)){
echo "<option value='".$tasks->ID."'>".$tasks->TaskName."</option>";
}
***************
*** 406,408 ****
}
include($footer);
! ?>
\ No newline at end of file
--- 406,408 ----
}
include($footer);
! ?>
Index: today.php
===================================================================
RCS file: /cvsroot/openfirst/projects/today.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** today.php 29 Aug 2003 15:50:35 -0000 1.2
--- today.php 30 Aug 2003 00:04:02 -0000 1.3
***************
*** 34,38 ****
// Check if user is a member
if(! ISSET($user->user)){
! showLogin();
}else{
--- 34,38 ----
// Check if user is a member
if(! ISSET($user->user)){
! showlogin();
}else{
***************
*** 122,127 ****
// Run through the current list of groups to preview there related information
! $groupquery = mysql_query("SELECT * FROM ofirst_projects_groups");
! while($group = mysql_fetch_object($groupquery)){
?>
--- 122,127 ----
// Run through the current list of groups to preview there related information
! $groupquery = ofirst_dbquery("SELECT * FROM ofirst_projects_groups ORDER BY GroupName;");
! while($group = ofirst_dbfetch_object($groupquery)){
?>
***************
*** 143,148 ****
// Listed the newly added projects for this day
! $projectquery = mysql_query("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$group->ID."'");
! while($project = mysql_fetch_object($projectquery)){
if($selectdate == date("F j, Y",$project->Dates)){
--- 143,148 ----
// Listed the newly added projects for this day
! $projectquery = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$group->ID."' ORDER BY GroupName");
! while($project = ofirst_dbfetch_object($projectquery)){
if($selectdate == date("F j, Y",$project->Dates)){
***************
*** 163,171 ****
// List the newly added tasks for this day
! $taskquery = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE GroupID = '".$group->ID."'");
! while($task = mysql_fetch_object($taskquery)){
! $taskprojquery = mysql_query("SELECT ProjectName FROM ofirst_projects_projects WHERE ID = '".$task->ProjectID."'");
! $taskproject = mysql_fetch_object($taskprojquery);
if($selectdate == date("F j, Y",$task->Dates)){
--- 163,171 ----
// List the newly added tasks for this day
! $taskquery = ofirst_dbquery("SELECT * FROM ofirst_projects_tasks WHERE GroupID = '".$group->ID."'");
! while($task = ofirst_dbfetch_object($taskquery)){
! $taskprojquery = ofirst_dbquery("SELECT ProjectName FROM ofirst_projects_projects WHERE ID = '".$task->ProjectID."' ORDER BY ProjectName;");
! $taskproject = ofirst_dbfetch_object($taskprojquery);
if($selectdate == date("F j, Y",$task->Dates)){
***************
*** 186,197 ****
// List the newly added notes for this day
! $notequery = mysql_query("SELECT * FROM ofirst_projects_notes WHERE GroupID = '".$group->ID."'");
! while($note = mysql_fetch_object($notequery)){
! $noteprojquery = mysql_query("SELECT ProjectName FROM ofirst_projects_projects WHERE ID = '".$note->ProjectID."'");
! $noteproject = mysql_fetch_object($noteprojquery);
! $notetasquery = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$note->TaskID."'");
! $notetask = mysql_fetch_object($notetasquery);
if($selectdate == date("F j, Y",$note->Dates)){
--- 186,197 ----
// List the newly added notes for this day
! $notequery = ofirst_dbquery("SELECT * FROM ofirst_projects_notes WHERE GroupID = '".$group->ID."'");
! while($note = ofirst_dbfetch_object($notequery)){
! $noteprojquery = ofirst_dbquery("SELECT ProjectName FROM ofirst_projects_projects WHERE ID = '".$note->ProjectID."'");
! $noteproject = ofirst_dbfetch_object($noteprojquery);
! $notetasquery = ofirst_dbquery("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$note->TaskID."'");
! $notetask = ofirst_dbfetch_object($notetasquery);
if($selectdate == date("F j, Y",$note->Dates)){
***************
*** 217,219 ****
}
include($footer);
! ?>
\ No newline at end of file
--- 217,219 ----
}
include($footer);
! ?>
Index: viewmeeting.php
===================================================================
RCS file: /cvsroot/openfirst/projects/viewmeeting.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** viewmeeting.php 29 Aug 2003 15:50:35 -0000 1.2
--- viewmeeting.php 30 Aug 2003 00:04:02 -0000 1.3
***************
*** 34,38 ****
// Check if user is a member
if(! ISSET($user->user)){
! showLogin();
}else{
--- 34,38 ----
// Check if user is a member
if(! ISSET($user->user)){
! showlogin();
}else{
***************
*** 54,61 ****
// Update information in the database
! mysql_query("UPDATE ofirst_projects_meetings SET
Notes = '".$_POST['notes']."',
AbsentList = '$absentlist',
! Status = 'done' WHERE ID = '".$_GET['ID']."'") or die(mysql_error());
echo "<br><br>Meeting updated! [ <a href='meetings.php'>Meetings</a> ]<br><br>";
die(include($footer));
--- 54,61 ----
// Update information in the database
! ofirst_dbquery("UPDATE ofirst_projects_meetings SET
Notes = '".$_POST['notes']."',
AbsentList = '$absentlist',
! Status = 'done' WHERE ID = '".$_GET['ID']."'") or die(ofirst_dberror());
echo "<br><br>Meeting updated! [ <a href='meetings.php'>Meetings</a> ]<br><br>";
die(include($footer));
***************
*** 63,68 ****
// Collect information for the current meeting
! $query = mysql_query("SELECT * FROM ofirst_projects_meetings WHERE ID = '".$_GET['ID']."'");
! $meeting = mysql_fetch_object($query);
?>
--- 63,68 ----
// Collect information for the current meeting
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_meetings WHERE ID = '".$_GET['ID']."'");
! $meeting = ofirst_dbfetch_object($query);
?>
***************
*** 85,90 ****
$assign = explode(",",$meeting->ArrangedFor);
foreach($assign as $assign){
! $query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$assign."'");
! $group = mysql_fetch_object($query);
echo "<br>".$group->GroupName;
}
--- 85,90 ----
$assign = explode(",",$meeting->ArrangedFor);
foreach($assign as $assign){
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$assign."' ORDER BY GroupName;");
! $group = ofirst_dbfetch_object($query);
echo "<br>".$group->GroupName;
}
***************
*** 144,149 ****
// Run through the groups and find values
! $query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$assign."'");
! $group = mysql_fetch_object($query);
$people = explode(",",$group->Members);
--- 144,149 ----
// Run through the groups and find values
! $query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$assign."'");
! $group = ofirst_dbfetch_object($query);
$people = explode(",",$group->Members);
|
|
From: <xt...@us...> - 2003-08-30 00:04:07
|
Update of /cvsroot/openfirst/projects/setup In directory sc8-pr-cvs1:/tmp/cvs-serv7756/setup Added Files: setup.mssql Log Message: Add multiple database support, alphabetical ordering of group names and user names --- NEW FILE: setup.mssql --- CREATE TABLE `ofirst_projects_groups` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `GroupName` tinytext, `Description` text, `Moderators` tinytext, `Members` tinytext, `Dates` text, PRIMARY KEY (`ID`)) TYPE=MyISAM; CREATE TABLE `ofirst_projects_meetings` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `Dates` text, `ForDate` text, `Description` text, `ArrangedFor` text, `AbsentList` text, `Notes` text, `Status` text, PRIMARY KEY (`ID`)) TYPE=MyISAM; CREATE TABLE `ofirst_projects_notes` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `ProjectID` tinyint(8) default NULL, `GroupID` tinyint(8) default NULL, `TaskID` tinyint(8) default NULL, `Description` tinytext, `Commiter` tinytext, `Dates` text, PRIMARY KEY (`ID`)) TYPE=MyISAM; CREATE TABLE `ofirst_projects_projects` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `ProjectName` tinytext, `GroupID` tinyint(3) default '0', `Completion` tinytext, `Description` text, `Assigned` text, `TarDate` text, `Dates` text, `Pend` tinytext, PRIMARY KEY (`ID`)) TYPE=MyISAM; CREATE TABLE `ofirst_projects_tasks` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `TaskName` text, `ProjectID` tinytext, `GroupID` tinytext, `DateAssigned` text, `TarDate` text, `Description` text, `Assigned` text, `Dates` text, `Completion` tinytext, `Pend` text, PRIMARY KEY (`ID`)) TYPE=MyISAM; INSERT INTO ofirst_config SET includes='',modulename='projects',showonmenu='0',active='0',modulenavigation='<a href="$basepath/projects/groups.php">Action Register</a> | <a href="$basepath/projects/mytask.php">My Tasks</a> | <a href="$basepath/projects/preferences.php">Preferences</a> | <a href="$basepath/projects/meetings.php">Meetings</a> | <a href="$basepath/projects/today.php">Todays Changes</a>'; ALTER TABLE ofirst_members ADD COLUMN ProjectsFrequency tinytext ALTER TABLE ofirst_members ADD COLUMN ProjectsSendCountDown tinytext ALTER TABLE ofirst_members ADD COLUMN ProjectsCommitSelect tinytext ALTER TABLE ofirst_members ADD COLUMN ProjectsSendTemplate tinytext |
Update of /cvsroot/openfirst/projects
In directory sc8-pr-cvs1:/tmp/cvs-serv4859
Modified Files:
groups.php index.php meetings.php mytask.php notes.php
preferences.php projects.php tasks.php today.php
viewmeeting.php
Log Message:
Minor audit commits. Some bugs/suggestions from Tim have also been changed.
Index: groups.php
===================================================================
RCS file: /cvsroot/openfirst/projects/groups.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** groups.php 27 Aug 2003 12:58:06 -0000 1.4
--- groups.php 29 Aug 2003 15:50:35 -0000 1.5
***************
*** 27,36 ****
--- 27,45 ----
*/
+ // Include globals and set header condense (not coded yet)
include("../config/globals.php");
$header_condense = true;
include($header);
+
+ // Check if user is a member
+ if(! ISSET($user->user)){
+ showLogin();
+ }else{
+
+ // Create button process
if(ISSET($_POST['create'])){
+ // Check if any assigned members have been added
if(! ISSET($_POST['members'])){
echo "<br><br>You must assign users to this task! Click back to continue.<br><br><br>";
***************
*** 38,41 ****
--- 47,51 ----
}
+ // Check if any assigned moderators have been added
if(! ISSET($_POST['moderators'])){
echo "<br><br>You must assign users to this task! Click back to continue.<br><br><br>";
***************
*** 43,58 ****
}
! if(is_array($_POST['moderators'])){
! $modera = implode(",",$_POST['moderators']);
! }else{
! $modera = $_POST['moderators'];
! }
! if(is_array($_POST['members'])){
! $mem = implode(",",$_POST['members']);
! }else{
! $mem = $_POST['members'];
! }
mysql_query("INSERT INTO ofirst_projects_groups SET
GroupName = '".$_POST['groupname']."',
--- 53,71 ----
}
! // Check if the value has come as a single value or array then use appropriate value in modera variable
! if(is_array($_POST['moderators'])){
! $modera = implode(",",$_POST['moderators']);
! }else{
! $modera = $_POST['moderators'];
! }
! // Check if the value has come as a single value or array then use appropriate value in mem variable
! if(is_array($_POST['members'])){
! $mem = implode(",",$_POST['members']);
! }else{
! $mem = $_POST['members'];
! }
+ // Insert data into the database
mysql_query("INSERT INTO ofirst_projects_groups SET
GroupName = '".$_POST['groupname']."',
***************
*** 65,70 ****
--- 78,85 ----
}
+ // Remove button process
if(ISSET($_POST['remove'])){
+ // If the confirmation button is selected then remove all group data
if(! ISSET($_POST['confirm'])){
echo "<br><br>Your request to remove the group was denied because you have not confirmed! [ <a href='groups.php'>Groups</a> ]<br><br>";
***************
*** 72,75 ****
--- 87,91 ----
}
+ // Remove data from every table that is related
mysql_query("DELETE FROM ofirst_projects_groups WHERE ID = '".$_POST['group']."'") or die(mysql_error());
mysql_query("DELETE FROM ofirst_projects_notes WHERE GroupID = '".$_POST['group']."'") or die(mysql_error());
***************
*** 107,113 ****
</tr>
<?php
- $query = mysql_query("SELECT * FROM ofirst_projects_groups");
- while($groups = mysql_fetch_object($query)){
?>
<tr <?php if(date("F j, Y",time()) == date("F j, Y",$groups->Dates)){ echo "bgColor='#CCCCCC'"; } ?> onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'" bgcolor="#ffffff">
--- 123,131 ----
</tr>
<?php
+
+ // Query the current group values and loop through them
+ $query = mysql_query("SELECT * FROM ofirst_projects_groups");
+ while($groups = mysql_fetch_object($query)){
?>
<tr <?php if(date("F j, Y",time()) == date("F j, Y",$groups->Dates)){ echo "bgColor='#CCCCCC'"; } ?> onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'" bgcolor="#ffffff">
***************
*** 135,141 ****
</table>
<br>
- <?php
- if(ISSET($user->user)){
- ?>
<form action='groups.php' method='POST'>
<table width="39%">
--- 153,156 ----
Index: index.php
===================================================================
RCS file: /cvsroot/openfirst/projects/index.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** index.php 27 Aug 2003 12:58:07 -0000 1.5
--- index.php 29 Aug 2003 15:50:35 -0000 1.6
***************
*** 26,30 ****
*
*/
!
! header("Location:groups.php");
?>
--- 26,47 ----
*
*/
!
! // Include globals and set header condense (not coded yet)
! include("../config/globals.php");
! $header_condense = true;
! include($header);
!
! if(! ISSET($user->user)){
! ?>
! <p> </p>
! <p>Welcome to the projects module! Only team members are able to access the projects
! module.<br>
! Please use the login form below this:</p>
! <?php
! showLogin();
! }else{
! echo "<p> </p><p>Welcome ".$user->user.", thank you for loggin in!<br><br>";
! }
! include($footer);
!
?>
Index: meetings.php
===================================================================
RCS file: /cvsroot/openfirst/projects/meetings.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** meetings.php 27 Aug 2003 12:58:07 -0000 1.1
--- meetings.php 29 Aug 2003 15:50:35 -0000 1.2
***************
*** 26,41 ****
*
*/
!
include("../config/globals.php");
$header_condense = true;
include($header);
! if(ISSET($_POST['create'])){
! if(! ISSET($_POST['assign'])){
! echo "<br><br>You must assign an arranged for field to this meeting! Click back to continue.<br><br><br>";
! die(include($footer));
! }
if(is_array($_POST['assign'])){
$assign = implode(",",$_POST['assign']);
--- 26,50 ----
*
*/
!
! // Include globals and set header condense (not coded yet)
include("../config/globals.php");
$header_condense = true;
include($header);
! // Check if user is a member
! if(! ISSET($user->user)){
! showLogin();
! }else{
! // Create button process
! if(ISSET($_POST['create'])){
+ // Check if members have been assigned to the meeting
+ if(! ISSET($_POST['assign'])){
+ echo "<br><br>You must assign an arranged for field to this meeting! Click back to continue.<br><br><br>";
+ die(include($footer));
+ }
+
+ // Check if assign is a single value or array then give variable a value
if(is_array($_POST['assign'])){
$assign = implode(",",$_POST['assign']);
***************
*** 43,49 ****
$assign = $_POST['assign'];
}
!
$fordate = strtotime($_POST['month']." ".$_POST['day'].",".$_POST['year']." ".$_POST['hour'].":".$_POST['minute']." ".$_POST['ampm']);
mysql_query("INSERT INTO ofirst_projects_meetings SET
ForDate = '".$fordate."',
--- 52,60 ----
$assign = $_POST['assign'];
}
!
! // Collect date and combine it
$fordate = strtotime($_POST['month']." ".$_POST['day'].",".$_POST['year']." ".$_POST['hour'].":".$_POST['minute']." ".$_POST['ampm']);
+ // Put value into database
mysql_query("INSERT INTO ofirst_projects_meetings SET
ForDate = '".$fordate."',
***************
*** 57,67 ****
}
if(ISSET($_POST['remove'])){
if(! ISSET($_POST['confirm'])){
echo "<br><br>Your request to remove the project was denied because you have not confirmed! [ <a href='projects.php?GroupID=".$_GET['GroupID']."'>Projects</a> ]<br><br>";
die(include($footer));
}
!
mysql_query("DELETE FROM ofirst_projects_meetings WHERE ID = '".$_POST['project']."'") or die(mysql_error());
echo "<br><br>Meetings removed! [ <a href='meetings.php'>Meetings</a> ]<br><br>";
--- 68,81 ----
}
+ // Remove button process
if(ISSET($_POST['remove'])){
+ // If remove process is confirmed
if(! ISSET($_POST['confirm'])){
echo "<br><br>Your request to remove the project was denied because you have not confirmed! [ <a href='projects.php?GroupID=".$_GET['GroupID']."'>Projects</a> ]<br><br>";
die(include($footer));
}
!
! // Remove meeting information
mysql_query("DELETE FROM ofirst_projects_meetings WHERE ID = '".$_POST['project']."'") or die(mysql_error());
echo "<br><br>Meetings removed! [ <a href='meetings.php'>Meetings</a> ]<br><br>";
***************
*** 85,90 ****
--- 99,107 ----
</tr>
<?php
+
+ // Check for meetings that have not passed yet
$meetquery = mysql_query("SELECT * FROM ofirst_projects_meetings WHERE Status='wait'");
while($meeting = mysql_fetch_object($meetquery)){
+
?>
<tr>
***************
*** 100,103 ****
--- 117,121 ----
echo "<br>".$group->GroupName;
}
+
?>
</td>
***************
*** 105,111 ****
--- 123,132 ----
<?php
}
+
+ // If there are no values then output a no value message
if(mysql_num_rows($meetquery) == 0){
echo "<tr><td> </td><td> </td><td>There are no planned meetings!</td><td> </td></tr>";
}
+
?>
</table>
***************
*** 123,128 ****
--- 144,152 ----
</tr>
<?php
+
+ // Check for passed meetings and preview them
$query = mysql_query("SELECT * FROM ofirst_projects_meetings WHERE Status='done'");
while($meeting = mysql_fetch_object($query)){
+
?>
<tr>
***************
*** 138,141 ****
--- 162,166 ----
echo $group->GroupName;
}
+
?>
</td>
***************
*** 143,149 ****
--- 168,177 ----
<?php
}
+
+ // If there are no values then output a message
if(mysql_num_rows($query) == 0){
echo "<tr><td> </td><td> </td><td>There are no past meetings!</td><td> </td></tr>";
}
+
?>
</table>
***************
*** 159,163 ****
<div align="right">Description:</div></td>
<td>
! <?php
if (function_exists("make_wysiwyg")) {
make_wysiwyg("description",500,255,"");
--- 187,193 ----
<div align="right">Description:</div></td>
<td>
! <?php
!
! // If the WYSIWYG function is set then use the WYSIWYG module
if (function_exists("make_wysiwyg")) {
make_wysiwyg("description",500,255,"");
***************
*** 165,168 ****
--- 195,199 ----
echo "<textarea name='description'></textarea>";
}
+
?>
</td>
***************
*** 246,253 ****
--- 277,287 ----
<select name="assign[]" width='40' size="6" multiple id="assign">
<?php
+
+ // Output a list of current groups
$query = mysql_query("SELECT * FROM ofirst_projects_groups");
while($group = mysql_fetch_object($query)){
echo "<option value='".$group->ID."'>".$group->GroupName."</option>";
}
+
?>
</select>
***************
*** 266,273 ****
<td><div align="right">Meeting Date:</div></td>
<td><select name="project" id="project">
! <?php
$query = mysql_query("SELECT * FROM ofirst_projects_meetings");
-
while($meeting = mysql_fetch_object($query)){
echo "<option value='".$meeting->ID."'>".date("F j, Y h:i a",$meeting->ForDate)."</option>";
--- 300,307 ----
<td><div align="right">Meeting Date:</div></td>
<td><select name="project" id="project">
! <?php
+ // Output a list of meetings by date
$query = mysql_query("SELECT * FROM ofirst_projects_meetings");
while($meeting = mysql_fetch_object($query)){
echo "<option value='".$meeting->ID."'>".date("F j, Y h:i a",$meeting->ForDate)."</option>";
***************
*** 290,292 ****
</table>
<br>
! <?php include($footer); ?>
--- 324,330 ----
</table>
<br>
! <?php
!
! }
! include($footer);
! ?>
\ No newline at end of file
Index: mytask.php
===================================================================
RCS file: /cvsroot/openfirst/projects/mytask.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** mytask.php 27 Aug 2003 12:58:07 -0000 1.1
--- mytask.php 29 Aug 2003 15:50:35 -0000 1.2
***************
*** 27,33 ****
--- 27,40 ----
*/
+ // // Include globals and set header condense (not coded yet)
include("../config/globals.php");
$header_condense = true;
include($header);
+
+ // Check if user is a member
+ if(! ISSET($user->user)){
+ showLogin();
+ }else{
+
?>
<h2>My Tasks Summarized</h2>
***************
*** 50,55 ****
<?php
!
!
$query = mysql_query("SELECT * FROM ofirst_projects_tasks");
while($tasks = mysql_fetch_object($query)){
--- 57,61 ----
<?php
! // Run through the current tasks
$query = mysql_query("SELECT * FROM ofirst_projects_tasks");
while($tasks = mysql_fetch_object($query)){
***************
*** 65,69 ****
if($showtask){
!
if($tasks->Pend == "none"){
$pend = false;
--- 71,76 ----
if($showtask){
!
! // If value is pending then select the proper information
if($tasks->Pend == "none"){
$pend = false;
***************
*** 84,87 ****
--- 91,96 ----
<td><a href="notes.php?GroupID=<?php echo $_GET['GroupID']; ?>&TaskID=<?php echo $tasks->ID; ?>&ProjectID=<?php echo $_GET['ProjectID']; ?>">
<?php
+
+ // If value is pending then show pend graphics
if($pend){
echo "<img src='../members/icons/actions/encrypted.png' border='0'>";
***************
*** 89,92 ****
--- 98,102 ----
echo "<a href='notes.php?GroupID=".$tasks->GroupID."&TaskID=".$tasks->ID."&ProjectID=".$tasks->ProjectID."'><img src='../members/icons/filesystems/desktop.png' border='0'></a>";
}
+
?>
</a></td>
***************
*** 120,122 ****
</table>
<br>
! <?php include($footer); ?>
--- 130,136 ----
</table>
<br>
! <?php
!
! }
! include($footer);
! ?>
\ No newline at end of file
Index: notes.php
===================================================================
RCS file: /cvsroot/openfirst/projects/notes.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** notes.php 27 Aug 2003 12:58:07 -0000 1.4
--- notes.php 29 Aug 2003 15:50:35 -0000 1.5
***************
*** 27,34 ****
--- 27,39 ----
*/
+ //
include("../config/globals.php");
$header_condense = true;
include($header);
+ // If the user is logged in
+ if(ISSET($user->user)){
+
+ // Create button process
if(ISSET($_POST['create'])){
mysql_query("INSERT INTO ofirst_projects_notes SET
***************
*** 44,47 ****
--- 49,53 ----
}
+ // Addcompletion button process
if(ISSET($_POST['addcompletion'])){
mysql_query("INSERT INTO ofirst_projects_notes SET
***************
*** 59,62 ****
--- 65,69 ----
}
+ // Get information related to these notes
$query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
$group = mysql_fetch_object($query);
***************
*** 91,96 ****
<td width="15%">Commiter</td>
</tr>
! <?php
$query = mysql_query("SELECT * FROM ofirst_projects_notes WHERE GroupID = '".$_GET['GroupID']."' AND ProjectID = '".$_GET['ProjectID']."' AND TaskID = '".$_GET['TaskID']."'");
while($notes = mysql_fetch_object($query)){
--- 98,104 ----
<td width="15%">Commiter</td>
</tr>
! <?php
+ // List the notes
$query = mysql_query("SELECT * FROM ofirst_projects_notes WHERE GroupID = '".$_GET['GroupID']."' AND ProjectID = '".$_GET['ProjectID']."' AND TaskID = '".$_GET['TaskID']."'");
while($notes = mysql_fetch_object($query)){
***************
*** 107,110 ****
--- 115,119 ----
}
+ // If no notes are present then display message
if(mysql_num_rows($query) == 0){
echo "\n <tr>\n <td> </td>\n <td> </td>\n <td>There are no notes for this task!</td>\n <td> </td>\n </tr>\n";
***************
*** 113,117 ****
</table>
<?php
! if(ISSET($user->user)){
$allowed = explode(",",$task->Assigned);
$show = false;
--- 122,127 ----
</table>
<?php
!
! // If current user is a member of this task then allow him to add/edit a note
$allowed = explode(",",$task->Assigned);
$show = false;
***************
*** 134,138 ****
<td valign="top"> <div align="right">Description: </div></td>
<td>
! <?php
if (function_exists("make_wysiwyg")) {
make_wysiwyg("description",500,255,"");
--- 144,150 ----
<td valign="top"> <div align="right">Description: </div></td>
<td>
! <?php
!
! // If the WYSIWYG function is set then display the WYSIWYG box
if (function_exists("make_wysiwyg")) {
make_wysiwyg("description",500,255,"");
***************
*** 140,143 ****
--- 152,156 ----
echo "<textarea name='description'></textarea>";
}
+
?>
</td>
***************
*** 188,194 ****
</table>
</form>
! <?php } } ?>
! <br>
! <br>
! <?php include($footer); ?>
! <p> </p>
\ No newline at end of file
--- 201,208 ----
</table>
</form>
! <?php
!
! }
! }
! include($footer);
! ?>
\ No newline at end of file
Index: preferences.php
===================================================================
RCS file: /cvsroot/openfirst/projects/preferences.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** preferences.php 27 Aug 2003 12:58:07 -0000 1.4
--- preferences.php 29 Aug 2003 15:50:35 -0000 1.5
***************
*** 27,34 ****
--- 27,41 ----
*/
+ // Include globals and set header condense (not coded yet)
include("../config/globals.php");
$header_condense = true;
include($header);
+ // Check if user is a member
+ if(! ISSET($user->user)){
+ showLogin();
+ }else{
+
+ // Save button process
if(ISSET($_POST['save'])){
mysql_query("UPDATE ofirst_members SET
***************
*** 39,48 ****
die(include($footer));
}
?>
<h2><font face="Verdana, Arial, Helvetica, sans-serif">Preferences</font><br>
</h2>
<form action='preferences.php' method='POST'>
! <table width="470" align="center">
! <tr>
<th>Update Mailer</th>
</tr>
--- 46,56 ----
die(include($footer));
}
+
?>
<h2><font face="Verdana, Arial, Helvetica, sans-serif">Preferences</font><br>
</h2>
<form action='preferences.php' method='POST'>
! <table width="527" align="center">
! <tr>
<th>Update Mailer</th>
</tr>
***************
*** 60,89 ****
</select>
</font></p>
! <p align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">What
! data would you like to be updated on?
! <select name="select" id="select">
! <option selected><?php echo $user->ProjectsCommitSelect; ?></option>
! <option>-----</option>
! <option>Related</option>
! <option>All</option>
! </select>
</font></p>
! <p align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">When
! would you like them to be sent?
! <select name="template" id="template">
! <option selected><?php echo $user->ProjectsSendTemplate; ?></option>
! <option>-----</option>
! <option value="Basic" >Basic Updates</option>
! <option value="Detailed">Detailed Updates</option>
! </select>
</font></p>
! <p align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
! <input name="save" type="submit" id="save" value="Save Preferences">
! <br>
! </font></p></td>
</tr>
</table>
</form>
! <p>
! <?php include($footer); ?>
! </p>
--- 68,100 ----
</select>
</font></p>
! <p align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">What
! kind of updates would you like to be sent?
! <select name="template" id="template">
! <option selected><?php echo $user->ProjectsSendTemplate; ?></option>
! <option>-----</option>
! <option value="Basic" >Basic Updates</option>
! <option value="Detailed">Detailed Updates</option>
! </select>
</font></p>
! <p align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">What
! kind of updates would you like to be sent?
! <select name="select" id="select">
! <option selected><?php echo $user->ProjectsCommitSelect; ?></option>
! <option>-----</option>
! <option>Related</option>
! <option>All</option>
! </select>
</font></p>
! <p align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
! <input name="save" type="submit" id="save" value="Save Preferences">
! <br>
! </font></p></td>
</tr>
</table>
</form>
! <?php
!
! }
! include($footer);
!
! ?>
\ No newline at end of file
Index: projects.php
===================================================================
RCS file: /cvsroot/openfirst/projects/projects.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** projects.php 27 Aug 2003 12:58:07 -0000 1.4
--- projects.php 29 Aug 2003 15:50:35 -0000 1.5
***************
*** 27,36 ****
--- 27,44 ----
*/
+ // Include globals and set header condense (not coded yet)
include("../config/globals.php");
$header_condense = true;
include($header);
+ // Check if user is a member
+ if(! ISSET($user->user)){
+ showLogin();
+ }else{
+
+ // Create project button process
if(ISSET($_POST['create'])){
+ // Check if members are assigned
if(! ISSET($_POST['assign'])){
echo "<br><br>You must assign users to this task! Click back to continue.<br><br><br>";
***************
*** 38,41 ****
--- 46,50 ----
}
+ // Check if value is single or array then give it a value for the database insert
if(is_array($_POST['assign'])){
$assign = implode(",",$_POST['assign']);
***************
*** 44,47 ****
--- 53,57 ----
}
+ // Create database record
mysql_query("INSERT INTO ofirst_projects_projects SET
ProjectName = '".$_POST['projectname']."',
***************
*** 58,62 ****
!
if(ISSET($_POST['remove'])){
--- 68,72 ----
! // Remove button process
if(ISSET($_POST['remove'])){
***************
*** 66,69 ****
--- 76,80 ----
}
+ // Remove all values related to this project
mysql_query("DELETE FROM ofirst_projects_projects WHERE ID = '".$_POST['project']."'") or die(mysql_error());
mysql_query("DELETE FROM ofirst_projects_notes WHERE ProjectID = '".$_POST['project']."'") or die(mysql_error());
***************
*** 74,77 ****
--- 85,89 ----
}
+ // Collect information about projects
$query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
$group = mysql_fetch_object($query);
***************
*** 101,111 ****
--- 113,126 ----
<?php
+ // List current projects in database
$query = mysql_query("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."'");
while($projects = mysql_fetch_object($query)){
+ // If record is not pending then set pend value false
if($projects->Pend == "none"){
$pend = false;
}else{
+ // If pend value of the pend project is 100 then set as false or else pend is true
$projquery = mysql_query("SELECT * FROM ofirst_projects_projects WHERE ID = '".$projects->Pend."'");
$pendproj = mysql_fetch_object($projquery);
***************
*** 123,132 ****
--- 138,151 ----
<?php
+ // If project completion is 100 then display completion graphic
if($projects->Completion == "100"){
echo "<a href='tasks.php?GroupID=".$_GET['GroupID']."&ProjectID=".$projects->ID."'><img src='../members/icons/actions/button_ok.png' border='0'></a>";
+
+ // If project is closed then display closed graphic
}elseif($projects->Completion == "CLOSE"){
echo "<a href='tasks.php?GroupID=".$_GET['GroupID']."&ProjectID=".$projects->ID."'><img src='../members/icons/actions/button_cancel.png' border='0'></a>";
}else{
+ // Decide on graphic depending on the value of pend
if($pend){
echo "<img src='../members/icons/actions/encrypted.png' border='0'>";
***************
*** 134,139 ****
echo "<a href='tasks.php?GroupID=".$_GET['GroupID']."&ProjectID=".$projects->ID."'><img src='../members/icons/actions/project_open.png' border='0'></a>";
}
! }
! ?>
</td>
<td>
--- 153,159 ----
echo "<a href='tasks.php?GroupID=".$_GET['GroupID']."&ProjectID=".$projects->ID."'><img src='../members/icons/actions/project_open.png' border='0'></a>";
}
! }
!
! ?>
</td>
<td>
***************
*** 155,158 ****
--- 175,179 ----
}
+ // Display no record response
if(mysql_num_rows($query) == 0){
echo "\n <tr>\n <td> </td>\n <td> </td>\n <td> </td>\n <td>No new projects!</td>\n <td> </td>\n </tr>";
***************
*** 163,167 ****
<br>
<?php
! if(ISSET($user->user)){
$allowed = explode(",",$group->Members);
$show = false;
--- 184,189 ----
<br>
<?php
!
! // Check if the current use is apart of this particular group then allow him to add/edit the project
$allowed = explode(",",$group->Members);
$show = false;
***************
*** 192,196 ****
<td><select name="pend" id="pend">
<option selected>none</option>
! <?php
$query = mysql_query("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."'");
--- 214,218 ----
<td><select name="pend" id="pend">
<option selected>none</option>
! <?php
$query = mysql_query("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."'");
***************
*** 268,277 ****
<td><div align="right">Assign:</div></td>
<td><p>
! <select name="assign[]" width='40' size="6" multiple id="assign">
! <?php
$assigned = explode(",",$group->Members);
foreach($assigned as $assign){
echo "<option>".$assign."</option>";
}
?>
</select>
--- 290,302 ----
<td><div align="right">Assign:</div></td>
<td><p>
! <select name="assign[]" width='40' size="6" multiple id="assign">
! <?php
!
! // Explode members and display the names
$assigned = explode(",",$group->Members);
foreach($assigned as $assign){
echo "<option>".$assign."</option>";
}
+
?>
</select>
***************
*** 293,300 ****
<td><div align="right">Project Name:</div></td>
<td><select name="project" id="project">
! <?php
$query = mysql_query("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."'");
-
while($projects = mysql_fetch_object($query)){
echo "<option value='".$projects->ID."'>".$projects->ProjectName."</option>";
--- 318,325 ----
<td><div align="right">Project Name:</div></td>
<td><select name="project" id="project">
! <?php
+ // Display current member list from the assigned values
$query = mysql_query("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$_GET['GroupID']."'");
while($projects = mysql_fetch_object($query)){
echo "<option value='".$projects->ID."'>".$projects->ProjectName."</option>";
***************
*** 317,322 ****
</table>
</form>
! <?php } } ?>
! <p>
! <?php include($footer); ?>
! </p>
--- 342,351 ----
</table>
</form>
! <?php
!
! }
! }
!
! include($footer);
!
! ?>
Index: tasks.php
===================================================================
RCS file: /cvsroot/openfirst/projects/tasks.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** tasks.php 27 Aug 2003 12:58:07 -0000 1.4
--- tasks.php 29 Aug 2003 15:50:35 -0000 1.5
***************
*** 27,41 ****
*/
include("../config/globals.php");
$header_condense = true;
include($header);
if(ISSET($_POST['create'])){
! if(! ISSET($_POST['assign'])){
! echo "<br><br>You must assign users to this project! Click back to continue.<br><br><br>";
! die(include($footer));
! }
if(is_array($_POST['assign'])){
$assign = implode(",",$_POST['assign']);
--- 27,48 ----
*/
+ // Include globals and set header condense (not coded yet)
include("../config/globals.php");
$header_condense = true;
include($header);
+ // If the user is logged in
+ if(ISSET($user->user)){
+
+ // Create button process
if(ISSET($_POST['create'])){
! // Check if users have been assigned to the task
! if(! ISSET($_POST['assign'])){
! echo "<br><br>You must assign users to this project! Click back to continue.<br><br><br>";
! die(include($footer));
! }
+ // Check if value is single or array then give assign a value for the database insert
if(is_array($_POST['assign'])){
$assign = implode(",",$_POST['assign']);
***************
*** 44,50 ****
--- 51,59 ----
}
+ // Combine the date that the user selected to put in the database
$strdate = $_POST['month']." ".$_POST['day'].",".$_POST['year'];
$strdate = strtotime($strdate);
+ // Insert record into database
mysql_query("INSERT INTO ofirst_projects_tasks SET
TaskName = '".$_POST['taskname']."',
***************
*** 62,84 ****
}
if(ISSET($_POST['addcompletion'])){
mysql_query("UPDATE ofirst_projects_projects SET Completion = '".$_POST['completion']."' WHERE ID = '".$_GET['ProjectID']."'") or die(mysql_error());
echo "<br><br>Project completion changed to: ".$_POST['completion']."% [ <a href='projects.php?GroupID=".$_GET['GroupID']."'>Notes</a> ]<br><br>";
die(include($footer));
! }
if(ISSET($_POST['remove'])){
! if(! ISSET($_POST['confirm'])){
! echo "<br><br>Your request to remove the task was denied because you have not confirmed! [ <a href='tasks.php?GroupID=".$_GET['GroupID']."&ProjectID=".$_GET['ProjectID']."'>Tasks</a> ]<br><br>";
! die(include($footer));
! }
mysql_query("DELETE FROM ofirst_projects_tasks WHERE ID = '".$_POST['task']."'") or die(mysql_error());
mysql_query("DELETE FROM ofirst_projects_notes WHERE TaskID = '".$_POST['task']."'") or die(mysql_error());
mysql_query("DELETE FROM ofirst_projects_tasks WHERE TaskID = '".$_POST['task']."'") or die(mysql_error());
mysql_query("DELETE FROM ofirst_projects_projects WHERE TaskID = '".$_POST['task']."'") or die(mysql_error());
echo "<br><br>Task removed! [ <a href='tasks.php?GroupID=".$_GET['GroupID']."&ProjectID=".$_GET['ProjectID']."'>Projects</a> ]<br><br>";
die(include($footer));
--- 71,99 ----
}
+ // Add completion button (adds the completion of the project this task is apart of)
if(ISSET($_POST['addcompletion'])){
+ // Update completion value in databaes
mysql_query("UPDATE ofirst_projects_projects SET Completion = '".$_POST['completion']."' WHERE ID = '".$_GET['ProjectID']."'") or die(mysql_error());
echo "<br><br>Project completion changed to: ".$_POST['completion']."% [ <a href='projects.php?GroupID=".$_GET['GroupID']."'>Notes</a> ]<br><br>";
die(include($footer));
! }
+ // Remove button process
if(ISSET($_POST['remove'])){
! // If a remove confirm is selected then allow the process to continue
! if(! ISSET($_POST['confirm'])){
! echo "<br><br>Your request to remove the task was denied because you have not confirmed! [ <a href='tasks.php?GroupID=".$_GET['GroupID']."&ProjectID=".$_GET['ProjectID']."'>Tasks</a> ]<br><br>";
! die(include($footer));
! }
+ // Remove every task related value in the database
mysql_query("DELETE FROM ofirst_projects_tasks WHERE ID = '".$_POST['task']."'") or die(mysql_error());
mysql_query("DELETE FROM ofirst_projects_notes WHERE TaskID = '".$_POST['task']."'") or die(mysql_error());
mysql_query("DELETE FROM ofirst_projects_tasks WHERE TaskID = '".$_POST['task']."'") or die(mysql_error());
mysql_query("DELETE FROM ofirst_projects_projects WHERE TaskID = '".$_POST['task']."'") or die(mysql_error());
+
echo "<br><br>Task removed! [ <a href='tasks.php?GroupID=".$_GET['GroupID']."&ProjectID=".$_GET['ProjectID']."'>Projects</a> ]<br><br>";
die(include($footer));
***************
*** 86,89 ****
--- 101,105 ----
}
+ // Gather information to show the following tasks
$query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
$group = mysql_fetch_object($query);
***************
*** 117,130 ****
--- 133,150 ----
<?php
+ // Run through the current tasks in the database related to this project and group
$query = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE ProjectID = '".$_GET['ProjectID']."' AND GroupID = '".$_GET['GroupID']."'");
while($tasks = mysql_fetch_object($query)){
+ // If a pend is not set then make value false
if($tasks->Pend == "none"){
$pend = false;
}else{
+ // If the value is true then find the value of the task its pending on
$taskquery = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$tasks->Pend."'");
$pendtask = mysql_fetch_object($taskquery);
+ // If the pend task is 100% then dont continue pend value
if($pendtask->Completion == 100){
$pend = false;
***************
*** 137,148 ****
<tr onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'" <?php if(date("F j, Y",time()) == date("F j, Y",$tasks->Dates)){ echo "bgColor='#CCCCCC'"; } ?>>
<td>
! <?php
if($tasks->Completion == "100"){
echo "<a href='notes.php?GroupID=".$_GET['GroupID']."&TaskID=".$tasks->ID."&ProjectID=".$_GET['ProjectID']."'><img src='../members/icons/actions/button_ok.png' border='0'></a>";
! }elseif($tasks->Completion == "CLOSE"){
echo "<a href='notes.php?GroupID=".$_GET['GroupID']."&TaskID=".$tasks->ID."&ProjectID=".$_GET['ProjectID']."'><img src='../members/icons/actions/button_cancel.png' border='0'></a>";
}else{
if($pend){
echo "<img src='../members/icons/actions/encrypted.png' border='0'>";
--- 157,172 ----
<tr onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'" <?php if(date("F j, Y",time()) == date("F j, Y",$tasks->Dates)){ echo "bgColor='#CCCCCC'"; } ?>>
<td>
! <?php
+ // If the task comletion is 100% then display the completion graphic
if($tasks->Completion == "100"){
echo "<a href='notes.php?GroupID=".$_GET['GroupID']."&TaskID=".$tasks->ID."&ProjectID=".$_GET['ProjectID']."'><img src='../members/icons/actions/button_ok.png' border='0'></a>";
!
! // If the task is closed then display the close value
! }elseif($tasks->Completion == "CLOSE"){
echo "<a href='notes.php?GroupID=".$_GET['GroupID']."&TaskID=".$tasks->ID."&ProjectID=".$_GET['ProjectID']."'><img src='../members/icons/actions/button_cancel.png' border='0'></a>";
}else{
+ // If the value is still pending then display the pend value
if($pend){
echo "<img src='../members/icons/actions/encrypted.png' border='0'>";
***************
*** 156,166 ****
<td>
<?php
echo $tasks->TaskName." (";
if(! $pend){
! echo $tasks->Completion."%";
}else{
echo "PEND ON: ".$pendtask->TaskName;
}
echo ")";
?>
</td>
--- 180,193 ----
<td>
<?php
+
+ // Decide between pend, close and completion value to display
echo $tasks->TaskName." (";
if(! $pend){
! if($tasks->Completion == "CLOSE"){ echo "CLOSED"; }else{ echo $tasks->Completion."%"; }
}else{
echo "PEND ON: ".$pendtask->TaskName;
}
echo ")";
+
?>
</td>
***************
*** 174,177 ****
--- 201,205 ----
}
+ // If no values are found then output a response
if(mysql_num_rows($query) == 0){
echo "\n <tr>\n <td> </td>\n <td> </td>\n <td> </td>\n <td>There are no tasks for this project!</td>\n <td> </td>";
***************
*** 182,187 ****
<?php
! if(ISSET($user->user)){
!
$allowed = explode(",",$project->Assigned);
$show = false;
--- 210,214 ----
<?php
! // Loop through members assigned to this current task, check if the user is any of those names then allow the to add/edit
$allowed = explode(",",$project->Assigned);
$show = false;
***************
*** 290,297 ****
--- 317,327 ----
<td><select name="assign[]" width='40' size="6" multiple id="assign">
<?php
+
+ // View assigned members to related project
$assigned = explode(",",$project->Assigned);
foreach($assigned as $assign){
echo "<option>".$assign."</option>";
}
+
?>
</select></td>
***************
*** 309,316 ****
<td><div align="right">Task Name:</div></td>
<td><select name="task" id="task">
! <?php
$query = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE GroupID = '".$_GET['GroupID']."' AND ProjectID = '".$_GET['ProjectID']."'");
-
while($tasks = mysql_fetch_object($query)){
echo "<option value='".$tasks->ID."'>".$tasks->TaskName."</option>";
--- 339,346 ----
<td><div align="right">Task Name:</div></td>
<td><select name="task" id="task">
! <?php
+ // View a list of tasks
$query = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE GroupID = '".$_GET['GroupID']."' AND ProjectID = '".$_GET['ProjectID']."'");
while($tasks = mysql_fetch_object($query)){
echo "<option value='".$tasks->ID."'>".$tasks->TaskName."</option>";
***************
*** 371,380 ****
</table>
</form>
! <?php } } ?>
! <br>
! <table width="102%">
! <tr>
! <td bgcolor="#CCCCCC">Highlighted Cell = New Commit</td>
! </tr>
! </table>
! <?php include($footer); ?>
--- 401,408 ----
</table>
</form>
! <?php
!
! }
! }
! include($footer);
! ?>
\ No newline at end of file
Index: today.php
===================================================================
RCS file: /cvsroot/openfirst/projects/today.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** today.php 27 Aug 2003 12:58:07 -0000 1.1
--- today.php 29 Aug 2003 15:50:35 -0000 1.2
***************
*** 27,34 ****
--- 27,41 ----
*/
+ // Include globals and set header condense (not coded yet)
include("../config/globals.php");
$header_condense = true;
include($header);
+ // Check if user is a member
+ if(! ISSET($user->user)){
+ showLogin();
+ }else{
+
+ // Select value of date to view for the page
if(ISSET($_POST['viewdate'])){
$selectdate = $_POST['month']." ".$_POST['day'].", ".$_POST['year'];
***************
*** 114,117 ****
--- 121,125 ----
<?php
+ // Run through the current list of groups to preview there related information
$groupquery = mysql_query("SELECT * FROM ofirst_projects_groups");
while($group = mysql_fetch_object($groupquery)){
***************
*** 134,137 ****
--- 142,146 ----
<?php
+ // Listed the newly added projects for this day
$projectquery = mysql_query("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$group->ID."'");
while($project = mysql_fetch_object($projectquery)){
***************
*** 153,156 ****
--- 162,166 ----
}
+ // List the newly added tasks for this day
$taskquery = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE GroupID = '".$group->ID."'");
while($task = mysql_fetch_object($taskquery)){
***************
*** 175,178 ****
--- 185,189 ----
}
+ // List the newly added notes for this day
$notequery = mysql_query("SELECT * FROM ofirst_projects_notes WHERE GroupID = '".$group->ID."'");
while($note = mysql_fetch_object($notequery)){
***************
*** 202,205 ****
?>
</table>
! <?php } ?>
! <br><br> <?php include($footer); ?>
\ No newline at end of file
--- 213,219 ----
?>
</table>
! <?php
! }
! }
! include($footer);
! ?>
\ No newline at end of file
Index: viewmeeting.php
===================================================================
RCS file: /cvsroot/openfirst/projects/viewmeeting.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** viewmeeting.php 27 Aug 2003 12:58:07 -0000 1.1
--- viewmeeting.php 29 Aug 2003 15:50:35 -0000 1.2
***************
*** 27,41 ****
*/
include("../config/globals.php");
$header_condense = true;
include($header);
if(ISSET($_POST['update'])){
! if(! ISSET($_POST['absent'])){
! echo "<br><br>You must select users who were absent of click none! Click back to continue.<br><br><br>";
! die(include($footer));
! }
if(is_array($_POST['absent'])){
$absentlist = implode(",",$_POST['absent']);
--- 27,50 ----
*/
+ // Include globals and set header condense (not coded yet)
include("../config/globals.php");
$header_condense = true;
include($header);
+ // Check if user is a member
+ if(! ISSET($user->user)){
+ showLogin();
+ }else{
+
+ // Update buttin process
if(ISSET($_POST['update'])){
! // Check if absent values were set
! if(! ISSET($_POST['absent'])){
! echo "<br><br>You must select users who were absent of click none! Click back to continue.<br><br><br>";
! die(include($footer));
! }
+ // Check if absent was a single string or array then add it to a variable
if(is_array($_POST['absent'])){
$absentlist = implode(",",$_POST['absent']);
***************
*** 44,47 ****
--- 53,57 ----
}
+ // Update information in the database
mysql_query("UPDATE ofirst_projects_meetings SET
Notes = '".$_POST['notes']."',
***************
*** 52,55 ****
--- 62,66 ----
}
+ // Collect information for the current meeting
$query = mysql_query("SELECT * FROM ofirst_projects_meetings WHERE ID = '".$_GET['ID']."'");
$meeting = mysql_fetch_object($query);
***************
*** 70,73 ****
--- 81,86 ----
<td><p>
<?php
+
+ // List people who meeting was arranged for
$assign = explode(",",$meeting->ArrangedFor);
foreach($assign as $assign){
***************
*** 76,83 ****
--- 89,98 ----
echo "<br>".$group->GroupName;
}
+
?>
</p></td>
</tr>
<?php
+ // View extra features if the meeting is done
if($meeting->Status == "done"){
?>
***************
*** 104,108 ****
<div align="right">Notes:</div></td>
<td>
! <?php
if (function_exists("make_wysiwyg")) {
make_wysiwyg("description",500,255,"");
--- 119,125 ----
<div align="right">Notes:</div></td>
<td>
! <?php
!
! // If WYSIWYG function is set then view the WYSIWYG function module
if (function_exists("make_wysiwyg")) {
make_wysiwyg("description",500,255,"");
***************
*** 110,113 ****
--- 127,131 ----
echo "<textarea name='description'></textarea>";
}
+
?>
</td>
***************
*** 115,137 ****
<tr>
<td><div align="right">Please list the people who were <strong>NOT</strong>
! present::</div></td>
<td><p>
<select name="absent[]" width='60' size="6">
! <option>none</option><?php
$assign = explode(",",$meeting->ArrangedFor);
foreach($assign as $assign){
$query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$assign."'");
$group = mysql_fetch_object($query);
- $people = explode(",",$group->Members);
$people = array_unique($people);
}
!
foreach($people as $people){
echo "\n <option>$people</option>";
}
! ?>
</select>
<font size="2"></font></p></td>
--- 133,162 ----
<tr>
<td><div align="right">Please list the people who were <strong>NOT</strong>
! present:</div></td>
<td><p>
<select name="absent[]" width='60' size="6">
! <option>none</option>
! <?php
!
! // Make a list of people who were present at the meeting
$assign = explode(",",$meeting->ArrangedFor);
foreach($assign as $assign){
+
+ // Run through the groups and find values
$query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$assign."'");
$group = mysql_fetch_object($query);
+ $people = explode(",",$group->Members);
+
+ // Remove any duplicated names in the array
$people = array_unique($people);
}
! // List the people currently in the array
foreach($people as $people){
echo "\n <option>$people</option>";
}
! ?>
</select>
<font size="2"></font></p></td>
***************
*** 143,147 ****
</tr>
</table></form>
! <p><br>
! <?php } include($footer); ?>
! </p>
--- 168,175 ----
</tr>
</table></form>
! <br>
! <?php
!
! }
! include($footer);
! ?>
|
|
From: <dav...@us...> - 2003-08-27 12:58:33
|
Update of /cvsroot/openfirst/projects/setup In directory sc8-pr-cvs1:/tmp/cvs-serv3608 Added Files: setup.mysql Log Message: initial upload --- NEW FILE: setup.mysql --- CREATE TABLE `ofirst_projects_groups` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `GroupName` tinytext, `Description` text, `Moderators` tinytext, `Members` tinytext, `Dates` text, PRIMARY KEY (`ID`)) TYPE=MyISAM; CREATE TABLE `ofirst_projects_meetings` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `Dates` text, `ForDate` text, `Description` text, `ArrangedFor` text, `AbsentList` text, `Notes` text, `Status` text, PRIMARY KEY (`ID`)) TYPE=MyISAM; CREATE TABLE `ofirst_projects_notes` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `ProjectID` tinyint(8) default NULL, `GroupID` tinyint(8) default NULL, `TaskID` tinyint(8) default NULL, `Description` tinytext, `Commiter` tinytext, `Dates` text, PRIMARY KEY (`ID`)) TYPE=MyISAM; CREATE TABLE `ofirst_projects_projects` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `ProjectName` tinytext, `GroupID` tinyint(3) default '0', `Completion` tinytext, `Description` text, `Assigned` text, `TarDate` text, `Dates` text, `Pend` tinytext, PRIMARY KEY (`ID`)) TYPE=MyISAM; CREATE TABLE `ofirst_projects_tasks` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `TaskName` text, `ProjectID` tinytext, `GroupID` tinytext, `DateAssigned` text, `TarDate` text, `Description` text, `Assigned` text, `Dates` text, `Completion` tinytext, `Pend` text, PRIMARY KEY (`ID`)) TYPE=MyISAM; INSERT INTO ofirst_config SET includes='',modulename='projects',showonmenu='0',active='0',modulenavigation='<a href="$basepath/projects/groups.php">Action Register</a> | <a href="$basepath/projects/mytask.php">My Tasks</a> | <a href="$basepath/projects/preferences.php">Preferences</a> | <a href="$basepath/projects/meetings.php">Meetings</a> | <a href="$basepath/projects/today.php">Todays Changes</a>'; ALTER TABLE ofirst_members ADD COLUMN ProjectsFrequency tinytext ALTER TABLE ofirst_members ADD COLUMN ProjectsSendCountDown tinytext ALTER TABLE ofirst_members ADD COLUMN ProjectsCommitSelect tinytext ALTER TABLE ofirst_members ADD COLUMN ProjectsSendTemplate tinytext |
Update of /cvsroot/openfirst/projects
In directory sc8-pr-cvs1:/tmp/cvs-serv3421
Added Files:
groups.php index.php meetings.php mytask.php notes.php
preferences.php projects.php tasks.php today.php
viewmeeting.php
Log Message:
initial upload
--- NEW FILE: meetings.php ---
<?php
/*
* openFIRST.projects - meetings.php
*
* Copyright (C) 2003,
* openFIRST Project
* Original Author: David Di Biase <dav...@ea...>
*
* 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.
* 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
*
*/
include("../config/globals.php");
$header_condense = true;
include($header);
if(ISSET($_POST['create'])){
if(! ISSET($_POST['assign'])){
echo "<br><br>You must assign an arranged for field to this meeting! Click back to continue.<br><br><br>";
die(include($footer));
}
if(is_array($_POST['assign'])){
$assign = implode(",",$_POST['assign']);
}else{
$assign = $_POST['assign'];
}
$fordate = strtotime($_POST['month']." ".$_POST['day'].",".$_POST['year']." ".$_POST['hour'].":".$_POST['minute']." ".$_POST['ampm']);
mysql_query("INSERT INTO ofirst_projects_meetings SET
ForDate = '".$fordate."',
Description = '".$_POST['description']."',
ArrangedFor = '".$assign."',
AbsentList = 'none',
Status = 'wait',
Dates = '".time()."'") or die(mysql_error());
echo "<br><br>Meeting created! [ <a href='meetings.php'>Meetings</a> ]<br><br>";
die(include($footer));
}
if(ISSET($_POST['remove'])){
if(! ISSET($_POST['confirm'])){
echo "<br><br>Your request to remove the project was denied because you have not confirmed! [ <a href='projects.php?GroupID=".$_GET['GroupID']."'>Projects</a> ]<br><br>";
die(include($footer));
}
mysql_query("DELETE FROM ofirst_projects_meetings WHERE ID = '".$_POST['project']."'") or die(mysql_error());
echo "<br><br>Meetings removed! [ <a href='meetings.php'>Meetings</a> ]<br><br>";
die(include($footer));
}
?>
<h2><font face="Verdana, Arial, Helvetica, sans-serif"> Meetings Organizer</font></h2>
<table width="100%">
<tr>
<th>Upcoming Meetings</th>
</tr>
</table>
<table width="100%">
<tr bgcolor="#999999">
<td width="6%"> </td>
<td width="21%"><div align="center"><strong>Date</strong></div></td>
<td width="52%"><div align="center"><strong>Description</strong></div></td>
<td width="21%"><div align="center"><strong>Arranged For</strong></div></td>
</tr>
<?php
$meetquery = mysql_query("SELECT * FROM ofirst_projects_meetings WHERE Status='wait'");
while($meeting = mysql_fetch_object($meetquery)){
?>
<tr>
<td><div align="center"><a href="viewmeeting.php?ID=<?php echo $meeting->ID; ?>"><img src="../members/icons/apps/date.png" width="32" height="32" border="0"></a></div></td>
<td><?php echo date("F j, Y",$meeting->ForDate); ?></td>
<td><?php echo $meeting->Description; ?></td>
<td>
<?php
$assign = explode(",",$meeting->ArrangedFor);
foreach($assign as $assign){
$query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$assign."'");
$group = mysql_fetch_object($query);
echo "<br>".$group->GroupName;
}
?>
</td>
</tr>
<?php
}
if(mysql_num_rows($meetquery) == 0){
echo "<tr><td> </td><td> </td><td>There are no planned meetings!</td><td> </td></tr>";
}
?>
</table>
<table width="100%">
<tr>
<th>Past Meetings</th>
</tr>
</table>
<table width="100%">
<tr bgcolor="#999999">
<td width="6%"> </td>
<td width="21%"><div align="center"><strong>Date</strong></div></td>
<td width="52%"><div align="center"><strong>Description</strong></div></td>
<td width="21%"><div align="center"><strong>Arranged For</strong></div></td>
</tr>
<?php
$query = mysql_query("SELECT * FROM ofirst_projects_meetings WHERE Status='done'");
while($meeting = mysql_fetch_object($query)){
?>
<tr>
<td><div align="center"><a href="viewmeeting.php?ID=<?php echo $meeting->ID; ?>"><img src="../members/icons/apps/date.png" width="32" height="32" border="0"></a></div></td>
<td><?php echo date("F j, Y",$meeting->ForDate); ?></td>
<td><?php echo $meeting->Description; ?></td>
<td>
<?php
$assign = explode(",",$meeting->ArrangedFor);
foreach($assign as $assign){
$query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$assign."'");
$group = mysql_fetch_object($query);
echo $group->GroupName;
}
?>
</td>
</tr>
<?php
}
if(mysql_num_rows($query) == 0){
echo "<tr><td> </td><td> </td><td>There are no past meetings!</td><td> </td></tr>";
}
?>
</table>
<br>
<form onsubmit="return dhtmlEditorPrepareSubmit();" action='meetings.php' method='POST'>
<table width="64%">
<tr>
<th width="19%"> </th>
<th width="31%">Plan New Meeting</th>
</tr>
<tr>
<td valign="top">
<div align="right">Description:</div></td>
<td>
<?php
if (function_exists("make_wysiwyg")) {
make_wysiwyg("description",500,255,"");
}else{
echo "<textarea name='description'></textarea>";
}
?>
</td>
</tr>
<tr>
<td><div align="right">Meeting Date:</div></td>
<td><select name="month" id="month">
<option selected><?php echo date("F",time()); ?></option>
<option>----</option>
<option>January</option>
<option>February</option>
<option>March</option>
<option>April</option>
<option>May</option>
<option>June</option>
<option>July</option>
<option>August</option>
<option>September</option>
<option>October</option>
<option>November</option>
<option>December</option>
</select>
<select name="day" id="day">
<option selected><?php echo date("j",time()); ?></option>
<option>----</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select>
,
<select name="year" id="year">
<option selected><?php echo date("Y",time()); ?></option>
<option>----</option>
<option>2003</option>
<option>2004</option>
<option>2005</option>
<option>2006</option>
<option>2007</option>
<option>2008</option>
<option>2009</option>
<option>2010</option>
</select>
<input name="hour" type="text" id="hour" size="2">
: <input name="minute" type="text" id="minute" size="2">
<select name="ampm" id="ampm">
<option selected>AM</option>
<option>PM</option>
</select> </td>
</tr>
<tr>
<td><div align="right">Arranged For:</div></td>
<td><p>
<select name="assign[]" width='40' size="6" multiple id="assign">
<?php
$query = mysql_query("SELECT * FROM ofirst_projects_groups");
while($group = mysql_fetch_object($query)){
echo "<option value='".$group->ID."'>".$group->GroupName."</option>";
}
?>
</select>
<font size="2"></font></p></td>
</tr>
<tr>
<td> </td>
<td><input name="create" type="submit" id="create2" value="Create Meeting">
<input type="reset" name="Reset" value="Reset"> </td>
</tr>
<tr>
<th> </th>
<th>Remove Meeting</th>
</tr>
<tr>
<td><div align="right">Meeting Date:</div></td>
<td><select name="project" id="project">
<?php
$query = mysql_query("SELECT * FROM ofirst_projects_meetings");
while($meeting = mysql_fetch_object($query)){
echo "<option value='".$meeting->ID."'>".date("F j, Y h:i a",$meeting->ForDate)."</option>";
}
?>
</select></td>
</tr>
<tr>
<td><div align="right">
<input name="confirm" type="checkbox" id="confirm" value="checkbox">
</div></td>
<td>Click here to confirm the removal of this meeting. Without checking the
meeting will not be removed.</td>
</tr>
<tr>
<td> </td>
<td><input name="remove" type="submit" id="remove" value="Remove"></td>
</tr>
</table>
<br>
<?php include($footer); ?>
--- NEW FILE: mytask.php ---
<?php
/*
* openFIRST.projects - mytask.php
*
* Copyright (C) 2003,
* openFIRST Project
* Original Author: David Di Biase <dav...@ea...>
*
* 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.
* 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
*
*/
include("../config/globals.php");
$header_condense = true;
include($header);
?>
<h2>My Tasks Summarized</h2>
<p>The information listed below is a list of summarized tasks that you have been
assigned to.</p>
<table width="100%" border="0" cellspacing="0" cellpadding="6">
<tr>
<td bgcolor="#666666"> <div align="center"><font color="#FFFFFF">Your Current
Tasks </font></div></td>
</tr>
</table>
<table width="100%" bordercolor="#999999">
<tr bgcolor="#999999">
<td width="4%"> </td>
<td width="20%">Task Name</td>
<td width="13%">Target Date</td>
<td width="33%">Description</td>
<td width="30%">Assigned</td>
</tr>
<?php
$query = mysql_query("SELECT * FROM ofirst_projects_tasks");
while($tasks = mysql_fetch_object($query)){
$showtask = false;
$assigned = explode(",",$tasks->Assigned);
foreach($assigned As $member){
if($member == $user->user){
$showtask = true;
}
}
if($showtask){
if($tasks->Pend == "none"){
$pend = false;
}else{
$taskquery = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$tasks->Pend."'");
$pendtask = mysql_fetch_object($taskquery);
if($pendtask->Completion == 100){
$pend = false;
}else{
$pend = true;
}
}
}
?>
<tr onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'" <?php if(date("F j, Y",time()) == date("F j, Y",$tasks->Dates)){ echo "bgColor='#CCCCCC'"; } ?>>
<td><a href="notes.php?GroupID=<?php echo $_GET['GroupID']; ?>&TaskID=<?php echo $tasks->ID; ?>&ProjectID=<?php echo $_GET['ProjectID']; ?>">
<?php
if($pend){
echo "<img src='../members/icons/actions/encrypted.png' border='0'>";
}else{
echo "<a href='notes.php?GroupID=".$tasks->GroupID."&TaskID=".$tasks->ID."&ProjectID=".$tasks->ProjectID."'><img src='../members/icons/filesystems/desktop.png' border='0'></a>";
}
?>
</a></td>
<td>
<?php
echo $tasks->TaskName." (";
if(! $pend){
echo $tasks->Completion."%";
}else{
echo "PEND ON: ".$pendtask->TaskName;
}
echo ")";
?>
</td>
<td>
<?php
echo date("F j, Y",$tasks->TarDate);
?>
</td>
<td><?php echo $tasks->Description; ?></td>
<td><?php echo $tasks->Assigned; ?></td>
</tr>
<?
}
if(mysql_num_rows($query) == 0){
echo "\n <tr>\n <td> </td>\n <td> </td>\n <td> </td>\n <td>There are no tasks for this project!</td>\n <td> </td>";
}
?>
</table>
<br>
<?php include($footer); ?>
--- NEW FILE: today.php ---
<?php
/*
* openFIRST.projects - today.php
*
* Copyright (C) 2003,
* openFIRST Project
* Original Author: David Di Biase <dav...@ea...>
*
* 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.
* 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
*
*/
include("../config/globals.php");
$header_condense = true;
include($header);
if(ISSET($_POST['viewdate'])){
$selectdate = $_POST['month']." ".$_POST['day'].", ".$_POST['year'];
}else{
$selectdate = date("F j, Y",time());
}
?>
<h2>Todays Changes</h2>
<form method="post" action="today.php">
<p>View Updates For:
<select name="month" id="month">
<option selected><?php echo date("F",time()); ?></option>
<option>----</option>
<option>January</option>
<option>February</option>
<option>March</option>
<option>April</option>
<option>May</option>
<option>June</option>
<option>July</option>
<option>August</option>
<option>September</option>
<option>October</option>
<option>November</option>
<option>December</option>
</select>
/
<select name="day" id="day">
<option selected><?php echo date("j",time()); ?></option>
<option>----</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
<option>9</option>
<option>10</option>
<option>11</option>
<option>12</option>
<option>13</option>
<option>14</option>
<option>15</option>
<option>16</option>
<option>17</option>
<option>18</option>
<option>19</option>
<option>20</option>
<option>21</option>
<option>22</option>
<option>23</option>
<option>24</option>
<option>25</option>
<option>26</option>
<option>27</option>
<option>28</option>
<option>29</option>
<option>30</option>
<option>31</option>
</select>
/
<select name="year" id="year">
<option selected><?php echo date("Y",time()); ?></option>
<option>----</option>
<option>2004</option>
<option>2003</option>
<option>2002</option>
<option>2001</option>
<option>2000</option>
</select>
<input name="viewdate" type="submit" id="viewdate" value="View Date">
</p>
</form>
<table width="100%" border="0" cellspacing="0" cellpadding="6">
<tr>
<th>
<div align="center">Notes commited on <strong><?php echo $selectdate; ?></strong></div></th>
</tr>
</table>
<?php
$groupquery = mysql_query("SELECT * FROM ofirst_projects_groups");
while($group = mysql_fetch_object($groupquery)){
?>
<table width="100%" border="0" cellspacing="0" cellpadding="6">
<tr>
<td bgcolor="#CCCCCC"> <div align="center"><font color="#000000"><strong><?php echo $group->GroupName; ?></strong></font></div></td>
</tr>
</table>
<table width="100%">
<tr bgcolor="#999999">
<td width="4%"> </td>
<td width="14%">Change</td>
<td width="15%">Project</td>
<td width="14%">Task</td>
<td width="35%">Decsription</td>
<td width="18%">Assigned/Commiter</td>
</tr>
<?php
$projectquery = mysql_query("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$group->ID."'");
while($project = mysql_fetch_object($projectquery)){
if($selectdate == date("F j, Y",$project->Dates)){
?>
<tr onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'">
<td><img src="../members/icons/actions/project_open.png" width="32" height="32"></td>
<td>New Project</td>
<td><font color='red'><?php echo $project->ProjectName; ?></font></td>
<td>--</td>
<td><?php echo $project->Description; ?></td>
<td><?php echo $project->Assigned; ?></td>
</tr>
<?php
}
}
$taskquery = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE GroupID = '".$group->ID."'");
while($task = mysql_fetch_object($taskquery)){
$taskprojquery = mysql_query("SELECT ProjectName FROM ofirst_projects_projects WHERE ID = '".$task->ProjectID."'");
$taskproject = mysql_fetch_object($taskprojquery);
if($selectdate == date("F j, Y",$task->Dates)){
?>
<tr onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'">
<td><img src="../members/icons/filesystems/desktop.png" width="32" height="32"></td>
<td>New Task</td>
<td><?php echo $taskproject->ProjectName; ?></td>
<td><font color='red'><?php echo $task->TaskName; ?></font></td>
<td><?php echo $task->Description; ?></td>
<td><?php echo $task->Assigned; ?></td>
</tr>
<?php
}
}
$notequery = mysql_query("SELECT * FROM ofirst_projects_notes WHERE GroupID = '".$group->ID."'");
while($note = mysql_fetch_object($notequery)){
$noteprojquery = mysql_query("SELECT ProjectName FROM ofirst_projects_projects WHERE ID = '".$note->ProjectID."'");
$noteproject = mysql_fetch_object($noteprojquery);
$notetasquery = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$note->TaskID."'");
$notetask = mysql_fetch_object($notetasquery);
if($selectdate == date("F j, Y",$note->Dates)){
?>
<tr onMouseOver="this.style.backgroundColor='#cccccc'" onMouseOut="this.style.backgroundColor='#ffffff'">
<td><img src="../members/icons/filesystems/files.png" width="32" height="32"></td>
<td>New Note Commited</td>
<td><?php echo $noteproject->ProjectName; ?></td>
<td><?php echo $notetask->TaskName; ?></td>
<td><font color='red'><?php echo $note->Description; ?></font></td>
<td><?php echo $note->Commiter; ?></td>
</tr>
<?php
}
}
?>
</table>
<?php } ?>
<br><br> <?php include($footer); ?>
--- NEW FILE: viewmeeting.php ---
<?php
/*
* openFIRST.projects - viewmeeting.php
*
* Copyright (C) 2003,
* openFIRST Project
* Original Author: David Di Biase <dav...@ea...>
*
* 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.
* 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
*
*/
include("../config/globals.php");
$header_condense = true;
include($header);
if(ISSET($_POST['update'])){
if(! ISSET($_POST['absent'])){
echo "<br><br>You must select users who were absent of click none! Click back to continue.<br><br><br>";
die(include($footer));
}
if(is_array($_POST['absent'])){
$absentlist = implode(",",$_POST['absent']);
}else{
$absentlist = $_POST['absent'];
}
mysql_query("UPDATE ofirst_projects_meetings SET
Notes = '".$_POST['notes']."',
AbsentList = '$absentlist',
Status = 'done' WHERE ID = '".$_GET['ID']."'") or die(mysql_error());
echo "<br><br>Meeting updated! [ <a href='meetings.php'>Meetings</a> ]<br><br>";
die(include($footer));
}
$query = mysql_query("SELECT * FROM ofirst_projects_meetings WHERE ID = '".$_GET['ID']."'");
$meeting = mysql_fetch_object($query);
?>
<h2>Meeting Viewer</h2>
<table width="64%">
<tr>
<th width="24%"> </th>
<th width="76%">Meeting for <?php echo date("F j, Y",$meeting->ForDate); ?></th>
</tr>
<tr>
<td valign="top"> <div align="right"><strong>Description:</strong></div></td>
<td><?php echo $meeting->Description; ?></td>
</tr>
<tr>
<td><div align="right"><strong>Arranged For:</strong></div></td>
<td><p>
<?php
$assign = explode(",",$meeting->ArrangedFor);
foreach($assign as $assign){
$query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$assign."'");
$group = mysql_fetch_object($query);
echo "<br>".$group->GroupName;
}
?>
</p></td>
</tr>
<?php
if($meeting->Status == "done"){
?>
<tr>
<td><div align="right"><strong>Notes:</strong></div></td>
<td><?php echo $meeting->Notes; ?></td>
</tr>
<tr>
<td><div align="right"><strong>Absent List:</strong></div></td>
<td><?php echo $meeting->AbsentList; ?></td>
</tr>
<?php } ?>
</table>
<br>
<?php if($meeting->Status != "done"){ ?>
<form onsubmit="return dhtmlEditorPrepareSubmit();" action='viewmeeting.php?ID=<?php echo $_GET['ID']; ?>' method='POST'>
<table width="48%">
<tr>
<th width="19%"> </th>
<th width="31%">Plan New Meeting</th>
</tr>
<tr>
<td valign="top">
<div align="right">Notes:</div></td>
<td>
<?php
if (function_exists("make_wysiwyg")) {
make_wysiwyg("description",500,255,"");
}else{
echo "<textarea name='description'></textarea>";
}
?>
</td>
</tr>
<tr>
<td><div align="right">Please list the people who were <strong>NOT</strong>
present::</div></td>
<td><p>
<select name="absent[]" width='60' size="6">
<option>none</option><?php
$assign = explode(",",$meeting->ArrangedFor);
foreach($assign as $assign){
$query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$assign."'");
$group = mysql_fetch_object($query);
$people = explode(",",$group->Members);
$people = array_unique($people);
}
foreach($people as $people){
echo "\n <option>$people</option>";
}
?>
</select>
<font size="2"></font></p></td>
</tr>
<tr>
<td> </td>
<td><input name="update" type="submit" id="update" value="Update Meeting">
<input type="reset" name="Reset" value="Reset"> </td>
</tr>
</table></form>
<p><br>
<?php } include($footer); ?>
</p>
|
|
From: <dav...@us...> - 2003-08-27 12:57:22
|
Update of /cvsroot/openfirst/projects/setup In directory sc8-pr-cvs1:/tmp/cvs-serv3358/setup Log Message: Directory /cvsroot/openfirst/projects/setup added to the repository |
Update of /cvsroot/openfirst/projects In directory sc8-pr-cvs1:/tmp/cvs-serv2859 Removed Files: book2_5.gif computer1.gif computer2.gif COPYING groups.php index.php keijiban.gif keijiban_s.gif looseleaf_b.gif looseleaf_g.gif looseleaf_r.gif looseleaf_v.gif mg_p.gif mg_s.gif mytasks.php notes.php ofirst_projects.sql pencil1_b.gif pencil1_g.gif pencil1_o.gif pencil1_r.gif preferences.php projects.php README screens.php tasks.php updates.php Log Message: Removing these files because the images are deprecated and the new files are dramatically different. --- book2_5.gif DELETED --- --- computer1.gif DELETED --- --- computer2.gif DELETED --- --- COPYING DELETED --- --- groups.php DELETED --- --- index.php DELETED --- --- keijiban.gif DELETED --- --- keijiban_s.gif DELETED --- --- looseleaf_b.gif DELETED --- --- looseleaf_g.gif DELETED --- --- looseleaf_r.gif DELETED --- --- looseleaf_v.gif DELETED --- --- mg_p.gif DELETED --- --- mg_s.gif DELETED --- --- mytasks.php DELETED --- --- notes.php DELETED --- --- ofirst_projects.sql DELETED --- --- pencil1_b.gif DELETED --- --- pencil1_g.gif DELETED --- --- pencil1_o.gif DELETED --- --- pencil1_r.gif DELETED --- --- preferences.php DELETED --- --- projects.php DELETED --- --- README DELETED --- --- screens.php DELETED --- --- tasks.php DELETED --- --- updates.php DELETED --- |
7 messages has been excluded from this view by a project administrator.
