Legend:

echo'<p>'.__('The demo on the left gives you an idea of what the app can do. If it will be useful for you, then do register...','church-admin').'</p>';

65

echo'<p>'.__('The church admin app costs £7.50 ($10) per month for your church and is free for users to download and use on their iOS or Android devices','church-admin').'</p>';

64

echo'<p>'.__('The demo on the left gives you an idea of what the app can do. Type "The Gateway Church" into the login screen to get some idea of what it can do! If it will be useful for you, then do subscribe with our free 1 month trial (£7.50pm after 1 month, cancel anytime)','church-admin').'</p>';

$sql='SELECT people_type_id FROM '.CA_PEO_TBL.' WHERE people_id="'.intval($people_id).'"';

78

$person_type=$wpdb->get_var($sql);

79

switch($person_type)

89

$check=$wpdb->get_var('SELECT attendance_id FROM '.CA_IND_TBL.' WHERE `date`="'.esc_sql($_POST['class_date']).'" AND people_id="'.intval($people_id).'" AND meeting_type="class" AND meeting_id="'.intval($_POST['class_id']).'"' );

foreach($_POST AS $key=>$value)$sqlsafe[$key]=esc_sql(stripslashes_deep($value));

24

foreach($sqlsafe['people_id'] AS $key=>$person)

25

{

26

$id=$wpdb->get_var('SELECT attendance_id FROM '.CA_IND_TBL.' WHERE `date`="'.$sqlsafe['date'].'" AND people_id="'.intval($person).'" AND meeting_type="'.esc_sql($meeting[0]).'" AND meeting_id="'.esc_sql($meeting[1]).'"');

$attendance=$wpdb->get_var('SELECT attendance_id FROM '.CA_IND_TBL.' WHERE meeting_type="'.esc_sql($meeting[0]).'" AND `date`="'.esc_sql($date->date).'" AND people_id="'.intval($person->people_id).'"');