openfirst-cvscommit — Notify subscribers of changes to files in CVS.

[Openfirst-cvscommit] manual/setup setup.mysql,NONE,1.1

[<dav...@us...>]

Update of /cvsroot/openfirst/manual/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv18252

Added Files:
	setup.mysql 
Log Message:
initial upload

--- NEW FILE: setup.mysql ---
CREATE table ofirst_manual (
title TEXT,
functionname TEXT,
maintainer TEXT,
creator TEXT,
ID int(6) unsigned NOT NULL auto_increment,
chapter int(3),
description TEXT,
notes TEXT,
syntax TEXT,
PRIMARY KEY  (`ID`)
);

[Openfirst-cvscommit] manual/setup - New directory

[<dav...@us...>]

Update of /cvsroot/openfirst/manual/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv18135/setup

Log Message:
Directory /cvsroot/openfirst/manual/setup added to the repository

[Openfirst-cvscommit] logger index.php,NONE,1.1

[<dav...@us...>]

Update of /cvsroot/openfirst/logger
In directory sc8-pr-cvs1:/tmp/cvs-serv17441

Added Files:
	index.php 
Log Message:
initial upload

--- NEW FILE: index.php ---
<?php
/*
 *  openFIRST.logger - index.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
 *
 */

  include("../config/globals.php"); 

  include("$header");

  mysql_select_db("openFIRST",$sqlconnection);

  

  if (ISSET($_POST['view'])){

  $min = $_POST['min'];

  $max = $_POST['max'];

    }else{

      $min = 0;

	  $max = 50;

  }

  

  if (ISSET($_GET['DELETE'])){

  mysql_query("DELETE FROM ofirst_logger WHERE IPAddress = '".$_GET['DELETE']."'") or die(mysql_error());

  }

  

  $query = mysql_query("SELECT * FROM ofirst_logger GROUP BY IPAddress LIMIT $min,$max");

  $amount = mysql_num_rows($query);

?>

<h1>View Log Information</h1>

<p>[ <a href="viewLog.php">Track User Movement </a>] [<a href="rawdata.php"> View 

  Raw Hits</a> ] [ <a href="reset.php">Reset Logger</a> ]</p>

<p>

<form action="viewLog.php" method="POST"> 

  <input name="min" type="text" id="min" value="<?php echo $min; ?>" size="10">

  to 

  <input name="max" type="text" id="max" value="<?php echo $max; ?>" size="10">

  <input name="view" type="submit" id="view" value="View">

  (<strong><?php echo $amount; ?></strong> total unique visitors) 

</form></p>

<div align="center"><font size="2">This page previews grouped unique visitors. 

  If you wish to view the exact location that the user has visited click<br>

  the track button below:<br>

  </font><br>

</div>

<table width="100%" border="1" cellpadding="1" cellspacing="0" bordercolor="#999999">

  <tr bgcolor="#999999"> 

    <td width="6%"> <div align="center">ID</div></td>

    <td width="20%"> <div align="center">Date</div></td>

    <td width="20%"> <div align="center">IP Address</div></td>

    <td width="30%"> <div align="center">Host Lookup</div></td>

	<td width="30%"> <div align="center">Option</div></td>

  </tr>

  <?

  while($log = mysql_fetch_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>[ <a href='viewLog.php?DELETE=$log->IPAddress'>Delete</a> ] [ <a href='track.php?ID=$log->IPAddress'>Track</a> ]</td>";

	echo "</tr>";

  }

?></tr>

</table>

<p> 

<?php  include("$footer"); ?>

[Openfirst-cvscommit] logger/setup setup.mysql,NONE,1.1

[<dav...@us...>]

Update of /cvsroot/openfirst/logger/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv17441/setup

Added Files:
	setup.mysql 
Log Message:
initial upload

--- NEW FILE: setup.mysql ---
CREATE TABLE `ofirst_logger` (
`ID` int(6) unsigned NOT NULL auto_increment,
`IPAddress` tinytext,
`Date` tinytext,
`Location` tinytext,
`QueryString` tinytext,
`HostLookup` tinytext,
`Browser` tinytext,
PRIMARY KEY  (`ID`)
) TYPE=MyISAM;

