openfirst-cvscommit Mailing List for openFIRST (Page 71)
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-10-16 23:53:32
|
Update of /cvsroot/openfirst/messenger
In directory sc8-pr-cvs1:/tmp/cvs-serv8786
Modified Files:
newmsg.php viewmsg.php inbox.php
Log Message:
Make messages go to the proper recipent when 'Reply' functionality is used, rather than presenting a list of recipients.
Index: newmsg.php
===================================================================
RCS file: /cvsroot/openfirst/messenger/newmsg.php,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** newmsg.php 16 Oct 2003 23:05:51 -0000 1.12
--- newmsg.php 16 Oct 2003 23:52:59 -0000 1.13
***************
*** 81,86 ****
$query = ofirst_dbquery("SELECT * FROM ofirst_messenger_usersonline WHERE ID = '".$_GET['RECIP']."'");
! $recipient = ofirst_dbfetch_object($query);
!
echo "<input type='hidden' name='recip' value='".$recipient->Member."'>";
echo $recipient->Member;
--- 81,89 ----
$query = ofirst_dbquery("SELECT * FROM ofirst_messenger_usersonline WHERE ID = '".$_GET['RECIP']."'");
! if(ofirst_dbnum_rows($query) == "0") {
! $recipient->Member = $_GET["RECIP"];
! } else {
! $recipient = ofirst_dbfetch_object($query);
! }
echo "<input type='hidden' name='recip' value='".$recipient->Member."'>";
echo $recipient->Member;
Index: viewmsg.php
===================================================================
RCS file: /cvsroot/openfirst/messenger/viewmsg.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** viewmsg.php 13 Oct 2003 17:58:27 -0000 1.7
--- viewmsg.php 16 Oct 2003 23:52:59 -0000 1.8
***************
*** 80,84 ****
</table>
<p>[ <a href='inbox.php?DELETE=<?php echo $msg->ID; ?>'> Delete </a> ] [
! <a href="newmsg.php?REPLY=<?php echo $sender->ID; ?>&SUBJECT=Re:%20<?php echo $msg->Subject; ?>">Reply</a>
]</p>
<?php
--- 80,84 ----
</table>
<p>[ <a href='inbox.php?DELETE=<?php echo $msg->ID; ?>'> Delete </a> ] [
! <a href="newmsg.php?RECIP=<?php echo $msg->Sender; ?>&SUBJECT=Re:%20<?php echo $msg->Subject; ?>">Reply</a>
]</p>
<?php
Index: inbox.php
===================================================================
RCS file: /cvsroot/openfirst/messenger/inbox.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** inbox.php 13 Oct 2003 17:58:27 -0000 1.7
--- inbox.php 16 Oct 2003 23:52:59 -0000 1.8
***************
*** 80,84 ****
<td><?php echo $messages->Sender; ?></td>
<td>[ <a href='inbox.php?DELETE=<?php echo $messages->ID; ?>'> Delete </a> ]
! <br>[ <a href="newmsg.php?SUBJECT=Re: <?php echo $messages->Subject; ?>">Reply</a> ]</td>
</tr>
<?php
--- 80,84 ----
<td><?php echo $messages->Sender; ?></td>
<td>[ <a href='inbox.php?DELETE=<?php echo $messages->ID; ?>'> Delete </a> ]
! <br>[ <a href="newmsg.php?RECIP=<?php echo($messages->Sender); ?>&SUBJECT=Re: <?php echo $messages->Subject; ?>">Reply</a> ]</td>
</tr>
<?php
|
|
From: <xt...@us...> - 2003-10-16 23:06:25
|
Update of /cvsroot/openfirst/messenger
In directory sc8-pr-cvs1:/tmp/cvs-serv1611
Modified Files:
newmsg.php
Log Message:
Fix spelling of message, again. (not sure how this wasn't caught earlier)
Index: newmsg.php
===================================================================
RCS file: /cvsroot/openfirst/messenger/newmsg.php,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** newmsg.php 13 Oct 2003 17:58:27 -0000 1.11
--- newmsg.php 16 Oct 2003 23:05:51 -0000 1.12
***************
*** 64,70 ****
<form onsubmit="return dhtmlEditorPrepareSubmit();" method="POST" action="newmsg.php">
<h1>Visitor Inbox for Messaging</h1>
! <p>Please make sure that your messeges do not contain profanity or abusive comments.</p>
<table width="66%">
! <th></th><th>Send New Messege</th>
<tr>
<td width="34%"><?php emoticon_preview("14"); ?></td>
--- 64,70 ----
<form onsubmit="return dhtmlEditorPrepareSubmit();" method="POST" action="newmsg.php">
<h1>Visitor Inbox for Messaging</h1>
! <p>Please make sure that your messages do not contain profanity or abusive comments.</p>
<table width="66%">
! <th></th><th>Send New Message</th>
<tr>
<td width="34%"><?php emoticon_preview("14"); ?></td>
|
|
From: <xt...@us...> - 2003-10-16 22:56:56
|
Update of /cvsroot/openfirst/members
In directory sc8-pr-cvs1:/tmp/cvs-serv31624
Modified Files:
profile.php
Log Message:
Modify some of the ICQ number checking.
Index: profile.php
===================================================================
RCS file: /cvsroot/openfirst/members/profile.php,v
retrieving revision 1.16
retrieving revision 1.17
diff -C2 -d -r1.16 -r1.17
*** profile.php 7 Oct 2003 20:34:01 -0000 1.16
--- profile.php 16 Oct 2003 22:49:04 -0000 1.17
***************
*** 106,110 ****
if($q->email != "") { echo("<td><img src='email.png' alt='email available' /></td>"); } else { echo("<td><img src='email-none.png' alt='email available' /></td>"); }
if($q->msn != "") { echo("<td><img src='msmsgs.png' alt='msn available' /></td>"); } else { echo("<td><img src='msmsgs-none.png' alt='email available' /></td>"); }
! if($q->icq != "") { echo("<td><img src='icq.png' alt='icq available' /></td>"); } else { echo("<td><img src='icq-none.png' alt='email available' /></td>"); }
if($q->aim != "") { echo("<td><img src='aim.png' alt='aim available' /></td>"); } else { echo("<td><img src='aim-none.png' alt='email available' /></td>"); }
if($q->picturelocation != "") { echo("<td><img src='photo.png' alt='photo available' /></td>"); }else{ echo("<td><img src='photo-none.png' alt='email available' /></td>"); }
--- 106,110 ----
if($q->email != "") { echo("<td><img src='email.png' alt='email available' /></td>"); } else { echo("<td><img src='email-none.png' alt='email available' /></td>"); }
if($q->msn != "") { echo("<td><img src='msmsgs.png' alt='msn available' /></td>"); } else { echo("<td><img src='msmsgs-none.png' alt='email available' /></td>"); }
! if($q->icq != "" && $q->icq != "0") { echo("<td><img src='icq.png' alt='icq available' /></td>"); } else { echo("<td><img src='icq-none.png' alt='email available' /></td>"); }
if($q->aim != "") { echo("<td><img src='aim.png' alt='aim available' /></td>"); } else { echo("<td><img src='aim-none.png' alt='email available' /></td>"); }
if($q->picturelocation != "") { echo("<td><img src='photo.png' alt='photo available' /></td>"); }else{ echo("<td><img src='photo-none.png' alt='email available' /></td>"); }
***************
*** 152,156 ****
<br /><img src='icq.png' alt='I Seek You (ICQ) Number' />: $q->icq
");
! if ($q->icq != "") {
echo("<img src=\"http://wwp.icq.com/scripts/online.dll?icq=$q->icq&img=5\" alt=\"User status\" />");
} else {
--- 152,156 ----
<br /><img src='icq.png' alt='I Seek You (ICQ) Number' />: $q->icq
");
! if ($q->icq != "" && $q->icq != "0") {
echo("<img src=\"http://wwp.icq.com/scripts/online.dll?icq=$q->icq&img=5\" alt=\"User status\" />");
} else {
|
|
From: <i-...@us...> - 2003-10-15 01:02:58
|
Update of /cvsroot/openfirst/logger
In directory sc8-pr-cvs1:/tmp/cvs-serv9462/logger
Modified Files:
index.php rawdata.php track.php
Log Message:
Anonymous web users no longer have access to Logger features such as host listings and tracker. This functionality should not really be available to unauthorized users :)
Index: index.php
===================================================================
RCS file: /cvsroot/openfirst/logger/index.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** index.php 13 Oct 2003 17:57:22 -0000 1.5
--- index.php 15 Oct 2003 01:02:53 -0000 1.6
***************
*** 27,30 ****
--- 27,35 ----
*/
+ if(!isset($user->user)||$user->membertype!="administrator"){
+ header("Location: stats.php");
+ exit;
+ }
+
include_once("../config/globals.php");
***************
*** 90,92 ****
<?php
include_once("$footer");
! ?>
\ No newline at end of file
--- 95,97 ----
<?php
include_once("$footer");
! ?>
Index: rawdata.php
===================================================================
RCS file: /cvsroot/openfirst/logger/rawdata.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** rawdata.php 13 Oct 2003 17:57:22 -0000 1.7
--- rawdata.php 15 Oct 2003 01:02:54 -0000 1.8
***************
*** 26,29 ****
--- 26,35 ----
*
*/
+
+ if(!isset($user->user)||$user->membertype!="administrator"){
+ header("Location: stats.php");
+ exit;
+ }
+
include_once("../config/globals.php");
include_once("$header");
***************
*** 66,77 ****
while($log = ofirst_dbfetch_object($query)){
echo "<tr>";
! echo " <td>$log->ID</td>";
! echo " <td>$log->Date</td>";
! echo " <td>$log->IPAddress</td>";
! echo " <td>$log->HostLookup</td>";
! echo " <td>$log->Location</td>";
! echo " <td>$log->QueryString</td>";
! echo " <td>[ <a href='rawdata.php?DELETE=$log->ID'>Delete</a> ]</td>";
! echo "</tr>";
}
?>
--- 72,83 ----
while($log = ofirst_dbfetch_object($query)){
echo "<tr>";
! echo " <td>$log->ID</td>";
! echo " <td>$log->Date</td>";
! echo " <td>$log->IPAddress</td>";
! echo " <td>$log->HostLookup</td>";
! echo " <td>$log->Location</td>";
! echo " <td>$log->QueryString</td>";
! echo " <td>[ <a href='rawdata.php?DELETE=$log->ID'>Delete</a> ]</td>";
! echo "</tr>";
}
?>
***************
*** 80,82 ****
<?php
include_once("$footer");
! ?>
\ No newline at end of file
--- 86,88 ----
<?php
include_once("$footer");
! ?>
Index: track.php
===================================================================
RCS file: /cvsroot/openfirst/logger/track.php,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** track.php 13 Oct 2003 17:57:22 -0000 1.12
--- track.php 15 Oct 2003 01:02:54 -0000 1.13
***************
*** 26,29 ****
--- 26,35 ----
*
*/
+
+ if(!isset($user->user)||$user->membertype!="administrator"){
+ header("Location: stats.php");
+ exit;
+ }
+
include_once("../config/globals.php");
include_once("$header");
|
|
From: <i-...@us...> - 2003-10-15 00:52:57
|
Update of /cvsroot/openfirst/base/config
In directory sc8-pr-cvs1:/tmp/cvs-serv8022/config
Modified Files:
auth.php
Log Message:
showlogin() now remembers the HTTP referer. The client script can use this information to return to previous location after login (used by the forum).
Index: auth.php
===================================================================
RCS file: /cvsroot/openfirst/base/config/auth.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** auth.php 15 Oct 2003 00:14:41 -0000 1.7
--- auth.php 15 Oct 2003 00:52:52 -0000 1.8
***************
*** 57,63 ****
function showlogin () {
// Show a login form for the user.
!
! echo("<br><br><form action='". $_SERVER["PHP_SELF"] . "' method='post'>
! <table width='27%'>
<tr>
<th width='36%'> </th>
--- 57,65 ----
function showlogin () {
// Show a login form for the user.
! echo("<br><br><form action='". $_SERVER["PHP_SELF"] . "' method='post'>");
! if(isset($_SERVER["HTTP_REFERER"])){
! echo("<input name='referer' type='hidden' value='".$_SERVER["HTTP_REFERER"]."'/>");
! }
! echo("<table width='27%'>
<tr>
<th width='36%'> </th>
|
|
From: <i-...@us...> - 2003-10-15 00:50:13
|
Update of /cvsroot/openfirst/forum
In directory sc8-pr-cvs1:/tmp/cvs-serv7415/forum
Modified Files:
editpost.php index.php newpost.php
Added Files:
login.php
Log Message:
The forum module now has login/logout functionality.
--- NEW FILE: login.php ---
<?php
/*
* openFIRST.forum - index.php
*
* Copyright (C) 2003,
* openFIRST Project
* Original Author: Greg Inozemtsev <gr...@si...>
*
* 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");
include($header);
if(isset($user->user)&&!isset($_GET["logout"]))
{
echo("<br /><table><tr><th>Forum Login</th></tr><tr><td>");
echo("<p>You are logged in as <b>$user->user</b>.</p>");
echo('<div align=center><a href=login.php?logout=1>Logout</a></div><br />');
echo("</td></tr></table><br />");
}
else{
if(isset($user->user)){
logout();
}
echo('<h2>Forum Login</h2><div style="width:300px;border-width:1px;border-style:dotted;padding:5px;background:url(\''.$basepath.'/images/back-lighter.gif\');">You need to log in to use this feature of the forum.<br />
If you are not registered yet? <b><a href=register.php>Register Now!</a></b></div>');
showlogin();
}
if(isset($_POST['referer'])&&(!ereg("login.php",$_POST['referer']))){
$back=$_POST['referer'];
}
if(isset($_SERVER['HTTP_REFERER'])&&(!ereg("login.php",$_SERVER['HTTP_REFERER']))){
$back=$_SERVER['HTTP_REFERER'];
}
if(isset($back)){
echo('<div><a href="'.$back.'">Back to forum</a></div>');
}
include($footer);
?>
Index: editpost.php
===================================================================
RCS file: /cvsroot/openfirst/forum/editpost.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** editpost.php 13 Oct 2003 20:10:37 -0000 1.1
--- editpost.php 15 Oct 2003 00:50:08 -0000 1.2
***************
*** 155,159 ****
else {
//not logged in: redirect to login
! header("Location: ".$basepath."/members");
}
?>
--- 155,159 ----
else {
//not logged in: redirect to login
! header("Location: login.php");
}
?>
Index: index.php
===================================================================
RCS file: /cvsroot/openfirst/forum/index.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** index.php 13 Oct 2003 22:17:11 -0000 1.2
--- index.php 15 Oct 2003 00:50:08 -0000 1.3
***************
*** 90,97 ****
echo("Welcome ");
if(isset($user->user)){
! echo($user->user);
}
}
! echo("</i></h4></th><td align=right><div>");
if($cat->closed){
echo("<i>Closed Forum</i></div><div>");
--- 90,102 ----
echo("Welcome ");
if(isset($user->user)){
! echo($user->user."</i></h4>");
! echo("<div align=right><a href=login.php>Logout</a></div>");
! }
! else{
! echo("</i></h4>");
! echo("<div align=right><a href=login.php>Login</a></div>");
}
}
! echo("</th><td align=right><div>");
if($cat->closed){
echo("<i>Closed Forum</i></div><div>");
Index: newpost.php
===================================================================
RCS file: /cvsroot/openfirst/forum/newpost.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** newpost.php 13 Oct 2003 20:10:37 -0000 1.1
--- newpost.php 15 Oct 2003 00:50:08 -0000 1.2
***************
*** 144,148 ****
else {
//not logged in: redirect to login
! header("Location: ".$basepath."/members");
}
?>
--- 144,148 ----
else {
//not logged in: redirect to login
! header("Location: login.php");
}
?>
|
|
From: <i-...@us...> - 2003-10-15 00:16:09
|
Update of /cvsroot/openfirst/members
In directory sc8-pr-cvs1:/tmp/cvs-serv3354/members
Modified Files:
logout.php
Log Message:
Moved logout code to logout() function in config/auth.php to allow it to be shared by several modules.
Index: logout.php
===================================================================
RCS file: /cvsroot/openfirst/members/logout.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** logout.php 23 Aug 2003 20:31:16 -0000 1.5
--- logout.php 15 Oct 2003 00:16:02 -0000 1.6
***************
*** 30,47 ****
if(isset($user->user)) {
! ?>
!
! <h1>Logged Out</h1>
! <?php
! $q = ofirst_dbquery("UPDATE ofirst_members SET authcode = NULL WHERE user='$user->user';");
! echo(ofirst_dberror());
! @session_start();
! @session_destroy();
! ?>
!
! <p>You have been logged out of this web site.</p>
!
! <?php
! } else {
echo("<h1>Cannot Logout</h1><p>You must be logged in in order to log out.</p>");
showlogin();
--- 30,37 ----
if(isset($user->user)) {
! logout();
! echo("<h1>Logged Out</h1><p>You have been logged out of this web site.</p>");
! }
! else {
echo("<h1>Cannot Logout</h1><p>You must be logged in in order to log out.</p>");
showlogin();
|
|
From: <i-...@us...> - 2003-10-15 00:14:45
|
Update of /cvsroot/openfirst/base/config
In directory sc8-pr-cvs1:/tmp/cvs-serv3155/config
Modified Files:
auth.php
Log Message:
Moved logout functionality to this script to allow it to be shared by several modules.
Index: auth.php
===================================================================
RCS file: /cvsroot/openfirst/base/config/auth.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** auth.php 13 Oct 2003 17:12:29 -0000 1.6
--- auth.php 15 Oct 2003 00:14:41 -0000 1.7
***************
*** 46,49 ****
--- 46,58 ----
}
+ function logout(){
+ if(isset($GLOBALS["user"]->user)) {
+ $q = ofirst_dbquery("UPDATE ofirst_members SET authcode = NULL WHERE user='".$GLOBALS["user"]->user."';");
+ echo(ofirst_dberror());
+ @session_start();
+ @session_destroy();
+ }
+ }
+
function showlogin () {
// Show a login form for the user.
|
|
From: <dav...@us...> - 2003-10-14 00:04:57
|
Update of /cvsroot/openfirst/projects
In directory sc8-pr-cvs1:/tmp/cvs-serv10007
Modified Files:
updates.php
Log Message:
Update script has been modified to send e-mails properly.
Index: updates.php
===================================================================
RCS file: /cvsroot/openfirst/projects/updates.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** updates.php 13 Oct 2003 23:37:52 -0000 1.7
--- updates.php 14 Oct 2003 00:04:54 -0000 1.8
***************
*** 43,47 ****
$message = "";
! $message .= "<h2>$title Action Register Updater</h2>
<div align='left'>Update Template: ".$mailgroup->ProjectsSendTemplate." | Commit Types: ".$mailgroup->ProjectsCommitSelect."</div>
<table width='100%' border='0' cellspacing='0' cellpadding='6'>
--- 43,47 ----
$message = "";
! $message .= "<html><h2>$title Action Register Updater</h2>
<div align='left'>Update Template: ".$mailgroup->ProjectsSendTemplate." | Commit Types: ".$mailgroup->ProjectsCommitSelect."</div>
<table width='100%' border='0' cellspacing='0' cellpadding='6'>
***************
*** 58,62 ****
$message .= "<table width='100%' border='0' cellspacing='0' cellpadding='6'>
<tr>
! <td bgcolor='#CCCCCC'> <div align='center'><font color='#000000'><strong>".$group->GroupName."</strong></font></div></td>
</tr>
</table>
--- 58,63 ----
$message .= "<table width='100%' border='0' cellspacing='0' cellpadding='6'>
<tr>
! <td bgcolor='#CCCCCC'> <div align='center'><font color='#000000'><strong>".$group->GroupName."</strong></font>
! </div></td>
</tr>
</table>
***************
*** 79,83 ****
$message .="
<tr>
! <td><img src='../members/icons/actions/project_open.png' width='32' height='32'></td>
<td>New Project</td>
<td><font color='red'>".$project->ProjectName."</font></td>
--- 80,84 ----
$message .="
<tr>
! <td><img src='$home/$basepath/members/icons/actions/project_open.png' width='32' height='32'></td>
<td>New Project</td>
<td><font color='red'>".$project->ProjectName."</font></td>
***************
*** 100,109 ****
$message .= "<tr >
! <td><img src='../members/icons/filesystems/desktop.png' width='32' height='32'></td>
<td>New Task</td>
<td>".$taskproject->ProjectName."</td>
<td><font color='red'>".$task->TaskName."</font></td>
<td>".$task->Description."</td>
! <td>".$task->Assigned."/td>
</tr>";
--- 101,110 ----
$message .= "<tr >
! <td><img src='$home/$basepath/members/icons/filesystems/desktop.png' width='32' height='32'></td>
<td>New Task</td>
<td>".$taskproject->ProjectName."</td>
<td><font color='red'>".$task->TaskName."</font></td>
<td>".$task->Description."</td>
! <td>".$task->Assigned."</td>
</tr>";
***************
*** 124,128 ****
$message .= "<tr>
! <td><img src='../members/icons/filesystems/files.png' width='32' height='32'></td>
<td>New Note Commited</td>
<td>".$noteproject->ProjectName."</td>
--- 125,129 ----
$message .= "<tr>
! <td><img src='$home/$basepath/members/icons/filesystems/files.png' width='32' height='32'></td>
<td>New Note Commited</td>
<td>".$noteproject->ProjectName."</td>
***************
*** 135,139 ****
}
! $message .="</table>";
}
--- 136,140 ----
}
! $message .="</table></html>";
}
***************
*** 142,146 ****
echo "<br> Sent to: $mailgroup->email (multipart)";
}else{
! mail($mailgroup->email,"$title Daily Update ".date('F j, Y',time()),$message);
echo "<br> Sent to: $mailgroup->email (mail)";
}
--- 143,155 ----
echo "<br> Sent to: $mailgroup->email (multipart)";
}else{
!
! $headers = "MIME-Version: 1.0\r\n";
! $headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
! $headers .= "From: $mailfrom\r\n";
! $headers .= "Reply-To: ".$mailgroup->email."\r\n";
! $headers .= "X-Priority: 1\r\n";
! $headers .= "X-MSMail-Priority: High\r\n";
!
! mail($mailgroup->email,"$title Daily Update ".date('F j, Y',time()),$message,$headers);
echo "<br> Sent to: $mailgroup->email (mail)";
}
|
|
From: <dav...@us...> - 2003-10-13 23:38:39
|
Update of /cvsroot/openfirst/projects/admin
In directory sc8-pr-cvs1:/tmp/cvs-serv5969/admin
Modified Files:
editgroups.php editprojects.php edittasks.php
Log Message:
Fixed commands to use ofirst database functions instead of mysql.
Index: editgroups.php
===================================================================
RCS file: /cvsroot/openfirst/projects/admin/editgroups.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** editgroups.php 13 Oct 2003 23:09:43 -0000 1.3
--- editgroups.php 13 Oct 2003 23:38:34 -0000 1.4
***************
*** 58,71 ****
}
! $group_query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
! $group = mysql_fetch_object($group_query);
// Edit assigned moderators
if(isset($_POST['editmods'])){
! mysql_query("UPDATE ofirst_projects_groups SET Moderators = '".$_POST['moderators']."' WHERE ID = '".$_GET['GroupID']."';") or die(mysql_error());
! $group_query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
! $group = mysql_fetch_object($group_query);
echo "<br>Moderators list has been updated!";
--- 58,71 ----
}
! $group_query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
! $group = ofirst_dbfetch_object($group_query);
// Edit assigned moderators
if(isset($_POST['editmods'])){
! ofirst_dbquery("UPDATE ofirst_projects_groups SET Moderators = '".$_POST['moderators']."' WHERE ID = '".$_GET['GroupID']."';") or die(mysql_error());
! $group_query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
! $group = ofirst_dbfetch_object($group_query);
echo "<br>Moderators list has been updated!";
***************
*** 76,83 ****
if(isset($_POST['editmembers'])){
! mysql_query("UPDATE ofirst_projects_groups SET Members = '".$_POST['members']."' WHERE ID = '".$_GET['GroupID']."';");
! $group_query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
! $group = mysql_fetch_object($group_query);
echo "<br>Members list has been updated!";
--- 76,83 ----
if(isset($_POST['editmembers'])){
! ofirst_dbquery("UPDATE ofirst_projects_groups SET Members = '".$_POST['members']."' WHERE ID = '".$_GET['GroupID']."';");
! $group_query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
! $group = ofirst_dbfetch_object($group_query);
echo "<br>Members list has been updated!";
Index: editprojects.php
===================================================================
RCS file: /cvsroot/openfirst/projects/admin/editprojects.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** editprojects.php 13 Oct 2003 23:09:43 -0000 1.2
--- editprojects.php 13 Oct 2003 23:38:34 -0000 1.3
***************
*** 56,69 ****
}
! $project_query = mysql_query("SELECT * FROM ofirst_projects_projects WHERE ID = '".$_GET['ProjectID']."'");
! $project = mysql_fetch_object($project_query);
// Edit assigned members to project
if(isset($_POST['editmembers'])){
! mysql_query("UPDATE ofirst_projects_projects SET Assigned = '".$_POST['members']."' WHERE ID = '".$_GET['ProjectID']."';");
! $project_query = mysql_query("SELECT * FROM ofirst_projects_projects WHERE ID = '".$_GET['ProjectID']."'");
! $project = mysql_fetch_object($project_query);
echo "<br>Members list has been updated!";
--- 56,69 ----
}
! $project_query = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE ID = '".$_GET['ProjectID']."'");
! $project = ofirst_dbfetch_object($project_query);
// Edit assigned members to project
if(isset($_POST['editmembers'])){
! ofirst_dbquery("UPDATE ofirst_projects_projects SET Assigned = '".$_POST['members']."' WHERE ID = '".$_GET['ProjectID']."';");
! $project_query = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE ID = '".$_GET['ProjectID']."'");
! $project = ofirst_dbfetch_object($project_query);
echo "<br>Members list has been updated!";
Index: edittasks.php
===================================================================
RCS file: /cvsroot/openfirst/projects/admin/edittasks.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** edittasks.php 13 Oct 2003 23:09:43 -0000 1.3
--- edittasks.php 13 Oct 2003 23:38:34 -0000 1.4
***************
*** 55,60 ****
}
! $task_query = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$_GET['TaskID']."'");
! $task = mysql_fetch_object($task_query);
--- 55,60 ----
}
! $task_query = ofirst_dbquery("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$_GET['TaskID']."'");
! $task = ofirst_dbfetch_object($task_query);
***************
*** 62,69 ****
if(isset($_POST['editmembers'])){
! mysql_query("UPDATE ofirst_projects_tasks SET Assigned = '".$_POST['members']."' WHERE ID = '".$_GET['TaskID']."';");
! $task_query = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$_GET['TaskID']."'");
! $task = mysql_fetch_object($task_query);
echo "<br>Members list has been updated!";
--- 62,69 ----
if(isset($_POST['editmembers'])){
! ofirst_dbquery("UPDATE ofirst_projects_tasks SET Assigned = '".$_POST['members']."' WHERE ID = '".$_GET['TaskID']."';");
! $task_query = ofirst_dbquery("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$_GET['TaskID']."'");
! $task = ofirst_dbfetch_object($task_query);
echo "<br>Members list has been updated!";
|
|
From: <dav...@us...> - 2003-10-13 23:37:56
|
Update of /cvsroot/openfirst/projects
In directory sc8-pr-cvs1:/tmp/cvs-serv5832
Modified Files:
groups.php updates.php viewmembers.php
Log Message:
Fixed commands to use ofirst database functions instead of mysql.
Index: groups.php
===================================================================
RCS file: /cvsroot/openfirst/projects/groups.php,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** groups.php 12 Oct 2003 23:39:14 -0000 1.12
--- groups.php 13 Oct 2003 23:37:52 -0000 1.13
***************
*** 127,131 ****
// If administrator is logged in then show the admin edit option
if($user->membertype == "administrator"){ ?>
! <td id="adminmenu" background="/openfirst/images/back-admin.png"><p align="center"><a href="admin/editgroups.php?GroupID=<?php echo $groups->ID; ?>">Edit</a></p></td>';
<?php }
?>
--- 127,131 ----
// If administrator is logged in then show the admin edit option
if($user->membertype == "administrator"){ ?>
! <td id="adminmenu" background="/openfirst/images/back-admin.png"><p align="center"><a href="admin/editgroups.php?GroupID=<?php echo $groups->ID; ?>">Edit</a></p></td>
<?php }
?>
Index: updates.php
===================================================================
RCS file: /cvsroot/openfirst/projects/updates.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** updates.php 3 Oct 2003 02:16:39 -0000 1.6
--- updates.php 13 Oct 2003 23:37:52 -0000 1.7
***************
*** 30,35 ****
include("../config/globals.php");
! $mailgroupquery = mysql_query("SELECT * FROM ofirst_members WHERE ProjectsUpdates = 'On'") or die(mysql_error());
! while($mailgroup = mysql_fetch_object($mailgroupquery)){
if(! isset($mailgroup->email)){
--- 30,35 ----
include("../config/globals.php");
! $mailgroupquery = ofirst_dbquery("SELECT * FROM ofirst_members WHERE ProjectsUpdates = 'On'") or die(mysql_error());
! while($mailgroup = ofirst_dbfetch_object($mailgroupquery)){
if(! isset($mailgroup->email)){
***************
*** 53,58 ****
// 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)){
$message .= "<table width='100%' border='0' cellspacing='0' cellpadding='6'>
--- 53,58 ----
// Run through the current list of groups to preview there related information
! $groupquery = ofirst_dbquery("SELECT * FROM ofirst_projects_groups");
! while($group = ofirst_dbfetch_object($groupquery)){
$message .= "<table width='100%' border='0' cellspacing='0' cellpadding='6'>
***************
*** 72,77 ****
// 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(date('F j, Y',time()) == date("F j, Y",$project->Dates)){
--- 72,77 ----
// Listed the newly added projects for this day
! $projectquery = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE GroupID = '".$group->ID."'");
! while($project = ofirst_dbfetch_object($projectquery)){
if(date('F j, Y',time()) == date("F j, Y",$project->Dates)){
***************
*** 91,99 ****
// 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(date('F j, Y',time()) == date("F j, Y",$task->Dates)){
--- 91,99 ----
// 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."'");
! $taskproject = ofirst_dbfetch_object($taskprojquery);
if(date('F j, Y',time()) == date("F j, Y",$task->Dates)){
***************
*** 112,123 ****
// 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(date('F j, Y',time()) == date('F j, Y',$note->Dates)){
--- 112,123 ----
// 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(date('F j, Y',time()) == date('F j, Y',$note->Dates)){
Index: viewmembers.php
===================================================================
RCS file: /cvsroot/openfirst/projects/viewmembers.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** viewmembers.php 12 Oct 2003 23:41:31 -0000 1.1
--- viewmembers.php 13 Oct 2003 23:37:52 -0000 1.2
***************
*** 35,40 ****
} else {
! $group_query = mysql_query("SELECT * FROM ofirst_projects_groups");
! $group = mysql_fetch_object($group_query);
?>
--- 35,40 ----
} else {
! $group_query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups");
! $group = ofirst_dbfetch_object($group_query);
?>
***************
*** 52,57 ****
foreach($assigned as $assign){
! $member_query = mysql_query("SELECT * FROM ofirst_members WHERE user = '".$assign."'");
! $member = mysql_fetch_object($member_query);
echo "<td>$assign</td>";
--- 52,57 ----
foreach($assigned as $assign){
! $member_query = ofirst_dbquery("SELECT * FROM ofirst_members WHERE user = '".$assign."'");
! $member = ofirst_dbfetch_object($member_query);
echo "<td>$assign</td>";
|
|
From: <dav...@us...> - 2003-10-13 23:31:34
|
Update of /cvsroot/openfirst/projects
In directory sc8-pr-cvs1:/tmp/cvs-serv4975
Modified Files:
notes.php tasks.php
Log Message:
Added project completion feature below project tree.
Index: notes.php
===================================================================
RCS file: /cvsroot/openfirst/projects/notes.php,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -d -r1.11 -r1.12
*** notes.php 13 Oct 2003 23:04:02 -0000 1.11
--- notes.php 13 Oct 2003 23:31:30 -0000 1.12
***************
*** 66,72 ****
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));
}
--- 66,72 ----
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']."'>Current Notes</a> ]<br><br>";
die(include($footer));
}
***************
*** 91,95 ****
<th> Navigation </th>
<tr>
! <td><?php projecttree("tasks",$_GET['ProjectID']); ?></td>
</table></td>
<td width="78%" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="6">
--- 91,129 ----
<th> Navigation </th>
<tr>
! <td><?php projecttree("tasks",$_GET['ProjectID']); ?></td></tr>
! <th>Set Task Completion </th>
! <tr>
! <td> <form method="POST" action="notes.php?TaskID=<?php echo $_GET['TaskID']; ?>&GroupID=<?php echo $_GET['GroupID']; ?>&ProjectID=<?php echo $_GET['ProjectID']; ?>">
! <p>
! <select name="completion" id="completion">
! <option selected><?php echo $task->Completion; ?></option>
! <option>---</option>
! <option>0</option>
! <option>5</option>
! <option>10</option>
! <option>15</option>
! <option>20</option>
! <option>25</option>
! <option>30</option>
! <option>35</option>
! <option>40</option>
! <option>45</option>
! <option>50</option>
! <option>55</option>
! <option>60</option>
! <option>65</option>
! <option>70</option>
! <option>75</option>
! <option>80</option>
! <option>85</option>
! <option>90</option>
! <option>95</option>
! <option>100</option>
! </select>
! <input name="addcompletion" type="submit" id="addcompletion" value="Set Completion">
! <font size="1"><br>
! (Allows you to change the completion of the task that these notes
! belong to)</font> </p>
! </form></td>
</table></td>
<td width="78%" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="6">
Index: tasks.php
===================================================================
RCS file: /cvsroot/openfirst/projects/tasks.php,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** tasks.php 13 Oct 2003 03:32:33 -0000 1.12
--- tasks.php 13 Oct 2003 23:31:30 -0000 1.13
***************
*** 77,81 ****
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>";
die(include($footer));
}
--- 77,81 ----
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']."'>Projects</a> ]<br><br>";
die(include($footer));
}
***************
*** 95,99 ****
<tr><th>Navigation</th><tr>
<td><?php projecttree("tasks",$_GET['ProjectID']); ?></td>
! </table></td>
<td width="78%" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="6">
<tr>
--- 95,134 ----
<tr><th>Navigation</th><tr>
<td><?php projecttree("tasks",$_GET['ProjectID']); ?></td>
! <tr>
! <th>Set Project Completion </th>
! <tr>
! <td>
! <form method="POST" action="tasks.php?GroupID=<?php echo $_GET['GroupID']; ?>&ProjectID=<?php echo $_GET['ProjectID']; ?>">
! <select name="completion" id="completion">
! <option selected><?php echo $project->Completion; ?></option>
! <option>---</option>
! <option>0</option>
! <option>5</option>
! <option>10</option>
! <option>15</option>
! <option>20</option>
! <option>25</option>
! <option>30</option>
! <option>35</option>
! <option>40</option>
! <option>45</option>
! <option>50</option>
! <option>55</option>
! <option>60</option>
! <option>65</option>
! <option>70</option>
! <option>75</option>
! <option>80</option>
! <option>85</option>
! <option>90</option>
! <option>95</option>
! <option>100</option>
! </select>
! <input name="addcompletion" type="submit" id="addcompletion" value="Set Completion">
! <br>
! <font size="1">(Allows you to change the completion of the project
! that these tasks are related to)</font>
! </form></td>
! </table></td>
<td width="78%" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="6">
<tr>
|
|
From: <dav...@us...> - 2003-10-13 23:16:08
|
Update of /cvsroot/openfirst/projects/setup In directory sc8-pr-cvs1:/tmp/cvs-serv2798/setup Modified Files: setup.mssql setup.mysql Log Message: The setup files required the new fields. Index: setup.mssql =================================================================== RCS file: /cvsroot/openfirst/projects/setup/setup.mssql,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** setup.mssql 13 Oct 2003 22:40:35 -0000 1.5 --- setup.mssql 13 Oct 2003 23:16:04 -0000 1.6 *************** *** 1,5 **** CREATE TABLE `ofirst_projects_groups` ( `ID` int(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` int(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` int(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` int(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` int(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; --- 1,5 ---- CREATE TABLE `ofirst_projects_groups` ( `ID` int(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` int(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` int(3) unsigned NOT NULL auto_increment, `ProjectID` tinyint(8) default NULL, `AttachedFile` blob, `mime` text, `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` int(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` int(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; Index: setup.mysql =================================================================== RCS file: /cvsroot/openfirst/projects/setup/setup.mysql,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** setup.mysql 13 Oct 2003 22:40:35 -0000 1.7 --- setup.mysql 13 Oct 2003 23:16:04 -0000 1.8 *************** *** 1,5 **** CREATE TABLE `ofirst_projects_groups` ( `ID` int(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` int(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` int(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` int(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` int(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; --- 1,5 ---- CREATE TABLE `ofirst_projects_groups` ( `ID` int(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` int(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` int(3) unsigned NOT NULL auto_increment, `ProjectID` tinyint(8) default NULL, `AttachedFile` blob, `mime` text, `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` int(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` int(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; |
|
From: <dav...@us...> - 2003-10-13 23:09:46
|
Update of /cvsroot/openfirst/projects/admin
In directory sc8-pr-cvs1:/tmp/cvs-serv1617/admin
Modified Files:
editgroups.php editprojects.php edittasks.php
Log Message:
Fixed many script bugs and problems. They are not set to work accordingly.
Index: editgroups.php
===================================================================
RCS file: /cvsroot/openfirst/projects/admin/editgroups.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** editgroups.php 13 Oct 2003 03:32:33 -0000 1.2
--- editgroups.php 13 Oct 2003 23:09:43 -0000 1.3
***************
*** 61,64 ****
--- 61,65 ----
$group = mysql_fetch_object($group_query);
+ // Edit assigned moderators
if(isset($_POST['editmods'])){
***************
*** 72,75 ****
--- 73,77 ----
}
+ // Edit assigned members to this task
if(isset($_POST['editmembers'])){
***************
*** 92,108 ****
</tr>
</table>
! <p> </p>
<form action="editgroups.php?GroupID=<?php echo $_GET['GroupID']; ?>" method="POST">
- <p><strong>Group Moderator List </strong></p>
<p>
! <textarea name="moderators" cols="60" rows="10" id="moderators"><?php echo $group->Members; ?></textarea>
! </p>
<p>
<input name="editmods" type="submit" id="editmods" value="Edit Moderators">
! </p>
<p><strong>Group Member List</strong> </p>
<p>
<textarea name="members" cols="60" rows="10" id="members"><?php echo $group->Members; ?></textarea>
! </p>
<p>
<input name="editmembers" type="submit" id="editmembers" value="Edit Members">
--- 94,109 ----
</tr>
</table>
! <p><strong>Group Moderator List </strong></p>
<form action="editgroups.php?GroupID=<?php echo $_GET['GroupID']; ?>" method="POST">
<p>
! <textarea name="moderators" cols="60" rows="10" id="textarea"><?php echo $group->Moderators; ?></textarea>
! </p>
<p>
<input name="editmods" type="submit" id="editmods" value="Edit Moderators">
! </p>
<p><strong>Group Member List</strong> </p>
<p>
<textarea name="members" cols="60" rows="10" id="members"><?php echo $group->Members; ?></textarea>
! </p>
<p>
<input name="editmembers" type="submit" id="editmembers" value="Edit Members">
Index: editprojects.php
===================================================================
RCS file: /cvsroot/openfirst/projects/admin/editprojects.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** editprojects.php 13 Oct 2003 22:48:28 -0000 1.1
--- editprojects.php 13 Oct 2003 23:09:43 -0000 1.2
***************
*** 42,53 ****
// 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
! ofirst_dbquery("DELETE FROM ofirst_projects_projects WHERE ID = '".$_POST['task']."'") or die(ofirst_dberror());
! 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());
echo "<br><br>Project removed! [ <a href='index.php'>Main</a> ]<br><br>";
--- 42,53 ----
// 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='editprojects.php?&ProjectID=".$_GET['ProjectID']."'>Projects</a> ]<br><br>";
die(include($footer));
}
// Remove every task related value in the database
! ofirst_dbquery("DELETE FROM ofirst_projects_projects WHERE ID = '".$_GET['ProjectID']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_tasks WHERE ID = '".$_GET['ProjectID']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_notes WHERE TaskID = '".$_GET['ProjectID']."'") or die(ofirst_dberror());
echo "<br><br>Project removed! [ <a href='index.php'>Main</a> ]<br><br>";
***************
*** 56,68 ****
}
! $task_query = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$_GET['ProjectID']."'");
! $task = mysql_fetch_object($task_query);
if(isset($_POST['editmembers'])){
! mysql_query("UPDATE ofirst_projects_projects SET Assigned = '".$_POST['members']."' WHERE ID = '".$_GET['TaskID']."';");
! $task_query = mysql_query("SELECT * FROM ofirst_projects_projects WHERE ID = '".$_GET['TaskID']."'");
! $task = mysql_fetch_object($group_query);
echo "<br>Members list has been updated!";
--- 56,69 ----
}
! $project_query = mysql_query("SELECT * FROM ofirst_projects_projects WHERE ID = '".$_GET['ProjectID']."'");
! $project = mysql_fetch_object($project_query);
+ // Edit assigned members to project
if(isset($_POST['editmembers'])){
! mysql_query("UPDATE ofirst_projects_projects SET Assigned = '".$_POST['members']."' WHERE ID = '".$_GET['ProjectID']."';");
! $project_query = mysql_query("SELECT * FROM ofirst_projects_projects WHERE ID = '".$_GET['ProjectID']."'");
! $project = mysql_fetch_object($project_query);
echo "<br>Members list has been updated!";
***************
*** 71,75 ****
?>
! <h2>Edit Project <font color="red"><?php echo $task->TaskName; ?></font></h2>
<h2><font color="red"></font></h2>
<table width="600">
--- 72,76 ----
?>
! <h2>Edit Project <font color="red"><?php echo $project->ProjectName; ?></font></h2>
<h2><font color="red"></font></h2>
<table width="600">
***************
*** 81,88 ****
</table>
<p> </p>
! <form action="editgroups.php?GroupID=<?php echo $_GET['GroupID']; ?>" method="POST">
! <p><strong>Group Member List</strong> </p>
<p>
! <textarea name="members" cols="60" rows="10" id="members"><?php echo $task->Assigned; ?></textarea>
</p>
<p>
--- 82,89 ----
</table>
<p> </p>
! <form action="editprojects.php?ProjectID=<?php echo $_GET['ProjectID']; ?>" method="POST">
! <p><strong>Assigned Members To Project </strong> </p>
<p>
! <textarea name="members" cols="60" rows="10" id="members"><?php echo $project->Assigned; ?></textarea>
</p>
<p>
Index: edittasks.php
===================================================================
RCS file: /cvsroot/openfirst/projects/admin/edittasks.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** edittasks.php 13 Oct 2003 03:32:33 -0000 1.2
--- edittasks.php 13 Oct 2003 23:09:43 -0000 1.3
***************
*** 42,54 ****
// 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
! 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());
! echo "<br><br>Task removed! [ <a href='tasks.php?GroupID=".$_GET['GroupID']."&ProjectID=".$_GET['ProjectID']."'>Projects</a> ]<br><br>";
die(include($footer));
--- 42,54 ----
// 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='edittasks.php?GroupID=".$_GET['TaskID']."'>Tasks</a> ]<br><br>";
die(include($footer));
}
// Remove every task related value in the database
! ofirst_dbquery("DELETE FROM ofirst_projects_tasks WHERE ID = '".$_GET['TaskID']."'") or die(ofirst_dberror());
! ofirst_dbquery("DELETE FROM ofirst_projects_notes WHERE TaskID = '".$_GET['TaskID']."'") or die(ofirst_dberror());
! echo "<br><br>Task removed! [ <a href='../groups.php'>Main</a> ]<br><br>";
die(include($footer));
***************
*** 58,61 ****
--- 58,63 ----
$task = mysql_fetch_object($task_query);
+
+ // Edit assigned members to task
if(isset($_POST['editmembers'])){
***************
*** 63,67 ****
$task_query = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$_GET['TaskID']."'");
! $task = mysql_fetch_object($group_query);
echo "<br>Members list has been updated!";
--- 65,69 ----
$task_query = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$_GET['TaskID']."'");
! $task = mysql_fetch_object($task_query);
echo "<br>Members list has been updated!";
***************
*** 79,85 ****
</tr>
</table>
! <p> </p>
! <form action="editgroups.php?GroupID=<?php echo $_GET['GroupID']; ?>" method="POST">
! <p><strong>Group Member List</strong> </p>
<p>
<textarea name="members" cols="60" rows="10" id="members"><?php echo $task->Assigned; ?></textarea>
--- 81,86 ----
</tr>
</table>
! <p><strong>Group Member List</strong> </p>
! <form action="edittasks.php?TaskID=<?php echo $_GET['TaskID']; ?>" method="POST">
<p>
<textarea name="members" cols="60" rows="10" id="members"><?php echo $task->Assigned; ?></textarea>
|
|
From: <i-...@us...> - 2003-10-13 23:04:20
|
Update of /cvsroot/openfirst/projects
In directory sc8-pr-cvs1:/tmp/cvs-serv673/projects
Added Files:
getfile.php
Log Message:
Download support.
--- NEW FILE: getfile.php ---
<?php
/*
* openFIRST.projects - getfile.php
*
* Copyright (C) 2003,
* openFIRST Project
* Original Author: Greg Inozemtsev <gr...@si...>
*
* 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");
if(isset($_GET["id"])){
$id=$_GET["id"];
}
else{
die("File not found");
}
$query=ofirst_dbquery("SELECT AttachedFile,mime FROM ofirst_projects_notes WHERE ID='".$id."';");
if (ofirst_dbnum_rows($query)==0){
die("File not found");
}
else {
$file = ofirst_dbfetch_object($query);
header("Content-type: ".$file->mime);
echo(base64_decode($file->AttachedFile));
}
?>
|
|
From: <i-...@us...> - 2003-10-13 23:04:05
|
Update of /cvsroot/openfirst/projects
In directory sc8-pr-cvs1:/tmp/cvs-serv550/projects
Modified Files:
notes.php
Log Message:
Bug fixes, download support.
Index: notes.php
===================================================================
RCS file: /cvsroot/openfirst/projects/notes.php,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** notes.php 13 Oct 2003 03:32:33 -0000 1.10
--- notes.php 13 Oct 2003 23:04:02 -0000 1.11
***************
*** 37,42 ****
// Create button process
if(isset($_POST['create'])){
!
! $bindata = file_get_contents($_FILES['notefile']['tmp_name'])){
$bindata = base64_encode($bindata);
--- 37,42 ----
// Create button process
if(isset($_POST['create'])){
!
! if($bindata = file_get_contents($_FILES['notefile']['tmp_name'])){
$bindata = base64_encode($bindata);
***************
*** 47,51 ****
Description = '".$_POST['description']."',
Commiter = '".$user->user."',
! AttachedFile = '".$bindata."',
Dates = '".time()."'") or die(ofirst_dberror());
--- 47,52 ----
Description = '".$_POST['description']."',
Commiter = '".$user->user."',
! AttachedFile = '".$bindata."',
! mime = '".$_FILES['notefile']['type']."',
Dates = '".time()."'") or die(ofirst_dberror());
***************
*** 53,56 ****
--- 54,58 ----
die(include($footer));
}
+ }
// Addcompletion button process
***************
*** 101,105 ****
<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
--- 103,108 ----
<td class="sub" width="17%">Date</td>
<td class="sub" width="63%">Note Write Up</td>
! <td class="sub" width="10%">Commiter</td>
! <td class="sub" width="5%">Attachment</td>
</tr>
<?php
***************
*** 115,118 ****
--- 118,124 ----
<td><?php echo $notes->Description; ?></td>
<td><?php echo $notes->Commiter; ?></td>
+ <?php if($notes->mime!=""){ ?>
+ <td><a href="getfile.php?id=<?php echo $notes->ID; ?>">Download</a></td>
+ <?php } else { echo("<td> </td>"); } ?>
</tr>
<?php
***************
*** 122,126 ****
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></td>
--- 128,132 ----
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></td>
***************
*** 138,144 ****
}
}
!
! // Show administrator the add option no matter what
! if($user->membertype == "administrator"){ $show = true; }
if($show){
--- 144,150 ----
}
}
!
! // Show administrator the add option no matter what
! if($user->membertype == "administrator"){ $show = true; }
if($show){
***************
*** 183,186 ****
--- 189,193 ----
}
}
+
include($footer);
?>
|
|
From: <dav...@us...> - 2003-10-13 22:48:33
|
Update of /cvsroot/openfirst/projects/admin
In directory sc8-pr-cvs1:/tmp/cvs-serv29921/admin
Added Files:
editprojects.php
Log Message:
initial upload
--- NEW FILE: editprojects.php ---
<?php
/*
* openFIRST.projects - groups.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 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 {
// 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
ofirst_dbquery("DELETE FROM ofirst_projects_projects WHERE ID = '".$_POST['task']."'") or die(ofirst_dberror());
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());
echo "<br><br>Project removed! [ <a href='index.php'>Main</a> ]<br><br>";
die(include($footer));
}
$task_query = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$_GET['ProjectID']."'");
$task = mysql_fetch_object($task_query);
if(isset($_POST['editmembers'])){
mysql_query("UPDATE ofirst_projects_projects SET Assigned = '".$_POST['members']."' WHERE ID = '".$_GET['TaskID']."';");
$task_query = mysql_query("SELECT * FROM ofirst_projects_projects WHERE ID = '".$_GET['TaskID']."'");
$task = mysql_fetch_object($group_query);
echo "<br>Members list has been updated!";
}
?>
<h2>Edit Project <font color="red"><?php echo $task->TaskName; ?></font></h2>
<h2><font color="red"></font></h2>
<table width="600">
<tr>
<td>To edit the users assigned to this project you must add/remove user names
from the boxes below. User names should be separated by a comma ie. jsomebody,mnobody,ahypithetical
etc. No spaces should be added either. </td>
</tr>
</table>
<p> </p>
<form action="editgroups.php?GroupID=<?php echo $_GET['GroupID']; ?>" method="POST">
<p><strong>Group Member List</strong> </p>
<p>
<textarea name="members" cols="60" rows="10" id="members"><?php echo $task->Assigned; ?></textarea>
</p>
<p>
<input name="editmembers" type="submit" id="editmembers" value="Edit Members">
</p>
<p>
<input name="confirm" type="checkbox" id="confirm" value="checkbox">
Remove this project and all its related data from the database.
<input name="remove" type="submit" id="remove" value="Remove Task">
</form>
<?php
} include($footer);
?>
|
|
From: <i-...@us...> - 2003-10-13 22:40:40
|
Update of /cvsroot/openfirst/projects/setup In directory sc8-pr-cvs1:/tmp/cvs-serv28847/projects/setup Modified Files: setup.mssql setup.mysql Log Message: Fixed module config code Index: setup.mssql =================================================================== RCS file: /cvsroot/openfirst/projects/setup/setup.mssql,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** setup.mssql 12 Oct 2003 23:39:51 -0000 1.4 --- setup.mssql 13 Oct 2003 22:40:35 -0000 1.5 *************** *** 4,8 **** CREATE TABLE `ofirst_projects_projects` ( `ID` int(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` int(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',adminnavigation='<a href="$basepath/projects/admin/updatesetup.php">Update Service Setup</a>',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>',includes='projectsmodule.php'; ALTER TABLE ofirst_members ADD COLUMN ProjectsUpdates tinytext ALTER TABLE ofirst_members ADD COLUMN ProjectsCommitSelect tinytext --- 4,8 ---- CREATE TABLE `ofirst_projects_projects` ( `ID` int(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` int(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 modulename='projects',showonmenu='0',active='0',adminnavigation='<a href="$basepath/projects/admin/updatesetup.php">Update Service Setup</a>',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>',includes='projectsmodule.php'; ALTER TABLE ofirst_members ADD COLUMN ProjectsUpdates tinytext ALTER TABLE ofirst_members ADD COLUMN ProjectsCommitSelect tinytext Index: setup.mysql =================================================================== RCS file: /cvsroot/openfirst/projects/setup/setup.mysql,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -d -r1.6 -r1.7 *** setup.mysql 12 Oct 2003 23:39:51 -0000 1.6 --- setup.mysql 13 Oct 2003 22:40:35 -0000 1.7 *************** *** 4,8 **** CREATE TABLE `ofirst_projects_projects` ( `ID` int(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` int(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',adminnavigation='<a href="$basepath/projects/admin/updatesetup.php">Update Service Setup</a>',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>',includes='projectsmodule.php'; ALTER TABLE ofirst_members ADD COLUMN ProjectsUpdates tinytext; ALTER TABLE ofirst_members ADD COLUMN ProjectsCommitSelect tinytext; --- 4,8 ---- CREATE TABLE `ofirst_projects_projects` ( `ID` int(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` int(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 modulename='projects',showonmenu='0',active='0',adminnavigation='<a href="$basepath/projects/admin/updatesetup.php">Update Service Setup</a>',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>',includes='projectsmodule.php'; ALTER TABLE ofirst_members ADD COLUMN ProjectsUpdates tinytext; ALTER TABLE ofirst_members ADD COLUMN ProjectsCommitSelect tinytext; |
|
From: <i-...@us...> - 2003-10-13 22:19:21
|
Update of /cvsroot/openfirst/forum/setup In directory sc8-pr-cvs1:/tmp/cvs-serv24845/forum/setup Modified Files: setup.mssql setup.mysql Log Message: Changed captions Index: setup.mssql =================================================================== RCS file: /cvsroot/openfirst/forum/setup/setup.mssql,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** setup.mssql 13 Oct 2003 20:22:30 -0000 1.1 --- setup.mssql 13 Oct 2003 22:19:03 -0000 1.2 *************** *** 1,3 **** CREATE TABLE IF NOT EXISTS `ofirst_forum` (`ID` int(6) unsigned NOT NULL auto_increment, `name` varchar(45) NOT NULL default 'main', `message` tinytext, `subforum` bigint(12) unsigned NOT NULL default '0', `hidden` tinyint(1) NOT NULL default '0', `closed` tinyint(1) default '0', UNIQUE KEY `ID` (`ID`), UNIQUE KEY `name` (`name`)) TYPE=MyISAM; CREATE TABLE IF NOT EXISTS `ofirst_forumposts` (`ID` bigint(8) unsigned NOT NULL auto_increment, `forum` varchar(45) NOT NULL default '', `ReplyTo` bigint(45) unsigned NOT NULL default '0', `Title` tinytext NOT NULL, `Author` tinytext NOT NULL, `Message` text, `DatePosted` datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY `ID` (`ID`)) TYPE=MyISAM; ! INSERT INTO ofirst_config SET modulename='forum',showonmenu='0',active='0',adminnavigation='<a href="$basepath/forum/admin/">Subforums</a>',modulenavigation='<a href="$basepath/forum/">Forum Home</a>',includes='forumvisit.php'; --- 1,3 ---- CREATE TABLE IF NOT EXISTS `ofirst_forum` (`ID` int(6) unsigned NOT NULL auto_increment, `name` varchar(45) NOT NULL default 'main', `message` tinytext, `subforum` bigint(12) unsigned NOT NULL default '0', `hidden` tinyint(1) NOT NULL default '0', `closed` tinyint(1) default '0', UNIQUE KEY `ID` (`ID`), UNIQUE KEY `name` (`name`)) TYPE=MyISAM; CREATE TABLE IF NOT EXISTS `ofirst_forumposts` (`ID` bigint(8) unsigned NOT NULL auto_increment, `forum` varchar(45) NOT NULL default '', `ReplyTo` bigint(45) unsigned NOT NULL default '0', `Title` tinytext NOT NULL, `Author` tinytext NOT NULL, `Message` text, `DatePosted` datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY `ID` (`ID`)) TYPE=MyISAM; ! INSERT INTO ofirst_config SET modulename='forum',showonmenu='0',active='0',adminnavigation='<a href="$basepath/forum/admin/">Forum Admin</a>',modulenavigation='<a href="$basepath/forum/">Forum Home</a>',includes='forumvisit.php'; Index: setup.mysql =================================================================== RCS file: /cvsroot/openfirst/forum/setup/setup.mysql,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** setup.mysql 13 Oct 2003 20:22:30 -0000 1.1 --- setup.mysql 13 Oct 2003 22:19:03 -0000 1.2 *************** *** 1,3 **** CREATE TABLE IF NOT EXISTS `ofirst_forum` (`ID` int(6) unsigned NOT NULL auto_increment, `name` varchar(45) NOT NULL default 'main', `message` tinytext, `subforum` bigint(12) unsigned NOT NULL default '0', `hidden` tinyint(1) NOT NULL default '0', `closed` tinyint(1) default '0', UNIQUE KEY `ID` (`ID`), UNIQUE KEY `name` (`name`)) TYPE=MyISAM; CREATE TABLE IF NOT EXISTS `ofirst_forumposts` (`ID` bigint(8) unsigned NOT NULL auto_increment, `forum` varchar(45) NOT NULL default '', `ReplyTo` bigint(45) unsigned NOT NULL default '0', `Title` tinytext NOT NULL, `Author` tinytext NOT NULL, `Message` text, `DatePosted` datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY `ID` (`ID`)) TYPE=MyISAM; ! INSERT INTO ofirst_config SET modulename='forum',showonmenu='0',active='0',adminnavigation='<a href="$basepath/forum/admin/">Subforums</a>',modulenavigation='<a href="$basepath/forum/">Forum Home</a>',includes='forumvisit.php'; --- 1,3 ---- CREATE TABLE IF NOT EXISTS `ofirst_forum` (`ID` int(6) unsigned NOT NULL auto_increment, `name` varchar(45) NOT NULL default 'main', `message` tinytext, `subforum` bigint(12) unsigned NOT NULL default '0', `hidden` tinyint(1) NOT NULL default '0', `closed` tinyint(1) default '0', UNIQUE KEY `ID` (`ID`), UNIQUE KEY `name` (`name`)) TYPE=MyISAM; CREATE TABLE IF NOT EXISTS `ofirst_forumposts` (`ID` bigint(8) unsigned NOT NULL auto_increment, `forum` varchar(45) NOT NULL default '', `ReplyTo` bigint(45) unsigned NOT NULL default '0', `Title` tinytext NOT NULL, `Author` tinytext NOT NULL, `Message` text, `DatePosted` datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY `ID` (`ID`)) TYPE=MyISAM; ! INSERT INTO ofirst_config SET modulename='forum',showonmenu='0',active='0',adminnavigation='<a href="$basepath/forum/admin/">Forum Admin</a>',modulenavigation='<a href="$basepath/forum/">Forum Home</a>',includes='forumvisit.php'; |
|
From: <i-...@us...> - 2003-10-13 22:19:07
|
Update of /cvsroot/openfirst/forum
In directory sc8-pr-cvs1:/tmp/cvs-serv24541/forum
Modified Files:
index.php
Log Message:
Minor bug fixes.
Index: index.php
===================================================================
RCS file: /cvsroot/openfirst/forum/index.php,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** index.php 13 Oct 2003 20:10:37 -0000 1.1
--- index.php 13 Oct 2003 22:17:11 -0000 1.2
***************
*** 35,39 ****
}
! $forum="main";
if(isset($_GET["forum"])){
$forum=strtolower($_GET["forum"]);
--- 35,39 ----
}
! $forum="";
if(isset($_GET["forum"])){
$forum=strtolower($_GET["forum"]);
***************
*** 65,69 ****
echo('<div align=left><a href="'.$basepath.'/forum">'.$title." Forums</a> $res</div>");
! $query="SELECT * FROM ofirst_forum WHERE name='$forum'";
if(!$admin){
$query.=" AND hidden=0";
--- 65,74 ----
echo('<div align=left><a href="'.$basepath.'/forum">'.$title." Forums</a> $res</div>");
! if($forum==""){
! $query="SELECT * FROM ofirst_forum WHERE subforum='0'";
! }
! else{
! $query="SELECT * FROM ofirst_forum WHERE name='$forum'";
! }
if(!$admin){
$query.=" AND hidden=0";
***************
*** 201,206 ****
}
! if($cat->subforum!=0&&$cat->closed==0){
! echo('<div><a href="newpost.php?forumid='.urlencode($forum).'">New Topic</a></div>');
}
--- 206,213 ----
}
! if(isset($cat)){
! if($cat->subforum!=0&&$cat->closed==0){
! echo('<div><a href="newpost.php?forumid='.urlencode($forum).'">New Topic</a></div>');
! }
}
|
|
From: <i-...@us...> - 2003-10-13 22:12:08
|
Update of /cvsroot/openfirst/forum/admin
In directory sc8-pr-cvs1:/tmp/cvs-serv22484/admin
Added Files:
index.php
Log Message:
Admin module for Forum
--- NEW FILE: index.php ---
<?php
/*
* openFIRST.forum - admin/index.php
*
* Copyright (C) 2003,
* openFIRST Project
* Original Author: Greg Inozemtsev <gr...@si...>
*
* 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_once("../../config/globals.php");
include_once($header);
echo("<h1>Forum Admin</h1>");
if (isset($user->membertype)&&$user->membertype=="administrator"){
if(!isset($_POST["act"])) {
$query = ofirst_dbquery("SELECT * FROM ofirst_forum ORDER BY ID");
echo("<table width=300><tr><th colspan=2><label for=cat>Forum</label></th></tr>");
echo('<tr><td align=center colspan=2><form id=ForumAdmin name=ForumAdmin method="POST" action="index.php"><select style="width:250px" name=cat id=cat size=4>');
if(ofirst_dbnum_rows($query)==0){
echo('<option selected value="0">(none)</option></select>');
}
else{
while($cat = ofirst_dbfetch_object($query)){
echo('<option value="'.$cat->ID.'">'.ucfirst($cat->name).'</option>');
}
?>
</select></td></tr>
<tr><td align=right colspan=2>
<input type=button
onclick="{
document.ForumAdmin.act.value='hide';
document.ForumAdmin.submit();
} " value="Hide/Show">
<input type=button
onclick="{
document.ForumAdmin.act.value='close';
document.ForumAdmin.submit();
} " value="Close/Open">
<input type=button
onclick="if(confirm('Deleting a forum deletes all messages in it. Proceed?')){
document.ForumAdmin.act.value='delete';
document.ForumAdmin.submit();
} " value=Delete></td></tr>
<?php
}
?>
<input type=hidden name=act value="new">
<tr><th colspan=2>New Subforum</th></tr>
<tr><td><div><label for=newcat>Title</label></div></td>
<td><input name=newcat id=newcat></tr>
<tr><td><div><label for=newdesc>Description</label></div></td>
<td><input name=newdesc id=newdesc></tr>
<tr><td colspan=2 align=center><input type=submit value="Create"></td></tr>
</td></tr></table></form>
<?php
}
else {
// Action
switch($_POST["act"]){
case "hide": {
if(isset($_POST["cat"])&&$_POST["cat"]!=0){
$q=ofirst_dbquery("SELECT name,hidden FROM ofirst_forum WHERE ID='".$_POST["cat"]."'");
$subforum=ofirst_dbfetch_object($q);
if($subforum->hidden){
ofirst_dbquery("UPDATE ofirst_forum SET hidden='0' WHERE ID='".$_POST["cat"]."'");
echo("<div>Subforum ".$subforum->name." is now visible to all visitors</div>");
}
else{
ofirst_dbquery("UPDATE ofirst_forum SET hidden='1' WHERE ID='".$_POST["cat"]."'");
echo("<div>Subforum ".$subforum->name." is only shown to administrators</div>");
}
}
else{
echo("<div>No action has been performed</div>");
}
break;
}
case "close": {
if(isset($_POST["cat"])&&$_POST["cat"]!=0){
$q=ofirst_dbquery("SELECT name,closed FROM ofirst_forum WHERE ID='".$_POST["cat"]."'");
$subforum=ofirst_dbfetch_object($q);
if($subforum->closed){
ofirst_dbquery("UPDATE ofirst_forum SET closed='0' WHERE ID='".$_POST["cat"]."'");
echo("<div>Subforum ".$subforum->name." is now unlocked</div>");
}
else{
ofirst_dbquery("UPDATE ofirst_forum SET closed='1' WHERE ID='".$_POST["cat"]."'");
echo("<div>Subforum ".$subforum->name." is now locked</div>");
}
}
else{
echo("<div>No action has been performed</div>");
}
break;
}
case "delete": {
if(isset($_POST["cat"])&&$_POST["cat"]!=0){
$q=ofirst_dbquery("SELECT name FROM ofirst_forum WHERE ID='".$_POST["cat"]."'");
$subforum=ofirst_dbfetch_object($q);
ofirst_dbquery("DELETE FROM ofirst_forumposts WHERE forum='".$subforum->name."'");
ofirst_dbquery("DELETE FROM ofirst_forum WHERE ID='".$_POST["cat"]."'");
echo("<div>Subforum ".$subforum->name." deleted</div>");
}
else{
echo("<div>No action has been performed</div>");
}
break;
}
default: {
if($_POST["newcat"]!=""){
$subforum=0;
$q=ofirst_dbquery("SELECT name FROM ofirst_forum WHERE subforum='0'");
if(isset($_POST["cat"])){
$subforum=$_POST["cat"];
}
if(ofirst_dbnum_rows($q)==0||$subforum!=0){
ofirst_dbquery("INSERT INTO ofirst_forum (name, message, subforum) VALUES ('" . $_POST["newcat"] . "', '" . $_POST["newdesc"] . "', '" .$subforum. "');");
echo("<div>Subforum ".$_POST["newcat"]." created</div>");
}
else {
echo("<div>Root category already exists. You must create a subforum.</div>");
}
}
else{
echo("<div>No action has been performed</div>");
}
break;
}
}
}
}
else{
echo("<div>You must log in as an administrative user to use this feature</div>");
}
include_once($footer);
?>
|
|
From: <i-...@us...> - 2003-10-13 20:23:14
|
Update of /cvsroot/openfirst/forum/admin In directory sc8-pr-cvs1:/tmp/cvs-serv28450/admin Log Message: Directory /cvsroot/openfirst/forum/admin added to the repository |
|
From: <i-...@us...> - 2003-10-13 20:22:33
|
Update of /cvsroot/openfirst/forum/setup In directory sc8-pr-cvs1:/tmp/cvs-serv28323/setup Added Files: setup.mssql setup.mysql Log Message: Setup for Forum module. MSSQL script is untested. --- NEW FILE: setup.mssql --- CREATE TABLE IF NOT EXISTS `ofirst_forum` (`ID` int(6) unsigned NOT NULL auto_increment, `name` varchar(45) NOT NULL default 'main', `message` tinytext, `subforum` bigint(12) unsigned NOT NULL default '0', `hidden` tinyint(1) NOT NULL default '0', `closed` tinyint(1) default '0', UNIQUE KEY `ID` (`ID`), UNIQUE KEY `name` (`name`)) TYPE=MyISAM; CREATE TABLE IF NOT EXISTS `ofirst_forumposts` (`ID` bigint(8) unsigned NOT NULL auto_increment, `forum` varchar(45) NOT NULL default '', `ReplyTo` bigint(45) unsigned NOT NULL default '0', `Title` tinytext NOT NULL, `Author` tinytext NOT NULL, `Message` text, `DatePosted` datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY `ID` (`ID`)) TYPE=MyISAM; INSERT INTO ofirst_config SET modulename='forum',showonmenu='0',active='0',adminnavigation='<a href="$basepath/forum/admin/">Subforums</a>',modulenavigation='<a href="$basepath/forum/">Forum Home</a>',includes='forumvisit.php'; --- NEW FILE: setup.mysql --- CREATE TABLE IF NOT EXISTS `ofirst_forum` (`ID` int(6) unsigned NOT NULL auto_increment, `name` varchar(45) NOT NULL default 'main', `message` tinytext, `subforum` bigint(12) unsigned NOT NULL default '0', `hidden` tinyint(1) NOT NULL default '0', `closed` tinyint(1) default '0', UNIQUE KEY `ID` (`ID`), UNIQUE KEY `name` (`name`)) TYPE=MyISAM; CREATE TABLE IF NOT EXISTS `ofirst_forumposts` (`ID` bigint(8) unsigned NOT NULL auto_increment, `forum` varchar(45) NOT NULL default '', `ReplyTo` bigint(45) unsigned NOT NULL default '0', `Title` tinytext NOT NULL, `Author` tinytext NOT NULL, `Message` text, `DatePosted` datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY `ID` (`ID`)) TYPE=MyISAM; INSERT INTO ofirst_config SET modulename='forum',showonmenu='0',active='0',adminnavigation='<a href="$basepath/forum/admin/">Subforums</a>',modulenavigation='<a href="$basepath/forum/">Forum Home</a>',includes='forumvisit.php'; |
|
From: <i-...@us...> - 2003-10-13 20:12:20
|
Update of /cvsroot/openfirst/forum/setup In directory sc8-pr-cvs1:/tmp/cvs-serv26734/setup Log Message: Directory /cvsroot/openfirst/forum/setup added to the repository |
|
From: <i-...@us...> - 2003-10-13 20:11:39
|
Update of /cvsroot/openfirst/forum
In directory sc8-pr-cvs1:/tmp/cvs-serv26638
Added Files:
forumvisit.php
Log Message:
"Include" script for forum module. Tracks new/read messages.
--- NEW FILE: forumvisit.php ---
<?php
/*
* openFIRST.forum - forumvisit.php
*
* Copyright (C) 2003,
* openFIRST Project
* Original Author: Greg Inozemtsev <gr...@si...>
*
* 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 module for forum)
//This code is used to determine which messages have been viewed
if(isset($user->user)){
if(!isset($_SESSION["forumvisit".$user->user])){
$_SESSION["forumvisit".$user->user]=0;
$q=ofirst_dbquery("SELECT forumvisit FROM ofirst_members WHERE user='$user->user';");
if(ofirst_dbnum_rows($q)!=0){
$visit=ofirst_dbfetch_object($q);
$_SESSION["forumvisit".$user->user]=$visit->forumvisit;
unset($visit);
}
unset($q);
ofirst_dbquery("UPDATE ofirst_members SET forumvisit='".date("Y-m-d H:i:s")."' WHERE user='$user->user';");
}
}
else{
$_SESSION["forumvisit"]=date("Y-m-d H:i:s");
}
?>
|
7 messages has been excluded from this view by a project administrator.
