$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) {
Example #2
0
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";
    }
}