Esempio n. 1
0
             }
             $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">&nbsp;' . $nl;
         $p = 'sql.php?sql_statement=' . urlencode($sql['sql_statement']) . '&amp;db=' . $databases['db_actual'] . '&amp;tablename=' . $tablename . '&amp;dbid=' . $dbid . '&amp;limitstart=' . $limitstart . '&amp;order=' . urlencode($order) . '&amp;orderdir=' . $orderdir . '&amp;tdc=' . $tdcompact;
         if ($key == -1) {
             $rk = build_where_from_record($temp[$i]);
             $p .= '&amp;recordkey=' . urlencode($rk);
         } else {
             //Key vorhanden
             $p .= '&amp;recordkey=' . urlencode($primary_key);
             //urlencode("`".$fdesc[$key]['name']."`='".$rowval."'");
         }
         if ($showtables == 1) {
             $p .= '&amp;recordkey=' . urlencode($tablename);
         }
         if (!isset($no_edit) || !$no_edit) {
             if ($showtables == 0) {
                 $d .= '<a href="' . $p . '&amp;mode=edit">' . $icon['edit'] . '</a>&nbsp;';
             }
         }
         if ($showtables == 0 && $tabellenansicht == 0) {
Esempio n. 2
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 = "&nbsp;";
            }
            $tpl->assign_block_vars('HITS.TABLEROW.TABLEDATA', array('VAL' => $val));
        }
    }
} else {
    if (!isset($tables[$table_selected])) {
        $tables[$table_selected] = '';