// License: GPL
//
////////////////////////////////////////////////////////////////////////
//Header of the page
$page_title ="Translation Teams";
$showedit=false;
include_once("lib/config.php");
include_once("lib/functions.php");
include_once("stats/configuration.inc.php");
include_once("stats/stats-functions.inc.php");
include("header.inc");
openlog("i18n-teams",LOG_PID,LOG_LOCAL4);
$currdate = date("Y-m-d",mktime());
$GLOBALS["dbh"]=initdb(config("mysql_host"), config("mysql_user"), config("mysql_password"), config("mysql_database"));
if (array_key_exists("sort", $_GET))
$sort=$_GET['sort'];
else
$sort="";
if ($sort=="isocode") {
$query="SELECT teamcode,teamname,mailinglist,website FROM teaminfo where status=1 ORDER BY teamcode";
}
else {
$query="SELECT teamcode,teamname,mailinglist,website FROM teaminfo where status=1 ORDER BY teamname";
}
$teamsarray=array();
if ($result=mysql_query($query, $GLOBALS["dbh"])) {
while($row=mysql_fetch_array($result)) {
$teamsarray[]=$row;;
}
}
echo "
If the team of the language you are searching for is not here, please contact kde-i18n-doc@kde.org to
request more information on how to create a new team.
Sort by :
name |
ISO code
";
echo render_teams_bar($teamsarray, $sort, $GLOBALS["dbh"]);
echo "
To see the full list of ISO codes, please visit the Codes for the
Representation of Names
of Languages page.
";
//Footer of the page
include("footer.inc");
//
// render teams bar, rows oriented
//
function render_teams_bar($teams, $sort) {
$colteam=3;
$teamitem="";
$cnt=1;
$altcolor=0;
$tdpercent= floor(100/$colteam);
$trcolor="";
//Header
$teamitem="
| Team |
";
foreach ($teams as $row) {
$trcolor = ($trcolor=="odd") ? "even" : "odd";
$teamitem.="";
if ($sort=="isocode") {
$teamname="
".$row["teamcode"]."
(".
$row["teamname"].
")
";
}
else {
$teamname="
".$row["teamname"]."
(".
$row["teamcode"].
")
";
}
$mailinglist=html_entity_decode($row['mailinglist'], ENT_QUOTES);
if ($mailinglist==NULL)
$mailinglist="None";
$website=html_entity_decode($row['website'], ENT_QUOTES);
if ($website==NULL)
$website="None";
$teamitem .="|
$teamname
|
";
$teamitem .="
";
$cnt++;
}
//Footer
$teamitem.= "
";
return $teamitem;
}
?>