$t) { if($_POST['import_'.$t]) { if($multi[$k]) { if(!$_POST['keep_'.$t]) mysql_query('DELETE FROM '.$t.' WHERE serial='.$_POST['id']); sqlforeach('SELECT * FROM '.$t.' WHERE serial='.$_POST['id2'], 'add_data', $t); } else { $data = sqlfirst('SELECT * FROM '.$t.' WHERE serial='.$_POST['id2']); $data['serial']=$_POST['id']; mysql_query('UPDATE '.$t.' SET '.updatestr($data).' WHERE serial='.$_POST['id']); } } } } else { // ANZEIGEN echo '

'; echo ''; echo ''; } // ANZEIGEN => NON-MULTI TABELLEN echo '

'; if(!$_POST['do_import']) { echo 'TARGET: '; echo '#'.$id.': '.sqlfirst('SELECT hostname FROM cfg_network WHERE serial='.$id,'hostname'); echo ' '; echo 'IMPORT FROM ALX: '; echo ''; function list_serial($data) { echo '# '.$data['serial'].': '.$data['hostname']; } sqlforeach('SELECT serial, hostname FROM cfg_network WHERE serial!='.$id.' ORDER BY serial ASC','list_serial',null); echo ' '; echo ''; echo 'IMPORT TABLES: '; echo ''; foreach($tabs as $k=>$t) { if(!$multi[$k]) echo ''; else echo ''; } echo ''; echo ' '.$t.' '.$t.' Keep old data ALL '; echo ''; } else echo 'IMPORT PROCESSED! [EDIT] [INDEX]'; // ANZEIGEN => NAVI echo '

'; // STATUS BESTIMMEN (ON/OFF) $conn = sqlfirst('SELECT * FROM state_connected WHERE serial='.$id); $state = 'Off'; if(count($conn)>0) { passthru("/usr/sbin/fping -c 1 -i 50 -q ".$conn['ip']." &> /dev/null && exit 0 || exit 1",$retval); if($retval==0) $state = 'On'; } echo ' '; $davor = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id-1),'mac')!=null; if($davor) $disdavor=''; else $disdavor = 'disabled=1'; $danach = sqlfirst('SELECT mac FROM client_serials WHERE serial='.($id+1),'mac')!=null; if($danach) $disdanach=''; else $disdanach = 'disabled=1'; echo ''; echo ''; echo ''; echo ' '; echo ' '; echo ' '; echo 'Serial:  #'.$id.' '; echo 'Stand:  '.date('H:i:s').' '; echo 'Status: '.$state.'line '; if($state=='On') echo 'IP: '.$conn['ip']; echo ' '; //echo ' '; if($state=='On') { echo ' '; echo ' '; } else echo ' '; echo '

'; if(!$_POST['do_import']) echo '

'; ?>