/** * Updates existing DB entry for some login * * @param string $login * @param string $seal * @param string $length * @param string $price * * @return void */ protected function update($login, $seal, $length, $price) { $login = mysql_real_escape_string($login); simple_update_field('condet', 'seal', $seal, "WHERE `login`='" . $login . "';"); simple_update_field('condet', 'length', $length, "WHERE `login`='" . $login . "';"); simple_update_field('condet', 'price', $price, "WHERE `login`='" . $login . "';"); }
public function save() { $value = serialize($_POST[self::FORM_NAME]); $value = base64_encode($value); simple_update_field('nas', 'options', $value, "WHERE `id` = '" . $this->_id . "'"); // Re-new options current values: $this->options = zb_NasOptionsGet($this->_id); // Return return true; }
public function save($id) { $id = vf($id, 3); if (isset($this->data[$id])) { simple_update_field('zbsannouncements', 'public', $_POST['editpublic'], "WHERE `id`='" . $id . "'"); simple_update_field('zbsannouncements', 'type', $_POST['edittype'], "WHERE `id`='" . $id . "'"); simple_update_field('zbsannouncements', 'title', $_POST['edittitle'], "WHERE `id`='" . $id . "'"); simple_update_field('zbsannouncements', 'text', $_POST['edittext'], "WHERE `id`='" . $id . "'"); log_register("ANNOUNCEMENT EDIT [" . $id . "]"); } else { throw new Exception(self::EX_ID_NO_EXIST); } }
} else { //printable result if (wf_CheckPost(array('printdatefrom', 'printdateto'))) { ts_PrintTasks($_POST['printdatefrom'], $_POST['printdateto']); } //show printing form show_window(__('Tasks printing'), ts_PrintDialogue()); } } else { //sms post sending if (wf_CheckPost(array('postsendemployee', 'postsendsmstext'))) { $smsDataRaw = ts_SendSMS($_POST['postsendemployee'], $_POST['postsendsmstext']); if (!empty($smsDataRaw)) { $smsDataSave = serialize($smsDataRaw); $smsDataSave = "'" . base64_encode($smsDataSave) . "'"; simple_update_field('taskman', 'smsdata', $smsDataSave, "WHERE `id`='" . $_GET['edittask'] . "'"); //flushing dark void $darkVoid = new DarkVoid(); $darkVoid->flushCache(); rcms_redirect('?module=taskman&edittask=' . $_GET['edittask']); } } //sms data flush if (wf_CheckGet(array('flushsmsdata'))) { ts_FlushSMSData($_GET['flushsmsdata']); rcms_redirect('?module=taskman&edittask=' . $_GET['flushsmsdata']); } /** * Salary accounting actions */ if ($altCfg['SALARY_ENABLED']) {
/** * Marks ticket as unreviewed in database * * @param int $ticketid * * @return void */ function zb_TicketSetUnDone($ticketid) { $ticketid = vf($ticketid, 3); simple_update_field('ticketing', 'status', '0', "WHERE `id`='" . $ticketid . "'"); log_register("TICKET OPEN [" . $ticketid . "]"); }
/** * Marks signup request as undone in database * * @param int $reqid Existing request ID * * @return void */ public function setUnDone($reqid) { $requid = vf($reqid, 3); simple_update_field('sigreq', 'state', '0', "WHERE `id`='" . $reqid . "'"); log_register('SIGREQ UNDONE [' . $reqid . ']'); }
if (!zb_AddressBuildProtected($_GET['buildid'])) { zb_AddressDeleteBuild($_GET['buildid']); rcms_redirect("?module=builds&action=edit&streetid=" . $streetid); } else { show_window('', wf_Link("?module=builds&action=edit&streetid=" . $streetid, 'Back', false, 'ubButton')); show_error(__('You can not delete a building if there are users of the apartment')); } } if ($_GET['action'] == 'editbuild') { $buildid = vf($_GET['buildid']); $streetid = vf($_GET['streetid']); //build edit subroutine if (isset($_POST['editbuildnum'])) { if (!empty($_POST['editbuildnum'])) { simple_update_field('build', 'buildnum', $_POST['editbuildnum'], "WHERE `id`='" . $buildid . "'"); simple_update_field('build', 'geo', $_POST['editbuildgeo'], "WHERE `id`='" . $buildid . "'"); } log_register("CHANGE AddressBuild [" . $buildid . "] " . mysql_real_escape_string($_POST['editbuildnum'])); rcms_redirect("?module=builds&action=edit&streetid=" . $streetid); } //construct edit form $builddata = zb_AddressGetBuildData($buildid); $streetname = zb_AddressGetStreetData($streetid); $streetname = $streetname['streetname']; $editinputs = $streetname . " " . $builddata['buildnum'] . wf_tag('hr'); $editinputs .= wf_TextInput('editbuildnum', 'Building number', $builddata['buildnum'], true, '10'); $editinputs .= wf_TextInput('editbuildgeo', 'Geo location', $builddata['geo'], true, '20'); $editinputs .= wf_Submit('Save'); $editform = wf_Form('', 'POST', $editinputs, 'glamour'); show_window(__('Edit') . ' ' . __('Build'), $editform); show_window('', wf_Link("?module=builds&action=edit&streetid=" . $streetid, 'Back', true, 'ubButton'));
/** * Performs switch replacement in database * * @param int $fromId * @param int $toId * @param int $employeeid * * @return void */ function zb_SwitchReplace($fromId, $toId, $employeeId) { $fromId = vf($fromId, 3); $toId = vf($toId, 3); $employeeId = vf($employeeId, 3); $allEmployees = ts_GetAllEmployee(); $fromData = zb_SwitchGetData($fromId); $toData = zb_SwitchGetData($toId); if (!empty($fromData)) { //copy geo coordinates to new switch simple_update_field('switches', 'geo', $fromData['geo'], "WHERE `id`='" . $toId . "'"); //setting new description and remove NP flag $newDescriptionTo = str_replace('NP', 'm:' . @$allEmployees[$employeeId], $toData['desc']); simple_update_field('switches', 'desc', $newDescriptionTo, "WHERE `id`='" . $toId . "'"); //copy location simple_update_field('switches', 'location', $fromData['location'], "WHERE `id`='" . $toId . "'"); //copy switch parent ID if (!empty($fromData['parentid'])) { simple_update_field('switches', 'parentid', $fromData['parentid'], "WHERE `id`='" . $toId . "'"); } else { $parentId_q = "UPDATE `switches` SET `parentid`=NULL WHERE `id`='" . $toId . "';"; nr_query($parentId_q); } //moving childs if it present simple_update_field('switches', 'parentid', $toId, "WHERE `parentid`='" . $fromId . "'"); // doing old switch cleanup and disabling it simple_update_field('switches', 'geo', '', "WHERE `id`='" . $fromId . "'"); $newFromLocation = __('removed from') . ': ' . $fromData['location']; simple_update_field('switches', 'location', $newFromLocation, "WHERE `id`='" . $fromId . "'"); $newFromDesc = 'NP u:' . @$allEmployees[$employeeId]; simple_update_field('switches', 'desc', $newFromDesc, "WHERE `id`='" . $fromId . "'"); $parentIdFrom_q = "UPDATE `switches` SET `parentid`=NULL WHERE `id`='" . $fromId . "';"; nr_query($parentIdFrom_q); log_register("SWITCH REPLACE FROM [" . $fromId . "] TO [" . $toId . "] EMPLOYEE [" . $employeeId . "]"); } else { show_error(__('Strange exeption') . ': FROM_SWITCH_EMPTY_DATA'); } }
/** * Saves timesheet editing results into database * * @return void */ public function timesheetSaveChanges() { if (wf_CheckPost(array('edittimesheetid'))) { $id = vf($_POST['edittimesheetid'], 3); if (isset($this->allTimesheets[$id])) { $timesheetData = $this->allTimesheets[$id]; $timesheetDate = $timesheetData['date']; $employee = $timesheetData['employeeid']; $hours = vf($_POST['editemployeehours'], 3); $hospitalFlag = wf_CheckPost(array('edithospital')) ? 1 : 0; $holidayFlag = wf_CheckPost(array('editholiday')) ? 1 : 0; $where = " WHERE `id`='" . $id . "';"; if ($timesheetData['hours'] != $hours) { simple_update_field('salary_timesheets', 'hours', $hours, $where); } if ($timesheetData['holiday'] != $holidayFlag) { simple_update_field('salary_timesheets', 'holiday', $holidayFlag, $where); } if ($timesheetData['hospital'] != $hospitalFlag) { simple_update_field('salary_timesheets', 'hospital', $hospitalFlag, $where); } log_register('SALARY EDIT TIMESHEET [' . $id . '] `' . $timesheetDate . '` EMPLOYEE [' . $employee . '] HOURS `' . $hours . '` HOSPITAL `' . $hospitalFlag . '` HOLIDAY `' . $holidayFlag . '`'); } else { log_register('SALARY EDIT FAIL TIMESHEET [' . $id . '] NOT_EXISTING_ID'); } } }
public function changeTask() { $taskID = vf($_GET['edit'], 3); if (wf_CheckPost(array('editname', 'editaction', 'editparam'))) { if (!empty($taskID)) { if (isset($_POST['editactive'])) { $actFlag = 1; } else { $actFlag = 0; } simple_update_field('watchdog', 'name', $_POST['editname'], "WHERE `id`='" . $taskID . "'"); simple_update_field('watchdog', 'checktype', $_POST['editchecktype'], "WHERE `id`='" . $taskID . "'"); simple_update_field('watchdog', 'param', $_POST['editparam'], "WHERE `id`='" . $taskID . "'"); simple_update_field('watchdog', 'operator', $_POST['editoperator'], "WHERE `id`='" . $taskID . "'"); simple_update_field('watchdog', 'condition', $_POST['editcondition'], "WHERE `id`='" . $taskID . "'"); simple_update_field('watchdog', 'action', $_POST['editaction'], "WHERE `id`='" . $taskID . "'"); simple_update_field('watchdog', 'active', $actFlag, "WHERE `id`='" . $taskID . "'"); log_register("WATCHDOG CHANGE TASK [" . $taskID . "] `" . $_POST['editname'] . "`"); } else { throw new Exception(self::TASKID_EX); } } else { throw new Exception(self::TASKADD_EX); } }
if (wf_CheckPost(array('newmaclan'))) { docsis_ModemAdd($_POST['newmaclan']); } //deleting modem if (wf_CheckGet(array('deletemodem'))) { docsis_ModemDelete($_GET['deletemodem']); rcms_redirect("?module=docsis"); } //editing modem if (isset($_POST['edituserbind']) and isset($_POST['editnote'])) { $editmodemid = vf($_GET['showmodem'], 3); if (!empty($editmodemid)) { $newmodemuserbind = mysql_real_escape_string($_POST['edituserbind']); $newmodemnote = mysql_real_escape_string($_POST['editnote']); simple_update_field('modems', 'userbind', $newmodemuserbind, "WHERE `id`='" . $editmodemid . "'"); simple_update_field('modems', 'note', $newmodemnote, "WHERE `id`='" . $editmodemid . "'"); log_register("DOCSIS MODEM EDIT BIND `" . $newmodemuserbind . "` [" . $editmodemid . "]"); rcms_redirect("?module=docsis&showmodem=" . $editmodemid); } else { show_window(__('Error'), __('Strange exeption')); } } //setting modem snmp community if (wf_CheckPost(array('newmodemcommunity', 'newsnmpwalkpath'))) { docsis_ModemSnmpSet($_POST['newmodemcommunity']); docsis_ModemSnmpWalkSet($_POST['newsnmpwalkpath']); rcms_redirect("?module=docsis"); } //show controls docsis_ControlsShow(); //show modems list by default
/** * changes pool login * * @param int $poolid Existing poolID * @param string $login Existin ubilling user login * * @return void */ public function poolLinkLogin($poolid, $login) { $poolid = vf($poolid, 3); $login = trim($login); if (isset($this->pools[$poolid])) { simple_update_field('netextpools', 'login', $login, "WHERE `id`='" . $poolid . "'"); log_register("POOL LINK USER `" . $login . "`"); } else { throw new Exception(self::EX_NOEXPOOL); } }
<?php if (cfr('SWITCHMAP')) { $altercfg = $ubillingConfig->getAlter(); if ($altercfg['SWYMAP_ENABLED']) { //wysiwyg switch placement if (wf_CheckPost(array('switchplacing', 'placecoords'))) { if (cfr('SWITCHESEDIT')) { $switchid = vf($_POST['switchplacing'], 3); $placegeo = mysql_real_escape_string($_POST['placecoords']); simple_update_field('switches', 'geo', $placegeo, "WHERE `id`='" . $switchid . "'"); log_register('SWITCH CHANGE [' . $switchid . ']' . ' GEO ' . $placegeo); rcms_redirect("?module=switchmap&locfinder=true"); } else { show_error(__('Access denied')); } } $ymconf = $ubillingConfig->getYmaps(); $ym_center = $ymconf['CENTER']; $ym_zoom = $ymconf['ZOOM']; $ym_type = $ymconf['TYPE']; $ym_lang = $ymconf['LANG']; $area = ''; //show map container sm_ShowMapContainer(); //collect switches geolocation data if (!wf_CheckGet(array('coverage'))) { $placemarks = sm_MapDrawSwitches(); //uplinks display mode if (wf_CheckGet(array('showuplinks')) and !wf_CheckGet(array('traceid'))) { $placemarks .= sm_MapDrawSwitchUplinks();
function ms_TicketSetDone($ticketid) { $ticketid = vf($ticketid); simple_update_field('ticketing', 'status', '1', "WHERE `id`='" . $ticketid . "'"); }
/** * Assigns exinsting ONU with some login * * @param int $onuid * @param string $login * * @return void */ public function onuAssign($onuid, $login) { $onuid = vf($onuid, 3); if (isset($this->allOnu[$onuid])) { simple_update_field('pononu', 'login', $login, "WHERE `id`='" . $onuid . "'"); log_register('PON ASSIGN ONU [' . $onuid . '] WITH (' . $login . ')'); } else { log_register('PON ASSIGN ONU [' . $onuid . '] FAILED'); } }
} else { show_window(__('Error'), __('Required fields')); } } //if someone deleting tagtype if (isset($_GET['delete'])) { stg_delete_tagtype($_GET['delete']); rcms_redirect("?module=usertags"); } //if someone wants to edit tagtype if (isset($_GET['edit'])) { $tagtypeid = vf($_GET['edit'], 3); if (isset($_POST['edittagcolor'])) { simple_update_field('tagtypes', 'tagcolor', $_POST['edittagcolor'], "WHERE `id`='" . $tagtypeid . "'"); simple_update_field('tagtypes', 'tagsize', $_POST['edittagsize'], "WHERE `id`='" . $tagtypeid . "'"); simple_update_field('tagtypes', 'tagname', $_POST['edittagname'], "WHERE `id`='" . $tagtypeid . "'"); log_register("TAGTYPE CHANGE [" . $tagtypeid . ']'); rcms_redirect("?module=usertags"); } //form construct $tagpriorities = array('1' => '1', '2' => '2', '3' => '3', '4' => '4', '5' => '5', '6' => '6'); $tagtypedata = stg_get_tagtype_data($tagtypeid); $editinputs = wf_ColPicker('edittagcolor', __('Color'), $tagtypedata['tagcolor'], true, '20'); $editinputs .= wf_TextInput('edittagname', 'Text', $tagtypedata['tagname'], true, 20); $editinputs .= wf_Selector('edittagsize', $tagpriorities, 'Priority', $tagtypedata['tagsize'], true); $editinputs .= wf_Submit('Save'); $editform = wf_Form('', 'POST', $editinputs, 'glamour'); show_window(__('Edit'), $editform); show_window('', wf_Link("?module=usertags", 'Back', true, 'ubButton')); } //show available tagtypes
/** * Changes existing custom map name in database * * @paramint $id * @param string $name * @throws Exception */ public function mapEdit($id, $name) { $id = vf($id, 3); if (isset($this->allMaps[$id])) { simple_update_field('custmaps', 'name', $name, "WHERE `id`='" . $id . "'"); log_register('CUSTMAPS EDIT MAP [' . $id . '] SET `' . $name . '`'); } else { throw new Exception(self::EX_NO_MAP_ID); } }
function catvbs_LockRow($rowid) { $rowid = vf($rowid, 3); simple_update_field('catv_bankstaparsed', 'state', '1', "WHERE `id`='" . $rowid . "'"); log_register("CATV_BANKSTA LOCK ROW " . $rowid); }
$priority = $_POST['newpriority']; if (!empty($price)) { zb_VserviceCreate($tagid, $price, $cashtype, $priority); rcms_redirect("?module=vservices"); } else { show_error(__('No all of required fields is filled')); } } if (isset($_GET['delete'])) { $vservid = $_GET['delete']; zb_VsericeDelete($vservid); rcms_redirect("?module=vservices"); } if (wf_CheckGet(array('edit'))) { $editId = vf($_GET['edit'], 3); if (wf_CheckPost(array('edittagid', 'editcashtype', 'editpriority', 'editfee'))) { simple_update_field('vservices', 'tagid', $_POST['edittagid'], "WHERE `id`='" . $editId . "'"); simple_update_field('vservices', 'cashtype', $_POST['editcashtype'], "WHERE `id`='" . $editId . "'"); simple_update_field('vservices', 'priority', $_POST['editpriority'], "WHERE `id`='" . $editId . "'"); simple_update_field('vservices', 'price', $_POST['editfee'], "WHERE `id`='" . $editId . "'"); log_register("CHANGE VSERVICE [" . $editId . "] PRICE `" . $_POST['editfee'] . "`"); rcms_redirect("?module=vservices"); } show_window(__('Edit'), web_VserviceEditForm($_GET['edit'])); } else { //show available services list web_VservicesShow(); } } else { show_error(__('Access denied')); }
/** * updates existing license key */ public function updateKey($index, $key) { if ($this->checkLicenseValidity($key)) { simple_update_field('ubstorage', 'value', $key, "WHERE `key`='" . $index . "'"); log_register("AVARICE UPDATE KEY `" . $index . '`'); return true; } else { log_register("AVARICE TRY UPDATE WRONG KEY"); return false; } }
//if someone deleting type if (isset($_GET['delete'])) { cf_TypeDelete($_GET['delete']); rcms_redirect("?module=cftypes"); } //if someone adding field if (isset($_POST['newtype'])) { cf_TypeAdd($_POST['newtype'], $_POST['newname']); rcms_redirect("?module=cftypes"); } //if someone edits type if (isset($_POST['editname'])) { $typeid = vf($_POST['editid']); $typename = $_POST['editname']; $typetype = $_POST['edittype']; simple_update_field('cftypes', 'type', $typetype, 'WHERE `id` = "' . $typeid . '"'); simple_update_field('cftypes', 'name', $typename, 'WHERE `id` = "' . $typeid . '"'); log_register("CFTYPE CHANGE [" . $typeid . "] `" . $typename . "`"); rcms_redirect("?module=cftypes"); } if (!isset($_GET['edit'])) { show_window(__('Available custom profile field types'), cf_TypesShow()); show_window(__('Create new field type'), cf_TypeAddForm()); } else { //editing type $typeid = vf($_GET['edit']); cf_TypeEditForm($typeid); } } else { show_error(__('You cant control this module')); }
/** * Updates task params in database * * @param int $taskid * @param string $startdate * @param string $starttime * @param string $address * @param string $login * @param string $phone * @param int $jobtypeid * @param int $employeeid * @param string $jobnote * * @return void */ function ts_ModifyTask($taskid, $startdate, $starttime, $address, $login, $phone, $jobtypeid, $employeeid, $jobnote) { $taskid = vf($taskid, 3); $startdate = mysql_real_escape_string($startdate); if (!empty($starttime)) { $starttime = "'" . mysql_real_escape_string($starttime) . "'"; } else { $starttime = 'NULL'; } $address = str_replace('\'', '`', $address); $address = mysql_real_escape_string($address); $login = mysql_real_escape_string($login); $phone = mysql_real_escape_string($phone); $jobtypeid = vf($jobtypeid, 3); $employeeid = vf($employeeid, 3); simple_update_field('taskman', 'startdate', $startdate, "WHERE `id`='" . $taskid . "'"); nr_query("UPDATE `taskman` SET `starttime` = " . $starttime . " WHERE `id`='" . $taskid . "'"); //that shit for preventing quotes simple_update_field('taskman', 'address', $address, "WHERE `id`='" . $taskid . "'"); simple_update_field('taskman', 'login', $login, "WHERE `id`='" . $taskid . "'"); simple_update_field('taskman', 'phone', $phone, "WHERE `id`='" . $taskid . "'"); simple_update_field('taskman', 'jobtype', $jobtypeid, "WHERE `id`='" . $taskid . "'"); simple_update_field('taskman', 'employee', $employeeid, "WHERE `id`='" . $taskid . "'"); simple_update_field('taskman', 'jobnote', $jobnote, "WHERE `id`='" . $taskid . "'"); log_register("TASKMAN MODIFY [" . $taskid . "] `" . $address . '`'); }
} } else { //editing switch form $switchid = vf($_GET['edit'], 3); $switchdata = zb_SwitchGetData($switchid); //if someone edit switch if (wf_CheckPost(array('editmodel'))) { if (cfr('SWITCHESEDIT')) { simple_update_field('switches', 'modelid', $_POST['editmodel'], "WHERE `id`='" . $switchid . "'"); simple_update_field('switches', 'ip', $_POST['editip'], "WHERE `id`='" . $switchid . "'"); simple_update_field('switches', 'location', $_POST['editlocation'], "WHERE `id`='" . $switchid . "'"); simple_update_field('switches', 'desc', $_POST['editdesc'], "WHERE `id`='" . $switchid . "'"); simple_update_field('switches', 'snmp', $_POST['editsnmp'], "WHERE `id`='" . $switchid . "'"); simple_update_field('switches', 'geo', $_POST['editgeo'], "WHERE `id`='" . $switchid . "'"); if ($_POST['editparentid'] != $switchid) { simple_update_field('switches', 'parentid', $_POST['editparentid'], "WHERE `id`='" . $switchid . "'"); } log_register('SWITCH CHANGE [' . $switchid . ']' . ' IP ' . $_POST['editip'] . " LOC `" . $_POST['editlocation'] . "`"); rcms_redirect("?module=switches&edit=" . $switchid); } else { show_error(__('Access denied')); } } //render switch edit form show_window(__('Edit switch'), web_SwitchEditForm($switchid)); //minimap container if ($altCfg['SWYMAP_ENABLED']) { if (!empty($switchdata['geo'])) { show_window(__('Mini-map'), wf_delimiter() . web_SwitchMiniMap($switchdata)); } }
/** * cnahges banksta contract number for some existing row * * @param int $bankstaid existing bank statement transaction ID * @param string $contract new contract number for this row */ public function bankstaSetContract($bankstaid, $contract) { $bankstaid = vf($bankstaid, 3); $contract = mysql_real_escape_string($contract); $contract = trim($contract); if (empty($this->bankstarecords)) { $this->loadBankstaAll(); } if (isset($this->bankstarecords[$bankstaid])) { $oldContract = $this->bankstarecords[$bankstaid]['contract']; simple_update_field('ukv_banksta', 'contract', $contract, "WHERE `id`='" . $bankstaid . "';"); log_register('UKV BANKSTA [' . $bankstaid . '] CONTRACT `' . $oldContract . '` CHANGED ON `' . $contract . '`'); } else { log_register('UKV BANKSTA NONEXIST [' . $bankstaid . '] CONTRACT CHANGE TRY'); } }
/** * Changes comment text in database * * @param int $id existing comment database ID * @param string $text new text for comment */ protected function modifyComment($id, $text) { $id = vf($id, 3); $text = strip_tags($text); simple_update_field('adcomments', 'text', $text, "WHERE `id`='" . $id . "';"); log_register("ADCOMM CHANGE SCOPE `" . $this->scope . "` ITEM [" . $this->item . "]"); }
/** * Saves contractor changes in database by data recieved from form * * @return void */ public function contractorsSave() { if (wf_CheckPost(array('editcontractorname', 'editcontractorid'))) { $contractorId = vf($_POST['editcontractorid'], 3); if (isset($this->allContractors[$contractorId])) { simple_update_field('wh_contractors', 'name', $_POST['editcontractorname'], "WHERE `id`='" . $contractorId . "'"); log_register('WAREHOUSE CONTRACTORS EDIT [' . $contractorId . '] `' . $_POST['editcontractorname'] . '`'); } else { log_register('WAREHOUSE CONTRACTORS EDIT FAIL [' . $contractorId . '] NO_EXISTING'); } } }
} else { //show editing form $nasid = vf($_GET['edit']); //if someone editing nas if (wf_CheckPost(array('editnastype'))) { $targetnas = "WHERE `id` = '" . $nasid . "'"; $nastype = vf($_POST['editnastype']); $nasip = mysql_real_escape_string($_POST['editnasip']); $nasname = mysql_real_escape_string($_POST['editnasname']); $nasbwdurl = mysql_real_escape_string($_POST['editnasbwdurl']); $netid = vf($_POST['networkselect']); simple_update_field('nas', 'nastype', $nastype, $targetnas); simple_update_field('nas', 'nasip', $nasip, $targetnas); simple_update_field('nas', 'nasname', $nasname, $targetnas); simple_update_field('nas', 'bandw', $nasbwdurl, $targetnas); simple_update_field('nas', 'netid', $netid, $targetnas); zb_NasConfigSave(); log_register("NAS EDIT " . $nasip); rcms_redirect("?module=nas&edit=" . $nasid); } $nasdata = zb_NasGetData($nasid); $currentnetid = $nasdata['netid']; $currentnasip = $nasdata['nasip']; $currentnasname = $nasdata['nasname']; $currentnastype = $nasdata['nastype']; $currentbwdurl = $nasdata['bandw']; $nastypes = array('local' => 'Local NAS', 'rscriptd' => 'rscriptd', 'mikrotik' => 'MikroTik', 'radius' => 'Radius'); $editinputs = multinet_network_selector($currentnetid) . "<br>"; $editinputs .= wf_Selector('editnastype', $nastypes, 'NAS type', $currentnastype, true); $editinputs .= wf_TextInput('editnasip', 'IP', $currentnasip, true, '15'); $editinputs .= wf_TextInput('editnasname', 'NAS name', $currentnasname, true, '15');
function uhw_ChangeMac($nethost_id, $newmac) { $newmac = strtolower($newmac); simple_update_field('nethosts', 'mac', $newmac, "WHERE `id`='" . $nethost_id . "'"); }
/** * Updates line data in database * * @return boolean true */ public function line_edit_form_submit($id, $data) { $where = "WHERE `id` = '" . $id . "'"; foreach ($data as $column => $new_value) { simple_update_field(self::TABLE_LINES, $column, $new_value, $where); } return true; }
<?php if (cfr('USERSMAP')) { $altercfg = $ubillingConfig->getAlter(); if ($altercfg['SWYMAP_ENABLED']) { //wysiwyg build map placement if (wf_CheckPost(array('buildplacing', 'placecoords'))) { if (cfr('BUILDS')) { $buildid = vf($_POST['buildplacing'], 3); $placegeo = mysql_real_escape_string($_POST['placecoords']); simple_update_field('build', 'geo', $placegeo, "WHERE `id`='" . $buildid . "'"); log_register('BUILD CHANGE [' . $buildid . ']' . ' GEO `' . $placegeo . '`'); rcms_redirect("?module=usersmap&locfinder=true"); } else { show_window(__('Error'), __('Access denied')); } } $ymconf = $ubillingConfig->getYmaps(); $ym_center = $ymconf['CENTER']; $ym_zoom = $ymconf['ZOOM']; $ym_type = $ymconf['TYPE']; $ym_lang = $ymconf['LANG']; $area = ''; //show map container um_ShowMapContainer(); //collect biulds geolocation data $placemarks = um_MapDrawBuilds(); //setting custom zoom and map center if need to find some build if (wf_CheckGet(array('findbuild'))) { $ym_zoom = $ymconf['FINDING_ZOOM']; $ym_center = vf($_GET['findbuild']);