[Openfirst-cvscommit] members photo.png,NONE,1.1 profile.php,1.7,1.8

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

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

Modified Files:
	profile.php 
Added Files:
	photo.png 
Log Message:
Add ordering to members profiles

--- NEW FILE: photo.png ---
(This appears to be a binary file; contents omitted.)

Index: profile.php
===================================================================
RCS file: /cvsroot/openfirst/members/profile.php,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** profile.php	23 Jul 2003 22:20:15 -0000	1.7
--- profile.php	23 Jul 2003 22:46:30 -0000	1.8
***************
*** 35,43 ****
  ?>
  <table>
!  <tr><th>User Name</th><th>Team</th><th>MSN</th><th>ICQ</th><th>AIM</th></tr>
  <?php
!     $query = mysql_query("SELECT user, team, msn, icq, aim FROM ofirst_members;");
      while($q = mysql_fetch_object($query)) {
!       echo("<tr><td><a href='profile.php?id=$q->user'>$q->user</a></td><td>$q->team</td><td>$q->msn</td><td>$q->icq</td><td>$q->aim</td></tr>");
      }
  ?>
--- 35,50 ----
  ?>
  <table>
!  <tr><th><a href="profile.php?orderby=user">Nick Name</a></th><th><a href="profile.php?orderby=team">Team</a></th><th><a href="profile.php?orderby=email">E-mail</a></th><th><a href="profile.php?orderby=msn">MSN</a></th><th><a href="profile.php?orderby=icq">ICQ</a></th><th><a href="profile.php?orderby=aim">AIM</a></th><th><a href="profile.php?orderby=picturelocation">Photo</th></tr>
  <?php
!     if($_GET["orderby"] == "") { $_GET["orderby"] = "user"; }
!     $query = mysql_query("SELECT * FROM ofirst_members where " . $_GET["orderby"] . " is NOT NULL ORDER BY " . $_GET["orderby"] . ";");
      while($q = mysql_fetch_object($query)) {
!       echo("<tr><td><a href='profile.php?id=$q->user'>$q->user</a></td><td>$q->team</td>");
!       if($q->email != "") { echo("<td><img src='email.png' alt='email available' /></td>"); } else { echo("<td></td>"); }
!       if($q->msn != "") { echo("<td><img src='msmsgs.png' alt='msn available' /></td>"); } else { echo("<td></td>"); }
!       if($q->icq != "") { echo("<td><img src='icq.png' alt='icq available' /></td>"); } else { echo("<td></td>"); }
!       if($q->aim != "") { echo("<td><img src='aim.png' alt='aim available' /></td>"); } else { echo("<td></td>"); }
!       if($q->picturelocation != "") { echo("<td><img src='photo.png' alt='photo available' /></td>"); }
!       echo("</tr>");
      }
  ?>