This reply has been marked as private.
This reply has been marked as private.
Hi,
I want to get the information stored in wp_bp_activity_meta Using Quiz id and User ID https://prnt.sc/kaovkg
How to get it
I need Quiz Start and Ending Time with full and obtained marks
1) So i got Quiz Start and Ending Time from this table https://prnt.sc/kbbi8t
SELECT * FROM wp_bp_activity
WHERE user_id
= 130 AND secondary_item_id
= 15712
2) I got the Quiz Questions and Full marks from this table "http://prntscr.com/kbbj4i"
3) Now i just need obtained Marks So as Vibe said "Obtained Marks with Percentage and Many other details are avalible in wp_bp_activity_meta Table" https://prnt.sc/kaovkg
But the Problem is just like i got the information using user id and Quiz id from First two tables, I don't know how to get the Obtained marks or other information from wp_bp_activity_meta
This reply has been marked as private.