su_check(access_control::SU_RIGHT_DEV,true); page_header('Datenbank durchsuchen'); output('`c`b`&Quick\'n\'dirty Tool um die Datenbank zu schrotten`&`b`c`n'); addnav('S?einfache Suche',$str_filename); addnav('Query eingeben',$str_filename.'?op=query'); switch($_GET['op']) { case '': $str_lnk = $str_filename.'?op=viewresult'; addnav('',$str_lnk); $str_enum_tables = ' accounts,Accounts, account_extra_info,aei, houses,Häuser, settings,Einstellungen '; $str_enum_ops = ' LIKE,ähnlich, =,gleich, >,größer, <,kleiner, <>,ungleich '; $arr_form = array( 'select'=>'SELECT Feldname(n)', 'table_custom'=>'FROM (eingeben', 'table_given'=>'oder wählen),enum,'.$str_enum_tables , 'where'=>'WHERE Feldinhalt', 'ops'=>'Ausdruck,enum,'.$str_enum_ops , 'search'=>'Suchstring', 'and_or'=>'AND / OR (optional),enum,AND,und,OR,oder', 'where1'=>'Feldinhalt', 'ops1'=>'Ausdruck,enum,'.$str_enum_ops , 'search1'=>'Suchstring' ); $arr_data = array( 'select'=>'*', 'where'=>'name', 'search'=>'logd' ); $str_out = '

'; $str_out .= generateform($arr_form,$arr_data,false,'Abfrage durchführen'); $str_out .= '

'; output($str_out); break; case 'viewresult': if(empty($_POST['ops'])) { $sql=stripslashes($_POST['sql']); } else { $str_select = ($_POST['select'] ? $_POST['select'] : '*'); $str_table = (!empty($_POST['table_custom']) ? $_POST['table_custom'] : $_POST['table_given']); $str_where = ($_POST['where'] ? $_POST['where'] : '1'); $str_search = ($_POST['ops']=='LIKE'?str_create_search_string($_POST['search']):stripslashes($_POST['search'])); $sql='SELECT '.$str_select.' FROM '.$str_table.' WHERE '.$str_where.' '.$_POST['ops'].' "'.$str_search.'"'; if (!empty($_POST['search1'])) { $str_where1 = ($_POST['where1'] ? $_POST['where1'] : '1'); $str_search1 = ($_POST['ops1']=='LIKE'?str_create_search_string($_POST['search1']):$_POST['search1']); $sql.=' '.$_POST['and_or'].' '.$str_where1.' '.$_POST['ops1'].' '.$str_search1; } $sql.=' LIMIT 30'; } $result=db_query($sql); if(is_resource($result) && db_num_rows($result)==0) { $str_out.='`$Die Abfrage lieferte ein leeres Ergebnis.`0'; } elseif(is_resource($result)) { $str_out.=''; while($row=db_fetch_assoc($result)) { if($i<1) { $str_out.=''; foreach ($row as $key => $value) { $str_out.= ''; } $str_out.=''; $i=10; } $bgclass = ($bgclass=='trdark'?'trlight':'trdark'); $str_out.=''; foreach ($row as $value) { $str_out.= ''; } $str_out.=''; $i--; } $str_out.='

'.$key.'
'.substr(strip_tags($value),0,50).(strlen($value)>50?'...':'').'

'; } elseif($result===true) { $str_out.=db_affected_rows().' Datensätze geändert.'; } else { $str_out.='Da war irgendwas falsch.'; } //output($str_out); // kein break; case 'query': $str_lnk = $str_filename.'?op=viewresult'; addnav('',$str_lnk); $arr_form = array( 'sql' => 'SQL-Query:,textarea,60,8' ); $arr_data = array( 'sql' => $sql ); $str_out .= '

'; $str_out .= generateform($arr_form,$arr_data,false,'Ausführen'); $str_out .= '

'; output($str_out); break; default: output('Undefinerte Operation! Op: '.$op); } addnav('Zurück'); grotto_nav(); page_footer(); ?>