"active", 'datatype' => "VARCHAR", 'formtype' => "SELECT", 'op' => "=", 'prefix' => "", 'suffix' => "", 'width' => "", 'value' => array('y' => "
Yes
", 'n' => "
No
")); $liste['item'][] = array( 'field' => 'server_id', 'datatype' => 'INTEGER', 'formtype' => 'SELECT', 'op' => '=', 'prefix' => '', 'suffix' => '', 'datasource' => array ( 'type' => 'SQL', 'querystring' => 'SELECT server_id,server_name FROM server WHERE {AUTHSQL} ORDER BY server_name', 'keyfield'=> 'server_id', 'valuefield'=> 'server_name' ), 'width' => '', 'value' => ''); $liste['item'][] = array( 'field' => 'source_ip', 'datatype' => 'VARCHAR', 'op' => '=', 'prefix' => '', 'suffix' => '', 'datasource' => array ( 'type' => 'SQL', 'querystring' => 'SELECT server_ip_map_id,source_ip FROM server_ip_map WHERE {AUTHSQL}', 'keyfield'=> 'server_ip_map_id', 'valuefield'=> 'source_ip' ), 'width' => '', 'value' => ''); $liste['item'][] = array( 'field' => 'destination_ip', 'datatype' => 'VARCHAR', 'op' => '=', 'prefix' => '', 'suffix' => '', 'datasource' => array ( 'type' => 'SQL', 'querystring' => 'SELECT server_ip_map_id,destination_ip FROM server_ip_map WHERE {AUTHSQL}', 'keyfield'=> 'server_ip_map_id', 'valuefield'=> 'destination_ip' ), 'width' => '', 'value' => ''); ?>