if (!$IP->user_id()) { die("Login error"); } switch ($_POST['do']) { case 'newRoute': //print_r($_POST); $dat = $_POST['port']; $ip = explode(":", $dat)[0]; $port_fr = explode(":", $dat)[1]; $port_to = 0; $name = 'new'; $comment = ''; //$sql ="INSERT INTO ip_routes (ir_user_id,ir_ip,ir_port_from,ir_name) "; //$sql.="VALUES ('".$IP->user_id()."',".$IP->db()->quote($ip).",".$IP->db()->quote($port).",".$IP->db()->quote($dat).");"; //$q=$IP->db()->query($sql) or die(print_r($IP->db()->errorInfo(), true) . "<hr />$sql"); $IP->routeCreate($name, $ip, $port_fr, $port_to, $comment); echo "document.location.href='?';"; //brutal! exit; case 'getRoute': //print_r($_POST); $id = $_POST['id'] * 1; $sql = "SELECT * FROM ip_routes WHERE ir_id={$id};"; $q = $IP->db()->query($sql) or die("Error {$sql}"); $r = $q->fetch(PDO::FETCH_ASSOC); //print_r($r); echo "\$('#ir_id').val({$id});\n"; echo "\$('#ir_ip').val('" . $r['ir_ip'] . "');\n"; echo "\$('#ir_port_from').val('" . $r['ir_port_from'] . "');\n"; echo "\$('#ir_port_to').val('" . $r['ir_port_to'] . "');\n"; echo "\$('#ir_name').val('" . $r['ir_name'] . "');\n";