| commit | author | age | ||
| 6de0aa | 1 | <?php |
| F | 2 | /* |
| 3 | Datatypes: | |
| 4 | - INTEGER | |
| 5 | - DOUBLE | |
| 6 | - CURRENCY | |
| 7 | - VARCHAR | |
| 8 | - TEXT | |
| 9 | - DATE | |
| 10 | */ | |
| 11 | ||
| 12 | //* Name of list | |
| b1a6a5 | 13 | $liste['name'] = 'server_php'; |
| 6de0aa | 14 | |
| F | 15 | //* Database table |
| b1a6a5 | 16 | $liste['table'] = 'server_php'; |
| 6de0aa | 17 | |
| F | 18 | //* Primary index column |
| b1a6a5 | 19 | $liste['table_idx'] = 'server_php_id'; |
| 6de0aa | 20 | |
| F | 21 | //* Search Field Prefix |
| b1a6a5 | 22 | $liste['search_prefix'] = 'search_'; |
| 6de0aa | 23 | |
| F | 24 | //* Records per page |
| b1a6a5 | 25 | $liste['records_per_page'] = "15"; |
| 6de0aa | 26 | |
| F | 27 | //* Script file for listing |
| b1a6a5 | 28 | $liste['file'] = 'server_php_list.php'; |
| 6de0aa | 29 | |
| F | 30 | //* Script file to edit |
| b1a6a5 | 31 | $liste['edit_file'] = 'server_php_edit.php'; |
| 6de0aa | 32 | |
| F | 33 | //* Script file to delete |
| b1a6a5 | 34 | $liste['delete_file'] = 'server_php_del.php'; |
| 6de0aa | 35 | |
| F | 36 | //* Paging template |
| b1a6a5 | 37 | $liste['paging_tpl'] = 'templates/paging.tpl.htm'; |
| 6de0aa | 38 | |
| F | 39 | //* Enable auth |
| b1a6a5 | 40 | $liste['auth'] = 'no'; |
| 6de0aa | 41 | |
| F | 42 | |
| 43 | /***************************************************** | |
| 44 | * Suchfelder | |
| 45 | *****************************************************/ | |
| 46 | ||
| b1a6a5 | 47 | $liste['item'][] = array( 'field' => 'server_id', |
| 2df826 | 48 | 'datatype' => 'INTEGER', |
| b1a6a5 | 49 | 'formtype' => 'SELECT', |
| 2df826 | 50 | 'op' => '=', |
| MC | 51 | 'prefix' => '', |
| 52 | 'suffix' => '', | |
| b1a6a5 | 53 | 'datasource' => array ( 'type' => 'SQL', |
| aff9ac | 54 | 'querystring' => 'SELECT server_id,server_name FROM server WHERE {AUTHSQL} AND mirror_server_id = 0 ORDER BY server_name', |
| b1a6a5 | 55 | 'keyfield'=> 'server_id', |
| MC | 56 | 'valuefield'=> 'server_name' |
| 57 | ), | |
| 58 | 'width' => '', | |
| 59 | 'value' => ''); | |
| 6de0aa | 60 | |
| b1a6a5 | 61 | $liste['item'][] = array( 'field' => 'client_id', |
| 2df826 | 62 | 'datatype' => 'INTEGER', |
| b1a6a5 | 63 | 'formtype' => 'SELECT', |
| 2df826 | 64 | 'op' => '=', |
| MC | 65 | 'prefix' => '', |
| 66 | 'suffix' => '', | |
| b1a6a5 | 67 | 'datasource' => array ( 'type' => 'SQL', |
| MC | 68 | 'querystring' => 'SELECT client_id,contact_name FROM client WHERE {AUTHSQL} ORDER BY contact_name', |
| 69 | 'keyfield'=> 'client_id', | |
| 70 | 'valuefield'=> 'contact_name' | |
| 71 | ), | |
| 72 | 'width' => '', | |
| 73 | 'value' => ''); | |
| 6de0aa | 74 | |
| b1a6a5 | 75 | $liste['item'][] = array( 'field' => 'name', |
| MC | 76 | 'datatype' => 'VARCHAR', |
| 77 | 'op' => 'like', | |
| 78 | 'prefix' => '%', | |
| 79 | 'suffix' => '%', | |
| 80 | 'width' => ''); | |
| 6de0aa | 81 | |
| b1a6a5 | 82 | ?> |
