\n"; // echo "
".getClientNameByCode($_REQUEST['cCode']).": Network

\n"; debug(2); if (array_key_exists("form_submitted", $_REQUEST)) { // save data now. $q = "cCode='".limitInputHTML($_REQUEST['cCode'], 16)."',"; $q .= "jobRef='',"; $q .= "modem_mfg='".limitInputHTML($_REQUEST['modem_mfg'], 64)."',"; $q .= "modem_mo='".limitInputHTML($_REQUEST['modem_mo'], 64)."',"; // $q .= "modem_sn='".limitInputHTML($_REQUEST['modem_sn'], 128)."',"; $q .= "router_mfg='".limitInputHTML($_REQUEST['router_mfg'], 64)."',"; $q .= "router_mo='".limitInputHTML($_REQUEST['router_mo'], 64)."',"; // $q .= "router_sn='".limitInputHTML($_REQUEST['router_sn'], 128)."',"; $q .= "ssid='".limitInputHTML($_REQUEST['ssid'], 64)."',"; $q .= "wl_key='".limitInputHTML($_REQUEST['wl_key'], 64)."', "; $q .= "wan_ip='".limitInputHTML($_REQUEST['wan_ip'], 16)."',"; $q .= "lan_gateway='".limitInputHTML($_REQUEST['lan_gateway'], 16)."',"; $q .= "router_user='".limitInputHTML($_REQUEST['router_user'], 32)."',"; $q .= "router_pass='".limitInputHTML($_REQUEST['router_pass'], 32)."',"; $q .= "dvr_email='".limitInputHTML($_REQUEST['dvr_email'], 128)."',"; $q .= "ddns_url='".limitInputHTML($_REQUEST['ddns_url'], 128)."',"; $q .= "ddns_provider='".limitInputHTML($_REQUEST['ddns_provider'], 64)."',"; $q .= "ddns_user='".limitInputHTML($_REQUEST['ddns_user'], 128)."',"; $q .= "ddns_pass='".limitInputHTML($_REQUEST['ddns_pass'], 32)."'"; if (empty($_REQUEST['network_tid'])) // if REQUEST[tid] is empty, this is a new entry { $r = sqlInsert("networking", $q); } else // the record already exists, so this is an edit { $r = sqlUpdate("networking", $q, "tid='{$_REQUEST['network_tid']}'"); } //update networkdevice set cCode='99300003W',device_name='AppleTV MBR',device_mfg='Apple',device_model='AppleTV',device_sn='',device_ip='',device_ip_type='',device_user='',device_pass='',device_ruser='',device_rpass='',device_mac='1C:1A:C0:AD:07:BC',device_port='', device_connectivity='Airplay disabled' where tid='2015013003508UX' if (!empty($_REQUEST['device_name']) or !empty($_REQUEST['device_id'])) { echo "\n"; $q = "cCode='".limitInputHTML($_REQUEST['cCode'], 16)."',"; $q .= "device_name='".limitInputHTML($_REQUEST['device_name'], 32)."',"; $q .= "device_mfg='".limitInputHTML($_REQUEST['device_mfg'], 64)."',"; $q .= "device_model='".limitInputHTML($_REQUEST['device_model'], 32)."',"; $q .= "device_sn='".limitInputHTML($_REQUEST['device_sn'], 64)."',"; $q .= "device_ip='".limitInputHTML($_REQUEST['device_ip'], 16)."',"; $q .= "device_ip_type='".limitInputHTML($_REQUEST['device_ip_type'], 16)."',"; $q .= "device_user='".limitInputHTML($_REQUEST['device_user'], 32)."',"; $q .= "device_pass='".limitInputHTML($_REQUEST['device_pass'], 32)."',"; $q .= "device_ruser='".limitInputHTML($_REQUEST['device_ruser'], 32)."',"; $q .= "device_rpass='".limitInputHTML($_REQUEST['device_rpass'], 32)."',"; $q .= "device_mac='".limitInputHTML($_REQUEST['device_mac'], 24)."',"; $q .= "device_port='".limitInputHTML($_REQUEST['device_port'], 32)."', "; $q .= "device_connectivity='".limitInputHTML($_REQUEST['device_connectivity'], 128)."', "; $q .= "integrate='{$_REQUEST['integrate']}', "; $q .= "device_notes='".limitInputHTML( $_REQUEST['device_notes'], 255)."'"; // echo "\n"; if (empty($_REQUEST['device_id'])) // if REQUEST[device_id] is empty, this is a new entry { // echo "\n"; $r = sqlRecycle("networkdevice", $q, "device_name = ''"); $_REQUEST['device_id'] = $r['t']; } else // the record already exists, so this is an edit { // echo "\n"; $r = sqlUpdate("networkdevice", $q, "tid='{$_REQUEST['device_id']}'"); } } if (!empty($_REQUEST['equip_name']) or !empty($_REQUEST['equipment_id'])) { $q = "cCode='".limitInputHTML( $_REQUEST['cCode'], 16)."', "; $q .= "equip_name='".limitInputHTML( $_REQUEST['equip_name'], 64)."', "; $q .= "equip_mfg='".limitInputHTML( $_REQUEST['equip_mfg'], 64)."', "; $q .= "equip_mo='".limitInputHTML( $_REQUEST['equip_mo'], 64)."', "; $q .= "equip_sn='".limitInputHTML( $_REQUEST['equip_sn'], 128)."', "; $q .= "equip_remote='".limitInputHTML( $_REQUEST['equip_remote'], 64)."', "; $q .= "equip_ctl_type='".limitInputHTML( $_REQUEST['equip_ctl_type'], 16)."', "; $q .= "equip_ctl_port='".limitInputHTML( $_REQUEST['equip_ctl_port'], 16)."', "; $q .= "equip_code_set='".limitInputHTML( $_REQUEST['equip_code_set'], 64)."', "; $q .= "equip_connection='".limitInputHTML( $_REQUEST['equip_connection'], 128)."', "; $q .= "equip_integrate='{$_REQUEST['equip_integrate']}', "; $q .= "equip_notes='".limitInputHTML( $_REQUEST['equip_notes'], 255)."'"; // echo "\n"; // echo "\n"; if (empty($_REQUEST['equipment_id'])) // if REQUEST[equipment_id] is empty, this is a new entry { // echo "\n"; $r = sqlRecycle("equipment", $q, "name = ''"); $_REQUEST['equipment_id'] = $r['t']; } else // the record already exists, so this is an edit { // echo "\n"; $r = sqlUpdate("equipment", $q, "tid='{$_REQUEST['equipment_id']}'"); } } } // get any data already on file $q = "cCode=\"{$_REQUEST['cCode']}\""; $networkDat = sqlSelect("networking", $q); if ($networkDat['n']) $networkDat = mysql_fetch_assoc($networkDat['r']); else { $networkDat = array(); $deviceDat = array(); } $deviceList = sqlEx("select * from networkdevice where cCode='{$_REQUEST['cCode']}' and device_name != '' order by device_name"); $deviceCnt = mysql_num_rows($deviceList); if ($deviceCnt == 0) $deviceDat = array(); echo "
\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; if (empty($noClose)) echo " \n"; // echo "
".getClientNameByCode($_REQUEST['cCode']).": Network