[Openfirst-cvscommit] news COPYING,1.1.1.1,NONE README,1.1.1.1,NONE addnews.php,1.2,NONE openFIRST-news.sql,1.1.1.1,NONE

[<xt...@us...>]

Update of /cvsroot/openfirst/news
In directory sc8-pr-cvs1:/tmp/cvs-serv17354

Removed Files:
	COPYING README addnews.php openFIRST-news.sql 
Log Message:
Remove functionality that is now duplicated elsewhere.

--- COPYING DELETED ---

--- README DELETED ---

--- addnews.php DELETED ---

--- openFIRST-news.sql DELETED ---

[Openfirst-cvscommit] logger/setup - New directory

[<dav...@us...>]

Update of /cvsroot/openfirst/logger/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv16809/setup

Log Message:
Directory /cvsroot/openfirst/logger/setup added to the repository

[Openfirst-cvscommit] members auth.php,1.12,NONE

[<xt...@us...>]

Update of /cvsroot/openfirst/members
In directory sc8-pr-cvs1:/tmp/cvs-serv16660

Removed Files:
	auth.php 
Log Message:
Remove authentication functions from members, as they are now part of the base package.

--- auth.php DELETED ---

[Openfirst-cvscommit] manual openFIRST.manual.sql,1.1.1.1,NONE

[<xt...@us...>]

Update of /cvsroot/openfirst/manual
In directory sc8-pr-cvs1:/tmp/cvs-serv16203

Removed Files:
	openFIRST.manual.sql 
Log Message:
Remove file with functionality duplicated elsewhere.

--- openFIRST.manual.sql DELETED ---

[Openfirst-cvscommit] guestbook/setup setup.mysql,NONE,1.1

[<dav...@us...>]

Update of /cvsroot/openfirst/guestbook/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv15947/setup

Added Files:
	setup.mysql 
Log Message:
initial upload

--- NEW FILE: setup.mysql ---
CREATE TABLE ofirst_guestbook (
guest text,
email text,
ICQ text,
AIM text,
MSN text,
YIM text,
IRC text,
webpage text,
location text,
comment text,
date text,
deletecode text
) TYPE=MyISAM;

[Openfirst-cvscommit] guestbook index.php,NONE,1.1

[<dav...@us...>]

Update of /cvsroot/openfirst/guestbook
In directory sc8-pr-cvs1:/tmp/cvs-serv15947

Added Files:
	index.php 
Log Message:
initial upload

--- NEW FILE: index.php ---
<?php
/*
 *
 *  openFIRST.guestbook - index.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
 *
 */

  include("../config/globals.php");
  include("$header");
?>
 <h1>View Guest Book</h1>
  <p>Comments are arranged alphabetically by guest name.  We are not 
responsible for the content contained in this guestbook.  The comments and 
opinions expressed throughout the guestbook are those of the poster, and 
do not necessarily reflect those of our robotics team.
<br /><a href="<?php echo($home); ?>">Return to main page</a> 
<a href="sign.php">Sign Guest Book</a></p>

