rsalumpit Posted March 24, 2009 Share Posted March 24, 2009 im making a php program that transfer datas to one CRM going to another crm..the source is an open source program so i have full control on it the problem is going to the second CRM..here is my code im getting a loggin error sometimes.. btw:im using vtigerCRM to Netsuite -autologin <form method="post" action="https://system.netsuite.com/app/login/nllogin.nl" name="otolog"> <input name="email" type="hidden" value="[email protected]"/> <input name="password" type="hidden" value="greatnews1" /> <input name="jsenabled" type="hidden" value="T" /> <input name="redirect" type="hidden" value="http://74.52.105.242/~tgn1/test1/customer.php" /> <input name="rememberme" type="hidden" value="T" /> <input name="submitter" type="hidden" value="Login" /> <input type="submit" value="Start"/> </form> -main <?php mysql_connect('localhost','tgn1_admin','admin'); mysql_select_db('tgn1_main'); $errors = '1'; function numstripall($tisnum) { $tisnum = str_replace("-","",$tisnum); $tisnum = str_replace(" ","",$tisnum); $tisnum = str_replace("(","",$tisnum); $tisnum = str_replace(")","",$tisnum); $tisnum = str_replace("/","",$tisnum); return($tisnum); } while ($errors =='1') { $errors = '2'; $edesc = ''; //echo $errors; $get_data = mysql_query("select vtiger_leaddetails.leadid, vtiger_leaddetails.salutation, vtiger_leaddetails.firstname, vtiger_leaddetails.lastname, vtiger_leaddetails.company, vtiger_leaddetails.industry, vtiger_leaddetails.leadstatus, vtiger_leaddetails.leadsource, vtiger_leaddetails.designation, vtiger_leaddetails.email, vtiger_leadscf.cf_560 as 'publication', vtiger_leadscf.cf_452 as 'pub_date', vtiger_leadscf.cf_454 as 'page_num', vtiger_leadscf.cf_456 as 'subject', vtiger_leadscf.cf_458 as 'colour', vtiger_leadscf.cf_460 as 'price', vtiger_leadscf.cf_462 as 'scan_date', vtiger_leadscf.cf_476 as 'misc', vtiger_leadscf.cf_466 as 'team', vtiger_leadscf.cf_468 as 'sic', vtiger_leadscf.cf_470 as 'article_url', vtiger_leadscf.cf_472 as 'pub_filename', vtiger_leadscf.cf_474 as 'pub_other', vtiger_leadscf.cf_480 as 'industryv2', vtiger_leadaddress.city, vtiger_leadaddress.state, vtiger_leadaddress.pobox, vtiger_leadaddress.country, vtiger_leadaddress.phone, vtiger_leadaddress.mobile, vtiger_leadaddress.fax, vtiger_leadaddress.lane, vtiger_leadaddress.code from vtiger_leaddetails left join vtiger_leadscf on vtiger_leaddetails.leadid = vtiger_leadscf.leadid left join vtiger_leadaddress on vtiger_leaddetails.leadid = vtiger_leadaddress.leadaddressid where leadstatus in('Reworked','Pending') and vtiger_leadaddress.phone != '' limit 1; "); if (mysql_num_rows($get_data) =='1') { $row = mysql_fetch_array($get_data); $lead_id = $row['leadid']; $firstname = $row['firstname']; $lastname = $row['lastname']; $company = addslashes($row['company']); $industry = $row['industryv2']; $leadstatus = $row['leadstatus']; $leadsource = $row['leadsource']; $designation = $row['designation']; $publication =$row['publication']; $pub_date = $row['pub_date']; $page_num = $row['page_num']; $subject = $row['subject']; $color = $row['colour']; $price = $row['price']; $misc = $row['misc']; $scan_date = $row['scan_date']; $team = $row['team']; $sic = $row['sic']; $article_url = $row['article_url']; $pub_filename = $row['pub_filename']; $city = $row['city']; $state = $row['state']; $pobox = $row['pobox']; $country = $row['country']; $phone = $row['phone']; $mobile = $row['mobile'];$fax = $row['fax']; $lane = $row['lane']; $email = $row['email']; $zcode = $row['code']; $pub_other = $row['pub_other']; $designation = $row['designation']; $q = mysql_query("select idxx from `vtiger_cf_560` where cf_560='$publication'"); $r = mysql_fetch_array($q); echo "<strong>".$leadsource."</strong><br>"; $q2 = mysql_query("select leadid from `vtiger_leadsource_lookup` where leadname='$leadsource'"); $r2 = mysql_fetch_array($q2); echo "<strong>".$r2['leadid']."</strong><br>"; /// $zcode = substr($zcode,0,10); $zcode=str_replace(" ","",$zcode); //$phone = numstripall($phone); if (strlen($phone) < 10) {$errors = 'Rejected'; $edesc .= ' | Phone Number Error';} if (strlen($publication) < 2) {$errors = 'Rejected'; $edesc .= ' | Pub Name';} if (strlen($pub_date) < 2) {$errors = 'Rejected'; $edesc .= ' | Pub Date';} if (strlen($scan_date) < 2) {$errors = 'Rejected'; $edesc .= ' | Scan Date';} if (strlen($firstname) < 1) {$errors = 'Rejected'; $edesc .= ' | First Name';} if (strlen($lastname) < 1) {$errors = 'Rejected'; $edesc .= ' | Last Name';} if (strlen($company) < 1) {$errors = 'Rejected'; $edesc .= ' | Company';} if (strlen($designation) < 1) {$errors = 'Rejected'; $edesc .= ' | Designation';} if (strlen($zcode) < 1) {$errors = 'Rejected'; $edesc .= ' | Postal Code';} if (strlen($sic) < 1) {$errors = 'Rejected'; $edesc .= ' | SIC code';} if (strlen($price) < 1) {$errors = 'Rejected'; $edesc .= ' | No size / price';} if (strlen($state) !=2) {$errors = 'Rejected'; $edesc .= ' | State Error';} if (strlen($lane) < 1) {$errors = 'Rejected'; $edesc .= ' | Address Incomplete';} if (strlen($subject) < 1) {$errors = 'Rejected'; $edesc .= ' | No Subject';} if (strlen($page_num) < 1) {$errors = 'Rejected'; $edesc .= ' | No Page Number';} if (strlen($country) < 6) {$errors = 'Rejected'; $edesc .= ' | Country Format:ex.United States';} if (strtolower($country) == 'united states'){$ccode = 'US';} if (strtolower($country) == 'canada'){$ccode = 'CA';} if (strtolower($country) == 'united kingdom'){$ccode = 'GB';} $stat='-OK'; if ($errors !=2){ mysql_query("update vtiger_leaddetails set leadstatus = '$errors' where leadid = '$lead_id'"); mysql_query("update vtiger_crmentity set description = '$edesc' where crmid = '$lead_id'"); } } else { $errors = 'Done'; echo 'No leads to upload.'; echo "<script>setTimeout(\"window.location = '".$_SERVER['PHP_SELF']."'\",5000)</script>"; exit; } echo $errors; if ($errors != '2') {$errors = 1;} } if ($errors == 2){ mysql_query("update vtiger_leaddetails set leadstatus = 'Warm' where leadid = '$lead_id'"); mysql_query("update vtiger_crmentity set description = '$stat' where crmid = '$lead_id'"); } function change($ch) { $sdyr = substr($ch,0,4); $sdmo = substr($ch,5,2); $sddy = substr($ch,8,2); $nu = $sdmo.'/'.$sddy.'/'.$sdyr; return $nu; } function numstrip($strip) { if (strpos($strip,") ",0) !==false) { $strip = str_replace(") ","-",$strip); $strip = substr($strip,1); } str_replace(" ","-",$strip); return $strip; } $phone = numstrip($phone); $scan_date = change($scan_date); $pub_date = change($pub_date); $date_format = 'm/d/Y'; $input = $scan_date; $input = trim($input); $time = strtotime($input); $is_valid_date = date($date_format, $time) == $input; if(!$is_valid_date) $scan_date = ""; echo $scan_date; echo $phone; if($industry=='Large Company (>100 employess)') $industry='1'; if($industry=='Medium Company (11-99 employees)') $industry='2'; if($industry=='Small Company (1-10 employees)') $industry='3'; if($industry=='Restaurant') $industry='4'; if($industry=='Doctor') $industry='5'; if($industry=='Lawyer') $industry='6'; if($industry=='Sports') $industry='7'; if($industry=='Individual') $industry='8'; if($industry=='Civic Organization') $industry='9'; echo "<strong>".$industry."</strong><br>"; mysql_query("update vtiger_leaddetails set leadstatus = 'Warm' where leadid = '$lead_id'"); echo '<form name="mymain" method="post" action="https://system.netsuite.com/app/common/entity/custjob.nl" target="results"> <input id="submitted" name="submitted" value="T" type="hidden"> <input id="submitter" name="submitter" value="Save" type="hidden"> <input id="isperson_fs_inp" name="isperson" value="F" type="hidden"> <input class="" value="LEAD" name="stage" id="stage" type="hidden"> <!--input id="hddn_entitystatus1" name="entitystatus" value="13"--> <input value="15612716" name="_eml_nkey_" id="_eml_nkey_" type="hidden"> <input name="_multibtnstate_" id="_multibtnstate_" type="hidden"> <input value="14" name="accessrole" id="accessrole" type="hidden"> <input value="F" name="accesstabchanged" id="accesstabchanged" type="hidden"> <input value="general" name="selectedtab" id="selectedtab" type="hidden"> <input name="id" id="id" type="hidden"> <input name="externalid" id="externalid" type="hidden"> <input value="custjob" name="type" id="type" type="hidden"> <input name="whence" id="whence" type="hidden"> <input value="T" name="templatestored" id="templatestored" type="hidden"> <input name="lastmodifieddate" id="lastmodifieddate" type="hidden"> <input value="813628" name="nluser" id="nluser" type="hidden"> <input value="1011" name="nlrole" id="nlrole" type="hidden"> <input value="0" name="nldept" id="nldept" type="hidden"> <input value="0" name="nlloc" id="nlloc" type="hidden"> <input value="1" name="nlsub" id="nlsub" type="hidden"> <input value="lead" name="baserecordtype" id="baserecordtype" type="hidden"> <input value="T" name="hasshipping" id="hasshipping" type="hidden"> <input value="'.$country.'" name="sessioncountry" type="hidden" id="sessioncountry"> <input value="'.$r['idxx'].'" name="custentity_pubname08" id="custentity_pubname08" type="hidden"> <input value="'.$r2['leadid'].'" name="leadsource" id="leadsource" type="hidden"> <input value="'.$industry.'" name="custentity38" id="custentity38" type="hidden"> company <input id="companyname" name="companyname" type="text" value="'.$company.'"> phone <input id="phone" name="phone" value="'.$phone.'"> mobile<input id="altphone" name="altphone" value="'.$mobile.'"> fax<input id="fax" name="fax" value="'.$fax.'"> email<input id="email" name="email" value="'.$email.'"> <input id="addressbook_defaultshipping_fs_inp" name="defaultshipping" value="T"> <input id="addressbook_defaultbilling_fs_inp" name="defaultbilling" value="T"> street<input id="addr1" name="addr1" value="'.$lane.'"> city<input id="city" name="city" value="'.$city.'"> <input id="zip" name="zip" size="13" maxlength="13" value="'.$zcode.'"> state<input id="hddn_dropdownstate23" name="dropdownstate" value="'.$state.'"> country<input id="hddn_country25" name="country" value="'.$country.'"> Pub name<input id="custentity3" name="custentity3" value="'.$publication.'"> Pub date<input id="custentity2" name="custentity2" value="'.$pub_date.'"> misc<input id="custentity_miscpubinfo" name="custentity_miscpubinfo" size="0" maxlength="300" value="'.$misc.'"> page num<input id="custentity5" name="custentity5" size="0" maxlength="300" value="'.$page_num.'"> subject <input id="custentity21" name="custentity21" size="40" maxlength="300" value="'.$subject.'"> price <input id="custentity22" name="custentity22" size="0" maxlength="300" value="'.$price.'"> color <input id="custentity17" name="custentity17" size="0" maxlength="300" value="'.$color.'"> scan date <input id="custentity48" name="custentity48" size="13" maxlength="20" value="'.$scan_date.'"> <input id="custentity_pubdate08" name="custentity_pubdate08" size="13" maxlength="20" value="'.$pub_date.'"> article url <input id="custentity_articleurl" name="custentity_articleurl" size="0" maxlength="999" value="http://'.$article_url.'"> filename <input id="custentity_publicationfilename" name="custentity_publicationfilename" size="0" maxlength="300" value="'.$pub_filename.'"/> SIC <input id="custentity28" name="custentity28" size="0" maxlength="300" value="'.$sic.'"> research team <input id="custentityresearchteam" name="custentityresearchteam" size="0" maxlength="300" value="'.$team.'">'; //add contacts echo ' <input class="" value="UTF-8" name="encoding" id="encoding" type="hidden"> <INPUT type="hidden" name="contactfields" value="_eml_nkey__multibtnstate_selectedtabidexternalidtypequickaddwhencecustomformentityidcompanysalutationfirstnamemiddlenamelastnametitlesubsidiaryphonefaxemaildefaultaddressisprivateisinactivetemplatestoredlastmodifieddatedatecreatedhasshippingowneroldparentcategoryaltemailofficephonehomephonemobilephonesupervisorsupervisorphoneassistantassistantphonecommentsglobalsubscriptionstatusimagefreeformstateprefsessioncountryhiddenzipbilladdr1billaddr2billaddr3billcitybillstatebillzipbillcountryshipaddr1shipaddr2shipaddr3shipcityshipstateshipzipshipcountrycompanyidunsubscribecustentity_leadcategoryeditionorigsubstatuscontactrole"> <input class="" name="contactflags" value="0000000001000000000000000000000000000000000000000000000000000" type="hidden"> <input class="" name="contactloaded" value="T" type="hidden"> <INPUT type="hidden" name="contactfieldsets" value=""> <input name="contacttypes" value="texttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttextphonetextemailtexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttexttextselect" type="hidden"> <input class="" name="contactlabels" value="ContactJob TitleMain PhoneEmail" type="hidden"> <INPUT type="hidden" name="contactdata" value="15612716contactT-40'.$firstname.' '.$lastname.''.$designation.'1'.$phone.''.$email.'FT1false'.$country.' -10"> <input class="" name="nextcontactidx" value="2" type="hidden"> <input name="addressbookfields" value="idinternaliddefaultshippingdefaultbillingisresidentialaddressidlabelattentionaddresseephoneaddr1addr2citystatedropdownstate_displaydropdownstatezipcountryaddrtextoverride" type="hidden"> <input name="addressbookflags" value="00000000000000800000" type="hidden"> <input name="addressbookloaded" value="T" type="hidden"> <input name="addressbooktypes" value="texttextcheckboxcheckboxcheckboxtexttexttexttextphonetexttexttexttexttextslaveselecttextselectaddresscheckbox" type="hidden"> <input name="addressbooklabels" value="Default ShippingDefault BillingResidential AddressLabelAttentionAddresseePhoneAddress 1Address 2CityState/ProvinceZipCountryAddressOverride" type="hidden"> <input name="addressbookdata" value="TTF'.$lane.''.$company.''.$phone.''.$lane.''.$city.''.$state.''.$state.''.$city.''.$zcode.''.$ccode.''.$company.' '.$lane.' '.$city.' '.$state.' '.$zcode.' '.$country.''.$company.''.$lane.''.$city.''.$country.'F" type="hidden"> <input name="nextaddressbookidx" value="2" type="hidden"> </form>'; ?> setTimeout("document.mymain.submit()",5000); setTimeout("document.location.href = 'customer.php'",15000); </script> Link to comment https://forums.phpfreaks.com/topic/150891-pls-help-me-i-need-to-know-why-i-get-errorpls-check/ Share on other sites More sharing options...
rsalumpit Posted March 25, 2009 Author Share Posted March 25, 2009 any other help pls? Link to comment https://forums.phpfreaks.com/topic/150891-pls-help-me-i-need-to-know-why-i-get-errorpls-check/#findComment-794014 Share on other sites More sharing options...
Maq Posted March 25, 2009 Share Posted March 25, 2009 here is my code im getting a loggin error sometimes.. How are you supposed to help you...? This is all you're giving us, sometimes you get a login error, well is there a pattern than produces this error or values that cause it? Put this at the top of your code and see if it displays any errors: ini_set ("display_errors", "1"); error_reporting(E_ALL); Link to comment https://forums.phpfreaks.com/topic/150891-pls-help-me-i-need-to-know-why-i-get-errorpls-check/#findComment-794055 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.