$arr_new_user = array(); $arr_comp_diff = array_diff($arr_compid_final, $arr_comp_toregister); foreach ($arr_comp_diff as $key => $val) { $var_username = ""; $var_userlogin = ""; getUserLogin($var_frommailbox, $val, $var_username, $var_userlogin); $var_userpassword = $var_userpassword != "" ? $var_userpassword : getUserPassword($var_fromaddress); $sql = "Insert into sptbl_users(nUserId,nCompId,vUserName,vEmail,vLogin,vPassword,dDate,nCSSId)\n\t\t\t\tValues('',\n\t\t\t\t'" . addslashes($val) . "',\n\t\t\t\t'" . addslashes($var_username) . "',\n\t\t\t\t'" . addslashes($var_fromaddress) . "',\n\t\t\t\t'" . addslashes($var_userlogin) . "',\n\t\t\t\t'" . md5($var_userpassword) . "',\n\t\t\t\tnow(),'1')"; executeQuery($sql, $conn); $var_id = mysql_insert_id(); $arr_comp_toregister[$var_id] = $val; $arr_user_login[$var_id] = $var_username; $arr_new_user[$var_id] = $var_userpassword; } foreach ($arr_new as $key => $val) { $var_tmp_compid = getCompanyId($val, $total_count); $var_tmp_userid = array_search($var_tmp_compid, $arr_comp_toregister); $var_userlogin = $arr_user_login[$var_tmp_userid]; $sql = "insert into sptbl_tickets(nTicketId,nDeptId,vRefNo,nUserId,vUserName,vTitle,tQuestion,\n\t\t\tvPriority,dPostDate,vMachineIP,dLastAttempted)\n\t\t\t\tvalues('','" . $val . "','1','" . $var_tmp_userid . "',\n\t\t\t\t'" . addslashes($var_userlogin) . "',\n\t\t\t\t'" . addslashes($mimedecoder->_mailheader->_headersubject) . "',\n\t\t\t\t'" . addslashes($var_message_main) . "','0',now(),\n\t\t\t\t'" . addslashes($var_machineip) . "',now())"; executeQuery($sql, $conn); $var_insert_id = mysql_insert_id($conn); $var_ticket_id = $var_insert_id; //update reference number // modified on 15-11-06 by roshith for constant length ref.no. // 'zero' added for 2 digit companyid if ($var_tmp_compid < 10) { $var_tmp_compid = "0" . $var_tmp_compid; } // 'zero' added for 2 digit departmentid $val_dept_id = $val; if ($val_dept_id < 10) {
function updatePosting($user) { $title = $_POST["title"]; $url = urldecode($_POST["url"]); $companyName = $_POST["company"]; $locationName = $_POST["location"]; # string value needs to be converted to int $source = $_POST["source"]; $id = $_POST["sid"]; // if location doesn't exist in locations table yet, add it if (locationExists($locationName) != true) { addLocation($locationName); } $locationId = getLocationId($locationName); // if location doesn't exist yet for user, add it if (companyIdExists($companyName) != true) { addCompany($companyName); } $companyId = getCompanyId($companyName); $query = "update postings "; $query .= "set title=\"{$title}\", "; $query .= "source=\"{$source}\", "; $query .= "location={$locationId}, "; $query .= "company={$companyId}, "; $query .= "url=\"{$url}\" "; $query .= "where id = {$id} "; //echo $query; if (booleanReturn($query)) { echo json_encode(true); } else { echo "failed to add posting"; } }