function showall($next) { global $REX; // ------------- FALLS KEIN ROWSELECT ALLE DATENSAETZE HOLEN UND ANZAHL SETZEN if ($this->rows == "") { $this->sql = new sql($this->DB); $this->sql->setQuery($this->query); $this->rows = $this->sql->getRows(); } $echo = "<table width=770 cellpadding=5 cellspacing=1 border=0 bgcolor=#ffffff>"; $echo .= $this->table_header; // ------------- BLAETTERN if (!($next > 0 && $next <= $this->rows)) { $next = 0; } $list_start = $next; $list_end = $next + $this->list_amount; if ($list_end > $this->rows) { $list_end = $this->rows; } $before = $next - $this->list_amount; if ($before < 0) { $before = 0; } $next = $next + $this->list_amount; if ($next > $this->rows) { $next = $next - $this->list_amount; } if ($next < 0) { $next = 0; } $bhead = $this->blaettern_head; $bhead = str_replace("###LINK_BACK###", $this->addonlink . $before, $bhead); $bhead = str_replace("###LINK_NEXT###", $this->addonlink . $next, $bhead); $bhead = str_replace("###LIST_START###", $list_start, $bhead); $bhead = str_replace("###LIST_END###", $list_end, $bhead); $bhead = str_replace("###LIST_ALL###", $this->rows, $bhead); if ($this->blaettern_top) { $echo .= "<tr><td colspan=" . $this->data_num . " class=lgrey>{$bhead}</td></tr>"; } // ------------ QUERY NEU ERSTELLEN MIT LIMIT $limit = "LIMIT " . $list_start . "," . $this->list_amount; $order = ""; if ($this->order_name != "") { $order = " order by " . $this->order_name . " " . $this->order_type; } elseif ($this->default_order_name != "") { $order = " order by " . $this->default_order_name . " " . $this->default_order_type; } $SQL = new sql($this->DB); $SQL->debugsql = $this->debugsql; $SQL->setQuery("{$this->query} {$order} {$limit}"); // ------------ <TH>HEADLINES $echo .= "<tr>"; for ($i = 1; $i <= $this->data_num; $i++) { $echo .= "<th>"; if ($this->data_order[$i]) { $type = $this->order_type; if ($type == "asc") { $type = "desc"; } else { $type = "asc"; } $echo .= " <a href=" . $this->addonlink . "&" . $this->var_ordername . "=" . $this->data[$i] . "&" . $this->var_ordertype . "=" . $type . "&" . $this->var_next . "={$before}><b>" . $this->data_name[$i] . "</b>" . $this->sort_char . "</a>"; } else { $echo .= $this->data_name[$i]; } $echo .= "</th>"; } $echo .= "</tr>"; // ------------ ERSTELLUNG DER LISTE for ($j = 0; $j < $SQL->getRows(); $j++) { for ($i = 1; $i <= $this->data_num; $i++) { // ----- START: DATENSATZ $echo .= "<td class=grey valign=top " . $this->td[$this->data_num] . ">"; // ----- START: FORMAT if (!is_array($this->format[$i])) { $value = htmlentities($SQL->getValue($this->data[$i])); } else { $value = $SQL->getValue($this->data[$i]); $contentvalue = $this->data[$i]; for ($k = 0; $k < count($this->format[$i]); $k++) { switch ($this->format[$i][$k]) { case "link": $linkid = $SQL->getValue($this->format_value2[$i][$k]); $value = '<a href="' . $this->format_value1[$i][$k] . $linkid . $this->format_value3[$i][$k] . '" ' . $this->format_value4[$i][$k] . '>' . $value . '</a>'; break; case "ifvalue": if ($value == $this->format_value1[$i][$k]) { $value = $this->format_value2[$i][$k]; } break; case "ifempty": if ($value == "") { $value = $this->format_value1[$i][$k]; } break; case "prefix": $value = $this->format_value1[$i][$k] . "{$value}"; break; case "suffix": $value = "{$value}" . $this->format_value1[$i][$k]; break; case "callback": $value = call_user_func($this->format_value1[$i][$k], $value); break; case "activestatus": if ($value == 0) { $value = "inactive"; } else { $value = "active"; } break; case "status": if ($value == 0) { $value = "inactive user"; } elseif ($value == 7) { $value = "superadmin"; } elseif ($value > 4) { $value = "admin"; } elseif ($value == 1) { $value = "guest"; } else { $value = "user"; } break; case "dt": $dt = $this->format_value1[$i][$k]; if ($dt == "") { $dt = "M-d Y H:i:s"; } $value = date_from_mydate($value, $dt); break; case "hour": $value = $value . " h"; break; case "minutes": $value = "{$value} min"; break; case "minute2hour": $hours = intval($value / 60); $minutes = ($value - $hours * 60) / 60 * 100; if ($minutes < 10) { $minutes = "0{$minutes}"; } elseif ($minutes == 0) { $minutes = "00"; } $value = "{$hours},{$minutes}"; break; case "date": $format = $this->format_value1[$i][$k]; if ($format == "") { $format = "d.M.Y H:i:s"; } $value = date_from_mydate($value, $format); break; case "time": $value = substr($value, 0, 2) . ":" . substr($value, 2, 2) . ""; break; case "unixToDateTime": $format = $this->format_value1[$i][$k]; if ($format == "") { $format = "d.M.Y H:i:s"; } $value = date($format, $value); break; case "nl2br": $value = nl2br($value); break; case "prozent": $value = "<img src=/pics/p_prozent/" . show_prozent($value) . ".gif height=13 width=50>"; break; case "wrap": $value = $this->format_value1[$i][$k] . $value . $this->format_value2[$i][$k]; break; case "addfield": $value = $value . $this->format_value2[$i][$k] . $SQL->getValue($this->format_value1[$i][$k]) . $this->format_value3[$i][$k]; break; case "clear": $value = ""; break; case "substr": $elements = imap_mime_header_decode($value); $value = ""; for ($l = 0; $l < count($elements); $l++) { // echo "Charset: {$elements[$i]->charset}\n"; $value .= $elements[$l]->text; } $value = substr($value, 0, $this->format_value1[$i][$k]); $value = htmlentities($value); break; case "content": $value = $contentvalue; break; case "size": $value = "<div style='text-align:right;width:auto;'>" . $this->human_file_size($value) . "</div>"; break; case "js": $elements = imap_mime_header_decode($value); $value = ""; for ($l = 0; $l < count($elements); $l++) { // echo "Charset: {$elements[$i]->charset}\n"; $value .= $elements[$l]->text; } if ($value == "") { $value = "<no entry>"; } if ($this->format_value4[$i][$k] == "") { $value = substr($value, 0, 30); } else { if ($this->format_value4[$i][$k] == "nosubstr") { $value = $value; } else { $value = substr($value, 0, $this->format_value4[$i][$k]); } } $value = nl2br(htmlentities($value)); $value = "<a href=javascript:" . $this->format_value1[$i][$k] . $SQL->getValue($this->format_value2[$i][$k]) . $this->format_value3[$i][$k] . ">{$value}</a>"; break; case "boldstatus": // ********************** // Prozer Special: MAIL // zum anzeigen von bold falls TRUE(1) // ********************** $elements = imap_mime_header_decode($value); $value = ""; for ($l = 0; $l < count($elements); $l++) { // echo "Charset: {$elements[$i]->charset}\n"; $value .= $elements[$l]->text; } if ($value == "") { $value = "<no subject entered>"; } $value = substr($value, 0, 30); $value = htmlentities($value); //echo "<!-- ".$SQL->getValue("header")."-->"; if ($SQL->getValue("spam") != 0 && eregi("X-Spam-Flag: YES", $SQL->getValue("header"))) { if (!$SQL->getValue($this->format_value1[$i][$k])) { $value = "<b style=\"color:red\">{$value}</b>"; } else { $value = "<span style=\"color:red\">{$value}</span>"; } } elseif (!$SQL->getValue($this->format_value1[$i][$k])) { $value = "<b>{$value}</b>"; } break; case "image": // ********************** // Prozer Special // zum anzeigen von bold falls TRUE(1) // ********************** if ($SQL->getValue($this->format_value1[$i][$k]) > 0) { $value = $this->format_value2[$i][$k] . " " . htmlentities($value); } else { $value = " "; } break; case "statustodo": // ********************** // Prozer Special // zum anzeigen von bold falls TRUE(1) // ********************** if ($value == 0) { $value = "done"; } elseif ($value == 1) { $value = "in work"; } elseif ($value == 2) { $value = "new"; } break; case "replace_value": $stype = explode("|", $this->format_value1[$i][$k]); $lvalue = $value; $defaultvalue = -1; for ($l = 0; $l < count($stype); $l++) { $svalue = $stype[$l]; $l++; $sname = $stype[$l]; if ($svalue === "") { $defaultvalue = $sname; } if ($lvalue == $svalue) { $lvalue = $sname; } } if ($lvalue == $value && $defaultvalue != -1) { $lvalue = $defaultvalue; } $value = $lvalue; break; case "checkbox": $value = "<input onclick=setTRColor('tr{$j}','#f0efeb','#d8dca5',this.checked); type=checkbox name='" . $this->format_value1[$i][$k] . "' value='" . $value . "'>"; break; } } } // if ($value==""){ $value = "-"; } // ----- END: FORMAT $echo .= $value; $echo .= "</td>\n"; // ----- END: DATENSATZ } $echo .= "</tr>"; // ----- END: REIHE $SQL->next(); } if ($this->blaettern_bottom) { $echo .= "<tr><td colspan=" . $this->data_num . " class=lgrey>{$bhead}</td></tr>"; } $echo .= $this->table_footer; $echo .= "</table>"; return $echo; }
function showMessage() { global $FORM; $msql = new sql($this->DB); $msql->setQuery("select * from {$this->table} {$this->userjoin_query} where " . $this->table . ".re_message_id='0' and " . $this->table . ".board_id='" . $this->boardname . "' and " . $this->table . ".message_id='" . $FORM[message_id] . "' and " . $this->table . ".status='1'"); if ($msql->getRows() == 1) { $mout = "<table " . $this->layout[50] . ">\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td colspan=2 " . $this->layout[30] . "><b>" . $this->text[10] . " <a href=" . $this->docname . "?" . $this->getLink() . " " . $this->layout[60] . ">" . $this->realboardname . "</a></b></td>\r\n\t\t\t\t</tr>\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td width=200 " . $this->layout[10] . "><b>" . $this->text[40] . "</b></td>\r\n\t\t\t\t\t<td width=500 " . $this->layout[20] . "><b>" . $msql->getValue($this->table . ".subject") . "</b></td>\r\n\t\t\t\t</tr>\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td " . $this->layout[10] . " valign=top>" . $this->showUser($msql->getValue($this->linkuser_field_id), $msql->getValue($this->userjoin_field)) . "<br>" . date_from_mydate($msql->getValue($this->table . ".stamp"), $this->text[150]) . $this->text[155] . "</td>\r\n\t\t\t\t\t<td " . $this->layout[20] . " valign=top>" . nl2br(htmlentities($msql->getValue($this->table . ".message"))); if ($this->admin) { $mout .= "<br><br><a href=" . $this->docname . "?" . $this->getLink() . "&FORM[func]=deleteMessage&FORM[message_id]=" . $msql->getValue($this->table . ".message_id") . " " . $this->layout[60] . ">" . $this->text[270] . "</a>"; } $mout .= "</td>\r\n\t\t\t\t\t</tr>"; $mrsql = new sql($this->DB); $mrsql->setQuery("select * from {$this->table} {$this->userjoin_query} where " . $this->table . ".re_message_id='" . $FORM[message_id] . "' and " . $this->table . ".status=1"); if ($mrsql->getRows() > 0) { $mout .= "<tr>\r\n\t\t\t\t\t\t<td " . $this->layout[30] . " colspan=2><b>" . $this->text[60] . "</b></td>\r\n\t\t\t\t\t</tr>" . $this->warning(2); for ($i = 0; $i < $mrsql->getRows(); $i++) { $mout .= "<tr>"; if ($mrsql->getValue('anonymous_user') != '') { $mout .= "<td " . $this->layout[10] . " valign=top><font color=#bbbbbb>" . sprintf("%03d", $i + 1) . "</font><br>" . $mrsql->getValue('anonymous_user') . "<br>"; } else { $mout .= "<td " . $this->layout[10] . " valign=top><font color=#bbbbbb>" . sprintf("%03d", $i + 1) . "</font><br>" . $this->showUser($mrsql->getValue($this->linkuser_field_id), $mrsql->getValue($this->userjoin_field)) . "<br>"; } $mout .= date_from_mydate($mrsql->getValue($this->table . ".stamp"), $this->text[150]) . $this->text[155] . "</td>\r\n\t\t\t\t\t<td " . $this->layout[20] . " valign=top>" . nl2br(htmlentities($mrsql->getValue($this->table . ".message"))); if ($this->admin) { $mout .= "<br><br><a href=" . $this->docname . "?" . $this->getLink() . "&FORM[func]=deleteMessage&FORM[message_id]=" . $mrsql->getValue($this->table . ".message_id") . " " . $this->layout[60] . ">" . $this->text[280] . "</a>"; } $mout .= "</td>\r\n\t\t\t\t\t\t</tr>"; $mrsql->next(); } } else { $mout .= "<tr><td colspan=2 " . $this->layout[20] . ">" . $this->text[170] . "</td></tr>"; } if ($this->checkVars()) { $mout .= "\r\n\t\t\t\t\t<form action=" . $this->docname . " method=post>\r\n\t\t\t\t\t" . $this->getLink("post") . "\r\n\t\t\t\t\t<input type=hidden name=FORM[message_id] value=" . $msql->getValue($this->table . ".message_id") . ">\r\n\t\t\t\t\t<input type=hidden name=FORM[func] value=reply>\r\n\t\t\t\t \t<tr>\r\n\t\t\t\t\t\t<td colspan=2 " . $this->layout[30] . "><b>" . $this->text[180] . "</b></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t"; // vscope anonymous hack if ($this->anonymous != false && $this->username == '') { $mout .= "\r\n\t \t<tr>\r\n\t \t<td " . $this->layout[10] . ">" . $this->text[290] . "</td>\r\n\t \t<td " . $this->layout[20] . "><input type=text name=FORM[anonymous_user] maxlength=15 style='width: 100%;' value='" . htmlentities($FORM[subject]) . "'></td>\r\n\t \t</tr>\r\n\t \t"; } $mout .= "\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td " . $this->layout[10] . " valign=top><font color=#bbbbbb>" . sprintf("%03d", $i + 1) . "</font><br>" . $this->username . "<br>" . date_from_mydate(date("YmdHis"), $this->text[150]) . $this->text[155] . "</td>\r\n\t\t\t\t\t\t<td " . $this->layout[20] . " valign=top>\r\n\t\t\t\t\t\t\t<textarea cols=60 rows=5 name=FORM[message] style='width: 100%;'>" . $FORM[message] . "</textarea><br>\r\n\t\t\t\t\t\t\t<input type=submit value='" . $this->text[190] . "'></td>\r\n\t\t\t\t\t</tr></form>"; } $mout .= "</table>"; } return $mout; }
} echo "</tr>"; } elseif ($REX_USER->isValueOf("rights", "article[" . $sql->getValue("id") . "]") || $REX_USER->isValueOf("rights", "article[all]")) { echo " <tr>\n\t <td class=grey align=center><a href=index.php?page=content&article_id=" . $sql->getValue("id") . "&category_id={$category_id}&mode=edit><img src=pics/{$icon} width=16 height=16 border=0></a></td>\n\t <td class=grey><a href=index.php?page=content&article_id=" . $sql->getValue("id") . "&category_id={$category_id}&mode=edit>" . $sql->getValue("name") . " </a></td>\n\t <td class=grey>{$pos}</td>\n\t <td class=grey>" . $TEMPLATE_NAME[$sql->getValue("template_id")] . "</td>\n\t <td class=grey>" . date_from_mydate($sql->getValue("erstelldatum"), "") . " </td>\n\t <td class=grey><b>{$startpage}</b></td>\n\t <td class=grey><strike>" . $I18N->msg("edit") . "</strike></td>"; if ($sql->getValue("startpage") == 1) { echo " <td class=grey><strike>delete</strike></td>\n\t <td class=grey><strike>" . $I18N->msg("status_online") . "</strike></td>"; } else { echo " <td class=grey><strike>" . $I18N->msg("delete") . "</strike></td>\n\t <td class=grey><strike>"; if ($sql->getValue("status") == 0) { echo "<font color=#dd0000>offline</font>"; } else { echo "<font color=#00dd00>" . $I18N->msg("status_online") . "</font>"; } echo " </strike></td>"; } echo "</tr>"; } else { echo " <tr>\n\t <td class=grey align=center><img src=pics/{$icon} width=16 height=16 border=0 align=middle></td>\n\t <td class=grey>" . $sql->getValue("name") . "</td>\n\t <td class=grey>{$pos}</td>\n\t <td class=grey>" . $TEMPLATE_NAME[$sql->getValue("template_id")] . "</td>\n\t <td class=grey>" . date_from_mydate($sql->getValue("erstelldatum"), "") . " </td>\n\t <td class=grey><b>{$startpage}</b></td>\n\t <td class=grey><strike>" . $I18N->msg("change") . "</strike></td>\n\t <td class=grey><strike>" . $I18N->msg("delete") . "</strike></td>\n\t <td class=grey><strike>"; if ($sql->getValue("status") == 0) { echo "<font color=#dd0000>" . $I18N->msg("status_offline") . "</font>"; } else { echo "<font color=#00dd00>" . $I18N->msg("status_online") . "</font>"; } echo " </strike></td>"; echo "</tr>"; } } $sql->counter++; } } echo "</table>";
function showall($next) { global $REX; // ------------- FALLS KEIN ROWSELECT ALLE DATENSAETZE HOLEN UND ANZAHL SETZEN if ($this->rows == "") { $this->sql = new sql($this->DB); $this->sql->setQuery($this->query); $this->rows = $this->sql->getRows(); } $echo = "<table width=100% cellpadding=5 cellspacing=1 border=0 bgcolor=#ffffff>"; $echo .= $this->table_header; // ------------- HEADER $echo .= "<tr><td colspan=" . ($this->data_num + $this->column_num) . " class=lgrey><b>"; // ------------- BLAETTERN if (!($next > 0 && $next <= $this->rows)) { $next = 0; } $list_start = $next; $list_end = $next + $this->list_amount; if ($list_end > $this->rows) { $list_end = $this->rows; } $before = $next - $this->list_amount; if ($before < 0) { $before = 0; } $next = $next + $this->list_amount; if ($next > $this->rows) { $next = $next - $this->list_amount; } if ($next < 0) { $next = 0; } $echo .= "<a href=index.php?article_id=" . $this->article_id . "&FORM[next]={$before}" . $this->addonlink . "><img src={$REX['HTDOCS_PATH']}/pics/back.gif width=24 height=13 border=0></a> "; $echo .= "<a href=index.php?article_id=" . $this->article_id . "&FORM[next]={$next}" . $this->addonlink . "><img src={$REX['HTDOCS_PATH']}/pics/forward.gif width=24 height=13 border=0></a>"; $echo .= " {$list_start} - {$list_end} of {$this->rows} "; $echo .= "</b></td></tr>"; // ------------ QUERY NEU ERSTELLEN MIT LIMIT $limit = "LIMIT " . $list_start . "," . $this->list_amount; $SQL = new sql($this->DB); $SQL->setQuery("{$this->query} {$limit}"); // ------------ <TH>HEADLINES $echo .= "<tr>"; for ($i = 1; $i <= $this->data_num; $i++) { $echo .= "<th>"; $echo .= $this->data_name[$i]; $echo .= "</th>"; if ($this->column_name[$i] != "") { $echo .= "<th> </th>"; } } $echo .= "</tr>"; // ------------ ERSTELLUNG DER LISTE for ($j = 0; $j < $SQL->getRows(); $j++) { // $echo .= "<tr onmouseover=\"setPointer(this,'#d8dca5')\" onmouseout=\"setPointer(this,'#f0efeb')\">"; $echo .= "<tr id=tr{$j}>"; for ($i = 1; $i <= $this->data_num; $i++) { $echo .= "<td class=grey valign=top>"; switch ($this->format[$i]) { case "activestatus": if ($SQL->getValue($this->data[$i]) == 0) { $value = "inactive"; } else { $value = "active"; } break; case "status": if ($SQL->getValue($this->data[$i]) == 0) { $value = "inactive user"; } elseif ($SQL->getValue($this->data[$i]) == 7) { $value = "superadmin"; } elseif ($SQL->getValue($this->data[$i]) > 4) { $value = "admin"; } elseif ($SQL->getValue($this->data[$i]) == 1) { $value = "guest"; } else { $value = "user"; } break; case "dt": $value = date_from_mydate($SQL->getValue($this->data[$i]), "M-d Y H:i:s"); break; case "hour": $value = $SQL->getValue($this->data[$i]) . " h"; break; case "minutes": $minutes = $SQL->getValue($this->data[$i]); $value = "{$minutes} min"; break; case "minute2hour": $hours = intval($SQL->getValue($this->data[$i]) / 60); $minutes = ($SQL->getValue($this->data[$i]) - $hours * 60) / 60 * 100; if ($minutes < 10) { $minutes = "0{$minutes}"; } elseif ($minutes == 0) { $minutes = "00"; } $value = "{$hours},{$minutes}"; break; case "date": $value = date_from_mydate($SQL->getValue($this->data[$i]), "Y-M-d"); break; case "time": $value = substr($SQL->getValue($this->data[$i]), 0, 2) . ":" . substr($SQL->getValue($this->data[$i]), 2, 2) . ""; break; case "unixToDateTime": $value = date("d.M.Y H:i:s", $SQL->getValue($this->data[$i])); break; case "nl2br": $value = nl2br($SQL->getValue($this->data[$i])); break; case "prozent": $value = "<img src=/pics/p_prozent/" . show_prozent($SQL->getValue($this->data[$i])) . ".gif height=13 width=50>"; break; case "substr": $value = $SQL->getValue($this->data[$i]); $elements = imap_mime_header_decode($value); $value = ""; for ($k = 0; $k < count($elements); $k++) { // echo "Charset: {$elements[$i]->charset}\n"; $value .= $elements[$k]->text; } $value = substr($value, 0, $this->format_value1[$i]); $value = htmlentities($value); break; case "content": $value = $this->data[$i]; break; case "js": $value = $SQL->getValue($this->data[$i]); $elements = imap_mime_header_decode($value); $value = ""; for ($k = 0; $k < count($elements); $k++) { // echo "Charset: {$elements[$i]->charset}\n"; $value .= $elements[$k]->text; } if ($value == "") { $value = "<no entry>"; } if ($this->format_value4[$i] == "") { $value = substr($value, 0, 30); } else { if ($this->format_value4[$i] == "nosubstr") { $value = $value; } else { $value = substr($value, 0, $this->format_value4[$i]); } } $value = nl2br(htmlentities($value)); $value = "<a href=javascript:" . $this->format_value1[$i] . $SQL->getValue($this->format_value2[$i]) . $this->format_value3[$i] . ">{$value}</a>"; break; case "boldstatus": // ********************** // Prozer Special: MAIL // zum anzeigen von bold falls TRUE(1) // ********************** $value = $SQL->getValue($this->data[$i]); $elements = imap_mime_header_decode($value); $value = ""; for ($k = 0; $k < count($elements); $k++) { // echo "Charset: {$elements[$i]->charset}\n"; $value .= $elements[$k]->text; } if ($value == "") { $value = "<no subject entered>"; } $value = substr($value, 0, 30); $value = htmlentities($value); if (!$SQL->getValue($this->format_value1[$i])) { $value = "<b>{$value}</b>"; } break; case "image": // ********************** // Prozer Special // zum anzeigen von bold falls TRUE(1) // ********************** if ($SQL->getValue($this->format_value1[$i]) > 0) { $value = $this->format_value2[$i] . " " . htmlentities($SQL->getValue($this->data[$i])); } else { $value = " "; } break; case "statustodo": // ********************** // Prozer Special // zum anzeigen von bold falls TRUE(1) // ********************** $value = $SQL->getValue($this->data[$i]); if ($value == 0) { $value = "done"; } elseif ($value == 1) { $value = "in work"; } elseif ($value == 2) { $value = "new"; } break; case "checkbox": $value = "<input onclick=setTRColor('tr{$j}','#f0efeb','#d8dca5',this.checked); type=checkbox name='" . $this->format_value1[$i] . "' value='" . $SQL->getValue($this->data[$i]) . "'>"; break; default: $value = htmlentities($SQL->getValue($this->data[$i])); } if ($value == "") { $value = "-"; } if ($this->link_to[$i] != "") { $link = $this->link_to[$i]; $link_field = $this->link_field[$i]; if ($this->link_field[$i] != "") { $value = "<a href=" . $this->link_to[$i] . urlencode($SQL->getValue($link_field)) . $this->addonlink . " class=yel>{$value}</a>"; } else { $value = value; } } $echo .= $value; $echo .= "</td>\n"; if ($this->column_name[$i] != "") { $link_name = $this->column_link[$i]; $link_field = $this->column_linkadd[$i]; $column_name = $this->column_name[$i]; $column_ausgabe = "<td class=grey valign=top><a href={$link_name}"; $column_ausgabe .= $SQL->getValue($link_field); $column_ausgabe .= $this->column_linkend[$i]; $column_ausgabe .= " class=yel>{$column_name}</a></td>"; $echo .= $column_ausgabe; } } $echo .= "</tr>"; $SQL->next(); } $echo .= $this->table_footer; $echo .= "</table><br>"; return $echo; }