Closed emasters closed 6 years ago
https://github.com/CCALI/caw/blob/7c3d11777d9d8948ba3e0eb4d27dfa3b7d060743/includes/question-list-public.php#L23
better query is select page.pid,people.uid,page.data, people.profile from page, people where page.data like '%public":true%' and page.uid = people.uid
select page.pid,people.uid,page.data, people.profile from page, people where page.data like '%public":true%' and page.uid = people.uid
Code following needs to be reviewed also.
https://github.com/CCALI/caw/blob/7c3d11777d9d8948ba3e0eb4d27dfa3b7d060743/includes/question-list-public.php#L23
better query is
select page.pid,people.uid,page.data, people.profile from page, people where page.data like '%public":true%' and page.uid = people.uidCode following needs to be reviewed also.