<?php
  mysql_select_db("$sqldatabase");
  $query = "SELECT * FROM ofirst_guestbook ORDER BY guest;";
  $result = mysql_query($query);

  if ($result) {
    while ($r = mysql_fetch_object($result)) {

     echo("<hr /><p>$r->date
<br /><img src='person.png' alt='Guest: ' /> Guest: $r->guest
<br /><img src='email.png' alt='E-mail Address: ' /> E-mail: <a href='mailto: $r->email'>$r->email</a>
<br /><img src='icq.png' alt='ICQ UIN: ' /> ICQ: $r->ICQ");

      if ($r->ICQ != "") {
       echo("<img src='http://wwp.icq.com/scripts/online.dll?icq=".$r->ICQ . "&amp;img=5' alt='User status' />");
      }
      echo("<br /><img src='aim.png' alt='AIM Screen name: ' /> AIM: $r->AIM
<br /><img src='msmsgs.png' alt='MSN Messenger Address: ' /> MSN: $r->MSN
<br /><img src='yahoo.png' alt='Yahoo! Messenger Address: ' /> YIM: $r->YIM");
      if ($r->YIM != "") {
       echo("<img src='http://opi.yahoo.com/online?u=$r->YIM &amp;m=g&amp;t=1' alt='User Status' />");
      }

      echo("<br /><img src='irc.png' alt='IRC: ' /> IRC:$r->IRC
<br /><img src='webpage.png' alt='Web Page' /> Web Page: <a href='$r->webpage'>$r->webpage</a>
<br /><img src='world.png' alt='Location: ' /> Location: $r->location");

      if (function_exists('emoticon_translate')) {
        $comment = emoticon_translate($r->comment);
      } else {
        $comment = $r->comment;
      }
  
      echo("<br />Comment: </p><p>" . $comment . "</p>\n");
   }
  }

  include("$footer");
?>

[Openfirst-cvscommit] logger COPYING,1.1.1.1,NONE openFIRST.logger.sql,1.1.1.1,NONE viewLog.php,1.3,NONE

[<xt...@us...>]

Update of /cvsroot/openfirst/logger
In directory sc8-pr-cvs1:/tmp/cvs-serv15777

Removed Files:
	COPYING openFIRST.logger.sql viewLog.php 
Log Message:
Remove functionality that is now moved elsewhere.

--- COPYING DELETED ---

--- openFIRST.logger.sql DELETED ---

--- viewLog.php DELETED ---

[Openfirst-cvscommit] guestbook/setup - New directory

[<dav...@us...>]

Update of /cvsroot/openfirst/guestbook/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv15708/setup

Log Message:
Directory /cvsroot/openfirst/guestbook/setup added to the repository

[Openfirst-cvscommit] guestbook .htaccess,1.2,NONE COPYING,1.1.1.1,NONE guestbook.sql,1.1,NONE view.php,1.8,NONE

[<xt...@us...>]

Update of /cvsroot/openfirst/guestbook
In directory sc8-pr-cvs1:/tmp/cvs-serv14797

Removed Files:
	.htaccess COPYING guestbook.sql view.php 
Log Message:
Remove functionality that is now duplicated elsewhere.

--- .htaccess DELETED ---

--- COPYING DELETED ---

--- guestbook.sql DELETED ---

--- view.php DELETED ---

[Openfirst-cvscommit] feedback index.php,NONE,1.1

[<dav...@us...>]

Update of /cvsroot/openfirst/feedback
In directory sc8-pr-cvs1:/tmp/cvs-serv13778

Added Files:
	index.php 
Log Message:
initial upload

--- NEW FILE: index.php ---
<?php
/*
 *  openFIRST.feedback - index.php
 *
 * Copyright (C) 2003,
 *  openFIRST Project
 *  Original Author: Tim Ginn <tim...@sy...>
 *
 * 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);

echo("<h1>Feedback</h1>");

  mysql_select_db($sqldatabase,$sqlconnection);

  // Get a list of the users able to
  // be contacted via the feedback form.
  $query = mysql_query("SELECT * FROM ofirst_feedbackusers ORDER BY name;");
  
  if (mysql_num_rows($query) != 0){
    if(isset($_POST["to"]) == true) {
      $messageallowed = false;
    } else {
      // Display the feedback form.
      ?>
      <form method="post" action="feedback.php">
      Message To: <select name="to">

      <?php
    }
    while($feedback = mysql_fetch_object($query)){
      if(! isset($_POST["to"])) {
        echo("<option value='$feedback->email'>$feedback->name</option>");
      } else {
        if ($_POST["to"] == $feedback->email) {
          $messageallowed = true;
        }
      }
    }
    if(isset($_POST["to"]) == false) {
     // Display rest of feedback form.
     echo("</select>");
     ?>

<br />Your E-mail Address (used for
replies):
<input type="text" name="from"
style="width: 150px;" /> <br />Type
of feedback: <input type="radio"
name="type" value="comment" />Comment
<input type="radio" name="type"
value="question" />Question <input
type="radio" name="type"
value="concern" />Concern
     <br />
Message: <br /><textarea
name="message" cols="40"
rows="20">Insert your feedback here.</textarea>
     <br />
     <input type="submit" value="Send Feedback" />
     <input type="reset" value="Clear Feedback" />
     </form>

     <?php
    } else {
      if ($messageallowed == true) {
        // Mail who they wish to contact.
mail($_POST["to"],
"Feedback: " . $_POST["type"], $_POST["message"]
. "\r\n\r\n--\r\nMessage generated by openfirst.feedback.
For more information about openFIRST, see:
http://openfirst.sourceforge.net"
,
"From: " . $_POST["from"] ."\r\nReply-To: ". $_POST["from"] ."\r\n");
        // Inform user of message being sent.
        echo("Your message has been
sent.  If a reply is desired, you
should receive it in the near
future.");

      } else {
        // Give an error.
        echo("You cannot use the
feedback form to contact that person
as the administrator of this web site
has not allowed it.  If you
believe you should be able to
contact this person, contact the
administrator asking them to
change their settings.");
      }
    }
  } else {
    echo("Before you can use
this, someone must first set up
users able to be e-mailed by
modifying the database.");
  }
 include($footer);
?>

[Openfirst-cvscommit] feedback/setup setup.mysql,NONE,1.1

[<dav...@us...>]

Update of /cvsroot/openfirst/feedback/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv13778/setup

Added Files:
	setup.mysql 
Log Message:
initial upload

--- NEW FILE: setup.mysql ---
create table ofirst_feedbackusers (
name TEXT, 
email TEXT
);

[Openfirst-cvscommit] feedback/setup - New directory

[<dav...@us...>]

Update of /cvsroot/openfirst/feedback/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv13555/setup

Log Message:
Directory /cvsroot/openfirst/feedback/setup added to the repository

[Openfirst-cvscommit] feedback COPYING,1.1.1.1,NONE README,1.1.1.1,NONE feedback.php,1.2,NONE openFIRST-feedback.sql,1.1,NONE

[<xt...@us...>]

Update of /cvsroot/openfirst/feedback
In directory sc8-pr-cvs1:/tmp/cvs-serv13381

Removed Files:
	COPYING README feedback.php openFIRST-feedback.sql 
Log Message:
Remove old files, as their functionality is being moved elsewhere.

--- COPYING DELETED ---

--- README DELETED ---

--- feedback.php DELETED ---

--- openFIRST-feedback.sql DELETED ---

[Openfirst-cvscommit] emoticon index.php,NONE,1.1

[<dav...@us...>]

Update of /cvsroot/openfirst/emoticon
In directory sc8-pr-cvs1:/tmp/cvs-serv12636

Added Files:
	index.php 
Log Message:
initial upload

--- NEW FILE: index.php ---
<?php
/*
 *  openFIRST.emoticon - index.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
 *
 */

mysql_select_db($sqldatabase,$sqlconnection);

// Switches all emoticon text for the
// proper symbol and returns the
// switched text.

function emoticon_translate ($text)
{
  $query = mysql_query("SELECT * FROM ofirst_emoticon");

  if (mysql_num_rows($query) != 0){
   while ($er = mysql_fetch_object($query)) {
     $text = str_replace($er->emoticon, $er->substitution, $text);
   }
  }

  return $text;
}

// Displays emoticons in a table.
// Its a good function to place on a messaging system
// or have as reference page.

function emoticon_preview ()
{
$query = mysql_query("SELECT * FROM ofirst_emoticon LIMIT 0,5");
echo "<table>";
   while ($emot = mysql_fetch_object($query)) {
     echo "<tr><td>".$emot->substitution."</td><td>".$emot->emoticon."</td></tr>";
   }
echo "</table>";
}

// Analyzis database and compares slur words
// then it replaces the slur words with its
// substitution value.

function slur_block ($text)
{
  $query = mysql_query("SELECT * FROM ofirst_slurblock");

  if (mysql_num_rows($query) != 0){
   while ($er = mysql_fetch_object($query)) {
     $text = str_replace($er->slur, $er->substitution, $text);
   }
  }

  return $text;
}

?>

[Openfirst-cvscommit] emoticon/setup - New directory

[<dav...@us...>]

Update of /cvsroot/openfirst/emoticon/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv12190/setup

Log Message:
Directory /cvsroot/openfirst/emoticon/setup added to the repository

[Openfirst-cvscommit] emoticon COPYING,1.1.1.1,NONE README,1.1.1.1,NONE emoticonf.php,1.3,NONE

[<xt...@us...>]

Update of /cvsroot/openfirst/emoticon
In directory sc8-pr-cvs1:/tmp/cvs-serv11742

Removed Files:
	COPYING README emoticonf.php 
Log Message:
Remove other files (scheduled for recreation, soon).

--- COPYING DELETED ---

--- README DELETED ---

--- emoticonf.php DELETED ---

[Openfirst-cvscommit] emoticon emote.sql,1.1.1.1,NONE populateemoticons.sql,1.1.1.1,NONE

[<xt...@us...>]

Update of /cvsroot/openfirst/emoticon
In directory sc8-pr-cvs1:/tmp/cvs-serv10448

Removed Files:
	emote.sql populateemoticons.sql 
Log Message:
Remove two SQL files since their functionality is being moved elsewhere.

--- emote.sql DELETED ---

--- populateemoticons.sql DELETED ---

[Openfirst-cvscommit] awards/setup setup.mysql,NONE,1.1

[<dav...@us...>]

Update of /cvsroot/openfirst/awards/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv7573/setup

Added Files:
	setup.mysql 
Log Message:
initial upload

--- NEW FILE: setup.mysql ---
CREATE TABLE `ofirst_awards` (
`ID` int(6) unsigned NOT NULL auto_increment,
`AwardName` tinytext,
`Event` tinytext,
`Date` date default NULL,
`Recipient` tinytext,
`Image` tinytext,
PRIMARY KEY  (`ID`)
) TYPE=MyISAM;

[Openfirst-cvscommit] awards/admin index.php,NONE,1.1

[<dav...@us...>]

Update of /cvsroot/openfirst/awards/admin
In directory sc8-pr-cvs1:/tmp/cvs-serv7573/admin

Added Files:
	index.php 
Log Message:
initial upload

--- NEW FILE: index.php ---
<?php
/*
 *  openFIRST.awards - manage.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"); 
  include($header);
  mysql_select_db("openFIRST",$sqlconnection);

  // Check if user is an admin then allow processes
  if (isset($user->user)){

  // If user has posted delete then delete specified record in querystring DELETE
  if (ISSET($_GET['DELETE'])){
    mysql_query("DELETE FROM ofirst_awards WHERE ID = '".$_GET['DELETE']."'") or die("DELETE: ".mysql_error());

    die("<br><br><center>Award information has been deleted. [ <a href='manage.php'>Manage Award</a> ]");
  }
  
  // If user has posted create then insert new award record
  if (ISSET($_POST['create'])){
    mysql_query("INSERT INTO ofirst_awards (AwardName,Event,Date,Image,Recipient) values(
                                '".$_POST['award']."'
		   ,'".$_POST['event']."'
		   ,'".$_POST['date']."'
		   ,'".$_POST['type']."'
		   ,'".$_POST['recipient']."')") or die("INSERT: ".mysql_error());

  die("<br><br><center>Congratulations on your new award. Award submitted! [ <a href='manage.php'>Manage Award</a> ]");
  }
  
?>

<h1>Manage Award Information</h1>

<p><a href="manage.php">Manage Awards </a>&nbsp;<a href="awards.php">View Awards</a>&nbsp;<?php membersmenu($user->membertype); ?></p>
<form name="form1" method="post" action="manage.php">
  <table width="500" border="1" align="center" cellpadding="5" cellspacing="0" bordercolor="#999999">
    <tr bgcolor="#999999"> 
      <td width="142">&nbsp;</td>
      <td width="248"><font color="#FFFFFF">Add A New Award</font></td>
    </tr>
    <tr> 
      <td><div align="right">Award Name:</div></td>
      <td><input name="award" type="text" id="award"></td>
    </tr>
    <tr> 
      <td><div align="right">Regional/Event:</div></td>
      <td><input name="event" type="text" id="event"></td>
    </tr>
    <tr> 
      <td><div align="right">Date:</div></td>
      <td><input name="date" type="text" id="date" value="<?php echo date("Y-n-j"); ?>" size="10"> 
        <font size="2">(Use this syntax: Year-Month-Day)</font></td>
    </tr>
    <tr> 
      <td><div align="right">Recipient:</div></td>
      <td><input name="recipient" type="text" id="recipient" value="Team Award"></td>
    </tr>
    <tr> 
      <td><div align="right">Award Type:</div></td>
      <td><table width="75%" border="0" cellspacing="0" cellpadding="4">
          <tr> 
            <td><div align="center"><img src="awardsgold.png" alt="Gold" width="25" height="30"></div></td>
            <td><div align="center"><img src="awardssilver.png" alt="Silver" width="25" height="30"></div></td>
            <td><div align="center"><img src="awardsbronze.png" alt="Bronze" width="25" height="30"></div></td>
          </tr>
          <tr> 
            <td><div align="center">
                <input name="type" type="radio" value="gold" checked>
              </div></td>
            <td><div align="center">
                <input type="radio" name="type" value="silver">
              </div></td>
            <td><div align="center">
                <input type="radio" name="type" value="bronze">
              </div></td>
          </tr>
        </table></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><input name="create" type="submit" id="create" value="Create Listing"></td>
    </tr>
  </table>
</form>
<table width="600" border="1" align="center" cellpadding="5" cellspacing="0" bordercolor="#999999">
  <tr bgcolor="#999999"> 
    <td> </td>
    <td width="152"><center><font color="#FFFFFF">Award Name</font><center></td>
    <td width="95"><center><font color="#FFFFFF">Event</font><center></td>
    <td width="84"><center><font color="#FFFFFF">Date</font><center></td>
    <td width="118"><center><font color="#FFFFFF">Recipient</font><center></td>
	 <td width="89"><center><font color="#FFFFFF">Option</font><center></td>
  </tr>
<?php
  // Loop through awards ordered by date
  $query = mysql_query("SELECT * FROM ofirst_awards ORDER BY Date");
  while($awards = mysql_fetch_object($query)){
?>
  <tr>
    <td><img src="awards<?php echo $awards->Image; ?>.png" alt="<?php echo $awards->Image; ?>"></td>
    <td><?php echo $awards->AwardName; ?></td>
    <td><?php echo $awards->Event; ?></td>
    <td><?php echo $awards->Date; ?></td>
    <td><?php echo $awards->Recipient; ?></td>
	<td><div align="center">[ <a href='manage.php?DELETE=<?php echo $awards->ID; ?>'>Delete</a> 
        ]</div></td>
  </tr>
<? } ?>
</table>
<?php

    }else{
    showlogin();
  }
include($footer);
?>

[Openfirst-cvscommit] awards index.php,NONE,1.1

[<dav...@us...>]

Update of /cvsroot/openfirst/awards
In directory sc8-pr-cvs1:/tmp/cvs-serv7573

Added Files:
	index.php 
Log Message:
initial upload

--- NEW FILE: index.php ---
<?php
/*
 *  openFIRST.awards - awards.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"); 
  include($header);
  mysql_select_db("openFIRST",$sqlconnection);

  // Query database for award information
  $query = mysql_query("SELECT * FROM ofirst_awards ORDER BY Date");
  $amount = mysql_num_rows($query);
?>
<h1>Team Awards</h1>
<p align="center">This team has won <strong><?php echo $amount; ?></strong> award(s).</p>

<table width="600" border="1" align="center" cellpadding="5" cellspacing="0" bordercolor="#999999">
  <tr bgcolor="#999999"> 
    <td width="32"> </td>
    <td width="209"><center><font color="#FFFFFF">Award Name</font><center></td>
    <td width="95"><center><font color="#FFFFFF">Event</font><center></td>
    <td width="84"><center><font color="#FFFFFF">Date</font><center></td>
    <td width="118"><center><font color="#FFFFFF">Recipient</font><center></td>
  </tr>
<?php
  // Loop through awards ordered by date
  while($awards = mysql_fetch_object($query)){
?>
  <tr> 
    <td><img src="awards<?php echo $awards->Image; ?>.png" alt="<?php echo $awards->Image; ?>"></td>
    <td><?php echo $awards->AwardName; ?></td>
    <td><?php echo $awards->Event; ?></td>
    <td><?php echo $awards->Date; ?></td>
    <td><?php echo $awards->Recipient; ?></td>
  </tr>
<? } ?>
</table>
<?php  include($footer); ?>

[Openfirst-cvscommit] awards/setup - New directory

[<dav...@us...>]

Update of /cvsroot/openfirst/awards/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv6820/setup

Log Message:
Directory /cvsroot/openfirst/awards/setup added to the repository