function bs_FilePush($filename, $rawdata) { $filename = vf($filename); $rawdata = mysql_real_escape_string($rawdata); $query = "INSERT INTO `bankstaraw` (\n `id` ,\n `filename` ,\n `rawdata`\n )\n VALUES (\n NULL , '" . $filename . "', '" . $rawdata . "'\n );\n "; nr_query($query); $lastid = simple_get_lastid('bankstaraw'); return $lastid; }
/** * Creates new tag type in database * * @return void */ function stg_add_tagtype() { $color = mysql_real_escape_string($_POST['newcolor']); $size = vf($_POST['newpriority'], 3); $text = mysql_real_escape_string($_POST['newtext']); $query = "INSERT INTO `tagtypes` (`id` ,`tagcolor` ,`tagsize` ,`tagname`) VALUES (NULL , '" . $color . "', '" . $size . "', '" . $text . "');"; nr_query($query); $newId = simple_get_lastid('tagtypes'); log_register('TAGTYPE ADD `' . $text . '` [' . $newId . ']'); }
public function create($public, $type, $title, $text) { $public = vf($public, 3); $type = vf($type); $title = mysql_real_escape_string($title); $text = mysql_real_escape_string($text); $query = "INSERT INTO `zbsannouncements` (`id`,`public`,`type`,`title`,`text`) VALUES\n (NULL, '" . $public . "', '" . $type . "', '" . $title . "', '" . $text . "'); "; nr_query($query); $newId = simple_get_lastid('zbsannouncements'); log_register("ANNOUNCEMENT CREATE [" . $newId . "]"); return $newId; }
function ms_MassSendMessage($users_arr, $message) { global $alter_conf; if (!empty($users_arr)) { foreach ($users_arr as $eachuser) { if (!$alter_conf['MASSSEND_SAFE']) { ms_SendMessage($eachuser, $message); } else { ms_TicketCreate('NULL', $eachuser, $message, 'NULL', whoami()); $newid = simple_get_lastid('ticketing'); ms_TicketSetDone($newid); } } log_register("MASSEND (" . sizeof($users_arr) . ")"); } }
$altCfg = $ubillingConfig->getAlter(); //if someone creates new task if (isset($_POST['createtask'])) { if (wf_CheckPost(array('newstartdate', 'newtaskaddress', 'newtaskphone'))) { if (wf_CheckPost(array('typicalnote'))) { $newjobnote = $_POST['typicalnote'] . ' ' . $_POST['newjobnote']; } else { $newjobnote = $_POST['newjobnote']; } //date validyty check if (zb_checkDate($_POST['newstartdate'])) { ts_CreateTask($_POST['newstartdate'], @$_POST['newstarttime'], $_POST['newtaskaddress'], @$_POST['newtasklogin'], $_POST['newtaskphone'], $_POST['newtaskjobtype'], $_POST['newtaskemployee'], $newjobnote); if (!isset($_GET['gotolastid'])) { rcms_redirect("?module=taskman"); } else { $lasttaskid = simple_get_lastid('taskman'); rcms_redirect("?module=taskman&edittask=" . $lasttaskid); } } else { show_error(__('Wrong date format')); } } else { show_error(__('All fields marked with an asterisk are mandatory')); } } //modify task sub if (isset($_POST['modifytask'])) { if (wf_CheckPost(array('modifystartdate', 'modifytaskaddress', 'modifytaskphone'))) { if (zb_checkDate($_POST['modifystartdate'])) { $taskid = $_POST['modifytask']; ts_ModifyTask($taskid, $_POST['modifystartdate'], $_POST['modifystarttime'], $_POST['modifytaskaddress'], @$_POST['modifytasklogin'], $_POST['modifytaskphone'], $_POST['modifytaskjobtype'], $_POST['modifytaskemployee'], $_POST['modifytaskjobnote']);
/** * Creates new address pool in database * * @param ... * * * @return void */ public function poolCreate($netid, $pool, $netmask, $vlan) { $netid = vf($netid, 3); $pool = mysql_real_escape_string($pool); $netmask = vf($netmask); $vlan = vf($vlan, 3); $query = "INSERT INTO `netextpools` (`id`, `netid`, `pool`, `netmask`, `gw`, `clientip`, `broadcast`, `vlan`, `login`) " . "VALUES (NULL, '" . $netid . "', '" . $pool . "', '" . $netmask . "', NULL, NULL, NULL, '" . $vlan . "', NULL);"; nr_query($query); $newPoolId = simple_get_lastid('netextpools'); log_register("POOL CREATE [" . $newPoolId . "] `" . $pool . "/" . $netmask . "`"); $newGw = int2ip(ip2int($pool) + 1); $newBroadcast = int2ip(ip2int($pool) + ($this->cidrOffsets[$netmask] - 1)); simple_update_field('netextpools', 'gw', $newGw, "WHERE `id`='" . $newPoolId . "';"); simple_update_field('netextpools', 'broadcast', $newBroadcast, "WHERE `id`='" . $newPoolId . "';"); //creating ips list for pool $newIpsStart = int2ip(ip2int($newGw) + 1); $newIpsEnd = int2ip(ip2int($newBroadcast) - 1); $this->ipsCreate($newPoolId, $newIpsStart, $newIpsEnd); }
/** * Creates new ONU in database and returns it Id or 0 if action fails * * @param int $onumodelid * @param int $oltid * @param string $ip * @param string $mac * @param string $serial * @param string $login * * @return int */ public function onuCreate($onumodelid, $oltid, $ip, $mac, $serial, $login) { $mac = strtolower($mac); $mac = trim($mac); $onumodelid = vf($onumodelid, 3); $oltid = vf($oltid, 3); $ip = mysql_real_escape_string($ip); $macRaw = $mac; $mac = mysql_real_escape_string($mac); $serial = mysql_real_escape_string($serial); $login = mysql_real_escape_string($login); $login = trim($login); $result = 0; if (!empty($mac)) { if (check_mac_format($mac)) { if ($this->checkMacUnique($mac)) { $query = "INSERT INTO `pononu` (`id`, `onumodelid`, `oltid`, `ip`, `mac`, `serial`, `login`) " . "VALUES (NULL, '" . $onumodelid . "', '" . $oltid . "', '" . $ip . "', '" . $mac . "', '" . $serial . "', '" . $login . "');"; nr_query($query); $result = simple_get_lastid('pononu'); log_register('PON CREATE ONU [' . $result . '] MAC `' . $macRaw . '`'); } else { log_register('PON MACDUPLICATE TRY `' . $macRaw . '`'); } } else { log_register('PON MACINVALID TRY `' . $macRaw . '`'); } } return $result; }
/** * Creates new outcoming operation record in database * * @param string $date * @param string $desttype * @param string $destparam * @param int $storageid * @param int $itemtypeid * @param float $count * @param float $price * @param string $notes * * @return string not emplty if something went wrong */ public function outcomingCreate($date, $desttype, $destparam, $storageid, $itemtypeid, $count, $price = '', $notes = '') { $result = ''; $date = mysql_real_escape_string($date); $desttype = mysql_real_escape_string($desttype); $destparam = mysql_real_escape_string($destparam); $storageid = vf($storageid, 3); $itemtypeid = vf($itemtypeid, 3); $countF = mysql_real_escape_string($count); $countF = str_replace('-', '', $countF); $countF = str_replace(',', '.', $countF); $priceF = mysql_real_escape_string($price); $priceF = str_replace(',', '.', $priceF); $notes = mysql_real_escape_string($notes); if (isset($this->allStorages[$storageid])) { if (isset($this->allItemTypes[$itemtypeid])) { $allItemRemains = $this->remainsOnStorage($storageid); @($itemRemains = $allItemRemains[$itemtypeid]); $itemsReserved = $this->reserveGet($storageid, $itemtypeid); $realRemains = $itemRemains - $itemsReserved; if ($countF <= $realRemains) { $query = "INSERT INTO `wh_out` (`id`,`date`,`desttype`,`destparam`,`storageid`,`itemtypeid`,`count`,`price`,`notes`) VALUES " . "(NULL,'" . $date . "','" . $desttype . "','" . $destparam . "','" . $storageid . "','" . $itemtypeid . "','" . $countF . "','" . $priceF . "','" . $notes . "')"; nr_query($query); $newId = simple_get_lastid('wh_out'); log_register('WAREHOUSE OUTCOME CREATE [' . $newId . '] ITEM [' . $itemtypeid . '] COUNT `' . $count . '` PRICE `' . $price . '`'); if ($desttype == 'storage') { $this->incomingCreate($date, $itemtypeid, 0, $destparam, $count, $price, '', __('from') . ' ' . __('Warehouse storage') . ' `' . $this->allStorages[$storageid] . '`'); } } else { $result = $this->messages->getStyledMessage(__('The balance of goods and materials in stock is less than the amount') . ' (' . $countF . ' > ' . $itemRemains . '-' . $itemsReserved . ')', 'error'); } } else { $result = $this->messages->getStyledMessage(__('Strange exeption') . ' EX_WRONG_ITEMTYPE_ID', 'error'); } } else { $result = $this->messages->getStyledMessage(__('Strange exeption') . ' EX_WRONG_STORAGE_ID', 'error'); } return $result; }
private function logResult() { $resultStatus = $this->getResult('result'); $resultStatusCode = $this->getResult('resultCode'); $resultComment = $this->getResult('resultComment'); switch ($resultStatusCode) { case 1: $resultComment = 'запрос обработан успешно'; break; case 0: $resultComment = 'запрос обрабатывается'; break; case -1: $resultComment = 'неверный алгоритм ЭП'; break; case -2: $resultComment = 'неверный формат ЭП'; break; case -3: $resultComment = 'недействительный сертификат ЭП'; break; case -4: $resultComment = 'некорректное значение ЭП'; break; case -5: $resultComment = 'ошибка проверки сертификата ЭП'; break; case -6: $resultComment = 'у заявителя отсутствует лицензия'; break; case -7: $resultComment = 'отсутствует идентификатор запроса'; break; case -8: $resultComment = 'неверный формат ID запроса'; break; case -9: $resultComment = 'не найден запрос по указанному ID'; break; case -10: $resultComment = 'повторите запрос позднее'; break; } $query = "\r\n INSERT INTO `rbs_results` (`requestID`, `resultStatus`, `resultStatusCode`, `resultComment`, `resultTime`)\r\n VALUES('{$this->_requestPK}', '{$resultStatus}', '{$resultStatusCode}', '{$resultComment}', NOW())\r\n ON DUPLICATE KEY UPDATE `resultStatus` = '{$resultStatus}', `resultStatusCode` = '{$resultStatusCode}', `resultComment` = '{$resultComment}', `resultTime` = NOW()\r\n "; nr_query($query); return simple_get_lastid('rbs_results'); }
<td>' . __('Text') . '</td> </tr> '; if (!empty($allmessages)) { foreach ($allmessages as $io => $eachmessage) { $result .= ' <tr class="row3"> <td>' . $eachmessage['date'] . '</td> <td>' . $eachmessage['text'] . '</td> </tr> '; } } $result .= '</table>'; show_window(__('Previous messages'), $result); } if (isset($_GET['username'])) { $login = $_GET['username']; web_MessagesShowPrevious($login); if (isset($_POST['messagetext'])) { zb_TicketCreate('NULL', $login, $_POST['messagetext'], 'NULL', whoami()); $newid = simple_get_lastid('ticketing'); zb_TicketSetDone($newid); rcms_redirect("?module=pl_sendmessage&username=" . $login); } web_MessageSendForm(); show_window('', web_UserControls($login)); } } else { show_error(__('You cant control this module')); }
/** * Creates new tariff in database * * @return void/string on error */ public function tariffCreate() { $result = ''; if (wf_CheckPost(array('newtariffname', 'newtarifffee', 'newtariffserviceid'))) { $nameF = mysql_real_escape_string($_POST['newtariffname']); $feeF = mysql_real_escape_string($_POST['newtarifffee']); $serviceidF = mysql_real_escape_string($_POST['newtariffserviceid']); $primary = wf_CheckPost(array('newtariffprimary')) ? 1 : 0; $freePeriod = wf_CheckPost(array('newtarifffreeperiod')) ? 1 : 0; if (zb_checkMoney($feeF)) { $query = "INSERT INTO `mg_tariffs` (`id`,`name`,`fee`,`serviceid`,`primary`,`freeperiod`) VALUES "; $query .= "(NULL,'" . $nameF . "','" . $feeF . "','" . $serviceidF . "','" . $primary . "','" . $freePeriod . "')"; nr_query($query); $newId = simple_get_lastid('mg_tariffs'); log_register('MEGOGO TARIFF CREATE [' . $newId . '] `' . $_POST['newtariffname'] . '` FEE `' . $_POST['newtarifffee'] . '`'); } else { $result = $this->messages->getStyledMessage(__('Wrong format of a sum of money to pay'), 'error'); } } else { $result = $this->messages->getStyledMessage(__('No all of required fields is filled'), 'error'); } return $result; }
/** * Creates new personal note in database * * @return void */ public function addMyNote() { if (wf_CheckPost(array('newtext'))) { $owner = $this->myLogin; $createDate = curdatetime(); $remindDate = !empty($_POST['newreminddate']) ? $_POST['newreminddate'] : ''; $activity = isset($_POST['newactive']) ? 1 : 0; $text = $_POST['newtext']; $this->createNote($owner, $createDate, $remindDate, $activity, $text); $newId = simple_get_lastid('stickynotes'); log_register("STICKY CREATE [" . $newId . "]"); } }
/** * Creates new DB contact record * * @param string $phone * @param string $name * * @return void */ public function createContact($phone, $name) { $phoneF = mysql_real_escape_string($phone); $nameF = mysql_real_escape_string($name); $query = "INSERT INTO `contacts` (`id`,`phone`,`name`) VALUES (NULL, '" . $phoneF . "','" . $nameF . "');"; nr_query($query); $newId = simple_get_lastid('contacts'); log_register('PHONEBOOK CREATE [' . $newId . '] NAME `' . $name . '` PHONE `' . $phone . '`'); }
/** * Creates new DHCP network * * @param int $netid * @param string $dhcpconfname * * @return void */ public function createNetwork($netid, $dhcpconfname) { $netid = vf($netid, 3); $dhcpconfname = vf($dhcpconfname); $dhcpconfname = trim($dhcpconfname); $query = "INSERT INTO `dhcp` (`id` ,`netid` , `dhcpconfig` , `confname`)\n VALUES (NULL , '" . $netid . "', '', '" . $dhcpconfname . "');"; nr_query($query); $newID = simple_get_lastid('dhcp'); log_register('CREATE DHCPNet [' . $newID . '] NETWORK [' . $netid . ']'); }
/** * creates new capability in database * * @param $address - users address * @param $phone - users phone * @param $notes - text notes to task * * @return integer */ public function addCapability($address, $phone, $notes) { $date = curdatetime(); $address = mysql_real_escape_string($address); $phone = mysql_real_escape_string($phone); $notes = mysql_real_escape_string($notes); $query = "INSERT INTO `capab` (`id` , `date` , `address` , `phone` ,`stateid` ,`notes` ,`price` ,`employeeid` ,`donedate`) \n VALUES ( NULL , '" . $date . "', '" . $address . "', '" . $phone . "', '0', '" . $notes . "', NULL , NULL , NULL);"; nr_query($query); $lastId = simple_get_lastid('capab'); log_register("CAPABILITY ADD [" . $lastId . "] `" . $address . "`"); }
catv_TariffModify($_POST['edittariffid'], $_POST['edittariffname'], $_POST['edittariffprice'], @$_POST['edittariffchans']); rcms_redirect("?module=catv&action=tariffs"); } if (isset($_GET['action'])) { //show available tariffs and add form if ($_GET['action'] == 'tariffs') { catv_TariffShowAll(); catv_TariffAddForm(); } //show user registration form if ($_GET['action'] == 'userreg') { //if someone register user $needtoregisteruser = array('realyregister'); if (wf_CheckPost($needtoregisteruser)) { catv_UserRegister($_POST['newusercontract'], $_POST['newuserrealname'], $_POST['newuserstreet'], $_POST['newuserbuild'], $_POST['newuserapt'], $_POST['newuserphone'], $_POST['newusertariff'], $_POST['newusercash'], $_POST['newuserdecoder']); $newuserid = simple_get_lastid('catv_users'); rcms_redirect("?module=catv_profile&userid=" . $newuserid); } catv_UserRegisterForm(); } //show user list if ($_GET['action'] == 'showusers') { if ($alter_conf['CATV_HP_MODE']) { if (isset($_GET['ajax'])) { catv_AjaxOnlineDataSource(); } catv_UsersShowList_hp(); } else { catv_UsersShowList(); } }
/** * Creates new map item in database * * @param int $mapid * @param string $type * @param string $geo * @param string $name * @param string $location */ public function itemCreate($mapid, $type, $geo, $name, $location) { $mapid = vf($mapid, 3); $type = mysql_real_escape_string($type); $geo = mysql_real_escape_string($geo); $nameFiltered = mysql_real_escape_string($name); $location = mysql_real_escape_string($location); if (isset($this->allMaps[$mapid])) { $query = "INSERT INTO `custmapsitems` (`id`, `mapid`, `type`, `geo`, `name`, `location`) " . "VALUES (NULL, '" . $mapid . "', '" . $type . "', '" . $geo . "', '" . $nameFiltered . "', '" . $location . "');"; nr_query($query); $newId = simple_get_lastid('custmapsitems'); log_register('CUSTMAPS CREATE ITEM `' . $name . '` ID [' . $newId . ']'); } else { throw new Exception(self::EX_NO_MAP_ID); } }
function docsis_ModemAdd($maclan) { $maclan = mysql_real_escape_string($maclan); //random mac for usb $macusb = '14:' . '88' . ':' . rand(10, 99) . ':' . rand(10, 99) . ':' . rand(10, 99) . ':' . rand(10, 99); $altercfg = rcms_parse_ini_file(CONFIG_PATH . '/alter.ini'); $netid = $altercfg['DOCSIS_MODEM_NETID']; $nextfreeip = multinet_get_next_freeip('nethosts', 'ip', $netid); $note = ''; $userbind = ''; $basetemplate = 'short'; $date = curdate(); //check for free ip in subnet if (!empty($nextfreeip)) { $nic = str_replace('.', 'x', $nextfreeip); //check is mac unique? if (multinet_mac_free($maclan) and check_mac_format($maclan)) { $query = "INSERT INTO `modems` (\n `id` ,\n `maclan` ,\n `macusb` ,\n `date` ,\n `ip` ,\n `conftemplate` ,\n `userbind` ,\n `nic` ,\n `note`\n )\n VALUES (\n NULL , '" . $maclan . "', '" . $maclan . "', '" . $date . "', '" . $nextfreeip . "', '" . $basetemplate . "', '' , '" . $nic . "', ''\n );"; nr_query($query); $lastid = simple_get_lastid('modems'); log_register("DOCSIS MODEM ADD MAC" . $maclan . " IP " . $nextfreeip . "[" . $lastid . "]"); multinet_add_host($netid, $nextfreeip, $maclan, ''); multinet_rebuild_all_handlers(); rcms_redirect("?module=docsis&showmodem=" . $lastid); } else { show_window(__('Error'), __('This MAC is currently used') . ' ' . __('This MAC have wrong format')); } } else { show_window(__('Error'), __('No free IP available in selected pool')); } }
/** * registers new users into database and returns new user ID * * @return int */ public function userCreate() { $curdate = date("Y-m-d H:i:s"); $query = "\n INSERT INTO `ukv_users` (\n `id` ,\n `contract` ,\n `tariffid` ,\n `cash` ,\n `active` ,\n `realname` ,\n `passnum` ,\n `passwho` ,\n `passdate` ,\n `paddr`,\n `ssn` ,\n `phone` ,\n `mobile` ,\n `regdate` ,\n `city` ,\n `street` ,\n `build` ,\n `apt` ,\n `inetlogin` ,\n `notes`\n )\n VALUES (\n NULL ,\n NULL ,\n NULL ,\n '" . self::REG_CASH . "',\n '" . self::REG_ACT . "',\n NULL ,\n NULL ,\n NULL ,\n NULL ,\n NULL ,\n NULL ,\n NULL ,\n NULL ,\n '" . $curdate . "',\n NULL ,\n NULL ,\n NULL ,\n NULL ,\n NULL ,\n NULL\n ); "; nr_query($query); $newUserId = simple_get_lastid('ukv_users'); $result = $newUserId; log_register("UKV REGISTER USER ((" . $newUserId . "))"); //saving post registration data $this->userPostRegSave($newUserId); return $result; }
/** * Creates new switch device in database * * @param int $modelid * @param string $ip * @param string $desc * @param string $location * @param string $snmp * @param string $geo * @param int $parentid */ function ub_SwitchAdd($modelid, $ip, $desc, $location, $snmp, $geo, $parentid = '') { $modelid = vf($modelid, 3); $ip = mysql_real_escape_string($ip); $desc = mysql_real_escape_string($desc); $location = mysql_real_escape_string($location); $snmp = mysql_real_escape_string($snmp); $parentid = vf($parentid, 3); if (!empty($parentid)) { $parentid = "'" . $parentid . "'"; } else { $parentid = 'NULL'; } $query = "INSERT INTO `switches` (`id` ,`modelid` ,`ip` ,`desc` ,`location` ,`snmp`,`geo`,`parentid`) " . "VALUES ('', '" . $modelid . "', '" . $ip . "', '" . $desc . "', '" . $location . "', '" . $snmp . "','" . $geo . "', " . $parentid . " );"; nr_query($query); $lastid = simple_get_lastid('switches'); log_register('SWITCH ADD [' . $lastid . '] IP `' . $ip . '` ON LOC `' . $location . '`'); show_window(__('Add switch'), __('Was added new switch') . ' ' . $ip . ' ' . $location); }
/** * creates new contact person in database * * @return void */ public function personCreate() { if (wf_CheckPost(array('addpersoncorpid', 'addpersonrealname'))) { $corpid = vf($_POST['addpersoncorpid']); $realname = mysql_real_escape_string($_POST['addpersonrealname']); $phone = mysql_real_escape_string($_POST['addpersonphone']); $im = mysql_real_escape_string($_POST['addpersonim']); $email = mysql_real_escape_string($_POST['addpersonemail']); $appointment = mysql_real_escape_string($_POST['addpersonappointment']); if (isset($this->corps[$corpid])) { $query = "INSERT INTO `corp_persons` (`id`, `corpid`, `realname`, `phone`, `im`, `email`, `appointment`) VALUES (NULL, '" . $corpid . "', '" . $realname . "', '" . $phone . "', '" . $im . "', '" . $email . "', '" . $appointment . "');"; nr_query($query); $newId = simple_get_lastid('corp_persons'); log_register("CORPS CREATE PERSON [" . $newId . "] FOR CORP [" . $corpid . "]"); } } }
/** * Write to DB sheduled task and log that * * @param string $date * @param string $login * @param string $action * @param string $param * @param string $note */ function createTask($date, $login, $action, $param, $note) { $dateF = mysql_real_escape_string($date); $loginF = mysql_real_escape_string($login); $actionF = mysql_real_escape_string($action); $paramF = mysql_real_escape_string($param); $noteF = mysql_real_escape_string($note); $query = "INSERT INTO `dealwithit` (`id`,`date`,`login`,`action`,`param`,`note`) VALUES"; $query .= "(NULL,'" . $dateF . "','" . $loginF . "','" . $actionF . "','" . $paramF . "','" . $noteF . "');"; nr_query($query); $newId = simple_get_lastid('dealwithit'); log_register('SCHEDULER CREATE ID [' . $newId . '] (' . $login . ') DATE `' . $date . ' `ACTION `' . $action . '` NOTE `' . $note . '`'); }
/** * Creates new salary job for some task * * @param int $taskid * @param int $employeeid * @param int $jobtypeid * @param float $factor * @param float $overprice * @param string $notes * * @return void */ public function createSalaryJob($taskid, $employeeid, $jobtypeid, $factor, $overprice, $notes) { $taskid = vf($taskid, 3); $employeeid = vf($employeeid, 3); $jobtypeid = vf($jobtypeid, 3); $factor = str_replace(',', '.', $factor); $overprice = str_replace(',', '.', $overprice); $notes = mysql_real_escape_string($notes); $overprice = mysql_real_escape_string($overprice); $date = curdatetime(); $state = 0; $query = "INSERT INTO `salary_jobs` (`id`, `date`, `state` ,`taskid`, `employeeid`, `jobtypeid`, `factor`, `overprice`, `note`)" . " VALUES (NULL, '" . $date . "', '" . $state . "' ,'" . $taskid . "', '" . $employeeid . "', '" . $jobtypeid . "', '" . $factor . "', '" . $overprice . "', '" . $notes . "');"; nr_query($query); $newId = simple_get_lastid('salary_jobs'); log_register('SALARY CREATE JOB [' . $newId . '] TASK [' . $taskid . '] EMPLOYEE [' . $employeeid . '] JOBTYPE [' . $jobtypeid . '] FACTOR `' . $factor . '` OVERPRICE `' . $overprice . '`'); }