| 1 |
csmall |
1.1 |
<? |
| 2 |
|
|
session_start(); |
| 3 |
|
|
include("config.inc"); |
| 4 |
|
|
include("common.inc"); |
| 5 |
|
|
|
| 6 |
|
|
function print_applicants($sql) { |
| 7 |
|
|
if (! ($db = open_db())) { |
| 8 |
|
|
return FALSE; |
| 9 |
|
|
} |
| 10 |
|
|
if (! ($query = pg_exec($db, $sql))) { |
| 11 |
|
|
echo "Problem with query", pg_ErrorMessage($db), "<BR>"; |
| 12 |
|
|
pg_Close($db); |
| 13 |
|
|
return FALSE; |
| 14 |
|
|
} |
| 15 |
|
|
$rows = pg_NumRows($query); |
| 16 |
|
|
for ($i = 0 ; $i < $rows ; $i++) { |
| 17 |
|
|
$row = pg_Fetch_Array($query, $i); |
| 18 |
|
|
echo "<TR><TD>", $row["apply_date"], "</TD>"; |
| 19 |
csmall |
1.3 |
print_flag($row["advocate_ok"],"<TD><IMG src=\"/images/shake/.png\" alt=\"V\"></TD>","<TD> </TD>"); |
| 20 |
csmall |
1.1 |
print_flag($row["id_ok"],"<TD><IMG src=\"/images/mag.png\" alt=\"I\"></TD>","<TD> </TD>"); |
| 21 |
|
|
print_flag($row["pnp_ok"],"<TD><IMG src=\"/images/dfsg.png\" alt=\"P\"></TD>","<TD> </TD>"); |
| 22 |
|
|
print_flag($row["tns_ok"],"<TD><IMG src=\"/images/hammer.png\" alt=\"T\"></TD>","<TD> </TD>"); |
| 23 |
|
|
print_flag($row["approved"],"<TD><IMG src=\"/images/thumb.png\" alt=\"A\"></TD>","<TD> </TD>"); |
| 24 |
|
|
print_flag($row["da_approved"],"<TD><IMG src=\"/images/new.png\" alt=\"N\"></TD>","<TD> </TD>"); |
| 25 |
|
|
if ($row["approved"] == "f" || $row["da_approved"] == "f") { |
| 26 |
|
|
echo "<TD><IMG src=\"/images/hold.png\" alt=\"H\"></TD>"; |
| 27 |
|
|
} else { |
| 28 |
|
|
echo "<TD> </TD>"; |
| 29 |
|
|
} |
| 30 |
|
|
echo "<TD><A href=\"amstatus.php?"; ?><?=SID?><?; |
| 31 |
|
|
echo "&user=", urlencode($row["email"]), "\">", |
| 32 |
|
|
$row["forename"], " ", $row["surname"], " <", |
| 33 |
|
|
$row["email"], "></A>", |
| 34 |
|
|
" </TD><TD>", $row["manager"], "</TD></TR>\n"; |
| 35 |
|
|
} |
| 36 |
|
|
# Now for other stuff |
| 37 |
|
|
|
| 38 |
|
|
pg_Close($db); |
| 39 |
|
|
return TRUE; |
| 40 |
|
|
}?> |
| 41 |
|
|
#use wml::nmpage title="Debian New Maintainer - List of all Applicants" |
| 42 |
|
|
<? |
| 43 |
|
|
|
| 44 |
|
|
if (!session_is_registered("s_username") || !session_is_registered("s_isam")) { |
| 45 |
|
|
?> |
| 46 |
|
|
<STRONG> |
| 47 |
|
|
You should not be here!!</STRONG> |
| 48 |
|
|
<? } else { |
| 49 |
|
|
session_register("s_username"); |
| 50 |
|
|
session_register("s_isam"); |
| 51 |
|
|
session_register("s_isfd"); |
| 52 |
|
|
session_register("s_isdam"); |
| 53 |
|
|
?> |
| 54 |
|
|
<H1>Debian New Maintainer - All Applicants</H1><BR> |
| 55 |
|
|
<P>This is a list of all applicants known to the database. This list is sorted |
| 56 |
|
|
by application date. Applicants who are now maintainers are not shown up |
| 57 |
|
|
in this list. |
| 58 |
|
|
<TABLE border=0> |
| 59 |
|
|
<TR><TH>Appl Date</TH><TH colspan="6">Flags</TH><TH>Applicant</TH><TH>Manager</TH></TR> |
| 60 |
|
|
<? |
| 61 |
|
|
$sql = "SELECT * from applicant WHERE newmaint IS NULL ORDER BY apply_date" ; |
| 62 |
|
|
print_applicants($sql); |
| 63 |
|
|
?> |
| 64 |
|
|
</TABLE> |
| 65 |
|
|
<H3>Key</H3> |
| 66 |
|
|
<UL> |
| 67 |
csmall |
1.3 |
<LI><IMG src="/images/shake.png" alt="I"> : Advocate Check OK |
| 68 |
csmall |
1.1 |
<LI><IMG src="/images/mag.png" alt="I"> : Identification complete |
| 69 |
|
|
<LI><IMG src="/images/dfsg.png" alt="P"> : Philosopy and Procedures complete |
| 70 |
|
|
<LI><IMG src="/images/hammer.png" alt="T"> : Tasks and Skills complete |
| 71 |
|
|
<LI><IMG src="/images/thumb.png" alt="A"> : Application Manager Recommends applicant |
| 72 |
|
|
<LI><IMG src="/images/new.png" alt="N"> : New Debian maintainer |
| 73 |
|
|
<LI><IMG src="/images/hold.png" alt="H"> : On hold |
| 74 |
|
|
</UL> |
| 75 |
|
|
<? } # Registered session ?> |
Parent Directory
| 
Revision Log