} else {
$view = 'alpha';
$r1 =& show_approved('bible_high');
$r2 =& show_approved('no_1');
$r3 =& show_approved('no_2');
$r4 =& show_approved('no_3');
$r5 =& show_approved('no_1');
$r6 =& show_approved('no_2');
$r7 =& show_approved('no_3');
$r8 =& show_approved('no_1');
$r9 =& show_approved('no_2');
$r10 =& show_approved('no_3');
$r11 =& show_approved('householder');
$r12 =& show_approved('householder');
$r32 =& show_approved('householder');
$r33 =& show_approved('householder');
}
$r13 =& study();
$r14 =& setting();
$r15 =& study();
$r16 =& setting();
$r17 =& study();
$r18 =& setting();
$r19 =& study();
$r20 =& setting();
$r21 =& study();
$r22 =& setting();
$r23 =& study();
$r24 =& setting();
$r25 =& study();
$r26 =& setting();
}
// *** END Update or insert attend1_meet1 assignment ***
if ($_SERVER['REQUEST_METHOD'] == 'POST' and isset($_POST['attend2_meet2'])) {
// *** Update or insert attend2_meet1 assignment ***
$user_id = $_POST['attend2_meet2'];
$conflict_msg =& handle_assignment_post($monday, $user_id, 2, $attend2_meet2, $page_id);
// meeting_type_id = 1, assign_type_id = 31, page_id = 5
}
// *** END Update or insert attend2_meet1 assignment ***
// *** END Handle the Forms. ***
$r1 =& show_approved(attend);
// *** Database query variables for forms select options ***
$r2 =& show_approved(attend);
// Query in functions filter for those approved for assignments
$r3 =& show_approved(attend);
$r4 =& show_approved(attend);
// Database query variables for when assignment record exists. The query returns data from users table and assignments table.
$row_attend1_meet1 =& assign_record_exists($monday, $page_id, $attend1_meet1);
// attend1_meet2 query - page_id = 5 AND assign_type_id = 28
$num_row_attend1_meet1 = mysqli_num_rows($row_attend1_meet1);
$row_attend2_meet1 =& assign_record_exists($monday, $page_id, $attend2_meet1);
// attend2_meet2 query - page_id = 5 AND assign_type_id = 29
$num_row_attend2_meet1 = mysqli_num_rows($row_attend2_meet1);
$row_attend1_meet2 =& assign_record_exists($monday, $page_id, $attend1_meet2);
// attend1_meet1 query - page_id = 5 AND assign_type_id = 30
$num_row_attend1_meet2 = mysqli_num_rows($row_attend1_meet2);
$row_attend2_meet2 =& assign_record_exists($monday, $page_id, $attend2_meet2);
// attend2_meet1 query - page_id = 5 AND assign_type_id = 31
$num_row_attend2_meet2 = mysqli_num_rows($row_attend2_meet2);
// *** END Database query variables for forms select options ***
// *** Create the Forms. Each form submits when a selection option is chosen. ***
}
if ($_SERVER['REQUEST_METHOD'] == 'POST' and isset($_POST['mic2_meet1'])) {
// *** Update or insert mic2_meet1 assignment ***
$user_id = $_POST['mic2_meet1'];
$conflict_msg =& handle_assignment_post($monday, $user_id, 1, $mic2_meet1, $page_id);
// meeting_type_id = 1, assign_type_id = 27, page_id = 6
}
$r1 =& show_approved(sound_panel);
// query in functions filter for those approved for assignments
$r2 =& show_approved(stage);
$r3 =& show_approved(mic);
$r4 =& show_approved(mic);
$r5 =& show_approved(sound_panel);
$r6 =& show_approved(stage);
$r7 =& show_approved(mic);
$r8 =& show_approved(mic);
// Database query variables for when assignment record exists. The query returns data from users table and assignments table.
$row_sound_meet2 =& assign_record_exists($monday, $page_id, $sound_meet2);
//page_id = 6 AND assign_type_id = 20 // sound_meet2 query
$num_row_sound_meet2 = mysqli_num_rows($row_sound_meet2);
$row_stage_meet2 =& assign_record_exists($monday, $page_id, $stage_meet2);
//page_id = 6 AND assign_type_id = 21 // stage_meet2 query
$num_row_stage_meet2 = mysqli_num_rows($row_stage_meet2);
$row_sound_meet1 =& assign_record_exists($monday, $page_id, $sound_meet1);
//page_id = 6 AND assign_type_id = 24 // sound_meet1 query
$num_row_sound_meet1 = mysqli_num_rows($row_sound_meet1);
$row_stage_meet1 =& assign_record_exists($monday, $page_id, $stage_meet1);
//page_id = 6 AND assign_type_id = 25 // stage_meet1 query
$num_row_stage_meet1 = mysqli_num_rows($row_stage_meet1);
$row_mic1_meet2 =& assign_record_exists($monday, $page_id, $mic1_meet2);
//page_id = 6 AND assign_type_id = 22 // mic1_meet2 query
// *** Update or insert close_prayer assignment ***
$user_id = $_POST['close_prayer'];
$conflict_msg =& handle_assignment_post($monday, $user_id, $meeting_type_id, $close_prayer, $page_id);
// meeting_type_id = 1, assign_type_id = 32, page_id = 4
}
$cts_r =& cts_detail($monday);
// Get the material for the Service Meeting
while ($cts_row = mysqli_fetch_array($cts_r)) {
$sm_1 = $cts_row['sm_1'];
$sm_2 = $cts_row['sm_2'];
$sm_3 = $cts_row['sm_3'];
}
$r1 =& show_approved(serv_meet);
$r2 =& show_approved(serv_meet);
$r3 =& show_approved(serv_meet);
$r4 =& show_approved(prayer);
$row_part_1 =& assign_record_exists($monday, $page_id, $part_1);
// Database query variables for when assignment record exists. The query returns data from users table and assignments table.
$num_row_part_1 = mysqli_num_rows($row_part_1);
//page_id = 4 AND assign_type_id = 17 // part_1 query
$row_part_2 =& assign_record_exists($monday, $page_id, $part_2);
//page_id = 4 AND assign_type_id = 18 // part_2 query
$num_row_part_2 = mysqli_num_rows($row_part_2);
$row_part_3 =& assign_record_exists($monday, $page_id, $part_3);
//page_id = 4 AND assign_type_id = 19 // part_3 query
$num_row_part_3 = mysqli_num_rows($row_part_3);
$row_close_prayer =& assign_record_exists($monday, $page_id, $close_prayer);
//page_id = 4 AND assign_type_id = 32 // close_prayer query
$num_row_close_prayer = mysqli_num_rows($row_close_prayer);
if ($num_row_part_1 = 1) {
$opt_1 = '<option value="' . $row_part_1['user_id'] . '" selected>' . $row_part_1['Name'] . '</option>';
$ptws_song_3 = $ptws_row[4];
}
// END Database query variables for meeting details (titles of themes, sources material)
// *** Database query variables for forms select options ***
// Database query variables for when there is no assignment record yet existing. Show those who are approved for various assignments.
$r1 =& show_approved(public_speaker);
// Local speaker
$r6 =& show_approved(public_speaker);
// Outgoing speaker 1
$r10 =& show_approved(public_speaker);
// Outgoing speaker 2
$r13 =& show_approved(public_speaker);
// Outgoing speaker 3
$r2 =& show_approved(chairman);
//$r3 =& show_approved(theme);
$r4 =& show_approved(reader);
//Select all the themes of the drop down(s)
$query3 = "SELECT * FROM themes ORDER BY theme_id";
$r3 = mysqli_query($dbc, $query3) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\nQuery: {$query3}");
$query5 = "SELECT * FROM themes ORDER BY theme_id";
$r5 = mysqli_query($dbc, $query5) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\nQuery: {$query5}");
$query7 = "SELECT * FROM themes ORDER BY theme_id";
$r7 = mysqli_query($dbc, $query7) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\nQuery: {$query7}");
$query12 = "SELECT * FROM themes ORDER BY theme_id";
$r12 = mysqli_query($dbc, $query12) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\nQuery: {$query12}");
$query14 = "SELECT * FROM themes ORDER BY theme_id";
$r14 = mysqli_query($dbc, $query14) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\nQuery: {$query15}");
//Select all the Congregation of the drop down(s)
$query8 = "SELECT * FROM congregations ORDER BY congregation";
$r8 = mysqli_query($dbc, $query8) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\nQuery: {$query8}");
$query9 = "SELECT * FROM congregations ORDER BY congregation";
