Location: PHPKode > projects > Mozart > Mozart-0.0.4/index.php
<?
include("connect.inc");
include("reqlogin.inc");
include("userprefs.inc");

$ContactTypeSQL = "SELECT type_id, type_name FROM types WHERE type_source = 'Contact' ORDER BY type_name";
$ContactType = mysql_query($ContactTypeSQL);
$ProjectTypeSQL = "SELECT type_id, type_name FROM types WHERE type_source = 'Project' ORDER BY type_name";
$ProjectType = mysql_query($ProjectTypeSQL);
?>
<html>
<title>Mozart: Main Index</title>
<body bgcolor=<? echo $bgcolor ?> text=<? echo $txtcolor ?>>
<center>
Welcome to Mozart <? echo $FirstName; echo " "; echo $LastName ?><br>
System ID: <? echo $SysID ?><br>
<?
if ($Message) {
	print("<font color=red>$Message</font>");
}
?>
<br>
<table border=1 cellspacing=0 cellpadding=0>
<tr>
<td>
<b>Contacts</b><br>
<a href="contactlist.php?Type=All">All</a>
<a href="contactlist.php?beg=A&end=B">A</a>
<a href="contactlist.php?beg=B&end=C">B</a>
<a href="contactlist.php?beg=C&end=D">C</a>
<a href="contactlist.php?beg=D&end=E">D</a>
<a href="contactlist.php?beg=E&end=F">E</a>
<a href="contactlist.php?beg=F&end=G">F</a>
<a href="contactlist.php?beg=G&end=H">G</a>
<a href="contactlist.php?beg=H&end=I">H</a>
<a href="contactlist.php?beg=I&end=J">I</a>
<a href="contactlist.php?beg=J&end=K">J</a>
<a href="contactlist.php?beg=K&end=L">K</a>
<a href="contactlist.php?beg=L&end=M">L</a>
<a href="contactlist.php?beg=M&end=N">M</a>
<br>
<a href="contactlist.php?beg=N&end=O">N</a>
<a href="contactlist.php?beg=O&end=P">O</a>
<a href="contactlist.php?beg=P&end=Q">P</a>
<a href="contactlist.php?beg=Q&end=R">Q</a>
<a href="contactlist.php?beg=R&end=S">R</a>
<a href="contactlist.php?beg=S&end=T">S</a>
<a href="contactlist.php?beg=T&end=U">T</a>
<a href="contactlist.php?beg=U&end=V">U</a>
<a href="contactlist.php?beg=V&end=W">V</a>
<a href="contactlist.php?beg=W&end=X">W</a>
<a href="contactlist.php?beg=X&end=Y">X</a>
<a href="contactlist.php?beg=Y&end=Z">Y</a>
<a href="contactlist.php?beg=Z&end=">Z</a>
</td>
<td>
<form action="contactlist.php?beg=&end=" method="post">
Contact Type:<select name="Type">
<option value=X>All
<?
while ($myrow = mysql_fetch_array($ContactType)) {
   printf("<option value=%s>%s", $myrow["type_id"], $myrow["type_name"]);
}
?>
</select>
<input type="submit" value="Find">
</form>
</td>
<td>
<a href="addcontact.php">Add New Contact</a>
</td>
</tr>
<tr>
<td>
<a href="calendar.php">Calendar</a>
</td>
<td>
<a href="addtodo.php">Add To Do</a>
</td>
<td>
<a href="addappt.php">Add Appointment</a>
</td>
</tr>
<tr>
<td>
<b>Projects</b><br>
<a href="projectlist.php?Type=All">All</a>
<a href="projectlist.php?beg=A&end=B">A</a>
<a href="projectlist.php?beg=B&end=C">B</a>
<a href="projectlist.php?beg=C&end=D">C</a>
<a href="projectlist.php?beg=D&end=E">D</a>
<a href="projectlist.php?beg=E&end=F">E</a>
<a href="projectlist.php?beg=F&end=G">F</a>
<a href="projectlist.php?beg=G&end=H">G</a>
<a href="projectlist.php?beg=H&end=I">H</a>
<a href="projectlist.php?beg=I&end=J">I</a>
<a href="projectlist.php?beg=J&end=K">J</a>
<a href="projectlist.php?beg=K&end=L">K</a>
<a href="projectlist.php?beg=L&end=M">L</a>
<a href="projectlist.php?beg=M&end=N">M</a>
<br>
<a href="projectlist.php?beg=N&end=O">N</a>
<a href="projectlist.php?beg=O&end=P">O</a>
<a href="projectlist.php?beg=P&end=Q">P</a>
<a href="projectlist.php?beg=Q&end=R">Q</a>
<a href="projectlist.php?beg=R&end=S">R</a>
<a href="projectlist.php?beg=S&end=T">S</a>
<a href="projectlist.php?beg=T&end=U">T</a>
<a href="projectlist.php?beg=U&end=V">U</a>
<a href="projectlist.php?beg=V&end=W">V</a>
<a href="projectlist.php?beg=W&end=X">W</a>
<a href="projectlist.php?beg=X&end=Y">X</a>
<a href="projectlist.php?beg=Y&end=Z">Y</a>
<a href="projectlist.php?beg=Z&end=">Z</a>
</td>
<td>
<form action="projectlist.php?beg=&end=" method="post">
Project Type:<select name="Type">
<option value=All>All
<?
while ($myrow = mysql_fetch_array($ProjectType)) {
   printf("<option value=%s>%s", $myrow["type_id"], $myrow["type_name"]);
}
?>
</select>
<input type="submit" value="Find">
</form>
</td>
<td>
<a href="addproject.php">Add New Project</a>
</td>
</tr>
<?
if ($Gmail) {
?>
   <tr><td><b>Email</b><br>
   <a href="gmail.php">gmail</a></td></tr>
<?
}
?>
<tr>
<?
if ($Admin) {
?>
  <td>
  <b>Admin Functions</b><br>
  <a href="adduser.php">Add New User</a>
  </td>
  <td><a href="newtypes.php">Add New Types</a></td>
<?
}
?>
<td>
<a href="chgpass.php">Change Password</a><br>
<a href="chgprof.php">Change Profile</a><br>
<a href="login.php">Login</a>
</td>
</tr>
</table>
</form>
</center>
</body>
</html>
Return current item: Mozart