$date_track_sql = "SELECT track_date FROM {$tbltracks} WHERE track_id='{$track_id}' ";
$date_track_res = mysql_query($date_track_sql) or send_err_mail($date_track_sql . mysql_error(), $PHP_SELF);
$date_track_row = mysql_fetch_array($date_track_res);
$track_date = $date_track_row[track_date];
$track_ticket_sql = "SELECT {$tblticketcheckin}.ticket_id FROM {$tbltickettrackRln},{$tblticketcheckin} WHERE \t\t{$tbltickettrackRln}.ticket_id={$tblticketcheckin}.ticket_id AND {$tbltickettrackRln}.track_id='{$track_id}' AND {$tblticketcheckin}.contact_id='{$contact_id}' AND {$tbltickettrackRln}.ticket_event_date='{$track_date}'";
$track_ticket_res = mysql_query($track_ticket_sql) or send_err_mail($track_ticket_sql . mysql_error(), $PHP_SELF);
$track_ticket_total = mysql_num_rows($track_ticket_res);
if ($reg_total > 0 || $is_free == 1 || $track_ticket_total > 0) {
//if reg type is 'seller or speaker' Or track is free
$reg_sql = "SELECT contact_id FROM {$tbltrackSpkRln} WHERE contact_id='{$contact_id}' AND track_id='{$track_id}' AND track_user_type='speaker' ";
$reg_res = mysql_query($reg_sql) or send_err_mail($reg_sql . mysql_error(), $PHP_SELF);
$reg_total = mysql_num_rows($reg_res);
if ($reg_total == "0") {
$insstate_sql = "INSERT INTO {$tbltrackSpkRln} (track_id, contact_id, track_user_type, status) VALUES ('{$track_id}', '{$contact_id}', '{$type}', 'active')";
$insstate_res = mysql_query($insstate_sql) or send_err_mail($insstate_sql . mysql_error(), $PHP_SELF);
update_prop_log($PHP_SELF, $insstate_sql, 'INSERT INTO $tbltrackSpkRln');
} else {
$name = get_contact_name($contact_id);
$error_str = $name;
$error_id_str = $contact_id;
$opp_type = 'Speaker';
$error_str = '<font color="#FF0000">' . $error_str . ' is already Registered as ' . $opp_type . ', If you continue then he will no longer available as ' . $opp_type . '. Do you want to continue?</font><br>';
$error_str .= '<button class="btn btn-primary" type="button" name="set_rln_contact" id="set_rln_contact" onClick=javascript:attendTrackReg("' . $user_id . '","' . $track_id . '","' . $type . '","continue"); >Continue</button>';
$error_str .= ' <button class="btn btn-success" type="button" name="set_rln_contact" id="set_rln_contact" onClick=javascript:attendTrackReg("' . $user_id . '","' . $track_id . '","' . $type . '","cancel"); >Cancel</button>';
}
} else {
//if reg type is 'seller or speaker' Or track is free
$error_str = '<font color="#FF0000">' . get_contact_name($contact_id) . " have no permission to attend this Track, Please Check your Tickets</font>";
}
}
echo $error_str;
$chk_rln_res = mysql_query($chk_rln_sql) or send_err_mail($chk_rln_sql . mysql_error(), $PHP_SELF);
if (mysql_num_rows($chk_rln_res) == 0) {
$txt_username = addslashes($txt_username);
$txt_password = addslashes($txt_password);
$txt_objective = addslashes($txt_objective);
$rln_insert_sql = "INSERT INTO {$tblorganisercontactRln} (organiser_id, contact_id, username, password, objective, added_by, added_on) VALUES ('{$organiser_id}', '{$contact_id}', '{$txt_username}', '{$txt_password}', '{$txt_objective}', '{$_SESSION['vis_user_id']}','{$CurGmtDT}')";
$rln_insert_res = mysql_query($rln_insert_sql) or send_err_mail($rln_insert_sql . mysql_error(), $PHP_SELF);
update_prop_log($PHP_SELF, $rln_insert_sql, 'INSERT INTO $tblorganisercontactRln');
}
$chk_contact_rln_sql = "SELECT contact_id FROM {$tblcontactcontactRln} WHERE contact_id='{$contact_id}' AND parent_contact_id='{$hid_company_id}' AND is_contact_person='1'";
$chk_contact_rln_res = mysql_query($chk_contact_rln_sql) or send_err_mail($chk_contact_rln_sql . mysql_error(), $PHP_SELF);
if (mysql_num_rows($chk_contact_rln_res) == 0) {
$is_contact_person = 1;
$rln_insert_sql = "INSERT INTO {$tblcontactcontactRln} (parent_contact_id, contact_id, relationship, is_prim_contact, is_contact_person) VALUES ('{$hid_company_id}', '{$contact_id}', '{$contact_designation}', '{$is_prim_contact}', '{$is_contact_person}')";
$rln_insert_res = mysql_query($rln_insert_sql) or send_err_mail($rln_insert_sql . mysql_error(), $PHP_SELF);
update_prop_log($PHP_SELF, $rln_insert_sql, 'INSERT INTO $tblcontactcontactRln');
}
}
$msg = "<meta http-equiv=\"Refresh\" content=\"0;url=manage_collegue.php\">";
echo $msg;
exit;
}
// if($submit == "Submit") ENDS
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<!-- Meta, title, CSS, favicons, etc. -->
<meta charset="utf-8">
update_prop_log($PHP_SELF, $sql1, 'UPDATE $tblcompanymastercompanytype');
}
}
foreach ($_FILES['organisation_media']['tmp_name'] as $key => $file) {
$company_id = $contactId;
$media_type = 'file';
if (trim($_FILES['organisation_media']['name'][$key])) {
$media_file_name = $_FILES['organisation_media']['name'][$key];
$media_file_name = preg_replace('/\\s+/', '_', $media_file_name);
$media_file_name = rand(9999, 99999) . $media_file_name;
$tmp_name = $_FILES['organisation_media']['name'][$key];
$upldstatus = move_uploaded_file($tmp_name, "uploads/{$media_file_name}");
}
$insstate_sql = "INSERT INTO {$tblcompprofmediarln} (company_id, media_type, media_file_name, added_on,added_by) VALUES ('{$company_id}', '{$media_type}', '{$media_file_name}', '{$CurGmtDT}', '{$_SESSION['vis_user_id']}')";
$insstate_res = mysql_query($insstate_sql) or send_err_mail($insstate_sql . mysql_error(), $PHP_SELF);
update_prop_log($PHP_SELF, $insstate_sql, 'INSERT INTO $tblcompprofmediarln ');
}
header('Location:./manage_company_profile.php');
} else {
$chk_sql = "SELECT * FROM {$tblcontact} WHERE contact_id IN(SELECT parent_contact_id FROM {$tblcontactcontactRln} WHERE contact_id = '{$user_id}') AND contact_type = 'company'";
$chk_res = mysql_query($chk_sql) or send_err_mail($chk_sql . mysql_error(), $PHP_SELF);
while ($Sql_stat_row = mysql_fetch_array($chk_res)) {
$company_id = $Sql_stat_row[contact_id];
$company_name = $Sql_stat_row[contact_name];
$company_address = $Sql_stat_row[contact_address];
$company_mobile = $Sql_stat_row[contact_mobile];
$company_official_email = $Sql_stat_row[contact_email_official];
$company_url = $Sql_stat_row[contact_url];
$company_desc = $Sql_stat_row[contact_desc];
$company_prof_pic = $Sql_stat_row[contact_prof_pic];
$company_addedby = $Sql_stat_row[contact_added_by];
