<?php
session_start();
include "config.php";
include "db.php";
dbconnect() or send_err_mail("dbconnect - Cannot connect to the Server", $PHP_SELF);
$id = intval($_REQUEST['id']);
$organiser_sql = "select * from {$tblcontact} where contact_id='{$id}'";
$organiser_res = mysql_query($organiser_sql) or send_err_mail($organiser_sql . mysql_error(), $PHP_SELF);
$organiser_row = mysql_fetch_array($organiser_res);
$contact_prof_pic = $organiser_row[contact_prof_pic];
unlink("organiser/contact_prof_pic/" . $contact_prof_pic);
$insstate_sql = "update {$tblcontact} set contact_prof_pic='' where contact_id ='{$id}'";
$insstate_res = mysql_query($insstate_sql) or send_err_mail($insstate_sql . mysql_error(), $PHP_SELF);
?>
<input type="file" id="prof_pic" name="prof_pic" required="required" class="form-control col-md-7 col-xs-12" value="" ><input type="hidden" name="hid_prof_pic_flag" id="hid_prof_pic_flag" value="0" >
$selRtRes2 = mysql_query($selRtQry2) or send_err_mail($selRtQry2 . mysql_error(), addslashes($PHP_SELF));
while ($selRtRow2 = mysql_fetch_assoc($selRtRes2)) {
$i = 0;
$fields2 = $colvalues2 = '';
$fields2 = $colvalues2 = array();
foreach ($selRtRow2 as $key2 => $value2) {
if ($key2 != 'schedule_id') {
$fields2[$i] = $key2;
$colvalues2[$i] = "'" . $value2 . "'";
}
$i++;
}
$fields2 = implode(",", $fields2);
$colvalues2 = implode(",", $colvalues2);
$addRt_sql2 = "insert into `{$tblschedules}` ({$fields2}) values ({$colvalues2}) ";
$addRt_res2 = mysql_query($addRt_sql2) or send_err_mail($addRt_sql2 . mysql_error(), addslashes($_SERVER['PHP_SELF']));
$new_sch_id = mysql_insert_id();
//update_prop_log($addRt_sql2, 'inserted booking details while block- confirm option from viewall page');
}
$schduleListQry = "UPDATE {$tblschedules} SET schedule_status='edited' WHERE schedule_id='{$schd_id}'";
$schduleListRes = mysql_query($schduleListQry);
$schduleListQry = "UPDATE {$tblschedules} SET parent_id='{$schd_id}', sender_status='{$updateStatusId_sender}', receiver_status='{$updateStatusId_receiver}', \n last_modified_user='******', is_overlap_req=0 {$updtStr} WHERE schedule_id='{$new_sch_id}'";
$schduleListRes = mysql_query($schduleListQry);
if ($act_type == 'sender') {
$updateStatusId = $updateStatusId_sender;
} else {
if ($act_type == 'receiver') {
$updateStatusId = $updateStatusId_sender;
}
}
$selstatusQ = "SELECT * FROM {$tblScheduleStatusMaster} WHERE status_id='{$updateStatusId}'";
<?php
session_start();
include "config.php";
include "db.php";
dbconnect() or send_err_mail("Cannot connect to server" . mysql_error(), $PHP_SELF);
$user_id = $_SESSION[vis_user_id];
$organiser_id = $_SESSION[vis_organiser_id];
$track_discussion = addslashes($track_discussion);
$result = addComment($discus_track_id, $discus_event_id, $track_discussion);
?>
<table border='0' width='100%' cellspacing="0" cellpadding="0" style="padding:100px;" >
<?php
$Discus_track_sql = "SELECT {$tbltrackDiscussion}.contact_id,{$tbltrackDiscussion}.track_discussion,{$tblcontact}.contact_prof_pic,{$tblcontact}.contact_name,{$tblcontact}.salutation,{$tblcontact}.first_name,{$tblcontact}.last_name FROM {$tbltrackDiscussion},{$tblcontact} WHERE {$tbltrackDiscussion}.status IN ('active') AND {$tbltrackDiscussion}.track_id='{$discus_track_id}' AND {$tbltrackDiscussion}.event_id='{$discus_event_id}' AND {$tbltrackDiscussion}.contact_id={$tblcontact}.contact_id ORDER BY {$tbltrackDiscussion}.added_on";
$Discus_track_res = mysql_query($Discus_track_sql) or send_err_mail($Discus_track_sql . mysql_error(), $PHP_SELF);
$Discus_track_total = mysql_num_rows($Discus_track_res);
if ($Discus_track_total > 0) {
while ($Discus_track_row = mysql_fetch_array($Discus_track_res)) {
$discuss_contact_id = $Discus_track_row['contact_id'];
$registarnt_type_id = get_registarnt_type_of_this_event($event_id, $discuss_contact_id);
if ($registarnt_type_id == "1") {
$discuss_profile_page = "buyer_profile.php";
}
if ($registarnt_type_id == "2") {
$discuss_profile_page = "seller_profile.php";
}
if ($registarnt_type_id == "3") {
$discuss_profile_page = "speaker_profile.php";
}
if ($registarnt_type_id == "4") {
echo " >{$Sql_stat_row['state_name']}</option> ";
}
?>
</select>
</span>
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="last-name">City <font color="#FF0000">*</font></label>
<div class="col-md-6 col-sm-6 col-xs-12">
<span id="citydiv_fil">
<select name="sel_city" class="form-control" id="sel_city" style="width:90%;" required="required">
<option value="">Select City</option>
<?php
$Sql_stat = "SELECT * FROM {$tblcity} WHERE state_id='{$sel_state}' and city_status='Active' order by city_name";
$Sql_stat_res = mysql_query($Sql_stat) or send_err_mail($Sql_stat . mysql_error(), $PHP_SELF);
while ($Sql_stat_row = mysql_fetch_array($Sql_stat_res)) {
echo "<option value='{$Sql_stat_row['city_id']}'";
if ($sel_city == $Sql_stat_row[city_id]) {
echo "selected ";
}
echo " >{$Sql_stat_row['city_name']}</option> ";
}
?>
</select>
</span>
</div>
</div>
<div class="form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12" for="last-name">Mobile <font color="#FF0000">*</font>
<?php
session_start();
include "config.php";
include "db.php";
dbconnect() or send_err_mail("Cannot connect to server" . mysql_error(), $PHP_SELF);
$user_id = $_SESSION[vis_user_id];
$organiser_id = $_SESSION[vis_organiser_id];
$contact_rln_id = add_contact($parent_contact_id, $contact_id);
echo $contact_rln_id;
