functions are incorporated from the upper dir.
-#include "lt2k.style"
+#include <ltol.style>
-<PAGE title="LinuxTag 2000 - Aussteller bearbeiten">
-
-<h1 align=center><font face="Helvetica,Arial">Oldenburger LinuxTag 2000</font></h1>
-<h3 align=center><font face="Helvetica,Arial">- Ausstellung -</font></h3>
+<page func="Oldenburger LinuxTag 2000" title="Ausstellung">
<define-tag field>
<set-var %attributes>
<?
if ($id > 0) {
- $dbh = pg_pconnect ("kuolema", "5432", "<db>")
+ $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
or die("Unable to connect to SQL server");
$query = "SELECT * FROM exhibitor WHERE id = '$id'";
}
?>
-</PAGE>
+</page>
# Local variables:
# mode: text
-#include "lt2k.style"
+#include <ltol.style>
-<PAGE title="LinuxTag 2000 - Ausstellung">
-
-<h1 align=center><font face="Helvetica,Arial">Oldenburger LinuxTag 2000</font></h1>
-<h3 align=center><font face="Helvetica,Arial">- Ausstellung -</font></h3>
-
-#<table border=0 cellspacing=3 bgcolor="#f7ba2e">
+<page func="Oldenburger LinuxTag 2000" title="Ausstellung::Platzbedarf">
<define-tag cell>
<td><font face="Helvetica,Arial">
</font></td>
</define-tag>
-<h3><font face="Helvetica,Arial">Platzbedarf</font></h3>
-<table border=1 cellspacing=1 cellpadding=3>
-<tr bgcolor="#c0e4f0"><th align=left width=56%><font face="Helvetica,Arial">Organisation</font></th>
+<table border=0 cellspacing=0 cellpadding=1>
+<tr bgcolor="#<colh>"><th align=left width=56%><font face="Helvetica,Arial">Organisation</font></th>
<th align=left width=20%><font face="Helvetica,Arial">Typ</font></th>
<th align=left width=7%><font face="Helvetica,Arial">Platz</font></th>
<th align=left width=7%><font face="Helvetica,Arial">Rechner</font></th>
</tr>
<?
- $dbh = pg_pconnect ("kuolema", "5432", "<db>")
+ $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
or die("Unable to connect to SQL server");
$query = "SELECT id,organization,type,amount,boothsize,nr_computers FROM exhibitor ORDER BY organization";
$sum=0;
$computers=0;
+ $color = "<cold>";
for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
$row = pg_fetch_array ($sth, $nr);
+ $color = $color == "<cold>"?"<coln>":"<cold>";
- printf ("<tr><td align=\"left\" width=\"56%%\"><font face=\"Helvetica,Arial\">%d. <a href=\"edit.php3?id=%d\">%s</a></font></td>"
+ printf ("<tr bgcolor=\"#%s\"><td align=\"left\" width=\"56%%\"><font face=\"Helvetica,Arial\">%d. "
+ ."<a href=\"edit.php3?id=%d\">%s</a></font></td>"
. "<td align=\"left\" width=\"20%%\"><font face=\"Helvetica,Arial\">%s</font></td>"
. "<td align=\"right\" width=\"7%%\"><font face=\"Helvetica,Arial\">%s</font></td>"
. "<td align=\"right\" width=\"7%%\"><font face=\"Helvetica,Arial\">%s</font></td>"
. "<td align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%8.2f</font></td>"
- . "</tr>\n", $nr+1, $row['id'], $row['organization'], $row['type'], $row['boothsize'],
+ . "</tr>\n", $color, $nr+1, $row['id'], $row['organization'], $row['type'], $row['boothsize'],
$row['nr_computers'], $row['amount']);
$sum += $row['boothsize'];
$amount += $row['amount'];
$sum_proj++;
}
}
+ $color = $color == "<cold>"?"<coln>":"<cold>";
?>
-<tr><th align=left width=76% colspan=2><font face="Helvetica,Arial">Summe</font></th>
+
+<tr bgcolor=#<? echo $color; ?>><th align=left width=76% colspan=2><font face="Helvetica,Arial">Summe</font></th>
<th align=right width=7%><font face="Helvetica,Arial"><? echo $sum; ?></font></th>
<th align=right width=7%><font face="Helvetica,Arial"><? echo $computers; ?></font></th>
<th align=right width=10%><font face="Helvetica,Arial"><? printf ("%9.2f",$amount); ?></font></th>
<? printf ("(Stände: %d kommerzielle, %d Projekte, %d LUGO<p>", $sum_comm-3, $sum_proj, $sum_lugo); ?>
-<a href="edit.php3">Neue Organisation aufnehmen</a><br>
<a href="list.php3?sort=name">Detail</a> (nach Namen sortiert)<br>
<a href="list.php3?sort=nr">Detail</a> (nach Standnr sortiert)<br>
-</PAGE>
+</page>
# Local variables:
# mode: text
-#include "lt2k.style"
+#include <ltol.style>
-<PAGE title="LinuxTag 2000 - Ausstellung">
-
-<h1 align=center><font face="Helvetica,Arial">Oldenburger LinuxTag 2000</font></h1>
-<h3 align=center><font face="Helvetica,Arial">- Ausstellung -</font></h3>
-
-#<table border=0 cellspacing=3 bgcolor="#f7ba2e">
+<page func="Oldenburger LinuxTag 2000" title="Ausstellung::Detail">
<define-tag cell>
<td><font face="Helvetica,Arial">
</font></td>
</define-tag>
-<h3><font face="Helvetica,Arial">Detailierte Aufschlüsselung</font></h3>
-
-<table border=1 cellspacing=1 cellpadding=3>
+<table border=0 cellspacing=0 cellpadding=1>
<tr bgcolor="#c0e4f0">
<th align=left width=10%><font face="Helvetica,Arial">Stand</font></th>
<th align=left width=30%><font face="Helvetica,Arial">Organisation</font></th>
$sort = "boothnr,organization";
}
- $dbh = pg_pconnect ("kuolema", "5432", "<db>")
+ $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
or die("Unable to connect to SQL server");
$query = "SELECT id,organization,boothnr,boothsize,nr_computers,nr_tables,nr_chairs,nr_walls,personal "
$sum['nr_walls']=0;
$sum['personal']=0;
+ $color = "<cold>";
for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
$row = pg_fetch_array ($sth, $nr);
$personal = 1;
if (!strlen ($row['boothnr'])) {
$row['boothnr'] = " ";
}
+ $color = $color == "<cold>"?"<coln>":"<cold>";
- printf ("<tr>
+ printf ("<tr bgcolor=\"#%s\">
<td align=\"left\" width=\"10%%\"><font face=\"Helvetica,Arial\">%s</font></td>
<td align=\"left\" width=\"30%%\"><font size=\"-1\" face=\"Helvetica,Arial\"><a href=\"edit.php3?id=%d\">%s</a></font></td>
<td align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d</font></td>
<td align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d</font></td>
<td align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d</font></td>
<td align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d qm</font></td>
- </tr>", $row['boothnr'], $row['id'], $row['organization'], $row['nr_computers'], $personal,
+ </tr>", $color, $row['boothnr'], $row['id'], $row['organization'], $row['nr_computers'], $personal,
$row['nr_tables'], $row['nr_chairs'], $row['nr_walls'],
$row['boothsize']);
$sum['nr_walls'] += $row['nr_walls'];
$sum['personal'] += $personal;
}
+ $color = $color == "<cold>"?"<coln>":"<cold>";
- printf ("<tr>
+ printf ("<tr bgcolor=\"#%s\">
<th align=\"left\" width=\"10%%\"><font face=\"Helvetica,Arial\"> </font></th>
<th align=\"left\" width=\"30%%\"><font face=\"Helvetica,Arial\">Summe</font></th>
<th align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d</font></th>
<th align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d</font></th>
<th align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d</font></th>
<th align=\"right\" width=\"10%%\"><font face=\"Helvetica,Arial\">%d qm</font></th>
- </tr>", $sum['nr_computers'], $sum['personal'], $sum['nr_tables'],
+ </tr>", $color, $sum['nr_computers'], $sum['personal'], $sum['nr_tables'],
$sum['nr_chairs'], $sum['nr_walls'], $sum['boothsize']);
?>
</table><p>
-
-<a href="index.php3">Index</a><br>
<a href="list.php3?sort=name">Detail</a> (nach Namen sortiert)<br>
<a href="list.php3?sort=nr">Detail</a> (nach Standnr sortiert)<br>
-#include "lt2k.style"
+#include <ltol.style>
+#include <phptools.inc>
-<PAGE title="LinuxTag 2000 - Aussteller bearbeiten">
-
-<h1 align=center><font face="Helvetica,Arial">Oldenburger LinuxTag 2000</font></h1>
-<h3 align=center><font face="Helvetica,Arial">- Ausstellung -</font></h3>
+<page func="Oldenburger LinuxTag 2000" title="Ausstellung">
+<sql_prepare>
<?
- function sql_prepare ($text)
- {
- # Der Himmel ist blau, das Wasser ist klar, die Vögel zwitschern
- # draußen, doch PHP weigert sich beharrlich, vernünftig zu
- # arbeiten.
- #
- # Problem: Im Form kommt " an, PHP macht daraus freundlicherweise \"
- # und schon sind unsere Daten in der SQL-DB kaputt. Danke
- # $mytext = ereg_replace ("\\\\", "\\\\", $text);
- $mytext = ereg_replace ("\\\"", "\"", $text);
- # $mytext = ereg_replace ("'", "\\'", $mytext);
- return ($mytext);
- }
-
- $dbh = pg_pconnect ("kuolema", "5432", "<db>")
+ $dbh = pg_pconnect ("<dbhost>", "<dbport>", "<dbname>")
or die("Unable to connect to SQL server");
<:
<a href="list.php3?sort=name">Detail</a> (nach Namen sortiert)<br>
<a href="list.php3?sort=nr">Detail</a> (nach Standnr sortiert)<br>
-<p><em>Die Datenbanken sind read-only, da der Oldenburger LinuxTag 2000 abgeschlossen ist.</em><p>
+<p><em>Die Datenbanken sind read-only geschaltet, da der Oldenburger LinuxTag 2000 abgeschlossen ist.</em><p>
</PAGE>