$send_ecommercemail = 0;
} else {
$send_ecommercemail = 1;
}
$qry_select1 = "Select companyname,email ,url1 from cs_companydetails where userid='{$gatewayid}'";
$rst_select1 = mysql_query($qry_select1, $cnn_cs);
$rst_result1 = mysql_fetch_array($rst_select1);
$companyname1 = $rst_result1['companyname'];
$email1 = $rst_result1['email'];
$url1 = $rst_result1['url1'];
$current_date_time = func_get_current_date_time();
$user_nameexist = 0;
if ($company) {
$user_nameexist = func_checkUsernameExistInAnyTable($username, $cnn_cs);
$user_companyexist = func_checkCompanynameExistInAnyTable($companyname, $cnn_cs);
$user_mailidexist = func_checkEmailExistInAnyTable($email, $cnn_cs);
$qry_select_user = "******";
//print $qry_select_user;
if ($user_nameexist == 1) {
$msgtodisplay = "<table width='350' height='100' align='center' valign='middle' style='border:1px solid black'><tr><td align='center' valign='middle'><font face='verdana' size='1' color='red'>Existing username !! </font></td></tr><tr><td align='center'><a href='javascript:window.history.back();'><img border='0' src='images/back.jpg'></a></td></tr></table>";
} elseif ($user_companyexist == 1) {
$msgtodisplay = "<table width='350' height='100' align='center' valign='middle' style='border:1px solid black'><tr><td align='center' valign='middle'><font face='verdana' size='1' color='red'>Existing Company name !! </font></td></tr><tr><td align='center'><a href='javascript:window.history.back();'><img border='0' src='images/back.jpg'></a></td></tr></table>";
} elseif ($user_mailidexist == 1) {
$msgtodisplay = "<table width='350' height='100' align='center' valign='middle' style='border:1px solid black'><tr><td align='center' valign='middle'><font face='verdana' size='1' color='red'>Existing Mail ID !! </font></td></tr><tr><td align='center'><a href='javascript:window.history.back();'><img border='0' src='images/back.jpg'></a></td></tr></table>";
} else {
$qry_insert_user = "******";
$qry_insert_user .= " values('{$username}','{$password}','{$companyname}','{$email}','{$voulmeNumber}',0,'{$transaction_type}','{$how_about_us}','{$reseller}','{$current_date_time}',{$send_ecommercemail},{$gatewayid})";
if (!($show_sql = mysql_query($qry_insert_user))) {
print mysql_errno() . ": " . mysql_error() . "<BR>";
print "Cannot execute query <br>";
print $qry_insert_user;
if ($companyname == "" || $contactname == "") {
$msgtodisplay = "Insufficient data.";
message($msgtodisplay);
exit;
}
if ($username == "") {
$msgtodisplay = "Please enter user name.";
message($msgtodisplay);
exit;
}
if (func_checkUsernameExistInAnyTable($username, $cnn_cs)) {
$msgtodisplay = "User name already exist.";
message($msgtodisplay);
exit;
}
if (func_checkEmailExistInAnyTable($email, $cnn_cs)) {
$msgtodisplay = "Email already exist.";
message($msgtodisplay);
exit;
}
if (func_checkCompanynameExistInAnyTable($companyname, $cnn_cs)) {
$msgtodisplay = "Company already exist.";
message($msgtodisplay);
exit;
}
if ($password == "") {
$msgtodisplay = "Please enter Password.";
message($msgtodisplay);
exit;
}
$qry_select = "SELECT cs_companydetails.companyname, cs_companydetails.url1, cs_logo.logo_filename,cs_companydetails.email FROM cs_companydetails, cs_logo WHERE cs_companydetails.userId ='{$sgatewayCompanyId}' AND cs_companydetails.userId = cs_logo.Logo_company_id";