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;
}
