Sections of the
Natural Language Software Registry |
| |
|
Sections $f_mainsection \n";
$query = "SELECT id, name FROM mainsection ORDER BY name";
$result = mysql_query($query,$mysql);
echo mysql_error();
while ( @$row = mysql_fetch_array($result) ) {
$query4 = "SELECT DISTINCT s.id AS summe FROM system s, system_section ss, section sec WHERE ss.system_id = s.id AND ss.section_id = sec.id AND sec.mainsection_id = $row[id] AND s.status = 1";
$result4 = mysql_query($query4,$mysql);
@$row4 = mysql_fetch_array($result4);
$total = mysql_num_rows($result4); // argl! waere ja alles viel einfacher, wenn das mit dem SELECT COUNT (DISTINCT s.id) klappen wuerde, wie's in der Doku steht!
if ( $row[id] == $f_mainsection ) {
echo " $row[name] ($total)
\n";
$query2 = "SELECT id, name FROM section WHERE mainsection_id = $row[id] ORDER BY name";
$result2 = mysql_query($query2,$mysql);
echo " "; // vorher: Blockquote statt UL, NOBR-Tags um die Sectionnamen ...
while ( @$row2 = mysql_fetch_array($result2) ) {
$query3 = "SELECT COUNT(s.id) AS summe FROM system s, system_section ss WHERE ss.system_id = s.id AND ss.section_id = $row2[id] AND s.status = 1";
$result3 = mysql_query($query3,$mysql);
@$row3 = mysql_fetch_array($result3);
$total = $row3[summe];
if ( $row2[id] == $f_section ) {
echo "- $row2[name] ($total)
\n";
} else {
echo " - $row2[name] ($total)
\n";
}
}
echo " ";
} else {
echo "$row[name] ($total)
\n";
}
}
?>
|
\n";
echo " |
| $row[name] |
\n";
echo "| |
\n";
echo "| description: $row[description] |
\n";
echo "| |
\n";
echo "![](\"gfx/orange.gif\") |
\n";
if ( $row[authors] ) {
echo "| authors | | $row[authors] |
\n";
}
if ( $row[institute] ) {
echo "| affiliation | | $row[institute] |
\n";
}
if ( $row[url] && $row[url] != "http://" ) {
echo "| homepage | | visit (in new window) |
\n";
}
if ( $row[ftp] && $row[ftp] != "ftp://" ) {
echo "| ftp-location | | visit (in new window) |
\n";
}
if ( $row[email] ) {
echo "| contact-email | | $row[email] |
\n";
}
if ( $row[required] ) {
echo "| required software | | $row[required] |
\n";
}
echo "| |
";
echo " |
\n";
if ( $row[waehrung] ) {
$query2 = "SELECT name FROM waehrung WHERE id = $row[waehrung]";
$result2 = mysql_query($query2,$mysql);
echo mysql_error();
@$row2 = mysql_fetch_array($result2);
$waehrung = $row2[name];
}
$query = "SELECT DISTINCT d.type AS name FROM docu d, system_docu sd WHERE sd.docu_id = d.id AND sd.system_id = $f_system";
$result = mysql_query($query,$mysql);
echo mysql_error();
if ( mysql_affected_rows() ) {
echo "| documentation | | ";
$i = 0;
while ( @$row = mysql_fetch_array($result) ) {
if ( $i > 0 ) {
echo ", ";
}
echo "$row[name]";
$i++;
}
echo " |
\n";
}
$query = "SELECT DISTINCT l.name AS name FROM language l, system_language sl WHERE sl.language_id = l.id AND sl.system_id = $f_system";
$result = mysql_query($query,$mysql);
echo mysql_error();
if ( mysql_affected_rows() ) {
echo "| supported languages | | ";
$i = 0;
while ( @$row = mysql_fetch_array($result) ) {
if ( $i > 0 ) {
echo ", ";
}
echo "$row[name]";
$i++;
}
echo " |
\n";
}
$query = "SELECT DISTINCT o.type AS name FROM os o, system_os so WHERE so.os_id = o.id AND so.system_id = $f_system";
$result = mysql_query($query,$mysql);
echo mysql_error();
if ( mysql_affected_rows() ) {
echo "| platforms | | ";
$i = 0;
while ( @$row = mysql_fetch_array($result) ) {
if ( $i > 0 ) {
echo ", ";
}
echo "$row[name]";
$i++;
}
echo " |
\n";
}
$query = "SELECT DISTINCT s.type AS name FROM software s, system_software ss WHERE ss.software_id = s.id AND ss.system_id = $f_system";
$result = mysql_query($query,$mysql);
echo mysql_error();
if ( mysql_affected_rows() ) {
echo "| distribution | | ";
$i = 0;
while ( @$row = mysql_fetch_array($result) ) {
if ( $i > 0 ) {
echo ", ";
}
echo "$row[name]";
$i++;
}
echo " |
\n";
}
$query = "SELECT DISTINCT m.name AS mainsectionname, s.name AS name , s.id AS id, ss.section_id AS sid, s.mainsection_id AS ms FROM section s, system_section ss, mainsection m WHERE ss.section_id = s.id AND ss.system_id = $f_system AND s.mainsection_id = m.id ORDER BY mainsectionname, name";
$result = mysql_query($query,$mysql);
echo mysql_error();
if ( mysql_affected_rows() ) {
echo "| sections | | ";
$i = 0;
while ( @$row = mysql_fetch_array($result) ) {
if ( $i > 0 ) {
echo ",
";
}
echo "$row[name]";
$i++;
}
echo " |
\n";
}
$status[1] = "";
$status[2] = "to negotiate";
$status[3] = "free";
$query = "SELECT DISTINCT academic_s, multiple_s, commercial_s, academic_p, multiple_p, commercial_p FROM license WHERE system_id = $f_system";
$result = mysql_query($query,$mysql);
echo mysql_error();
if ( mysql_affected_rows() ) {
@$row = mysql_fetch_array($result);
echo "| |
";
echo " |
\n";
echo "| pricing |
";
echo "| |
";
if ( $row[academic_s] ) {
echo "| academic | | " . $status[$row[academic_s]];
if ( $row[academic_p] ) {
if ( $row[academic_s] != 1 ) {
echo ", ";
}
echo "$waehrung $row[academic_p],--";
}
echo " |
";
}
if ( $row[multiple_s] ) {
echo "| multiple user | | " . $status[$row[multiple_s]];
if ( ( $row[multiple_s] == 1 ) && ( $row[multiple_p] ) ) {
if ( $row[multiple_s] != 1 ) {
echo ", ";
}
echo "$waehrung $row[multiple_p],--";
}
echo " |
";
}
if ( $row[commercial_s] ) {
echo "| commercial | | " . $status[$row[commercial_s]];
if ( ( $row[commercial_s] == 1 ) && ( $row[commercial_p] ) ) {
if ( $row[commercial_s] != 1 ) {
echo ", ";
}
echo "$waehrung $row[commercial_p],--";
}
echo " |
";
}
}
echo " |
\n";
// hier kommt das Datum der letzten Ueberpruefung (stempel) hin
$stempel_format = substr ($stempel, 6,2) . "." . substr ($stempel, 4,2) . "." . substr ($stempel, 0,4);
echo "| last verified: $stempel_format |
\n";
// echo " |
\n";
echo "| |
\n";
echo "
";
} else {
# Liste der Systeme und Abstracts in der entsprechenden Section anzeigen
if ( ! ( $f_skip ) ) {
$f_skip = 0;
}
$nextpage = $f_skip +1;
$lastpage = $f_skip -1;
$anzahl = 5;
$limit = $f_skip * $anzahl;
$nextcheck = $limit + $anzahl;
$query = "SELECT COUNT(s.id) AS summe FROM system s, system_section ss WHERE ss.system_id = s.id AND ss.section_id = $f_section AND s.status = 1";
$result = mysql_query($query,$mysql);
@$row = mysql_fetch_array($result);
$total = $row[summe];
$lowborder = $f_skip * $anzahl + 1;
$highborder = ( $f_skip +1 ) * $anzahl;
if ( $highborder > $total ) {
$highborder = $total;
}
if ( $total == 0 ) {
$lowborder = $total;
}
$query = "SELECT s.id AS id FROM system s, system_section ss WHERE ss.system_id = s.id AND ss.section_id = $f_section AND s.status = 1 ORDER BY name LIMIT $nextcheck, $anzahl";
$result = mysql_query($query,$mysql);
echo mysql_error();
if ( mysql_affected_rows() ) {
// $nextlink = "$row[description]\n";
} else {
# Beschreibungstext ... was kann man machen?
?>
![](\"gfx/right.gif\"){kind=small}
![](\"gfx/empty.gif\"){kind=spacer}
\n";
// $nextlink = "[next $anzahl hits]\n";
// $nextlink = " ";
}
if ( $f_skip > 0 ) {
// $lastlink = "[previous $anzahl hits]\n";
$lastlink = "![](\"gfx/left.gif\"){kind=small}
