Teams working on Project Odin are:
";
TekstEnd();
$sSql ="SELECT\n".
" refcode,\n".
" name,\n".
" longname,\n".
" description,\n".
" tasks,\n".
" notes\n".
"FROM\n".
" team\n".
"ORDER BY refcode\n";
$Result = mysql_query($sSql, $db);
if (!$Result)
{
Odin32DBSqlError($sSql);
die("Failed to query teams from database!");
}
/*
* Loop thru all teams and display information about each.
*/
while ($aTeam = mysql_fetch_array($Result))
{
Odin32DBNaslov2($aTeam["name"]." Team
(".$aTeam["longname"].")",
$aTeam["name"]." Team
(".$aTeam["longname"].")",
$aTeam["name"]);
/*
* Description
*/
TekstBeg();
echo $aTeam["description"]."\n";
TekstEnd();
/*
* If more than one group list them!
*/
$sSql ="SELECT\n".
" refcode,\n".
" name,\n".
" description,\n".
" notes\n".
"FROM\n".
" tgroup\n".
"WHERE\n".
" team = ".$aTeam["refcode"]."\n".
"ORDER By refcode\n";
$Result2 = mysql_query($sSql, $db);
if (!$Result2)
{
echo "
| ";
Odin32DBSqlError($sSql);
echo " |
";
die("team group sql failed");
}
$cGroups = mysql_num_rows($Result2);
if ($cGroups > 1)
{
TekstBeg();
echo "The ".$aTeam["name"]." Team consists of following groups with\n".
"accompanying tasks:";
TekstEnd();
GrayTableBeg("");
echo "";
GTCell("Group", "WIDTH=30% VALIGN=middle align=center", "d0d0d0");
GTCell("Task", "WIDTH=70% VALIGN=middle align=center", "d0d0d0");
echo "
";
while ($aGroup = mysql_fetch_array($Result2))
{
echo "";
GTCell($aGroup["name"], "VALIGN=middle", "");
GTCell($aGroup["description"], "", "");
echo "
";
}
GrayTableEnd();
if ($aTeam["name"] == 'WAI')
{
TekstBeg();
echo "\n".
" More detailed informations about each group's status and progress is available from\n";
LocLink("DevelopersOdin32WAI.phtml", "'Odin32 API' pages in 'Developers' section");
echo ".\n";
TekstEnd();
}
}
/*
* List task, members, and notes table
*/
TableBeg("");
/*
* tasks
*/
if (isset($aTeam["tasks"]))
{
echo "
\n";
TCell("Tasks:", "width=20% valign=top align=right");
TCell($aTeam["tasks"], "width=80%");
echo "
\n",
"| |
\n";
}
/*
* members
*/
$sSql ="SELECT DISTINCT\n".
" a.name AS name,\n".
" a.email AS email\n".
"FROM\n".
" tgroup,\n".
" tgroupmember,\n".
" author a\n".
"WHERE\n".
" tgroup.team = ".$aTeam["refcode"]." AND\n".
" tgroupmember.tgroup = tgroup.refcode AND\n".
" MOD(tgroupmember.tgroup, 1000) <> 999 AND\n". //Ignore the unassigned group (ends with 999).
" a.refcode = tgroupmember.author\n".
"ORDER BY codemaintainer DESC, last, name\n";
$Result2 = mysql_query($sSql, $db);
if (!$Result2)
{
echo "| ";
Odin32DBSqlError($sSql);
echo " |
";
die("team member sql failed");
}
if (mysql_num_rows($Result2) > 0)
{
$sMembers = "";
while ($aMember = mysql_fetch_array($Result2))
$sMembers = $sMembers." ".
(isset($aMember["email"])
? "". $aMember["name"]."\n"
: $aMember["name"]."\n");
echo "\n";
TCell("Members:", "width=20% valign=top align=right");
TCell($sMembers, "width=80%");
echo "
\n",
"| |
\n";
}
/*
* Unassigned members if $cGroups > 1
*/
if ($cGroups > 1)
{
$sSql ="SELECT DISTINCT\n".
" a.name AS name,\n".
" a.email AS email\n".
"FROM\n".
" tgroup,\n".
" tgroupmember,\n".
" author a\n".
"WHERE\n".
" tgroup.team = ".$aTeam["refcode"]." AND\n".
" tgroupmember.tgroup = tgroup.refcode AND\n".
" MOD(tgroupmember.tgroup, 1000) = 999 AND\n". //Only the unassigned group (ends with 999).
" a.refcode = tgroupmember.author\n".
"ORDER BY last, name\n";
$Result2 = mysql_query($sSql, $db);
if (!$Result2)
{
echo "| ";
Odin32DBSqlError($sSql);
echo " |
";
die("team member sql failed");
}
if (mysql_num_rows($Result2) > 0)
{
$sMembers = "";
while ($aMember = mysql_fetch_array($Result2))
$sMembers = $sMembers." ".
(isset($aMember["email"])
? "". $aMember["name"]."\n"
: $aMember["name"]."\n");
echo "\n";
TCell("Unassigned:", "width=20% valign=top align=right");
TCell($sMembers."", "width=80%");
echo "
\n",
"| |
\n";
/* note if WAI */
if ($aTeam["name"] == "WAI")
{
TableEnd();
TekstBeg("");
echo "\n".
" Unassigned members are listed in italic. Detailed\n".
" information about each member's assignment is available from Odin32 API pages in 'Developers'\n".
" section.\n";
TekstEnd();
TableBeg("");
}
}
}
/*
* notes
*/
if (isset($aTeam["notes"]))
{
echo "
\n";
TCell("Notes:", "width=20% valign=top align=right");
TCell($aTeam["notes"], "width=80%");
echo "
\n",
"| |
\n";
}
/* end of task, members, notes table */
TableEnd();
}
require $sMainDir."07-ColumnTwoFooter.php3";
require $sMainDir."08-News.php3";
require $sMainDir."09-ContentsTitle.php3";
Odin32DBWriteContents();
require $sMainDir."10-EndOfContent.php3";
require $sMainDir."11-NetlabsContact.php3";
$Kada=date ("j M Y", filemtime(__file__));
require $sMainDir."12-OdinBanner.php3";
require $sMainDir."13-Closing.php3";
?>