Topic: pls help me i need to know why i get error..pls check..

[rsalumpit]

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

Code: [Select]

<form method="post" action="https://system.netsuite.com/app/login/nllogin.nl" name="otolog">
<input name="email" type="hidden" value="p7three@tgn.com"/>
<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

Code: [Select]

<?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_
selectedtab
id
externalid
type
quickadd
whence
customform
entityid
company
salutation
firstname
middlename
lastname
title
subsidiary
phone
fax
email
defaultaddress
isprivate
isinactive
templatestored
lastmodifieddate
datecreated
hasshipping
owner
oldparent
category
altemail
officephone
homephone
mobilephone
supervisor
supervisorphone
assistant
assistantphone
comments
globalsubscriptionstatus
image
freeformstatepref
sessioncountry
hiddenzip
billaddr1
billaddr2
billaddr3
billcity
billstate
billzip
billcountry
shipaddr1
shipaddr2
shipaddr3
shipcity
shipstate
shipzip
shipcountry
companyid
unsubscribe
custentity_leadcategory
edition
origsubstatus
contactrole">
<input class="" name="contactflags" value="0
0
0
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0" type="hidden">
<input class="" name="contactloaded" value="T" type="hidden">
<INPUT type="hidden" name="contactfieldsets"  value="






























































">
<input name="contacttypes" value="text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
phone
text
email
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
text
select" type="hidden">
<input class="" name="contactlabels" value="








Contact





Job Title

Main Phone

Email








































" type="hidden">
<INPUT type="hidden" name="contactdata"    value="15612716




contact
T

-40
'.$firstname.' '.$lastname.'





'.$designation.'
1
'.$phone.'

'.$email.'



F


T












1

false
'.$country.'





















-10">
<input class="" name="nextcontactidx" value="2" type="hidden">
<input name="addressbookfields" value="id
internalid
defaultshipping
defaultbilling
isresidential
addressid
label
attention
addressee
phone
addr1
addr2
city
state
dropdownstate_display
dropdownstate
zip
country
addrtext
override" type="hidden">
<input name="addressbookflags" value="0
0
0
0
0
0
0
0
0
0
0
0
0
0
8
0
0
0
0
0" type="hidden">
<input name="addressbookloaded" value="T" type="hidden">
<input name="addressbooktypes" value="text
text
checkbox
checkbox
checkbox
text
text
text
text
phone
text
text
text
text
text
slaveselect
text
select
address
checkbox" type="hidden">
<input name="addressbooklabels" value="

Default Shipping
Default Billing
Residential Address

Label
Attention
Addressee
Phone
Address 1
Address 2
City
State/Province


Zip
Country
Address
Override" type="hidden">
<input name="addressbookdata" value="

T
T
F

'.$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>

[rsalumpit]

any other help pls?

[Maq]

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:

Code: [Select]

ini_set ("display_errors", "1");
error_reporting(E_ALL);