\n"; echo "
\n"; echo " \n"; echo " \n"; echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; //=========================== Devices =========================== switch ( $deviceCnt ) { case 0: $caption = "No Entries"; break; case 1: $caption = "1 Item"; break; default: $caption = "$deviceCnt items"; break; } echo " \n"; echo " \n"; echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; // ============================== Un-Networked Equipment ============================== $q = "select * from equipment where cCode='{$_REQUEST['cCode']}' and equip_name != '' order by equip_name,equip_mfg,equip_mo,equip_sn"; $equipmentList = sqlEx($q); $equipmentCount = mysql_num_rows($equipmentList); switch ( $equipmentCount ) { case 0: $caption = "No Entries"; break; case 1: $caption = "1 Item"; break; default: $caption = "$equipmentCount items"; break; } echo " \n"; echo " \n"; echo " \n"; // echo " \n"; // echo " \n"; // echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; // ==================================================================================== echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
".getClientNameByCode($_REQUEST['cCode']).": Network
 
Modem MFGModem Mo
Modem S/N
Router MFGRouter Mo
Router S/N
SSIDWL Key
WAN IPLAN Gateway
Router UsernameRouter Password
eMail
DDNS URLProvider
DDNS UsernameDDNS Password
 
Networked Equpment ( $caption )
 
Device\n"; if ( $deviceCnt == 0 ) { echo "First Device"; } else { $itemCnt = 0; echo "\n"; } echo " Name
MFGModel
S/N  Include in Integration
LAN IPIP Type\n"; echo " \n"; echo "
UsernamePassword
Remote UsernameRemote Password
Device Port(s)Device MAC
Connectivity
Notes
 
Un-Networked Equpment ( $caption )
 
Item\n"; if ( $equipmentCount == 0 ) { echo "First Item"; } else { $itemCnt = 0; echo "\n"; } echo " Name
MFGModel
S/NRemote
CodeSet  Include in Integration
Ctl TypeCtl Port
Connectivity
Notes


"; // echo ""; echo "
\n"; echo "
\n"; ?>