} $primary_key .= '`' . urlencode($rowkey) . '`=\'' . urlencode($rowval) . '\''; } } //echo "<br><br>Primaerschluessel erkannt: ".$primary_key; } foreach ($sortkey as $rowkey => $rowval) { if ($rowkey == 'Name' && $tabellenansicht == 1 && isset($row['Name'])) { $tablename = $row['Name']; } if ($erste_spalte == 1) { //edit-pics $d .= $nl . '<td valign="top" nowrap="nowrap" class="small"> ' . $nl; $p = 'sql.php?sql_statement=' . urlencode($sql['sql_statement']) . '&db=' . $databases['db_actual'] . '&tablename=' . $tablename . '&dbid=' . $dbid . '&limitstart=' . $limitstart . '&order=' . urlencode($order) . '&orderdir=' . $orderdir . '&tdc=' . $tdcompact; if ($key == -1) { $rk = build_where_from_record($temp[$i]); $p .= '&recordkey=' . urlencode($rk); } else { //Key vorhanden $p .= '&recordkey=' . urlencode($primary_key); //urlencode("`".$fdesc[$key]['name']."`='".$rowval."'"); } if ($showtables == 1) { $p .= '&recordkey=' . urlencode($tablename); } if (!isset($no_edit) || !$no_edit) { if ($showtables == 0) { $d .= '<a href="' . $p . '&mode=edit">' . $icon['edit'] . '</a> '; } } if ($showtables == 0 && $tabellenansicht == 0) {
$table_keys = isset($fieldinfos['primary_keys']) ? $fieldinfos['primary_keys'] : ''; for ($a = 0; $a < $zeige_treffer; $a++) { $tablename = array_keys($treffer[$a]); if (is_array($table_keys) && sizeof($table_keys) > 0) { // a primary key exitst $keystring = ''; foreach ($table_keys as $k) { // remove hit marker from value $x = str_replace('<span class="treffer">', '', $treffer[$a][$k]); $x = str_replace('</span>', '', $x); $keystring .= '`' . $k . '`="' . addslashes($x) . '" AND '; } $keystring = substr($keystring, 0, -5); $rk = build_recordkey($keystring); } else { $rk = urlencode(build_where_from_record($treffer[$a])); // no keys } $delete_link = 'sql.php?search=1&mode=kill&db=' . urlencode($db) . '&tablename=' . urlencode($tables[$table_selected]) . '&rk=' . $rk; $edit_link = 'sql.php?mode=searchedit&db=' . urlencode($db) . '&tablename=' . urlencode($tables[$table_selected]) . '&recordkey=' . $rk; $tpl->assign_block_vars('HITS.TABLEROW', array('CLASS' => $a % 2 ? 'dbrow' : 'dbrow1', 'NR' => $a + $offset + 1, 'TABLENAME' => $tables[$table_selected], 'LINK_EDIT' => $edit_link, 'ICON_EDIT' => $icon['edit'], 'LINK_DELETE' => $delete_link, 'ICON_DELETE' => $icon['delete'])); foreach ($treffer[$a] as $key => $val) { if ($val == '') { $val = " "; } $tpl->assign_block_vars('HITS.TABLEROW.TABLEDATA', array('VAL' => $val)); } } } else { if (!isset($tables[$table_selected])) { $tables[$table_selected] = '';