1 ) { $country = $countryelse; } $error_msg = ''; /* if(!$direct_signup ) { if (empty($_SESSION['session_captcha']) || trim(strtolower($_REQUEST['captcha'])) != $_SESSION['session_captcha']) { $error_msg .= "Image text dont match
"; $EINPUTRR = true; } } $_SESSION['session_captcha'] = ''; */ /* $captcha = ''; if(isset($_POST['g-recaptcha-response'])){ $captcha = $_POST['g-recaptcha-response']; } if(!$captcha){ $error_msg .= "An error occured. Please try again."; $EINPUTRR = true; } else { $secretKey = "6LdrA9wUAAAAAD-LxSK31s8pwdIztB8RWyyjJrok"; $ip = $_SERVER['REMOTE_ADDR']; // post request to server $url = 'https://www.google.com/recaptcha/api/siteverify?secret=' . urlencode($secretKey) . '&response=' . urlencode($captcha); $response = file_get_contents($url); $responseKeys = json_decode($response,true); // should return JSON with success as true if($responseKeys["success"]) { } else { $error_msg .= "An error occured. Please try again."; $EINPUTRR = true; } } */ if ( strlen($username) == 0 || strlen($company) == 0 || strlen($country) < 3 || strlen($email) == 0 ) { $error_msg .= "Required Field Missing
"; $EINPUTRR = true; } if ( $email != $confirmemail ) { echo "Emails don't Match
"; $EINPUTRR = true; } $mpSQL = "SELECT login_email FROM customer_sub_users WHERE lower(login_email) = lower('$email') "; $result = pg_query($db,$mpSQL); if(pg_num_rows($result)) { $error_msg .= "Email Already Registered. Please try with another Email ID
"; $EINPUTRR = true; } $sSQL = "SELECT email from customer WHERE lower(email) = lower('$email') "; $result = pg_query($db, $sSQL) or die(pg_last_error()); if(pg_num_rows($result)) { $error_msg .= "Email Already Registered. Please try with another Email ID
"; $EINPUTRR = true; } if (strtoupper($company) == 'GOOGLE') { echo "An error occured. Please try again
"; $EINPUTRR = true; } if ( $EINPUTRR ) { echo ""; } else { if ( $ZAAUID == 0 ) { /* $res = file_get_contents("http://api.ipinfodb.com/v3/ip-city/?key=3dc5167cd0b7acec90146ba40996f953042b231909095cd7c59fa506d267011c&ip=".$_SERVER['REMOTE_ADDR']); $res = explode(";" , $res ); $ip_country = $res[4]; */ $client_ip = getUserIP(); $res = getIPCountry($client_ip); $ip_country = strtoupper($res['country']); $rcoss = array(); if($partner_code) { $q = "SELECT affiliate_id FROM affiliate WHERE affiliate_code = '".$partner_code."'"; $r = pg_query($q) ; $line = pg_fetch_array($r, null, PGSQL_ASSOC); $rcoss['affiliate_id_fk'] = $line['affiliate_id']; } $sql = "SELECT * FROM stock_shipment_setup WHERE country = '$country' ORDER BY ass_date desc Limit 1 "; $result = pg_query($db, $sql); $line = pg_fetch_array($result, null, PGSQL_ASSOC); if($line['smoke_per_stk'] != -1) $rcoss['smoke_per_stk'] = (int)$line['smoke_per_stk']; if($line['stuffing_per_stk'] != -1) $rcoss['stuffing_per_stk'] = (int)$line['stuffing_per_stk']; if($line['thc_per_stk'] != -1) $rcoss['thc_per_stk'] = (int)$line['thc_per_stk']; if($line['blfee_per_stk'] != -1) $rcoss['blfee_per_stk'] = (int)$line['blfee_per_stk']; if($line['radiation_per_stk'] != -1) $rcoss['radiation_per_stk'] = (int)$line['radiation_per_stk']; if($line['spe_radiation_per_stk'] != -1) $rcoss['spe_radiation_per_stk'] = (int)$line['spe_radiation_per_stk']; if($line['inspection_per_stk'] != -1) $rcoss['inspection_per_stk'] = (int)$line['inspection_per_stk']; if($line['pekema_per_stk'] != -1) $rcoss['pekema_per_stk'] = (int)$line['pekema_per_stk']; if($line['jevicodo_per_stk'] != -1) $rcoss['jevicodo_per_stk'] = (int)$line['jevicodo_per_stk']; if($line['addinsp_per_stk'] != -1) $rcoss['addinsp_per_stk'] = (int)$line['addinsp_per_stk']; if($line['delartaion_per_stk'] != -1) $rcoss['delartaion_per_stk'] = (int)$line['delartaion_per_stk']; if($line['engineno_per_stk'] != -1) $rcoss['engineno_per_stk'] = (int)$line['engineno_per_stk']; if($line['smoke_per_stk_exempt'] != -1) $rcoss['smoke_per_stk_exempt'] = (int)$line['smoke_per_stk_exempt']; if($line['stuffing_per_stk_exempt'] != -1) $rcoss['stuffing_per_stk_exempt'] = (int)$line['stuffing_per_stk_exempt']; if($line['thc_per_stk_exempt'] != -1) $rcoss['thc_per_stk_exempt'] = (int)$line['thc_per_stk_exempt']; if($line['blfee_per_stk_exempt'] != -1) $rcoss['blfee_per_stk_exempt'] = (int)$line['blfee_per_stk_exempt']; if($line['radiation_per_stk_exempt'] != -1) $rcoss['radiation_per_stk_exempt'] = (int)$line['radiation_per_stk_exempt']; if($line['spe_radiation_per_stk_exempt'] != -1) $rcoss['spe_radiation_per_stk_exempt'] = (int)$line['spe_radiation_per_stk_exempt']; if($line['inspection_per_stk_exempt'] != -1) $rcoss['inspection_per_stk_exempt'] = (int)$line['inspection_per_stk_exempt']; if($line['pekema_per_stk_exempt'] != -1) $rcoss['pekema_per_stk_exempt'] = (int)$line['pekema_per_stk_exempt']; if($line['jevicodo_per_stk_exempt'] != -1) $rcoss['jevicodo_per_stk_exempt'] = (int)$line['jevicodo_per_stk_exempt']; if($line['addinsp_per_stk_exempt'] != -1) $rcoss['addinsp_per_stk_exempt'] = (int)$line['addinsp_per_stk_exempt']; if($line['delartaion_per_stk_exempt'] != -1) $rcoss['delartaion_per_stk_exempt'] = (int)$line['delartaion_per_stk_exempt']; if($line['engineno_per_stk_exempt'] != -1) $rcoss['engineno_per_stk_exempt'] = (int)$line['engineno_per_stk_exempt']; if($line['smoke_per_stk_min'] != -1) $rcoss['smoke_per_stk_min'] = (int)$line['smoke_per_stk_min']; if($line['stuffing_per_stk_min'] != -1) $rcoss['stuffing_per_stk_min'] = (int)$line['stuffing_per_stk_min']; if($line['thc_per_stk_min'] != -1) $rcoss['thc_per_stk_min'] = (int)$line['thc_per_stk_min']; if($line['blfee_per_stk_min'] != -1) $rcoss['blfee_per_stk_min'] = (int)$line['blfee_per_stk_min']; if($line['radiation_per_stk_min'] != -1) $rcoss['radiation_per_stk_min'] = (int)$line['radiation_per_stk_min']; if($line['spe_radiation_per_stk_min'] != -1) $rcoss['spe_radiation_per_stk_min'] = (int)$line['spe_radiation_per_stk_min']; if($line['inspection_per_stk_min'] != -1) $rcoss['inspection_per_stk_min'] = (int)$line['inspection_per_stk_min']; if($line['pekema_per_stk_min'] != -1) $rcoss['pekema_per_stk_min'] = (int)$line['pekema_per_stk_min']; if($line['jevicodo_per_stk_min'] != -1) $rcoss['jevicodo_per_stk_min'] = (int)$line['jevicodo_per_stk_min']; if($line['addinsp_per_stk_min'] != -1) $rcoss['addinsp_per_stk_min'] = (int)$line['addinsp_per_stk_min']; if($line['delartaion_per_stk_min'] != -1) $rcoss['delartaion_per_stk_min'] = (int)$line['delartaion_per_stk_min']; if($line['engineno_per_stk_min'] != -1) $rcoss['engineno_per_stk_min'] = (int)$line['engineno_per_stk_min']; if($line['smoke_per_stk_max'] != -1) $rcoss['smoke_per_stk_max'] = (int)$line['smoke_per_stk_max']; if($line['stuffing_per_stk_max'] != -1) $rcoss['stuffing_per_stk_max'] = (int)$line['stuffing_per_stk_max']; if($line['thc_per_stk_max'] != -1) $rcoss['thc_per_stk_max'] = (int)$line['thc_per_stk_max']; if($line['blfee_per_stk_max'] != -1) $rcoss['blfee_per_stk_max'] = (int)$line['blfee_per_stk_max']; if($line['radiation_per_stk_max'] != -1) $rcoss['radiation_per_stk_max'] = (int)$line['radiation_per_stk_max']; if($line['spe_radiation_per_stk_max'] != -1) $rcoss['spe_radiation_per_stk_max'] = (int)$line['spe_radiation_per_stk_max']; if($line['inspection_per_stk_max'] != -1) $rcoss['inspection_per_stk_max'] = (int)$line['inspection_per_stk_max']; if($line['pekema_per_stk_max'] != -1) $rcoss['pekema_per_stk_max'] = (int)$line['pekema_per_stk_max']; if($line['jevicodo_per_stk_max'] != -1) $rcoss['jevicodo_per_stk_max'] = (int)$line['jevicodo_per_stk_max']; if($line['addinsp_per_stk_max'] != -1) $rcoss['addinsp_per_stk_max'] = (int)$line['addinsp_per_stk_max']; if($line['delartaion_per_stk_max'] != -1) $rcoss['delartaion_per_stk_max'] = (int)$line['delartaion_per_stk_max']; if($line['engineno_per_stk_max'] != -1) $rcoss['engineno_per_stk_max'] = (int)$line['engineno_per_stk_max']; if($line['lc_amn_stk'] != -1) $rcoss['lc_amn_stk'] = (int)$line['lc_amn_stk']; if($line['misc_amn_stk'] != -1) $rcoss['misc_amn_stk'] = (int)$line['misc_amn_stk']; if($ship_grace_days_stk != -1) $acoss['ship_grace_days_stk'] = (int)$ship_grace_days_stk; if($penalty_per_day_stk != -1) $acoss['penalty_per_day_stk'] = (int)$penalty_per_day_stk; $rcoss['min_exempt'] = (int)$line['min_exempt']; $stk_liner = array(); $qliner = "SELECT DISTINCT liner , shipment_type , buy_country FROM stk_freight WHERE ship_port = '".$port."' AND ship_country = '".$country."' AND priority = '1' ORDER BY shipment_type Limit 1 "; $resultliner = pg_query($db, $qliner ) or die(pg_last_error()); while ( $rowliner = pg_fetch_array($resultliner, null, PGSQL_ASSOC)) { $stk_liner[$rowliner['buy_country']] = $rowliner['liner']; } $rcoss['stk_liner'] = json_encode($stk_liner); $sql = "SELECT * FROM countryport WHERE cpcountry = '$country' AND cpport = '$port' "; $result = pg_query($db, $sql) or die(pg_last_error()); $line = pg_fetch_array($result, null, PGSQL_ASSOC); $rcoss['priceup'] = intval($line[cppriceup]); $rcoss['priceuptype'] = intval($line[cppriceuptype]); $rcoss['priceup_slabs'] = $line[cppriceup_slabs]; $rcoss['agentdef'] = ($line[cpfreight]); $rcoss['cus_freight_type'] = ($line[cpfreighttype]); $rcoss['cus_ship_type'] = ($line[cpshiptype]); $rcoss['duedatetype'] = ($line[cpduedatetype]); $rcoss['duedays'] = ($line[cpduedays]); $rcoss['currenctystock'] = ($line[cpcurr]); if($line['cprealmileage'] == 'YES') { $rcoss['realmilage'] = 1; $rcoss['realmilage_place'] = $line['cprealmilage_place']; } if($line['cprealauctionpoints'] == 'YES') { $rcoss['realaucpoints'] = 1; $rcoss['realaucpoints_place'] = $line['cprealaucpoints_place']; } $sql2 = ""; if($country == 'UNITED ARAB EMIRATES') $sql2 = " OR upper(template_label) like upper('U.A.E%') "; $sSQLtemp = "SELECT * FROM auction_slabs_template WHERE plan_status = 1 AND default_plan = 1 AND (upper(template_label) like upper('".$country."%') ".$sql2." ) "; $resulttemp = pg_query($db,$sSQLtemp) or die(pg_last_error()); if(pg_num_rows($resulttemp) == 0 ) { $sSQLtemp = "SELECT * FROM auction_slabs_template WHERE plan_status = 1 AND default_plan = 1 AND upper(template_label) like upper('GLOBAL%') "; $resulttemp = pg_query($db,$sSQLtemp) or die(pg_last_error()); } $templine = pg_fetch_array($resulttemp, null, PGSQL_ASSOC); $auction_tempate_id = $templine['log_id']; /* unset($templine['log_id']); unset($templine['country']); unset($templine['remarks']); unset($templine['recording_aucvideo_days']); unset($templine['live_aucvideo_days']); unset($templine['print_remarks']); unset($templine['setting_date']); unset($templine['template_label']); unset($templine['apply_limit']); unset($templine['plan_status']); unset($templine['shipmentamount_auc_print']); unset($templine['documentrelease_auc_print']); unset($templine['dep_req_type']); unset($templine['dep_req_value']); unset($templine['default_plan']); unset($templine['sec_plan']); unset($templine['sec_plan_per_2']); */ $cus_columns = array(); $sSQL = "select column_name from information_schema.columns where table_name='customer' " ; $r = pg_query($sSQL) or die(pg_last_error()); while($row = pg_fetch_array($r, null, PGSQL_ASSOC)) { $cus_columns[] = $row['column_name']; } $rcoss['auction_tempate_id'] = $auction_tempate_id; $rcoss['template_type'] = 'Original'; foreach($templine as $k => $v) { if($v && in_array($k , $cus_columns)) { $rcoss[$k] = $v; } } $rcoss['comission1_1'] = (int)$rcoss['comission1_1']; $rcoss['username'] = strtoupper(htmlentities($username,ENT_QUOTES)); $rcoss['lastname'] = strtoupper(htmlentities($lastname,ENT_QUOTES)); $rcoss['company'] = strtoupper(htmlentities($company,ENT_QUOTES)); $rcoss['country'] = ($country); $rcoss['port'] = ($port); $rcoss['address'] = strtoupper(htmlentities($address,ENT_QUOTES)); $rcoss['streetno'] = strtoupper(htmlentities($streetno,ENT_QUOTES)); $rcoss['address_area'] = strtoupper(htmlentities($address_area,ENT_QUOTES)); $rcoss['city'] = strtoupper(htmlentities($city,ENT_QUOTES)); $rcoss['state'] = strtoupper(htmlentities($state,ENT_QUOTES)); $rcoss['postcode'] = strtoupper(htmlentities($postcode,ENT_QUOTES)); $rcoss['addresscountry'] = strtoupper(htmlentities($addresscountry,ENT_QUOTES)); $rcoss['tel'] = htmlentities($tel,ENT_QUOTES); $rcoss['tel2'] = htmlentities($tel2,ENT_QUOTES); $rcoss['fax'] = htmlentities($fax,ENT_QUOTES); $rcoss['hometel'] = htmlentities($hometel,ENT_QUOTES); $rcoss['mobile'] = htmlentities($mobile,ENT_QUOTES); $rcoss['mobile2'] = htmlentities($mobile2,ENT_QUOTES); $rcoss['whatsapp1'] = htmlentities($whatsapp1,ENT_QUOTES); $rcoss['whatsapp2'] = htmlentities($whatsapp2,ENT_QUOTES); $rcoss['email'] = htmlentities($email,ENT_QUOTES); $rcoss['skype'] = htmlentities($skype,ENT_QUOTES); $rcoss['website'] = htmlentities($website,ENT_QUOTES); $rcoss['wdt'] = strftime("%Y-%m-%d"); $rcoss['rank'] = 0; $rcoss['valid'] = 0; $password = sprintf("%x", time() ); if($ip_country != 'JAPAN') $rcoss['login_sent'] = 1; else $rcoss['login_sent'] = 0; $rcoss['login'] = $email; $rcoss['password'] = $password; $rcoss['inetaddress'] = $client_ip; $rcoss['inetcountry'] = strtoupper($ip_country); $rcoss['cancel1'] = AA_CANCEL1; $rcoss['cancel2'] = AA_CANCEL2; $rcoss['cancel3'] = AA_CANCEL3; $rcoss['cancel4'] = AA_CANCEL4; $rcoss['comission1'] = AA_COMISSION1; $rcoss['comission2'] = AA_COMISSION2; $rcoss['comission3'] = AA_COMISSION3; $rcoss['comission4'] = AA_COMISSION4; $rcoss['rank'] = 0; $rcoss['needinsurance'] = (int)$needinsurance; $rcoss['needbalance'] = 1; // $rcoss['agentdef'] = "NYK"; $rcoss['depopercar'] = 100000; $rcoss['auctionsw'] = 1; $rcoss['stockbuysw'] = 1; $rcoss['shipmentamount'] = 25; $rcoss['documentrelease'] = 100; $rcoss['needbalance'] = 1; $rcoss['stockmailsw'] = 1; $rcoss['pricenotshow'] = 1; $rcoss['disableinvoiceedit']= 1; $rcoss['orderablesw'] = 1; $rcoss['reserveablesw'] = 1; $rcoss['partssw'] = 1; $rcoss['view_auction_pics'] = 1; $rcoss['country_restrict'] = 1; $rcoss['currencyauction'] = 1; $rcoss['reques_url'] = $_SERVER[REQUEST_URI]; //if($free_auction_access) { $rcoss['free_auction_access'] = 1; $rcoss['unapproved_bidding'] = 1; $rcoss['bidding_wo_deposit'] = 25; $rcoss['view_limit_expiry'] = date("Y-m-d" , strtotime("+7 Days")); $rcoss['stk_free_access'] = 1; $rcoss['stk_bidding_wo_deposit'] = 25; $rcoss['stk_buy_expiry'] = date("Y-m-d" , strtotime("+7 Days")); if($country == 'PAKISTAN') { $rcoss['cnf_curr'] = 'PKR'; $rcoss['local_curr'] = 'PKR'; $rcoss['showroom_label'] = 'At Showroom'; } } if($country != 'MALAYSIA') { $rcoss['bank_charges_stk'] = 'CA'; } if($country == 'UNITED ARAB EMIRATES') { $rcoss['hide_highest_bid'] = '1'; } $res = pg_insert($db,'customer',$rcoss) or die("Insert 1"); $result = pg_query($db,"select max(userid) as maxid from customer"); if ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) { $CUSTOMERID = $line['maxid']; } pg_free_result($result); $rcoss2['userid'] = $CUSTOMERID; $rcoss2['auctionid'] = $zulfiqaraacookie; $rcoss2['useragent'] = $_SERVER['HTTP_USER_AGENT']; $rcoss2['acceptencoding'] = $_SERVER['HTTP_ACCEPT_ENCODING']; $rcoss2['connection'] = $_SERVER['HTTP_CONNECTION']; $rcoss2['isvalid'] = 1; $rcoss2['lastaccess'] = strftime("%Y-%m-%d %T"); $rcoss2['ipaddress'] = $client_ip; pg_insert($db,AA_USERCOOKIETABLE,$rcoss2) or die("Insert 2"); $rss = $cond = array(); $cond['userid'] = $CUSTOMERID; /* $q = "SELECT * FROM auction_slabs WHERE country = '".$country."'"; $r = pg_query($q); $line = pg_fetch_array($r, null, PGSQL_ASSOC); $default_set = $line['default_set']; $rss['cancel1'] = (int)str_replace(",","",$line[cancel1]); $rss['cancel2'] = (int)str_replace(",","",$line[cancel2]); $rss['cancel3'] = (int)str_replace(",","",$line[cancel3]); $rss['cancel4'] = (int)str_replace(",","",$line[cancel4]); $rss['cancel5'] = (int)str_replace(",","",$line[cancel5]); $rss['cancel6'] = (int)str_replace(",","",$line[cancel6]); $rss['cancel7'] = (int)str_replace(",","",$line[cancel7]); $rss['comissionfine1'] = (int)str_replace(",","",$line[comissionfine1]); $rss['comissionfine2'] = (int)str_replace(",","",$line[comissionfine2]); $rss['comissionfine3'] = (int)str_replace(",","",$line[comissionfine3]); $rss['comissionfine4'] = (int)str_replace(",","",$line[comissionfine4]); $rss['comissionfine5'] = (int)str_replace(",","",$line[comissionfine5]); $rss['comissionfine6'] = (int)str_replace(",","",$line[comissionfine6]); $rss['comissionfine7'] = (int)str_replace(",","",$line[comissionfine7]); $rss['comissionfine1week2'] = (int)str_replace(",","",$line[comissionfine1week2]); $rss['comissionfine2week2'] = (int)str_replace(",","",$line[comissionfine2week2]); $rss['comissionfine3week2'] = (int)str_replace(",","",$line[comissionfine3week2]); $rss['comissionfine4week2'] = (int)str_replace(",","",$line[comissionfine4week2]); $rss['comissionfine5week2'] = (int)str_replace(",","",$line[comissionfine5week2]); $rss['comissionfine6week2'] = (int)str_replace(",","",$line[comissionfine6week2]); $rss['comissionfine7week2'] = (int)str_replace(",","",$line[comissionfine7week2]); $rss['comissionfine1week3'] = (int)str_replace(",","",$line[comissionfine1week3]); $rss['comissionfine2week3'] = (int)str_replace(",","",$line[comissionfine2week3]); $rss['comissionfine3week3'] = (int)str_replace(",","",$line[comissionfine3week3]); $rss['comissionfine4week3'] = (int)str_replace(",","",$line[comissionfine4week3]); $rss['comissionfine5week3'] = (int)str_replace(",","",$line[comissionfine5week3]); $rss['comissionfine6week3'] = (int)str_replace(",","",$line[comissionfine6week3]); $rss['comissionfine7week3'] = (int)str_replace(",","",$line[comissionfine7week3]); $rss['comissionfine1week4'] = (int)str_replace(",","",$line[comissionfine1week4]); $rss['comissionfine2week4'] = (int)str_replace(",","",$line[comissionfine2week4]); $rss['comissionfine3week4'] = (int)str_replace(",","",$line[comissionfine3week4]); $rss['comissionfine4week4'] = (int)str_replace(",","",$line[comissionfine4week4]); $rss['comissionfine5week4'] = (int)str_replace(",","",$line[comissionfine5week4]); $rss['comissionfine6week4'] = (int)str_replace(",","",$line[comissionfine6week4]); $rss['comissionfine7week4'] = (int)str_replace(",","",$line[comissionfine7week4]); $rss['freestock1'] = (int)str_replace(",","",$line[freestock1]); $rss['freestock2'] = (int)str_replace(",","",$line[freestock2]); $rss['freestock3'] = (int)str_replace(",","",$line[freestock3]); $rss['freestock4'] = (int)str_replace(",","",$line[freestock4]); $rss['freestock5'] = (int)str_replace(",","",$line[freestock5]); $rss['freestock6'] = (int)str_replace(",","",$line[freestock6]); $rss['freestock7'] = (int)str_replace(",","",$line[freestock7]); $rss['freecomm1'] = (int)str_replace(",","",$line[freecomm1]); $rss['freecomm2'] = (int)str_replace(",","",$line[freecomm2]); $rss['freecomm3'] = (int)str_replace(",","",$line[freecomm3]); $rss['freecomm4'] = (int)str_replace(",","",$line[freecomm4]); $rss['freecomm5'] = (int)str_replace(",","",$line[freecomm5]); $rss['freecomm6'] = (int)str_replace(",","",$line[freecomm6]); $rss['freecomm7'] = (int)str_replace(",","",$line[freecomm7]); $rss['min_penalty'] = (int)str_replace(",","",$line[min_penalty]); $rss['depopercar'] = (int)str_replace(",","",$line[depopercar]); $rss['depopercarbuy'] = (int)str_replace(",","",$line[depopercarbuy]); $rss['maxbuyingbudget'] = (int)str_replace(",","",$line[maxbuyingbudget]); $rss['waiting_shipment_limit_au'] = (int)str_replace(",","",$line[waiting_shipment_limit_au]); $rss['shipped_limit_au'] = (int)str_replace(",","",$line[shipped_limit_au]); $rss['bl_released_limit_au'] = (int)str_replace(",","",$line[bl_released_limit_au]); $rss['shipping_delay_days'] = (int)str_replace(",","",$line[shipping_delay_days]); $rss['rank'] = (int)str_replace(",","",$line[rank]); $rss['comission1'] = (int)str_replace(",","",$line['comission1_'.$default_set]); $rss['comission2'] = (int)str_replace(",","",$line['comission2_'.$default_set]); $rss['comission3'] = (int)str_replace(",","",$line['comission3_'.$default_set]); $rss['comission4'] = (int)str_replace(",","",$line['comission4_'.$default_set]); $rss['comission5'] = (int)str_replace(",","",$line['comission5_'.$default_set]); $rss['comission6'] = (int)str_replace(",","",$line['comission6_'.$default_set]); $rss['comission7'] = (int)str_replace(",","",$line['comission7_'.$default_set]); $rss['comission1week2'] = (int)str_replace(",","",$line['comission1_'.$default_set.'week2']); $rss['comission2week2'] = (int)str_replace(",","",$line['comission2_'.$default_set.'week2']); $rss['comission3week2'] = (int)str_replace(",","",$line['comission3_'.$default_set.'week2']); $rss['comission4week2'] = (int)str_replace(",","",$line['comission4_'.$default_set.'week2']); $rss['comission5week2'] = (int)str_replace(",","",$line['comission5_'.$default_set.'week2']); $rss['comission6week2'] = (int)str_replace(",","",$line['comission6_'.$default_set.'week2']); $rss['comission7week2'] = (int)str_replace(",","",$line['comission7_'.$default_set.'week2']); $rss['comission1week3'] = (int)str_replace(",","",$line['comission1_'.$default_set.'week3']); $rss['comission2week3'] = (int)str_replace(",","",$line['comission2_'.$default_set.'week3']); $rss['comission3week3'] = (int)str_replace(",","",$line['comission3_'.$default_set.'week3']); $rss['comission4week3'] = (int)str_replace(",","",$line['comission4_'.$default_set.'week3']); $rss['comission5week3'] = (int)str_replace(",","",$line['comission5_'.$default_set.'week3']); $rss['comission6week3'] = (int)str_replace(",","",$line['comission6_'.$default_set.'week3']); $rss['comission7week3'] = (int)str_replace(",","",$line['comission7_'.$default_set.'week3']); $rss['comission1week4'] = (int)str_replace(",","",$line['comission1_'.$default_set.'week4']); $rss['comission2week4'] = (int)str_replace(",","",$line['comission2_'.$default_set.'week4']); $rss['comission3week4'] = (int)str_replace(",","",$line['comission3_'.$default_set.'week4']); $rss['comission4week4'] = (int)str_replace(",","",$line['comission4_'.$default_set.'week4']); $rss['comission5week4'] = (int)str_replace(",","",$line['comission5_'.$default_set.'week4']); $rss['comission6week4'] = (int)str_replace(",","",$line['comission6_'.$default_set.'week4']); $rss['comission7week4'] = (int)str_replace(",","",$line['comission7_'.$default_set.'week4']); $rss['week1ship'] = (int)str_replace(",","",$line['week1_'.$default_set.'ship']); $rss['week2ship'] = (int)str_replace(",","",$line['week2_'.$default_set.'ship']); $rss['week3ship'] = (int)str_replace(",","",$line['week3_'.$default_set.'ship']); $rss['week4ship'] = (int)str_replace(",","",$line['week4_'.$default_set.'ship']); $rss['stuffing_per_au'] = (int)$line['stuffing_per_au']; $rss['thc_per_au'] = (int)$line['thc_per_au']; $rss['blfee_per_au'] = (int)$line['blfee_per_au']; $rss['radiation_per_au'] = (int)$line['radiation_per_au']; $rss['ff_per_au'] = (int)$line['ff_per_au']; $rss['trans_exemption'] = (int)$line['trans_exemption']; */ $sSQL = "SELECT * FROM receivable_plans WHERE country = '".$country."' AND label like '%Basic%' AND buytype = 'JAPAN' "; $result = pg_query($db,$sSQL); if(pg_num_rows($result) == 0 ) { $sSQL = "SELECT * FROM receivable_plans WHERE country = 'Global' AND buytype = 'JAPAN' "; $result = pg_query($db,$sSQL); } $line = pg_fetch_array($result, null, PGSQL_ASSOC); $rss['buy_days'] = $line['buy_days']; $rss['buy_percent'] = $line['buy_percent']; $rss['order_days'] = $line['order_days']; $rss['order_percent'] = $line['order_percent']; $rss['ship_days'] = $line['ship_days']; $rss['ship_percent'] = $line['ship_percent']; $rss['arrive_days'] = $line['arrive_days']; $rss['arrive_percent'] = $line['arrive_percent']; $rss['docs_days'] = $line['docs_days']; $rss['docs_percent'] = $line['docs_percent']; $rss['del_days'] = $line['del_days']; $rss['del_percent'] = $line['del_percent']; $rss['shipmentamount'] = $line['ship_rel_percent']; $rss['documentrelease'] = $line['doc_rel_percent']; $rss['custom_setting'] = $line['custom_setting']; $rss['waiting_shipment_limit'] = $line['waiting_shipment_limit']; $rss['shipped_limit'] = $line['shipped_limit']; $rss['bl_released_limit'] = $line['bl_released_limit']; $rss['total_credit_limit'] = $line['total_credit_limit']; $rss['rec_plan_id'] = $line['plan_id']; $sSQL = "SELECT * FROM receivable_plans WHERE country = '".$country."' AND label like '%Basic%' AND buytype = 'UAE' "; $result = pg_query($db,$sSQL); if(pg_num_rows($result) == 0 ) { $sSQL = "SELECT * FROM receivable_plans WHERE country = 'Global' AND buytype = 'UAE' "; $result = pg_query($db,$sSQL); } $line = pg_fetch_array($result, null, PGSQL_ASSOC); if($line['plan_id']) { $rss['buy_days_uae'] = $line['buy_days']; $rss['buy_percent_uae'] = $line['buy_percent']; $rss['order_days_uae'] = $line['order_days']; $rss['order_percent_uae'] = $line['order_percent']; $rss['ship_days_uae'] = $line['ship_days']; $rss['ship_percent_uae'] = $line['ship_percent']; $rss['arrive_days_uae'] = $line['arrive_days']; $rss['arrive_percent_uae'] = $line['arrive_percent']; $rss['docs_days_uae'] = $line['docs_days']; $rss['docs_percent_uae'] = $line['docs_percent']; $rss['del_days_uae'] = $line['del_days']; $rss['del_percent_uae'] = $line['del_percent']; $rss['shipmentamount_uae'] = $line['ship_rel_percent']; $rss['documentrelease_uae'] = $line['doc_rel_percent']; $rss['waiting_shipment_limit_uae'] = $line['waiting_shipment_limit']; $rss['shipped_limit_uae'] = $line['shipped_limit']; $rss['bl_released_limit_uae'] = $line['bl_released_limit']; $rss['total_credit_limit_uae'] = $line['total_credit_limit']; $rss['rec_plan_id_uae'] = $line['plan_id']; } pg_update($db,'customer',$rss,$cond) or die('error 999'); if($ip_country != 'JAPAN') { $customer_msg = "\n\n\nCustomer Details\n\nCompany Name:$company \nUser Name:$email \nCustomer ID:$CUSTOMERID \nCountry:$country \nBusiness Tel:$tel \nMobile No:$mobile \n\n "; $sSQL = "select * from messages where msgid=10"; $result = pg_query($db,"select auctionid from usercookie where userid=" . $CUSTOMERID) or die(pg_last_error());; if ($row = pg_fetch_array($result, null, PGSQL_ASSOC)) { $AuctionID = $row['auctionid']; } pg_free_result($result); $result = pg_query($db,$sSQL); if ($row = pg_fetch_array($result, null, PGSQL_ASSOC)) { $msg = $row['msgtext']; $msgfooter = $row['msgfooter']; $tmpID = session_id() . "_" . time(); $msg .= "\n\nhttp://www.zulfiqar.co.jp/yourid.php?REQUESTNO=" . $tmpID." "; $msg .= $msgfooter; $rcoss = array(); $rcoss['tmpid'] = $CUSTOMERID; $rcoss['auctionid'] = $AuctionID; $rcoss['tmpcode'] = $tmpID; $rcoss['wdt'] = strftime("%Y-%m-%d %T"); pg_insert($db,"fogetid",$rcoss) or die("fogetid err"); send_mail($email,$row['msgsubject'],nl2br($msg),"From: $row[msgfrom]"); send_mail($staffemail,$row['msgsubject'],nl2br($msg).$customer_msg,"From: $row[msgfrom]"); $show_msg = 'Thank you for choosing us as a potential supplier for new and used cars from Japan.
We are pleased to inform you that your membership has been processed successfully.
Please check email for login details.'; } } else { $result = pg_query($db,"select * from " . AA_MESSAGESTABLE . " where msgid=9") or die(pg_last_error()); if ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) { $honbun = $line['msgtext']; $honbun .= "\n"; $honbun .= $line['msgfooter']; send_mail($email,$line['msgsubject'],$honbun,"From: $line[msgfrom]"); $show_msg = 'Thank you for considering us as a potential supplier of new and used cars from Japan.
Your application is in process. Should you be evaluated as a real buyer we will be in further contact with you.'; } } pg_free_result($result); } } } if($show_msg) echo "











"; else { if($free_auction_access) { ?>