'; echo '

'; } function adminMenu() { echo "

"; echo "

"; } function adminListLocations() { global $cxn; global $m; $sql="select id, post_title title, post_name location, post_content description from wp_posts where post_type='location' order by post_date desc "; $locations=loadTable($cxn,$sql); echo ""; echo ""; echo ""; echo ""; echo ""; foreach($locations as $lkp) { $sql="select * from wp_postmeta where post_id=".$lkp['id']; $meta=loadTable($cxn,$sql); foreach($meta as $m) $lkp[$m['meta_key']]=$m['meta_value']; echo ""; } echo "

Location	Title	Details	Operation
"; if(array_key_exists('location',$lkp)) echo $lkp['location']; echo "	"; if(array_key_exists('title',$lkp)) echo $lkp['title']; echo "	"; if(array_key_exists('wpcf-location-timing',$lkp)) echo "".$lkp['wpcf-location-timing']." "; if(array_key_exists('wpcf-location-address',$lkp)) echo $lkp['wpcf-location-address']; echo "	"; if(array_key_exists('id',$lkp)) echo "View"; echo "

"; } function adminViewLocation() { global $cxn; global $m; if(array_key_exists('id',$_REQUEST)) { $sql="select id, post_title title, post_name location, post_content description from wp_posts where post_type='location' and id=".dbEscape($cxn,$_REQUEST['id']); $locations=loadTable($cxn,$sql); foreach($locations as $lkp) { $sql="select * from wp_postmeta where post_id=".$lkp['id']; $meta=loadTable($cxn,$sql); foreach($meta as $m) $lkp[$m['meta_key']]=$m['meta_value']; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

Location	"; if(array_key_exists('location',$lkp)) echo $lkp['location']; echo "
Title	"; if(array_key_exists('title',$lkp)) echo $lkp['title']; echo "
Timing	"; if(array_key_exists('wpcf-location-timing',$lkp)) echo $lkp['wpcf-location-timing']; echo "
Address	"; if(array_key_exists('wpcf-location-address',$lkp)) echo $lkp['wpcf-location-address']; echo "
Map	"; print_r($lkp['wpcf-add-real-google-map']); echo "
Description	"; $description=substr($lkp['description'],0,strpos($lkp['description'],"",$description); print_r($description); echo "

"; } } else { echo "Location Not Found"; } } function adminAddLocation() { if(array_key_exists('address',$_REQUEST)); echo "

Add Location

"; } function displayUsers() { global $tblUser; global $isStaff; if($isStaff==0) { echo "Sorry - your user account does not have access to this area."; return 0; } echo "

User List

"; echo ""; $sort=['family_name'=>1,'given_name'=>1,'email'=>1]; $tbl=$tblUser->find([],['sort'=>$sort]); foreach($tbl as $rec) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

Picture	Name	Email	Roles	Operation
	".$rec['name']."	".$rec['email']."	"; if(array_key_exists("role",$rec)) { foreach($rec['role'] as $role=>$ck) { if($ck==1) echo $role." "; } } echo "	"; echo "Edit User"; echo "

"; } function processLoginSessions() # No longer used { global $tblSess; global $tblUser; $tbl=$tblSess->find(['user'=>['$exists'=>1]]); foreach($tbl as $rec) { $cnt=-1; if(array_key_exists('user',$rec)) { if(array_key_exists('id',$rec['user'])) { $id=$rec['user']['id']; $cnt=$tblUser->count(['id'=>$id]); if($cnt==0) { $tblUser->insertOne($rec['user']); } } } } } function displayLoginSessions() { global $tblSess; global $tblUser; global $isStaff; if($isStaff==0) { echo "Sorry - your user account does not have access to this area."; return 0; } echo "

User List

"; echo ""; $sort=['family_name'=>1,'given_name'=>1,'email'=>1]; $tbl=$tblSess->find([],['sort'=>$sort]); foreach($tbl as $rec) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

Picture	id	Name	Email	Roles	Operation
	".$rec['id']."	".$rec['name']."	".$rec['email']."	"; if(array_key_exists("role",$rec)) { foreach($rec['role'] as $role) { echo $role." "; } } echo "	"; echo "Edit User"; echo "

"; } function editUser() { global $tblUser; global $isStaff; if($isStaff==0) { echo "Sorry - your user account does not have access to this area."; return 0; } $id=-1; if(array_key_exists('id',$_REQUEST)) $id=$_REQUEST['id']; $filter=['id'=>$id]; echo "

Edit User

"; $cnt=$tblUser->count($filter); if($cnt>0) { if(array_key_exists("operation",$_REQUEST)) { if($_REQUEST['operation']=="staff") { $op=['$set'=>["role.staff"=>1]]; $ck=$tblUser->updateOne($filter,$op); } if($_REQUEST['operation']=="removestaff") { $op=['$unset'=>["role.staff"=>0]]; $ck=$tblUser->updateOne($filter,$op); } } $rec=$tblUser->findOne($filter); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

id:	".$rec['id']."
Verified Email:	".$rec['verified_email']."
Picture:
Given Name:	".$rec['given_name']."
Family Name:	".$rec['family_name']."
Name:	".$rec['name']."
Roles:	"; $staff=0; if(array_key_exists("role",$rec)) { foreach($rec['role'] as $role=>$val) { echo $role." "; } if (array_key_exists('staff',$rec['role'])) { $staff=$rec['role']['staff']; } } echo "
Operations:	"; if($staff==0) echo "Add Staff Role "; if($staff==1) echo "Remove Staff Role "; echo "
Email:	".$rec['email']."

"; } else { echo "Could not find user"; } } ?>